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)); }