/// <summary>
/// This method is used to Update the vendor entry with the help of ProSupplierEntry Procedure before check
/// the vendor name must be unique if vendor name is duplicate then show popup message for user.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUpdate_Click(object sender, System.EventArgs e)
{
PartiesClass obj = new PartiesClass();
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 (!checkAcc_Period())
{
MessageBox.Show("Please enter the Accounts Period from Organization Details");
return;
}
// string sname=StringUtil.FirstCharUpper((txtFName.Text.ToString().Trim())) +" "+ StringUtil.FirstCharUpper((txtMName.Text.ToString().Trim() ))+" "+ StringUtil.FirstCharUpper((txtLName.Text.ToString().Trim() )); SqlDataReader SqlDtr;
// string sql1="select Supp_ID from supplier where Supp_Name='"+sname+"'";
//
// SqlDtr=obj.GetRecordSet(sql1);
//
// if(SqlDtr.HasRows)
// {
// MessageBox.Show("Vendor Name "+sname+" Already Exist");
// return;
// }
// SqlDtr.Close();
string sql1;
SqlDataReader SqlDtr = null;
string sname = "";
if (txtFName.Text.Trim() != "")
{
sname += txtFName.Text.Trim();
}
if (txtMName.Text.Trim() != "")
{
sname += " " + txtMName.Text.Trim();
}
if (txtLName.Text.Trim() != "")
{
sname += " " + txtLName.Text.Trim();
}
//((txtFName.Text.ToString().Trim() )) +" "+ StringUtil.FirstCharUpper((txtMName.Text.ToString().Trim() ))+" "+ StringUtil.FirstCharUpper((txtLName.Text.ToString().Trim() ));
sql1 = "select Supp_Id from Supplier where Supp_Name='" + sname.Trim() + "'";
SqlDtr = obj.GetRecordSet(sql1);
if (SqlDtr.HasRows)
{
MessageBox.Show("Vendor Name " + sname + " Already Exist");
return;
}
SqlDtr.Close();
sql1 = "select * from Ledger_Master where Ledger_Name='" + sname.Trim() + "'";
SqlDtr = obj.GetRecordSet(sql1);
if (SqlDtr.HasRows)
{
MessageBox.Show("Ledger Name " + sname + " Already Exist");
return;
}
SqlDtr.Close();
// sql1 = "Select Tin_No from supplier where Tin_No = '"+txtTinNo.Text.Trim()+"'";
// SqlDtr= obj.GetRecordSet(sql1);
// if(SqlDtr.HasRows)
// {
// MessageBox.Show("The Tin No. "+txtTinNo.Text.Trim()+" Already Exist");
// return;
// }
// SqlDtr.Close();
obj.Supp_ID = lblSupplierID.Text;
if (txtMName.Text != "" && txtLName.Text != "")
{
obj.Supp_Name = StringUtil.FirstCharUpper((txtFName.Text.ToString().Trim())) + " " + StringUtil.FirstCharUpper((txtMName.Text.ToString().Trim()) + " " + (txtLName.Text.ToString().Trim()));
}
else if (txtMName.Text == "" && txtLName.Text != "")
{
obj.Supp_Name = StringUtil.FirstCharUpper((txtFName.Text.ToString().Trim())) + " " + StringUtil.FirstCharUpper((txtLName.Text.ToString().Trim()));
}
else if (txtMName.Text != "" && txtLName.Text == "")
{
obj.Supp_Name = StringUtil.FirstCharUpper((txtFName.Text.ToString().Trim())) + " " + StringUtil.FirstCharUpper((txtMName.Text.ToString().Trim()));
}
else if (txtLName.Text == "" && txtMName.Text == "")
{
obj.Supp_Name = StringUtil.FirstCharUpper((txtFName.Text.ToString().Trim()));
}
obj.Supp_Type = DropType.SelectedItem.Value.ToString();
obj.Address = txtAddress.Text.Trim();
obj.City = DropCity.SelectedItem.Value.ToString();
obj.State = DropState.SelectedItem.Value.ToString();
obj.Country = DropCountry.SelectedItem.Value.ToString();
if (txtPhoneOff.Text == "")
{
obj.Tel_Off = "0";
}
else
{
obj.Tel_Off = txtPhoneOff.Text;
}
if (txtPhoneRes.Text == "")
{
obj.Tel_Res = "0";
}
else
{
obj.Tel_Res = txtPhoneRes.Text;
}
if (txtMobile.Text == "")
{
obj.Mobile = "0";
}
else
{
obj.Mobile = txtMobile.Text;
}
obj.EMail = txtEMail.Text.Trim();
if (txtOpBalance.Text == "")
{
obj.Op_Balance = "0";
}
else
{
obj.Op_Balance = txtOpBalance.Text;
}
obj.Balance_Type = DropBal.SelectedItem.Value.ToString();
if (DropCrDay.SelectedIndex == 0)
{
obj.CR_Days = "0";
}
else
{
obj.CR_Days = DropCrDay.SelectedItem.Value.ToString();
}
obj.Tin_No = txtTinNo.Text.Trim();
// call the function to insert the supplier details.
obj.InsertSupplier();
MessageBox.Show("Vendor Saved");
Clear();
GetNextSupplierID();
CreateLogFiles.ErrorLog("Form:Vender_Entry.aspx, Method:btnUpdate_Click " + " Supplier_ID " + obj.Supp_ID + " Supplier Type " + obj.Supp_Type + " supplier City " + obj.City + " IS SAVED " + " user " + uid);
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:Vender_Entry.aspx, Method:btnUpdate_Click (). EXCEPTION: " + ex.Message + " user " + uid);
}
}
