//SAVE
public static string CU_Mst_Customer(M_AT_Mst_CustomerBO mvObjCust)
{
M_AT_Mst_CustomerBO ObjAT_Cust = new M_AT_Mst_CustomerBO();
string strRetMst = "";
DataTable dt = new DataTable();
string var_ErrorMessage = "";
try
{
if (mvObjCust.MCust_RegType.Length == 0)
{
var_ErrorMessage = var_ErrorMessage + "Pls Select Customer Type<br>";
}
if (SQLManager.CheckDuplicateRecord("M_AT_Mst_Customer", "M_Cust_ID", mvObjCust.M_Cust_ID, "MCustCode", mvObjCust.MCust_Code, ""))
{
var_ErrorMessage = var_ErrorMessage + "Customer Code Already Exist.<br>";
}
if (SQLManager.CheckDuplicateRecord("M_AT_Mst_Customer", "M_Cust_ID", mvObjCust.M_Cust_ID, "MCust_Name", mvObjCust.MCust_Name, ""))
{
var_ErrorMessage = var_ErrorMessage + "Customer Name Already Exists.<br>";
}
if (mvObjCust.MCust_Code.Length == 0)
{
var_ErrorMessage = var_ErrorMessage + "Customer Code No Cannot Be Blank.<br>";
}
if (mvObjCust.MCust_Name.Length == 0)
{
var_ErrorMessage = var_ErrorMessage + "Customer Name Cannot Be Blank.<br>";
}
if (mvObjCust.MCust_TradeName.Length == 0)
{
var_ErrorMessage = var_ErrorMessage + "Customer Trade Name Cannot Be Blank.<br>";
}
if (mvObjCust.MCust_Reg_State_ID == 0)
{
var_ErrorMessage = var_ErrorMessage + "Select Customer State.<br>";
}
if (mvObjCust.MCust_ShippTo_State_ID == 0)
{
var_ErrorMessage = var_ErrorMessage + "Select Customer Shipp To State.<br>";
}
if (var_ErrorMessage.Length == 0)
{
using (TransactionScope scope = new TransactionScope())
{
if (Convert.ToInt32(mvObjCust.M_Cust_ID) == 0)
{
ObjAT_Cust.Fk_Company_ID = mvObjCust.Fk_Company_ID;
ObjAT_Cust.Fk_Branch_ID = mvObjCust.Fk_Branch_ID;
ObjAT_Cust.Fk_Year_ID = mvObjCust.Fk_Year_ID;
ObjAT_Cust.MDBSC_RowCreatedByUser_ID = mvObjCust.MDBSC_RowCreatedByUser_ID;
ObjAT_Cust.MDBSC_RowCreatedByUserName = mvObjCust.MDBSC_RowCreatedByUserName;
ObjAT_Cust.MCust_Code = MaheshAF18.Application.MEF.GenrateRefNo(mvObjCust.Fk_Company_ID, mvObjCust.Fk_Branch_ID, 0, "Customer", "CUST", "CUST", "No", "", "", "", 0);
}
ObjAT_Cust.M_Cust_ID = mvObjCust.M_Cust_ID;
ObjAT_Cust.MCust_Name = mvObjCust.MCust_Name;
ObjAT_Cust.MCust_TradeName = mvObjCust.MCust_TradeName;
ObjAT_Cust.MCust_RegType = mvObjCust.MCust_RegType;
ObjAT_Cust.MCust_CreditDays = mvObjCust.MCust_CreditDays;
ObjAT_Cust.MCust_Reg_Add1 = mvObjCust.MCust_Reg_Add1;
ObjAT_Cust.MCust_Reg_Add2 = mvObjCust.MCust_Reg_Add2;
ObjAT_Cust.MCust_Reg_Pincode = mvObjCust.MCust_Reg_Pincode;
ObjAT_Cust.MCust_Reg_City = mvObjCust.MCust_Reg_City;
ObjAT_Cust.MCust_Reg_State_ID = mvObjCust.MCust_Reg_State_ID;
ObjAT_Cust.MCust_Reg_Country = mvObjCust.MCust_Reg_Country;
ObjAT_Cust.MCust_BL_PANNO = mvObjCust.MCust_BL_PANNO;
ObjAT_Cust.MCust_BL_GSTNO = mvObjCust.MCust_BL_GSTNO;
ObjAT_Cust.MCust_Primary_Contact_Person = mvObjCust.MCust_Primary_Contact_Person;
ObjAT_Cust.MCust_Primary_CP_MobileNo = mvObjCust.MCust_Primary_CP_MobileNo;
ObjAT_Cust.MCust_Primary_CP_PhoneNo = mvObjCust.MCust_Primary_CP_PhoneNo;
ObjAT_Cust.MCust_Primary_CP_EmailID = mvObjCust.MCust_Primary_CP_EmailID;
ObjAT_Cust.MCust_ShippTo_CompanyName = mvObjCust.MCust_ShippTo_CompanyName;
ObjAT_Cust.MCust_ShippTo_ContactPerson = mvObjCust.MCust_ShippTo_ContactPerson;
ObjAT_Cust.MCust_ShippTo_CP_MobileNo = mvObjCust.MCust_ShippTo_CP_MobileNo;
ObjAT_Cust.MCust_ShippTo_Add1 = mvObjCust.MCust_ShippTo_Add1;
ObjAT_Cust.MCust_ShippTo_Add2 = mvObjCust.MCust_ShippTo_Add2;
ObjAT_Cust.MCust_ShippTo_Pincode = mvObjCust.MCust_ShippTo_Pincode;
ObjAT_Cust.MCust_ShippTo_City = mvObjCust.MCust_ShippTo_City;
ObjAT_Cust.MCust_ShippTo_State_ID = mvObjCust.MCust_ShippTo_State_ID;
ObjAT_Cust.MCust_ShippTo_Country = mvObjCust.MCust_ShippTo_Country;
ObjAT_Cust.MCust_ShippTo_PANNO = mvObjCust.MCust_ShippTo_PANNO;
ObjAT_Cust.MCust_ShippTo_GSTNO = mvObjCust.MCust_ShippTo_GSTNO;
ObjAT_Cust.MDBSC_RowStatus = mvObjCust.MDBSC_RowStatus;
ObjAT_Cust.MDBSC_RowLupdnByUser_ID = mvObjCust.MDBSC_RowLupdnByUser_ID;
ObjAT_Cust.MDBSC_RowLupdnUserName = mvObjCust.MDBSC_RowLupdnUserName;
ObjAT_Cust.MDBSC_RowLupdnOn_DT = DateHelper.ConvertToDataBase(DateHelper.ConvertToForm(DateTime.Now));
ObjAT_Cust.MCust_Contact_FaxNo = mvObjCust.MCust_Contact_FaxNo;
ObjAT_Cust.MCust_Contact_OfficeNo1 = mvObjCust.MCust_Contact_OfficeNo1;
ObjAT_Cust.MCust_Contact_OfficeNo2 = mvObjCust.MCust_Contact_OfficeNo2;
ObjAT_Cust.MCust_Contact_Email_Admin = mvObjCust.MCust_Contact_Email_Admin;
ObjAT_Cust.MCust_Contact_Website = mvObjCust.MCust_Contact_Website;
ObjAT_Cust.MCust_Primary_Contact_Designation = mvObjCust.MCust_Primary_Contact_Designation;
var_ErrorMessage = ObjAT_Cust.Insert_Update(ObjAT_Cust);
//ObjItem.MItem_ID =Convert.ToInt64( var_ErrorMessage.Substring((var_ErrorMessage.IndexOf("|") + 1), (var_ErrorMessage.Length - var_ErrorMessage.IndexOf("|") - 1)));
//var_ErrorMessage = var_ErrorMessage.Substring((0), (var_ErrorMessage.IndexOf("|")));
scope.Complete();
}
strRetMst = var_ErrorMessage;
}
else
{
strRetMst = var_ErrorMessage + "|" + mvObjCust.M_Cust_ID.ToString();
}
return(strRetMst);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void btnsave_Click(object sender, System.EventArgs e)
{
try
{
string var_GSTState = "";
string var_StateCode = "";
if (MCust_RegType.SelectedIndex == 0)
{
ErrorMessage = ErrorMessage + "Pls Select Customer Type<br>";
}
else
{
if ((MCust_RegType.Text == "Registered Taxpayer") || (MCust_RegType.Text == "Composite Taxpayer"))
{
if (MCust_BL_GSTNO.Text.Length != 15)
{
ErrorMessage = ErrorMessage + "Billing GST No Cannot Be Blank<br>";
}
if (MCust_ShippTo_GSTNO.Text.Length != 15)
{
ErrorMessage = ErrorMessage + "Consignee GST No Cannot Be Blank<br>";
}
if (MCust_Reg_State_ID.SelectedIndex > 0)
{
if (MCust_BL_GSTNO.Text.Length > 2)
{
var_GSTState = MCust_BL_GSTNO.Text.Substring(0, 2);
}
var_StateCode = MCust_Reg_State_ID.SelectedItem.Text.Substring(0, 2);
if (var_GSTState != var_StateCode)
{
ErrorMessage = ErrorMessage + "Invlid Billing GST No For " + MCust_Reg_State_ID.SelectedItem.Text + " .<br>";
}
}
if (MCust_ShippTo_State_ID.SelectedIndex > 0)
{
if (MCust_ShippTo_GSTNO.Text.Length > 2)
{
var_GSTState = MCust_ShippTo_GSTNO.Text.Substring(0, 2);
}
var_StateCode = MCust_ShippTo_State_ID.SelectedItem.Text.Substring(0, 2);
if (var_GSTState != var_StateCode)
{
ErrorMessage = ErrorMessage + "Invlid Consignee GST No For " + MCust_ShippTo_State_ID.SelectedItem.Text + " .<br>";
}
}
}
if (MCust_RegType.Text == "Unregistered")
{
}
}
if (SQLManager.CheckDuplicateRecord("M_AT_Mst_Customer", "M_Cust_ID", Convert.ToInt32("0" + M_Cust_ID.Text), "MCustCode", MCust_Code.Text, ""))
{
ErrorMessage = ErrorMessage + "Customer Code Already Exist.<br>";
}
if (SQLManager.CheckDuplicateRecord("M_AT_Mst_Customer", "M_Cust_ID", Convert.ToInt32("0" + M_Cust_ID.Text), "MCustName", MCust_Name.Text, ""))
{
ErrorMessage = ErrorMessage + "Customer Name Already Exists.<br>";
}
if (MCust_Code.Text.Length == 0)
{
ErrorMessage = ErrorMessage + "Customer Code No Cannot Be Blank.<br>";
}
if (MCust_Name.Text.Length == 0)
{
ErrorMessage = ErrorMessage + "Customer Name Cannot Be Blank.<br>";
}
if (MCust_TradeName.Text.Length == 0)
{
ErrorMessage = ErrorMessage + "Customer Trade Name Cannot Be Blank.<br>";
}
if (MCust_Reg_State_ID.SelectedIndex == 0)
{
ErrorMessage = ErrorMessage + "Select Customer State.<br>";
}
if (MCust_ShippTo_State_ID.SelectedIndex == 0)
{
ErrorMessage = ErrorMessage + "Select Customer Shipp To State.<br>";
}
if (ErrorMessage.Length == 0)
{
using (TransactionScope scope = new TransactionScope())
{
if (Convert.ToInt32(M_Cust_ID.Text) == 0)
{
ObjAT_Cust.Fk_Company_ID = SessionUserData.Company.CompanyID;
ObjAT_Cust.Fk_Branch_ID = SessionUserData.Company.BranchID;
ObjAT_Cust.Fk_Year_ID = SessionUserData.Company.YearID;
ObjAT_Cust.MDBSC_RowCreatedByUser_ID = SessionUserData.UserData.UserID;
ObjAT_Cust.MDBSC_RowCreatedByUserName = SessionUserData.UserData.UserName;
ObjAT_Cust.MCust_Code = MaheshAF18.Application.MEF.GenrateRefNo(SessionUserData.Company.CompanyID, SessionUserData.Company.BranchID, 0, "Customer", "CUST", "CUST", "No", "", "", "", 0);
}
SetValuesToBO();
ErrorMessage = ObjAT_Cust.Insert_Update(ObjAT_Cust);
M_Cust_ID.Text = ErrorMessage.Substring((ErrorMessage.IndexOf("|") + 1), (ErrorMessage.Length - ErrorMessage.IndexOf("|") - 1));
ErrorMessage = ErrorMessage.Substring((0), (ErrorMessage.IndexOf("|")));
scope.Complete();
}
SetValueToControls_Edit(Convert.ToInt64(M_Cust_ID.Text));
DisplayCustomMessageSummary(ErrorMessage);
}
else
{
DisplayCustomMessageSummary(ErrorMessage);
}
}
catch (Exception ex)
{
DisplayCustomMessageSummary("Failed Save Data");
}
}