public ActionResult PharmacyStoresOrder(wardstockMainModel obj) { var wardList = db.Wards.ToList().Where(a => a.ID > 0); obj.WardList = (from d in wardList select new SelectListItem { Value = d.ID.ToString(), Text = d.WardName }).ToList(); //string ward_Name = Ward_Name; int ID = Convert.ToInt32(obj.ID); Ward objm = new Ward(); //var qq = y; objm = db.Wards.Where(e => e.ID == ID).FirstOrDefault(); if (objm == null) { obj.WardstockList = (from e in db.wardstocks select new wardstockMainModel { ID = e.ID, lnkdid = e.lnkdid, costcentre = e.costcentre, drugfull = e.drugfull, drug_form = e.drug_form, drug_name = e.drug_name, drug_packsize = e.drug_packsize, drug_strength = e.drug_strength }).ToList(); } else { obj.WardstockList = (from e in db.wardstocks where e.costcentre == objm.WardName select new wardstockMainModel { ID = e.ID, lnkdid = e.lnkdid, costcentre = e.costcentre, drugfull = e.drugfull, drug_form = e.drug_form, drug_name = e.drug_name, drug_packsize = e.drug_packsize, drug_strength = e.drug_strength }).ToList(); } return(View(obj)); }
public ActionResult PharmacyStoresOrder(string WardName) { wardstockMainModel obj = new wardstockMainModel(); try { if (WardName != null) { var wardList = db.Wards.ToList().Where(a => a.WardName == WardName); obj.WardList = (from d in wardList where d.WardName == WardName select new SelectListItem { Value = d.ID.ToString(), Text = d.WardName }).ToList(); var qq = (from e in db.wardstocks select new wardstockMainModel { ID = e.ID, lnkdid = e.lnkdid, costcentre = e.costcentre, drugfull = e.drugfull, drug_form = e.drug_form, drug_name = e.drug_name, drug_packsize = e.drug_packsize, drug_strength = e.drug_strength }).ToList(); obj.WardstockList = qq; } else { var wardList = db.Wards.ToList().Where(a => a.ID > 0); obj.WardList = (from d in wardList select new SelectListItem { Value = d.ID.ToString(), Text = d.WardName }).ToList(); var qq = (from e in db.wardstocks select new wardstockMainModel { ID = e.ID, lnkdid = e.lnkdid, costcentre = e.costcentre, drugfull = e.drugfull, drug_form = e.drug_form, drug_name = e.drug_name, drug_packsize = e.drug_packsize, drug_strength = e.drug_strength }).ToList(); obj.WardstockList = qq; } } catch (Exception ex) { TempData["Alert"] = string.Format("A server error occurred. Please contact the administrator."); } return(View("PharmacyStoresOrder", obj)); }