/// <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);
}
