public List <LocationsDTO> MappingFromLocationToLOcationsDTO(IEnumerable <Location> LocationList)
{
List <LocationsDTO> locationDTOList = new List <LocationsDTO>();
foreach (var Location in LocationList)
{
LocationsDTO locationDto = new LocationsDTO();
locationDto.ID = Location.ID;
locationDto.Name = Location.Name;
locationDto.Identifier = Location.Identifier;
locationDto.PropCode = Location.PropCode;
locationDto.RDUsageID = Location.RDUsageID;
if (locationDto.RDUsageID == 1)
{
locationDto.RDB = "R";
}
else if (locationDto.RDUsageID == 2)
{
locationDto.RDB = "D";
}
else
{
locationDto.RDB = "B";
}
locationDto.IsActive = Location.IsActive;
locationDto.CreatedBy = Location.CreatedBy;
locationDto.CreatedDate = Location.CreatedDate;
locationDto.ModifiedBy = Location.ModifiedBy;
locationDto.ModifiedDate = Location.ModifiedDate;
locationDTOList.Add(locationDto);
}
return(locationDTOList);
}
public LocationsDTO GetLocationById(int id)
{
LocationsDTO result = new LocationsDTO();
if (id != 0)
{
result = modalFactory.Parse(_ILocationRepository.GetLocationById(id));
}
else
{
result = new LocationsDTO();
}
if (result.RDUsageID == 1)
{
result.RDB = "R";
}
else if (result.RDUsageID == 2)
{
result.RDB = "D";
}
else
{
result.RDB = "B";
}
return(result);
}
public ActionResult AddOrEdit(int id = 0)
{
LocationsDTO lstLocationsDTO = new LocationsDTO();
if (id == 0)
{
return(View(new LocationsDTO()));
}
else
{
var request = new RestRequest(string.Format("EditLocation"), Method.POST)
{
RequestFormat = DataFormat.Json
};
request.JsonSerializer = NewtonsoftJsonSerializer.Default;
request.AddJsonBody(id);
var response = clientLocation.Execute <LocationsDTO>(request);
int totalRecords = 0;
if (response.Data != null)
{
lstLocationsDTO = response.Data;
}
else
{
lstLocationsDTO = new LocationsDTO();
// Filter record count.
int recFilter = totalRecords;
}
// return Json(new { data = lstLocationsDTO }, JsonRequestBehavior.AllowGet);
return(View("AddorEdit", lstLocationsDTO));
}
}
public ActionResult AddOrEdit(LocationsDTO loc)
{
string msg = null;
if (loc.ID == 0)
{
// Save location which are in Oacy/Unsc But not in location table
var req = new RestRequest(string.Format("UpdateLocation"), Method.POST)
{
RequestFormat = DataFormat.Json
};
req.JsonSerializer = NewtonsoftJsonSerializer.Default;
req.AddJsonBody(loc);
var response = clientLocation.Execute <bool>(req);
msg = (response.Data ? "Saved Successfully" : "Something went Wrong!!");
}
else
{
// Update location in location table
var request = new RestRequest(string.Format("UpdateLocation"), Method.POST)
{
RequestFormat = DataFormat.Json
};
request.JsonSerializer = NewtonsoftJsonSerializer.Default;
request.AddJsonBody(loc);
var response = clientLocation.Execute <bool>(request);
msg = (response.Data ? "Updated Successfully" : "Something went Wrong!!");
}
return(Json(new { success = true, message = msg }, JsonRequestBehavior.AllowGet));
}
public async Task <IResponse <List <PriceInquiryResult> > > PriceInquiry(LocationsDTO priceInquiry, bool cashed, bool hasReturn)
{
var result = new Response <List <PriceInquiryResult> >();
result.Result = new List <PriceInquiryResult>();
try
{
var peyk = await AloPeikProvider.PriceInquiry(priceInquiry.Source, priceInquiry.Destination, cashed, hasReturn);
var post = await PostProvider.PriceInquiry(priceInquiry.Source, priceInquiry.Destination, cashed, hasReturn);
if (peyk.IsNotNull())
{
result.Result.Add(peyk);
}
if (post.IsNotNull())
{
result.Result.Add(post);
}
result.IsSuccessful = true;
result.Message = ServiceMessage.Success;
return(result);
}
catch (Exception e)
{
FileLoger.Error(e);
result.Message = ServiceMessage.Exception;
return(result);
}
}
public LocationsDTO Parse(Location item)
{
LocationsDTO result = new LocationsDTO();
result.CreatedBy = item.CreatedBy;
result.ID = item.ID;
result.CreatedDate = item.CreatedDate;
result.Identifier = item.Identifier;
result.IsActive = item.IsActive;
result.ModifiedBy = item.ModifiedBy;
result.ModifiedDate = item.ModifiedDate;
result.Name = item.Name;
result.PipelineID = item.PipelineID;
result.PropCode = item.PropCode;
result.RDUsageID = item.RDUsageID;
if (result.RDUsageID == 1)
{
result.RDB = "R";
}
else if (result.RDUsageID == 2)
{
result.RDB = "D";
}
else
{
result.RDB = "B";
}
return(result);
}
public ActionResult AddLocation(FormCollection fc, LocationListDTO locList)
{
LocationsDTO locationsDTO = new LocationsDTO();
List <LocationsDTO> loc = new List <LocationsDTO>();
string pipelineDuns = fc["PipelineDuns"];
loc = locList.LocationsList.ToList();
locList.DunsNo = pipelineDuns;
ILocationService.AddLocationByPipeline(loc, pipelineDuns);
return(RedirectToAction("Index", new { pipelineDuns = pipelineDuns }));
}
public PartialViewResult AddLocationRow(string pipelineDuns, string RowCount)
{
LocationListDTO model = new LocationListDTO();
model.CurrentLocationRow = Convert.ToInt32(RowCount);
model.DunsNo = pipelineDuns;
model.LocationsList = new List <LocationsDTO>();
var item = new LocationsDTO();
item.CreatedDate = DateTime.Now;
model.LocationsList.Add(item);
return(PartialView("_AddLocationRow", model));
}
public List <LocationsDTO> GetLocations(string Keyword, string PipelineDuns)
{
List <LocationsDTO> resultantList = new List <LocationsDTO>();
List <Location> data = new List <Location>();
if (string.IsNullOrEmpty(Keyword))
{
data = DbContext.Location.Where(a => a.PipeDuns == PipelineDuns && a.IsActive == true).ToList();
}
else
{
data = DbContext.Location.Where(a => a.PipeDuns == PipelineDuns &&
a.IsActive == true &&
(a.Identifier.Contains(Keyword) || a.PropCode.Contains(Keyword) || a.Name.Contains(Keyword))).ToList();
}
foreach (var item in data)
{
var dtoObj = new LocationsDTO
{
CreatedBy = item.CreatedBy,
ID = item.ID,
CreatedDate = item.CreatedDate,
Identifier = item.Identifier,
IsActive = item.IsActive,
ModifiedBy = item.ModifiedBy,
ModifiedDate = item.ModifiedDate,
Name = item.Name,
PipelineID = item.PipelineID,
PropCode = item.PropCode,
RDUsageID = item.RDUsageID,
};
if (dtoObj.RDUsageID == 1)
{
dtoObj.RDB = "R";
}
else if (dtoObj.RDUsageID == 2)
{
dtoObj.RDB = "D";
}
else
{
dtoObj.RDB = "B";
}
resultantList.Add(dtoObj);
}
return(resultantList.OrderBy(a => a.Name).ToList());
}
public ActionResult AddOrEdit(LocationsDTO loc)
{
string msg = null;
if (loc.ID == 0)
{
bool Data = ILocationService.UpdateLocationByID(loc);
msg = (Data ? "Saved Successfully" : "Something went Wrong!!");
}
else
{
bool Data = ILocationService.UpdateLocationByID(loc);
msg = (Data ? "Updated Successfully" : "Something went Wrong!!");
}
return(Json(new { success = true, message = msg }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddLocation(FormCollection fc, LocationListDTO locList)
{
LocationsDTO locationsDTO = new LocationsDTO();
List <LocationsDTO> loc = new List <LocationsDTO>();
string PipelineDuns = fc["hdnPipelineDuns"];
loc = locList.LocationsList.ToList();
var request = new RestRequest(string.Format("AddLocation"), Method.POST)
{
RequestFormat = DataFormat.Json
};
request.JsonSerializer = NewtonsoftJsonSerializer.Default;
request.AddJsonBody(loc);
var response = clientLocation.Execute <bool>(request);
string pipeline = loc.Select(x => x.PipelineDuns).ToString();
return(RedirectToAction("Index", new { pipelineDuns = pipeline }));
}
public ActionResult Index(string pipelineDuns)
{
LocationsDTO model = new LocationsDTO();
ShipperReturnByIdentity currentIdentityValues = GetValueFromIdentity();
PipelineDTO pipe = new PipelineDTO();
if (Request["pipelineDuns"] == null || string.IsNullOrEmpty(pipelineDuns))
{
var pipes = GetPipelines();
pipelineDuns = pipes.Count > 0 ? pipes.FirstOrDefault().DUNSNo : string.Empty;
}
else
{
pipelineDuns = Request["pipelineDuns"] != null ? Request["pipelineDuns"].ToString() : pipelineDuns;
}
model.PipelineDuns = pipelineDuns;
return(View(model));
}
public bool UpdateLocationByID(LocationsDTO loc)
{
// save location which are in Oacy/Unsc but not in table
Location location = new Location();
if (loc.ID == 0)
{
location.CreatedDate = DateTime.Now;
location.Name = loc.Name;
location.Identifier = loc.Identifier;
location.PropCode = loc.PropCode;
location.RDUsageID = loc.RDUsageID;
location.PipelineID = loc.PipelineID;
location.IsActive = true;
location.CreatedBy = loc.CreatedBy;
location.ModifiedBy = loc.ModifiedBy;
location.ModifiedDate = DateTime.Now;
location.PipeDuns = loc.PipelineDuns;
location.TransactionTypeId = 0;
DbContext.Locations.Add(location);
DbContext.SaveChanges();
}
else
{
//update location in location table
var objLoc = DbContext.Locations.Where(a => a.ID == loc.ID).FirstOrDefault();
objLoc.Name = loc.Name;
objLoc.Identifier = loc.Identifier;
objLoc.PropCode = loc.PropCode;
objLoc.RDUsageID = loc.RDUsageID;
// objLoc.PipelineID = loc.PipelineID;
// objLoc.IsActive = loc.IsActive;
//objLoc.ModifiedBy = loc.ModifiedBy;
objLoc.ModifiedDate = DateTime.Now;
// objLoc.PipeDuns = loc.PipeDuns; // adding pipeduns is pending
//objLoc.TransactionTypeId = 0;
DbContext.Entry(objLoc).State = EntityState.Modified;
DbContext.SaveChanges();
}
return(true);
}
public LocationsDTO GetLocationById(int id)
{
LocationsDTO result = new LocationsDTO();
Location data = new Location();
if (id != 0)
{
data = DbContext.Locations.Where(a => a.ID == id).FirstOrDefault();
}
result.CreatedBy = data.CreatedBy;
result.ID = data.ID;
result.CreatedDate = data.CreatedDate;
result.Identifier = data.Identifier;
result.IsActive = data.IsActive;
result.ModifiedBy = data.ModifiedBy;
result.ModifiedDate = data.ModifiedDate;
result.Name = data.Name;
result.PipelineID = data.PipelineID;
result.PropCode = data.PropCode;
result.RDUsageID = data.RDUsageID;
if (result.RDUsageID == 1)
{
result.RDB = "R";
}
else if (result.RDUsageID == 2)
{
result.RDB = "D";
}
else
{
result.RDB = "B";
}
return(result);
}
// PageNo = 0,1,2,3...so on.
public List <LocationsDTO> GetLocationsWithPaging(string Keyword, string PipelineDuns, int PageNo, int PageSize, string PopupFor, bool IsSpecialDelCase, string order, string orderDir)
{
List <LocationsDTO> resultantList = new List <LocationsDTO>();
List <Location> Result = new List <Location>();
int NotRDB = 1; // for not Receipt locs.
if (PopupFor == "RecLoc" || PopupFor == "Receipt" || PopupFor == "ContractPath" || PopupFor == "Supply")
{
NotRDB = 2; // for not delivery locs.
if (string.IsNullOrEmpty(Keyword))
{
var QueryableData = DbContext.Location.Where(a => a.PipeDuns == PipelineDuns && a.IsActive == true && a.RDUsageID != NotRDB);
var QueryableDataWithOrder = GetQueryableDataWithOrder(QueryableData, order, orderDir);
Result = QueryableDataWithOrder.Skip(PageNo * PageSize).Take(PageSize).ToList();
}
else
{
var QueryableDataWithKeyword = DbContext.Location.Where(a => a.PipeDuns == PipelineDuns &&
a.IsActive == true &&
a.RDUsageID != NotRDB &&
(a.Identifier.Contains(Keyword) || a.PropCode.Contains(Keyword) || a.Name.Contains(Keyword)));
var QueryableDataWithOrder = GetQueryableDataWithOrder(QueryableDataWithKeyword, order, orderDir);
Result = QueryableDataWithOrder.Skip(PageNo * PageSize).Take(PageSize).ToList();
}
}
else
{
NotRDB = 1; // not-Receipt
if (IsSpecialDelCase)
{
if (PipelineDuns == "006958581") // ANR Pipeline Company
{
// locationList = locationList.Where(a => a.PropCode == "103565" || a.PropCode == "103702").ToList();
if (string.IsNullOrEmpty(Keyword))
{
Result = DbContext.Location.Where(a => a.PropCode == "103565" || a.PropCode == "103702").OrderBy(a => a.Name).Skip(PageNo * PageSize).Take(PageSize).ToList();
}
else
{
Result = DbContext.Location.Where(a => (a.PropCode == "103565" || a.PropCode == "103702") &&
(a.Identifier.Contains(Keyword) || a.PropCode.Contains(Keyword) || a.Name.Contains(Keyword))).OrderBy(a => a.Name).Skip(PageNo * PageSize).Take(PageSize).ToList();
}
}
else if (PipelineDuns == "007933047") //Transwestern Pipeline Company, LLC
{
// locationList = locationList.Where(a => a.PropCode == "58646" || a.PropCode == "58647" || a.PropCode == "58648" || a.PropCode == "58649" || a.PropCode == "500543").ToList();
if (string.IsNullOrEmpty(Keyword))
{
Result = DbContext.Location.Where(a => a.PropCode == "58646" || a.PropCode == "58647" || a.PropCode == "58648" || a.PropCode == "58649" || a.PropCode == "500543").OrderBy(a => a.Name).Skip(PageNo * PageSize).Take(PageSize).ToList();
}
else
{
Result = DbContext.Location.Where(a => (a.PropCode == "58646" || a.PropCode == "58647" || a.PropCode == "58648" || a.PropCode == "58649" || a.PropCode == "500543") &&
(a.Identifier.Contains(Keyword) || a.PropCode.Contains(Keyword) || a.Name.Contains(Keyword))).OrderBy(a => a.Name).Skip(PageNo * PageSize).Take(PageSize).ToList();
}
}
else if (PipelineDuns == "829416002") // FAYETTEVILLE EXPRESS PIPELINE LLC
{
//locationList = locationList.Where(a => a.PropCode == "58744").ToList();
if (string.IsNullOrEmpty(Keyword))
{
Result = DbContext.Location.Where(a => a.PropCode == "58744").OrderBy(a => a.Name).Skip(PageNo * PageSize).Take(PageSize).ToList();
}
else
{
Result = DbContext.Location.Where(a => (a.PropCode == "58744") &&
(a.Identifier.Contains(Keyword) || a.PropCode.Contains(Keyword) || a.Name.Contains(Keyword))).OrderBy(a => a.Name).Skip(PageNo * PageSize).Take(PageSize).ToList();
}
}
else
{
if (string.IsNullOrEmpty(Keyword))
{
Result = DbContext.Location.Where(a => a.PipeDuns == PipelineDuns && a.IsActive == true && a.RDUsageID != NotRDB).OrderBy(a => a.Name).Skip(PageNo * PageSize).Take(PageSize).ToList();
}
else
{
Result = DbContext.Location.Where(a => a.PipeDuns == PipelineDuns &&
a.IsActive == true &&
a.RDUsageID != NotRDB &&
(a.Identifier.Contains(Keyword) || a.PropCode.Contains(Keyword) || a.Name.Contains(Keyword))).OrderBy(a => a.Name).Skip(PageNo * PageSize).Take(PageSize).ToList();
}
}
}
else//If location is Delivery
{
if (string.IsNullOrEmpty(Keyword))
{
var QueriableDelLocData = DbContext.Location.Where(a => a.PipeDuns == PipelineDuns && a.IsActive == true && a.RDUsageID != NotRDB);
var QueryableDataWithOrderDelLoc = GetQueryableDataWithOrder(QueriableDelLocData, order, orderDir);
Result = QueryableDataWithOrderDelLoc.Skip(PageNo * PageSize).Take(PageSize).ToList();
}
else
{
var QueriableDelLocDataWithData = DbContext.Location.Where(a => a.PipeDuns == PipelineDuns &&
a.IsActive == true &&
a.RDUsageID != NotRDB &&
(a.Identifier.Contains(Keyword) || a.PropCode.Contains(Keyword) || a.Name.Contains(Keyword)));
var QueryableDataWithOrderDelLoc = GetQueryableDataWithOrder(QueriableDelLocDataWithData, order, orderDir);
Result = QueryableDataWithOrderDelLoc.Skip(PageNo * PageSize).Take(PageSize).ToList();
}
}
}
foreach (var item in Result)
{
var dtoObj = new LocationsDTO
{
CreatedBy = item.CreatedBy,
ID = item.ID,
CreatedDate = item.CreatedDate,
Identifier = item.Identifier,
IsActive = item.IsActive,
ModifiedBy = item.ModifiedBy,
ModifiedDate = item.ModifiedDate,
Name = item.Name,
PipelineID = item.PipelineID,
PropCode = item.PropCode,
RDUsageID = item.RDUsageID,
};
if (dtoObj.RDUsageID == 1)
{
dtoObj.RDB = "R";
}
else if (dtoObj.RDUsageID == 2)
{
dtoObj.RDB = "D";
}
else
{
dtoObj.RDB = "B";
}
resultantList.Add(dtoObj);
}
return(resultantList);
}
public bool UpdateLocationByID(LocationsDTO loc)
{
bool result = _ILocationRepository.UpdateLocationByID(modalFactory.Create(loc));
return(result);
}
public IHttpActionResult GetAllLocations()
{
List <LocationsDTO> res = LocationsDTO.ConvertToDto(DB.Locations.ToList());
return(Ok(res));
}
public async Task <IActionResult> Price([FromBody] LocationsDTO priceInquiry) => Ok(await _deliveryService.PriceInquiry(priceInquiry, false, false));
public IHttpActionResult SaveLocsNotInTblLoc([FromBody] LocationsDTO loc)
{
var source = locRepository.UpdateLocationByID(loc);
return(Ok(source));
}
