public static bool addResignation(Resignation r)
{
DBConnector dbcon = new DBConnector();
//try
//{
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "INSERT INTO resignation (rank, post, letter_submitted_date, resignation_date, reason, resignation_letter, employee_idemployee) VALUES (N'" + r.rank + "', N'" + r.post + "', '" + r.letter_submitted_date.ToString("yyyy-MM-dd") + "', '" + r.resignation_date.ToString("yyyy-MM-dd") + "', N'" + r.reason + "', N'" + r.resignation_letter + "', " + 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;
}*/
}
private void btnSave_Click(object sender, EventArgs e)
{
bool r_present = true;
if (ResignationHandler.getResignation() == null)
{
r_present = false;
}
Resignation r = null;
if (!r_present)
{
r = new Resignation();
}
else
{
r = ResignationHandler.getResignation();
}
r.letter_submitted_date = resignation_letter_submitted_date.Value.Date;
r.post = resignation_post.Text;
r.rank = resignation_rank.Text;
r.reason = resignation_reason.Text;
r.resignation_date = resignation_date.Value.Date;
r.resignation_letter = resignation_letter.Text;
bool state;
if (!r_present)
{
state = ResignationHandler.addResignation(r);
}
else
{
state = ResignationHandler.updateResignation(r);
}
if (state)
{
MessageBox.Show("Employee Resignation details updated succesfully...!");
}
else
{
MessageBox.Show("Updating Resignation details failed...!");
}
}
public static Resignation getResignation()
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "SELECT * FROM resignation WHERE employee_idemployee=" + Employee.employee_id;
cmd.Connection = dbcon.connection;
MySqlDataReader reader = cmd.ExecuteReader();
Console.Write(Employee.employee_id + "\n");
Resignation r = null;
if (reader.Read())
{
r = new Resignation();
r.rank = reader["rank"].ToString();
r.post = reader["post"].ToString();
r.reason = reader["reason"].ToString();
r.resignation_letter = reader["resignation_letter"].ToString();
r.letter_submitted_date = Convert.ToDateTime(reader["letter_submitted_date"]);
r.resignation_date = Convert.ToDateTime(reader["resignation_date"]);
}
reader.Close();
dbcon.closeConnection();
return r;
}
else
{
return null;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return null;
//}
}
public static bool updateResignation(Resignation r)
{
DBConnector dbcon = new DBConnector();
//try
//{
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "UPDATE resignation SET rank=N'" + r.rank + "n, post=N'" + r.post + "', letter_submitted_date='" + r.letter_submitted_date.ToString("yyyy-MM-dd") + "', resignation_date='" + r.resignation_date.ToString("yyyy-MM-dd") + "', reason=N'" + r.reason + "', resignation_letter=N'" + r.resignation_letter + "' WHERE employee_idemployee=" + 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;
}*/
}
