protected void btnsearch_Click(object sender, EventArgs e) { bll clconn = new bll(); DataTable dt = new DataTable(); dt = clconn.connection(Session["query"].ToString()); if (dt != null) { GridView1.DataSource = dt; GridView1.DataBind(); } else { lblresult.Text = "There is no such complain registered."; } UpdatePanel2.Visible = false; }
protected void Page_Load(object sender, EventArgs e) { try { if (Session ["designation"]=="as") { } } catch{ Response .Redirect ("CmsHome1.aspx"); } if (Session["designation"].ToString() == "Head") { upheadshift.Visible = true; Session["query"] = "select ticket_id, taskdesc, client_id,emp_technician,emp_shift,docomplain,probtype,priority,ticket_status from complain where emp_head='" + Session["empid"] + "' AND ticket_status='Escalate to Head'"; bll clconn = new bll(); DataTable dt = new DataTable(); dt = clconn.connection(Session["query"].ToString()); GridView3.DataSource = dt; GridView3.DataBind(); lbnopart.Visible = true; } else if (Session["designation"].ToString() == "Shift engg") { upheadshift.Visible = true; Session["query"] = "select ticket_id, taskdesc, client_id,emp_technician,emp_shift,docomplain,probtype,priority,ticket_status from complain where emp_shift='" + Session["empid"] + "' AND ( ticket_status='Parts Received' OR ticket_status='Escalate to shift engineer' OR ticket_status='Submit for client approval' OR ticket_status='Submit to store' OR ticket_status='AMC vendor notified')"; bll clconn = new bll(); DataTable dt = new DataTable(); dt = clconn.connection(Session["query"].ToString()); GridView3.DataSource = dt; GridView3.DataBind(); rbnopart.Enabled = true; rbyespart.Enabled = true; } else if (Session["designation"].ToString() == "Help desk personnel") { uphelp.Visible = true; if (IsPostBack) { //string str1; //str1 = Request.QueryString["ticketid"]; //int id2 = Convert.ToInt32(str1); } bll amcnotification = new bll(); DataTable dt; dt = amcnotification.amcnotification(); GridView5.DataSource = dt; GridView5.DataBind(); bll amc = new bll(); amc.notifiedno(); } }
protected void Button1_Click(object sender, EventArgs e) { if (txtcompreg.Text != "") { string str1 = Session["query"].ToString(); DateTime date; date=Convert.ToDateTime (txtcompreg.Text ); str1 += "docomplain BETWEEN '" + txtcompreg .Text + "' AND '"+txtcompreg.Text+" 23:59:59.997' "; Session["query"] = str1; } //GridView1.Visible = true; bll clconn = new bll(); DataTable dt = new DataTable(); dt=clconn.connection(Session["query"].ToString()); GridView2.DataSource = dt; GridView2.DataBind(); btnexport.Visible = true; btnpdf.Visible = true; }