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