public long TotalRecord(object whereClause)
{
try
{
using (AAASIncidentRepository AIRepo = new AAASIncidentRepository())
{
return(AIRepo.RecordCount <AAASIncident>(whereClause));
}
}
catch (Exception ex)
{
throw ex;
}
}
public DataTableModel ListPaged(Dictionary <string, string> dic = null)
{
try
{
string[] searchColumns = new string[] { "User_Contact_Number", "Incident_Type", "Description", "Created_By" };
DataTableModel dtModel = new DataTableModel();
Meta meta = new Meta();
if (dic.TryGetValue("pagination[page]", out string page))
{
meta.page = Convert.ToInt64(page);
}
if (dic.TryGetValue("pagination[pages]", out string pages))
{
meta.pages = Convert.ToInt64(pages);
}
if (dic.TryGetValue("pagination[perpage]", out string perpage))
{
meta.perpage = Convert.ToInt64(perpage);
}
var parameters = this.ParseParameters(dic);
using (AAASIncidentRepository IncidentRepository = new AAASIncidentRepository())
{
dtModel.Data = IncidentRepository.GetListPaged <AAASIncident>(Convert.ToInt32(dic["pagination[page]"]), Convert.ToInt32(dic["pagination[perpage]"]), parameters, parameters["orderby"].ToString() + " " + parameters["sortorder"].ToString(), searchColumns);
meta.total = IncidentRepository.RecordCount <AAASIncident>(parameters, searchColumns);
}
dtModel.Meta = meta;
return(dtModel);
}
catch (Exception ex)
{
throw ex;
}
}