public void TestReadStudents()
{
DBConnection.Type = DBType.MySQL;
DBConnection.ConnectionString = "Server=localhost;Port=3306;Uid=root;Pwd=system32;Database=Students;CheckParameters=false;";
long total = 0;
long pages = 0;
var list = StudentMapper.GetAllPaginatedWhere(1, 10, out total, out pages, "");
Assert.AreNotEqual(0, total);
Assert.AreNotEqual(0, pages);
Assert.AreNotEqual(null, list);
Assert.AreNotEqual(0, list.Count);
}
public StudentsResponse GetPaginatedList(DateTime startDate, DateTime endDate, string name, bool isEnabled, string gender, string type, int pageNumber, int pageSize, string sortBy, string sortDirection)
{
var listResult = new List <Student>();
long totalItems = 0;
long totalPages = 0;
try
{
string filter = string.Empty;
string joinOperator = string.Empty;
//filter = " convert(date, updated_on) between '" + startDate.ToString("yyyyMMdd") + "' and '" + endDate.ToString("yyyyMMdd") + "' ";
filter = " updated_on >= '" + startDate.ToString("yyyy-MM-dd") + "' and updated_on <= '" + endDate.ToString("yyyy-MM-dd") + "' + INTERVAL 1 DAY ";
if (!string.IsNullOrEmpty(name))
{
filter += " and name like '%" + name + "%'";
}
if (!string.IsNullOrEmpty(gender))
{
filter += " and gender = '" + gender + "'";
}
joinOperator = (string.IsNullOrEmpty(filter) ? string.Empty : " and ");
if (!string.IsNullOrEmpty(type))
{
filter += " and type = '" + type + "'";
}
listResult = StudentMapper.GetAllPaginatedWhere(pageNumber, pageSize, out totalItems, out totalPages, filter, sortBy, sortDirection, isEnabled);
}
catch (Exception ex)
{
Logger.Create().Exception(ex);
}
return(new StudentsResponse {
Students = listResult, TotalStudents = totalItems, TotalPages = totalPages
});
}