public ProjetForfait(int initCodeProjet, string initNomProjet, DateTime initDdebut, DateTime initDfin, Client initLeCLient, string initContact, string initMailContact, decimal initMontantContrat, bool YesNo, Collaborateur initChefDeProjet) { CodeProjet = initCodeProjet; NomProjet = initNomProjet; DDebut = initDdebut; DFin = initDfin; LeClient = initLeCLient; Contact = initContact; MailContact = initMailContact; MontantContrat = initMontantContrat; if (YesNo == true) { PenaliteOuiNon = Penalite.Oui; } else PenaliteOuiNon = Penalite.Non; ChefDeProjet = initChefDeProjet; }
public static List<Client> GetAllclients() { using (SqlConnection sqlConnect = GetConnection()) { using (SqlCommand sqlCde = new SqlCommand()) { sqlCde.Connection = sqlConnect; string strsql = "Select [idClient],[raisonsociale],[adresse1],[adresse2],[cp],[ville],[telephone],[mail] from Client "; try { sqlCde.CommandText = strsql; SqlDataReader sqlRdr = sqlCde.ExecuteReader(); Clients = new List<Client>(); while (sqlRdr.Read()) { Client cli = new Client() { CodeClient = sqlRdr.GetInt32(0), RaisonSociale = sqlRdr.GetString(1), Adresse1 = sqlRdr.GetString(2), Adresse2 = sqlRdr[3].ToString(), CP = sqlRdr.GetString(4), Ville = sqlRdr.GetString(5), Telephone = sqlRdr.GetString(6), Mail = sqlRdr[7].ToString() }; Clients.Add(cli); } sqlRdr.Close(); return Clients; } catch (Exception ex) { throw new DAOException(ex.Message); } } } }