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