1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174
|
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace PTI_5
{
public class clients // En public pour pouvoir la passer en paramètre dans les formulaires //
{
// --------------------------------------
// ATTRIBUTS |
//---------------------------------------
private int clientNum;
private string clientNom;
private string clientPrenom;
private string adresse;
private string adresse2;
private string tel;
private string cp;
private List<Classes.Sejour> mesSejours;
// --------------------------------------
// ACCESSEURS |
//---------------------------------------
public string ClientPrenom
{
get { return clientPrenom; }
set { clientPrenom = value; }
}
public string ClientNom
{
get { return clientNom; }
set { clientNom = value; }
}
public int ClientNum
{
get { return clientNum; }
set { clientNum = value; }
}
public List<Classes.Sejour> MesSejours
{
get { return mesSejours; }
set { mesSejours = value; }
}
public string Adresse
{
get { return adresse; }
set { adresse = value; }
}
public string Adresse2
{
get { return adresse2; }
set { adresse2 = value; }
}
public string Tel
{
get { return tel; }
set { tel = value; }
}
public string Cp
{
get { return cp; }
set { cp = value; }
}
// __________________________________________________________________________________________//
// --------------------------------------
// CONSTRUCTEURS |
//---------------------------------------
public clients(int ClientNum,string ClientNom, string ClientPrenom,string Adresse,string Adresse2,string Tel, string Cp)
{
this.clientNum = ClientNum;
this.clientNom = ClientNom;
this.clientPrenom = ClientPrenom;
this.adresse = Adresse;
this.adresse2 = Adresse2;
this.cp = Cp;
this.tel = Tel;
}
public clients(int ClientNum, string ClientNom, string ClientPrenom,List<Classes.Sejour> MesSejours)
{
this.clientNum = ClientNum;
this.clientNom = ClientNom;
this.clientPrenom = ClientPrenom;
this.mesSejours = MesSejours;
}
//_____________________________________________________________________________________________________//
// --------------------------------------
// METHODES |
//---------------------------------------
public Boolean possedeSejour(SqlConnection m_connection)
{
string request = "SELECT cli_nom FROM Clients inner join Sejours on Clients.cli_num = Sejours.sej_client WHERE cli_num="+this.ClientNum;
SqlCommand maCommande = new SqlCommand(request,m_connection);
if (maCommande.ExecuteScalar() == null)
return false;
else
return true;
}
public static List<Classes.Sejour> affecterSejour(SqlConnection m_connection, clients MonClient)
{
List<Classes.Sejour> MesSejours = new List<Classes.Sejour>();
// SQL //
string request = "SELECT * FROM Clients inner join Sejours on Clients.cli_num = Sejours.sej_client WHERE cli_num=" + MonClient.ClientNum;
SqlCommand maCommande = new SqlCommand(request,m_connection);
SqlDataReader reader = maCommande.ExecuteReader();
// SQL //
while (reader.Read())
{
Classes.Sejour MonSejour = null;
// On instancie le Sejour //
if ((Classes.Bdd.getTypeSejour(Convert.ToInt16(reader["sej_num"]), m_connection) == "SejoursCaravane"))
{
MonSejour = new Classes.SejourCaravane(Convert.ToInt16(reader["sej_num"]), Convert.ToDateTime(reader["sej_dateDebut"]), Convert.ToDateTime(reader["sej_datefin"]), Convert.ToSingle(reader["sej_prixEmplacement"]), MonClient);
}
else
{
if ((Classes.Bdd.getTypeSejour(Convert.ToInt16(reader["sej_num"]), m_connection) == "SejoursGroupe"))
{
// Si le sejour est de type Groupe, on recrée une seconde requête SQL afin de récupérer les propriétés propre au groupe (nbpersonnes) //
// On instancie donc un nouvel objet SejourGroupe //
string request2 = "SELECT * FROM Sejours inner join SejoursGroupe on Sejours.sej_num = SejoursGroupe.sej_num WHERE Sejours.sej_num=" + Convert.ToInt16(reader["sej_num"]);
SqlCommand maCommande2 = new SqlCommand(request2, m_connection);
SqlDataReader reader2 = maCommande2.ExecuteReader();
while (reader2.Read())
{
MonSejour = new Classes.SejourGroupe(Convert.ToInt16(reader2["sej_num"]), Convert.ToDateTime(reader2["sej_dateDebut"]), Convert.ToDateTime(reader2["sej_datefin"]), Convert.ToSingle(reader2["sej_prixEmplacement"]), MonClient, Convert.ToInt16(reader2["nb_personne"]));
}
}
else
{
if ((Classes.Bdd.getTypeSejour(Convert.ToInt16(reader["sej_num"]), m_connection) == "SejoursMobilHome"))
{
string request2 = "SELECT * FROM Sejours inner join SejoursMobilHome on Sejours.sej_num = SejoursMobilHome.sej_num WHERE Sejours.sej_num=" + Convert.ToInt16(reader["sej_num"]);
SqlCommand maCommande2 = new SqlCommand(request2, m_connection);
SqlDataReader reader2 = maCommande2.ExecuteReader();
while (reader2.Read())
{
MonSejour = new Classes.SejourMobilHome(Convert.ToInt16(reader2["sej_num"]), Convert.ToDateTime(reader2["sej_dateDebut"]), Convert.ToDateTime(reader2["sej_datefin"]), Convert.ToSingle(reader2["sej_prixEmplacement"]), MonClient, Convert.ToInt16(reader2["nbAdulte"]), Convert.ToInt16(reader2["nbEnfant"]));
MonSejour.getType();
}
}
}
}
MesSejours.Add(MonSejour);
}
return MesSejours;
} |