/// <summary> /// Load data method. /// </summary> /// <returns>Returns - Data</returns> private static List <Country> LoadData() { // Initialization. List <Country> lst = new List <Country>(); try { using (var db = new AnroAppEntities()) { lst = db.Countries.ToList(); } } catch (Exception ex) { Console.Write(ex); } return(lst); }
public static DTResult <Country> GetDataFromBL(HttpContext context, List <DTColumn> columns) { DTResult <Country> dataCountry = new DTResult <Country>(); DTParameters param = DataTableCommon.SetParameters(context, columns); try { using (var db = new AnroAppEntities()) { var query = db.Countries.AsQueryable().Where(a => (a.CountryName.Contains(param.Search.Value) || param.Search.Value == null));; dataCountry = DataTableFiltering <Country> .GetResult(param, query); } } catch (Exception ex) { Console.Write(ex); } return(dataCountry); }