public static bool addPassport(Passport p) { DBConnector dbcon = new DBConnector(); //try //{ if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO passport (rank, post, passport_no, place_of_issue, date_of_issue, date_of_renewal, status, employee_idemployee) VALUES (N'" + p.rank + "', N'" + p.post + "', N'" + p.number + "', N'" + p.place_of_issue + "', '" + p.getdate_of_issue().ToString("yyyy-MM-dd") + "', '" + p.getdate_of_renewal().ToString("yyyy-MM-dd") + "', " + p.status + ", " + 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) { Passport p = new Passport(); p.number = passport_no.Text; p.place_of_issue = passport_issued_place.Text; p.post = passport_post.Text; p.rank = passport_rank.Text; p.setdate_of_issue(passport_issued_date.Value.Date); p.setdate_of_renewal(passport_renewal_date.Value.Date); if (passport_status_active.Checked) { p.status = true; } else { p.status = false; } bool state = PassportHandler.addPassport(p); if (state) { MessageBox.Show("Employee passport details added succesfully...!"); } else { MessageBox.Show("Adding employee personal pasport failed...!"); } //frmMain.getForm().Show(); }
public static Passport getPassport() { //try //{ DBConnector dbcon = new DBConnector(); if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM passport WHERE employee_idemployee=" + Employee.employee_id; cmd.Connection = dbcon.connection; MySqlDataReader reader = cmd.ExecuteReader(); Passport p = null; if (reader.Read()) { p = new Passport(); if (reader["status"].ToString() == "True") { p.status=true; } else { p.status = false; } p.p_id = int.Parse(reader["idpassport"].ToString()); p.rank = reader["rank"].ToString(); p.post = reader["post"].ToString(); p.number = reader["passport_no"].ToString(); p.place_of_issue = reader["place_of_issue"].ToString(); p.setdate_of_issue(Convert.ToDateTime(reader["date_of_issue"])); p.setdate_of_renewal(Convert.ToDateTime(reader["date_of_renewal"])); } reader.Close(); dbcon.closeConnection(); return p; } else { return null; } //} //catch (MySqlException e) //{ //int errorcode = e.Number; //return null; //} }
public void updatePassport() { Passport p = new Passport(); p.p_id = this.p_id; p.number = this.passport_no.Text; p.place_of_issue = this.passport_issued_place.Text; p.post = this.passport_post.Text; p.rank = this.passport_rank.Text; p.setdate_of_issue(this.passport_issued_date.Value.Date); p.setdate_of_renewal(this.passport_renewal_date.Value.Date); if (this.passport_status_active.Checked) { p.status = true; } else { p.status = false; } bool state = PassportHandler.updatePassport(p); Console.Write(state + "\n"); }
public static bool updatePassport(Passport p) { //try //{ DBConnector dbcon = new DBConnector(); if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "UPDATE passport SET rank=N'" + p.rank + "', post=N'" + p.post + "', passport_no=N'" + p.number + "', place_of_issue=N'" + p.place_of_issue + "', date_of_issue='" + p.getdate_of_issue().ToString("yyyy-MM-dd") + "', date_of_renewal='" + p.getdate_of_renewal().ToString("yyyy-MM-dd") + "', status=" + p.status + " WHERE employee_idemployee=" + Employee.employee_id + " AND idpassport=" + p.p_id; cmd.Connection = dbcon.connection; cmd.Prepare(); cmd.ExecuteNonQuery(); dbcon.closeConnection(); return true; } else { return false; } //} //catch (MySqlException e) //{ //int errorcode = e.Number; //return false; //} }