public static void addOfficeExp(Role.OfficeExpenses exp) { // try // { String date = DateTime.Now.ToString("yyyy-MM-dd"); String type = exp.ExpType; int exid = exp.OffExpenseId; int staff = exp.StaffIssued.StaffId; String cat = exp.Category; double am = exp.Amount; DBConnection.updateDB("Insert into office_expenses (type, staff_id, date, Category, amount) values('" + type + "' , " + staff + " , '" + date + "' , '" + cat + "' , " + am + ");"); MessageBox.Show("Successfully added"); /* } * * catch (Exception) * { * MessageBox.Show("Something went wrong!","Add Expenses",MessageBoxButtons.OK,MessageBoxIcon.Error); * * }*/ }
public static void saveOfficeExpenses(Role.OfficeExpenses exp) { try { DBConnection.updateDB("insert into exp (staff_id, date, category,amount)" + +exp.StaffIssued.StaffId + "', '" + exp.Date + "', " + "'" + exp.Category + "', '" + exp.Amount + "')"); } catch (Exception) { MessageBox.Show("Something went wrong!", "Add client", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void metroButton2_Click(object sender, EventArgs e) { Role.OfficeExpenses exp = new Role.OfficeExpenses(); exp.ExpType = type.Text.ToString(); //exp.OffExpenseId = int.Parse(expid.Text.ToString()); exp.StaffIssued = new Staff(int.Parse(combo.SelectedValue.ToString())); if (Validation.isNumber(inAmount.Text)) { exp.Amount = int.Parse(inAmount.Text.ToString()); exp.Category = category.Text.ToString(); Database.addOfficeExp(exp); } else { MessageBox.Show("Invalid Number"); } }