private async void dPay_btn_Click(object sender, RoutedEventArgs e)
{
double amount = 0.0;
if (!(dPayAmount_box.Text.Equals("")))
{
amount = Convert.ToDouble(dPayAmount_box.Text);
}
String date = dPayDate_box.Date.ToString();
if (amount == 0.0)
{
MessageDialog msg = new MessageDialog("Amount cannot be 0!");
await msg.ShowAsync();
}
else if (amount < 0)
{
MessageDialog msg = new MessageDialog("Amount cannot be less than 0!");
await msg.ShowAsync();
}
else
{
SmallTransactions sTrans = new SmallTransactions(amount, "Debt payment", 'd', "DID_123", "DPID_123", date, "AC_ID123");
DebtLoanController controller = new DebtLoanController();
controller.addPayDebt(sTrans);
}
}
public static int insertSmallTransactions(SmallTransactions sTrans)
{
int status = 0;
double amount = sTrans.Amount;
String description = sTrans.Description;
char type = sTrans.Type;
String id = sTrans.Id;
String trans_id = sTrans.Transaction_id;
String[] dateArray = sTrans.Date.ToString().Split(' ');
String date = dateArray[0];
String accID = sTrans.AccID;
try
{
using (var connection = new SQLitePCL.SQLiteConnection("Storage.db"))
{
using (var statement = connection.Prepare(@"INSERT INTO SmallTransactions (Amount, Description, Type,
ID, TransactionID, Date, Acc_ID)
VALUES(?,?,?,?,?,?,?);"))
{
statement.Bind(1, amount.ToString());
statement.Bind(2, description);
statement.Bind(3, type.ToString());
statement.Bind(4, id);
statement.Bind(5, trans_id);
statement.Bind(6, date);
statement.Bind(7, accID);
SQLiteResult s = statement.Step();
statement.Reset();
statement.ClearBindings();
if ((s.ToString().Equals("DONE")))
{
Debug.WriteLine("Step done");
status = 1;
}
else
{
Debug.WriteLine("Step failed");
status = 0;
}
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
return(status);
}
private async void dDeposit_btn_Click(object sender, RoutedEventArgs e)
{
double amount = Convert.ToDouble(dAmount_box.Text);
String date = dDate_box.Date.ToString();
if (amount == 0)
{
MessageDialog msg = new MessageDialog("Amount cannot be 0!");
await msg.ShowAsync();
}
else if (amount < 0)
{
MessageDialog msg = new MessageDialog("Amount cannot be less than 0!");
await msg.ShowAsync();
}
else
{
CommonController comCont = new CommonController();
IncomeExpenseController ieCont = new IncomeExpenseController();
String ieID = comCont.idGenerator("ie");
String stID = comCont.idGenerator("st");
IncExp incexp = new IncExp(savings.Name + "[Transaction]", amount, "default_null", "default_null", "Saving transaction - depost", ieID, "default_null", false, "AC_ID123");
SmallTransactions sTrans = new SmallTransactions(amount, "", 'd', savings.Id, stID, date, "AC_ID123");
SavingsController controller = new SavingsController();
int status = controller.addDepositWithdraw(sTrans);
int status2 = ieCont.addTransaction(incexp);
int status3 = comCont.insertMoreIDs(ieID, savings.Id, stID);
if (status == 1 && status2 == 1 && status3 == 1)
{
MessageDialog msg = new MessageDialog("Successfully deposited!");
await msg.ShowAsync();
Frame.Navigate(typeof(SavingsDetails), savings);
}
else
{
MessageDialog msg = new MessageDialog("Failed to deposit!");
await msg.ShowAsync();
}
}
}
private async void wWithdraw_btn_Click(object sender, RoutedEventArgs e)
{
SavingsController cont = new SavingsController();
double currentAmount = cont.savingsCurrentAmount(savings);
if (Convert.ToDouble(wAmount_box.Text) > currentAmount)
{
MessageDialog msg = new MessageDialog("You don't have that much in your savings");
await msg.ShowAsync();
}
else
{
double amount = Convert.ToDouble(wAmount_box.Text);
String date = wDate_box.Date.ToString();
IncomeExpenseController ieCont = new IncomeExpenseController();
CommonController comCont = new CommonController();
String wID = comCont.idGenerator("st");
String ieID = comCont.idGenerator("ie");
IncExp incexp = new IncExp(savings.Name + "[Transaction]", amount, "default_null", "default_null", "Saving transaction - withdraw", ieID, "default_null", true, "AC_ID123");
SmallTransactions sTrans = new SmallTransactions(amount, "", 'w', savings.Id, wID, date, "AC_ID123");
SavingsController controller = new SavingsController();
int status = controller.addDepositWithdraw(sTrans);
int status2 = ieCont.addTransaction(incexp);
int status3 = comCont.insertMoreIDs(ieID, savings.Id, wID);
if (status == 1 && status2 == 1 && status3 == 1)
{
MessageDialog msg = new MessageDialog("Successfully withdrawed!");
await msg.ShowAsync();
Frame.Navigate(typeof(SavingsDetails), savings);
}
else
{
MessageDialog msg = new MessageDialog("Failed to withdraw!");
await msg.ShowAsync();
}
}
}
public void addPayDebt(SmallTransactions sTrans)
{
DatabaseHandler.insertSmallTransactions(sTrans);
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
st = (SmallTransactions)e.Parameter;
indiTransAmountBox.Text = "Rs." + st.Amount.ToString() + ".00";
indiTransDateBox.Text = st.Date;
}
public int addDepositWithdraw(SmallTransactions trans)
{
return(DatabaseHandler.insertSmallTransactions(trans));
}
