/// <summary>
///
/// </summary>
/// <param name="vendor"></param>
/// <param name="company"></param>
/// <returns></returns>
public Response VendorCreateUpdate(PMVendor vendor, string company)
{
var response = new Response();
string VendorXML;
string server = ConfigKey.ReadSetting("SERVER");
//var server = Properties.Settings.Default.SERVER.ToString();
string CNX = "data source=" + server + ";initial catalog=" + company + ";integrated security=SSPI;persist security info=False;packet size=4096";
var eConnect = new eConnectRequest();
taUpdateCreateVendorRcd pmVendorCreateUpdate;
try
{
pmVendorCreateUpdate = SetVendorValues(vendor);
VendorXML = SerializeVendor(pmVendorCreateUpdate);
response = eConnect.CreateGPMaster(CNX, VendorXML);
return(response);
}
catch (Exception ex)
{
response = new Response();
response.SUCCESS = false;
response.MESSAGE = ex.Message;
response.STACK = ex.StackTrace;
return(response);
}
}
public bool SaveDataOnPMVendors(PMVendorsEntity item)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
var vendorID = db.Vendors.Where(v => v.VendorName.Contains(item.Vendor)).Select(a => a.VendorId).FirstOrDefault();
PMVendor PV = new PMVendor();
PV.PMVendorId = Guid.NewGuid();
PV.PMHeader = item.PMHeader;
PV.Vendor = vendorID;
PV.WONTE = item.WONTE;
PV.Description = item.Description;
db.PMVendors.Add(PV);
db.SaveChanges();
}
catch (Exception ex)
{
throw (ex);
}
}
return(true);
}
/// <summary>
///
/// </summary>
/// <param name="vendor"></param>
/// <param name="company"></param>
/// <returns></returns>
public Response CreateUpdateVendor(PMVendor vendor, string company)
{
PMVendorCreateUpdate createVendor = new PMVendorCreateUpdate();
return(createVendor.VendorCreateUpdate(vendor, company));
}
/// <summary>
///
/// </summary>
/// <param name="vendor"></param>
/// <returns></returns>
private taUpdateCreateVendorRcd SetVendorValues(PMVendor vendor)
{
var pmVendorCreateUpdate = new taUpdateCreateVendorRcd();
try
{
pmVendorCreateUpdate.VENDORID = vendor.VENDORID;
pmVendorCreateUpdate.VENDNAME = vendor.VENDNAME;
pmVendorCreateUpdate.VENDSHNM = vendor.VENDSHNM;
pmVendorCreateUpdate.VNDCHKNM = vendor.VNDCHKNM;
pmVendorCreateUpdate.HOLD = vendor.HOLD.GetValueOrDefault();
pmVendorCreateUpdate.VENDSTTS = vendor.VENDSTTS.GetValueOrDefault();
pmVendorCreateUpdate.VNDCLSID = vendor.VNDCLSID;
pmVendorCreateUpdate.VADDCDPR = vendor.VADDCDPR;
pmVendorCreateUpdate.VNDCNTCT = vendor.VNDCNTCT;
pmVendorCreateUpdate.ADDRESS1 = vendor.ADDRESS1;
pmVendorCreateUpdate.ADDRESS2 = vendor.ADDRESS2;
pmVendorCreateUpdate.ADDRESS3 = vendor.ADDRESS3;
pmVendorCreateUpdate.CITY = vendor.CITY;
pmVendorCreateUpdate.STATE = vendor.STATE;
pmVendorCreateUpdate.ZIPCODE = vendor.ZIPCODE;
pmVendorCreateUpdate.CCode = vendor.CCode;
pmVendorCreateUpdate.COUNTRY = vendor.COUNTRY;
pmVendorCreateUpdate.PHNUMBR1 = vendor.PHNUMBR1;
pmVendorCreateUpdate.PHNUMBR2 = vendor.PHNUMBR2;
pmVendorCreateUpdate.PHNUMBR3 = vendor.PHNUMBR3;
pmVendorCreateUpdate.FAXNUMBR = vendor.FAXNUMBR;
pmVendorCreateUpdate.TAXSCHID = vendor.TAXSCHID;
pmVendorCreateUpdate.SHIPMTHD = vendor.SHIPMTHD;
pmVendorCreateUpdate.UPSZONE = vendor.UPSZONE;
pmVendorCreateUpdate.VADCDPAD = vendor.VADCDPAD;
pmVendorCreateUpdate.VADCDTRO = vendor.VADCDTRO;
pmVendorCreateUpdate.VADCDSFR = vendor.VADCDSFR;
pmVendorCreateUpdate.ACNMVNDR = vendor.ACNMVNDR;
pmVendorCreateUpdate.COMMENT1 = vendor.COMMENT1;
pmVendorCreateUpdate.COMMENT2 = vendor.COMMENT2;
pmVendorCreateUpdate.NOTETEXT = vendor.NOTETEXT;
pmVendorCreateUpdate.CURNCYID = vendor.CURNCYID;
pmVendorCreateUpdate.RATETPID = vendor.RATETPID;
pmVendorCreateUpdate.PYMTRMID = vendor.PYMTRMID;
pmVendorCreateUpdate.DISGRPER = vendor.DISGRPER.GetValueOrDefault();
pmVendorCreateUpdate.DUEGRPER = vendor.DUEGRPER.GetValueOrDefault();
pmVendorCreateUpdate.PYMNTPRI = vendor.PYMNTPRI;
pmVendorCreateUpdate.MINORDER = vendor.MINORDER.GetValueOrDefault();
pmVendorCreateUpdate.TRDDISCT = vendor.TRDDISCT.GetValueOrDefault();
pmVendorCreateUpdate.TXIDNMBR = vendor.TXIDNMBR;
pmVendorCreateUpdate.TXRGNNUM = vendor.TXRGNNUM;
pmVendorCreateUpdate.CHEKBKID = vendor.CHEKBKID;
pmVendorCreateUpdate.USERDEF1 = vendor.USERDEF1;
pmVendorCreateUpdate.USERDEF2 = vendor.USERDEF2;
pmVendorCreateUpdate.TEN99TYPE = vendor.TEN99TYPE.GetValueOrDefault();
pmVendorCreateUpdate.TEN99BOXNUMBER = vendor.TEN99BOXNUMBER.GetValueOrDefault();
pmVendorCreateUpdate.FREEONBOARD = vendor.FREEONBOARD.GetValueOrDefault();
pmVendorCreateUpdate.USERLANG = vendor.USERLANG.GetValueOrDefault();
pmVendorCreateUpdate.MINPYTYP = vendor.MINPYTYP.GetValueOrDefault();
pmVendorCreateUpdate.MINPYDLR = vendor.MINPYDLR.GetValueOrDefault();
pmVendorCreateUpdate.MINPYPCT = vendor.MINPYPCT.GetValueOrDefault();
pmVendorCreateUpdate.MXIAFVND = vendor.MXIAFVND.GetValueOrDefault();
pmVendorCreateUpdate.MAXINDLR = vendor.MAXINDLR.GetValueOrDefault();
pmVendorCreateUpdate.CREDTLMT = vendor.CREDTLMT.GetValueOrDefault();
pmVendorCreateUpdate.CRLMTDLR = vendor.CRLMTDLR.GetValueOrDefault();
pmVendorCreateUpdate.WRITEOFF = vendor.WRITEOFF.GetValueOrDefault();
pmVendorCreateUpdate.MXWOFAMT = vendor.MXWOFAMT.GetValueOrDefault();
pmVendorCreateUpdate.Revalue_Vendor = vendor.Revalue_Vendor.GetValueOrDefault();
pmVendorCreateUpdate.Post_Results_To = vendor.Post_Results_To.GetValueOrDefault();
pmVendorCreateUpdate.KPCALHST = vendor.KPCALHST.GetValueOrDefault();
pmVendorCreateUpdate.KPERHIST = vendor.KPERHIST.GetValueOrDefault();
pmVendorCreateUpdate.KPTRXHST = vendor.KPTRXHST.GetValueOrDefault();
pmVendorCreateUpdate.KGLDSTHS = vendor.KGLDSTHS.GetValueOrDefault();
pmVendorCreateUpdate.PTCSHACF = vendor.PTCSHACF.GetValueOrDefault();
pmVendorCreateUpdate.PMCSHACTNUMST = vendor.PMCSHACTNUMST;
pmVendorCreateUpdate.PMAPACTNUMST = vendor.PMAPACTNUMST;
pmVendorCreateUpdate.PMDAVACTNUMST = vendor.PMDAVACTNUMST;
pmVendorCreateUpdate.PMDTKACTNUMST = vendor.PMDTKACTNUMST;
pmVendorCreateUpdate.PMFINACTNUMST = vendor.PMFINACTNUMST;
pmVendorCreateUpdate.PMPRCHACTNUMST = vendor.PMPRCHACTNUMST;
pmVendorCreateUpdate.PMTDSCACTNUMST = vendor.PMTDSCACTNUMST;
pmVendorCreateUpdate.PMMSCHACTNUMST = vendor.PMMSCHACTNUMST;
pmVendorCreateUpdate.PMFRTACTNUMST = vendor.PMFRTACTNUMST;
pmVendorCreateUpdate.PMTAXACTNUMST = vendor.PMTAXACTNUMST;
pmVendorCreateUpdate.PMWRTACTNUMST = vendor.PMWRTACTNUMST;
pmVendorCreateUpdate.ACPURACTNUMST = vendor.ACPURACTNUMST;
pmVendorCreateUpdate.PURPVACTNUMST = vendor.PURPVACTNUMST;
pmVendorCreateUpdate.UseVendorClass = vendor.UseVendorClass.GetValueOrDefault();
pmVendorCreateUpdate.CreateAddress = vendor.CreateAddress.GetValueOrDefault();
pmVendorCreateUpdate.UpdateIfExists = vendor.UpdateIfExists.GetValueOrDefault();
pmVendorCreateUpdate.RequesterTrx = vendor.RequesterTrx.GetValueOrDefault();
return(pmVendorCreateUpdate);
}
catch (Exception)
{
throw;
}
}
