public async Task <IEnumerable <TransactionPartyEntity> > GetTransactionPartiesAsync()
{
string query = "SELECT * FROM `TransactionParty`";
return(await SqliteConnector.ExecuteQueryAsync(query, ReaderToEntity));
}
public async Task <IEnumerable <OneTimeTasks> > GetTaskAsync()
{
string query = "SELECT * FROM `OneTimeTasks`";
return(await SqliteConnector.ExecuteQueryAsync(query, ReaderToEntity));
}
public async Task <IEnumerable <ScheduledTasks> > GetScheduledTasksAsync()
{
string query = "SELECT * FROM `ScheduledTasks`";
return(await SqliteConnector.ExecuteQueryAsync(query, ReaderToEntitySheduledTask));
}
public async Task <IEnumerable <ScheduledTasks> > GetTodayActiveScheduleTasksAsync()
{
string query = "SELECT * FROM `ScheduledTasks` WHERE `IsDelete` = 0 ";
return(await SqliteConnector.ExecuteQueryAsync(query, ReaderToEntitySheduledTask));
}
public async Task <IEnumerable <SheduledTransactionList> > GetSheduledTransactionsAsync()
{
string query = "SELECT * FROM `ScheduledTransaction`";
return(await SqliteConnector.ExecuteQueryAsync(query, ReaderToEntitySheduledTransactionList));
}
public async Task <IEnumerable <SheduledTransactionList> > GetTodayActiveTransactionScheduleAsync()
{
string query = "SELECT * FROM `ScheduledTransaction` WHERE `IsDelete` = 0 ";
return(await SqliteConnector.ExecuteQueryAsync(query, ReaderToEntitySheduledTransactionList));
}