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