public static bool addPensionAndDeath(PensionAndDeath pd) { DBConnector dbcon = new DBConnector(); //try //{ if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO pension_death (retired, dead, died_date, informed_date, note, employee_idemployee) VALUES (" + pd.retired + ", " + pd.dead + ", '" + pd.died_date.ToString("yyyy-MM-dd") + "', '" + pd.informed_date.ToString("yyyy-MM-dd") + "', N'" + pd.note + "', " + 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 pd_present = true; if (PensionAndDeathHandler.getPensionAndDeath() == null) { pd_present = false; } PensionAndDeath pd = null; if (!pd_present) { pd = new PensionAndDeath(); } else { pd = PensionAndDeathHandler.getPensionAndDeath(); } pd.note = pension_notes.Text; pd.died_date = pension_died_date.Value.Date; pd.informed_date = pension_informed_date.Value.Date; if (pension_retired.Checked) { pd.retired = true; } else { pd.retired = false; } if (pension_dead.Checked) { pd.dead = true; } else { pd.dead = false; } bool state; if (!pd_present) { state = PensionAndDeathHandler.addPensionAndDeath(pd); } else { state = PensionAndDeathHandler.updatePensionAndDeath(pd); } if (state) { MessageBox.Show("Employee Pension and Death details updated succesfully...!"); } else { MessageBox.Show("Updating Pension and Death details failed...!"); } }
public static PensionAndDeath getPensionAndDeath() { //try //{ DBConnector dbcon = new DBConnector(); if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM pension_death WHERE employee_idemployee=" + Employee.employee_id; cmd.Connection = dbcon.connection; MySqlDataReader reader = cmd.ExecuteReader(); Console.Write(Employee.employee_id + "\n"); PensionAndDeath pd = null; if (reader.Read()) { pd = new PensionAndDeath(); pd.note = reader["note"].ToString(); pd.died_date = Convert.ToDateTime(reader["died_date"]); pd.informed_date = Convert.ToDateTime(reader["informed_date"]); if (reader["retired"].ToString() == "True") { pd.retired = true; } else { pd.retired = false; } if (reader["dead"].ToString() == "True") { pd.dead = true; } else { pd.dead = false; } } reader.Close(); dbcon.closeConnection(); return pd; } else { return null; } //} //catch (MySqlException e) //{ //int errorcode = e.Number; //return null; //} }
public static bool updatePensionAndDeath(PensionAndDeath pd) { DBConnector dbcon = new DBConnector(); //try //{ if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "UPDATE pension_death SET retired=" + pd.retired + ", dead=" + pd.dead + ", died_date='" + pd.died_date.ToString("yyyy-MM-dd") + "', informed_date='" + pd.informed_date.ToString("yyyy-MM-dd") + "', note=N'" + pd.note + "' 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; }*/ }