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;
}
