public ActionResult ViewDrugsDetails() { List <AdminDrugDetailsModel> lst = new List <AdminDrugDetailsModel>(); using (ProjectEntities db = new ProjectEntities()) { var getdata = db.Drugs.Where(a => a.IsDeleted == false); foreach (var item in getdata) { lst.Add(new AdminDrugDetailsModel { DrugId = item.DrugId, DrugName = item.DrugName, ManufactureDate = Convert.ToDateTime(item.ManufactureDate), ExpiredDate = Convert.ToDateTime(item.ExpiredDate), UsedFor = item.UsedFor, SideEffects = item.SideEffects, TotalQuantityAvailable = Convert.ToInt32(item.TotalQuantityAvailable), }); } } AdminDrugDetailsModel model = new AdminDrugDetailsModel(); model.lstdrugdetail = lst; return(View(model)); }
public ActionResult EditDrugDetails(int id) { AdminDrugDetailsModel model = new AdminDrugDetailsModel(); using (ProjectEntities db = new ProjectEntities()) { var getdata = db.Drugs.SingleOrDefault(a => a.DrugId == id); model.DrugId = getdata.DrugId; model.DrugName = getdata.DrugName; model.ManufactureDate = Convert.ToDateTime(getdata.ManufactureDate); model.ExpiredDate = Convert.ToDateTime(getdata.ExpiredDate); model.UsedFor = getdata.UsedFor; model.SideEffects = getdata.SideEffects; model.TotalQuantityAvailable = Convert.ToInt32(getdata.TotalQuantityAvailable); model.IsDeleted = Convert.ToBoolean(getdata.IsDeleted); return(View("AddDrugDetails", model)); } }
public ActionResult PostDrugDetails(AdminDrugDetailsModel model) { using (ProjectEntities db = new ProjectEntities()) { if (model.DrugId == 0) { // insert db.InsertDrugDetails(model.DrugName, model.ManufactureDate, model.ExpiredDate, model.UsedFor, model.SideEffects, model.TotalQuantityAvailable, model.IsDeleted); ViewBag.Message = "Inserted"; } else { // update db.UpdateDrugDetails(model.DrugId, model.DrugName, model.ManufactureDate, model.ExpiredDate, model.UsedFor, model.SideEffects, model.TotalQuantityAvailable, model.IsDeleted); ViewBag.Message = "Updated"; } } return(View("AddDrugDetails")); }