public static bool addRemuneration(Remuneration r)
{
DBConnector dbcon = new DBConnector();
//try
//{
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "INSERT INTO remuneration (rank, post, salary_grade, salary_slip_no, basic_salary, transport_allowance, fuel_allowance, mobile_phone_allowance, housing_allowance, other_allowance, salary_increase_date, salary_increase_amount, current_total_salary, employee_idemployee) VALUES (N'" + r.rank + "', N'" + r.post + "', N'" + r.salary_grade + "', N'" + r.salary_slip_no + "', " + r.basic_salary + ", " + r.transport_allowance + ", " + r.fuel_allowance + ", " + r.mobile_phone_allowance + ", " + r.housing_allowance + ", " + r.other_allowance + ", '" + r.getsalary_increase_date().ToString("yyyy-MM-dd") + "', " + r.salary_increase_amount + ", " + r.current_total_salary + ", " + Employee.employee_id + ")";
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return true;
}
else
{
dbcon.closeConnection();
return false;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//dbcon.closeConnection();
//return false;
//}
}
public static bool updateRemuneration(Remuneration r)
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "UPDATE remuneration SET salary_grade=N'" + r.salary_grade + "', salary_slip_no=" + r.salary_slip_no + ", basic_salary=" + r.basic_salary + ", transport_allowance=" + r.transport_allowance + ", fuel_allowance=" + r.fuel_allowance + ", mobile_phone_allowance=" + r.mobile_phone_allowance + ", housing_allowance=" + r.housing_allowance + ", other_allowance=" + r.other_allowance + ", salary_increase_date='" + r.getsalary_increase_date().ToString("yyyy-MM-dd") + "', salary_increase_amount=" + r.salary_increase_amount + ", current_total_salary=" + r.current_total_salary + " WHERE employee_idemployee=" + Employee.employee_id + " AND idremuneration=" + r.r_id;
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return true;
}
else
{
return false;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return false;
//}
}