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