protected void btninsert_Click(object sender, EventArgs e) { Hashtable data = new Hashtable(); data.Add("cmpname", txtcmpname.Text); data.Add("adrs", txtadrs.Text); data.Add("phoneno", txtphoneno.Text); data.Add("emailid", txtemailid.Text ); data.Add("servingarea", txtservingarea.Text); data.Add("p1name", txtname1.Text); data.Add("p1phoneno",txtp1.Text ); data.Add("p1desc",txtdesc1.Text); data.Add("p2name", txtname2.Text); if (txtname2.Text != "") { data.Add("p2phoneno", txtp2.Text); } data.Add("p2desc", txtdesc2.Text); data.Add("p3name", txtname3.Text); if (txtname3.Text != "") { data.Add("p3phoneno", txtp3 .Text); } data.Add("p3desc", txtdesc3.Text); int id; bll inscmd = new bll(); id=inscmd.ins3vendordet(data); lblretvendorid.Text = "Third Party Vendor Details Inserted & Vendor ID is" + id.ToString(); }
protected void btnupdate_Click(object sender, EventArgs e) { Hashtable data = new Hashtable(); data.Add("cmpname",txtcmpname.Text ); data.Add("vendorid", txtvendorid.Text); data.Add("adrs", txtadrs.Text); data.Add("phoneno", txtphoneno.Text); data.Add("emailid", txtemailid.Text); data.Add("servingarea", txtservingarea.Text); data.Add("p1name", txtname1.Text); data.Add("p1phoneno", txtphoneno1.Text); data.Add("p1desc", txtdesc1.Text); data.Add("p2name", txtname2.Text); if (txtname2.Text != "") { data.Add("p2phoneno", txtphoneno2.Text); } data.Add("p2desc", txtdesc2.Text); data.Add("p3name", txtname3.Text); if (txtname3.Text != "") { data.Add("p3phoneno", txtphoneno3.Text); } data.Add("p3desc", txtdesc3.Text); bll upven = new bll(); upven.up3vendor(data); lblupvendor3.Text = "Details Successfully Updated"; }
protected void Page_Load(object sender, EventArgs e) { //string str; //str = Session["id"].ToString(); int id = Convert.ToInt32(Session["id"]); bll selview = new bll(); Hashtable data = new Hashtable(); data = selview.sel3vendorbyid(id); txtvendorid.Text = data["vendorid"].ToString(); txtcmpname.Text = data["cmpname"].ToString(); txtadrs.Text = data["adrs"].ToString(); txtphoneno.Text = data["phoneno"].ToString(); txtemailid.Text = data["emailid"].ToString(); txtservingarea.Text = data["servingarea"].ToString(); txtname1.Text = data["p1name"].ToString(); txtphoneno1.Text = data["p1phoneno"].ToString(); txtdesc1.Text = data["p1desc"].ToString(); txtname2.Text = data["p2name"].ToString(); if ((data["p2name"].ToString()) != "") { txtphoneno2.Text = data["p2phoneno"].ToString(); } txtdesc2.Text = data["p2desc"].ToString(); txtname3.Text = data["p3name"].ToString(); if ((data["p3name"].ToString()) != "") { txtphoneno3.Text = data["p3phoneno"].ToString(); } txtdesc3.Text = data["p3desc"].ToString(); }
protected void Button1_Click1(object sender, EventArgs e) { int id = Convert.ToInt32(txtticketid.Text); Hashtable data = new Hashtable(); bll compview = new bll(); data = compview.selcomp(id); txtticket_id .Text = data["ticket_id"].ToString(); txtclientname.Text = data["client_id"].ToString(); txtcustomername.Text = data["cc_id"].ToString(); txtempreg.Text = data["emp_reg"].ToString(); txtdoc.Text = data["docomplain"].ToString(); //txtempassigned.Text = data["emp_assess"].ToString(); txtprobtype.Text = data["probtype"].ToString(); txtprobsubtype.Text = data["probsubtype"].ToString(); txtpriority.Text = data["priority"].ToString(); cbstatus.SelectedItem.Text = data["ticket_status"].ToString(); txtdorepair.Text = data["dorepair"].ToString(); txtxtaskdesc.Text = data["taskdesc"].ToString(); txtothers.Text = data["others"].ToString(); txtassetid.Text = data["assetid"].ToString(); commaDelimited = data["fullstring"].ToString(); string[] year = commaDelimited.Split(new char[] { ',' }); foreach (string month in year) { d[k] = month; k++; } TabContainer1.Visible = true; }
protected void btndelete_Click(object sender, EventArgs e) { string str; str=Request.QueryString["EQid"]; int id = Convert.ToInt32(str); bll cldelasset = new bll(); cldelasset.delasset(id); }
protected void btndelete_Click(object sender, EventArgs e) { int id; id = Convert.ToInt32(cbcontrolname.SelectedValue); bll cldel = new bll(); cldel.delcontrol(id); Response.Redirect("updcontrols.aspx"); }
protected void btndel_Click(object sender, EventArgs e) { int id = Convert.ToInt32(ComboBox1.SelectedValue); bll cldelete = new bll(); cldelete.delclient(id); lbldelclient.Text = "Details Successfully Deleted"; Response.Redirect("updclietndet.aspx"); }
protected void btndel_Click(object sender, EventArgs e) { string str; str = Request.QueryString["ccid"]; int id = Convert.ToInt32(str); bll cldelclientcont = new bll(); cldelclientcont.delclientcontact(id); Response.Redirect("updclientcont.aspx"); }
protected void btndel_Click(object sender, EventArgs e) { string str; str = Request.QueryString["vdid"]; int id = Convert.ToInt32(str); bll cldelthird = new bll(); cldelthird.delthirdvendor(id); Response.Redirect("vendor3up.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { string str5; str5 = Request.QueryString["eqpid"]; int id = Convert.ToInt32(str5); bll calamcnotify = new bll(); calamcnotify.amcnotify(id); Label7.Text = "Successfully Notified"; }
protected void btnsignin_Click(object sender, EventArgs e) { Session["uname"] = txtusername.Text; string pwd = txtpassword.Text; string uname = Session["uname"].ToString(); Hashtable data = new Hashtable(); data.Add("username", uname); data.Add("password", pwd); data.Add ("length",pwd .Length ); Hashtable retval1=new Hashtable (); bll clloginfun = new bll(); retval1 = clloginfun.sellogin(data); Session["empid"] = retval1["emp_id"].ToString(); if (Convert.ToInt32(retval1["emp_id"]) != 0) { Hashtable data1 = new Hashtable(); if (retval1["user"].ToString() == "employee") { bll selempdet = new bll(); data1 = selempdet.selempdet(Convert.ToInt32(retval1["emp_id"])); Session["designation"] = data1["designation"].ToString(); Session["department"] = data1["dept"].ToString(); Session["empid"] = data1["empid"].ToString(); if (retval1["securityques"].ToString() == "" & retval1["securityans"].ToString() == "") { Response.Redirect("firsttimelogin.aspx"); } else { Response.Redirect("viewprofile.aspx"); } } else { Response.Redirect("clienthome.aspx"); } } else if (Convert.ToInt32(retval1["emp_id"]) == 0) { lblerrmsg.Visible = true; } }
protected void btnupdate_Click(object sender, EventArgs e) { Hashtable data = new Hashtable(); data.Add("clientid", cbclientid .SelectedValue); data.Add("eqpid", txtassetid.Text); if (cbtype.SelectedItem.Text == "Other") { data.Add("eqptype", txttype.Text); } else { data.Add("eqptype", cbtype.SelectedItem.Text); } if (cbsubtype.SelectedItem.Text == "Other") { data.Add("eqpsubtype", txtsubtype.Text); } else { data.Add("eqpsubtype", cbsubtype.SelectedItem.Text); } data.Add("mfg", txtmfg.Text); data.Add("domfg", txtdofmfg.Text); data.Add("doinst", txtdoinst.Text); data.Add("lenwarranty", txtlenwarranty.Text); data.Add("extdwarranty", txtextwarranty.Text); data.Add("make", txtmake.Text); data.Add("model", txtmodel.Text); data.Add("serial", txtserial.Text); data.Add("tonnage", txttonnage.Text); data.Add("age", txtage.Text); data.Add("bldgno", txtbldgno.Text); data.Add("blockno", txtblockno.Text); data.Add("servingarea", txtservingarea.Text); data.Add("bldgname", txtbldgname.Text); data.Add("wind", txtwing.Text); data.Add("aptno", txtaptno.Text); data.Add("floor", txtfloor.Text); data.Add("zone", txtzone.Text); data.Add("roomtype", txtroomtype.Text); data.Add("roomdetails", txtroomdetails.Text); data.Add("optcrt", txtoptcrt.Text); data.Add("optvol", txtoptvol.Text); data.Add("amcperiod", txtamcperiod.Text); data.Add("otherdetails", txtotherdetails.Text); bll clickupd = new bll(); clickupd.eqpupd (data); lblupdmes.Text = "Details Succesfully Updated"; }
protected void btnupdate_Click(object sender, EventArgs e) { Hashtable data = new Hashtable(); data.Add("id", cbcontrolname.SelectedValue); data.Add("value", txtdefvalues.Text); data.Add("dbname", txtmethodname.Text); data.Add("label", txtlabelname.Text); data.Add("description", txtdesc.Text); data.Add("control", cbupdcontrols.SelectedValue); bll clupd = new bll(); clupd.updcontrol(data); lblretupdate.Text = "Details Successfully Updated"; }
protected void Page_Load(object sender, EventArgs e) { string str4; str4 = Request.QueryString["mfg"]; string mfg = (str4).ToString(); string str5; str5 = Request.QueryString["clientid"]; int id = Convert.ToInt32 ( str5 ); int v; bll man = new bll(); v=man.vendorid(mfg); bll clsel = new bll(); Hashtable insertdata = new Hashtable(); insertdata = clsel.selclientdet(id); txtorgnameup.Text = insertdata["org_name"].ToString(); txtadrsup.Text = insertdata["address"].ToString(); txtemaildidup.Text = insertdata["emailid"].ToString(); txtorgtypeup.Text = insertdata["orgtype"].ToString(); txtphonenoup.Text = insertdata["phoneno"].ToString(); bll selview = new bll(); Hashtable data = new Hashtable(); data = selview.sel3vendorbyid(v); txtvendorid.Text = data["vendorid"].ToString(); txtcmpname.Text = data["cmpname"].ToString(); txtadrs.Text = data["adrs"].ToString(); txtphoneno.Text = data["phoneno"].ToString(); txtemailid.Text = data["emailid"].ToString(); txtservingarea.Text = data["servingarea"].ToString(); txtname1.Text = data["p1name"].ToString(); txtphoneno1.Text = data["p1phoneno"].ToString(); txtdesc1.Text = data["p1desc"].ToString(); txtname2.Text = data["p2name"].ToString(); if ((data["p2name"].ToString()) != "") { txtphoneno2.Text = data["p2phoneno"].ToString(); } txtdesc2.Text = data["p2desc"].ToString(); txtname3.Text = data["p3name"].ToString(); if ((data["p3name"].ToString()) != "") { txtphoneno3.Text = data["p3phoneno"].ToString(); } txtdesc3.Text = data["p3desc"].ToString(); TabContainer1.Visible = true; }
protected void ComboBox1_SelectedIndexChanged(object sender, EventArgs e) { int id1 = Convert.ToInt32(ComboBox1.SelectedValue); bll clsel = new bll(); Hashtable insertdata = new Hashtable(); insertdata = clsel.selclientdet(id1); txtorgnameup.Text = insertdata["org_name"].ToString(); txtadrsup.Text = insertdata["address"].ToString(); txtemaildidup.Text = insertdata["emailid"].ToString(); txtorgtypeup.Text = insertdata["orgtype"].ToString(); txtphonenoup.Text = insertdata["phoneno"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(Session["id"]); Hashtable data = new Hashtable(); bll selempdet = new bll(); data = selempdet.selempdet(id); lblempid.Text = data["empid"].ToString(); lblname.Text = data["name"].ToString(); lbldob.Text = data["dob"].ToString(); lbladdress.Text = data["adrs"].ToString(); lblphoneno.Text = data["phoneno"].ToString(); lblemailid.Text = data["emailid"].ToString(); }
protected void cbcontrolname_SelectedIndexChanged(object sender, EventArgs e) { int id; id = Convert .ToInt32(cbcontrolname .SelectedValue); Hashtable data=new Hashtable (); bll clupdate = new bll(); data=clupdate.selcontrol (id); txtlabelname.Text = data["label"].ToString(); txtdefvalues.Text = data["value"].ToString(); txtmethodname.Text = data["dbname"].ToString(); txtdesc.Text = data["description"].ToString(); cbupdcontrols.SelectedValue = data["control"].ToString(); }
protected void btnupdate_Click(object sender, EventArgs e) { Hashtable insertdata = new Hashtable(); //insertdata.Add("client_det", txtclientid1 .Text); insertdata.Add("org_name", txtorgnameup.Text); insertdata.Add("address", txtadrsup.Text); insertdata.Add("phoneno", txtphonenoup.Text); insertdata.Add("emailid", txtemaildidup.Text); insertdata.Add("orgtype", txtorgtypeup.Text); insertdata.Add("client_id", ComboBox1.SelectedValue); bll clupdclient = new bll(); clupdclient.upclientdet(insertdata); lblupclient.Text = "Details Successfully Updated"; }
protected void btninsert_Click(object sender, EventArgs e) { Hashtable data = new Hashtable(); data.Add ("client_id",cbclientnme .SelectedValue ); data.Add ("control",Label5 .Text ); data.Add ("value",txtdefvalues .Text ); data.Add ("dbname",txtmethodname .Text ); data.Add ("label",txtlabelname .Text ); data.Add ("description",txtdesc.Text ); int id; bll clins = new bll(); id= clins.inscontrol(data); lblretid.Text = "Control Details Successfully Inserted & Control ID is " + id.ToString(); }
protected void btninsert_Click(object sender, EventArgs e) { Hashtable data=new Hashtable (); lblmes .Text ="all"; string pwd = txtpwd.Text; data.Add("t", lblmes.Text); data.Add("emp_id", Convert .ToInt32 (Session ["empid"])); data .Add ("securityques",cbsecques .SelectedItem .Text ); data.Add ("password",txtpwd .Text ); data.Add("length", pwd.Length); data .Add ("securityans",txtsecans .Text ); bll clreg = new bll(); clreg.registration(data); lblmes.Text = "Account Details Saved"; }
protected void btninsclientdetails_Click(object sender, EventArgs e) { Hashtable insertdata = new Hashtable(); //insertdata.Add("client_det", txtclientid1 .Text); insertdata.Add("org_name", txtorgname.Text); insertdata.Add("address", txtadrs.Text); insertdata.Add("phoneno", txtphoneno.Text); insertdata.Add("emailid", txtemaildid.Text); insertdata.Add("orgtype", txtorgtype.Text); int id; bll clickins = new bll(); id=clickins.clientdetinfo(insertdata); lblretclientid.Text = "Client Details Inserted & Client ID is " + id.ToString(); }
protected void btninsert_Click(object sender, EventArgs e) { Hashtable data = new Hashtable(); data.Add("client_id", cbclientname.SelectedValue); data.Add("asset_id", cbaptno.SelectedValue); data.Add("name", txtname.Text); data.Add("phoneno", txtphoneno.Text); data.Add("emailid", txtemailid.Text ); data.Add("desg", txtdesg.Text); data.Add("desc", txtdesc.Text); int id; bll insclientcont = new bll(); id=insclientcont.insclientcontactdet(data); lblretccid.Text = "Client Contact Details Inserted & Client Contact ID is " + id.ToString(); }
protected void btnupdate_Click(object sender, EventArgs e) { Hashtable data = new Hashtable(); // data.Add("client_id", cbclientname.SelectedValue); data.Add("cc_id", txtclientcont.Text); // data.Add("asset_id",txtaptno .Text ); data.Add("name", txtname.Text); data.Add("phoneno", txtphoneno.Text); data.Add("emailid", txtemailid.Text); data.Add("desg", txtdesg.Text); data.Add("desc", txtdesc.Text); bll updclientcont = new bll(); updclientcont.updclientcontbyid (data); lblclientupd.Text = "Details Successfully Updated"; }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(Session["empid"]); Hashtable data = new Hashtable(); bll selempdet = new bll(); data = selempdet.selempdet(id); if (data["name"].ToString() == "") { Response.Redirect("CmsHome1.aspx"); } lblempid .Text = data["empid"].ToString(); lblname .Text = data["name"].ToString(); lbldob .Text = data["dob"].ToString(); lbladdress .Text = data["adrs"].ToString(); lblphoneno.Text = data["phoneno"].ToString(); lblemailid .Text = data["emailid"].ToString(); lbldesg .Text = data["designation"].ToString(); lbldept .Text = data["dept"].ToString(); if (data["designation"].ToString() != "Head") { upshift.Visible = true; if ((data["headname"].ToString()) != "") { lblheadname.Text = data["headname"].ToString(); } else { lblheadname.Text = "No Head Assigned!"; } } //{ // //cbheadname.SelectedItem.Text = data["headname"].ToString(); // cbheadname.SelectedValue.Replace(data["headname"].ToString(), data["headname"].ToString()); //} else { uphead . Visible = true; //lbreportingemp .Text = //cbheadname.Enabled = false; } }
protected void btnempdetails_Click(object sender, EventArgs e) { Hashtable data = new Hashtable(); data.Add("name", txtname.Text); data.Add("dob", txtdob.Text); data.Add("adrs", txtadrs.Text); data.Add("phoneno", txtphoneno.Text); data.Add("emailid", txtemailid.Text); data.Add("designation", cbdesg.SelectedItem.Text); data.Add("dept", cbdep.SelectedItem.Text); if (cbdesg.SelectedItem.Text != "Head") { if (lblheadname.Visible == false) { data.Add("headname", ""); data.Add("headid", ""); } else { data.Add("headname", cbheadname.SelectedItem.Text); data.Add("headid", cbheadname.SelectedValue); } } data.Add("desc", txtdesc.Text); bll insempdet = new bll(); int j; j=insempdet.insempdet(data); for (int i = 0; i < lbempunder.Items.Count; i++) { Hashtable datahead = new Hashtable(); ListItem li = new ListItem(); datahead.Add("empheadchange", lbempunder.Items[i].Value); datahead.Add("empheadname", txtname.Text); datahead.Add("empheadid", j); bll emphead = new bll(); emphead.uphead(datahead); } lblretemp.Text = "Employee Details Inserted & Employee ID is " + j.ToString(); }
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 Button1_Click(object sender, EventArgs e) { string str; str = Request.QueryString["vdid"]; int id = Convert.ToInt32(str); Hashtable data2 = new Hashtable(); data2.Add("ticket_id",Session["compid"]); data2.Add("desc", txttaskdesc.Text); data2.Add("pk", id); data2.Add("dbname", "vendor"); bll helptakt = new bll(); helptakt.inshelptas(data2); Hashtable data4= new Hashtable(); data4.Add("ticket_id",Session["compid"]); data4.Add("ticket_status","Escalate to Help Desk"); bll comphelp = new bll(); comphelp.upcomphelp(data4); }
protected void btnupd_Click(object sender, EventArgs e) { Hashtable data = new Hashtable(); data.Add("empid", txtempid.Text); data.Add("name", txtname.Text); data.Add("dob", txtdob.Text); data.Add("adrs", txtadrs.Text); data.Add("phoneno", txtphoneno.Text); data.Add("emailid", txtemailid.Text); data.Add("designation", cbdesg.SelectedItem.Text); data.Add("dept", cbdep.SelectedItem.Text); if (cbdesg.SelectedItem.Text != "Head") { if (lblheadname.Visible == false) { data.Add("headname", ""); data.Add("headid", ""); } else { data.Add("headname", cbheadname.SelectedItem.Text); data.Add("headid", cbheadname.SelectedValue); } } data.Add("desc", txtdesc.Text); bll upemp = new bll(); upemp.upemp(data); for (int i = 0; i < lbempunder.Items.Count; i++) { Hashtable datahead = new Hashtable(); ListItem li = new ListItem(); datahead.Add("empheadchange", lbempunder.Items[i].Value); datahead.Add("empheadname", txtname.Text); datahead.Add("empheadid", txtempid.Text); bll emphead = new bll(); emphead.uphead(datahead); } }
protected void btnsubmit_Click(object sender, EventArgs e) { Hashtable data = new Hashtable(); data.Add("username", txtuname.Text); data.Add("securityques", cbsecques.SelectedItem.Text); data.Add("securityans", txtsecans.Text); bll clfrg = new bll(); int id; id = clfrg.forgotpwd(data); if (id != 0) { lblresult.Text = "A mail with your account details has been sent to your email id"; } else { lblresult.Text = "Please enter valid security question and answer"; } }
protected void LinkButton1_Click1(object sender, EventArgs e) { string str; str = Request.QueryString["ccid"]; int id = Convert.ToInt32(str); Hashtable data = new Hashtable(); bll selclientcont = new bll(); data = selclientcont.selclientcontbyid(id); txtclientcont.Text = data["cc_id"].ToString(); txtaptno.Text = data["asset_id"].ToString(); txtname.Text = data["name"].ToString(); txtphoneno.Text = data["phoneno"].ToString(); txtemailid.Text = data["emailid"].ToString(); txtdesg.Text = data["desg"].ToString(); txtdesc.Text = data["desc"].ToString(); UpdatePanel2.Visible = true; btnupdate.Visible = true; btndel.Visible = true; btndel0.Visible = true; }