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