protected void btnupdate_Click(object sender, EventArgs e) { transportermaster objtransporter = new transportermaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtransporter.transportermaster_SRNO = -1; objtransporter.transportermaster_TRANSPORTERNAME = txttransportername.Text.Trim().ToString(); objtransporter.transportermaster_TRANSPORTERCODE = txttransportercode.Text.Trim().ToString(); if (rdlocal.Checked == true) { objtransporter.transportermaster_TRANTYPE = "LOCAL"; objtransporter.transportermaster_TRANTYPECODE = 1; } else { objtransporter.transportermaster_TRANTYPE = "REMOTE"; objtransporter.transportermaster_TRANTYPECODE = 2; } objtransporter.transportermaster_MOBILENO = txtphone.Text.Trim().ToString(); objtransporter.transportermaster_FAX = txtfax.Text.Trim().ToString(); objtransporter.transportermaster_EMAILID = txtemail.Text.Trim().ToString(); objtransporter.transportermaster_PANNO = txtpanno.Text.Trim().ToString(); objtransporter.transportermaster_SERVICETAXNO = txtservicetaxno.Text.Trim().ToString(); objtransporter.transportermaster_ADDRESS = txtaddress.Text.Trim().ToString(); objtransporter.transportermaster_STATUS = General.Parse<int>(ddlstatus.SelectedValue.Trim().ToString()); string condition = "SRNO=" + ViewState["TRANSPORTERID"].ToString().Trim(); if (objtransporter.Insert(false, "transportermaster", condition)) { string sqltax = "SELECT SRNO,TAXNAME,TAXUNIT,TAXVALUE FROM TAXMASTER TM WHERE TM.STATUS=0 AND TM.TAXNAME='SERVICE TAX'"; Handler hdntax = new Handler(); DataTable dttax = hdntax.GetTable(sqltax); string sqlchecktax = "SELECT SRNO,STATUS FROM TAXATIONMASTER TM WHERE TAXPARTYTYPE='TRANSPORTER' AND TAXPARTYID="+ViewState["TRANSPORTERID"].ToString().Trim()+" AND TAXID="+dttax.Rows[0]["SRNO"].ToString(); Handler hdntax1 = new Handler(); DataTable dtchecktax = hdntax1.GetTable(sqlchecktax); if(dtchecktax.Rows.Count > 0 && dtchecktax.Rows[0][0].ToString() != string.Empty) { if (rdserviceapplicable.Checked == true && dtchecktax.Rows[0][1].ToString() == "1") { taxationmaster objtax = new taxationmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtax.taxationmaster_SRNO = -1; objtax.taxationmaster_TAXPARTYID =-1; objtax.taxationmaster_TAXID =-1; objtax.taxationmaster_TAXVALUE = -1; objtax.taxationmaster_STATUS = 0; string taxcondition="SRNO="+dtchecktax.Rows[0][0].ToString(); if (objtax.Insert(false, "taxationmaster",taxcondition)) { } } else if (rdservicenotapplicable.Checked == true && dtchecktax.Rows[0][1].ToString() == "0") { taxationmaster objtax = new taxationmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtax.taxationmaster_SRNO = -1; objtax.taxationmaster_TAXPARTYID =-1; objtax.taxationmaster_TAXID =-1; objtax.taxationmaster_TAXVALUE = -1; objtax.taxationmaster_STATUS =1; string taxcondition="SRNO="+dtchecktax.Rows[0][0].ToString(); if (objtax.Insert(false, "taxationmaster",taxcondition)) { } } } if (memberrepeater.Items.Count > 0) { int membercount = ((DataTable)ViewState["personrecord"]).Rows.Count; for (int i = 0; i < memberrepeater.Items.Count; i++) { TextBox name = (TextBox)memberrepeater.Items[i].FindControl("txtpersonname"); TextBox phone = (TextBox)memberrepeater.Items[i].FindControl("txtperphone"); TextBox email = (TextBox)memberrepeater.Items[i].FindControl("txtperemailid"); TextBox mobile = (TextBox)memberrepeater.Items[i].FindControl("txtpermobile"); if(i<membercount) { personalmaster objpersonal = new personalmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonal.personalmaster_SRNO = -1; objpersonal.personalmaster_PERSONNAME = name.Text.ToString().Trim(); objpersonal.personalmaster_EMAILID = email.Text.ToString().Trim(); objpersonal.personalmaster_PHONENO = phone.Text.ToString().Trim(); objpersonal.personalmaster_MOBILE = mobile.Text.ToString().Trim(); objpersonal.personalmaster_PERSONRELATIONID =-1; string taxcondition = "SRNO=" + ((DataTable)ViewState["personrecord"]).Rows[i]["SRNO"].ToString().Trim(); if (objpersonal.Insert(false, "personalmaster",taxcondition)) { } } else { personalmaster objpersonal = new personalmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonal.personalmaster_SRNO = -1; objpersonal.personalmaster_PERSONNAME = name.Text.ToString().Trim(); objpersonal.personalmaster_EMAILID = email.Text.ToString().Trim(); objpersonal.personalmaster_PHONENO = phone.Text.ToString().Trim(); objpersonal.personalmaster_MOBILE = mobile.Text.ToString().Trim(); objpersonal.personalmaster_PERSONRELATIONID = General.Parse<int>(ViewState["TRANSPORTERID"].ToString().Trim()); objpersonal.personalmaster_PERSONTYPE = "TRANSPORTER"; if (objpersonal.Insert(true, "personalmaster")) { } } } } MessageBox("Transporter Details Updated Successfully"); Response.Redirect("transporterlist.aspx?ID=1"); } }
protected void btnsubmit1_Click(object sender, EventArgs e) { contractmaster contract = new contractmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); contract.contractmaster_CONTRACTID = -1; contract.contractmaster_CONTRACTWITH = "CUSTOMER"; if(rdservicecontract.Checked == true) { contract.contractmaster_CONTRACTTYPE = "SERVICECONTRACT"; contract.contractmaster_CONTRACTTYPEID = 1; contract.contractmaster_SERVICECHARGE = General.Parse<double>(txtchargservice.Text.Trim().ToString()); } else if(rdtransportcontract.Checked == true) { contract.contractmaster_CONTRACTTYPE = "TRANSPORTCONTRACT"; contract.contractmaster_CONTRACTTYPEID = 2; contract.contractmaster_RATE = General.Parse<double>(txtrate.Text.Trim().ToString()); } contract.contractmaster_CONTRACTDATE = txtdate.Text.Trim().ToString(); contract.contractmaster_REFNO = txtrefno.Text.Trim().ToString(); contract.contractmaster_REFDATE = txtrefdate.Text.Trim().ToString(); contract.contractmaster_STARTDATE = txtcontractdate.Text.Trim().ToString(); contract.contractmaster_ENDDATE = txtexpirydate.Text.Trim().ToString(); contract.contractmaster_QUANTITY = General.Parse<double>(txtquantity.Text.Trim().ToString()); contract.contractmaster_QUANTITYPER = ddlquantitytype.SelectedItem.Text.ToString(); contract.contractmaster_PARTYID = General.Parse<int>(ddlparty.SelectedValue.Trim().ToString()); contract.contractmaster_PARTYCONTACTPERSONID = General.Parse<int>(ddlcontactperson.SelectedValue.Trim().ToString()); contract.contractmaster_CMPID = General.Parse<int>(Session["cmpid"].ToString()); contract.contractmaster_BRANCHID = General.Parse<int>(Session["branchid"].ToString()); contract.contractmaster_STATUS = 0; if (contract.Insert(true, "contractmaster")) { string sql = "SELECT MAX(CONTRACTID) FROM CONTRACTMASTER CM WHERE CM.STATUS=0 AND" + " CM.PARTYID=" + ddlparty.SelectedValue.Trim().ToString() + " AND CM.PARTYCONTACTPERSONID=" + ddlcontactperson.SelectedValue.Trim().ToString(); Handler hdn = new Handler(); DataTable dt = hdn.GetTable(sql); ViewState["contractid"] = dt.Rows[0][0].ToString().Trim(); string sqltax = "SELECT SRNO,TAXNAME,TAXUNIT,TAXVALUE FROM TAXMASTER TM WHERE TM.STATUS=0 AND TM.TAXNAME='SERVICE TAX'"; ; Handler hdntax = new Handler(); DataTable dttax = hdntax.GetTable(sqltax); taxationmaster objtax = new taxationmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtax.taxationmaster_SRNO = -1; objtax.taxationmaster_TAXPARTYTYPE = "CONTRACT"; objtax.taxationmaster_TAXPARTYID = General.Parse<int>(ViewState["contractid"].ToString()); objtax.taxationmaster_TAXID = General.Parse<int>(dttax.Rows[0]["SRNO"].ToString()); objtax.taxationmaster_TAXNAME = dttax.Rows[0]["TAXNAME"].ToString().Trim(); objtax.taxationmaster_TAXVALUE = General.Parse<double>(dttax.Rows[0]["TAXVALUE"].ToString().Trim()); objtax.taxationmaster_TAXUNIT = dttax.Rows[0]["TAXUNIT"].ToString().Trim(); objtax.taxationmaster_STATUS = 0; if (objtax.Insert(true, "taxationmaster")) { } } ScriptManager.RegisterStartupScript(this, this.GetType(), "msg1", "ShowDiv2();", true); }
protected void btnsubmit_Click(object sender, EventArgs e) { string partyid = string.Empty; string contactperson = string.Empty; partyid = ddlparty.SelectedValue.ToString(); quotationmaster objquotation = new quotationmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objquotation.quotationmaster_QUOTATIONID = -1; objquotation.quotationmaster_PARTYID=General.Parse<int>(partyid); objquotation.quotationmaster_PARTYTYPE = 1; objquotation.quotationmaster_CONTACTPERSON=General.Parse<int>(contactperson); objquotation.quotationmaster_DATE = txtdate.Text.Trim().ToString(); objquotation.quotationmaster_EXPIRYDATE = txtexpirydate.Text.Trim().ToString(); if (txtrefno.Text.Trim().ToString() != string.Empty) { objquotation.quotationmaster_REFNO = txtrefno.Text.Trim().ToString(); } objquotation.quotationmaster_COALCOST = General.Parse<double>(txtfinalcoalcost.Text.Trim().ToString()); objquotation.quotationmaster_TAXCOST = General.Parse<double>(txtfinaltax.Text.Trim().ToString()); objquotation.quotationmaster_TRANSPORTATIONCOST = General.Parse<double>(txttransportationcost.Text.Trim().ToString()); objquotation.quotationmaster_TOTALCOST = General.Parse<double>(txtfinalcoalcost.Text.Trim().ToString()); objquotation.quotationmaster_STATUS = 0; if (objquotation.Insert(true, "quotationmaster")) { string sqlmax = "SELECT MAX(QUOTATIONID) AS QUOTATIONID FROM QUOTATIONMASTER GM WHERE PARTYID=" + partyid; Handler hdnmax = new Handler(); DataTable dtmax = hdnmax.GetTable(sqlmax); quotationspecification objspecification = new quotationspecification(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objspecification.quotationspecification_SRNO = -1; objspecification.quotationspecification_QUOTATIONID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objspecification.quotationspecification_COALTYPE = ddlcoalgrade.SelectedItem.Text; objspecification.quotationspecification_COALTYPEID = General.Parse<int>(ddlcoalgrade.SelectedValue.ToString()); objspecification.quotationspecification_COALSOURCE = ddlcoalsource.SelectedItem.Text; objspecification.quotationspecification_COALSOURCEID = General.Parse<int>(ddlcoalsource.SelectedValue.ToString()); objspecification.quotationspecification_COALQUANTITY = General.Parse<double>(txtcoalquantity.Text.Trim().ToString()); objspecification.quotationspecification_COALRATE = General.Parse<double>(txtcoalrate.Text.Trim().ToString()); objspecification.quotationspecification_COALSIZEMIN = General.Parse<double>(txtcoalsizemin.Text.Trim().ToString()); objspecification.quotationspecification_COALSIZEMAX = General.Parse<double>(txtcoalsizemax.Text.Trim().ToString()); objspecification.quotationspecification_GCV = General.Parse<double>(txtgcv.Text.Trim().ToString()); objspecification.quotationspecification_GCVERROR = General.Parse<double>(txtgcv.Text.Trim().ToString()); objspecification.quotationspecification_MOISTURE = General.Parse<double>(txtmoisture.Text.Trim().ToString()); objspecification.quotationspecification_MOISTUREERROR = General.Parse<double>(txtmoistureerror.Text.Trim().ToString()); if (objspecification.Insert(true, "quotationspecification")) { } for (int t = 0; t < ((DataTable)Session["tax"]).Rows.Count; t++) { string sqltax = "SELECT SRNO,TAXNAME,TAXUNIT,TAXVALUE FROM TAXMASTER TM WHERE TM.STATUS=0 AND TM.TAXNAME='" + ((DataTable)Session["tax"]).Rows[t]["TAXNAME"].ToString().Trim() + "' AND TM.TAXVALUE=" + ((DataTable)Session["tax"]).Rows[t]["TAXVALUE"].ToString().Trim(); Handler hdntax = new Handler(); DataTable dttax = hdntax.GetTable(sqltax); taxationmaster objtax = new taxationmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtax.taxationmaster_SRNO = -1; objtax.taxationmaster_TAXPARTYTYPE = "QUOTATION"; objtax.taxationmaster_TAXPARTYID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objtax.taxationmaster_TAXID = General.Parse<int>(dttax.Rows[0]["SRNO"].ToString()); objtax.taxationmaster_TAXNAME = dttax.Rows[0]["TAXNAME"].ToString().Trim(); objtax.taxationmaster_TAXVALUE = General.Parse<double>(dttax.Rows[0]["TAXVALUE"].ToString().Trim()); objtax.taxationmaster_TAXUNIT = dttax.Rows[0]["TAXUNIT"].ToString().Trim(); objtax.taxationmaster_STATUS = 0; if (objtax.Insert(true, "taxationmaster")) { } } foreach (ListItem aListItem in chktermslist.Items) { if (aListItem.Selected) { termstable objterms = new termstable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objterms.termstable_SRNO = -1; objterms.termstable_STATUS = 0; objterms.termstable_PARTYTYPE = "QUOTATION"; objterms.termstable_PARTYID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objterms.termstable_TERMSID = General.Parse<int>(aListItem.Value.ToString().Trim()); objterms.termstable_TERMS = aListItem.Text.Trim().ToString(); objterms.termstable_TERMSVALUE =-1; if (objterms.Insert(true, "termstable")) { } } } } Response.Redirect("Quotationlist.aspx?ID=1"); }
protected void btnsubmit_Click(object sender, EventArgs e) { string sqlcheck = "SELECT RTRIM(SRNO) AS TRANSPORTERNO FROM TRANSPORTERMASTER TM WHERE TRANSPORTERCODE='" + txttransportercode.Text.Trim().ToString() + "'"; Handler hdncheck = new Handler(); DataTable dtcheck = hdncheck.GetTable(sqlcheck); if (dtcheck.Rows.Count == 0) { transportermaster objtransporter = new transportermaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtransporter.transportermaster_SRNO = -1; objtransporter.transportermaster_TRANSPORTERNAME = txttransportername.Text.Trim().ToString(); objtransporter.transportermaster_TRANSPORTERCODE = txttransportercode.Text.Trim().ToString(); if (rdlocal.Checked == true) { objtransporter.transportermaster_TRANTYPE = "LOCAL"; objtransporter.transportermaster_TRANTYPECODE = 1; } else { objtransporter.transportermaster_TRANTYPE = "REMOTE"; objtransporter.transportermaster_TRANTYPECODE = 2; } objtransporter.transportermaster_MOBILENO = txtphone.Text.Trim().ToString(); objtransporter.transportermaster_FAX = txtfax.Text.Trim().ToString(); if (txtemail.Text.Trim().ToString() != string.Empty) { objtransporter.transportermaster_EMAILID = txtemail.Text.Trim().ToString(); } objtransporter.transportermaster_PANNO = txtpano.Text.Trim().ToString(); objtransporter.transportermaster_SERVICETAXNO = txtservicetaxno.Text.Trim().ToString(); objtransporter.transportermaster_ADDRESS = txtaddress.Text.Trim().ToString(); objtransporter.transportermaster_STATUS = 0; if (objtransporter.Insert(true, "transportermaster")) { string sqlmax = "SELECT MAX(SRNO) AS SRNO FROM TRANSPORTERMASTER TM WHERE STATUS=0 AND TRANSPORTERNAME='" + txttransportername.Text.Trim().ToString() + "' AND TRANSPORTERCODE='" + txttransportercode.Text.Trim().ToString() + "'"; Handler hdnmax = new Handler(); DataTable dtmax = hdnmax.GetTable(sqlmax); if (rdserviceapplicable.Checked == true) { string sqltax = "SELECT SRNO,TAXNAME,TAXUNIT,TAXVALUE FROM TAXMASTER TM WHERE TM.STATUS=0 AND TM.TAXNAME='SERVICE TAX'"; Handler hdntax = new Handler(); DataTable dttax = hdntax.GetTable(sqltax); taxationmaster objtax = new taxationmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtax.taxationmaster_SRNO = -1; objtax.taxationmaster_TAXPARTYTYPE = "TRANSPORTER"; objtax.taxationmaster_TAXPARTYID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objtax.taxationmaster_TAXID = General.Parse<int>(dttax.Rows[0]["SRNO"].ToString()); objtax.taxationmaster_TAXNAME = dttax.Rows[0]["TAXNAME"].ToString().Trim(); objtax.taxationmaster_TAXVALUE = General.Parse<double>(dttax.Rows[0]["TAXVALUE"].ToString().Trim()); objtax.taxationmaster_TAXUNIT = dttax.Rows[0]["TAXUNIT"].ToString().Trim(); objtax.taxationmaster_STATUS = 0; if (objtax.Insert(true, "taxationmaster")) { } } if (dtmax.Rows.Count > 0 && memberrepeater.Items.Count > 0) { for (int i = 0; i < memberrepeater.Items.Count; i++) { TextBox name = (TextBox)memberrepeater.Items[i].FindControl("txtpersonname"); TextBox phone = (TextBox)memberrepeater.Items[i].FindControl("txtperphone"); TextBox email = (TextBox)memberrepeater.Items[i].FindControl("txtperemailid"); TextBox mobile = (TextBox)memberrepeater.Items[i].FindControl("txtpermobile"); personalmaster objpersonal = new personalmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonal.personalmaster_SRNO = -1; objpersonal.personalmaster_PERSONNAME = name.Text.ToString().Trim(); if (email.Text.ToString().Trim() != string.Empty) { objpersonal.personalmaster_EMAILID = email.Text.ToString().Trim(); } objpersonal.personalmaster_PHONENO = phone.Text.ToString().Trim(); objpersonal.personalmaster_MOBILE = mobile.Text.ToString().Trim(); objpersonal.personalmaster_PERSONRELATIONID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objpersonal.personalmaster_PERSONTYPE = "TRANSPORTER"; if (objpersonal.Insert(true, "personalmaster")) { } } } personaltable objpersonal1 = new personaltable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonal1.personaltable_RELATIONSHIPID = -1; objpersonal1.personaltable_FIRSTNAME = txttransportername.Text.Trim().ToString(); objpersonal1.personaltable_BRANCHID = General.Parse<int>(Session["branchid"].ToString()); Handler branch = new Handler(); DataTable dtbranch = branch.GetTable("select BRANCHNAME from branchmaster where branchid=" + Session["branchid"].ToString()); objpersonal1.personaltable_BRANCHNAME = dtbranch.Rows[0][0].ToString().Trim(); if (objpersonal1.Insert(true, "personaltable")) { string sql = "SELECT MAX(PR.RELATIONSHIPID) AS RELATIONSHIPID FROM personaltable PR WHERE PR.BRANCHID=1 AND PR.FIRSTNAME='" + txttransportername.Text.Trim().ToString() + "'"; Handler hdn = new Handler(); DataTable dt = hdn.GetTable(sql); personalrelation objpersonalrelation = new personalrelation(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonalrelation.personalrelation_SRNO = -1; objpersonalrelation.personalrelation_RELATIONSHIPID = General.Parse<int>(dt.Rows[0][0].ToString()); objpersonalrelation.personalrelation_ASSOSIATEDFEILD = "MAIN ACCOOUNT"; objpersonalrelation.personalrelation_ASSOSIATEDBRANCH = General.Parse<int>(Session["branchid"].ToString()); objpersonalrelation.personalrelation_GROUPID = 100; objpersonalrelation.personalrelation_STATUS = 0; if (objpersonalrelation.Insert(true, "personalrelation")) { } } MessageBox("Transporter Added Successfully"); Response.Redirect("transporterlist.aspx?ID=2"); //Response.Redirect("transporterdetails.aspx?ID=1&TRANSPORTERID=" + dtmax.Rows[0][0].ToString()); } } else { MessageBox("Transporter Code Already Exist"); } }
protected void btnsubmit_Click(object sender, EventArgs e) { string partyid = string.Empty; string contactperson = string.Empty; partyid = ddlparty.SelectedValue.ToString(); quotationmaster objquotation = new quotationmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objquotation.quotationmaster_QUOTATIONID = -1; objquotation.quotationmaster_PARTYID = General.Parse<int>(partyid); objquotation.quotationmaster_PARTYTYPE = 1; objquotation.quotationmaster_CONTACTPERSON = General.Parse<int>(contactperson); objquotation.quotationmaster_DATE = txtdate.Text.Trim().ToString(); objquotation.quotationmaster_EXPIRYDATE = txtexpirydate.Text.Trim().ToString(); if (txtrefno.Text.Trim().ToString() != string.Empty) { objquotation.quotationmaster_REFNO = txtrefno.Text.Trim().ToString(); } objquotation.quotationmaster_COALCOST = General.Parse<double>(txtfinalcoalcost.Text.Trim().ToString()); objquotation.quotationmaster_TAXCOST = General.Parse<double>(txtfinaltax.Text.Trim().ToString()); objquotation.quotationmaster_TRANSPORTATIONCOST = General.Parse<double>(txttransportationcost.Text.Trim().ToString()); objquotation.quotationmaster_TOTALCOST = General.Parse<double>(txtfinalcoalcost.Text.Trim().ToString()); objquotation.quotationmaster_STATUS = 0; string condition = "QUOTATIONID=" + ViewState["QUOTATIONID"].ToString(); if (objquotation.Insert(false, "quotationmaster", condition)) { quotationspecification objspecification = new quotationspecification(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objspecification.quotationspecification_SRNO = -1; objspecification.quotationspecification_QUOTATIONID = -1; objspecification.quotationspecification_COALTYPE = ddlcoalgrade.SelectedItem.Text; objspecification.quotationspecification_COALTYPEID = General.Parse<int>(ddlcoalgrade.SelectedValue.ToString()); objspecification.quotationspecification_COALSOURCE = ddlcoalsource.SelectedItem.Text; objspecification.quotationspecification_COALSOURCEID = General.Parse<int>(ddlcoalsource.SelectedValue.ToString()); objspecification.quotationspecification_COALQUANTITY = General.Parse<double>(txtcoalquantity.Text.Trim().ToString()); objspecification.quotationspecification_COALRATE = General.Parse<double>(txtcoalrate.Text.Trim().ToString()); objspecification.quotationspecification_COALSIZEMIN = General.Parse<double>(txtcoalsizemin.Text.Trim().ToString()); objspecification.quotationspecification_COALSIZEMAX = General.Parse<double>(txtcoalsizemax.Text.Trim().ToString()); objspecification.quotationspecification_GCV = General.Parse<double>(txtgcv.Text.Trim().ToString()); objspecification.quotationspecification_GCVERROR = General.Parse<double>(txtgcv.Text.Trim().ToString()); objspecification.quotationspecification_MOISTURE = General.Parse<double>(txtmoisture.Text.Trim().ToString()); objspecification.quotationspecification_MOISTUREERROR = General.Parse<double>(txtmoistureerror.Text.Trim().ToString()); if (objspecification.Insert(false, "quotationspecification", condition)) { } SqlConnection Connection = new SqlConnection("Data Source=50.28.62.129,1433;Network Library=DBMSSOCN;Initial Catalog=db_fuel;User ID=fuel;Password= lSa2@11h"); string qry = "delete from taxationmaster where TAXPARTYTYPE='QUOTATION' AND TAXPARTYID=" + ViewState["QUOTATIONID"].ToString(); Connection.Open(); SqlCommand com = new SqlCommand(qry, Connection); com.ExecuteNonQuery(); Connection.Close(); for (int t = 0; t < ((DataTable)Session["tax"]).Rows.Count; t++) { string sqltax = "SELECT SRNO,TAXNAME,TAXUNIT,TAXVALUE FROM TAXMASTER TM WHERE TM.STATUS=0 AND TM.TAXNAME='" + ((DataTable)Session["tax"]).Rows[t]["TAXNAME"].ToString().Trim() + "' AND TM.TAXVALUE=" + ((DataTable)Session["tax"]).Rows[t]["TAXVALUE"].ToString().Trim(); Handler hdntax = new Handler(); DataTable dttax = hdntax.GetTable(sqltax); taxationmaster objtax = new taxationmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtax.taxationmaster_SRNO = -1; objtax.taxationmaster_TAXPARTYTYPE = "QUOTATION"; objtax.taxationmaster_TAXPARTYID = General.Parse<int>(ViewState["QUOTATIONID"].ToString()); objtax.taxationmaster_TAXID = General.Parse<int>(dttax.Rows[0]["SRNO"].ToString()); objtax.taxationmaster_TAXNAME = dttax.Rows[0]["TAXNAME"].ToString().Trim(); objtax.taxationmaster_TAXVALUE = General.Parse<double>(dttax.Rows[0]["TAXVALUE"].ToString().Trim()); objtax.taxationmaster_TAXUNIT = dttax.Rows[0]["TAXUNIT"].ToString().Trim(); objtax.taxationmaster_STATUS = 0; if (objtax.Insert(true, "taxationmaster")) { } } string qry1 = "delete from termstable where partytype='QUOTATION' AND PARTYID=" + ViewState["QUOTATIONID"].ToString(); Connection.Open(); SqlCommand com1 = new SqlCommand(qry1, Connection); com1.ExecuteNonQuery(); Connection.Close(); foreach (ListItem aListItem in chktermslist.Items) { if (aListItem.Selected) { termstable objterms = new termstable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objterms.termstable_SRNO = -1; objterms.termstable_STATUS = 0; objterms.termstable_PARTYTYPE = "QUOTATION"; objterms.termstable_PARTYID = General.Parse<int>(ViewState["QUOTATIONID"].ToString()); objterms.termstable_TERMSID = General.Parse<int>(aListItem.Value.ToString().Trim()); objterms.termstable_TERMS = aListItem.Text.Trim().ToString(); objterms.termstable_TERMSVALUE = -1; if (objterms.Insert(true, "termstable")) { } } } } Response.Redirect("Quotationlist.aspx?ID=2"); }