public long TotalRecord(object whereClause) { try { using (AAASSOSRepository ASRepo = new AAASSOSRepository()) { return(ASRepo.RecordCount <AAASSOS>(whereClause)); } } catch (Exception ex) { throw ex; } }
public DataTableModel ListPaged(Dictionary <string, string> dic = null) { try { string[] searchColumns = new string[] { "User_Contact_Number", "User_IMEI", "Address", "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 (AAASSOSRepository SosRepository = new AAASSOSRepository()) { dtModel.Data = SosRepository.GetListPaged <AAASSOS>(Convert.ToInt32(dic["pagination[page]"]), Convert.ToInt32(dic["pagination[perpage]"]), parameters, parameters["orderby"].ToString() + " " + parameters["sortorder"].ToString(), searchColumns); meta.total = SosRepository.RecordCount <AAASSOS>(parameters, searchColumns); } dtModel.Meta = meta; return(dtModel); } catch (Exception ex) { throw ex; } }