public List <ServiceOperatorModel> GetRecords(int?page, int?limit, string sortBy, string direction, string searchString, out int total)
{
string sqlQuery = " EXEC spGetServiceList ";
IDataReader dr = objDAL.GetDataReader(sqlQuery, KeyConstant.Server_Sahbox_17);
List <ServiceOperatorModel> OperatorDataList = new List <ServiceOperatorModel>();
while (dr.Read())
{
ServiceOperatorModel objServiceOperatorModel = new ServiceOperatorModel();
objServiceOperatorModel.Live = Convert.ToString(dr["Live"], null);
objServiceOperatorModel.Expired = Convert.ToString(dr["Expired"], null);
objServiceOperatorModel.Operator = Convert.ToString(dr["Operator"], null);
OperatorDataList.Add(objServiceOperatorModel);
}
total = OperatorDataList.Count();
var records = OperatorDataList.Select(a => a);
if (!string.IsNullOrWhiteSpace(searchString))
{
records = OperatorDataList.Where(p => p.Operator.Contains(searchString) || p.Live.Contains(searchString));
}
if (!string.IsNullOrEmpty(sortBy) && !string.IsNullOrEmpty(direction))
{
if (direction.Trim().ToLower() == "asc")
{
//records = SortHelper.OrderBy(records, sortBy);
}
else
{
// records = SortHelper.OrderByDescending(records, sortBy);
}
}
if (page.HasValue && limit.HasValue)
{
int start = (page.Value - 1) * limit.Value;
records = records.Skip(start).Take(limit.Value);
}
return(records.ToList());
}
public void Save(ServiceOperatorModel player)
{
}