public ActionResult Drawings(DrawingViewModel m, HttpPostedFileBase inputFile) { if (ModelState.IsValid) { try { if (!string.IsNullOrEmpty(m.Drawing.DrawingNo)) { if (!string.IsNullOrEmpty(m.Drawing.Subject)) { if (!string.IsNullOrEmpty(m.Drawing.ApprovalBy)) { if (inputFile != null && inputFile.ContentLength > 0) { if (inputFile.ContentType == "application/pdf") { Guid FileName = Guid.NewGuid(); m.Drawing.FilePath = "/Uploads/Drawings/" + FileName + ".pdf"; string tPath = Path.Combine(Server.MapPath("~/Uploads/Drawings/"), FileName + ".pdf"); inputFile.SaveAs(tPath); m.Drawing.CreatedBy = Request.Cookies["INDMS"]["UserID"]; m.Drawing.CreatedDate = null; db.Drawings.Add(m.Drawing); db.SaveChanges(); TempData["RowId"] = m.Drawing.Id; TempData["MSG"] = "Save Successfully"; return RedirectToAction("Drawings"); } else { TempData["Error"] = "Please Select PDF Files Only."; } } else { TempData["Error"] = "Please Select File"; } } else { TempData["Error"] = "Please Select Approval By."; } } else { TempData["Error"] = "Please Enter Subject"; } } else { TempData["Error"] = "Please Enter Drawing No."; } } catch (Exception ex) { TempData["Error"] = ex.Message; } } m.Drawings = db.Drawings.OrderByDescending(x => x.Id); foreach (Drawing item in m.Drawings) { item.ApprovalBy = db.Users.SingleOrDefault(x => x.UserId == new Guid(item.ApprovalBy)).Name; //from d in db.Users // where d.UserId.ToString() == item.ApprovalBy // select d.Name; } return View(m); }
public ActionResult Drawings() { DrawingViewModel m = new DrawingViewModel(); m.Drawings = db.Drawings.OrderByDescending(x => x.Id); foreach (Drawing item in m.Drawings) { item.ApprovalBy = db.Users.SingleOrDefault(x => x.UserId == new Guid(item.ApprovalBy)).Name; //from d in db.Users // where d.UserId.ToString() == item.ApprovalBy // select d.Name; } return View(m); }