public void AddClientToBdd(ref string FirstName, ref string LastName, ref string Country, ref string city, ref string CellNumber, ref string Address, ref string Email)
{
storedProcedure_name = @"dbo.[AddClient]";
using SqlConnection connection = new SqlConnection(Helper.CnnVal("ManagementAppDB"));
{
SqlCommand command = new SqlCommand(storedProcedure_name, connection);
command.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = FirstName;
command.Parameters.Add("@LastName", SqlDbType.VarChar).Value = LastName;
command.Parameters.Add("@Country", SqlDbType.VarChar).Value = Country;
command.Parameters.Add("@City", SqlDbType.VarChar).Value = city;
command.Parameters.Add("@CellNumber", SqlDbType.VarChar).Value = CellNumber;
command.Parameters.Add("@Address", SqlDbType.VarChar).Value = Address;
command.Parameters.Add("@Email", SqlDbType.VarChar).Value = Email;
connection.Open();
command.CommandType = CommandType.StoredProcedure;
command.ExecuteNonQuery();
increment += 1;
if (increment >= 1)
{
Manage = new VerifyInformation_And_ManageStuff();
Manage.GetCurrentMenuFormInstance(ref Menu);
}
}
}
private void EnregistrerBtn_Click(object sender, EventArgs e)
{
DataAccess InsertDatatoBdd = new DataAccess();
VerifyInformation_And_ManageStuff Ifempty = new VerifyInformation_And_ManageStuff();
string prenom = "", nom = "", pays = "", ville = "", adresse = "", mail = "", telephone = "";
prenom = Prenom.Text;
nom = Nom.Text;
pays = Pays.Text;
ville = Ville.Text;
telephone = Telephone.Text;
adresse = Adresse.Text;
mail = Mail.Text;
if (!Ifempty.IsAddClientTextfieldEmpty(prenom, nom, pays, ville, Telephone.Text, adresse, mail))
{
return;
}
else
{
InsertDatatoBdd.AddClientToBdd(ref prenom, ref nom, ref pays, ref ville, ref telephone, ref adresse, ref mail);
MessageBox.Show("Enregistrement reussi", "Enregistrement", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
ResetTextboxContains();
}
}
private void Login_button_Click(object sender, EventArgs e)
{
DataAccess data = new DataAccess();
VerifyInformation_And_ManageStuff IfEmpty = new VerifyInformation_And_ManageStuff();
if (!IfEmpty.IsLoginTextfieldEmpty(UserNameTextbox.Text, PasswordTextbox.Text))
{
return;
}
data.VerifyCredentialsInformation(UserNameTextbox.Text, PasswordTextbox.Text);
}
