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
|
public void AddCustomer()
{
SqlCeCommand cmd = clConnexionBdd.PreparerCommande("SELECT * FROM Customer "
+ "WHERE (FirstName = @FirstName AND Name = @Name)");
cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = this._firstNameCustomer;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = this._nameCustomer;
// Object datareader
SqlCeDataReader rdr = cmd.ExecuteReader();
Object[] row = null;
bool find = false;
while (rdr.Read())
{
if (row == null)
{
MessageBox.Show("Le client existe déja dans la base de données", "Client déja référencé", MessageBoxButtons.OK, MessageBoxIcon.Information);
find = true;
}
}
rdr.Close();
if (find == false)
{
SqlCeCommand cmdAddCustomer = clConnexionBdd.PreparerCommande("INSERT INTO Customer (Civility, FirstName, Name, AdressL1, AdressL2, "
+ "ZipCode, City, Country, TelHome, TelOffice, TelMobile, Fax, Email, Observations, OriginBooking, TypeOf, "
+ "Appreciation, DateCreated) "
+ "VALUES (@Civility, @FirstName, @Name, @AdressL1, @AdressL2, @ZipCode, @City, @Country, @TelHome, @TelOffice,"
+ "@TelHome, @Fax, @Email, @Observations, @OriginBooking, @TypeOf, @Appreciation, @DateCreated)");
//Attribution des valeurs aux paramètres
cmdAddCustomer.Parameters.Add("@Civility", SqlDbType.NVarChar).Value = this._civilityCustomer;
cmdAddCustomer.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = this._firstNameCustomer;
cmdAddCustomer.Parameters.Add("@Name", SqlDbType.NVarChar).Value = this._nameCustomer;
cmdAddCustomer.Parameters.Add("@AdressL1", SqlDbType.NVarChar).Value = this._adressL1Customer;
cmdAddCustomer.Parameters.Add("@AdressL2", SqlDbType.NVarChar).Value = this._adressL2Customer;
cmdAddCustomer.Parameters.Add("@ZipCode", SqlDbType.NVarChar).Value = this._zipCodeCustomer;
cmdAddCustomer.Parameters.Add("@City", SqlDbType.NVarChar).Value = this._cityCustomer;
cmdAddCustomer.Parameters.Add("@Country", SqlDbType.NVarChar).Value = this._countryCustomer;
cmdAddCustomer.Parameters.Add("@TelHome", SqlDbType.NVarChar).Value = Convert.ToInt64(this._telHomeCustomer);
cmdAddCustomer.Parameters.Add("@TelOffice", SqlDbType.NVarChar).Value = Convert.ToInt64(this._telOfficeCustomer);
cmdAddCustomer.Parameters.Add("@TelMobile", SqlDbType.NVarChar).Value = Convert.ToInt64(this._telMobileCustomer);
cmdAddCustomer.Parameters.Add("@Fax", SqlDbType.BigInt).Value = Convert.ToInt64(this._faxCustomer);
cmdAddCustomer.Parameters.Add("@Email", SqlDbType.NVarChar).Value = this._emailCustomer;
cmdAddCustomer.Parameters.Add("@Observations", SqlDbType.NVarChar).Value = this._observationsCustomer;
cmdAddCustomer.Parameters.Add("@OriginBooking", SqlDbType.NVarChar).Value = this._originBookingCustomer;
cmdAddCustomer.Parameters.Add("@TypeOf", SqlDbType.NVarChar).Value = this._typeOfCustomer;
cmdAddCustomer.Parameters.Add("@Appreciation", SqlDbType.NVarChar).Value = this._appreciationCustomer;
cmdAddCustomer.Parameters.Add("@DateCreated", SqlDbType.DateTime).Value = this._dateCreatedCustomer;
cmdAddCustomer.ExecuteNonQuery();
}
} |
