public ActionResult EditDrugs(int?ID) { CASDatabaseEntities db = new CASDatabaseEntities(); DrugDataModel dt = new DrugDataModel(); int id = Convert.ToInt32(ID); var getData = db.Drugs.Where(m => m.DrugID == id).FirstOrDefault(); if (getData != null) { dt.DrugName = getData.DrugName; dt.Manufacturer = getData.Manufacturer; dt.Substitutions = getData.Substitutions; dt.Uses = getData.Uses; dt.SideEffects = getData.SideEffects; dt.NotRecommended = getData.NotRecommended; dt.MfgDate = getData.MfgDate; dt.ExpDate = getData.ExpDate; dt.QOH = getData.QOH; dt.QOHType = getData.QOHType; dt.Price = Convert.ToDouble(getData.Price); dt.DiscountAmount = Convert.ToDouble(getData.DiscountAmount); dt.IsDeleted = getData.IsDeleted; } return(View(dt)); }
public ActionResult AddDrugs(DrugDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); Drug objDrug = new Drug(); if (ModelState.IsValid) { var getData = db.Drugs.Where(m => m.DrugName == dt.DrugName).FirstOrDefault(); if (getData != null) { ViewBag.Text = "Drug Already Present. Only Updation Allowed"; } else { if (dt.QOH == 0) { ViewBag.Text = "New Drug Cannot Be Entered With ZERO Quantity."; } else { if (dt.MfgDate > DateTime.Today || dt.ExpDate < DateTime.Today) { ViewBag.Text = "Invalid Manufacturing or Expiry Date"; } else { objDrug.DrugName = dt.DrugName; objDrug.Manufacturer = dt.Manufacturer; objDrug.Substitutions = dt.Substitutions; objDrug.MfgDate = dt.MfgDate; objDrug.ExpDate = dt.ExpDate; objDrug.Uses = dt.Uses; objDrug.SideEffects = dt.SideEffects; objDrug.NotRecommended = dt.NotRecommended; objDrug.QOH = dt.QOH; objDrug.QOHType = dt.QOHType; objDrug.Price = Convert.ToDecimal(dt.Price); objDrug.DiscountAmount = Convert.ToDecimal(dt.DiscountAmount); objDrug.IsDeleted = false; db.Drugs.Add(objDrug); db.SaveChanges(); ViewBag.Text = "Drug Inserted Successfully"; } } } } return(View(dt)); }
public ActionResult DeleteDrugs(int?ID) { CASDatabaseEntities db = new CASDatabaseEntities(); DrugDataModel dt = new DrugDataModel(); int id = Convert.ToInt32(ID); var getData = db.Drugs.Where(m => m.DrugID == id).FirstOrDefault(); if (getData != null) { getData.IsDeleted = true; dt.IsDeleted = getData.IsDeleted; db.SaveChanges(); } return(RedirectToAction("ViewDrugs", "Admin")); }
public ActionResult Drugs() { CASDatabaseEntities db = new CASDatabaseEntities(); List <DrugDataModel> list = new List <DrugDataModel>(); DrugDataModel dt = new DrugDataModel(); var getDetails = from d in db.Drugs where d.IsDeleted == false select new { d.DrugName, d.Manufacturer, d.Substitutions, d.Uses, d.SideEffects, d.NotRecommended, d.MfgDate, d.ExpDate, d.QOH, d.QOHType, d.Price, d.DiscountAmount, }; foreach (var item in getDetails) { list.Add(new DrugDataModel { DrugName = item.DrugName, Manufacturer = item.Manufacturer, Substitutions = item.Substitutions, Uses = item.Uses, SideEffects = item.SideEffects, NotRecommended = item.NotRecommended, MfgDate = item.MfgDate, ExpDate = item.ExpDate, QOH = item.QOH, QOHType = item.QOHType, Price = Convert.ToDouble(item.Price), DiscountAmount = Convert.ToDouble(item.DiscountAmount), }); } dt.ListDrugs = list; return(View(dt)); }
public ActionResult ViewDrugs() { CASDatabaseEntities db = new CASDatabaseEntities(); List <DrugDataModel> list = new List <DrugDataModel>(); DrugDataModel dt = new DrugDataModel(); var getDetails = from d in db.Drugs select new { d.DrugID, d.DrugName, d.Manufacturer, d.MfgDate, d.ExpDate, d.QOH, d.QOHType, d.Price, d.DiscountAmount, d.IsDeleted }; foreach (var item in getDetails) { list.Add(new DrugDataModel { DrugID = item.DrugID, DrugName = item.DrugName, Manufacturer = item.Manufacturer, MfgDate = item.MfgDate, ExpDate = item.ExpDate, QOH = item.QOH, QOHType = item.QOHType, Price = Convert.ToDouble(item.Price), DiscountAmount = Convert.ToDouble(item.DiscountAmount), IsDeleted = item.IsDeleted, }); } dt.ListDrugs = list; return(View(dt)); }
public ActionResult EditDrugs(int?ID, DrugDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); int id = Convert.ToInt32(ID); var getData = db.Drugs.Where(m => m.DrugID == id).FirstOrDefault(); if (ModelState.IsValid) { if (getData != null) { if (getData.QOH == 0 && dt.QOH > 0) { getData.IsDeleted = false; } else if (dt.QOH > 0 && dt.IsDeleted == false) { getData.IsDeleted = false; } else { getData.IsDeleted = true; } getData.DrugName = dt.DrugName; getData.Manufacturer = dt.Manufacturer; getData.Substitutions = dt.Substitutions; getData.Uses = dt.Uses; getData.SideEffects = dt.SideEffects; getData.NotRecommended = dt.NotRecommended; getData.MfgDate = dt.MfgDate; getData.ExpDate = dt.ExpDate; getData.QOH = dt.QOH; getData.QOHType = dt.QOHType; getData.Price = Convert.ToDecimal(dt.Price); getData.DiscountAmount = Convert.ToDecimal(dt.DiscountAmount); db.SaveChanges(); } } return(RedirectToAction("ViewDrugs", "Salesperson")); }