public async Task <User> Get(Dictionary <string, object> param)
{
try
{
return(await _adapterPattern.SingleExecuteQuery <User>(param, "usp_spa_User", DataConfiguration.instanceCore));
}
catch (Exception ex)
{
Logger.LogError(ex);
return(null);
}
}
public async Task <ArticleComment> SingleQuery(Dictionary <string, object> param)
{
try
{
return(await _adapterPattern.SingleExecuteQuery <ArticleComment>(param, "usp_ArticleComment", DataConfiguration.instanceCore));
}
catch (Exception ex)
{
Logger.LogError(ex);
return(null);
}
}
/// <summary>
/// get user
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public async Task <DoctorProfile> SingleQuery(Dictionary <string, object> param)
{
try
{
return(await _adapterPattern.SingleExecuteQuery <DoctorProfile>(param, "usp_DoctorProfile", DataConfiguration.instanceCore));
}
catch (Exception ex)
{
Logger.LogError(ex);
throw ex;
}
}
public async Task <bool> ApprovedBook(Dictionary <string, object> param)
{
try
{
var val = await _adapterPattern.SingleExecuteQuery <bool>(param, "usp_AppointmentLog_ApprovedBook", DataConfiguration.instanceCore);
return(val);
}
catch (Exception ex)
{
Logger.LogError(ex);
return(false);
}
}
public async Task <SystemNotification> SingleQuery(Dictionary <string, dynamic> para)
{
try
{
var data = await _adapterPattern.SingleExecuteQuery <SystemNotification>(para, "usp_SystemNotification", DataConfiguration.instanceCore);
return(data);
}
catch (Exception ex)
{
Logger.LogError(ex);
return(null);
}
}
public Task <bool> CheckPermission(Dictionary <string, dynamic> para)
{
return(_adapterPattern.SingleExecuteQuery <bool>(para, "usp_CheckPermission", DataConfiguration.instanceCore));
}
public async Task <bool> CheckExist(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.SingleExecuteQuery <bool>(para, "usp_Advertise_CheckExistName"));
}
/// <summary>
/// Get by condition
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public async Task <Post> SingleQuery(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.SingleExecuteQuery <Post>(para, "usp_Post"));
}
public async Task <SEOPage> SingleQuery(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.SingleExecuteQuery <SEOPage>(para, "usp_spa_SEOPage"));
}
/// <summary>
/// Get by condition
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public async Task <Workflow> SingleQuery(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.SingleExecuteQuery <Workflow>(para, "usp_Workflow"));
}
/// <summary>
/// Get by condition
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public async Task <LinkBuilding> SingleQuery(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.SingleExecuteQuery <LinkBuilding>(para, "usp_LinkBuilding"));
}
/// <summary>
/// Get by condition
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public async Task <GalleryStore> SingleQuery(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.SingleExecuteQuery <GalleryStore>(para, "usp_GalleryStore"));
}
public async Task <T> SingleExecuteQuery <T>(Dictionary <string, dynamic> obj, string proc, byte instance, DataConfiguration.DapperQueryOption queryOption)
{
return(await _adapterPattern.SingleExecuteQuery <T>(obj, proc, instance, queryOption));
}
public async Task <Gallery> Get(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.SingleExecuteQuery <Gallery>(para, "usp_spa_Gallery"));
}
/// <summary>
/// Get by condition
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public async Task<Slider> SingleQuery(Dictionary<string, dynamic> para)
{
return await _adapterPattern.SingleExecuteQuery<Slider>(para, "usp_Slider");
}
/// <summary>
/// Get by condition
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public async Task <Setting> SingleQuery(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.SingleExecuteQuery <Setting>(para, "usp_Setting", DataConfiguration.instanceCore));
}
/// <summary>
/// Get by condition
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public async Task <Category> SingleQuery(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.SingleExecuteQuery <Category>(para, "usp_Category"));
}
/// <summary>
/// Get by condition
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public async Task <DepartmentServices> SingleQuery(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.SingleExecuteQuery <DepartmentServices>(para, "usp_DepartmentServices", 2));
}
/// <summary>
/// Get by condition
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public async Task <CMSConfiguration> SingleQuery(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.SingleExecuteQuery <CMSConfiguration>(para, "usp_Configuration"));
}