public LocationsResultDTO GetLocationByPipeline(string pipelineDuns)
{
LocationsResultDTO locResult = new LocationsResultDTO();
var locationResult = DbContext.Locations.Where(a => a.PipeDuns == pipelineDuns).ToList();
locResult.locationsDTO = locationResult.Select(a => modalFactory.Parse(a)).OrderBy(a => a.Name).ToList();
locResult.RecordCount = locResult.locationsDTO.Count();
return(locResult);
}
public SwntResultDTO GetSwntListWithPaging(string PipelineDuns, bool IsCritical, string Keyword, DateTime?postStartDate, DateTime?postEndDate, DateTime?EffectiveStartDate, DateTime?EffectiveEndDate, SortingPagingInfo sortingPagingInfo)
{
//Get SWNT list using above parameters
List <SwntPerTransaction> swntdatalist = new List <SwntPerTransaction>();
SwntResultDTO swntResultDTO = new SwntResultDTO();
try
{
swntdatalist = GetNoticesBySearch(PipelineDuns, IsCritical, Keyword, postStartDate, postEndDate, EffectiveStartDate, EffectiveEndDate);
var dataQueryWithOrder = SortByColumnWithOrder(swntdatalist.AsQueryable(), sortingPagingInfo);
sortingPagingInfo.PageCount = dataQueryWithOrder.Count();
swntResultDTO.RecordCount = sortingPagingInfo.PageCount;
var resultData = dataQueryWithOrder.Skip((sortingPagingInfo.CurrentPageIndex - 1) * sortingPagingInfo.PageSize).Take(sortingPagingInfo.PageSize).ToList();
if (resultData.Count() > 0)
{
var swntResult = resultData.Select(a => modalFactory.Parse(a)).ToList();
swntResultDTO.swntPerTransactionDTO = swntResult;
return(swntResultDTO);
}
return(new SwntResultDTO());
}
catch (Exception ex)
{
return(null);
}
}
public bool SaveUserPermissions(UserPipelineDTO userMapping)
{
string userID = (userMapping.userPipelineMappingDTO.Count > 0 && !string.IsNullOrEmpty(userMapping.userPipelineMappingDTO.Select(u => u.UserId).FirstOrDefault()) ? userMapping.userPipelineMappingDTO[0].UserId : userMapping.UserId);
var userPipelineMapping = factory.Parse(userMapping);
if (userMapping != null)
{
var deleteUser = dbcontext.UserPipelineMappings.Where(a => a.userId == userID).Select(a => a).ToList();
var Delete = dbcontext.UserPipelineMappings.RemoveRange(deleteUser);
dbcontext.SaveChanges();
var OnlyNomsOrUprd = userPipelineMapping
.Where(a => a.IsNoms == true || a.IsUPRD == true)
.Select(a => a).ToList();
var result = dbcontext.UserPipelineMappings.AddRange(OnlyNomsOrUprd);
var Success = dbcontext.SaveChanges();
if (Success > 0)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
public List <CounterPartiesDTO> GetCounterParties(string Keyword, string PipeDuns)
{
List <CounterParty> data = new List <CounterParty>();
if (string.IsNullOrEmpty(Keyword))
{
data = DbContext.CounterParties.Where(a =>
a.IsActive
).ToList();
}
else
{
data = DbContext.CounterParties.Where(a =>
(a.Identifier.Contains(Keyword) ||
a.PropCode.Contains(Keyword) ||
a.Name.Contains(Keyword))
//&& (a.PipeDuns == PipeDuns)
&& a.IsActive
).ToList();
}
return(data.Select(a => modalFactory.Parse(a)).ToList());
}
// PageNo = 0,1,2,3...so on.
public LocationsResultDTO GetLocationsWithPaging(string Keyword, string PipelineDuns, string PopupFor, bool IsSpecialDelCase, SortingPagingInfo sortingPagingInfo)
{
LocationsResultDTO locationsResultDTO = new LocationsResultDTO();
List <Location> Result = new List <Location>();
int PageNo = sortingPagingInfo.CurrentPageIndex;
int PageSize = sortingPagingInfo.PageSize;
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.Locations.Where(a => a.PipeDuns == PipelineDuns && a.IsActive == true && a.RDUsageID != NotRDB);
var QueryableDataWithOrder = GetQueryableDataWithOrder(QueryableData, sortingPagingInfo);
sortingPagingInfo.PageCount = QueryableDataWithOrder.Count();
Result = QueryableDataWithOrder.Skip((PageNo - 1) * PageSize).Take(PageSize).ToList();
}
else
{
var QueryableDataWithKeyword = DbContext.Locations.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, sortingPagingInfo);
sortingPagingInfo.PageCount = QueryableDataWithOrder.Count();
Result = QueryableDataWithOrder.Skip((PageNo - 1) * 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.Locations.Where(a => a.PropCode == "103565" || a.PropCode == "103702").OrderBy(a => a.Name).Skip((PageNo - 1) * PageSize).Take(PageSize).ToList();
}
else
{
Result = DbContext.Locations.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 - 1) * 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.Locations.Where(a => a.PropCode == "58646" || a.PropCode == "58647" || a.PropCode == "58648" || a.PropCode == "58649" || a.PropCode == "500543").OrderBy(a => a.Name).Skip((PageNo - 1) * PageSize).Take(PageSize).ToList();
}
else
{
Result = DbContext.Locations.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 - 1) * 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.Locations.Where(a => a.PropCode == "58744").OrderBy(a => a.Name).Skip((PageNo - 1) * PageSize).Take(PageSize).ToList();
}
else
{
Result = DbContext.Locations.Where(a => (a.PropCode == "58744") &&
(a.Identifier.Contains(Keyword) || a.PropCode.Contains(Keyword) || a.Name.Contains(Keyword))).OrderBy(a => a.Name).Skip((PageNo - 1) * PageSize).Take(PageSize).ToList();
}
}
else
{
if (string.IsNullOrEmpty(Keyword))
{
Result = DbContext.Locations.Where(a => a.PipeDuns == PipelineDuns && a.IsActive == true && a.RDUsageID != NotRDB).OrderBy(a => a.Name).Skip((PageNo - 1) * PageSize).Take(PageSize).ToList();
}
else
{
Result = DbContext.Locations.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 - 1) * PageSize).Take(PageSize).ToList();
}
}
}
else//If location is Delivery
{
if (string.IsNullOrEmpty(Keyword))
{
var QueriableDelLocData = DbContext.Locations.Where(a => a.PipeDuns == PipelineDuns && a.IsActive == true && a.RDUsageID != NotRDB);
var QueryableDataWithOrderDelLoc = GetQueryableDataWithOrder(QueriableDelLocData, sortingPagingInfo);
sortingPagingInfo.PageCount = QueryableDataWithOrderDelLoc.Count();
Result = QueryableDataWithOrderDelLoc.Skip((PageNo - 1) * PageSize).Take(PageSize).ToList();
}
else
{
var QueriableDelLocDataWithData = DbContext.Locations.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, sortingPagingInfo);
sortingPagingInfo.PageCount = QueryableDataWithOrderDelLoc.Count();
Result = QueryableDataWithOrderDelLoc.Skip((PageNo - 1) * PageSize).Take(PageSize).ToList();
}
}
}
locationsResultDTO.RecordCount = sortingPagingInfo.PageCount;
locationsResultDTO.locationsDTO = Result.Select(a => modalFactory.Parse(a)).OrderBy(a => a.Name).ToList();
return(locationsResultDTO);
}
