public static bool addDisciplinaryDetails(DisciplinaryDetails dd) { DBConnector dbcon = new DBConnector(); //try //{ if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO desciplinary_details (rank, post, breaking, request_main_admin, breaking_date, given_sentence, given_sentence_date, verdict_of_director_general, verdict_of_director_general_date, inquiry_officer, suspended_date, rejoined_date, suspended_time, employee_idemployee) VALUES (N'" + dd.rank + "', N'" + dd.post + "', N'" + dd.breaking + "', N'" + dd.request_main_admin + "', '" + dd.breaking_date.ToString("yyyy-MM-dd") + "', N'" + dd.given_sentence + "', '" + dd.given_sentence_date.ToString("yyyy-MM-dd") + "', N'" + dd.verdict_of_director_general + "', '" + dd.verdict_of_director_general_date.ToString("yyyy-MM-dd") + "', N'" + dd.inquiry_officer + "', '" + dd.suspended_date.ToString("yyyy-MM-dd") + "', '" + dd.rejoined_date.ToString("yyyy-MM-dd") + "', N'" + dd.suspended_time + "', " + 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 DisciplinaryDetails getDisciplinaryDetails() { //try //{ DBConnector dbcon = new DBConnector(); if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM desciplinary_details WHERE employee_idemployee=" + Employee.employee_id; cmd.Connection = dbcon.connection; MySqlDataReader reader = cmd.ExecuteReader(); Console.Write(Employee.employee_id + "\n"); DisciplinaryDetails dd = null; if (reader.Read()) { dd = new DisciplinaryDetails(); dd.rank = reader["rank"].ToString(); dd.post = reader["post"].ToString(); dd.breaking = reader["breaking"].ToString(); dd.breaking_date = Convert.ToDateTime(reader["breaking_date"]); dd.given_sentence = reader["given_sentence"].ToString(); dd.given_sentence_date = Convert.ToDateTime(reader["given_sentence_date"]); dd.inquiry_officer = reader["inquiry_officer"].ToString(); dd.rejoined_date = Convert.ToDateTime(reader["rejoined_date"]); dd.request_main_admin = reader["request_main_admin"].ToString(); dd.suspended_date = Convert.ToDateTime(reader["suspended_date"]); dd.suspended_time = reader["suspended_time"].ToString(); dd.verdict_of_director_general = reader["verdict_of_director_general"].ToString(); dd.verdict_of_director_general_date = Convert.ToDateTime(reader["verdict_of_director_general_date"]); } reader.Close(); dbcon.closeConnection(); return dd; } else { return null; } //} //catch (MySqlException e) //{ //int errorcode = e.Number; //return null; //} }
public static bool updateDisciplinaryDetails(DisciplinaryDetails dd) { DBConnector dbcon = new DBConnector(); //try //{ if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "UPDATE desciplinary_details SET rank=N'" + dd.rank + "', post=N'" + dd.post + "', breaking=N'" + dd.breaking + "', request_main_admin=N'" + dd.request_main_admin + "', breaking_date='" + dd.breaking_date.ToString("yyyy-MM-dd") + "', given_sentence=N'" + dd.given_sentence + "', given_sentence_date='" + dd.given_sentence_date.ToString("yyyy-MM-dd") + "', verdict_of_director_general=N'" + dd.verdict_of_director_general + "', verdict_of_director_general_date='" + dd.verdict_of_director_general_date.ToString("yyyy-MM-dd") + "', inquiry_officer=N'" + dd.inquiry_officer + "', suspended_date='" + dd.suspended_date.ToString("yyyy-MM-dd") + "', rejoined_date='" + dd.rejoined_date.ToString("yyyy-MM-dd") + "', suspended_time=N'" + dd.suspended_time + "' 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; }*/ }
private void btnSave_Click(object sender, EventArgs e) { bool desc_present = true; if (DisciplinaryDetailsHandler.getDisciplinaryDetails() == null) { desc_present = false; } DisciplinaryDetails dd = null; if (!desc_present) { dd = new DisciplinaryDetails(); } else { dd = DisciplinaryDetailsHandler.getDisciplinaryDetails(); } dd.rank = desciplinary_rank.Text; dd.post = desciplinary_post.Text; dd.verdict_of_director_general = desciplinary_verdict_of_director_general.Text; dd.breaking = desciplinary_breaking.Text; dd.given_sentence = desciplinary_given_sentence.Text; dd.inquiry_officer = desciplinary_inquiry_officer.Text; dd.request_main_admin = desciplinary_request_of_main_administration_officer.Text; dd.suspended_time = desciplinary_suspended_time.Text; dd.verdict_of_director_general_date = desciplinary_verdict_of_director_general_date.Value.Date; dd.given_sentence_date = disciplinary_given_sentence_date.Value.Date; dd.breaking_date = disciplinary_breaking_date.Value.Date; dd.rejoined_date = disciplinary_rejoined_date.Value.Date; dd.suspended_time = desciplinary_suspended_time.Text; bool state; if (!desc_present) { state = DisciplinaryDetailsHandler.addDisciplinaryDetails(dd); } else { state = DisciplinaryDetailsHandler.updateDisciplinaryDetails(dd); } if (state) { MessageBox.Show("Employee Disciplinary details updated succesfully...!"); } else { MessageBox.Show("Updating Disciplinary details failed...!"); } }