private void ButtonLogin_Click(object sender, RoutedEventArgs e)
{
if (TextBoxEmail.Text.Length == 0)
{
ErrorMessage.Text = "Enter an email.";
TextBoxEmail.Focus();
}
else if (!Regex.IsMatch(TextBoxEmail.Text, @"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"))
{
ErrorMessage.Text = "Enter a valid email.";
TextBoxEmail.Select(0, TextBoxEmail.Text.Length);
TextBoxEmail.Focus();
}
else
{
string email = TextBoxEmail.Text;
string password = passwordBox1.Password;
if (_loginController.AuthenticateUser(email, password) == true)
{
string welcomeMessage = _loginController.GetCurrentUser();
MessageBox.Show(welcomeMessage);
Reset();
FrameMain.Navigate(new ShowItemsView());
}
else
{
ErrorMessage.Text = "Sorry! Please enter existing emailid/password.";
}
}
}
/// <summary>
/// Helper methods to display information in the Results textbox.
/// </summary>
private void ResultsClear()
{
TextBoxResults.Clear();
TextBoxLeadID.Clear();
TextBoxCapturedBy.Clear();
TextBoxCapturedDate.Clear();
TextBoxRegID.Clear();
TextBoxFirstName.Clear();
TextBoxLastName.Clear();
TextBoxTitle.Clear();
TextBoxCompany.Clear();
TextBoxCompany2.Clear();
TextBoxAddress.Clear();
TextBoxAddress2.Clear();
TextBoxAddress3.Clear();
TextBoxCity.Clear();
TextBoxStateCode.Clear();
TextBoxZipCode.Clear();
TextBoxCountryCode.Clear();
TextBoxEmail.Clear();
TextBoxPhone.Clear();
TextBoxPhoneExt.Clear();
TextBoxFax.Clear();
TextBoxNotes.Clear();
dgvDemographics.DataSource = null;
}
/// <summary>
/// Allows the other pages to return to this initial screen.
/// </summary>
public void GoBack()
{
TextBoxEmail.Clear();
TextBoxPassword.Clear();
LabelAlert.Content = "";
Content = content;
}
private void ButtonAjouter_OnClick(object sender, RoutedEventArgs e)
{
if (TextBoxNom.Text != "" & TextBoxPrenom.Text != "" & TextBoxSociete.Text != "" &
TextBoxTelephone.Text != "" &
TextBoxEmail.Text != "") // Si les champs ne sont pas vides, la création est impossible
{
SqlConnection connection = new SqlConnection(ConString);
connection.Open(); // Ouvertue de la connexion
SqlCommand cmdSqlCommand =
new SqlCommand(
"INSERT INTO dbo.Clients(Nom,Prenom,Societe,Telephone,Email) Values(@Nom, @Prenom, @Societe, @Telephone, @Email)",
connection); // Requête d'insertion d'un nouveau client
cmdSqlCommand.Parameters.AddWithValue("@Nom", TextBoxNom.Text); // Paramètre du Nom du client
cmdSqlCommand.Parameters.AddWithValue("@Prenom", TextBoxPrenom.Text); // Paramètre du Prenom du client
cmdSqlCommand.Parameters.AddWithValue("@Societe",
TextBoxSociete.Text); // Paramètre de la Societe du client
cmdSqlCommand.Parameters.AddWithValue("@Telephone",
TextBoxTelephone.Text); // Paramètre du numéro de Telephone du client
cmdSqlCommand.Parameters.AddWithValue("@Email", TextBoxEmail.Text); // Paramètre de l'Email du client
cmdSqlCommand.ExecuteNonQuery(); // Execution de la requête
MessageBox.Show("Le client " + TextBoxNom.Text + " " + TextBoxPrenom.Text + " " + "de la société " + TextBoxSociete.Text + " a été créé"); // Affichage du message après execution de la requête
FillDataGrid(); // Recharge la table Clients
TextBoxNom.Clear(); // Vide le champs Nom
TextBoxPrenom.Clear(); // Vide le champs Prenom
TextBoxSociete.Clear(); // Vide le champs Societe
TextBoxTelephone.Clear(); // Vide le champs Telephone
TextBoxEmail.Clear(); // Vide le champs Email
connection.Close(); // Fermeture de la connexion
}
}
private void ButtonLogin_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(TextBoxEmail.Text))
{
MessageBox.Show(" Введите вашу почту", "Внимание");
TextBoxEmail.Focus();
return;
}
if (string.IsNullOrWhiteSpace(PasswordBox.Password))
{
MessageBox.Show(" Введите ваш пароль", "Внимание");
PasswordBox.Focus();
return;
}
foreach (var user in context.Users)
{
if ((user.Email == TextBoxEmail.Text) && (user.Password == User.GetHash(PasswordBox.Password.Trim())))
{
User currentUser = user;
var display = new Display(context, currentUser);
display.Show();
this.Close();
return;
}
}
MessageBox.Show(" Почта или пароль были введены некорректно\n Повторите ввод или зарегистрируйтесь", "Пользователь не найден");
return;
}
private bool Validacija()
{
if (string.IsNullOrWhiteSpace(TextBoxIme.Text))
{
MessageBox.Show("Niste unijeli ime");
TextBoxIme.Focus();
return(false);
}
if (string.IsNullOrWhiteSpace(TextBoxPrezime.Text))
{
MessageBox.Show("Niste unijeli prezime");
TextBoxPrezime.Focus();
return(false);
}
if (string.IsNullOrWhiteSpace(TextBoxEmail.Text))
{
MessageBox.Show("Niste unijeli email");
TextBoxEmail.Focus();
return(false);
}
return(true);
}
private void Resetuj(bool rez)
{
TextBoxAutomobilId.Clear();
TextBoxTipId.Clear();
TextBoxTipGoriva.Clear();
TextBoxBrend.Clear();
TextBoxModel.Clear();
TextBoxGodProizvodnje.Clear();
TextBoxBoja.Clear();
TextBoxKapacitet.Clear();
TextBoxBrVrata.Clear();
TextBoxVrstaMenjaca.Clear();
TextBoxRezervacijaId.Clear();
DateDatumIznajmljivanja.SelectedDate = DateTime.Today;
DateDatumVracanja.SelectedDate = DateDatumIznajmljivanja.SelectedDate.Value.AddDays(1);
TextBoxCenaAuta.Clear();
TextBoxCenaRezervoara.Clear();
TextBoxUkupnaCena.Clear();
TextBoxOpis.Clear();
if (rez)
{
TextBoxImeKlijenta.Clear();
comboKlijenti.SelectedIndex = -1;
TextBoxImePrezime.Clear();
TextBoxDatum_rodjenja.Clear();
TextBoxEmail.Clear();
TextBoxBroj_telefona.Clear();
TextBoxBr_vozacke_dozvole.Clear();
TextBoxId.Clear();
}
}
private void ButtonEffacer_OnClick(object sender, RoutedEventArgs e)
{
if (TextBoxNom.Text != "" & TextBoxPrenom.Text != "" & TextBoxSociete.Text != "" &
TextBoxTelephone.Text != "" &
TextBoxEmail.Text != "") // Si les champs ne sont pas vides, la création est impossible
{
SqlConnection connection = new SqlConnection(ConString);
connection.Open(); // Ouvertue de la connexion
SqlCommand cmdSqlCommand =
new SqlCommand(
"DELETE FROM dbo.Clients WHERE Id=@Id",
connection); // Requête de suppression du client
cmdSqlCommand.Parameters.AddWithValue("@Id", TextBoxId.Text); // Paramètre de l'Email du client
if (MessageBox.Show("Oui ou Non", "Êtes vous sûr de vouloir supprimer ce client ?", MessageBoxButton.YesNo,
MessageBoxImage.Question) == MessageBoxResult.Yes) // Boite de dialogue demandant la confirmation pour la suppression du client
{
cmdSqlCommand.ExecuteNonQuery(); // Execution de la requête
MessageBox.Show("Le client " + TextBoxNom.Text + " " + TextBoxPrenom.Text + " " + "de la société " + TextBoxSociete.Text + " a été supprimé"); // Affichage du message après execution de la requête
}
FillDataGrid(); // Recharge la table Clients
TextBoxId.Clear();
TextBoxNom.Clear(); // Vide le champs Nom
TextBoxPrenom.Clear(); // Vide le champs Prenom
TextBoxSociete.Clear(); // Vide le champs Societe
TextBoxTelephone.Clear(); // Vide le champs Telephone
TextBoxEmail.Clear(); // Vide le champs Email
connection.Close(); // Fermeture de la connexion
}
}
private async void Submit_Click(object sender, RoutedEventArgs e)
{
Localclient = new Client();
SettingHandler.SetIpPort(TbIpPort.Text);
if (TextBoxEmail.Text.Length == 0)
{
Errormessage.Text = "Bitte Email-Addresse eingeben";
TextBoxEmail.Focus();
}
else if (!Regex.IsMatch(TextBoxEmail.Text, @"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"))
{
Errormessage.Text = "Bitte eine gültige EMail-Addresse eingeben";
TextBoxEmail.Select(0, TextBoxEmail.Text.Length);
TextBoxEmail.Focus();
}
else
{
var sc = ServerConnection.CurrentInstance ?? new ServerConnection();
Localclient.UserName = TextBoxUserName.Text;
Localclient.EMail = TextBoxEmail.Text;
Localclient.EncPassword = new Encryption(PasswordBox1.Password).EncryptStringToBytes(PasswordBox1.Password);
if (await sc.TryReg(Localclient))
{
Errormessage.Text = "Erfolgreich Registriert";
}
//TODOLOW: Needs a Close for the Reg Connection
}
}
//Updates the edited user
private void UpdateButton_Click(object sender, RoutedEventArgs e)
{
if (CheckInput())
{
if (CheckForDuplicate())
{
NewUser();
if (((User)ListBoxUsers.SelectedItem != null))
{
((User)ListBoxUsers.SelectedItem).Name = TextBoxName.Text;
((User)ListBoxUsers.SelectedItem).Email = TextBoxEmail.Text;
ListBoxUsers.Items.Remove(ListBoxUsers.SelectedItem);
}
else if (((User)ListBoxAdmins.SelectedItem != null))
{
((User)ListBoxAdmins.SelectedItem).Name = TextBoxName.Text;
((User)ListBoxAdmins.SelectedItem).Email = TextBoxEmail.Text;
ListBoxAdmins.Items.Remove(ListBoxAdmins.SelectedItem);
}
ButtonsDisabled();
UpdateButton.IsEnabled = false;
ButtonCreateUser.IsEnabled = true;
ListBoxUsers.IsEnabled = true;
ListBoxAdmins.IsEnabled = true;
TextBoxName.Clear();
TextBoxEmail.Clear();
}
}
}
public void CLearFields()
{
TextBoxSurname.Clear();
TextBoxName.Clear();
MaskedTBPhone.Clear();
TextBoxEmail.Clear();
LabelNumber.Text = "";
}
private void Resetuj()
{
TextBoxId.Clear();
TextBoxIme.Clear();
TextBoxPrezime.Clear();
TextBoxEmail.Clear();
ComboBox1.SelectedIndex = -1;
}
private void TextBoxEmail_Enter(object sender, EventArgs e)
{
if (TextBoxEmail.ForeColor == Color.DimGray && TextBoxEmail.Text == "Email")
{
TextBoxEmail.Clear();
TextBoxEmail.ForeColor = Color.Black;
}
}
private void ButtonRaz_OnClick(object sender, RoutedEventArgs e)
{
TextBoxId.Clear(); // Vide le champs ID
TextBoxNom.Clear(); // Vide le champs Nom
TextBoxPrenom.Clear(); // Vide le champs Prenom
TextBoxSociete.Clear(); // Vide le champs Societe
TextBoxTelephone.Clear(); // Vide le champs Telephone
TextBoxEmail.Clear(); // Vide le champs Email
}
private void ClearTextBoxes()
{
TextBoxFirst.Clear();
TextBoxLast.Clear();
TextBoxEmail.Clear();
PasswordBoxPassword.Clear();
TextBoxFirst.Focus();
}
private void Submit_Click(object sender, RoutedEventArgs e)
{
if (TextBoxEmail.Text.Length == 0)
{
Errormessage.Text = "Enter an email.";
TextBoxEmail.Focus();
}
else if (!Regex.IsMatch(TextBoxEmail.Text,
@"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"))
{
Errormessage.Text = "Enter a valid email.";
TextBoxEmail.Select(0, TextBoxEmail.Text.Length);
TextBoxEmail.Focus();
}
else
{
string firstname = TextBoxFirstName.Text;
string lastname = TextBoxLastName.Text;
string email = TextBoxEmail.Text;
string password = PasswordBox1.Password;
if (PasswordBox1.Password.Length == 0)
{
Errormessage.Text = "Enter password.";
PasswordBox1.Focus();
}
else if (PasswordBoxConfirm.Password.Length == 0)
{
Errormessage.Text = "Enter Confirm password.";
PasswordBoxConfirm.Focus();
}
else if (PasswordBox1.Password != PasswordBoxConfirm.Password)
{
Errormessage.Text = "Confirm password must be same as password.";
PasswordBoxConfirm.Focus();
}
else
{
Errormessage.Text = "";
User newUser = new User()
{
Pass = password,
Email = email,
FirstName = firstname,
LastName = lastname,
RegistrationDate = DateTime.Now
};
if (SaveToDatabase(newUser))
{
Errormessage.Text = "You have Registered successfully.";
RedirectToLoginPage(newUser);
Reset();
}
}
}
}
protected void BtnResetUserPassword_Click(object sender, EventArgs e)
{
string UserName2 = TextBoxUsername.Text.Trim();
string EmailEntered = TextBoxEmail.Text.Trim();
if (UserName2.Equals(""))
{
ShowMessage("Please Enter your System Username", true);
TextBoxUsername.Focus();
}
else if (EmailEntered.Equals(""))
{
ShowMessage("Please Enter Your System Email", true);
TextBoxEmail.Focus();
}
else
{
dataTable = datafile.GetUserPassword(UserName2, EmailEntered);
SystemUser user = new SystemUser();
if (dataTable.Rows.Count > 0)
{
user.Userid = int.Parse(dataTable.Rows[0]["Userid"].ToString());
user.Email = dataTable.Rows[0]["UserEmail"].ToString();
user.Fname = dataTable.Rows[0]["FirstName"].ToString();
user.Uname = dataTable.Rows[0]["UserName"].ToString();
user.Sname = dataTable.Rows[0]["SurName"].ToString();
user.Oname = dataTable.Rows[0]["OtherName"].ToString();
string passwd = bll.PasswdString(8);
user.Passwd = bll.EncryptString(passwd);
/// Reset Password
datafile.ResetPassword(user);
// DataLogin gg = new DataLogin();
string Subject = "New PegPay Portal Credentials";
string Body = "Hello\t" + user.Fname + "\t" + user.Sname + "\t" + user.Oname + "<br></br><br></br>" + "Please Find Below your New Portal Credentials" +
"<br></br><br></br>" + "Username:\t" + user.Uname +
"<br></br><br></br>" + "Password:\t" + passwd + "<br></br><br></br><br></br>Thank You" + "<br></br><b></br><b></br>Pegasus Technologies";
SendMail mm = new SendMail();
mm.SendUserEmail(user.Email, Subject, Body);
ShowMessage1("Hello\t" + user.Fname + "\t" + user.Sname + "\t" + user.Oname + "\t your new credentials have been sent to your Email", true);
MultiView1.ActiveViewIndex = 0;
}
else
{
ShowMessage("Your Username and Email are not corresponding", true);
ClearControls();
MultiView1.ActiveViewIndex = 2;
}
}
}
public void ClearInputs()
{
TextBoxFirstName.Clear();
TextBoxLastName.Clear();
TextBoxAge.Clear();
TextBoxEmail.Clear();
TextBoxAddress.Clear();
TextBoxSSN.Clear();
ComboBoxGender.SelectedIndex = -1;
}
internal void ClearControls()
{
TextBoxFirstName.Clear();
TextBoxLastName.Clear();
TextBoxCitizenID.Clear();
TextBoxContact.Clear();
DateTimeHireStaff.ResetText();
TextBoxAddress.Clear();
TextBoxCity.Clear();
TextBoxZipCode.Clear();
TextBoxEmail.Clear();
}
private void btnRecargar_Click(object sender, EventArgs e)
{
comboTipoDoc.SelectedIndex = -1;
comboCargo.SelectedIndex = -1;
TextBoxTelefono.Clear();
TextBoxApellido.Clear();
TextBoxNombre.Clear();
TextBoxDocumento.Clear();
TextBoxEmail.Clear();
RadioHombre.Checked = false;
RadioMujer.Checked = false;
}
public StAppEnter()
{
InitializeComponent();
TextBoxEmail.Focus();
foreach (var station in context.Stations)
{
if (station.Adress == "Клементовский пер., д.23, стр.1")
{
currentStation = station;
}
}
StationName.Text = currentStation.Adress.ToString();
}
//Create user button
private void ButtonCreateUser_Click(object sender, RoutedEventArgs e)
{
if (CheckInput())
{
if (CheckForDuplicate())
{
NewUser();
TextBoxName.Clear();
TextBoxEmail.Clear();
}
}
ListBoxUsers.UnselectAll();
ListBoxAdmins.UnselectAll();
ButtonsDisabled();
}
private async void LoginUser()
{
try
{
TextBlockError.Text = "";
await this._viewModel.LogIn(GetEmail(), GetPassword());
//await this._viewModel.LogIn("CrewMem1", "Test123!");
this.Frame.Navigate(typeof(Aircrew.Dashboard), null);
}
catch (Exception ex)
{
TextBlockError.Text = ex.Message;
TextBoxEmail.Focus(FocusState.Keyboard);
}
}
private void ButtonLogin_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(TextBoxEmail.Text))
{
MessageBox.Show(" Введите вашу почту", "Внимание");
TextBoxEmail.Focus();
return;
}
if (string.IsNullOrWhiteSpace(PasswordBox.Password))
{
MessageBox.Show(" Введите ваш пароль", "Внимание");
PasswordBox.Focus();
return;
}
foreach (var user in context.Users)
{
if ((user.Email == TextBoxEmail.Text.Trim()) && (user.Password == User.GetHash(PasswordBox.Password.Trim())))
{
User currentUser = user;
foreach (Ride ride in context.Rides)
{
if (ride.UserId == currentUser.Id && ride.IsRideFinished == false)
{
if (currentStation.NumberOfSlots == 0)
{
MessageBox.Show(" Вы не можете поставить велосипед на эту станцию.\n Нет свободных слотов", "Нет мест");
return;
}
var currentRide = ride;
var stAppLeaveBike = new StAppGiveBack(context, currentUser, currentStation, currentRide);
stAppLeaveBike.Show();
this.Close();
return;
}
}
var stAppTakeBike = new StAppTakeBike(context, currentUser, currentStation);
stAppTakeBike.Show();
this.Close();
return;
}
}
MessageBox.Show(" Почта или пароль были введены некорректно\n Повторите ввод или зарегистрируйтесь", "Пользователь не найден");
return;
}
private void SetControls(bool isEnabled)
{
if (InvokeRequired)
{
Invoke(new SetControlsDelegate(SetControls), isEnabled);
}
else
{
TextBoxEmail.Enabled = isEnabled;
ButtonAddAdmin.Enabled = isEnabled;
if (isEnabled)
{
TextBoxEmail.Clear();
}
}
}
private void ButtonSubmit_Click(object sender, RoutedEventArgs e)
{
if (TextBoxEmail.Text.Length == 0)
{
ErrorMessage.Text = "Enter an email.";
TextBoxEmail.Focus();
}
else if (!Regex.IsMatch(TextBoxEmail.Text, @"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"))
{
ErrorMessage.Text = "Enter a valid email.";
TextBoxEmail.Select(0, TextBoxEmail.Text.Length);
TextBoxEmail.Focus();
}
else
{
string firstName = TextBoxFirstName.Text;
string lastName = TextBoxLastName.Text;
string email = TextBoxEmail.Text;
string password = PasswordBox1.Password;
if (PasswordBox1.Password.Length == 0)
{
ErrorMessage.Text = "Enter password.";
PasswordBox1.Focus();
}
else if (PasswordBoxConfirm.Password.Length == 0)
{
ErrorMessage.Text = "Enter Confirm password.";
PasswordBoxConfirm.Focus();
}
else if (PasswordBox1.Password != PasswordBoxConfirm.Password)
{
ErrorMessage.Text = "Confirm password must be same as password.";
PasswordBoxConfirm.Focus();
}
else
{
ErrorMessage.Text = "";
_registerController.CreateNewUser(firstName, lastName, email, password);
ErrorMessage.Text = "You have Registered successfully.";
Reset();
FrameMain.Navigate(new ShowItemsView());
}
}
}
protected void ButtonRegistar_Click(object sender, EventArgs e)
{
if (TextBoxPass.Text != TextBoxPass2.Text)
{
divErrors.Visible = true;
StatusText.Text = "As palavras-passe não são iguais!";
TextBoxPass.Focus();
}
else if (EmailInUse(TextBoxEmail.Text))
{
divErrors.Visible = true;
StatusText.Text = "O email introduzido já está em uso!";
TextBoxEmail.Focus();
}
else
{
InstanciateUser();
}
}
protected void ButtonSignUp_Click(object sender, EventArgs e)
{
bool isExistingUser = CheckIsExistingUser();
if (isExistingUser)
{
divAlertMessage.Visible = true;
divAlertMessage.Attributes["class"] = "alert fade in alert-error";
labelAlertMessage.InnerText = "Email ID already exists.";
TextBoxEmail.Focus();
}
else
{
bool isSuccess = Insert();
if (isSuccess)
{
FormsAuthentication.RedirectFromLoginPage(TextBoxEmail.Text.Trim(), false);
}
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
if (TextBoxEmail.Text.Length == 0)
{
Errormessage.Text = "Enter valid UserName or password!";
TextBoxEmail.Focus();
}
string email = TextBoxEmail.Text;
string password = PasswordBox.Password;
if (Globas.Db.ValidPassword(email, password))
{
Main.Show();
Close();
}
else
{
Errormessage.Text = "Sorry! Please enter existing username/password.";
}
}
private void ButtonModifier_OnClick(object sender, RoutedEventArgs e)
{
if (TextBoxId.Text != "" & TextBoxNom.Text != "" & TextBoxPrenom.Text != "" & TextBoxSociete.Text != "" &
TextBoxTelephone.Text != "" & TextBoxEmail.Text != "") // Si les champs ne sont pas vides, la modification est impossible
{
SqlConnection connection = new SqlConnection(ConString);
connection.Open(); // Ouvertue de la connexion
SqlCommand cmdSqlCommand =
new SqlCommand(
"UPDATE dbo.Clients SET Nom=@Nom, Prenom=@Prenom ,Societe=@Societe, Telephone=@Telephone, Email=@Email WHERE Id=@Id"
, connection); // Requête d'insertion d'un nouveau client
cmdSqlCommand.Parameters.AddWithValue("@Id", TextBoxId.Text); // Paramètre de l'ID du client
cmdSqlCommand.Parameters.AddWithValue("@Nom", TextBoxNom.Text); // Paramètre du Nom du client
cmdSqlCommand.Parameters.AddWithValue("@Prenom", TextBoxPrenom.Text); // Paramètre du Prenom du client
cmdSqlCommand.Parameters.AddWithValue("@Societe", TextBoxSociete.Text); // Paramètre de la Societe du client
cmdSqlCommand.Parameters.AddWithValue("@Telephone", TextBoxTelephone.Text); // Paramètre du numéro de Telephone du client
cmdSqlCommand.Parameters.AddWithValue("@Email", TextBoxEmail.Text); // Paramètre de l'Email du client
cmdSqlCommand.ExecuteNonQuery(); // Execution de la requête
int rows = cmdSqlCommand.ExecuteNonQuery(); // Variable qui stocke le nombre de requêtes effectuées
if (rows > 1)
{
MessageBox.Show(rows + " requêtes ont bien été effectuées"); // Affichage du message après execution de la requête (dans le cas où il y en a plusieurs)
}
else
{
MessageBox.Show(rows + " requête a bien été effectuée"); // Affichage du message après execution de la requête (dans le cas où il n'y en a qu'une seule)
}
FillDataGrid(); // Recharge la table Clients
TextBoxNom.Clear(); // Vide le champs Nom
TextBoxPrenom.Clear(); // Vide le champs Prenom
TextBoxSociete.Clear(); // Vide le champs Societe
TextBoxTelephone.Clear(); // Vide le champs Telephone
TextBoxEmail.Clear(); // Vide le champs Email
connection.Close(); // Fermeture de la connexion
}
}
