public ActionResult Bed()
{
List <Bed> CategoryList = new List <Bed>();
Property p = new Property();
DataSet ds = new DataSet();
p.OnTable = "FetchBed";
ds = dl.FetchBed_sp(p);
List <SelectListItem> Typeinventory = new List <SelectListItem>();
Typeinventory.Add(new SelectListItem {
Text = "Select", Value = ""
});
foreach (DataRow dr in ds.Tables[1].Rows)
{
Typeinventory.Add(new SelectListItem {
Text = dr["Purpose"].ToString(), Value = dr["TId"].ToString()
});
}
ViewBag.Typeinventory = new SelectList(Typeinventory, "Value", "Text");
List <SelectListItem> Groupinventory = new List <SelectListItem>();
Groupinventory.Add(new SelectListItem {
Text = "Select", Value = ""
});
foreach (DataRow dr in ds.Tables[2].Rows)
{
Groupinventory.Add(new SelectListItem {
Text = dr["GName"].ToString(), Value = dr["BGId"].ToString()
});
}
ViewBag.Groupinventory = new SelectList(Groupinventory, "Value", "Text");
try
{
foreach (DataRow item in ds.Tables[0].Rows)
{
Bed m = new Bed();
m.BId = item["BId"].ToString();
m.BName = item["BName"].ToString();
m.TId = item["TId"].ToString();
m.Purpose = item["Purpose"].ToString();
m.BGId = item["BGId"].ToString();
m.GName = item["GName"].ToString();
m.AddedBy = item["AddedBy"].ToString();
m.IsActive = item["IsActive"].ToString();
CategoryList.Add(m);
}
ViewBag.CategoryList = CategoryList;
}
catch (Exception e)
{
}
return(View());
}