public List <Pipeline_TransactionType_MapDTO> GetTransactions(string pipelineDuns)
{
//var data = DbContext.Pipeline_TransactionType_Map.Where(a => a.PipeDuns == pipelineDuns).ToList();
List <Pipeline_TransactionType_MapDTO> resultantData = new List <Pipeline_TransactionType_MapDTO>();
var data = (from pt in DbContext.Pipeline_TransactionType_Map
join tt in DbContext.metadataTransactionType on pt.TransactionTypeID equals tt.ID
where pt.PipeDuns == pipelineDuns
select new
{
id = pt.ID,
name = tt.Name,
identifier = tt.Identifier,
isActive = pt.IsActive,
pathType = pt.PathType,
PipeLineDuns = pt.PipeDuns
}).ToList();
foreach (var tt in data)
{
Pipeline_TransactionType_MapDTO itemObj = new Pipeline_TransactionType_MapDTO();
itemObj.ID = tt.id;
itemObj.Name = tt.name;
itemObj.IsActive = tt.isActive;
itemObj.PathType = tt.pathType;
itemObj.pipelineDuns = tt.PipeLineDuns;
resultantData.Add(itemObj);
}
return(resultantData);
}
public ActionResult Index(string pipelineDuns)
{
Pipeline_TransactionType_MapDTO model = new Pipeline_TransactionType_MapDTO();
if (Request["pipelineDuns"] == null || string.IsNullOrEmpty(pipelineDuns))
{
var pipes = _pipelineService.GetAllActivePipeline();
pipelineDuns = pipes.ToList().Count > 0 ? pipes.FirstOrDefault().DUNSNo : string.Empty;
}
else
{
pipelineDuns = Request["pipelineDuns"] != null ? Request["pipelineDuns"].ToString() : pipelineDuns;
}
model.pipelineDuns = pipelineDuns;
return(View(model));
}
public ActionResult AddorEdit(Pipeline_TransactionType_MapDTO transaction, FormCollection fc)
{
//Pipeline_TransactionType_MapDTO Pipeline_TransactionTypeDTO = new Pipeline_TransactionType_MapDTO();
//string pipelineDuns = fc["pipelineDuns"];
//Pipeline_TransactionTypeDTO.PathType = fc["PathType"];
//Pipeline_TransactionTypeDTO.MetaDataTransactionTypesDTO = Convert.ToInt32(fc["TransType"]);
//List<SelectListItem> selectedItems = Pipeline_TransactionTypeDTO.MetaDataTransactionTypesDTO.Where(p => p.ID.Contains(int.Parse(transaction.))).ToList();
//Pipeline_TransactionTypeDTO.PipeDuns = pipelineDuns;
if (ModelState.IsValid)
{
string Message = _IPipeTransTypeMapService.UpdateTransactionByID(transaction);
return(Json(new { success = true, message = Message }, JsonRequestBehavior.AllowGet));
}
else
{
return(PartialView("AddorEdit"));
}
}
public ActionResult AddorEdit(int id = 0)
{
Pipeline_TransactionType_MapDTO ptm = new Pipeline_TransactionType_MapDTO();
List <SelectListItem> items = new List <SelectListItem>();
items.Add(new SelectListItem {
Text = "Contract", Value = "C"
});
items.Add(new SelectListItem {
Text = "Market", Value = "M"
});
items.Add(new SelectListItem {
Text = "Non-Pathed", Value = "NP"
});
items.Add(new SelectListItem {
Text = "Pathed", Value = "P"
});
items.Add(new SelectListItem {
Text = "Supply", Value = "S"
});
if (id == 0)
{
ViewBag.PathType = new SelectList(items, "Value", "Text");
//ViewBag.Transtype = new SelectList(_transtypeService.GetTransactions(), "ID", "Name");
ptm.MetaDataTransactionTypesDTO = _transtypeService.GetTransactions().ToList();
return(View(ptm));
}
else
{
ptm = _IPipeTransTypeMapService.GetTransactionByid(id);
ViewBag.PathType = new SelectList(items, "Value", "Text", ptm.PathType);
ptm.MetaDataTransactionTypesDTO = _transtypeService.GetTransactions().ToList();
return(View(ptm));
}
}
public string UpdateTransactionByID(Pipeline_TransactionType_MapDTO Transaction)
{
string Notification = _UPRDPipeTransService.UpdateTransactionByID(modalFactory.Create(Transaction));
return(Notification);
}
