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(); }