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