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));
}
