// GET: PCRDetails
public ActionResult Index(string requisitionID)
{
Models.PCR myModel = new Models.PCR();
CodeFirst.CodeFirst db = new CodeFirst.CodeFirst();
if (requisitionID != null)
{
var intPCRID = Int32.Parse(requisitionID);
var myPCR = db.Petty_Cash_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.ReqDate = myPCR.ReqDate.Value;
myModel.ApprovalStatus = myPCR.ApprovalStatus;
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.Lines = myPCR.Petty_Cash_Requisition_Line.ToList();
}
GlobalModel = myModel;
return(View(myModel));
}
public ActionResult Upload([Bind(Prefix = "")] Models.PCR 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.Petty_Cash_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", "PCR"));
}
return(View("Index", model));
}
// GET: PCR
public ActionResult Index()
{
Models.PCR myModel = new Models.PCR();
if (TempData["model"] != null)
{
myModel = (Models.PCR)TempData["model"];
TempData.Remove("model");
}
return(View(myModel));
}
// GET: AddPCR
public ActionResult Index()
{
var db = new CodeFirst.CodeFirst();
var PCR = new Models.PCR();
PCR.Suppliers = db.Suppliers.ToList();
PCR.Projects = db.Projects.ToList();
PCR.Users = db.Users.AsEnumerable().Select(u => new SelectListItem
{
Value = u.UserID.ToString(),
Text = u.Initials + " " + u.LastName
}).ToList();
return(View(PCR));
}
