private void DBComboxCPFact_SelectedIndexChanged(object sender, EventArgs e) { UInt32 ID_UL; DBComboxCPFact.GetSelectedItemID(out ID_UL); DBComboxCPLibFact.SelectItemByID(ID_UL); ValueChanged(this, EventArgs.Empty); }
private void BtnSaveChanges_Click(object sender, EventArgs e) { if (mEditState_b) { UInt32 ClientID_UL = DBListViewClient.GetSelectedItemID(); //Build update request if (mDBManager_O != null && mDBManager_O.mConnected_b) { UInt32 TypeSocID_UL; UInt32 CPFactID_UL, CPLivrID_UL; UInt32 ClientNumber_UL; if (UInt32.TryParse(TxtClientNumber.Text, out ClientNumber_UL)) { // Check if client number already exists String ClientWithSameNumber_ST = mDBManager_O.GetTableField("Client", "ClientNom", "NumClientInterne='" + ClientNumber_UL + "'"); String ClientIDWithSameNumber_ST = mDBManager_O.GetTableField("Client", "ClientID", "NumClientInterne='" + ClientNumber_UL + "'"); UInt32 ClientIDWithSameNumber_UL = 0; UInt32.TryParse(ClientIDWithSameNumber_ST, out ClientIDWithSameNumber_UL); DialogResult DlgRes_O = DialogResult.Yes; if (!String.IsNullOrEmpty(TxtClientNumber.Text) && !String.IsNullOrEmpty(ClientWithSameNumber_ST) && ClientID_UL != ClientIDWithSameNumber_UL) { DlgRes_O = MessageBox.Show("Le client " + ClientWithSameNumber_ST + " existe déjà sous le numéro " + ClientNumber_UL + ". Poursuivre quand même l'enregistrement ?", "Attention", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); } if (DlgRes_O == DialogResult.Yes) { DBComboxTypeSoc.GetSelectedItemID(out TypeSocID_UL); DBComboxCPFact.GetSelectedItemID(out CPFactID_UL); DBComboxCPLivr.GetSelectedItemID(out CPLivrID_UL); List <String> Param_O = new List <String>(); List <Object> Values_O = new List <Object>(); String SqlCommand_O = @"UPDATE Client SET ClientNom=@ClientNom, NumClientInterne=@NumClientInterne, TypeSocID=@TypeSocID, NrTVA=@NrTVA, Contact=@Contact, ContactTel=@ContactTel, ContactEmail=@ContactEmail, AdresseFact=@AdresseFact, CodePostalFactID=@CodePostalFactID, AdresseLivraison=@AdresseLivraison, CodePostalLivraisonID=@CodePostalLivraisonID, ClientTel=@ClientTel, ClientFax=@ClientFax, ClientMail=@ClientMail, ClientRem=@ClientRem, NoteEnvoi=@NoteEnvoi, Certif=@Certif, RappConf=@RappConf WHERE ClientID=@ClientID"; Param_O.Add("@ClientNom"); Values_O.Add(TxtClientName.Text); Param_O.Add("@NumClientInterne"); Values_O.Add((int)ClientNumber_UL); Param_O.Add("@TypeSocID"); Values_O.Add((int)TypeSocID_UL); Param_O.Add("@NrTVA"); Values_O.Add(TxtTVA.Text); Param_O.Add("@Contact"); Values_O.Add(TxtContactName.Text); Param_O.Add("@ContactTel"); Values_O.Add(TxtContactTel.Text); Param_O.Add("@ContactEmail"); Values_O.Add(TxtContactMail.Text); Param_O.Add("@AdresseFact"); Values_O.Add(TxtAdressFact.Text); Param_O.Add("@CodePostalFactID"); Values_O.Add((int)CPFactID_UL); Param_O.Add("@AdresseLivraison"); Values_O.Add(TxtAdressLivr.Text); Param_O.Add("@CodePostalLivraisonID"); Values_O.Add((int)CPLivrID_UL); Param_O.Add("@ClientTel"); Values_O.Add(TxtTel.Text); Param_O.Add("@ClientFax"); Values_O.Add(TxtFax.Text); Param_O.Add("@ClientMail"); Values_O.Add(TxtMail.Text); Param_O.Add("@ClientRem"); Values_O.Add(TxtRem.Text); Param_O.Add("@ClientID"); Values_O.Add((int)ClientID_UL); Param_O.Add("@NoteEnvoi"); Values_O.Add(CheckBoxNE.Checked); Param_O.Add("@Certif"); Values_O.Add(CheckBoxCertif.Checked); Param_O.Add("@RappConf"); Values_O.Add(CheckBoxRappConf.Checked); mDBManager_O.ExecuteRequest(SqlCommand_O, Param_O, Values_O); SetEditState(false); DBListViewClient.SetLockState(false); DBListViewClient.Refresh(); DBListViewClient.SelectItemByID(ClientID_UL); } } else { MessageBox.Show("Impossible d'enregistrer les modifications : le numéro de client entré n'est pas un nombre valide.", "Erreur !", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void BtnSaveChanges_Click(object sender, EventArgs e) { if (mEditState_b) { UInt32 ProviderID_UL = DBListViewProvider.GetSelectedItemID(); //Build update request if (mDBManager_O != null && mDBManager_O.mConnected_b) { UInt32 TypeSocID_UL; UInt32 CPFactID_UL; // Check if provider number already exists String ProviderWithSameNumber_ST = mDBManager_O.GetTableField("Fourn", "FournNom", "NumFournInterne='" + TxtProviderNumber.Text + "'"); String ProviderIDWithSameNumber_ST = mDBManager_O.GetTableField("Fourn", "FournID", "NumFournInterne='" + TxtProviderNumber.Text + "'"); UInt32 ProviderIDWithSameNumber_UL = 0; UInt32.TryParse(ProviderIDWithSameNumber_ST, out ProviderIDWithSameNumber_UL); DialogResult DlgRes_O = DialogResult.Yes; if (!String.IsNullOrEmpty(TxtProviderNumber.Text) && !String.IsNullOrEmpty(ProviderWithSameNumber_ST) && ProviderID_UL != ProviderIDWithSameNumber_UL) { DlgRes_O = MessageBox.Show("Le fournisseur " + ProviderWithSameNumber_ST + " existe déjà sous le numéro " + TxtProviderNumber.Text + ". Poursuivre quand même l'enregistrement ?", "Attention", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); } if (DlgRes_O == DialogResult.Yes) { DBComboxTypeSoc.GetSelectedItemID(out TypeSocID_UL); DBComboxCPFact.GetSelectedItemID(out CPFactID_UL); List <String> Param_O = new List <String>(); List <Object> Values_O = new List <Object>(); String SqlCommand_O = @"UPDATE Fourn SET FournNom=@FournNom, NumFournInterne=@NumFournInterne, TypeSocID=@TypeSocID, NrTVA=@NrTVA, Contact=@Contact, ContactTel=@ContactTel, ContactEmail=@ContactEmail, Adresse=@Adresse, CodePostalID=@CodePostalID, FournTel=@FournTel, FournFax=@FournFax, FournMail=@FournMail, FournRem=@FournRem WHERE FournID=@FournID"; Param_O.Add("@FournNom"); Values_O.Add(TxtProviderName.Text); Param_O.Add("@NumFournInterne"); Values_O.Add(TxtProviderNumber.Text); Param_O.Add("@TypeSocID"); Values_O.Add((int)TypeSocID_UL); Param_O.Add("@NrTVA"); Values_O.Add(TxtTVA.Text); Param_O.Add("@Contact"); Values_O.Add(TxtContactName.Text); Param_O.Add("@ContactTel"); Values_O.Add(TxtContactTel.Text); Param_O.Add("@ContactEmail"); Values_O.Add(TxtContactMail.Text); Param_O.Add("@Adresse"); Values_O.Add(TxtAdressFact.Text); Param_O.Add("@CodePostalID"); Values_O.Add((int)CPFactID_UL); Param_O.Add("@FournTel"); Values_O.Add(TxtTel.Text); Param_O.Add("@FournFax"); Values_O.Add(TxtFax.Text); Param_O.Add("@FournMail"); Values_O.Add(TxtMail.Text); Param_O.Add("@FournRem"); Values_O.Add(TxtRem.Text); Param_O.Add("@FournID"); Values_O.Add((int)ProviderID_UL); mDBManager_O.ExecuteRequest(SqlCommand_O, Param_O, Values_O); SetEditState(false); DBListViewProvider.SetLockState(false); DBListViewProvider.Refresh(); DBListViewProvider.SelectItemByID(ProviderID_UL); } } } }