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