public string addBp()
{
string result = "";
SAPbobsCOM.BusinessPartners defbp = (SAPbobsCOM.BusinessPartners)Program.objHrmsUI.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oBusinessPartners);
defbp.GetByKey("W-00006935");
SAPbobsCOM.BusinessPartners bp = (SAPbobsCOM.BusinessPartners)Program.objHrmsUI.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oBusinessPartners);
bp.CardCode = dtCard.GetValue("CardCode", 0).ToString();;
bp.CardType = SAPbobsCOM.BoCardTypes.cCustomer;
bp.CardName = dtCard.GetValue("BName", 0).ToString();;
bp.Phone1 = dtCard.GetValue("CTel", 0).ToString();;
bp.EmailAddress = dtCard.GetValue("CEmail", 0).ToString();;
bp.FederalTaxID = "EX";
bp.GroupCode = defbp.GroupCode;
bp.PayTermsGrpCode = defbp.PayTermsGrpCode;
bp.DownPaymentClearAct = defbp.DownPaymentClearAct;
bp.DefaultAccount = defbp.DefaultAccount;
bp.DebitorAccount = defbp.DebitorAccount;
bp.ContactEmployees.Name = dtCard.GetValue("CNID", 0).ToString();;
bp.ContactEmployees.Phone1 = dtCard.GetValue("CNTel", 0).ToString();;
bp.ContactEmployees.E_Mail = dtCard.GetValue("CNEmail", 0).ToString();;
bp.Addresses.AddressType = SAPbobsCOM.BoAddressType.bo_BillTo;
bp.Addresses.AddressName = dtCard.GetValue("BName", 0).ToString();;
bp.Addresses.Street = dtCard.GetValue("BStPO", 0).ToString();;
bp.Addresses.City = dtCard.GetValue("BCity", 0).ToString();;
string statecode = StateCode(dtCard.GetValue("BState", 0).ToString());
if (statecode != "")
{
bp.Addresses.State = statecode;
}
bp.Addresses.ZipCode = dtCard.GetValue("BZip", 0).ToString();;
bp.Addresses.UserFields.Fields.Item("U_PhoneNum").Value = dtCard.GetValue("BTel", 0).ToString();;
bp.Addresses.UserFields.Fields.Item("U_EMail").Value = dtCard.GetValue("BEmail", 0).ToString();;
bp.Addresses.TaxCode = "EX";
bp.Addresses.Add();
bp.Addresses.AddressType = SAPbobsCOM.BoAddressType.bo_ShipTo;
bp.Addresses.AddressName = "S-" + dtCard.GetValue("SName", 0).ToString();;
bp.Addresses.Street = dtCard.GetValue("SStPO", 0).ToString();;
bp.Addresses.City = dtCard.GetValue("SCity", 0).ToString();;
statecode = StateCode(dtCard.GetValue("SState", 0).ToString()).ToString();;
if (statecode != "")
{
bp.Addresses.State = statecode;
}
bp.Addresses.ZipCode = dtCard.GetValue("SZip", 0).ToString();
bp.Addresses.UserFields.Fields.Item("U_PhoneNum").Value = dtCard.GetValue("STel", 0);
bp.Addresses.UserFields.Fields.Item("U_EMail").Value = dtCard.GetValue("SEmail", 0);
bp.Addresses.TaxCode = "EX";
bp.Addresses.Add();
int bpSuccess = bp.Add();
if (bpSuccess != 0)
{
int erroCode = 0;
string errDescr = "";
Program.objHrmsUI.oCompany.GetLastError(out erroCode, out errDescr);
oApplication.StatusBar.SetText("Failed to add BP : " + errDescr);
}
return(result);
}
public string postDocument()
{
Program.objHrmsUI.loadSettings();
string outStr = "";
string TaxCode = Program.objHrmsUI.getSetting("TAX").ToString();
try
{
if (dtORDR.Rows.Count == 0)
{
return("No Items");
}
SAPbobsCOM.Documents Doc = (SAPbobsCOM.Documents)Program.objHrmsUI.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oPurchaseOrders);
SAPbobsCOM.BusinessPartners bp = (SAPbobsCOM.BusinessPartners)Program.objHrmsUI.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oBusinessPartners);
bool bpexist = bp.GetByKey(dtHead.GetValue("CardCode", 0).ToString());
Doc.CardCode = dtHead.GetValue("CardCode", 0).ToString();
Doc.DocDate = Convert.ToDateTime(dtHead.GetValue("InvDate", 0));
Doc.DocDueDate = Convert.ToDateTime(dtHead.GetValue("InvDate", 0));
// Doc.SalesPersonCode = Convert.ToInt16( Program.objHrmsUI.settings["WebSlpCode"].ToString());
Doc.PickRemark = "LTD A/R Invoice " + dtHead.GetValue("InvNum", 0).ToString(); // dtORDR.GetValue("NumAtCard", 0).ToString();
Doc.NumAtCard = "LTD Inv # " + dtHead.GetValue("InvNum", 0).ToString();
Doc.Comments = dtHead.GetValue("REM", 0).ToString();
Doc.DiscountPercent = Convert.ToDouble(dtHead.GetValue("DP", 0));
int ItemLineNum = -1;
for (int i = 0; i < dtRDR1.Rows.Count; i++)
{
if (dtRDR1.GetValue("ItemCode", i).ToString() != "")
{
Doc.Lines.ItemCode = dtRDR1.GetValue("ItemCode", i).ToString();
Doc.Lines.ItemDescription = dtRDR1.GetValue("ItemName", i).ToString(); //rs.Fields.Item("ItemName").Value;
Doc.Lines.Quantity = Convert.ToDouble(dtRDR1.GetValue("Qty", i));
Doc.Lines.UnitPrice = Convert.ToDouble(dtRDR1.GetValue("Price", i));
Doc.Lines.DiscountPercent = Convert.ToDouble(dtRDR1.GetValue("DiscP", i));
Doc.Lines.UoMEntry = getUomEntry(dtRDR1.GetValue("UOM", i).ToString());
// Doc.Lines.VatGroup = TaxCode.ToString();
Doc.Lines.TaxCode = TaxCode;
Doc.Lines.Add();
ItemLineNum++;
}
else
{
Doc.SpecialLines.LineType = SAPbobsCOM.BoDocSpecialLineType.dslt_Text;
Doc.SpecialLines.LineText = dtRDR1.GetValue("ItemName", i).ToString();
Doc.SpecialLines.AfterLineNumber = ItemLineNum;
Doc.SpecialLines.Add();
}
}
try
{
if (Doc.Add() != 0)
{
int erroCode = 0;
string errDescr = "";
Program.objHrmsUI.oCompany.GetLastError(out erroCode, out errDescr);
outStr = "Error:" + errDescr + outStr;
oApplication.StatusBar.SetText("Failed to post Order : " + errDescr);
}
else
{
outStr = Convert.ToString(Program.objHrmsUI.oCompany.GetNewObjectKey());
}
}
catch (Exception ex)
{
oApplication.StatusBar.SetText("Failed in Exec Query on Posting Document. : " + ex.Message);
}
finally
{
}
}
catch (Exception ex)
{
oApplication.SetStatusBarMessage("Error in posting document : " + ex.Message);
}
return(outStr);
}
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."));
}