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