// GET: Manage public ActionResult Index() { List<DocumentAndTypeVM> ListDocToShow = new List<DocumentAndTypeVM>(); using (var db = new DocumentDbContext()) { foreach (var item in db.Documents.ToList()) { DocumentAndTypeVM temp = new DocumentAndTypeVM(); temp.Title = item.Title; temp.Version = item.Version; temp.DocumentFile = item.DocumentFile; temp.DocumentFileExcel = item.DocumentFileExcel; temp.DocumentId = item.DocumentId; temp.Index = item.Index; temp.DescriptionOp = db.Operations.Where(x => x.OperationId == item.OperationId).First().Description; temp.OperationNumber = db.Operations.Where(x => x.OperationId == item.OperationId).First().OperationNumber; temp.DocumentTypeDescription = db.DocumentTypes.Where(x => x.DocumentTypeId == item.DocumentTypeId).First().Description; temp.LineName = db.Lines.Where(x => x.LineId == item.LineId).First().LineName; ListDocToShow.Add(temp); } ViewData["Lines"] = new SelectList(ListDocToShow,"LineName","LineName"); ViewData["Operation"] = new SelectList(ListDocToShow, "OperationNumber"); ViewData["DocumentVariant"] = new SelectList(ListDocToShow, "DocumentTypeDescription"); } return View(ListDocToShow); }
public JsonResult EmpDetails() { List<DocumentAndTypeVM> ListDocToShow = new List<DocumentAndTypeVM>(); using (var db = new DocumentDbContext()) { foreach (var item in db.Documents.ToList()) { if (item.StatusId == 4 || item.StatusId == 7) { DocumentAndTypeVM temp = new DocumentAndTypeVM(); temp.Index = item.Index; temp.DescriptionOp = db.Operations.Where(x => x.OperationId == item.OperationId).First().Description; temp.OperationNumber = db.Operations.Where(x => x.OperationId == item.OperationId).First().OperationNumber; temp.DocumentTypeDescription = db.DocumentTypes.Where(x => x.DocumentTypeId == item.DocumentTypeId).First().Description; temp.LineName = db.Lines.Where(x => x.LineId == item.LineId).First().LineName; temp.DocumentId = item.DocumentId; ListDocToShow.Add(temp); } } } return Json(ListDocToShow, JsonRequestBehavior.AllowGet); }