public bool SaveCustomer(mdlBusinessPartner objMdlBusinessPartner, string operation) { bool isSaved = false; if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); SqlTransaction transaction = con.BeginTransaction(); try { SqlCommand cmd = new SqlCommand("stp_ERP_BusinessPartner_CRUD", con, transaction); cmd.Parameters.Clear(); cmd.Parameters.Add("@pk_PartnerID", SqlDbType.VarChar, 6).Value = objMdlBusinessPartner.PkBusinessPartnerId; cmd.Parameters.Add("@PartnerCategory", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PartnerCatagory; cmd.Parameters.Add("@PartnerName", SqlDbType.VarChar, 100).Value = objMdlBusinessPartner.PartnerName; cmd.Parameters.Add("@Remarks", SqlDbType.VarChar, 250).Value = objMdlBusinessPartner.Remarks; cmd.Parameters.Add("@Discontinued", SqlDbType.Bit).Value = objMdlBusinessPartner.Discontinued; cmd.Parameters.Add("@Datefrom", SqlDbType.Date).Value = objMdlBusinessPartner.Datefrom; cmd.Parameters.Add("@DateTo", SqlDbType.Date).Value = objMdlBusinessPartner.DateTo; cmd.Parameters.Add("@PCCompanyType", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PcCompanyType; cmd.Parameters.Add("@PCNTN", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.Pcntn; cmd.Parameters.Add("@PCSTR", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.Pcstr; cmd.Parameters.Add("@PCOtherIdentity", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PcOtherIdentity; cmd.Parameters.Add("@PCPhone1", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PcPhone1; cmd.Parameters.Add("@PCPhone2", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PcPhone2; cmd.Parameters.Add("@PCMobile1", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PcMobile1; cmd.Parameters.Add("@PCMobile2", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PcMobile2; cmd.Parameters.Add("@PCFax", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PcFax; cmd.Parameters.Add("@PCPostalCode", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PcPostalCode; cmd.Parameters.Add("@PCEmail", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PcEmail; cmd.Parameters.Add("@PCWebsite", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PcWebsite; cmd.Parameters.Add("@PCBusinessStartDate", SqlDbType.Date).Value = objMdlBusinessPartner.PcBusinessStartDate; cmd.Parameters.Add("@PCMailingAddress", SqlDbType.VarChar, 150).Value = objMdlBusinessPartner.PcMailingAddress; cmd.Parameters.Add("@PCClassification", SqlDbType.VarChar, 1).Value = objMdlBusinessPartner.PcClassification; cmd.Parameters.Add("@PLCountry", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PlCountry; cmd.Parameters.Add("@PLProvience", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PlProvience; cmd.Parameters.Add("@PLCity", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PlCity; cmd.Parameters.Add("@PLAddress", SqlDbType.VarChar, 150).Value = objMdlBusinessPartner.PlAddress; cmd.Parameters.Add("@PLReciverperson", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PlReciverperson; cmd.Parameters.Add("@PLPostalcode", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PlPostalcode; cmd.Parameters.Add("@PaymentMode", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PaymentMode; cmd.Parameters.Add("@CreditLimit", SqlDbType.Decimal).Value = objMdlBusinessPartner.CreditLimit; cmd.Parameters.Add("@CreditDays", SqlDbType.Decimal).Value = objMdlBusinessPartner.CreditDays; cmd.Parameters.Add("@PaymentsDates", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PaymentsDates; cmd.Parameters.Add("@PaymentDays", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PaymentDays; cmd.Parameters.Add("@SaleBaseDays", SqlDbType.Decimal).Value = objMdlBusinessPartner.SaleBaseDays; cmd.Parameters.Add("@DunningTerms", SqlDbType.Bit).Value = objMdlBusinessPartner.DunningTerms; cmd.Parameters.Add("@IntrestPercentage", SqlDbType.Decimal).Value = objMdlBusinessPartner.IntrestPercentage; cmd.Parameters.Add("@DishnorPercentage", SqlDbType.Decimal).Value = objMdlBusinessPartner.DishnorPercentage; cmd.Parameters.Add("@Holiday", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.Holiday; cmd.Parameters.Add("@IntrestonAreas", SqlDbType.Bit).Value = objMdlBusinessPartner.IntrestonAreas; cmd.Parameters.Add("@AutoPostingofDishnor", SqlDbType.Bit).Value = objMdlBusinessPartner.AutoPostingofDishnor; cmd.Parameters.Add("@GLAccount", SqlDbType.VarChar, 14).Value = objMdlBusinessPartner.GlAccount; cmd.Parameters.Add("@ConsolidateAccount", SqlDbType.VarChar, 6).Value = objMdlBusinessPartner.ConsolidateAccount; cmd.Parameters.Add("@WHITStatus", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.WhitStatus; cmd.Parameters.Add("@WHITERefrence", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.WhiteRefrence; cmd.Parameters.Add("@Validfrom", SqlDbType.Date).Value = objMdlBusinessPartner.Validfrom; cmd.Parameters.Add("@Validto", SqlDbType.Date).Value = objMdlBusinessPartner.Validto; cmd.Parameters.Add("@WHITRate", SqlDbType.Decimal).Value = objMdlBusinessPartner.WhitRate; cmd.Parameters.Add("@WHSTStatus", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.WhstStatus; cmd.Parameters.Add("@PGroup", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PGroup; cmd.Parameters.Add("@ForBMCSubBrickId", SqlDbType.VarChar, 6).Value = objMdlBusinessPartner.ForBmcSubBrickId; cmd.Parameters.Add("@QualifyPerson", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.QualifyPerson; cmd.Parameters.Add("@AddUser", SqlDbType.VarChar, 16).Value = objMdlBusinessPartner.AddUser; cmd.Parameters.Add("@OldCode", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.OldCode; cmd.Parameters.Add("@AddGroup", SqlDbType.VarChar, 6).Value = objMdlBusinessPartner.AddGroup; if (operation == "Save") { cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 20).Value = "SaveMaster"; } else if (operation == "Update") { cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 20).Value = "Update"; } cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); SaveBusinessPartnerDetails(objMdlBusinessPartner, transaction, cmd); transaction.Commit(); isSaved = true; if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { transaction.Rollback(); MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error); isSaved = false; if (con.State == ConnectionState.Open) { con.Close(); } } return isSaved; }
private void SaveBusinessPartnerDetails(mdlBusinessPartner objMdlBusinessPartner, SqlTransaction transaction, SqlCommand cmd) { #region Contact Person //Delete Contact Person Information if (objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows.Count > 0) { cmd = new SqlCommand("Delete from D_BusinessPartner_ContactPerson where FK_PartnerID='" + objMdlBusinessPartner.PkBusinessPartnerId + "' AND FK_PartnerCategory = '"+ objMdlBusinessPartner.PartnerCatagory +"'", con, transaction); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } //Inserting Contact Person Information for (int i = 0; i <= objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows.Count - 1; i++) { cmd = new SqlCommand("stp_ERP_BusinessPartner_CRUD", con, transaction); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.Add("@pk_PartnerID", SqlDbType.VarChar, 6).Value = objMdlBusinessPartner.PkBusinessPartnerId; cmd.Parameters.Add("@PartnerCategory", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PartnerCatagory; cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows[i]["First Name"].ToString(); cmd.Parameters.Add("@LasTName", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows[i]["Last Name"].ToString(); cmd.Parameters.Add("@Department", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows[i]["Department"].ToString(); cmd.Parameters.Add("@Designation", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows[i]["Designation"].ToString(); cmd.Parameters.Add("@Phone1", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows[i]["Phone 1"].ToString(); cmd.Parameters.Add("@Phone2", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows[i]["Phone 2"].ToString(); cmd.Parameters.Add("@Mobile1", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows[i]["Mobile 1"].ToString(); cmd.Parameters.Add("@Mobile2", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows[i]["Mobile 2"].ToString(); cmd.Parameters.Add("@FaxNo", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows[i]["Fax No"].ToString(); cmd.Parameters.Add("@EmailID", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows[i]["Email ID"].ToString(); cmd.Parameters.Add("@SocialMediaID", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows[i]["Social Media ID"].ToString(); cmd.Parameters.Add("@Address", SqlDbType.VarChar, 150).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[1].Rows[i]["Address"].ToString(); cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 20).Value = "ContactPerson"; cmd.ExecuteNonQuery(); } #endregion #region Licenses Information //Delete Licenses Information if (objMdlBusinessPartner.DsBusinessPartners.Tables[4].Rows.Count > 0) { cmd = new SqlCommand("Delete from D_BusinessPartner_LicenceInformation where Fk_PartnerID='" + objMdlBusinessPartner.PkBusinessPartnerId + "' AND FK_PartnerCategory= '" + objMdlBusinessPartner.PartnerCatagory + "'", con, transaction); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } //Inserting Licenses Information for (int i = 0; i <= objMdlBusinessPartner.DsBusinessPartners.Tables[4].Rows.Count - 1; i++) { cmd = new SqlCommand("stp_ERP_BusinessPartner_CRUD", con, transaction); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.Add("@pk_PartnerID", SqlDbType.VarChar, 6).Value = objMdlBusinessPartner.PkBusinessPartnerId; cmd.Parameters.Add("@PartnerCategory", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PartnerCatagory; cmd.Parameters.Add("@LicenceType", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[4].Rows[i]["Liscense Type"].ToString(); cmd.Parameters.Add("@LicenceNumber", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[4].Rows[i]["Liscense No."].ToString(); cmd.Parameters.Add("@ExpiryDate", SqlDbType.Date).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[4].Rows[i]["Expiry Date"].ToString(); cmd.Parameters.Add("@ReceiptDate", SqlDbType.Date).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[4].Rows[i]["Receipt Date"].ToString(); cmd.Parameters.Add("@BlockDate", SqlDbType.Date).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[4].Rows[i]["Block Date"].ToString(); cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 20).Value = "LicenseInformation"; cmd.ExecuteNonQuery(); } #endregion #region Bank Particulars //Delete Bank Particulars Information if (objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows.Count > 0) { cmd = new SqlCommand("Delete from D_BusinessPartner_BankParticulars where FK_BusinessPartnerID='" + objMdlBusinessPartner.PkBusinessPartnerId + "' AND FK_PartnerCategory= '" + objMdlBusinessPartner.PartnerCatagory + "'", con, transaction); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } //Inserting Bank Particulars Information for (int i = 0; i <= objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows.Count - 1; i++) { cmd = new SqlCommand("stp_ERP_BusinessPartner_CRUD", con, transaction); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.Add("@pk_PartnerID", SqlDbType.VarChar, 6).Value = objMdlBusinessPartner.PkBusinessPartnerId; cmd.Parameters.Add("@PartnerCategory", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PartnerCatagory; cmd.Parameters.Add("@AccountNo", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows[i]["Account No"].ToString(); cmd.Parameters.Add("@BankCountry", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows[i]["Bank Country"].ToString(); cmd.Parameters.Add("@BankName", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows[i]["Bank Name"].ToString(); cmd.Parameters.Add("@BankCode", SqlDbType.VarChar, 10).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows[i]["Bank Code"].ToString(); cmd.Parameters.Add("@BranchName", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows[i]["Branch Name"].ToString(); cmd.Parameters.Add("@BranchAddress", SqlDbType.VarChar, 150).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows[i]["Branch Address"].ToString(); cmd.Parameters.Add("@AccountTitle", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows[i]["Account Title"].ToString(); cmd.Parameters.Add("@SwiftCode", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows[i]["Swift Code"].ToString(); cmd.Parameters.Add("@IBAN", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows[i]["IBAN"].ToString(); cmd.Parameters.Add("@CreditCardType", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows[i]["Credit Card Type"].ToString(); cmd.Parameters.Add("@CreditCardNo", SqlDbType.VarChar, 20).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows[i]["Credit Card No"].ToString(); cmd.Parameters.Add("@ExpiryDate", SqlDbType.DateTime).Value = Convert.ToDateTime(objMdlBusinessPartner.DsBusinessPartners.Tables[0].Rows[i]["Expiry Date"].ToString()); cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 20).Value = "BankParticulars"; cmd.ExecuteNonQuery(); } #endregion #region Booking Details //Delete Booking Details Information if (objMdlBusinessPartner.DsBusinessPartners.Tables[5].Rows.Count > 0) { cmd = new SqlCommand("Delete from D_BusinessPartner_BookingDetails where FK_PartnerID='" + objMdlBusinessPartner.PkBusinessPartnerId + "' AND FK_PartnerCategory= '" + objMdlBusinessPartner.PartnerCatagory + "'", con, transaction); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } //Inserting Booking Details Information for (int i = 0; i <= objMdlBusinessPartner.DsBusinessPartners.Tables[5].Rows.Count - 1; i++) { cmd = new SqlCommand("stp_ERP_BusinessPartner_CRUD", con, transaction); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.Add("@pk_PartnerID", SqlDbType.VarChar, 6).Value = objMdlBusinessPartner.PkBusinessPartnerId; cmd.Parameters.Add("@PartnerCategory", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PartnerCatagory; cmd.Parameters.Add("@Fk_OCGroupId", SqlDbType.VarChar, 9).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[5].Rows[i]["OCGroup ID"].ToString(); cmd.Parameters.Add("@WeekDay", SqlDbType.VarChar, 15).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[5].Rows[i]["Week Day"].ToString(); cmd.Parameters.Add("@Class", SqlDbType.VarChar, 15).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[5].Rows[i]["Class"].ToString(); cmd.Parameters.Add("@ContactTime", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[5].Rows[i]["Contact Time"].ToString(); cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 20).Value = "BookingDetails"; cmd.ExecuteNonQuery(); } #endregion #region Code Description //Delete Code Description Information if (objMdlBusinessPartner.DsBusinessPartners.Tables[5].Rows.Count > 0) { cmd = new SqlCommand("Delete from D_BusinessPartner_CodeDescription where FK_PartnerID='" + objMdlBusinessPartner.PkBusinessPartnerId + "' AND Category= '" + objMdlBusinessPartner.PartnerCatagory + "'", con, transaction); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } //Inserting Code Description Information for (int i = 0; i <= objMdlBusinessPartner.DsBusinessPartners.Tables[3].Rows.Count - 1; i++) { cmd = new SqlCommand("stp_ERP_BusinessPartner_CRUD", con, transaction); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.Add("@pk_PartnerID", SqlDbType.VarChar, 6).Value = objMdlBusinessPartner.PkBusinessPartnerId; cmd.Parameters.Add("@PartnerCategory", SqlDbType.VarChar, 50).Value = objMdlBusinessPartner.PartnerCatagory; cmd.Parameters.Add("@CompanyCode", SqlDbType.VarChar, 10).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[3].Rows[i]["Company Code"].ToString(); cmd.Parameters.Add("@CpmpanyRefID", SqlDbType.VarChar, 10).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[3].Rows[i]["Company Ref ID"].ToString(); cmd.Parameters.Add("@SubBrickID", SqlDbType.VarChar, 4).Value = objMdlBusinessPartner.DsBusinessPartners.Tables[3].Rows[i]["Sub Brick ID"].ToString(); cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 20).Value = "CodeDescription"; cmd.ExecuteNonQuery(); } #endregion #region Attachments //Inserting Attachment And Details Information for (int i = 0; i <= objMdlBusinessPartner.DsBusinessPartners.Tables[2].Rows.Count - 1; i++) { Thread.Sleep(1000); objSaveDownload.SendFile("BusinessPartnerId", objMdlBusinessPartner.PkBusinessPartnerId + objMdlBusinessPartner.PartnerCatagory, "FilePath", "D_BusinessPartner_Attachements", objMdlBusinessPartner.DsBusinessPartners.Tables[2].Rows[i]["File Path"].ToString(), objMdlBusinessPartner.DsBusinessPartners.Tables[2].Rows[i]["Remarks"].ToString(), objMdlBusinessPartner.DsBusinessPartners.Tables[2].Rows[i]["File Name"].ToString()); } #endregion }
public bool SaveCustomer(mdlBusinessPartner objMdlBusinessPartner, string operation) { return ObjDalBusinessPartner.SaveCustomer(objMdlBusinessPartner, operation); }