//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"); } }