public bool Update(Batch_Model model) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = _context.Batches.Where(batch => batch.BatchID == model.BatchID).FirstOrDefault(); data.BatchName = model.BatchName; data.ProductCategoryId = model.ProductCategoryId; data.ProductID = model.ProductID; data.QunatityProduced = model.QunatityProduced; data.UnitPrice = model.UnitPrice; data.StockLeft = model.StockLeft; data.DateProduced = model.DateProduced; data.ExpiryDate = model.ExpiryDate; data.DateUpdated = DateTime.Now; _context.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public bool Save(Batch_Model model) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = new Batch() { BatchID = GetNewBatchID(), BatchName = model.BatchName, ProductCategoryId = model.ProductCategoryId, ProductID = model.ProductID, QunatityProduced = model.QunatityProduced, UnitPrice = model.UnitPrice, StockLeft = Convert.ToInt64(model.QunatityProduced), DateProduced = model.DateProduced, ExpiryDate = model.ExpiryDate, DateCreated = DateTime.Now }; _context.Batches.Add(data); _context.SaveChanges(); return(true); } catch (Exception) { throw; } } }
public ActionResult BatchAdd(Batch_Model batch_Model) { if (string.IsNullOrEmpty(batch_Model.BatchName)) { ViewBag.AddBatchError = "Error"; return(View("Batch")); } else { if (Batch_.Save(batch_Model)) { Session["Success"] = batch_Model.BatchName + " added successfully!!"; } else { Session["Error"] = batch_Model.BatchName + " couldn't be added please retry!!"; } return(RedirectToAction("Batch")); } }
public ActionResult BatchDelete(Batch_Model batch_Model) { var Batch_Name = batch_Model.BatchName; try { if (Batch_.Delete(batch_Model.BatchID)) { return(Json(Batch_Name + " batch has been deleted successfully")); } else { return(Json("Error")); } } catch (Exception e) { return(Json("Error" + e.ToString())); } }
public ActionResult BatchUpdate(Batch_Model batch_Model) { if (string.IsNullOrEmpty(batch_Model.BatchName)) { ViewBag.UpdateBatchError = "Error"; ViewBag.UpdateBatchData = batch_Model.BatchID; return(View("Batch")); } else { if (Batch_.Update(batch_Model)) { Session["Success"] = batch_Model.BatchName + " updated successfully!!"; return(RedirectToAction("Batch")); } else { Session["Error"] = batch_Model.BatchName + " couldn't be updated please retry!!"; return(View("Batch")); } } }