public static bool addNonCashBenefit(NonCashBenefit ncb)
{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "INSERT INTO noncash_benefit (approved_benefit, date_issued, amount, price, employee_idemployee) VALUES (N'" + ncb.approved_benefit + "', '" + ncb.getdate_issued().ToString("yyyy-MM-dd") + "', " + ncb.amount + ", " + ncb.price + ", " + Employee.employee_id + ")";
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return true;
}
else
{
dbcon.closeConnection();
return false;
}
}
public static bool updateNonCashBenefit(NonCashBenefit ncb)
{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "UPDATE noncash_benefit SET approved_benefit=N'" + ncb.approved_benefit + "', date_issued='" + ncb.getdate_issued().ToString("yyyy-MM-dd") + "', amount=" + ncb.amount + ", price=" + ncb.price + " WHERE employee_idemployee=" + Employee.employee_id + " AND idnoncash_benefit=" + ncb.ncb_id;
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return true;
}
else
{
return false;
}
}