public BusinessPartnerResponse ManageBusinessPartner(BusinessPartnerVM businessPartner)
{
using (ReceiptDAL reciptDal = new ReceiptDAL())
{
return(reciptDal.ManageBusinessPartner(businessPartner));
}
}
private void setBspLables(BusinessPartnerVM businessPartner)
{
isReceiptFormEnable = true;
lblSelectedName.Text = businessPartner.Name;
lblSelectedPhoneNumber.Text = businessPartner.contacts.First().PhoneNumber;
lblSelectedAddress.Text = businessPartner.addresses.First().Address;
ProductFormFieldValidation();
cmbPhoneNumber.Enabled = false;
txtName.Enabled = false;
txtAddress.Enabled = false;
}
private void phoneNumberValidateValue()
{
this.BusinessPartnerFormFieldValidation();
using (ReceiptBLL receipt = new ReceiptBLL())
{
BusinessPartnerContactDetails contact = this.contacts.Where(selectContact => selectContact.PhoneNumber.Trim().ToUpper() == cmbPhoneNumber.Text.Trim().ToUpper()).FirstOrDefault();
if (contact != null)
{
this.selectedBSP = receipt.GetBusinessPartnerByBSPId(contact.BusinessPartnerId);
txtName.Text = this.selectedBSP.Name;
txtAddress.Text = this.selectedBSP.addresses.First().Address;
}
}
}
public BusinessPartnerResponse ManageBusinessPartner(BusinessPartnerVM businessPartner)
{
SqlConnection connection = dbInstance.GetDBConnection();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
cmd = new SqlCommand("Manage_BusinessPartner", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BusinessPartnerData", JsonConvert.SerializeObject(businessPartner));
da = new SqlDataAdapter(cmd);
da.Fill(ds);
DataTable contactTable = ds.Tables[0];
return(this.GetBusinessPartnerResponse(contactTable));
}
private void btnCustomerAdd_Click(object sender, EventArgs e)
{
isReceiptFormEnable = false;
if (!isBusinessPartnerAvailable)
{
if (txtName.Text.Trim().Length > 0 &&
txtAddress.Text.Trim().Length > 0 &&
cmbPhoneNumber.Text.Trim().Length >= 10 &&
cmbPhoneNumber.Text.Trim().Length <= 12)
{
BusinessPartnerVM bspVM = new BusinessPartnerVM()
{
contacts = new List <BusinessPartnerContactDetails>(),
addresses = new List <BusinessPartnerAddressDetails>()
};
BusinessPartnerContactDetails bspContactVM;
BusinessPartnerAddressDetails bspAddressVM = new BusinessPartnerAddressDetails();
bspContactVM = this.contacts.Where(selectContact => selectContact.PhoneNumber.Trim().ToUpper() == cmbPhoneNumber.Text.Trim().ToUpper()).FirstOrDefault();
if (bspContactVM != null)
{
bspVM.Id = bspContactVM.BusinessPartnerId;
bspVM.mpt_StatusEnum = (int)BusinessPartnerStatusEnum.Active;
bspAddressVM.Id = this.selectedBSP.addresses.FirstOrDefault().Id;
}
else
{
bspContactVM = new BusinessPartnerContactDetails();
bspAddressVM = new BusinessPartnerAddressDetails();
bspContactVM.Id = 0;
bspContactVM.PhoneNumber = cmbPhoneNumber.Text;
bspContactVM.Email = "";
bspAddressVM.Id = 0;
}
bspVM.Name = txtName.Text;
bspAddressVM.Address = txtAddress.Text;
bspVM.contacts = bspVM.contacts.Append(bspContactVM);
bspVM.addresses = bspVM.addresses.Append(bspAddressVM);
using (ReceiptBLL receipt = new ReceiptBLL())
{
BusinessPartnerResponse bspResponse = receipt.ManageBusinessPartner(bspVM);
bspVM.Id = bspResponse.BusinessPartnerId;
bspContactVM = (from contact in bspVM.contacts
select contact).FirstOrDefault();
bspAddressVM = (from address in bspVM.addresses
select address).FirstOrDefault();
bspContactVM.BusinessPartnerId = bspResponse.BusinessPartnerId;
bspContactVM.Id = bspResponse.ContactId;
bspAddressVM.BusinessPartnerId = bspResponse.BusinessPartnerId;
bspAddressVM.Id = bspResponse.AddressId;
this.selectedBSP = bspVM;
this.setBspLables(this.selectedBSP);
this.btnCustomerAdd.Enabled = false;
this.btnCustomerReset.Enabled = false;
}
}
else
{
MessageBox.Show("Mandatory fields are missing");
}
}
else
{
this.setBspLables(this.selectedBSP);
}
}
public async Task <IActionResult> PostBPMaster(BusinessPartnerVM VM)
{
bool IsCreate = true, IsRecordFound = false;
SAPEntity.Instance.InitializeCompany();
if (SAPEntity.Company.Connected)
{
SAPbobsCOM.BusinessPartners SAPBusinessPartner = (SAPbobsCOM.BusinessPartners)SAPEntity.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oBusinessPartners);
if (!string.IsNullOrEmpty(VM.cardcode) && SAPBusinessPartner.GetByKey(VM.cardcode))
{
IsCreate = false;
}
else
{
SAPBusinessPartner.CardCode = _BPrepo.GetNewCardCodeForLead("L");
SAPBusinessPartner.CardType = BoCardTypes.cLid;
}
if (VM.Type == "Portfolio")
{
SAPBusinessPartner.CardType = BoCardTypes.cCustomer;
}
SAPBusinessPartner.CardName = VM.cardname;
SAPBusinessPartner.EmailAddress = VM.email;
SAPBusinessPartner.Website = VM.website;
SAPBusinessPartner.Phone1 = VM.telephone;
SAPBusinessPartner.Notes = VM.sector;
SAPBusinessPartner.Currency = VM.currency;
SAPBusinessPartner.FreeText = VM.Notes;
//adress
for (var i = 0; i <= SAPBusinessPartner.Addresses.Count - 1; i++)
{
IsRecordFound = false;
SAPBusinessPartner.Addresses.SetCurrentLine(i);
if (SAPBusinessPartner.Addresses.AddressName == VM.temp_address && SAPBusinessPartner.Addresses.AddressType == BoAddressType.bo_ShipTo &&
SAPBusinessPartner.Addresses.RowNum == Convert.ToInt32(VM.lineNum) && SAPBusinessPartner.Addresses.BPCode == SAPBusinessPartner.CardCode)
{
IsRecordFound = true;
break;
}
}
if (!IsRecordFound)
{
SAPBusinessPartner.Addresses.SetCurrentLine(SAPBusinessPartner.Addresses.Count - 1);
if (!string.IsNullOrEmpty(SAPBusinessPartner.Addresses.AddressName))
{
SAPBusinessPartner.Addresses.Add();
}
SAPBusinessPartner.Addresses.SetCurrentLine(SAPBusinessPartner.Addresses.Count - 1);
}
SAPBusinessPartner.Addresses.SetCurrentLine(SAPBusinessPartner.Addresses.Count - 1);
SAPBusinessPartner.Addresses.AddressType = BoAddressType.bo_ShipTo;
SAPBusinessPartner.Addresses.AddressName = VM.adressname;
SAPBusinessPartner.Addresses.Street = VM.street;
SAPBusinessPartner.Addresses.AddressName2 = VM.landmark;
SAPBusinessPartner.Addresses.Country = VM.country;
SAPBusinessPartner.Addresses.State = VM.state;
SAPBusinessPartner.Addresses.City = VM.city;
SAPBusinessPartner.Addresses.ZipCode = VM.zipcode;
//GST
if (!string.IsNullOrEmpty(VM.gstin))
{
SAPBusinessPartner.Addresses.GstType = BoGSTRegnTypeEnum.gstRegularTDSISD;
SAPBusinessPartner.Addresses.GSTIN = VM.gstin;
}
//Contact person
if (!string.IsNullOrEmpty(VM.pfname))
{
IsRecordFound = false;
for (var i = 0; i <= SAPBusinessPartner.ContactEmployees.Count - 1; i++)
{
SAPBusinessPartner.ContactEmployees.SetCurrentLine(i);
if (SAPBusinessPartner.ContactEmployees.InternalCode == Convert.ToInt32(VM.pcntctCode))
{
IsRecordFound = true;
SAPBusinessPartner.ContactEmployees.SetCurrentLine(i);
break;
}
}
if (!IsRecordFound)
{
SAPBusinessPartner.ContactEmployees.SetCurrentLine(SAPBusinessPartner.ContactEmployees.Count - 1);
if (!string.IsNullOrEmpty(SAPBusinessPartner.ContactEmployees.Name))
{
SAPBusinessPartner.ContactEmployees.Add();
}
SAPBusinessPartner.ContactEmployees.SetCurrentLine(SAPBusinessPartner.ContactEmployees.Count - 1);
}
SAPBusinessPartner.ContactEmployees.Name = VM.pfname + " " + VM.plname;
SAPBusinessPartner.ContactEmployees.FirstName = VM.pfname;
SAPBusinessPartner.ContactEmployees.LastName = VM.plname;
SAPBusinessPartner.ContactEmployees.MobilePhone = VM.pmobile;
SAPBusinessPartner.ContactEmployees.E_Mail = VM.pemail;
SAPBusinessPartner.ContactEmployees.Phone1 = VM.ptel;
SAPBusinessPartner.ContactEmployees.Position = VM.pposition;
}
if (!string.IsNullOrEmpty(VM.sfname))
{
IsRecordFound = false;
for (var i = 0; i <= SAPBusinessPartner.ContactEmployees.Count - 1; i++)
{
SAPBusinessPartner.ContactEmployees.SetCurrentLine(i);
if (SAPBusinessPartner.ContactEmployees.InternalCode == Convert.ToInt32(VM.scntctCode))
{
IsRecordFound = true;
SAPBusinessPartner.ContactEmployees.SetCurrentLine(i);
break;
}
}
if (!IsRecordFound)
{
SAPBusinessPartner.ContactEmployees.SetCurrentLine(SAPBusinessPartner.ContactEmployees.Count - 1);
if (!string.IsNullOrEmpty(SAPBusinessPartner.ContactEmployees.Name))
{
SAPBusinessPartner.ContactEmployees.Add();
}
SAPBusinessPartner.ContactEmployees.SetCurrentLine(SAPBusinessPartner.ContactEmployees.Count - 1);
}
SAPBusinessPartner.ContactEmployees.Title = "Mr/Mrs";
SAPBusinessPartner.ContactEmployees.Name = VM.sfname + " " + VM.slname;
SAPBusinessPartner.ContactEmployees.FirstName = VM.sfname;
SAPBusinessPartner.ContactEmployees.LastName = VM.slname;
SAPBusinessPartner.ContactEmployees.MobilePhone = VM.smobile;
SAPBusinessPartner.ContactEmployees.E_Mail = VM.semail;
SAPBusinessPartner.ContactEmployees.Phone1 = VM.stel;
SAPBusinessPartner.ContactEmployees.Position = VM.sposition;
}
if (!string.IsNullOrEmpty(VM.pan))
{
IsRecordFound = false;
for (var i = 0; i <= SAPBusinessPartner.FiscalTaxID.Count - 1; i++)
{
SAPBusinessPartner.FiscalTaxID.SetCurrentLine(i);
if (SAPBusinessPartner.FiscalTaxID.BPCode == SAPBusinessPartner.CardCode && SAPBusinessPartner.FiscalTaxID.Address == SAPBusinessPartner.Address)
{
IsRecordFound = true;
break;
}
}
if (!IsRecordFound)
{
SAPBusinessPartner.FiscalTaxID.SetCurrentLine(SAPBusinessPartner.FiscalTaxID.Count - 1);
if (!string.IsNullOrEmpty(SAPBusinessPartner.FiscalTaxID.BPCode))
{
SAPBusinessPartner.FiscalTaxID.Add();
}
SAPBusinessPartner.FiscalTaxID.SetCurrentLine(SAPBusinessPartner.FiscalTaxID.Count - 1);
}
SAPBusinessPartner.FiscalTaxID.TaxId0 = VM.pan;
}
if (IsCreate)
{
if (SAPBusinessPartner.Add() == 0)
{
string ObjCode;
SAPEntity.Company.GetNewObjectCode(out ObjCode);
return(StatusCode(201));
}
else
{
string Message = SAPEntity.Company.GetLastErrorDescription();
return(BadRequest(Message));
}
}
else
{
if (SAPBusinessPartner.Update() == 0)
{
string ObjCode;
SAPEntity.Company.GetNewObjectCode(out ObjCode);
return(StatusCode(201));
}
else
{
string Message = SAPEntity.Company.GetLastErrorDescription();
return(BadRequest(Message));
}
}
}
return(BadRequest("not able to connect sap."));
}
