private void saveAndClose()
{
Boolean isAnyEmpty = false;
ArrayList arrParam = new ArrayList();
errorMessage("");
isAnyEmpty = _Inputs.Any(x => x.Text.Equals(""));
if (isAnyEmpty)
{
errorMessage("Veuillez remplir tout les élements du formulaire");
return;
}
if (_Title.Equals("agenda"))
{
TextBox textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXDATE"));
if (!isDateValid(textBox.Text))
{
errorMessage("Date non conforme(ex:01.01.2019)");
return;
}
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXHEURE"));
if (!isHourValid(textBox.Text))
{
errorMessage("Heure non conforme (ex:08:15)");
return;
}
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXNOMCLIENT"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXTYPE"));
arrParam.Add(textBox.Text);
//insert agenda with query
DataSetISpaDataTableAdapters.VW_AGENDATableAdapter tableAdapter = new DataSetISpaDataTableAdapters.VW_AGENDATableAdapter();
int resp = tableAdapter.InsertQuery(Convert.ToDateTime(arrParam[0]), Convert.ToDateTime(arrParam[1]), arrParam[2].ToString(), arrParam[3].ToString());
Console.WriteLine(resp);
//tableAdapter.InsertQuery(Convert.ToDateTime(arrParam[0]), Convert.ToDateTime(arrParam[1]), arrParam[2].ToString(), arrParam[3].ToString());
_MotherForm.addRow(arrParam);
}
if (_Title.Equals("clients"))
{
//first_name,last_name,d.o.b,email,adresse
TextBox textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXPRENOM"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXNOM"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXDOB"));
if (!isDateValid(textBox.Text))
{
errorMessage("Date de naissance non conforme (ex:01.01.2019");
return;
}
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXEMAIL"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXADRESSE"));
arrParam.Add(textBox.Text);
//insert client with query
DataSetISpaDataTableAdapters.VW_CLIENTTableAdapter tableAdapter = new DataSetISpaDataTableAdapters.VW_CLIENTTableAdapter();
tableAdapter.InsertQuery(arrParam[0].ToString(), arrParam[1].ToString(), Convert.ToDateTime(arrParam[2]), arrParam[3].ToString(), arrParam[4].ToString());
_MotherForm.addRow(arrParam);
}
if (_Title.Equals("factures"))
{
//Date d'ouverture,ID Client,Nom Client,Type,Prix,Payé
TextBox textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXDATE"));
if (!isDateValid(textBox.Text))
{
errorMessage("Date de naissance non conforme (ex:01.01.2019)");
return;
}
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXHEURE"));
if (!isHourValid(textBox.Text))
{
errorMessage("Heure non conforme (ex:08:15)");
return;
}
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXNOMCLIENT"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXTYPE"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXPRIX"));
String val = textBox.Text;
val.Replace(',', '.');
double outDouble;
if (!double.TryParse(textBox.Text, out outDouble))
{
errorMessage("Prix non conforme (ex: 5.50)");
return;
}
val.Replace('.', ',');
arrParam.Add(val);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXPAYE"));
if (!(textBox.Text.ToLower() == "true" || textBox.Text.ToLower() == "false"))
{
errorMessage("Boolean de paiement non conforme (ex:true ou false");
return;
}
arrParam.Add(textBox.Text == "true" ? 1 : 0);
DateTime date1 = Convert.ToDateTime(arrParam[0]);
DateTime time1 = Convert.ToDateTime(arrParam[1]);
//insert factures with query
DataSetISpaDataTableAdapters.VW_FACTURETableAdapter tableAdapter = new DataSetISpaDataTableAdapters.VW_FACTURETableAdapter();
tableAdapter.InsertQuery(date1, time1, arrParam[2].ToString(), arrParam[3].ToString(), arrParam[4].ToString(), Convert.ToDecimal(arrParam[5]));
_MotherForm.addRow(arrParam);
}
if (_Title.Equals("products"))
{
//nom,description,fournisseur,prix
TextBox textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXNOM"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXDESCRIPTION"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXFOURNISSEUR"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXPRIX"));
String val = textBox.Text;
val.Replace(',', '.');
double outDouble;
if (!double.TryParse(textBox.Text, out outDouble))
{
errorMessage("Prix non conforme (ex: 5.50)");
return;
}
val.Replace('.', ',');
arrParam.Add(val);
//insert product with query
DataSetISpaDataTableAdapters.VW_PRODUITTableAdapter tableAdapter = new DataSetISpaDataTableAdapters.VW_PRODUITTableAdapter();
tableAdapter.InsertQuery(arrParam[0].ToString(), arrParam[1].ToString(), arrParam[2].ToString(), arrParam[3].ToString());
_MotherForm.addRow(arrParam);
}
if (_Title.Equals("users"))
{
DataSetISpaData datas = new DataSetISpaData();
ArrayList arr = new ArrayList();
// set attributes from form
TextBox textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXNOM"));
arr.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXPASSWORD"));
arr.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXTYPE"));
arr.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXACTIF"));
if (!(textBox.Text.ToLower() == "true" || textBox.Text.ToLower() == "false"))
{
errorMessage("Boolean Actif non conforme (ex:true ou false)");
return;
}
arr.Add(textBox.Text == "true" ? 1 : 0);
//insert user with query
DataSetISpaDataTableAdapters.VW_USERTableAdapter tableAdapter = new DataSetISpaDataTableAdapters.VW_USERTableAdapter();
tableAdapter.InsertQuery(arr[0].ToString(), arr[1].ToString(), arr[2].ToString(), Convert.ToDecimal(arr[3]));
//refresh current table
_MotherForm.addRow(arrParam);
}
if (_Title.Equals("changer de mot de passe"))
{
String username;
lblError.Text = "";
TextBox textBox = _Inputs.Find(x => x.Name.Contains("txtBoxAncien mot de passe"));
String oldPass = textBox.Text.Trim();
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxNouveau mot de passe"));
String newPass = textBox.Text.Trim();
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxRépéter nouveau mot de passe"));
String secondNewPass = textBox.Text.Trim();
DataSetISpaDataTableAdapters.VW_USERTableAdapter tableAdapter = new DataSetISpaDataTableAdapters.VW_USERTableAdapter();
DataSetISpaData.VW_USERDataTable dataTable;
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxNom utilisateur"));
if (textBox is null)
{
username = _ArrayParam[0].ToString();
dataTable = tableAdapter.GetDataByUser(username);
}
else
{
username = textBox.Text.Trim();
dataTable = tableAdapter.GetDataByUser(username);
}
if (dataTable.Rows.Count == 0)
{
errorMessage("Votre compte à été supprimé de la base, veuillez contacter l'admin");
return;
}
DataRow row = dataTable.Rows[0];
if (row != null)
{
if (row["XNOM"].ToString().Trim().Equals(username.Trim()) && row["XPASSWORD"].ToString().Trim().Equals(oldPass.Trim()))
{
if (row["XACTIF"].ToString().Trim() == "0")
{
errorMessage("Votre compte à été désactivé, veuillez contacter l'admin");
return;
}
Console.WriteLine("cred ok " + username + " " + oldPass);
if (!newPass.Equals(secondNewPass))
{
errorMessage("Vous n'avez pas écrit le même nouveau mot de passe");
return;
}
tableAdapter.UpdateQuery(username, newPass, row["XTYPE"].ToString().Trim(), Convert.ToDecimal(row["XACTIF"]), username);
this.Close();
return;
}
errorMessage("Erreur de votre ancien mot de passe, veuillez réessayer");
return;
}
errorMessage("Votre compte à été supprimé de la base, veuillez contacter l'admin");
return;
}
this.Close();
}
private void saveAndClose()
{
Boolean isAnyEmpty = false;
ArrayList arrParam = new ArrayList();
errorMessage("");
isAnyEmpty = _Inputs.Any(x => x.Text.Equals(""));
if (isAnyEmpty)
{
errorMessage("Veuillez remplir tout les élements du formulaire");
return;
}
if (_Title.Equals("agenda"))
{
TextBox textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXDATE"));
if (!isDateValid(textBox.Text))
{
errorMessage("Date non conforme(ex:01.01.2019)");
return;
}
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXHEURE"));
if (!isHourValid(textBox.Text))
{
errorMessage("Heure non conforme (ex:08:15)");
return;
}
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXNOMCLIENT"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXTYPE"));
arrParam.Add(textBox.Text);
//insert agenda with query
DataSetISpaDataTableAdapters.VW_AGENDATableAdapter tableAdapter = new DataSetISpaDataTableAdapters.VW_AGENDATableAdapter();
int resp = tableAdapter.InsertQuery(Convert.ToDateTime(arrParam[0]), Convert.ToDateTime(arrParam[1]), arrParam[2].ToString(), arrParam[3].ToString());
Console.WriteLine(resp);
//tableAdapter.InsertQuery(Convert.ToDateTime(arrParam[0]), Convert.ToDateTime(arrParam[1]), arrParam[2].ToString(), arrParam[3].ToString());
_MotherForm.addRow(arrParam);
}
if (_Title.Equals("clients"))
{
//first_name,last_name,d.o.b,email,adresse
TextBox textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXPRENOM"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXNOM"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXDOB"));
if (!isDateValid(textBox.Text))
{
errorMessage("Date de naissance non conforme (ex:01.01.2019");
return;
}
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXEMAIL"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXADRESSE"));
arrParam.Add(textBox.Text);
//insert client with query
DataSetISpaDataTableAdapters.VW_CLIENTTableAdapter tableAdapter = new DataSetISpaDataTableAdapters.VW_CLIENTTableAdapter();
tableAdapter.InsertQuery(arrParam[0].ToString(), arrParam[1].ToString(), Convert.ToDateTime(arrParam[2]), arrParam[3].ToString(), arrParam[4].ToString());
_MotherForm.addRow(arrParam);
}
if (_Title.Equals("factures"))
{
//Date d'ouverture,ID Client,Nom Client,Type,Prix,Payé
TextBox textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXDATE"));
if (!isDateValid(textBox.Text))
{
errorMessage("Date de naissance non conforme (ex:01.01.2019)");
return;
}
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXHEURE"));
if (!isHourValid(textBox.Text))
{
errorMessage("Heure non conforme (ex:08:15)");
return;
}
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXNOMCLIENT"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXTYPE"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXPRIX"));
String val = textBox.Text;
val.Replace(',', '.');
double outDouble;
if (!double.TryParse(textBox.Text, out outDouble))
{
errorMessage("Prix non conforme (ex: 5.50)");
return;
}
val.Replace('.', ',');
arrParam.Add(val);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXPAYE"));
if (!(textBox.Text.ToLower() == "true" || textBox.Text.ToLower() == "false"))
{
errorMessage("Boolean de paiement non conforme (ex:true ou false");
return;
}
arrParam.Add(textBox.Text == "true" ? 1 : 0);
DateTime date1 = Convert.ToDateTime(arrParam[0]);
DateTime time1 = Convert.ToDateTime(arrParam[1]);
//insert factures with query
DataSetISpaDataTableAdapters.VW_FACTURETableAdapter tableAdapter = new DataSetISpaDataTableAdapters.VW_FACTURETableAdapter();
tableAdapter.InsertQuery(date1, time1, arrParam[2].ToString(), arrParam[3].ToString(), arrParam[4].ToString(), Convert.ToDecimal(arrParam[5]));
_MotherForm.addRow(arrParam);
}
if (_Title.Equals("products"))
{
//nom,description,fournisseur,prix
TextBox textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXNOM"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXDESCRIPTION"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXFOURNISSEUR"));
arrParam.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXPRIX"));
String val = textBox.Text;
val.Replace(',', '.');
double outDouble;
if (!double.TryParse(textBox.Text, out outDouble))
{
errorMessage("Prix non conforme (ex: 5.50)");
return;
}
val.Replace('.', ',');
arrParam.Add(val);
//insert product with query
DataSetISpaDataTableAdapters.VW_PRODUITTableAdapter tableAdapter = new DataSetISpaDataTableAdapters.VW_PRODUITTableAdapter();
tableAdapter.InsertQuery(arrParam[0].ToString(), arrParam[1].ToString(), arrParam[2].ToString(), arrParam[3].ToString());
_MotherForm.addRow(arrParam);
}
if (_Title.Equals("users"))
{
DataSetISpaData datas = new DataSetISpaData();
ArrayList arr = new ArrayList();
// set attributes from form
TextBox textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXNOM"));
arr.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXPASSWORD"));
arr.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXTYPE"));
arr.Add(textBox.Text);
textBox = _Inputs.Find(x => x.Name.Contains("txtBoxXACTIF"));
if (!(textBox.Text.ToLower() == "true" || textBox.Text.ToLower() == "false"))
{
errorMessage("Boolean Actif non conforme (ex:true ou false)");
return;
}
arr.Add(textBox.Text == "true" ? 1 : 0);
//insert user with query
DataSetISpaDataTableAdapters.VW_USERTableAdapter tableAdapter = new DataSetISpaDataTableAdapters.VW_USERTableAdapter();
tableAdapter.InsertQuery(arr[0].ToString(), arr[1].ToString(), arr[2].ToString(), Convert.ToDecimal(arr[3]));
//refresh current table
_MotherForm.addRow(arrParam);
}
this.Close();
}
