protected void btnSave_Click(object sender, EventArgs e) { // DdlSection.Text = "----"; if (Session["saved"] == null) { Session["saved"] = "s"; } if (Session["saved"].ToString() != TxtCustCode.Text.Trim()) { try { //string Area = TxtArea.Text.Split(':')[0].Trim(); Other_Z.Customer_cs_rev _objCust = new Other_Z.Customer_cs_rev(); _objCust.CustID = Convert.ToInt32(LblCustId.Text); _objCust.CustCode = TxtCustCode.Text.Trim(); _objCust.ShortForm = TxtShortForm.Text.Trim(); _objCust.FamilyCode = TxtFamilyCode.Text.Trim(); _objCust.Address = TxtAddress.Text.Trim(); _objCust.Zip = TxtZip.Text.Trim(); _objCust.Phone1 = TxtPhone1.Text.Trim(); _objCust.Phone2 = TxtPhone2.Text.Trim(); _objCust.EmailID = TxtEmailID.Text.Trim(); _objCust.CUSTOMERTYPE = TxtCustomerType.Text.Trim(); _objCust.IsDeleted = false; _objCust.IsActive = true; _objCust.CreatedBy = Convert.ToString(Session["UserName"]); _objCust.CustName = TxtCustName.Text.Trim(); _objCust.ZoneID = Convert.ToInt32(DDLzone.SelectedValue); _objCust.SuperZoneID = Convert.ToInt32(DDLsuperzone.SelectedValue); _objCust.AreaZoneID = Convert.ToInt32(DDLareazone.SelectedValue); _objCust.AreaID = Convert.ToInt32(DDLarea.SelectedValue); _objCust.DMID = Convert.ToInt32(ddLStates.SelectedValue); _objCust.City = Convert.ToInt32(ddlCity.SelectedValue); _objCust.CustRating = Convert.ToInt32(DdlCustRating.SelectedValue); _objCust.Fyfrom = Convert.ToInt32(strFY); _objCust.CMID = Convert.ToInt32(DDLCC.SelectedValue); _objCust.CMIDsub = Convert.ToInt32(DDLCSC.SelectedValue); _objCust.SchAdditionalDis = txtSchAdditionalDis.Text.Trim(); _objCust.TODValue1 = txtTODValue1.Text.Trim(); _objCust.TODValue2 = txtTODValue2.Text.Trim(); _objCust.TODValue3 = txtTODValue3.Text.Trim(); _objCust.TODDisc1 = txtTODDisc1.Text.Trim(); _objCust.TODDisc2 = txtTODDisc2.Text.Trim(); _objCust.TODDisc3 = txtTODDisc3.Text.Trim(); _objCust.isSplit = chk_splitdc.Checked; XmlDocument doc = new XmlDocument(); XmlNode node1 = doc.CreateElement("r"); XmlNode nd = doc.CreateElement("CUL"); nd.InnerText = txtUpperlimit.Text; node1.AppendChild(nd); nd = doc.CreateElement("CLL"); nd.InnerText = txtLowerlimit.Text; node1.AppendChild(nd); nd = doc.CreateElement("SBUCode"); nd.InnerText = ddlSbucode.Text; node1.AppendChild(nd); nd = doc.CreateElement("P"); nd.InnerText = txtPANNo.Text; node1.AppendChild(nd); nd = doc.CreateElement("G"); nd.InnerText = txtGstNo.Text; node1.AppendChild(nd); nd = doc.CreateElement("S"); nd.InnerText = txtStateCode.Text.Trim(); node1.AppendChild(nd); #region DataTable To Xml Convert XmlNode node = doc.CreateElement("tod"); foreach (GridViewRow item in TODGridview.Rows) { XmlNode element = doc.CreateElement("t"); nd = doc.CreateElement("i"); nd.InnerText = ((TextBox)item.FindControl("lblTodAmount")).Text.Trim(); element.AppendChild(nd); nd = doc.CreateElement("j"); nd.InnerText = ((TextBox)item.FindControl("lblTodPercentage")).Text.Trim(); element.AppendChild(nd); nd = doc.CreateElement("f"); nd.InnerText = Convert.ToInt32(strFY).ToString(); element.AppendChild(nd); nd = doc.CreateElement("a"); nd.InnerText = Convert.ToInt32(((CheckBox)item.FindControl("lblAction")).Checked).ToString(); element.AppendChild(nd); node.AppendChild(element); } foreach (GridViewRow item in GridAssorted.Rows) { XmlNode element2 = doc.CreateElement("ad"); nd = doc.CreateElement("b"); nd.InnerText = ((Label)item.FindControl("bookId")).Text.Trim(); element2.AppendChild(nd); nd = doc.CreateElement("fr"); nd.InnerText = ((TextBox)item.FindControl("lblFromQty")).Text.Trim(); element2.AppendChild(nd); nd = doc.CreateElement("to"); nd.InnerText = ((TextBox)item.FindControl("lblToQty")).Text.Trim(); element2.AppendChild(nd); nd = doc.CreateElement("di"); nd.InnerText = ((TextBox)item.FindControl("lblDiscount")).Text.Trim(); element2.AppendChild(nd); node.AppendChild(element2); } node1.AppendChild(node); _objCust.OtherFields = node1.OuterXml.ToString(); Session["TempDataTable"] = null; Session["TempAssorted"] = null; TODGridview.Visible = false; GridAssorted.Visible = false; #endregion string TxtPrincipalDOB1 = ""; string TxtKeyPersonDOB1 = ""; try { TxtPrincipalDOB1 = TxtPrincipalDOB.Text.Split('/')[1] + "/" + TxtPrincipalDOB.Text.Split('/')[0] + "/" + TxtPrincipalDOB.Text.Split('/')[2]; TxtKeyPersonDOB1 = TxtKeyPersonDOB.Text.Split('/')[1] + "/" + TxtKeyPersonDOB.Text.Split('/')[0] + "/" + TxtKeyPersonDOB.Text.Split('/')[2]; } catch (Exception ex) { } if (LblCustId.Text == "0") { _objCust.Save(out CID); // TxtCustId.Text = Convert.ToString(CID); string Medium = TxtMedium.Text.Split(':')[0].Trim(); CustomerDetails _objCustDetails = new CustomerDetails(); _objCustDetails.CustId = CID; _objCustDetails.CustCode = TxtCustCode.Text.Trim(); _objCustDetails.CreditLimit = TxtCreditLimit.Text.Trim(); // _objCustDetails.Creditdays = txtcreditdays.Text.Trim(); _objCustDetails.BlackList = ChkBlacklist.Checked; _objCustDetails.CreatedBy = Convert.ToString(Session["UserName"]); _objCustDetails.PrincipalName = TxtPrincipalName.Text.Trim(); _objCustDetails.PrincipalMobile = TxtPrincipalMobile.Text.Trim(); _objCustDetails.PrincipalDOB = TxtPrincipalDOB1; _objCustDetails.KeyPersonName = TxtKeyPersonName.Text.Trim(); _objCustDetails.KeyPersonMobile = TxtKeyPersonMobile.Text.Trim(); _objCustDetails.KeyPersonDOB = TxtKeyPersonDOB.Text.Trim(); _objCustDetails.AdditinalDis = TxtAdditinalDis.Text.Trim(); _objCustDetails.VIPRemark = TxtVIPRemark.Text.Trim(); _objCustDetails.BlackListRemark = TxtblkRemark.Text.Trim(); _objCustDetails.BlackListDate = TxtblkDate.Text.Trim(); _objCustDetails.SectionID = 0; //_objCustDetails.SectionID = Convert.ToInt32(DdlSection.SelectedValue); _objCustDetails.Medium = Medium; //_objCustDetails.BoardID = Convert.ToInt32(DDLBoard.SelectedValue.ToString()); if (txtcgp.Text.Trim().ToString() != "") { _objCustDetails.CGP = Convert.ToDecimal(txtcgp.Text.Trim().ToString()); } else { _objCustDetails.CGP = 0; } if (txtbuisiness.Text.Trim().ToString() != "") { _objCustDetails.Business_Potential = Convert.ToDecimal(txtbuisiness.Text.Trim().ToString()); } else { _objCustDetails.Business_Potential = 0; } _objCustDetails.Association = txtassociation.Text.Trim().ToString(); _objCustDetails.Payment_Track = ""; _objCustDetails.Save(); // grdCustDetails.Visible = true; PnlDetails.Visible = true; MessageBox("Record saved successfully"); if (btnSave.Text == "Update") { PnlDetails.Visible = true; PnlAdd.Visible = false; btnSave.Visible = false; filter.Visible = true; } else { PnlDetails.Visible = false; PnlAdd.Visible = true; btnSave.Visible = true; } } else { string Medium = TxtMedium.Text.Split(':')[0].Trim(); _objCust.CustID = Convert.ToInt32(LblCustId.Text); _objCust.CustDetailID = Convert.ToInt32(LblCustDetailID1.Text); if (TxtCreditLimit.Text == "") { TxtCreditLimit.Text = "0"; } _objCust.CreditLimit = Convert.ToInt32(TxtCreditLimit.Text.Trim()); _objCust.CreditDays = txtcreditdays.Text.Trim(); _objCust.BlackList = ChkBlacklist.Checked; _objCust.IsDeleted1 = false; _objCust.PrincipalName = TxtPrincipalName.Text.Trim(); _objCust.PrincipalMobile = TxtPrincipalMobile.Text.Trim(); _objCust.PrincipalDOB = TxtPrincipalDOB.Text.Trim(); _objCust.KeyPersonName = TxtKeyPersonName.Text.Trim(); _objCust.KeyPersonMobile = TxtKeyPersonMobile.Text.Trim(); _objCust.KeyPersonDOB = TxtKeyPersonDOB.Text.Trim(); _objCust.AdditinalDis = TxtAdditinalDis.Text.Trim(); _objCust.VIPRemark = TxtVIPRemark.Text.Trim(); //_objCust.SectionID = Convert.ToInt32(DdlSection.SelectedValue); _objCust.SectionID = 0; _objCust.Medium = Medium; //_objCust.BoardID = Convert.ToInt32(DDLBoard.SelectedValue.ToString()); if (txtcgp.Text.Trim().ToString() != "") { _objCust.CGP = Convert.ToDecimal(txtcgp.Text.Trim().ToString()); } else { _objCust.CGP = 0; } if (txtbuisiness.Text.Trim().ToString() != "") { _objCust.Business_Potential = Convert.ToDecimal(txtbuisiness.Text.Trim().ToString()); } else { _objCust.Business_Potential = 0; } _objCust.Association = txtassociation.Text.Trim().ToString(); _objCust.Payment_Track = ""; _objCust.Remark5 = strFY.ToString(); _objCust.Update(); MessageBox("Record updated successfully"); TxtCustCode.Enabled = true; if (btnSave.Text.ToLower() == "update") { PnlDetails.Visible = true; PnlAdd.Visible = false; btnSave.Visible = false; filter.Visible = true; } else { PnlDetails.Visible = false; PnlAdd.Visible = true; btnSave.Visible = true; } } TxtCustCode.Text = ""; TxtShortForm.Text = ""; TxtFamilyCode.Text = ""; TxtAddress.Text = ""; TxtZip.Text = ""; TxtPhone1.Text = ""; TxtPhone2.Text = ""; TxtEmailID.Text = ""; TxtCustName.Text = ""; txtcreditdays.Text = ""; TxtCreditLimit.Text = ""; TxtPrincipalName.Text = ""; TxtPrincipalMobile.Text = ""; TxtPrincipalDOB.Text = ""; TxtKeyPersonName.Text = ""; TxtKeyPersonMobile.Text = ""; TxtKeyPersonDOB.Text = ""; TxtAdditinalDis.Text = ""; TxtVIPRemark.Text = ""; TxtMedium.Text = ""; TxtCustomerType.Text = ""; DDLzone.SelectedValue = "0"; DDLareazone.SelectedValue = "0"; DDLarea.SelectedValue = "0"; ddLStates.SelectedValue = "0"; DDLsuperzone.SelectedValue = "0"; DdlCustRating.SelectedValue = "0"; // DDLBoard.SelectedValue = "0"; txtassociation.Text = ""; txtbuisiness.Text = ""; txtcgp.Text = ""; txtSchAdditionalDis.Text = ""; txtTODDisc1.Text = ""; txtTODDisc2.Text = ""; txtTODDisc3.Text = ""; txtTODValue1.Text = ""; txtTODValue2.Text = ""; txtTODValue3.Text = ""; DDLCC.SelectedValue = "0"; DDLCSC.SelectedValue = "0"; ddlCity.SelectedValue = "0"; txtStateCode.Text = ""; } catch (SqlException ex) { Response.Write(ex.Message.ToString()); } catch (Exception ex1) { Response.Write(ex1.Message.ToString()); } } Session["saved"] = TxtCustCode.Text.Trim(); }
protected void btnSave_Click(object sender, EventArgs e) { // DdlSection.Text = "----"; try { //string Area = TxtArea.Text.Split(':')[0].Trim(); Customer_cs _objCust = new Customer_cs(); _objCust.CustID = Convert.ToInt32(LblCustId.Text); _objCust.CustCode = TxtCustCode.Text.Trim(); _objCust.ShortForm = TxtShortForm.Text.Trim(); _objCust.FamilyCode = TxtFamilyCode.Text.Trim(); _objCust.Address = TxtAddress.Text.Trim(); _objCust.Zip = TxtZip.Text.Trim(); _objCust.Phone1 = TxtPhone1.Text.Trim(); _objCust.Phone2 = TxtPhone2.Text.Trim(); _objCust.EmailID = TxtEmailID.Text.Trim(); _objCust.CUSTOMERTYPE = TxtCustomerType.Text.Trim(); _objCust.IsDeleted = false; _objCust.IsActive = true; _objCust.CreatedBy = Convert.ToString(Session["UserName"]); _objCust.CustName = TxtCustName.Text.Trim(); _objCust.ZoneID = Convert.ToInt32(DDLzone.SelectedValue); _objCust.SuperZoneID = Convert.ToInt32(DDLsuperzone.SelectedValue); _objCust.AreaZoneID = Convert.ToInt32(DDLareazone.SelectedValue); _objCust.AreaID = Convert.ToInt32(DDLarea.SelectedValue); _objCust.DMID = Convert.ToInt32(ddLStates.SelectedValue); _objCust.City = Convert.ToInt32(ddlCity.SelectedValue); _objCust.CustRating = Convert.ToInt32(DdlCustRating.SelectedValue); string TxtPrincipalDOB1 = ""; string TxtKeyPersonDOB1 = ""; try { TxtPrincipalDOB1 = TxtPrincipalDOB.Text.Split('/')[1] + "/" + TxtPrincipalDOB.Text.Split('/')[0] + "/" + TxtPrincipalDOB.Text.Split('/')[2]; TxtKeyPersonDOB1 = TxtKeyPersonDOB.Text.Split('/')[1] + "/" + TxtKeyPersonDOB.Text.Split('/')[0] + "/" + TxtKeyPersonDOB.Text.Split('/')[2]; } catch { } if (LblCustId.Text == "0") { _objCust.Save(out CID); // TxtCustId.Text = Convert.ToString(CID); string Medium = TxtMedium.Text.Split(':')[0].Trim(); CustomerDetails _objCustDetails = new CustomerDetails(); _objCustDetails.CustId = CID; _objCustDetails.CustCode = TxtCustCode.Text.Trim(); _objCustDetails.CreditLimit = TxtCreditLimit.Text.Trim(); // _objCustDetails.Creditdays = txtcreditdays.Text.Trim(); _objCustDetails.BlackList = ChkBlacklist.Checked; _objCustDetails.CreatedBy = Convert.ToString(Session["UserName"]); _objCustDetails.PrincipalName = TxtPrincipalName.Text.Trim(); _objCustDetails.PrincipalMobile = TxtPrincipalMobile.Text.Trim(); _objCustDetails.PrincipalDOB = TxtPrincipalDOB1; _objCustDetails.KeyPersonName = TxtKeyPersonName.Text.Trim(); _objCustDetails.KeyPersonMobile = TxtKeyPersonMobile.Text.Trim(); _objCustDetails.KeyPersonDOB = TxtKeyPersonDOB.Text.Trim(); _objCustDetails.AdditinalDis = TxtAdditinalDis.Text.Trim(); _objCustDetails.VIPRemark = TxtVIPRemark.Text.Trim(); _objCustDetails.SectionID = 0; //_objCustDetails.SectionID = Convert.ToInt32(DdlSection.SelectedValue); _objCustDetails.Medium = Medium; _objCustDetails.Save(); grdCustDetails.Visible = true; PnlDetails.Visible = true; MessageBox("Record saved successfully"); if (btnSave.Text == "Update") { PnlDetails.Visible = true; PnlAdd.Visible = false; btnSave.Visible = false; filter.Visible = true; } else { PnlDetails.Visible = false; PnlAdd.Visible = true; btnSave.Visible = true; } } else { string Medium = TxtMedium.Text.Split(':')[0].Trim(); _objCust.CustID = Convert.ToInt32(LblCustId.Text); _objCust.CustDetailID = Convert.ToInt32(LblCustDetailID1.Text); if (TxtCreditLimit.Text == "") { TxtCreditLimit.Text = "0"; } _objCust.CreditLimit = Convert.ToInt32(TxtCreditLimit.Text.Trim()); _objCust.CreditDays = txtcreditdays.Text.Trim(); _objCust.BlackList = ChkBlacklist.Checked; _objCust.IsDeleted1 = false; _objCust.PrincipalName = TxtPrincipalName.Text.Trim(); _objCust.PrincipalMobile = TxtPrincipalMobile.Text.Trim(); _objCust.PrincipalDOB = TxtPrincipalDOB.Text.Trim(); _objCust.KeyPersonName = TxtKeyPersonName.Text.Trim(); _objCust.KeyPersonMobile = TxtKeyPersonMobile.Text.Trim(); _objCust.KeyPersonDOB = TxtKeyPersonDOB.Text.Trim(); _objCust.AdditinalDis = TxtAdditinalDis.Text.Trim(); _objCust.VIPRemark = TxtVIPRemark.Text.Trim(); //_objCust.SectionID = Convert.ToInt32(DdlSection.SelectedValue); _objCust.SectionID = 0; _objCust.Medium = Medium; _objCust.Update(); DataView dv1 = new DataView(BindGvCustDetail().Table); Session["data"] = dv1; grdCustDetails.DataSource = dv1; grdCustDetails.DataBind(); MessageBox("Record updated successfully"); TxtCustCode.Enabled = true; if (btnSave.Text.ToLower() == "update") { PnlDetails.Visible = true; PnlAdd.Visible = false; btnSave.Visible = false; filter.Visible = true; } else { PnlDetails.Visible = false; PnlAdd.Visible = true; btnSave.Visible = true; } } TxtCustCode.Text = ""; TxtShortForm.Text = ""; TxtFamilyCode.Text = ""; TxtAddress.Text = ""; TxtZip.Text = ""; TxtPhone1.Text = ""; TxtPhone2.Text = ""; TxtEmailID.Text = ""; TxtCustName.Text = ""; TxtCreditLimit.Text = ""; TxtPrincipalName.Text = ""; TxtPrincipalMobile.Text = ""; TxtPrincipalDOB.Text = ""; TxtKeyPersonName.Text = ""; TxtKeyPersonMobile.Text = ""; TxtKeyPersonDOB.Text = ""; TxtAdditinalDis.Text = ""; TxtVIPRemark.Text = ""; TxtMedium.Text = ""; TxtCustomerType.Text = ""; DDLzone.SelectedValue = "0"; DDLareazone.SelectedValue = "0"; DDLarea.SelectedValue = "0"; ddLStates.SelectedValue = "0"; DDLsuperzone.SelectedValue = "0"; DdlCustRating.SelectedValue = "0"; } catch (SqlException ex) { Response.Write(ex.Message.ToString()); } catch (Exception ex1) { Response.Write(ex1.Message.ToString()); } }