Ejemplo n.º 1
0
 private void buttonENREGISTRER_Click(object sender, EventArgs e)
 {
     this.Cursor = Cursors.WaitCursor;
     try
     {
         Application.DoEvents();
         CHMGC.RESULT_QUERY res = CLIENT_APP_PARAM.gcws.ENREGISTRER("1", dt);
         if (res.OK)
         {
             MessageBox.Show(res.MESSAGE, "Enregistrement", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
         else
         {
             MessageBox.Show(res.MESSAGE, "Enregistrement", MessageBoxButtons.OK, MessageBoxIcon.Error);
         }
     }
     catch (Exception er)
     {
         MessageBox.Show(er.Message, "Connexion serveur", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
     finally
     {
         this.Cursor = Cursors.Default;
     }
 }
Ejemplo n.º 2
0
        private void BTN_ENREGISTRER_Click(object sender, EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;
            try
            {
                Application.DoEvents();
                CHMGC.RESULT_QUERY res = CLIENT_APP_PARAM.gcws.INSERT_FACTURE_CLIENT(DATE_FACTURE.Value, CODE_CLIENT, HT.Value, TVA.Value, TTC.Value,
                                                                                     TAUX_REMISE.Value, TTC.Value, TIMBRE.Value, NP.Value, ML.Text, false, "Non reglée", TTC.Value, Convert.ToDecimal(CODE_MAG),
                                                                                     Convert.ToDecimal(CLIENT_APP_PARAM.Fenetre_principale.code_user), CLIENT_APP_PARAM.Fenetre_principale.prenom_user,
                                                                                     CLIENT_APP_PARAM.Fenetre_principale.nom_user, REMARQUE, dt_lg_b_liv);
                if (res.OK)
                {
                    CODE_FACTURE.Text = res.CODE;
                    MessageBox.Show(res.MESSAGE, "INVOICE SAVE", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    BTN_ENREGISTRER.Enabled = false;
                }
                else
                {
                    MessageBox.Show(res.MESSAGE, "Attention", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            catch (Exception er)
            {
                MessageBox.Show(er.Message, "Connexion serveur", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
            foreach (DataRowView dr in bs_b_liv_selectionne)
            {
                //CLIENT_APP_PARAM.GEST.P_BON_LIVRAISON.UPDATE_FACTURE(dr["CODE_B_LIV"].ToString(), true);
                CLIENT_APP_PARAM.gcws.UPDATE_FACTURE(dr["CODE_B_LIV"].ToString(), true);
                //CLIENT_APP_PARAM.GEST.P_FACTURE.FACTURATION(CODE_FACTURE.Text, dr["CODE_B_LIV"].ToString(), DATE_FACTURE.Value);
                CLIENT_APP_PARAM.gcws.FACTURATION_CLIENT(CODE_FACTURE.Text, dr["CODE_B_LIV"].ToString(), DATE_FACTURE.Value);
                REMARQUE += dr["CODE_B_LIV"].ToString() + "   //  ";
            }
            remarq.Text           = "Remarque : " + REMARQUE;
            BTN_REGLEMENT.Enabled = true;
            BTN_APERçU.Enabled    = true;
            CHM_FICHE_FACTURE_CLIENT f = new CHM_FICHE_FACTURE_CLIENT(CODE_FACTURE.Text);

            f.MdiParent = CLIENT_APP_PARAM.Fenetre_principale;
            f.Show();
        }
Ejemplo n.º 3
0
        private void buttonENREGISTRER_Click(object sender, EventArgs e)
        {
            errorProvider1.SetError(RS_CLIENT, "");
            if (CODE_CLIENT == "-1")
            {
                REF_CLIENT.Focus();
                errorProvider1.SetError(RS_CLIENT, "Sélectionner le client. ");
                RS_CLIENT.Text = "Sélectionner le client. ";
                return;
            }
            if (MessageBox.Show("Etes sûres d'enregistrer la commande?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
            {
                this.Cursor = Cursors.WaitCursor;
                try
                {
                    Application.DoEvents();
                    //CHM_GESTION_COMERCIALE.RESULT_QUERY res = CLIENT_APP_PARAM.GEST.P_COMMANDE.SAVE(CODE_CLIENT, DATE_COMMANDE.Value, PRIORITE_COMMANDE.Checked, (PRIORITE_COMMANDE.Checked == true) ? DATE_EXPIRATION_COMMANDE.Value : (object)null, CLIENT_APP_PARAM.Fenetre_principale.code_user.ToString(), false , dt_lg_commande);
                    CHMGC.RESULT_QUERY res = CLIENT_APP_PARAM.gcws.SAVE_COMMANDE_CLIENT(CODE_CLIENT, DATE_COMMANDE.Value, PRIORITE_COMMANDE.Checked, (PRIORITE_COMMANDE.Checked == true) ? DATE_EXPIRATION_COMMANDE.Value : (object)null, CLIENT_APP_PARAM.Fenetre_principale.code_user.ToString(), false, dt_lg_commande);
                    if (res.OK)
                    {
                        CODE_COMMANDE.Text = res.CODE;
                        MessageBox.Show(res.MESSAGE, "Enregistrement", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        buttonENREGISTRER.Enabled = false;
                    }
                    else
                    {
                        MessageBox.Show(res.MESSAGE, "Attention", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                }
                catch (Exception er)
                {
                    MessageBox.Show(er.Message, "Connexion serveur", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }

                finally
                {
                    this.Cursor = Cursors.Default;
                }
            }
        }
Ejemplo n.º 4
0
 private void dataGridView1_RowValidating(object sender, DataGridViewCellCancelEventArgs e)
 {
     if (_bs_inventaire.Current != null)
     {
         try
         {
             DataRowView drv = (DataRowView)_bs_inventaire.Current;
             //CHM_GESTION_COMERCIALE.RESULT_QUERY res = CLIENT_APP_PARAM.GEST.P_INVENTAIRE.ENREGISTRER_LIGNE_INVENTAIRE(_code_inventaire, (decimal)drv["CODE_ARTICLE"], (decimal)drv["QTE_INVENTAIRE"]);
             CHMGC.RESULT_QUERY res = CLIENT_APP_PARAM.gcws.ENREGISTRER_LIGNE_INVENTAIRE(_code_inventaire, (decimal)drv["CODE_ARTICLE"], (decimal)drv["QTE_INVENTAIRE"]);
             if (!res.OK)
             {
                 MessageBox.Show("Enregistré avec succès.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
                 _bs_inventaire.Position = _bs_inventaire.Find("CODE_BARRE_ARTICLE", (decimal)drv["CODE_ARTICLE"]);
                 return;
             }
         }
         catch (Exception er)
         {
             MessageBox.Show(er.Message, this.Text);
         }
     }
 }
Ejemplo n.º 5
0
 private void BTN_AJOUTER_Click(object sender, EventArgs e)
 {
     try
     {
         CHMGC.RESULT_QUERY res = CLIENT_APP_PARAM.gcws.VERIFIER_INVENTAIRE_MAGAZIN(Convert.ToDecimal(CLIENT_APP_PARAM.CODE_MAG));
         if (res.OK)
         {
             CHM_FICHE_COMMANDE cmd = new CHM_FICHE_COMMANDE("-1");
             cmd.WindowState = FormWindowState.Maximized;
             cmd.RightToLeft = RightToLeft.No;
             cmd.MdiParent   = CLIENT_APP_PARAM.Fenetre_principale;
             cmd.Show();
         }
         else
         {
             MessageBox.Show("Magasin encours d'inventaire.", this.Text);
         }
     }
     catch (Exception er)
     {
         MessageBox.Show(er.Message);
     }
 }
Ejemplo n.º 6
0
        private void btn_annuler_Click_1(object sender, EventArgs e)
        {
            try
            {
                if (_bs_liste_br_fr.Current != null)
                {
                    DataRowView drv = (DataRowView)_bs_liste_br_fr.Current;

                    //if (DateTime.Now <= Convert.ToDateTime(drv["DATE_BR_FR"]).AddHours(1))
                    //{
                    //CHM_GESTION_COMERCIALE.RESULT_QUERY res = CLIENT_APP_PARAM.GEST.P_BR_FR.DELETE_BR_FR((decimal)drv["CODE_BRECEP"]);
                    CHMGC.RESULT_QUERY res = CLIENT_APP_PARAM.gcws.DELETE_BR_FR((decimal)drv["CODE_BRECEP"]);
                    if (res.OK)
                    {
                        //_dt_liste_br_fr = CLIENT_APP_PARAM.GEST.P_BR_FR.SELECT_ALL_BR_FR();
                        _dt_liste_br_fr            = CLIENT_APP_PARAM.gcws.SELECT_ALL_BR_FR();
                        _bs_liste_br_fr.DataSource = _dt_liste_br_fr;
                        dgv_liste.DataSource       = _bs_liste_br_fr;
                        calcul_total();
                        MessageBox.Show(res.MESSAGE, this.Text);
                    }
                    else
                    {
                        MessageBox.Show(res.MESSAGE, "Error");
                    }
                    //}
                    //else
                    //{
                    //    MessageBox.Show("áÞÏ ÊÌÇæÒÊ ÃßËÑ ãä ÓÇÚÉ ãäÐ ÅÏÎÇá ÅÐä ÇáÅÓÊáÇã. áÇ íãßä ÅÌÑÇÁ ÇáÊÚÏíá.", this.Text);
                    //}
                }
            }
            catch (Exception er)
            {
                MessageBox.Show(er.Message);
            }
        }
Ejemplo n.º 7
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         CHMGC.RESULT_QUERY res = CLIENT_APP_PARAM.gcws.VERIFIER_INVENTAIRE_MAGAZIN(Convert.ToDecimal(CLIENT_APP_PARAM.CODE_MAG));
         if (res.OK)
         {
             BON_RECEPTION.CHM_FRM_BR_FOURNISSEUR f = new CHM_FRM_BR_FOURNISSEUR(-1);
             f.WindowState = FormWindowState.Normal;
             //f.MdiParent = CLIENT_APP_PARAM.Fenetre_principale;
             f.OnSave += new CHM_FRM_BR_FOURNISSEUR.EnregistrementBR(f_OnSave);
             f.Show();
             //_dt_liste_br_fr = CLIENT_APP_PARAM.GEST.P_BR_FR.SELECT_ALL_BR_FR();
         }
         else
         {
             MessageBox.Show("Magasin encours d'inventaire.", this.Text);
         }
     }
     catch (Exception er)
     {
         MessageBox.Show(er.Message, this.Text);
     }
 }
Ejemplo n.º 8
0
        private void BTN_ENREGISTRER_Click(object sender, EventArgs e)
        {
            #region Verification des champs
            if (xtraTabControl1.SelectedTabPageIndex == 0 && RS_CLIENT.Text == string.Empty)
            {
                MessageBox.Show("Veuillez sélectionner le client!", this.Text);
                return;
            }
            #endregion
            if (dS_MOUV1.LIGNE_FACTURE.Rows.Count > 0 && MessageBox.Show("Etes vous sûres d'enregistrer la facture?", "Enregistrement facture", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
            {
                this.Cursor = Cursors.WaitCursor;
                try
                {
                    DataTable dtDetailsFc = new DataTable("dtDetailsFc");
                    foreach (DataColumn c in dS_MOUV1.LIGNE_FACTURE.Columns)
                    {
                        DataColumn col = new DataColumn(c.ColumnName, c.DataType);
                        dtDetailsFc.Columns.Add(col);
                    }

                    foreach (DataRow dr in dS_MOUV1.LIGNE_FACTURE.Rows)
                    {
                        dtDetailsFc.ImportRow(dr);
                    }

                    Application.DoEvents();
                    string[] bl = new string[bl_facture.Count];
                    for (int i = 0; i < bl_facture.Count; i++)
                    {
                        bl[i] = bl_facture[i];
                    }
                    //CHM_GESTION_COMERCIALE.RESULT_QUERY res = CLIENT_APP_PARAM.GEST.P_FACTURE.INSERT_FACTURE(DATE_FACTURE.Value, CODE_CLIENT, HT.Text, TVA.Value.ToString(), TTC.Value.ToString(), TAUX_REMISE.Value.ToString(), TTC.Value.ToString(), TIMBRE.Value.ToString(), NP.Value.ToString(), ML.Text, false, "Non reglée", TTC.Value.ToString(), CODE_MAG, CLIENT_APP_PARAM.Fenetre_principale.code_user, CLIENT_APP_PARAM.Fenetre_principale.prenom_user, CLIENT_APP_PARAM.Fenetre_principale.nom_user, REMARQUE, dt_lg_b_liv);

                    decimal credit = TIMBRE.Value;
                    foreach (DataRow dr in dS_MOUV1.V_PIECE_CLIENT_SANS_FACTURE.Rows)
                    {
                        if (dr["CHECKED"].ToString() == "True")
                        {
                            credit += (decimal)dr["RESTE_NP"];
                        }
                    }

                    CHMGC.RESULT_QUERY res = CLIENT_APP_PARAM.gcws.INSERT_FACTURE_CLIENT(DATE_FACTURE.Value, CODE_CLIENT.ToString(), HT.Value, TVA.Value, TTC.Value, TAUX_REMISE.Value, TTC.Value, TIMBRE.Value, NP.Value, ML.Text, false, "Non reglée", credit, CODE_MAG, Convert.ToDecimal(CLIENT_APP_PARAM.Fenetre_principale.code_user), CLIENT_APP_PARAM.Fenetre_principale.prenom_user, CLIENT_APP_PARAM.Fenetre_principale.nom_user, REMARQUE, dtDetailsFc, bl);
                    if (res.OK)
                    {
                        CODE_FACTURE.Text = res.CODE;
                        MessageBox.Show(res.MESSAGE, "Enregistrement de facture.", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        chM_CMP_VALIDATION1.button1.Enabled = false;

                        if (MessageBox.Show("Voulez vous imprimer la facture?", "Impression", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
                        {
                            try
                            {
                                this.Cursor = Cursors.WaitCursor;
                                ReportDocument rpt = new CHM_RPT_FACTURE();
                                rpt.SetDataSource(CLIENT_APP_PARAM.gcws.Imprimer_FACTURE_CLIENT(res.CODE));
                                rpt.SetParameterValue("entete", CLIENT_APP_PARAM.entete);
                                rpt.PrintOptions.PrinterName = CLIENT_APP_PARAM.ReportPrinter;
                                rpt.PrintToPrinter(1, true, 0, 0);
                                this.Cursor = Cursors.Default;
                            }
                            catch (Exception print_er)
                            {
                                MessageBox.Show(print_er.Message, "Problème Impression", MessageBoxButtons.OK, MessageBoxIcon.Error);
                            }
                            finally
                            {
                                this.Cursor = Cursors.Default;
                            }
                        }
                        if (OnSave != null)
                        {
                            OnSave(res.CODE);
                        }
                        Close();
                    }
                    else
                    {
                        MessageBox.Show(res.MESSAGE, "Attention", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                }
                catch (Exception er)
                {
                    MessageBox.Show(er.Message, "Connexion serveur", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                finally
                {
                    this.Cursor = Cursors.Default;
                }
            }
            else
            {
                MessageBox.Show("Rien à facturer!", "Enregistrement facture", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }
Ejemplo n.º 9
0
        private void BTN_ENREGISTRER_Click(object sender, EventArgs e)
        {
            if (dataSet11.LG_BON_LIVRAISON.Rows.Count > 0)
            {
                if (MessageBox.Show("Etes vous sur d'enregistrer le bon de livraison?", "Vaalidation enregistrement", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
                {
                    this.Cursor = Cursors.WaitCursor;
                    try
                    {
                        Application.DoEvents();
                        CODE_CMD = "";
                        foreach (DataRow dr in dataSet11.LG_BON_LIVRAISON.Rows)
                        {
                            if (dr["CODE_COMMANDE"].ToString() != "" && !CODE_CMD.Contains(dr["CODE_COMMANDE"].ToString()))
                            {
                                CODE_CMD += dr["CODE_COMMANDE"].ToString();
                            }
                        }
                        //CHM_GESTION_COMERCIALE.RESULT_QUERY res = CLIENT_APP_PARAM.GEST.P_BON_LIVRAISON.SAVE(DATE_B_LIV.Value, CODE_CLIENT, CODE_CMD, CLIENT_APP_PARAM.Fenetre_principale.code_user, dt_lg_b_liv_prepare);
                        dt_lg_b_liv_prepare.Clear();
                        foreach (DataRow dr in dataSet11.LG_BON_LIVRAISON.Rows)
                        {
                            DataRow drDet = dt_lg_b_liv_prepare.NewRow();
                            drDet.BeginEdit();
                            drDet["CODE_ARTICLE"]        = dr["CODE_ARTICLE"];
                            drDet["REF_ARTICLE"]         = dr["REF_ARTICLE"];
                            drDet["DESIGNATION_ARTICLE"] = dr["DESIGNATION_ARTICLE"];
                            drDet["QTE_LIGNE_B_LIV"]     = dr["QTE_LIGNE_B_LIV"];
                            drDet["PRIX_HT_B_LIV"]       = dr["PRIX_HT_B_LIV"];
                            drDet["PRIX_TOTAL_HT"]       = dr["PRIX_TOTAL_HT"];
                            drDet["REMISE"]         = dr["REMISE"];
                            drDet["TVA_B_LIV"]      = dr["TVA_B_LIV"];
                            drDet["PRIX_U_TTC"]     = dr["PRIX_U_TTC"];
                            drDet["PRIX_TOTAL_TTC"] = dr["PRIX_TOTAL_TTC"];
                            drDet["CODE_COMMANDE"]  = dr["CODE_COMMANDE"];
                            drDet["QTTE_STOCK"]     = dr["QTTE_STOCK"];
                            drDet["MAX_REMISE"]     = dr["MAX_REMISE"];
                            drDet.EndEdit();


                            dt_lg_b_liv_prepare.Rows.Add(drDet);
                            dt_lg_b_liv_prepare.AcceptChanges();
                        }
                        CHMGC.RESULT_QUERY res = CLIENT_APP_PARAM.gcws.SAVE(DATE_B_LIV.Value, CODE_CLIENT, CODE_CMD, Convert.ToDecimal(cbx_magasin.SelectedValue), CLIENT_APP_PARAM.Fenetre_principale.code_user, dt_lg_b_liv_prepare, NUM_FI.ToArray());
                        if (res.OK)
                        {
                            CODE_B_LIV.Text = res.CODE;
                            MessageBox.Show(res.MESSAGE, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
                            chM_CMP_VALIDATION1.button1.Enabled = false;
                            this.Cursor = Cursors.Default;
                            if (MessageBox.Show("Voulez vous imprimer le bon de livraison?", "Impression", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
                            {
                                this.Cursor = Cursors.WaitCursor;
                                DataTable dt             = CLIENT_APP_PARAM.gcws.Imprimer_BL(res.CODE);
                                decimal   montant_ht     = 0;
                                decimal   montant_remise = 0;
                                decimal   montant_TVA    = 0;
                                decimal   montant_TTC    = 0;
                                foreach (DataRow dr in dt.Rows)
                                {
                                    montant_ht     += (decimal)dr["PRIX_HT_B_LIV"] * (decimal)dr["QTE_LIGNE_B_LIV"];
                                    montant_remise += (decimal)dr["PRIX_HT_B_LIV"] * (decimal)dr["REMISE"] / 100 * (decimal)dr["QTE_LIGNE_B_LIV"];
                                    montant_TVA    += ((decimal)dr["PRIX_HT_B_LIV"] - (decimal)dr["PRIX_HT_B_LIV"] * (decimal)dr["REMISE"] / 100) * (decimal)dr["TVA_B_LIV"] / 100 * (decimal)dr["QTE_LIGNE_B_LIV"];
                                }
                                montant_TTC = montant_ht - montant_remise + montant_TVA;

                                RPT_B_LIV rpt = new RPT_B_LIV();
                                rpt.SetDataSource(dt);
                                rpt.SetParameterValue("mnt_HT", montant_ht);
                                rpt.SetParameterValue("Total_Remise", montant_remise);
                                rpt.SetParameterValue("Total_TVA", montant_TVA);
                                rpt.SetParameterValue("Montant_TTC", montant_TTC);
                                rpt.SetParameterValue("entete", CLIENT_APP_PARAM.entete);
                                rpt.PrintOptions.PrinterName = CLIENT_APP_PARAM.ReportPrinter;
                                rpt.PrintToPrinter(1, true, 0, 0);
                                this.Cursor = Cursors.Default;
                            }

                            Close();
                        }
                        else
                        {
                            MessageBox.Show(res.MESSAGE, "Attention", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                            return;
                        }
                    }
                    catch (Exception er)
                    {
                        MessageBox.Show(er.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    finally
                    {
                        this.Cursor = Cursors.Default;
                    }
                }
            }
            else
            {
                MessageBox.Show("Bon de livraison vide, veuillez insérer les articles!");
            }
        }
Ejemplo n.º 10
0
        private void buttonENREGISTRER_Click(object sender, EventArgs e)
        {
            #region Validation des champs
            errorProvider1.SetError(txt_fournisseur, "");
            {
                if (txt_fournisseur.Text.Trim() == "")
                {
                    errorProvider1.SetError(button2, "Saisir Fournisseur!");
                    button2.Focus();
                    return;
                }
            }

            errorProvider1.SetError(cbx_magazin, "");
            {
                if (cbx_magazin.SelectedValue == null)
                {
                    errorProvider1.SetError(cbx_magazin, "Sélectionner le Magasin!");
                    cbx_magazin.Focus();
                    return;
                }
            }

            errorProvider1.SetError(txt_NUM_ORDER, "");
            {
                if (txt_NUM_ORDER.Text.Trim() == "")
                {
                    errorProvider1.SetError(txt_NUM_ORDER, "N° de BL Fournisseur manquant!");
                    txt_NUM_ORDER.Focus();
                    txt_NUM_ORDER.Select();
                    return;
                }
            }

            errorProvider1.SetError(gridControl1, "");
            {
                if (dS_MOUV1.LG_BR_FR.Rows.Count == 0)
                {
                    errorProvider1.SetError(gridControl1, "Rien à enregistrer");
                    return;
                }
            }
            #endregion

            if (MessageBox.Show("Etes vous sûres d'enregistrer le bon de réception?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
            {
                _dt_details_br = new DataTable("dtDetails");
                foreach (DataColumn c in dS_MOUV1.LG_BR_FR.Columns)
                {
                    DataColumn newCol = new DataColumn();
                    newCol.ColumnName = c.ColumnName;
                    newCol.DataType   = c.DataType;

                    _dt_details_br.Columns.Add(newCol);
                }

                foreach (DataRow dr in dS_MOUV1.LG_BR_FR.Rows)
                {
                    _dt_details_br.ImportRow(dr);
                }
                if (_CODE_BRECEP == -1)
                {
                    try
                    {
                        Cursor = Cursors.WaitCursor;
                        Application.DoEvents();
                        //CHM_GESTION_COMERCIALE.RESULT_QUERY res = CLIENT_APP_PARAM.GEST.P_BR_FR.INSERT_BR_FR(txt_NUM_ORDER.Text, _code_fournisseur, (decimal)cbx_magazin.SelectedValue, dateTimePicker1.Value, Convert.ToDecimal(CLIENT_APP_PARAM.Fenetre_principale.code_user), NP.Value, nud_pourcentage_remise.Value, _dt_details_br);
                        CHMGC.RESULT_QUERY res = CLIENT_APP_PARAM.gcws.INSERT_BR_FR(txt_NUM_ORDER.Text, _code_fournisseur, (decimal)cbx_magazin.SelectedValue, dateTimePicker1.Value, Convert.ToDecimal(CLIENT_APP_PARAM.Fenetre_principale.code_user), lb_MNT_HT.Value, nud_pourcentage_remise.Value, _dt_details_br);
                        if (res.OK)
                        {
                            MessageBox.Show(res.MESSAGE, "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            buttonENREGISTRER.Enabled = false;
                            if (OnSave != null)
                            {
                                OnSave(_CODE_BRECEP);
                            }

                            if (MessageBox.Show("Vouler vous visualiser le bon de réception?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
                            {
                                ReportDocument rpt = new BON_RECEPTION.RPT_BR_FR();
                                //DataTable dt = CLIENT_APP_PARAM.GEST.P_BR_FR.IMPRIMER_BRECEP_FR(Convert.ToDecimal(res.CODE));
                                DataTable dt = CLIENT_APP_PARAM.gcws.IMPRIMER_BRECEP_FR(Convert.ToDecimal(res.CODE));
                                rpt.SetDataSource(dt);

                                CHM_ETATS f = new CHM_ETATS();
                                f.CHM_Aperçu_document.ReportSource = rpt;
                                f.MdiParent = CLIENT_APP_PARAM.Fenetre_principale;
                                f.Show();
                            }


                            Close();
                        }
                        else
                        {
                            MessageBox.Show(res.MESSAGE, "Attention", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                    }
                    catch (Exception er)
                    {
                        MessageBox.Show(er.Message, "Connection error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }

                    finally
                    {
                        this.Cursor = Cursors.Default;
                    }
                }
                else
                {
                    try
                    {
                        Cursor = Cursors.WaitCursor;
                        Application.DoEvents();
                        //CHM_GESTION_COMERCIALE.RESULT_QUERY res = CLIENT_APP_PARAM.GEST.P_BR_FR.UPDATE_BR_FR(_CODE_BRECEP, txt_NUM_ORDER.Text, _code_fournisseur, (decimal)cbx_magazin.SelectedValue, dateTimePicker1.Value, Convert.ToDecimal(CLIENT_APP_PARAM.Fenetre_principale.code_user), NP.Value, nud_pourcentage_remise.Value, _dt_details_br);
                        CHMGC.RESULT_QUERY res = CLIENT_APP_PARAM.gcws.UPDATE_BR_FR(_CODE_BRECEP, txt_NUM_ORDER.Text, _code_fournisseur, (decimal)cbx_magazin.SelectedValue, dateTimePicker1.Value, Convert.ToDecimal(CLIENT_APP_PARAM.Fenetre_principale.code_user), lb_MNT_HT.Value, nud_pourcentage_remise.Value, _dt_details_br);
                        if (res.OK)
                        {
                            MessageBox.Show(res.MESSAGE, "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            buttonENREGISTRER.Enabled = false;
                            ReportDocument rpt = new BON_RECEPTION.RPT_BR_FR();
                            //DataTable dt = CLIENT_APP_PARAM.GEST.P_BR_FR.IMPRIMER_BRECEP_FR(Convert.ToDecimal(res.CODE));
                            DataTable dt = CLIENT_APP_PARAM.gcws.IMPRIMER_BRECEP_FR(Convert.ToDecimal(res.CODE));
                            rpt.SetDataSource(dt);

                            CHM_ETATS f = new CHM_ETATS();
                            f.CHM_Aperçu_document.ReportSource = rpt;
                            f.MdiParent = CLIENT_APP_PARAM.Fenetre_principale;
                            f.Show();
                            Close();
                        }
                        else
                        {
                            MessageBox.Show(res.MESSAGE, "Attention", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                    }
                    catch (Exception er)
                    {
                        MessageBox.Show(er.Message, "Connection error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }

                    finally
                    {
                        this.Cursor = Cursors.Default;
                    }
                }
            }
        }