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