/// <summary>
/// This is the method that provide Paging mechanism using stored procedure but current not imilimented
/// </summary>
/// <param name="searchValue"></param>
/// <param name="CurrentPage"></param>
/// <param name="PageSize"></param>
/// <param name="TotalRows"></param>
/// <returns></returns>
public List <CompanyVM> GetList(string searchValue, int CurrentPage, int PageSize, out int TotalRows)
{
List <CompanyVM> list = new List <CompanyVM>();
try
{
using (CMS_DbEntities db = new CMS_DbEntities())
{
List <SpCompany> companies = new List <SpCompany>();
companies = db.UserSP_GetCompany(searchValue, 1, 10, "Name", "ASC").ToList();
TotalRows = (companies.Count() > 0) ? (companies.FirstOrDefault().MaxRows ?? 0) : 0;
foreach (SpCompany company in companies)
{
list.Add(converter.ConvertToModel(company));
}
}
}
catch (Exception ex)
{
// We can add a error logger to record all exception
throw;
}
return(list);
}
