public async Task <Tuple <IEnumerable <UserProfile>, int> > GetDoctorList(Dictionary <string, dynamic> param)
{
try
{
Tuple <IEnumerable <UserProfile>, int> data = await _adapterPattern.ExecuteQueryOut <UserProfile>(param, "usp_spa_User", "totalItem", DataConfiguration.instanceCore);
return(data);
}
catch (Exception ex)
{
Logger.LogError(ex);
return(null);
}
}
public async Task <Tuple <IEnumerable <SystemNotification>, int> > QueryPaging(Dictionary <string, dynamic> para)
{
Tuple <IEnumerable <SystemNotification>, int> data = await _adapterPattern.ExecuteQueryOut <SystemNotification>(para, "usp_SystemNotification", "totalItem", 2);
return(data);
}
//public async Task<List<PostList>> GetAll(string languageCode, int categoryId, string numTop, byte priority)
//{
// try
// {
// //DapperConfiguration.OpenConnection(1);
// using (IDbConnection dapper = DapperConfiguration.Open(1))
// {
// var data = await dapper.QueryAsync<PostList>("usp_spa_Post",
// new { languageCode = languageCode, categoryId = categoryId, numTop = numTop, priority = priority },
// commandType: System.Data.CommandType.StoredProcedure);
// dapper.Close();
// return data.ToList();
// }
// // DapperConfiguration.CloseConnection();
// }
// catch (Exception ex)
// {
// Logger.LogError(ex);
// return null;
// }
//}
public async Task <Tuple <IEnumerable <PostList>, int> > QueryPaging(Dictionary <string, dynamic> para)
{
Tuple <IEnumerable <PostList>, int> data = await _adapterPattern.ExecuteQueryOut <PostList>(para, "usp_spa_Post_Paging", "totalItem", 1);
return(data);
}
public async Task <Tuple <IEnumerable <QA>, int> > Query(Dictionary <string, dynamic> para)
{
Tuple <IEnumerable <QA>, int> data = await _adapterPattern.ExecuteQueryOut <QA>(para, "usp_spa_QA", "totalItem", DataConfiguration.instanceCore);
return(data);
}
