public static Remuneration getRemuneration()
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "SELECT * FROM remuneration WHERE employee_idemployee=" + Employee.employee_id;
cmd.Connection = dbcon.connection;
MySqlDataReader reader = cmd.ExecuteReader();
Remuneration r = null;
if (reader.Read())
{
r = new Remuneration();
r.r_id = int.Parse(reader["idremuneration"].ToString());
r.rank = reader["rank"].ToString();
r.post = reader["post"].ToString();
r.salary_grade = reader["salary_grade"].ToString();
r.salary_slip_no = reader["salary_slip_no"].ToString();
r.basic_salary = (float)Convert.ToDouble(reader["basic_salary"].ToString());
r.transport_allowance = (float)Convert.ToDouble(reader["transport_allowance"].ToString());
r.fuel_allowance = (float)Convert.ToDouble(reader["fuel_allowance"].ToString());
r.mobile_phone_allowance = (float)Convert.ToDouble(reader["mobile_phone_allowance"].ToString());
r.housing_allowance = (float)Convert.ToDouble(reader["housing_allowance"].ToString());
r.other_allowance = (float)Convert.ToDouble(reader["other_allowance"].ToString());
r.salary_increase_amount = (float)Convert.ToDouble(reader["salary_increase_amount"].ToString());
r.current_total_salary = (float)Convert.ToDouble(reader["current_total_salary"].ToString());
r.setsalary_increase_date(Convert.ToDateTime(reader["salary_increase_date"]));
}
reader.Close();
dbcon.closeConnection();
return r;
}
else
{
return null;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return null;
//}
}
public void updateRemuneration()
{
Remuneration r = new Remuneration();
r.r_id = this.r_id;
r.salary_grade = this.remun_salary_grade.Text;
r.salary_slip_no = this.remun_salary_slip_no.Text;
r.basic_salary = (float)Convert.ToDouble(this.remun_basic_salary.Text);
r.transport_allowance = (float)Convert.ToDouble(this.remun_transport_allowance.Text);
r.fuel_allowance = (float)Convert.ToDouble(this.remun_fuel_allowance.Text);
r.mobile_phone_allowance = (float)Convert.ToDouble(this.remun_mobile_phone_allowance.Text);
r.housing_allowance = (float)Convert.ToDouble(this.remun_housing_allowance.Text);
r.other_allowance = (float)Convert.ToDouble(this.remun_other_allowance.Text);
r.salary_increase_amount = (float)Convert.ToDouble(this.remun_salary_increase_amount.Text);
r.current_total_salary = (float)Convert.ToDouble(this.remun_current_total_salary.Text);
r.setsalary_increase_date(this.remun_salary_increase_date.Value.Date);
bool state = RemunerationHandler.updateRemuneration(r);
Console.Write(state + "\n");
}
private void btnSave_Click(object sender, EventArgs e)
{
Remuneration r = new Remuneration();
r.rank = remun_rank.Text;
r.post = remun_post.Text;
r.salary_grade = remun_salary_grade.Text;
r.salary_slip_no = remun_salary_no.Text;
r.basic_salary = (float)Convert.ToDouble(remun_basic_salary.Text);
r.transport_allowance = (float)Convert.ToDouble(remun_transport_allowance.Text);
r.fuel_allowance = (float)Convert.ToDouble(remun_fuel_allowance.Text);
r.mobile_phone_allowance = (float)Convert.ToDouble(remun_telephone_allowance.Text);
r.housing_allowance = (float)Convert.ToDouble(remun_house_allowance.Text);
r.other_allowance = (float)Convert.ToDouble(remun_other_allowances.Text);
r.salary_increase_amount = (float)Convert.ToDouble(remun_increased_by.Text);
r.current_total_salary = (float)Convert.ToDouble(remun_present_salary.Text);
r.setsalary_increase_date(remun_salary_increased_date.Value.Date);
bool state = RemunerationHandler.addRemuneration(r);
if (state)
{
MessageBox.Show("Employee remuneration details added succesfully...!");
}
else
{
MessageBox.Show("Adding employee remuneration details failed...!");
}
}
