public ActionResult Upload([Bind(Prefix = "")] Models.EFTR model, HttpPostedFileBase file) { var db = new CodeFirst.CodeFirst(); //array of allowed extensions var allowedExtensions = new[] { ".pdf" }; //checking extension of file uploaded var checkExtension = Path.GetExtension(file.FileName).ToLower(); //check if does not contain the extension (not png/jpg/jpeg) var myReq = db.EFT_Requisition.Where(v => v.RequisitionID == model.RequisitionID).SingleOrDefault(); if (!allowedExtensions.Contains(checkExtension)) { ViewBag.Error = "Only PDF Files are allowed."; return(View("Index", model)); } if (file.ContentLength > 8 * 1024 * 1024) { ViewBag.Error = "File too big!"; } if (ViewBag.Error == null) { if (myReq != null) { string path = Path.Combine(Server.MapPath("~/Files"), Path.GetFileName(file.FileName)); file.SaveAs(path); myReq.ReceiptFile = "~/Files/" + file.FileName; db.SaveChanges(); } TempData["js"] = "myUpdateSuccess()"; return(RedirectToAction("Index", "EFTR")); } return(View("Index", model)); }
// GET: EFTRDetails public ActionResult Index(string requisitionID) { Models.EFTR myModel = new Models.EFTR(); CodeFirst.CodeFirst db = new CodeFirst.CodeFirst(); if (requisitionID != null) { var intEFTRid = Int32.Parse(requisitionID); var myEFTR = db.EFT_Requisition.Where(i => i.RequisitionID == intEFTRid).FirstOrDefault(); var mySupplierID = db.Suppliers.Where(i => i.SupplierID == myEFTR.SupplierID).FirstOrDefault(); var myUserID = db.Users.Where(i => i.UserID == myEFTR.UserID).FirstOrDefault(); var myProjectID = db.Projects.Where(i => i.ProjectID == myEFTR.ProjectID).FirstOrDefault(); myModel.RequisitionID = myEFTR.RequisitionID; myModel.Date = myEFTR.Date; myModel.ApprovedCEO = myEFTR.ApprovedCEO; myModel.ApprovedProjectManger = myEFTR.ApprovedProjectManger; myModel.ReceiptFile = myEFTR.ReceiptFile; myModel.SupplierID = mySupplierID.SupplierID; myModel.ProjectID = myProjectID.ProjectID; myModel.UserID = myUserID.UserID; myModel.Name = db.Suppliers.Where(i => i.SupplierID == mySupplierID.SupplierID).FirstOrDefault().Name; myModel.ProjectName = db.Projects.Where(i => i.ProjectID == myProjectID.ProjectID).FirstOrDefault().ProjectName; myModel.Initials = db.Users.Where(i => i.UserID == myUserID.UserID).FirstOrDefault().Initials; myModel.LastName = db.Users.Where(i => i.UserID == myUserID.UserID).FirstOrDefault().LastName; myModel.TotalAmount = myEFTR.TotalAmount; myModel.Lines = myEFTR.EFT_Requisition_Line.ToList(); } return(View(myModel)); }
// GET: EFTR public ActionResult Index() { Models.EFTR myModel = new Models.EFTR(); if (TempData["model"] != null) { myModel = (Models.EFTR)TempData["model"]; TempData.Remove("model"); } return(View(myModel)); }
// GET: AddEFTR public ActionResult Index() { var db = new CodeFirst.CodeFirst(); var EFTR = new Models.EFTR(); EFTR.Suppliers = db.Suppliers.ToList(); EFTR.Projects = db.Projects.ToList(); EFTR.Users = db.Users.AsEnumerable().Select(u => new SelectListItem { Value = u.UserID.ToString(), Text = u.Initials + " " + u.LastName }).ToList(); return(View(EFTR)); }
// GET: AddFiletoEFTR public ActionResult Index(string requisitionID) { Models.EFTR myModel = new Models.EFTR(); CodeFirst.CodeFirst db = new CodeFirst.CodeFirst(); if (requisitionID != null) { var intPCRID = Int32.Parse(requisitionID); var myPCR = db.EFT_Requisition.Where(i => i.RequisitionID == intPCRID).FirstOrDefault(); var mySupplierID = db.Suppliers.Where(i => i.SupplierID == myPCR.SupplierID).FirstOrDefault(); var myUserID = db.Users.Where(i => i.UserID == myPCR.UserID).FirstOrDefault(); var myProjectID = db.Projects.Where(i => i.ProjectID == myPCR.ProjectID).FirstOrDefault(); myModel.RequisitionID = myPCR.RequisitionID; myModel.Date = myPCR.Date; myModel.ApprovedCEO = myPCR.ApprovedCEO; myModel.ApprovedCEO = myPCR.ApprovedProjectManger; myModel.ReceiptFile = myPCR.ReceiptFile; myModel.SupplierID = mySupplierID.SupplierID; myModel.ProjectID = myProjectID.ProjectID; myModel.UserID = myUserID.UserID; myModel.Name = db.Suppliers.Where(i => i.SupplierID == mySupplierID.SupplierID).FirstOrDefault().Name; myModel.ProjectName = db.Projects.Where(i => i.ProjectID == myProjectID.ProjectID).FirstOrDefault().ProjectName; myModel.Initials = db.Users.Where(i => i.UserID == myUserID.UserID).FirstOrDefault().Initials; myModel.LastName = db.Users.Where(i => i.UserID == myUserID.UserID).FirstOrDefault().LastName; myModel.TotalAmount = myPCR.TotalAmount; myModel.Suppliers = db.Suppliers.ToList(); myModel.Projects = db.Projects.ToList(); myModel.Users = db.Users .AsEnumerable() .Select(u => new SelectListItem { Value = u.UserID.ToString(), Text = u.Initials + " " + u.LastName }).ToList(); myModel.Lines = myPCR.EFT_Requisition_Line.ToList(); } return(View(myModel)); }