private void NewPerson_User_Signature_Office_Activated(object sender, EventArgs e) { this.Cursor = System.Windows.Forms.Cursors.WaitCursor; person_userComboBox.Items.Clear(); Person_User person_user = new Person_User(); User user = new User(); Person person = new Person(); person_user.findAll(); foreach (Person_User person_userList in person_user.persons_users) { user.iduser = person_userList.iduser; user.findByIdUser(); person_user.user = user; person.idperson = person_userList.idperson; person.findByIdperson(); person_user.person = person; person_userComboBox.Items.Add(person_user.user.username + " - " + person_user.person.personname); } signatureComboBox.Items.Clear(); Signature signature = new Signature(); signature.findAll(); foreach (Signature signatureList in signature.signatures) { signatureComboBox.Items.Add(signatureList.signaturename); } officeComboBox.Items.Clear(); Office office = new Office(); office.findAll(); foreach (Office officeList in office.offices) { officeComboBox.Items.Add(officeList.officedescription); } this.Cursor = System.Windows.Forms.Cursors.Default; }
public void findAll() { db = new Database(); person_user_computerQuery = new MySqlCommand(); person_user_computerQuery.Connection = db.Connection(); person_user_computerQuery.CommandText = "SELECT * FROM person_user_computer"; person_user_computerResult = person_user_computerQuery.ExecuteReader(); while (person_user_computerResult.Read()) { if (!person_user_computerResult.IsDBNull(0)) { idperson_user = person_user_computerResult.GetInt32(0); } if (!person_user_computerResult.IsDBNull(1)) { person = new Person(); person.idperson = person_user_computerResult.GetInt32(1); person.findByIdperson(); } if (!person_user_computerResult.IsDBNull(2)) { user = new User(); user.iduser = person_user_computerResult.GetInt32(2); user.findByIdUser(); } //if (!person_user_computerResult.IsDBNull(3)) //{ // person_userstart = person_user_computerResult.GetDateTime(3); //} //else //{ // person_userstart = null; //} //if (!person_user_computerResult.IsDBNull(4)) //{ // person_userfinish = person_user_computerResult.GetDateTime(4); //} //else //{ // person_userfinish = null; //} persons_users_computers.Add(new Person_User_Computer { idperson_user = this.idperson_user, person = this.person, user = this.user }); } db.Close(); }