public List <SelectListItem> SupplierNName()
{
List <SelectListItem> lst_s = new List <SelectListItem>();
using (ProjectEntities1 ie = new ProjectEntities1())
{
var gdata = ie.Suppliers.ToList();
foreach (var item in gdata)
{
lst_s.Add(new SelectListItem
{
Text = item.FirstName + " " + item.LastName,
Value = item.SupplierId.ToString()
});
}
}
return(lst_s);
}
public List <SelectListItem> DoctorSpecs()
{
List <SelectListItem> lst_d = new List <SelectListItem>();
using (ProjectEntities1 ie = new ProjectEntities1())
{
var gdata = ie.SpecializedDatas.ToList();
foreach (var item in gdata)
{
lst_d.Add(new SelectListItem
{
Text = item.SpecializedName,
Value = item.SpecializedId.ToString()
});
}
}
return(lst_d);
}
public List <SelectListItem> DruGdetail()
{
List <SelectListItem> lst_d = new List <SelectListItem>();
using (ProjectEntities1 ie = new ProjectEntities1())
{
var gdata = ie.Drugs.ToList();
foreach (var item in gdata)
{
lst_d.Add(new SelectListItem
{
Text = item.DrugName,
Value = item.DrugId.ToString()
});
}
}
return(lst_d);
}
public List <SelectListItem> DoctorApp()
{
List <SelectListItem> lst_d = new List <SelectListItem>();
using (ProjectEntities1 ie = new ProjectEntities1())
{
var gdata = ie.Doctors.ToList();
foreach (var item in gdata)
{
var gdata2 = ie.SpecializedDatas.FirstOrDefault(a => a.SpecializedId == item.SpecializedId);
lst_d.Add(new SelectListItem
{
Text = item.FirstName + " " + item.LastName + " [ " + gdata2.SpecializedName + " ]",
Value = item.DoctorId.ToString()
});
}
}
return(lst_d);
}
public List <SelectListItem> RoleNName()
{
List <SelectListItem> lst = new List <SelectListItem>();
using (ProjectEntities1 ie = new ProjectEntities1())
{
var gdata = ie.RoleDetails.ToList();
foreach (var item in gdata)
{
lst.Add(new SelectListItem
{
Text = item.RoleName,
Value = item.RoleId.ToString()
});
}
}
return(lst);
/*RoleModel model = new RoleModel();
* model.listItems = lst;*/
}