/// <summary>
/// This method is used to check the customer name, ledger name and Tin no can not be duplicate
/// in customer or Ledger_Master table. After that call stored procedure 'ProCustomerUpdate' for
/// update the custoemr information.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUpdate_Click(object sender, System.EventArgs e)
{
PartiesClass obj = new PartiesClass();
SqlDataReader SqlDtr = null;
try
{
StringBuilder errorMessage = new StringBuilder();
if (txtTinNo.Text != string.Empty)
{
string sPattern = "^[a-zA-Z0-9]+$";
if (!System.Text.RegularExpressions.Regex.IsMatch(txtTinNo.Text, sPattern))
{
errorMessage.Append("- Please Enter GSTIN No. in Alpha Numeric");
errorMessage.Append("\n");
}
}
if (errorMessage.Length > 0)
{
MessageBox.Show(errorMessage.ToString());
return;
}
if (!TempCustName.Text.ToLower().Trim().Equals(lblName.Text.ToLower().Trim()))
{
string ename = lblName.Text.Trim();
string sql1 = "select * from Customer where Cust_Name='" + ename.Trim() + "'";
SqlDtr = obj.GetRecordSet(sql1);
if (SqlDtr.HasRows)
{
MessageBox.Show("Customer Name " + ename + " Already Exist");
return;
}
SqlDtr.Close();
sql1 = "select * from Ledger_Master where Ledger_Name='" + ename.Trim() + "'";
SqlDtr = obj.GetRecordSet(sql1);
if (SqlDtr.HasRows)
{
MessageBox.Show("Ledger Name " + ename + " Already Exist");
return;
}
SqlDtr.Close();
}
if (!txtTinNo.Text.Trim().Equals(""))
{
string sql1 = "Select Tin_No,Cust_ID from customer where Tin_No = '" + txtTinNo.Text.Trim() + "' and Tin_No<>'unregister' and Tin_No<>'UNREGISTERED' and Tin_No<>'Un Register'";
SqlDtr = obj.GetRecordSet(sql1);
if (SqlDtr.HasRows)
{
if (SqlDtr.Read())
{
if (!LblCustomerID.Text.Equals(SqlDtr["Cust_ID"].ToString()))
{
MessageBox.Show("The Tin No. " + txtTinNo.Text.Trim() + " Already Exist");
return;
}
}
}
SqlDtr.Close();
}
else
{
txtTinNo.Text = "Un Register";
}
obj.Cust_ID = LblCustomerID.Text;
obj.Cust_Name = lblName.Text.ToString().Trim();
obj.TempCustName = TempCustName.Text;
obj.Cust_Type = DropCustType.SelectedItem.Value.ToString();
obj.Address = txtAddress.Text.ToString();
obj.City = DropCity.SelectedItem.Value.ToString();
obj.State = DropState.SelectedItem.Value.ToString();
obj.Country = DropCountry.SelectedItem.Value.ToString();
obj.EMail = txtEMail.Text.ToString();
if (txtcode.Text == "")
{
obj.sadbhavnacd = "0";
}
else
{
obj.sadbhavnacd = txtcode.Text.ToString();
}
if (txtPhoneRes.Text == "")
{
obj.Tel_Res = "0";
}
else
{
obj.Tel_Res = txtPhoneRes.Text;
}
if (txtPhoneOff.Text == "")
{
obj.Tel_Off = "0";
}
else
{
obj.Tel_Off = txtPhoneOff.Text;
}
if (txtMobile.Text == "")
{
obj.Mobile = "0";
}
else
{
obj.Mobile = txtMobile.Text;
}
if (txtCRLimit.Text == "")
{
obj.CR_Limit = "0";
}
else
{
obj.CR_Limit = txtCRLimit.Text;
}
if (DropCrDay.SelectedIndex == 0)
{
obj.CR_Days = "0";
}
else
{
obj.CR_Days = DropCrDay.SelectedItem.Value.ToString();
}
string OpBal = "0";
if (txtOpBalance.Text == "")
{
obj.Op_Balance = "0";
}
else
{
obj.Op_Balance = txtOpBalance.Text;
OpBal = txtOpBalance.Text;
}
obj.Balance_Type = DropBal.SelectedItem.Value.ToString();
obj.Tin_No = txtTinNo.Text.Trim();
if (DropSSR.SelectedIndex == 0)
{
obj.SSR = "";
}
else
{
SqlDtr = obj.GetRecordSet("select Emp_ID from Employee where Emp_Name='" + DropSSR.SelectedItem.Text + "'");
if (SqlDtr.Read())
{
obj.SSR = SqlDtr["Emp_ID"].ToString();
}
else
{
obj.SSR = "";
}
SqlDtr.Close();
}
obj.ContactPerson = txtContactPerson.Text;
// Calls method to update the customers details.
obj.UpdateCustomer();
/* Comment by Mahesh b'coz balance updated by existing procedure
* string Ledger_ID = "";
* dbobj.SelectQuery("select Ledger_ID from Ledger_Master where Ledger_Name=(select Cust_Name from Customer where Cust_ID='"+LblCustomerID.Text.Trim()+"')",ref SqlDtr);
* if(SqlDtr.Read())
* {
* Ledger_ID = SqlDtr.GetValue(0).ToString();
* }
* SqlDtr.Close();
* //UpdateCustomerBalance(LblCustomerID.Text.Trim(),Ledger_ID);
* object op=null;
* dbobj.ExecProc(OprType.Update,"UpdateAccountsLedgerForCustomer",ref op,"@Ledger_ID",Ledger_ID);
*/
MessageBox.Show("Customer Updated");
Clear();
CreateLogFiles.ErrorLog("Form:Customer_Updates.aspx,Class:PartiesClass.cs: Method:btnUpdate_Click " + " Recored of - Cust Name " + obj.Cust_Name + " Cust id " + obj.Cust_ID + " IS UPDATED " + " User Type " + uid);
Response.Redirect("Customer_List.aspx", false);
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:Customer_Updates.aspx,Class:PartiesClass.cs: Method:btnUpdate_Click " + " recored of " + " Cust Name " + obj.Cust_Name + " IS UPDATED " + " EXCEPTION " + ex.Message + " User Type " + uid); //Err.ErrorLog(Server.MapPath("Logs/ErrorLog"),"Form:Customer_Update.aspx,Method:btnUpdate_Click,Class:PartiesClass.cs " + ex.Message);
}
}
