public ActionResult medicinDelete(int id = 0) { tbl_MedicineInfo bc1 = db.tbl_MedicineInfo.FirstOrDefault(s => s.MediInfoID == id); db.tbl_MedicineInfo.Remove(bc1); db.SaveChanges(); return(RedirectToAction("medicineInfoList")); }
public ActionResult medicineInfoList(string keyword, tbl_MedicineInfo model) { var results = (from item in db.tbl_MedicineInfo where item.MediName.Contains(keyword) || item.MedicompaName.Contains(keyword) select item).ToList(); var pageIndex = model.Page ?? 1; model.medicineInfoListResults = results.ToPagedList(pageIndex, RecordsPerPage); return(View(model)); }
public ActionResult medicineInfoList(tbl_MedicineInfo model) { var results = (from item in db.tbl_MedicineInfo select item).ToList().OrderBy(p => p.MediInfoID); var pageIndex = model.Page ?? 1; model.medicineInfoListResults = results.ToPagedList(pageIndex, RecordsPerPage); return(View(model)); }
public ActionResult addmedicineInfo(tbl_MedicineInfo medicineInfo) { if (ModelState.IsValid) { db.tbl_MedicineInfo.Add(medicineInfo); db.SaveChanges(); return(RedirectToAction("medicineInfoList")); } ViewBag.MediUnitID = new SelectList(db.tbl_MedicinUnit, "MediUnitID", "UnitName"); ViewBag.MediCataID = new SelectList(db.tbl_MedicinCatagory, "MediCataID", "CatagoryName"); return(View(medicineInfo)); }
public ActionResult medcinUpdate(int id = 0) { medicinId = id; tbl_MedicineInfo bc = db.tbl_MedicineInfo.FirstOrDefault(s => s.MediInfoID == medicinId); if (bc == null) { return(HttpNotFound()); } ViewBag.GetMediName = bc.MediName; ViewBag.GetMedicompaName = bc.MedicompaName; ViewBag.MediUnitID = new SelectList(db.tbl_MedicinUnit, "MediUnitID", "UnitName"); ViewBag.MediCataID = new SelectList(db.tbl_MedicinCatagory, "MediCataID", "CatagoryName"); return(View(bc)); }
public ActionResult medcinUpdate(tbl_MedicineInfo bc, int id = 0) { tbl_MedicineInfo bc1 = db.tbl_MedicineInfo.FirstOrDefault(s => s.MediInfoID == medicinId); bc1.MediName = bc.MediName; bc1.MedicompaName = bc.MedicompaName; bc1.MediUnitID = bc.MediUnitID; bc1.MediCataID = bc.MediCataID; if (bc1 == null) { return(HttpNotFound()); } db.SaveChanges(); ViewBag.MediUnitID = new SelectList(db.tbl_MedicinUnit, "MediUnitID", "UnitName"); ViewBag.MediCataID = new SelectList(db.tbl_MedicinCatagory, "MediCataID", "CatagoryName"); ViewBag.Message = "Update Successfuly"; return(View(bc1)); }