public ActionResult Purchase(Models.ActivityLogsPurchase model) { if (ModelState.IsValid) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); string userName = HttpContext.User.Identity.Name; var queryCurrentActivityLog = (from p in _dbContext.T_ActivityLog where p.AspNetUsers.UserName == userName && (p.dtEndWorkingDay == null) select p).FirstOrDefault(); var queryPurchaseID = (from p in _dbContext.T_PurchaseType where p.vPurchaseTypeName == model.purchaseType select p.iPuchaseTypeID).FirstOrDefault(); JneCommSitesDataLayer.T_Purchase newPurchase = new JneCommSitesDataLayer.T_Purchase(); string invoiceName = "Nothing"; newPurchase.iActivityLogID = queryCurrentActivityLog.iActivityLogID; newPurchase.Description = model.description; newPurchase.iPuchaseTypeID = queryPurchaseID; newPurchase.dtPurchaseEndDate = Convert.ToDateTime(DateTime.Now); newPurchase.dtPurchaseStartDate = Convert.ToDateTime(model.startPurchaseCheckPoint, culture); newPurchase.dPrice = Convert.ToDecimal(model.price); newPurchase.vPosition = model.position; _dbContext.T_Purchase.Add(newPurchase); if (model.documentToUpload != null) { invoiceName = userName + "_" + model.description.Replace(" ", "") + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + "_" + Path.GetExtension(model.documentToUpload.FileName).Replace(" ", ""); string path = System.IO.Path.Combine(Server.MapPath("~/Documents/Invoices/"), invoiceName); // file is uploaded model.documentToUpload.SaveAs(path); } newPurchase.InvoiceName = invoiceName; _dbContext.SaveChanges(); return(View(model)); } else { return(RedirectToAction("CreateActivityLogOptions")); } }
public ActionResult Purchase(Models.ActivityLogsOptions model) { if (ModelState.IsValid) { CultureInfo culture = new CultureInfo("en-US"); Models.ActivityLogsPurchase purchaseModel = new Models.ActivityLogsPurchase(); purchaseModel.startPurchaseCheckPoint = model.checkPoint; purchaseModel.sitePurchase = model.site; purchaseModel.purchaseType = model.activityLogOption; return(View("Purchase", purchaseModel)); } else { return(RedirectToAction("CreateActivityLogOptions")); } }