public async Task <int> InsertTransactionAsync(TransactionEntity transactionEntity, bool isUserPerformed = false)
{
string query = "INSERT INTO `Transaction`" +
"(`TransactionPartyId`,`Amount`,`IsIncome`,`TransactionDateTime`,`ScheduledTransactionId`,`Remarks`,`CreatedDateTime`,`IsUserPerformed`) " +
"VALUES (@TransactionPartyId,@Amount,@IsIncome,@TransactionDateTime,@ScheduledTransactionId,@Remarks,@CreatedDateTime,@IsUserPerformed);";
IEnumerable <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@TransactionPartyId", transactionEntity.TransactionPartyId),
new KeyValuePair <string, object>("@Amount", transactionEntity.Amount),
new KeyValuePair <string, object>("@IsIncome", transactionEntity.IsIncome ? 1 : 0),
new KeyValuePair <string, object>("@TransactionDateTime", TimeConverterMethods.ConvertDateTimeToTimeStamp(transactionEntity.TransactionDateTime)),
new KeyValuePair <string, object>("@ScheduledTransactionId", transactionEntity.ScheduledTransactionId),
new KeyValuePair <string, object>("@Remarks", transactionEntity.Remarks),
new KeyValuePair <string, object>("@CreatedDateTime", TimeConverterMethods.ConvertDateTimeToTimeStamp(transactionEntity.CreatedDateTime)),
new KeyValuePair <string, object>("@IsUserPerformed", isUserPerformed ? 1 : 0)
};
int id = await SqliteConnector.ExecuteInsertQueryAsync(query, parameters, true);
query = "UPDATE `Transaction` SET `ReferenceNumber`=@ReferenceNumber WHERE `Id`=@Id";
parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@ReferenceNumber", id.ToString("TC00000000")),
new KeyValuePair <string, object>("@Id", id)
};
await SqliteConnector.ExecuteNonQueryAsync(query, parameters, true);
return(id);
}
public async Task <int> InsertTaskAsync(OneTimeTasks task, bool isUserPerformed = false)
{
string query = "INSERT INTO `OneTimeTasks`" +
"(`Type`,`Comments`,`Duration`,`CreatedUser`,`CreatedDateTime`,`IsDelete`,`Effectivedate`) " +
"VALUES (@Type,@Comments,@Duration,@CreatedUser,@CreatedDateTime,@IsDelete,@Effectivedate);";
IEnumerable <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@Type", task.Type),
new KeyValuePair <string, object>("@Comments", task.Comments),
new KeyValuePair <string, object>("@Duration", task.Duration),
new KeyValuePair <string, object>("@CreatedUser", task.CreatedUser),
new KeyValuePair <string, object>("@Effectivedate", TimeConverterMethods.ConvertDateTimeToTimeStamp(task.Effectivedate)),
new KeyValuePair <string, object>("@CreatedDateTime", TimeConverterMethods.ConvertDateTimeToTimeStamp(task.CreatedDateTime)),
new KeyValuePair <string, object>("@IsDelete", 0)
};
int id = await SqliteConnector.ExecuteInsertQueryAsync(query, parameters, true);
query = "UPDATE `OneTimeTasks` SET `ReferenceNumber`=@ReferenceNumber WHERE `Id`=@Id";
parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@ReferenceNumber", id.ToString("OTASK000000")),
new KeyValuePair <string, object>("@Id", id)
};
await SqliteConnector.ExecuteNonQueryAsync(query, parameters, true);
return(id);
}
public async Task <int> UpdateUserLastCheckDateTimeAsync(DateTime dateTime)
{
string query = @"UPDATE `User` SET `LastCheckDateTime`=@LastCheckDateTime;";
IList <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@LastCheckDateTime", TimeConverterMethods.ConvertDateTimeToTimeStamp(dateTime))
};
return(await SqliteConnector.ExecuteNonQueryAsync(query, parameters : parameters, true));
}
public async Task <int> UpdateUserCurrentBalanceAsync(double balance)
{
string query = @"UPDATE `User` SET `CurrentBalance`=@CurrentBalance;";
IList <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@CurrentBalance", balance)
};
return(await SqliteConnector.ExecuteNonQueryAsync(query, parameters : parameters, true));
}
public async void UpdateNextTransactionDate(int id, DateTime dtAddDates)
{
string query = "UPDATE `ScheduledTasks` SET `Effectivedate`=@Effectivedate WHERE `Id`=@Id";
IEnumerable <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@Id", id),
new KeyValuePair <string, object>("@Effectivedate", TimeConverterMethods.ConvertDateTimeToTimeStamp(dtAddDates))
};
await SqliteConnector.ExecuteNonQueryAsync(query, parameters, true);
}
public async Task <int> DeleteTransactionPartyAsync(int id)
{
string query = "UPDATE `TransactionParty` " +
"SET `IsActive`=@IsActive " +
"WHERE `Id` = @Id";
IEnumerable <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@IsActive", 0),
new KeyValuePair <string, object>("@Id", id)
};
return(await SqliteConnector.ExecuteNonQueryAsync(query, parameters, true));
}
public async void DeleteTaskAsync(int id)
{
string query = "UPDATE `OneTimeTasks` " +
"SET `IsDelete`=@IsDelete " +
"WHERE `Id` = @Id";
IEnumerable <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@IsDelete", 1),
new KeyValuePair <string, object>("@Id", id)
};
await SqliteConnector.ExecuteNonQueryAsync(query, parameters, true);
}
public async Task <int> UpdateTransactionPartyAsync(TransactionPartyEntity transactionPartyEntity)
{
string query = "UPDATE `TransactionParty` " +
"SET `Code`=@Code,`Description`=@Description " +
"WHERE `Id` = @Id";
IEnumerable <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@Code", transactionPartyEntity.Code),
new KeyValuePair <string, object>("@Description", transactionPartyEntity.Description),
new KeyValuePair <string, object>("@Id", transactionPartyEntity.Id)
};
return(await SqliteConnector.ExecuteNonQueryAsync(query, parameters, true));
}
public async Task <int> UpdateTaskAsync(OneTimeTasks task)
{
string query = "UPDATE `OneTimeTasks` " +
"SET `Type`=@Type,`Comments`=@Comments,`Duration`=@Duration,`Effectivedate`=@Effectivedate " +
"WHERE `Id` = @Id";
IEnumerable <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@Type", task.Type),
new KeyValuePair <string, object>("@Comments", task.Comments),
new KeyValuePair <string, object>("@Duration", task.Duration),
new KeyValuePair <string, object>("@Effectivedate", TimeConverterMethods.ConvertDateTimeToTimeStamp(task.Effectivedate)),
new KeyValuePair <string, object>("@Id", task.Id),
};
return(await SqliteConnector.ExecuteNonQueryAsync(query, parameters, true));
}
public async Task <int> UpdateTransactionAsync(TransactionEntity transactionEntity)
{
string query = "UPDATE `Transaction` " +
"SET `TransactionPartyId`=@TransactionPartyId,`Amount`=@Amount,`IsIncome`=@IsIncome,`Remarks`=@Remarks " +
"WHERE `Id` = @Id";
IEnumerable <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@TransactionPartyId", transactionEntity.TransactionPartyId),
new KeyValuePair <string, object>("@Amount", transactionEntity.Amount),
new KeyValuePair <string, object>("@IsIncome", transactionEntity.IsIncome ? 1 : 0),
new KeyValuePair <string, object>("@Remarks", transactionEntity.Remarks),
new KeyValuePair <string, object>("@Id", transactionEntity.Id),
};
return(await SqliteConnector.ExecuteNonQueryAsync(query, parameters, true));
}
public async Task <int> UpdateScheduledTransactionListAsync(SheduledTransactionList transactionEntity)
{
string query = "UPDATE `ScheduledTransaction` " +
"SET `TransactionPartyId`=@TransactionPartyId,`Amount`=@Amount,`RepeatType`=@RepeatType,`StartDateTime`=@StartDateTime,`EndDateTime`=@EndDateTime,`InfiniteSchedule`=@InfiniteSchedule,`NextTransactionDate`=@NextTransactionDate,`IsActive`=@IsActive,`Remarks`=@Remarks " +
"WHERE `Id` = @Id";
IEnumerable <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@TransactionPartyId", transactionEntity.TransactionPartyId),
new KeyValuePair <string, object>("@Amount", transactionEntity.Amount),
new KeyValuePair <string, object>("@IsIncome", transactionEntity.IsIncome ? 1 : 0),
new KeyValuePair <string, object>("@Remarks", transactionEntity.Remarks),
new KeyValuePair <string, object>("@RepeatType", transactionEntity.RepeatType),
new KeyValuePair <string, object>("@StartDateTime", TimeConverterMethods.ConvertDateTimeToTimeStamp(transactionEntity.StartDateTime)),
new KeyValuePair <string, object>("@EndDateTime", TimeConverterMethods.ConvertDateTimeToTimeStamp(transactionEntity.EndDateTime ?? transactionEntity.StartDateTime)),
new KeyValuePair <string, object>("@NextTransactionDate", TimeConverterMethods.ConvertDateTimeToTimeStamp(transactionEntity.NextTransactionDate)),
new KeyValuePair <string, object>("@InfiniteSchedule", transactionEntity.InfiniteSchedule ? 1 : 0),
new KeyValuePair <string, object>("@IsActive", transactionEntity.IsActive),
new KeyValuePair <string, object>("@Id", transactionEntity.Id),
};
return(await SqliteConnector.ExecuteNonQueryAsync(query, parameters, true));
}
public async Task <int> InsertScheduledTransactionListAsync(SheduledTransactionList transactionEntity)
{
string query = "INSERT INTO `ScheduledTransaction`" +
"(`TransactionPartyId`,`Amount`,`IsIncome`,`RepeatType`,`StartDateTime`,`Remarks`,`CreatedDateTime`,`EndDateTime`,`NextTransactionDate`,`InfiniteSchedule`,`IsDelete`,`CreatedUser`,`IsActive`) " +
"VALUES (@TransactionPartyId,@Amount,@IsIncome,@RepeatType,@StartDateTime,@Remarks,@CreatedDateTime,@EndDateTime,@NextTransactionDate,@InfiniteSchedule,@IsDelete,@CreatedUser,@IsActive);";
IEnumerable <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@TransactionPartyId", transactionEntity.TransactionPartyId),
new KeyValuePair <string, object>("@Amount", transactionEntity.Amount),
new KeyValuePair <string, object>("@IsIncome", transactionEntity.IsIncome ? 1 : 0),
new KeyValuePair <string, object>("@RepeatType", transactionEntity.RepeatType),
new KeyValuePair <string, object>("@StartDateTime", TimeConverterMethods.ConvertDateTimeToTimeStamp(transactionEntity.StartDateTime)),
new KeyValuePair <string, object>("@Remarks", transactionEntity.Remarks),
new KeyValuePair <string, object>("@CreatedDateTime", TimeConverterMethods.ConvertDateTimeToTimeStamp(transactionEntity.CreatedDateTime)),
new KeyValuePair <string, object>("@EndDateTime", TimeConverterMethods.ConvertDateTimeToTimeStamp(transactionEntity.EndDateTime ?? transactionEntity.StartDateTime)),
new KeyValuePair <string, object>("@NextTransactionDate", TimeConverterMethods.ConvertDateTimeToTimeStamp(transactionEntity.NextTransactionDate)),
new KeyValuePair <string, object>("@InfiniteSchedule", transactionEntity.InfiniteSchedule ? 1 : 0),
new KeyValuePair <string, object>("@IsDelete", 0),
new KeyValuePair <string, object>("@CreatedUser", transactionEntity.CreatedUser),
new KeyValuePair <string, object>("@IsActive", 1)
};
int id = await SqliteConnector.ExecuteInsertQueryAsync(query, parameters, true);
query = "UPDATE `ScheduledTransaction` SET `ReferenceNumber`=@ReferenceNumber WHERE `Id`=@Id";
parameters = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@ReferenceNumber", id.ToString("SYSTC00000000")),
new KeyValuePair <string, object>("@Id", id)
};
await SqliteConnector.ExecuteNonQueryAsync(query, parameters, true);
return(id);
}