public async Task <List <AppointmentEdit> > Query(Dictionary <string, object> param)
{
try
{
var data = await _adapterPattern.ExecuteQuery <AppointmentEdit>(param, "usp_Appointment", DataConfiguration.instanceCore);
return(data.ToList());
}
catch (Exception ex)
{
Logger.LogError(ex);
return(null);
}
}
public async Task <Schedule> GetScheduleExamine(Dictionary <string, object> param)
{
try
{
var data = await _adapterPattern.ExecuteQuery <Schedule>(param, "usp_spa_ScheduleExamine", DataConfiguration.instanceCore);
return(data.FirstOrDefault());
}
catch (Exception ex)
{
Logger.LogError(ex);
return(null);
}
}
public async Task <List <User> > GetUserHaveScheduleExamine(Dictionary <string, object> param)
{
try
{
var data = await _adapterPattern.ExecuteQuery <User>(param, "usp_spa_User_HasScheduleExamine", DataConfiguration.instanceCore);
return(data.ToList());
}
catch (Exception ex)
{
Logger.LogError(ex);
return(null);
}
}
public async Task <IEnumerable <DepartmentServices> > Query(Dictionary <string, dynamic> para)
{
try
{
var data = await _adapterPattern.ExecuteQuery <DepartmentServices>(para, "usp_spa_DepartmentServices", DataConfiguration.instanceCore);
return(data.ToList());
}
catch (Exception ex)
{
Logger.LogError(ex);
return(null);
}
}
public async Task <List <Feature> > Query(Dictionary <string, object> param)
{
try
{
var data = await _adapterPattern.ExecuteQuery <Feature>(param, "usp_spa_Feature", DataConfiguration.instanceCMS);
return(data.ToList());
}
catch (Exception ex)
{
Logger.LogError(ex);
return(null);
}
}
/// <summary>
/// Get Module
/// </summary>
/// <param name="param">Dictionary</param>
/// <returns>List Module</returns>
public async Task <IEnumerable <Module> > Query(Dictionary <string, object> param, string procedureName)
{
try
{
var data = await _adapterPattern.ExecuteQuery <Module>(param, procedureName, DataConfiguration.instanceCore);
return(data.ToList());
}
catch (Exception ex)
{
Logger.LogError(ex);
return(null);
}
}
/// <summary>
/// Get all
/// </summary>
/// <returns></returns>
public async Task <IEnumerable <Advertise> > Query(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.ExecuteQuery <Advertise>(para, "usp_Advertise"));
}
/// <summary>
/// Get all
/// </summary>
/// <returns></returns>
public async Task <IEnumerable <PostList> > Query(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.ExecuteQuery <PostList>(para, "usp_Post"));
}
/// <summary>
/// Get all
/// </summary>
/// <returns></returns>
public async Task <IEnumerable <Category> > Query(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.ExecuteQuery <Category>(para, "usp_Category"));
}
/// <summary>
/// Get all
/// </summary>
/// <returns></returns>
public async Task<IEnumerable<Slider>> Query(Dictionary<string, dynamic> para)
{
return await _adapterPattern.ExecuteQuery<Slider>(para, "usp_Slider");
}
/// <summary>
/// Get all
/// </summary>
/// <returns></returns>
public async Task <IEnumerable <Workflow> > Query(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.ExecuteQuery <Workflow>(para, "usp_Workflow"));
}
/// <summary>
/// Get all
/// </summary>
/// <returns></returns>
public async Task <IEnumerable <LinkBuilding> > Query(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.ExecuteQuery <LinkBuilding>(para, "usp_LinkBuilding"));
}
/// <summary>
/// Get all
/// </summary>
/// <returns></returns>
public async Task <IEnumerable <GalleryStore> > Query(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.ExecuteQuery <GalleryStore>(para, "usp_GalleryStore"));
}
public async Task <IEnumerable <T> > ExecuteQuery <T>(Dictionary <string, dynamic> obj, string proc, byte instance)
{
return(await _adapterPattern.ExecuteQuery <T>(obj, proc, instance));
}
public async Task <IEnumerable <QA> > Query(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.ExecuteQuery <QA>(para, "usp_QA", DataConfiguration.instanceCore));
}
/// <summary>
/// Get all
/// </summary>
/// <returns></returns>
public async Task <IEnumerable <DepartmentServices> > Query(Dictionary <string, dynamic> para)
{
return(await _adapterPattern.ExecuteQuery <DepartmentServices>(para, "usp_DepartmentServices", 2));
}
public Task <IEnumerable <int> > Internal_Counter()
{
return(_adapterPattern.ExecuteQuery <int>(null, "usp_Internal_Dashboard", DataConfiguration.instanceCore));
}
