public static ReturnObject GetEmployeeData(int page_number, bool is_filter, string filters)
{
leave_assign page_object = new leave_assign();
ReturnObject return_object = new ReturnObject();
DBConnection db_connection = new DBConnection();
DataTable employee_data = new DataTable();
string query = string.Empty;
int start_row = 0, number_of_record = 0;
try
{
//set rows count
start_row = (page_number - 1) * 30;
number_of_record = page_number * 30 + 1;
//get base query
query = page_object.GetEmployeeBaseQuery();
//append filter query
if (is_filter)
{
query = page_object.GetFilterQuery(filters, query);
}
//append paging
query += " ) Employees where row > " + start_row + " and row < " + number_of_record;
employee_data = db_connection.ReturnDataTable(query);
return_object.status = "success";
return_object.return_data = JsonConvert.SerializeObject(employee_data, Formatting.Indented);
}
catch (Exception ex)
{
Logger.LogException(ex, page, "GET_EMPLOYEE_DATA");
return_object.status = "error";
return_object.return_data = "An error occurred while loading Employee Data. Please try again. If the error persists, please contact Support.";
}
return(return_object);
}
