using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace PCMS.Pages
{
	/// <summary>
	/// Summary description for Listall.
	/// </summary>
	public class SearchResults: System.Web.UI.Page
	{
		protected System.Data.SqlClient.SqlConnection listallSQL;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.HyperLink HyperLink3;
		protected System.Web.UI.WebControls.HyperLink HyperLink2;
		protected System.Web.UI.WebControls.LinkButton LinkButton1;
		protected System.Web.UI.WebControls.HyperLink HyperLink4;
		protected System.Web.UI.WebControls.DataGrid dgList;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			try
			{
				BindDataGrid();
			}
			catch (Exception ex)
			{
				Response.Redirect("Error.aspx?Error=" + ex);
			}
		
		}

		public void BindDataGrid()
		{
			string strQuery="Select * From PCMTable where";
			if(Int32.Parse(Request.QueryString["searchType"])==0)
				strQuery+=" Name Like '%"+ Request.QueryString["searchString"] + "%'";
			else
			{
				strQuery+=" Mobile like '%"+ Request.QueryString["searchString"] + "%'";
				strQuery+="OR Home_Phone like '%"+ Request.QueryString["searchString"] + "%'";
				strQuery+="OR Office_Phone like '%"+ Request.QueryString["searchString"] + "%'";
			}
			//listallSQL.Open();

			SqlCommand sqlCmd=new SqlCommand(strQuery,listallSQL);
			SqlDataAdapter sda=new SqlDataAdapter(sqlCmd);
			DataSet ds=new DataSet();
			sda.Fill(ds);
			dgList.DataSource=ds;
			dgList.DataBind();
			dgList.ControlStyle.Height=25;
			dgList.ItemStyle.Height=25;
			listallSQL.Close();
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.listallSQL = new System.Data.SqlClient.SqlConnection();
			this.dgList.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dgList_PageIndexChanged);
			// 
			// listallSQL
			// 
			this.listallSQL.ConnectionString = "data source=AV;initial catalog=PCM;integrated security=SSPI;persist security info" +
				"=False;workstation id=AV;packet size=4096";
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void dgList_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			dgList.CurrentPageIndex=e.NewPageIndex;
			BindDataGrid();
		}
	}
}