public void ajouterHotel(clsHotelEntity hotel, clsInfoClient client)
{
SqlConnection MyC = new SqlConnection();
MyC.ConnectionString = Connection;
MyC.Open();
SqlCommand MyCom = new SqlCommand("dbo.enregistrerHotel", MyC);
MyCom.CommandType = CommandType.StoredProcedure;
MyCom.Parameters.Add("@nomUser", SqlDbType.Text);
MyCom.Parameters["@nomUser"].Value = client.nomUser;
MyCom.Parameters.Add("@prenomUser", SqlDbType.Text);
MyCom.Parameters["@prenomUser"].Value = client.prenomUser;
MyCom.Parameters.Add("@adresseUser", SqlDbType.Text);
MyCom.Parameters["@adresseUser"].Value = client.adresseUser;
MyCom.Parameters.Add("@cpUser", SqlDbType.Int);
MyCom.Parameters["@cpUser"].Value = client.cpUser;
MyCom.Parameters.Add("@villeUser", SqlDbType.Text);
MyCom.Parameters["@villeUser"].Value = client.villeUser;
MyCom.Parameters.Add("@PAYSUSER", SqlDbType.Text);
MyCom.Parameters["@PAYSUSER"].Value = client.paysUser;
MyCom.Parameters.Add("@compteUser", SqlDbType.Text);
MyCom.Parameters["@compteUser"].Value = client.compteUser;
MyCom.Parameters.Add("@nomHotel", SqlDbType.Text);
MyCom.Parameters["@nomHotel"].Value = hotel.nomHotel;
MyCom.Parameters.Add("@adresseHotel", SqlDbType.Text);
MyCom.Parameters["@adresseHotel"].Value = hotel.adresseHotel;
MyCom.Parameters.Add("@cpHotel", SqlDbType.Int);
MyCom.Parameters["@cpHotel"].Value = hotel.cpHotel;
MyCom.Parameters.Add("@villeHotel", SqlDbType.Text);
MyCom.Parameters["@VilleHotel"].Value = hotel.villeHotel;
MyCom.Parameters.Add("@paysHotel", SqlDbType.Text);
MyCom.Parameters["@paysHotel"].Value = hotel.paysHotel;
MyCom.Parameters.Add("@dateArriveeHotel", SqlDbType.Date);
MyCom.Parameters["@dateArriveeHotel"].Value = hotel.dateArrivee;
MyCom.Parameters.Add("@dureeSejour", SqlDbType.Int);
MyCom.Parameters["@dureeSejour"].Value = hotel.duree;
MyCom.Parameters.Add("@prixHotel", SqlDbType.Int);
MyCom.Parameters["@prixHotel"].Value = hotel.prixNuit;
MyCom.ExecuteScalar();
MyCom.Dispose();
MyC.Close();
}
public void ajouterVol(clsVolEntity vol, clsInfoClient client)
{
SqlConnection MyC = new SqlConnection();
MyC.ConnectionString = Connection;
MyC.Open();
SqlCommand MyCom = new SqlCommand("dbo.enregistrerVol", MyC);
MyCom.CommandType = CommandType.StoredProcedure;
MyCom.Parameters.Add("@nomUser", SqlDbType.Text);
MyCom.Parameters["@nomUser"].Value = client.nomUser;
MyCom.Parameters.Add("@prenomUser", SqlDbType.Text);
MyCom.Parameters["@prenomUser"].Value = client.prenomUser;
MyCom.Parameters.Add("@adresseUser", SqlDbType.Text);
MyCom.Parameters["@adresseUser"].Value = client.adresseUser;
MyCom.Parameters.Add("@cpUser", SqlDbType.Int);
MyCom.Parameters["@cpUser"].Value = client.cpUser;
MyCom.Parameters.Add("@villeUser", SqlDbType.Text);
MyCom.Parameters["@villeUser"].Value = client.villeUser;
MyCom.Parameters.Add("@paysUser", SqlDbType.Text);
MyCom.Parameters["@paysUser"].Value = client.paysUser;
MyCom.Parameters.Add("@compteUser", SqlDbType.Text);
MyCom.Parameters["@compteUser"].Value = client.compteUser;
MyCom.Parameters.Add("@villeDepartVol", SqlDbType.Text);
MyCom.Parameters["@villeDepartVol"].Value = vol.villeDepart;
MyCom.Parameters.Add("@paysDepartVol", SqlDbType.Text);
MyCom.Parameters["@paysDepartVol"].Value = vol.paysDepart;
MyCom.Parameters.Add("@villeDestinationVol", SqlDbType.Text);
MyCom.Parameters["@villeDestinationVol"].Value = vol.villeDestination;
MyCom.Parameters.Add("@paysDestinationVol", SqlDbType.Text);
MyCom.Parameters["@paysDestinationVol"].Value = vol.paysDestination;
MyCom.Parameters.Add("@dateDepartVol", SqlDbType.Date);
MyCom.Parameters["@dateDepartVol"].Value = vol.dateDepart;
MyCom.Parameters.Add("@prixVol", SqlDbType.Int);
MyCom.Parameters["@prixVol"].Value = vol.prixVol;
MyCom.ExecuteScalar();
MyCom.Dispose();
MyC.Close();
}
public bool ajouterCommande(clsHotelEntity hotel, clsVolEntity vol, clsInfoClient client)
{
bool R = true;
try
{
(new clsEnregistrerHotel()).ajouterHotel(hotel, client);
(new clsEnregistrerVol()).ajouterVol(vol, client);
}
catch(SqlException e)
{
Console.WriteLine(e);
R = false;
}
return R;
}
protected void Button_valider_Click(object sender, EventArgs e)
{
// vol.nom
// Donnée à envoyer
string nom = txtNom.Text;
string prenom = txtPrenom.Text;
string age = txtAge.Text;
string nationalite = txtNationalite.Text;
string ville = txtVille.Text;
string adresse = txtAdresse.Text;
string tel = txtTelephone.Text;
string numCarte = txtNumCarte.Text;
string crypto = txtCryptogramme.Text;
// date d'expiration de la carte
DateTime dateExp = new DateTime(Convert.ToInt32(drpAnneeExpiration.SelectedValue),
Convert.ToInt32(drpMoisExpiration.SelectedValue), 1);
// Verification de remplissable des champs
if (!String.IsNullOrEmpty(nom) && !String.IsNullOrEmpty(prenom) &&
!String.IsNullOrEmpty(age) && !String.IsNullOrEmpty(nationalite) &&
!String.IsNullOrEmpty(ville) && !String.IsNullOrEmpty(txtCp.Text) &&
!String.IsNullOrEmpty(adresse) && !String.IsNullOrEmpty(tel)&&
!String.IsNullOrEmpty(numCarte) && !String.IsNullOrEmpty(crypto)
&& dateExp != null)
{
// Informations client
clsInfoClient client = new clsInfoClient();
client.nomUser = nom;
client.prenomUser = prenom;
client.age = age;
client.paysUser = nationalite;
client.villeUser = ville;
client.cpUser = Convert.ToInt32(txtCp.Text);
client.adresseUser = adresse;
client.tel = tel;
client.compteUser = numCarte + ' ' + crypto;
client.dateExp = dateExp;
// Recuperation du vol et de l'hotel
clsVolEntity vol = new clsVolEntity();
clsHotelEntity hotel = new clsHotelEntity();
vol = (clsVolEntity) Session["vol"];
hotel = (clsHotelEntity) Session["hotel"];
vol.infoClient = client;
hotel.infoClient = client;
// Ajout a la file d'attente
MessageQueue mqVols = new MessageQueue(@".\private$\cmdvols");
MessageQueue mqHotels = new MessageQueue(@".\private$\cmdhotels");
mqVols.Send(vol, "Commande vol");
mqHotels.Send(hotel, "Commande hotel");
mqVols.Close();
mqHotels.Close();
Response.Redirect("UICommandeValidee.aspx");
}
else
{
lblError.Text = "Veuillez remplir les champs !";
lblError.Visible = true;
}
}