public static SelectList GetRoleList()
{
using (var ent = new DirectoryEntities())
{
return(new SelectList(ent.AspNetRoles.ToList(), "Name", "Name"));
}
}
public static SelectList GetAllPalika()
{
using (var ent = new DirectoryEntities())
{
return(new SelectList(ent.tblPalikas.ToList(), "PalikaId_val", "PalikaName_Nep"));
}
}
public static SelectList GetAllState()
{
using (var ent = new DirectoryEntities())
{
return(new SelectList(ent.tblStates.ToList(), "StateId_val", "StateName_Nep"));
}
}
public static SelectList GetAllDirectorySubCategory()
{
using (var ent = new DirectoryEntities())
{
return(new SelectList(ent.tblDirectorySubCategories.ToList(), "DirectorySubCategoryId", "DirectorySubCategoryName"));
}
}
public static SelectList GetAllDistrict()
{
using (var ent = new DirectoryEntities())
{
return(new SelectList(ent.tblDistricts.ToList(), "DistrictId_val", "DistrictName_Nep"));
}
}
public static SelectList GetDirectorySubCategoryById(int id)
{
List <SelectListItem> subCatList = new List <SelectListItem>();
using (DirectoryEntities db = new DirectoryEntities())
{
return(new SelectList(db.tblDirectorySubCategories.Where(x => x.DirectoryCategoryId == id).ToList(), "DirectorySubCategoryId", "DirectorySubCategoryName"));
}
}
public static string GetStateName(int?id)
{
using (var ent = new DirectoryEntities())
{
var obj = ent.tblStates.Where(x => x.StateId_val == id).SingleOrDefault();
if (obj != null)
{
return(obj.StateName);
}
else
{
return("");
}
}
}
public static string GetDistrictById(int?id)
{
using (var ent = new DirectoryEntities())
{
var obj = ent.tblDistricts.Where(x => x.DistrictId_val == id).SingleOrDefault();
if (obj != null)
{
return(obj.DistrictName_Nep);
}
else
{
return("");
}
}
}
public static string GetDirectorySubCategoryName(int?id)
{
using (var ent = new DirectoryEntities())
{
var obj = ent.tblDirectorySubCategories.Where(x => x.DirectorySubCategoryId == id).SingleOrDefault();
if (obj != null)
{
return(obj.DirectorySubCategoryName);
}
else
{
return("");
}
}
}