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