/// <summary>
/// update site
/// </summary>
/// <param name="site"></param>
/// <returns></returns>
public OperationResult UpdateSite(IV40700_Site site)
{
var operationResult = new OperationResult();
var existingSite = _dynamicsContext.IV40700_Site.FirstOrDefault(x => x.LOCNDSCR.ToLower() == site.LOCNDSCR.ToLower());
if (existingSite != null)
{
logger.Debug("Site is being updated.");
try
{
existingSite.LOCNCODE = site.LOCNCODE;
existingSite.LOCNDSCR = site.LOCNDSCR;
existingSite.NOTEINDX = site.NOTEINDX;
existingSite.ADDRESS1 = site.ADDRESS1;
existingSite.ADDRESS2 = site.ADDRESS2;
existingSite.ADDRESS3 = site.ADDRESS3;
existingSite.CITY = site.CITY;
existingSite.STATE = site.STATE;
existingSite.ZIPCODE = site.ZIPCODE;
existingSite.COUNTRY = site.COUNTRY;
existingSite.PHONE1 = site.PHONE1;
existingSite.PHONE2 = site.PHONE2;
existingSite.PHONE3 = site.PHONE3;
existingSite.FAXNUMBR = site.FAXNUMBR;
existingSite.Location_Segment = site.Location_Segment;
existingSite.STAXSCHD = site.STAXSCHD;
existingSite.PCTAXSCH = site.PCTAXSCH;
existingSite.INCLDDINPLNNNG = site.INCLDDINPLNNNG;
existingSite.PORECEIPTBIN = site.PORECEIPTBIN;
existingSite.PORETRNBIN = site.PORETRNBIN;
existingSite.SOFULFILLMENTBIN = site.SOFULFILLMENTBIN;
existingSite.SORETURNBIN = site.SORETURNBIN;
existingSite.BOMRCPTBIN = site.BOMRCPTBIN;
existingSite.MATERIALISSUEBIN = site.MATERIALISSUEBIN;
existingSite.WMSINT = site.WMSINT;
existingSite.PICKTICKETSITEOPT = site.PICKTICKETSITEOPT;
existingSite.BINBREAK = site.BINBREAK;
existingSite.CCode = site.CCode;
existingSite.DECLID = site.DECLID;
existingSite.INACTIVE = site.INACTIVE;
existingSite.DEX_ROW_ID = site.DEX_ROW_ID;
_dynamicsContext.SubmitChanges();
operationResult.Success = true;
operationResult.Message = "Success";
}
catch (Exception ex)
{
operationResult.Success = false;
operationResult.Message = "Error";
logger.ErrorFormat("Error while updating site: { 0} ", ex.ToString());
}
}
else
{
operationResult.Success = false;
operationResult.Message = "Unable to find selected site.";
}
return(operationResult);
}
/// <summary>
/// update salesperson
/// </summary>
/// <param name="salesperson"></param>
/// <returns></returns>
public OperationResult UpdateSalesperson(RM00301_Salesperson salesperson)
{
var operationResult = new OperationResult();
var existingSalesperson = _dynamicsContext.RM00301_Salesperson.FirstOrDefault(x => x.SLPRSNID.Replace(" ", string.Empty) == salesperson.SLPRSNID);
if (existingSalesperson != null)
{
logger.Debug("Salesperson is being updated.");
try
{
existingSalesperson.SLPRSNID = salesperson.SLPRSNID;
existingSalesperson.EMPLOYID = salesperson.EMPLOYID;
existingSalesperson.VENDORID = salesperson.VENDORID;
existingSalesperson.SLPRSNFN = salesperson.SLPRSNFN;
existingSalesperson.SPRSNSMN = salesperson.SPRSNSMN;
existingSalesperson.SPRSNSLN = salesperson.SPRSNSLN;
existingSalesperson.ADDRESS1 = salesperson.ADDRESS1;
existingSalesperson.ADDRESS2 = salesperson.ADDRESS2;
existingSalesperson.ADDRESS3 = salesperson.ADDRESS3;
existingSalesperson.CITY = salesperson.CITY;
existingSalesperson.STATE = salesperson.STATE;
existingSalesperson.ZIP = salesperson.ZIP;
existingSalesperson.COUNTRY = salesperson.COUNTRY;
existingSalesperson.PHONE1 = salesperson.PHONE1;
existingSalesperson.PHONE2 = salesperson.PHONE2;
existingSalesperson.PHONE3 = salesperson.PHONE3;
existingSalesperson.FAX = salesperson.FAX;
existingSalesperson.INACTIVE = salesperson.INACTIVE;
existingSalesperson.SALSTERR = salesperson.SALSTERR;
existingSalesperson.COMMCODE = salesperson.COMMCODE;
existingSalesperson.COMPRCNT = salesperson.COMPRCNT;
existingSalesperson.STDCPRCT = salesperson.STDCPRCT;
existingSalesperson.COMAPPTO = salesperson.COMAPPTO;
existingSalesperson.COSTTODT = salesperson.COSTTODT;
existingSalesperson.CSTLSTYR = salesperson.CSTLSTYR;
existingSalesperson.TTLCOMTD = salesperson.TTLCOMTD;
existingSalesperson.TTLCOMLY = salesperson.TTLCOMLY;
existingSalesperson.COMSLTDT = salesperson.COMSLTDT;
existingSalesperson.COMSLLYR = salesperson.COMSLLYR;
existingSalesperson.NCOMSLTD = salesperson.NCOMSLTD;
existingSalesperson.NCOMSLYR = salesperson.NCOMSLYR;
existingSalesperson.KPCALHST = salesperson.KPCALHST;
existingSalesperson.KPERHIST = salesperson.KPERHIST;
existingSalesperson.NOTEINDX = salesperson.NOTEINDX;
existingSalesperson.MODIFDT = salesperson.MODIFDT;
existingSalesperson.CREATDDT = salesperson.CREATDDT;
existingSalesperson.COMMDEST = salesperson.COMMDEST;
existingSalesperson.DEX_ROW_TS = salesperson.DEX_ROW_TS;
existingSalesperson.DEX_ROW_ID = salesperson.DEX_ROW_ID;
_dynamicsContext.SubmitChanges();
operationResult.Success = true;
operationResult.Message = "Success";
}
catch (Exception ex)
{
operationResult.Success = false;
operationResult.Message = "Error";
logger.ErrorFormat("Error while updating salesperson: { 0} ", ex.ToString());
}
}
else
{
operationResult.Success = false;
operationResult.Message = "Unable to find selected salesperson.";
}
return(operationResult);
}
