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"); }