public IQueryable <Watchlist> GetByDataSet(int pipelineId, EnercrossDataSets dataSet, string userId)
{
var result = (from mapping in DbContext.WatchListPipelineMappings
join res in DbContext.Watchlists on mapping.WatchListId equals res.Id
where mapping.PipelineId == pipelineId && res.UserId == userId && res.DataSetId == dataSet
select res);
return(result);
}
public PartialViewResult PopUpPartials(EnercrossDataSets dataSet, string clickedRow, string pipelineDuns)
{
WatchListPopUpPartialDTO model = new WatchListPopUpPartialDTO();
model.RowId = clickedRow;
model.DataSet = dataSet;
model.PipelineDuns = pipelineDuns;
model.Locations = new List <LocationsDTO>();
return(PartialView("~/Views/WatchList/_UprdLocations.cshtml", model));
}
public IQueryable <MasterColumn> GetByDataSet(EnercrossDataSets dataSet)
{
if (dataSet == EnercrossDataSets.SWNT)
{
return(DbContext.MasterColumns.Where(a => a.DataSetId == (EnercrossDataSets.SWNT)));
}
else if (dataSet == EnercrossDataSets.OACY)
{
return(DbContext.MasterColumns.Where(a => a.DataSetId == (EnercrossDataSets.OACY)));
}
else
{
return(DbContext.MasterColumns.Where(a => a.DataSetId == (EnercrossDataSets.UNSC)));
}
}
//public IQueryable<Watchlist> GetByAlertFrequency(WatchlistAlertFrequency alertFrequency) {
// return DbContext.Watchlists.Where(a => a.AlertFrequency == alertFrequency);
//}
public int AddWatchList(string Name, EnercrossDataSets dataset, string UserId)
{
Watchlist newWatchList = new Watchlist();
newWatchList.Name = Name;
if (dataset == EnercrossDataSets.SWNT)
{
newWatchList.DataSetId = EnercrossDataSets.SWNT;
}
else if (dataset == EnercrossDataSets.OACY)
{
newWatchList.DataSetId = EnercrossDataSets.OACY;
}
else
{
newWatchList.DataSetId = EnercrossDataSets.UNSC;
}
newWatchList.UserId = UserId;
newWatchList.CreatedDate = DateTime.UtcNow;
newWatchList.ModifiedDate = DateTime.UtcNow;
DbContext.Watchlists.Add(newWatchList);
DbContext.SaveChanges();
return(newWatchList.Id);
}
public IQueryable <WatchListMailAlertUPRDMapping> GetData(string UserId, int watchListId, EnercrossDataSets dataSet)
{
return(DbContext.WatchListMailAlertUPRDMappings.Where(a => a.UserId == UserId &&
a.WatchListId == watchListId &&
a.DataSetId == dataSet
));
}
public IQueryable <Watchlist> GetAllBydataSet(EnercrossDataSets dataset)
{
return(DbContext.Watchlists.Where(a => dataset == a.DataSetId));
}
public ActionResult GetLocationFromUPRD(EnercrossDataSets dataSet, string pipelineDuns)
{
JsonResult result = new JsonResult();
try
{
List <LocationsDTO> dataList = new List <LocationsDTO>();
int totalRecords = 0;
// Initialization.
string search = Request.Form.GetValues("search[value]")[0];
string draw = Request.Form.GetValues("draw")[0];
string order = Request.Form.GetValues("order[0][column]")[0];
if (order == "2")
{
order = "Loc";
}
else
{
order = "LocName";
}
string orderDir = Request.Form.GetValues("order[0][dir]")[0];
int startRec = Convert.ToInt32(Request.Form.GetValues("start")[0]);
int pageSize = Convert.ToInt32(Request.Form.GetValues("length")[0]);
int pageno = (startRec / pageSize) + 1;
// Loading.
RestRequest requestForLoc = new RestRequest("GetLocationsFromUPRDsUsingPaging", Method.GET);
requestForLoc.JsonSerializer = NewtonsoftJsonSerializer.Default;
requestForLoc.AddQueryParameter("PipelineDuns", pipelineDuns);
requestForLoc.AddQueryParameter("datasetType", dataSet.ToString());
requestForLoc.AddQueryParameter("Keyword", search);
requestForLoc.AddQueryParameter("PageNo", pageno.ToString());
requestForLoc.AddQueryParameter("PageSize", pageSize.ToString());
requestForLoc.AddQueryParameter("order", order);
requestForLoc.AddQueryParameter("orderDir", orderDir);
IRestResponse <LocationsResultDTO> responseForLoc = client.Execute <LocationsResultDTO>(requestForLoc);
if (responseForLoc.Data != null)
{
dataList = responseForLoc.Data.locationsDTO;
totalRecords = responseForLoc.Data.RecordCount;
}
else
{
dataList = new List <LocationsDTO>();
totalRecords = 0;
}
// Filter record count.
int recFilter = totalRecords;
// Loading drop down lists.
result = this.Json(new { draw = Convert.ToInt32(draw), recordsTotal = totalRecords, recordsFiltered = recFilter, data = dataList }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
}
return(result);
}
