public ActionResult Dosage() { List <PharmacyDosage> CategoryList = new List <PharmacyDosage>(); Property p = new Property(); DataSet ds = new DataSet(); p.OnTable = "FetchPharmacyDosage"; ds = dl.FetchPharmacyDosage_sp(p); List <SelectListItem> Categoryinventory = new List <SelectListItem>(); Categoryinventory.Add(new SelectListItem { Text = "Select", Value = "" }); foreach (DataRow dr in ds.Tables[1].Rows) { Categoryinventory.Add(new SelectListItem { Text = dr["CategoryName"].ToString(), Value = dr["CategoryId"].ToString() }); } ViewBag.Categoryinventory = new SelectList(Categoryinventory, "Value", "Text"); try { foreach (DataRow item in ds.Tables[0].Rows) { PharmacyDosage m = new PharmacyDosage(); m.DosageId = item["DosageId"].ToString(); m.DName = item["DName"].ToString(); m.CategoryId = item["CategoryId"].ToString(); m.CategoryName = item["CategoryName"].ToString(); m.AddedBy = item["AddedBy"].ToString(); m.IsActive = item["IsActive"].ToString(); CategoryList.Add(m); } ViewBag.CategoryList = CategoryList; } catch (Exception e) { } return(View()); }
public ActionResult Dosage(PharmacyDosage c) { HttpCookie rxgoAdminCookie = Request.Cookies["rxgoAdmin"]; string AddedBy = rxgoAdminCookie.Values["Hid"]; c.AddedBy = AddedBy; try { if (dl.InsertPharmacyDosage_sp(c) > 0) { TempData["MSG"] = "Dosage Added Successfully"; } } catch (Exception ex) { TempData["MSG"] = "Something went wrong."; return(Redirect("/MedicineCategory/Dosage")); } TempData["MSG"] = "Dosage Added Successfully."; return(Redirect("/MedicineCategory/Dosage")); }