/// <summary>
/// get site by location code
/// </summary>
/// <param name="locationCode"></param>
/// <returns></returns>
public IV40700_Site GetSite(string locationCode)
{
var site = new IV40700_Site();
try
{
site = _dynamicsContext.IV40700_Site.FirstOrDefault(x => x.LOCNCODE.Replace(" ", string.Empty).ToLower() == locationCode.Replace(" ", string.Empty).ToLower());
}
catch (Exception ex)
{
logger.ErrorFormat("Error getting site: {0} ", ex.ToString());
}
return(site);
}
/// <summary>
/// convert site to view model
/// </summary>
/// <param name="site"></param>
/// <returns></returns>
public SiteViewModel ConvertToView(IV40700_Site site)
{
SiteViewModel model = new SiteViewModel();
var _stateRepository = new StateRepository();
var _countryRepository = new CountryRepository();
var state = _stateRepository.GetState(site.STATE);
var country = _countryRepository.GetCountry(site.COUNTRY);
model.SiteId = site.LOCNCODE;
model.LocationCode = site.LOCNCODE;
model.SiteDescription = (!string.IsNullOrEmpty(site.LOCNDSCR.Replace(" ", string.Empty))) ? site.LOCNDSCR : "N/A";
model.Address1 = (!string.IsNullOrEmpty(site.ADDRESS1.Replace(" ", string.Empty))) ? site.ADDRESS1 : "N/A";
model.Address2 = (!string.IsNullOrEmpty(site.ADDRESS2.Replace(" ", string.Empty))) ? site.ADDRESS2 : "N/A";
model.Address3 = (!string.IsNullOrEmpty(site.ADDRESS3.Replace(" ", string.Empty))) ? site.ADDRESS3 : "N/A";
model.City = (!string.IsNullOrEmpty(site.CITY.Replace(" ", string.Empty))) ? site.CITY : "N/A";
model.StateName = (state != null && !string.IsNullOrEmpty(state.Name)) ? state.Name : "N/A";
model.PostalCode = (!string.IsNullOrEmpty(site.ZIPCODE.Replace(" ", string.Empty))) ? site.ZIPCODE : "N/A";
model.CountryName = (country != null && !string.IsNullOrEmpty(country.Name)) ? country.Name : "N/A";
model.IsActive = site.INACTIVE != 1 ? true : false;
if (_stateRepository != null)
{
_stateRepository.Dispose();
_stateRepository = null;
}
if (_countryRepository != null)
{
_countryRepository.Dispose();
_countryRepository = null;
}
return(model);
}
/// <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);
}
