// 4 fnc.Load Durectors
 public clsListDirectors fncGetDirectors()
 {
     try
     {
         // 1. Objet clsListDirectors
         clsListDirectors ListDirectors = new clsListDirectors();
         // 2. Execute open connection
         Command.Connection = Connection.OpenConnection();
         // 3. Execute stored procedure
         Command.CommandText = "selectDirectors";
         // 4. Execute specify the command type
         Command.CommandType = CommandType.StoredProcedure;
         // 5. Execute the Reader
         Read = Command.ExecuteReader();
         // 6. Load the list
         while (Read.Read())
         {
             // variables
             string  number, name, lastName, email, img, sexe, active;
             int     iddirector, idbank;
             decimal salary;
             iddirector = Read.GetInt32(Read.GetOrdinal("iddirector"));
             idbank     = Read.GetInt32(Read.GetOrdinal("idbank"));
             number     = Read.GetString(Read.GetOrdinal("Number"));
             name       = Read.GetString(Read.GetOrdinal("Name"));
             lastName   = Read.GetString(Read.GetOrdinal("Last Name"));
             email      = Read.GetString(Read.GetOrdinal("Email"));
             img        = Read.GetString(Read.GetOrdinal("img"));
             salary     = Read.GetDecimal(Read.GetOrdinal("salary"));
             sexe       = Read.GetString(Read.GetOrdinal("sexe"));
             active     = Read.GetString(Read.GetOrdinal("active"));
             ListDirectors.fncAdd(new clsDirector(iddirector, number, name, lastName, email, img, active, sexe, salary, idbank));
         }
         // 7. Close Read Connection
         Read.Close();
         Connection.CloseConnection();
         // 8. Make the return
         return(ListDirectors);
     }
     catch (Exception ex)
     {
         MessageBox.Show("Error in the Model getting the director list from data base " + ex.Message);
         return(null);
     }
 }
Exemple #2
0
 public void fncGetDirectors(clsDirector director)
 {
     try
     {
         // 1. Objet clsListDirectors
         clsListDirectors ListDirectors = new clsListDirectors();
         // 2. Execute open connection
         Command.Connection = Connection.OpenConnection();
         // 3. Execute stored procedure
         Command.CommandText = "selectDirectors";
         // 4. Execute specify the command type
         Command.CommandType = CommandType.StoredProcedure;
         // 5. Execute the Reader
         Read = Command.ExecuteReader();
         // 6. Load the list
         while (Read.Read())
         {
             director.vId       = Read.GetInt32(Read.GetOrdinal("iddirector"));
             director.vIdbank   = Read.GetInt32(Read.GetOrdinal("idbank"));
             director.vNumber   = Read.GetString(Read.GetOrdinal("Number"));
             director.vName     = Read.GetString(Read.GetOrdinal("Name"));
             director.vLastName = Read.GetString(Read.GetOrdinal("Last Name"));
             director.vEmail    = Read.GetString(Read.GetOrdinal("Email"));
             director.vImg      = Read.GetString(Read.GetOrdinal("img"));
             director.vSalary   = Read.GetDecimal(Read.GetOrdinal("salary"));
             director.vSexe     = Read.GetString(Read.GetOrdinal("sexe"));
             director.vActive   = Read.GetString(Read.GetOrdinal("active"));
             ListDirectors.fncAdd(director);
         }
         // 7. Close Read Connection
         Read.Close();
         Connection.CloseConnection();
     }
     catch (Exception ex)
     {
         MessageBox.Show("Error in the Model getting the director list from data base " + ex.Message);
     }
 }