// 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);
}
