public static void AddExpenses(ExpenseDetailEvent addExpense) { /* try * {*/ string date = DateTime.Now.ToString("yyyy-MM-dd"); int eti = addExpense.ExpType.ExpTypeId; int ei = addExpense.EventOfExp.EventId; int p = addExpense.ProjectOfEvent.ProjectID; double a = addExpense.Amount; string c = addExpense.Comment; string pt = addExpense.PaymentType; DBConnection.updateDB("insert into exp_detail_event (exp_type_id, event_id, proj_id, amount, comment, dateOfExp, paymentType) values" + " (" + eti + ", " + ei + " , " + p + " , " + a + " ,'" + c + "','" + date + "', '" + pt + "');"); MessageBox.Show("Expenses successfully added!"); /* } * catch (Exception) * { * * MessageBox.Show("Something went wrong!", "Add Expenses", MessageBoxButtons.OK, MessageBoxIcon.Error); * }*/ }
private void submitExpBtn_Click(object sender, EventArgs e) { ExpenseDetailEvent exp = null; foreach (DataGridViewRow row in eventExpensesGrid.Rows) { int expTypeId = 0; string expType = row.Cells[0].Value.ToString(); double amount = Double.Parse(row.Cells[2].Value.ToString()); DateTime date = Convert.ToDateTime(row.Cells[3].Value.ToString()); String iouDir = row.Cells[1].Value.ToString(); string comment = row.Cells[4].Value.ToString(); DataTable tmp = (DataTable)expTypeCmbBox.DataSource; foreach (DataRow r in tmp.Rows) { if (r[1].ToString() == expType) { expTypeId = Int32.Parse(r[0].ToString()); } } exp = new ExpenseDetailEvent(new ExpenseType(expTypeId), new Event(eventId), new Project(projId), amount, date, comment, iouDir); Database.addEventExpense(exp); } notifyIcon.Icon = SystemIcons.Application; notifyIcon.BalloonTipText = "Event Expenses Successfully added!"; notifyIcon.ShowBalloonTip(200); expTypeCmbBox.SelectedIndex = 0; amountTxtBox.Text = ""; datePicker.Value = DateTime.Today; commentTxtBox.Text = ""; iouRadioBtn.Checked = true; dt.Rows.Clear(); eventExpensesGrid.DataSource = dt; double tot = 0.0; foreach (DataGridViewRow row in eventExpensesGrid.Rows) { tot += Double.Parse(row.Cells[2].Value.ToString()); } totalExpLbl.Text = "Rs. " + tot; }
private void btnOk_Click(object sender, EventArgs e) { if (Validation.isNumber(totalAmount.Text)) { ExpenseDetailEvent ede = new ExpenseDetailEvent(); ede.PaymentType = paymentType.Text.ToString(); ede.ProjectOfEvent = new Project(pid); ede.EventOfExp = new Event(eid); ede.ExpType = new ExpenseType(int.Parse(expenseType.SelectedValue.ToString())); ede.Comment = details.Text.ToString(); ede.Amount = double.Parse(totalAmount.Text.ToString()); Database.AddExpenses(ede); } else { MessageBox.Show("Invalid Number"); } }