public Task <List <PageSumQueryModel> > PageSumQuery()
{
string sql = "SELECT GRP_ID,SUM(CASE WHEN DATA_12 = @COLOUR THEN CAST(DOC_NB_PAGES AS INT)ELSE 0 END)as Colour_Totals,SUM(CASE WHEN DATA_12 = @MONO THEN CAST(DOC_NB_PAGES AS INT)ELSE 0 END)as Mono_Totals from dbo.ChartTestData GROUP BY GRP_ID;";
return(_db.LoadData <PageSumQueryModel, dynamic>(sql, new { COLOUR = "COLOUR", MONO = "MONO" }));
}
public List <PatientModel> GetPatients()
{
var output = _sqlDataAccess.LoadData <PatientModel, dynamic>("dbo.spUserRole_FindPatinets", new { });
return(output);
}
public Task <List <DataQuizModel> > GetQuizs()
{
string sql = "select * from quiz";
return(_db.LoadData <DataQuizModel, dynamic>(sql, new { }));
}
public List <MedicineModel> GetMedicines()
{
var output = _sqlDataAccess.LoadData <MedicineModel, dynamic>("dbo.spMedicines_FindAll", new { });
return(output);
}
public Task <List <SequenceList> > CreateGetSequence(string UserId)
{
string usp = "usp_ProcessTypeGroupCreateGetSequence @UserID";
return(_sqlDataAccess.LoadData <SequenceList, dynamic>(usp, new { UserId }));
}
public List <GenreModel> GetByBookId(int bookId)
{
var output = _dataAccess.LoadData <GenreModel, dynamic>("spBookGenre_GetByBookId", new { bookId }, "LibraryDatabase");
return(output);
}
public List <InventoryModel> GetInventory()
{
var output = _sql.LoadData <InventoryModel, dynamic>("dbo.spInventory_GetAll", new { }, "SRMData");
return(output);
}
public Task <List <PageSectionContentConditionTypeList> > List(string UserId)
{
string usp = "usp_PageSectionContentConditionTypeList @UserId";
return(_sqlDataAccess.LoadData <PageSectionContentConditionTypeList, dynamic>(usp, new { UserId = UserId }));
}
public List <UserModel> GetUserById(string Id)
{
var output = _sql.LoadData <UserModel, dynamic>("dbo.spUserLookup", new { Id }, "TulipData");
return(output);
}
public List <ClientModel> GetClients()
{
var output = _sql.LoadData <ClientModel, dynamic>("dbo.spClient_GetAll", new { }, "OHMData");
return(output);
}
public List <WindDataModel> GetAllData()
{
var output = _sql.LoadData <WindDataModel, dynamic>("dbo.spWindData_GetAllData", new { }, "WeatherStationDB");
return(output);
}
public Task <List <ClaimList> > CreateGetClaimList(string UserId, string RoleId)
{
string usp = "usp_RoleClaimCreateGetClaimList @UserId, @RoleID";
return(_sqlDataAccess.LoadData <ClaimList, dynamic>(usp, new { UserId, RoleId }));
}
public List <ProductModel> GetProducts()
{
return(_sqlDataAccess.LoadData <ProductModel, dynamic>("dbo.sqlProduct_GetAll", new { }, "RMData"));
}
public Task <List <ProcessTypeFlowPassComparisonOperatorList> > List(string UserId)
{
string usp = "usp_ProcessTypeFlowPassComparisonOperatorList @UserId";
return(_sqlDataAccess.LoadData <ProcessTypeFlowPassComparisonOperatorList, dynamic>(usp, new { UserId = UserId }));
}
public async Task <List <FrontContentContentTypeGroup> > ContentTypeContentTypeGroup(string UserId)
{
string usp = "usp_FrontContentTypeIndexGetContentGroup @UserId";
var x = await _sqlDataAccess.LoadData <FrontContentContentTypeGroup, dynamic>(usp, new { UserId = UserId });
return(x);
}
public async Task <List <int> > NewProcessGetInitialTemplateList()
{
string usp = "usp_NewProcessGetInitialTemplateFlowList";
var x = await _sqlDataAccess.LoadData <int>(usp);
return(x);
}
public Task <List <SequenceList> > CreateGetSequence(string UserId)
{
string usp = "[usp_UserMenuCreateGetSequence] @UserID";
return(_sqlDataAccess.LoadData <SequenceList, dynamic>(usp, new { UserId }));
}
public List <BookRentInfoModel> GetByUserId(string userId)
{
var output = _dataAccess.LoadData <BookRentInfoModel, dynamic>("spBookRent_GetByUserId", new { userId }, "LibraryDatabase");
return(output);
}
public List <ProductModel> GetProducts()
{
var output = _sql.LoadData <ProductModel, dynamic>("dbo.spProduct_GetAll", new { }, "TRMData");
return(output);
}
public Task <List <T> > GetAll()
{
var query = $"Select * From {_tableName};";
return(_database.LoadData <T, object>(query, new {}));
}
public Task <List <ManagerModel> > GetManagers()
{
string sql = "[dbo].[SelectAllManager]";
return(db.LoadData <ManagerModel, dynamic>(sql, new { }));
}
public Task <List <EmployeeModel> > GetEmployeesListTask()
{
string sql = "select * from employees_table";
return(_db.LoadData <EmployeeModel, dynamic>(sql, new { }));
}
public Task <List <HotelModel> > GetHotels()
{
string sql = "[dbo].[SelectAllHotel]";
return(db.LoadData <HotelModel, dynamic>(sql, new { }));
}
/// <summary>
/// Selects all roles
/// </summary>
/// <returns></returns>
public async Task <List <Role> > Select()
{
string sql = "SELECT * FROM `roles`";
return(await _sqlDataAccess.LoadData <Role>(sql));
}
public List <RoomModel> GetRooms()
{
var output = _sql.LoadData <RoomModel, dynamic>("dbo.spRoom_GetAll", new { }, "OHMData");
return(output);
}
public Task <List <PersonModel> > GetPeople()
{
string sql = "select * from dbo.People";
return(_db.LoadData <PersonModel, dynamic>(sql, new { }));
}
public List <SaleReportModel> GetSaleReports()
{
var output = _sql.LoadData <SaleReportModel, dynamic>("dbo.spSale_SaleReport", new { }, "TRMData");
return(output);
}
public List <UserModel> GetUserById(string Id)
{
return(_sqlDataAccess.LoadData <UserModel, dynamic>("dbo.sqlUserLookup", new { Id }, "RMData"));
}
public async Task <List <Content> > IndexGet(string UserId)
{
string usp = "usp_Contents @UserID";
var x = await _sqlDataAccess.LoadData <Content, dynamic>(usp, new { UserId = UserId });
return(x);
}
public Task <List <ProcessTypeStageFieldIndexGetFields> > IndexGet(string UserId, int ProcessTypeStageId)
{
string usp = "usp_ProcessTypeStageFieldIndexGet @UserId, @ProcessTypeStageId";
return(_sqlDataAccess.LoadData <ProcessTypeStageFieldIndexGetFields, dynamic>(usp, new { UserId = UserId, ProcessTypeStageId = ProcessTypeStageId }));
}
