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; }*/ }