public ActionResult Details(int MaterialEntryMasId)
{
ViewBag.MaterialEntryMasId = MaterialEntryMasId;
var id = (from entryMas in db.Proc_MaterialEntryMas
join procProject in db.ProcProject on entryMas.ProcProjectId equals procProject.Id
join site in db.ProjectSite on procProject.ProjectSiteId equals site.Id
join project in db.Project on site.ProjectId equals project.Id
where entryMas.Id == MaterialEntryMasId
select new { site, project }).FirstOrDefault();
ViewBag.ProjectId = id.project.Id;
ViewBag.ProjectName = id.project.Name;
ViewBag.SiteId = id.site.Id;
ViewBag.SiteName = id.site.Name;
VMMaterialsEntryMasterDetail vm = new VMMaterialsEntryMasterDetail();
vm.proc_MaterialEntryMas = db.Proc_MaterialEntryMas.SingleOrDefault(x => x.Id == MaterialEntryMasId);
List <Proc_MaterialEntryDet> tenderList = new List <Proc_MaterialEntryDet>();
var TenderDetails = db.Proc_MaterialEntryDet.Where(x => x.Proc_MaterialEntryMasId == MaterialEntryMasId).ToList();
foreach (var item in TenderDetails)
{
tenderList.Add(item);
}
vm.proc_MaterialEntryDet = tenderList;
return(View(vm));
}
public ActionResult Edit(int MaterialEntryMasId)
{
ViewBag.MaterialEntryMasId = MaterialEntryMasId;
var id = (from entryMas in db.Proc_MaterialEntryMas
join procProject in db.ProcProject on entryMas.ProcProjectId equals procProject.Id
join site in db.ProjectSite on procProject.ProjectSiteId equals site.Id
join project in db.Project on site.ProjectId equals project.Id
where entryMas.Id == MaterialEntryMasId
select new { site, project }).FirstOrDefault();
ViewBag.ProjectId = id.project.Id;
ViewBag.ProjectName = id.project.Name;
ViewBag.SiteId = id.site.Id;
ViewBag.SiteName = id.site.Name;
List <SelectListItem> ItemList = new List <SelectListItem>();
//var items = (from procProjectItem in db.ProcProjectItem
// join procproject in db.ProcProject on procProjectItem.ProcProjectId equals procproject.Id
// join site in db.ProjectSite on procproject.ProjectSiteId equals site.Id
// join project in db.Project on site.ProjectId equals project.Id
// where project.Id == id.project.Id && site.Id == id.site.Id
// select procProjectItem).ToList();
var items = (from purchaseMas in db.Proc_PurchaseOrderMas
join purchaseDet in db.Proc_PurchaseOrderDet on purchaseMas.Id equals purchaseDet.Proc_PurchaseOrderMasId
join tenderMas in db.Proc_TenderMas on purchaseMas.Proc_TenderMasId equals tenderMas.Id
join tenderDet in db.Proc_TenderDet on tenderMas.Id equals tenderDet.Proc_TenderMasId
join requisitionDet in db.Proc_RequisitionDet on tenderDet.Proc_RequisitionDetId equals requisitionDet.Id
join requisitionMas in db.Proc_RequisitionMas on requisitionDet.Proc_RequisitionMasId equals requisitionMas.Id
join procproject in db.ProcProject on requisitionMas.ProcProjectId equals procproject.Id
join procProjectItem in db.ProcProjectItem on procproject.Id equals procProjectItem.ProcProjectId
join site in db.ProjectSite on procproject.ProjectSiteId equals site.Id
join project in db.Project on site.ProjectId equals project.Id
where project.Id == id.project.Id && site.Id == id.site.Id && purchaseDet.ItemId == procProjectItem.ItemId
select procProjectItem).Distinct().ToList();
foreach (var x in items)
{
var itemName = db.Item.SingleOrDefault(m => m.Id == x.ItemId);
ItemList.Add(new SelectListItem {
Text = itemName.Name, Value = x.ItemId.ToString()
});
}
//var items = from requisitionDet in db.Proc_RequisitionDet
ViewBag.ItemName = ItemList;
ViewBag.PONo = new SelectList(db.Proc_PurchaseOrderMas, "PONo", "PONo");
ViewBag.ReqNo = new SelectList(db.Proc_RequisitionMas, "Id", "RCode");
ViewBag.MaterialEntryMasId = MaterialEntryMasId;
VMMaterialsEntryMasterDetail vm = new VMMaterialsEntryMasterDetail();
vm.proc_MaterialEntryMas = db.Proc_MaterialEntryMas.SingleOrDefault(x => x.Id == MaterialEntryMasId);
List <Proc_MaterialEntryDet> tenderList = new List <Proc_MaterialEntryDet>();
var TenderDetails = db.Proc_MaterialEntryDet.Where(x => x.Proc_MaterialEntryMasId == MaterialEntryMasId).ToList();
foreach (var item in TenderDetails)
{
tenderList.Add(item);
}
vm.proc_MaterialEntryDet = tenderList;
return(View(vm));
}
