public bool editCreditBoss(clsmvt mvt) { try{ InitializeConnection(); string q = "update mouvement set voirBoss=@voirBoss, date_mvt=date_Format(Now(), '%Y-%m-%d') where id=@id"; cmd = new MySqlCommand(q, con); cmd.Parameters.Add(new MySqlParameter("@id", mvt.Id)); cmd.Parameters.Add(new MySqlParameter("@voirBoss", mvt.VoirBoss)); DialogResult result = MessageBox.Show("Voulez-vous vraiment passer cette operation ?", "PAIEMENT CREDIT", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Paiement credit Boss effecté"); } else { return(false); } } }catch (Exception ex) { MessageBox.Show("Une erreur s'est produite lors du traitement de l'operation /n" + ex.Message); } return(true); }
private void simpleButton1_Click(object sender, EventArgs e) { if (lbID.Text == "0") { MessageBox.Show("Vous devez selectionner un credit dans la liste"); } else { if (int.Parse(txtpaie.Text) > int.Parse(lbmontant.Text)) { MessageBox.Show("Le montant a payé ne peut pas depasser le montant de credit"); } else { //mofidication mvt clsmvt mvt = new clsmvt(); int montantavant = int.Parse(lbmontant.Text); int montantapres = montantavant - (int.Parse(txtpaie.Text)); mvt.VoirBoss = "" + montantapres; mvt.Id = int.Parse(lbID.Text); glossaire.Instance.editCreditBoss(mvt); lbdesign.Text = ""; lbdate.Text = ""; lbID.Text = "0"; lbmontant.Text = ""; txtpaie.Text = ""; glossaire.Instance.GetDataTableBoss(gridControl1); } } }
public Boolean InsertMvt(clsmvt mvt) { try { InitializeConnection(); string q = "insert into mouvement(ref_art,libeleMvt,typeMvt,nbrpieces,prix_gros,prix_u,totalpaie,typepaie,ref_client,ref_agent,voirBoss) values(@ref_art,@libeleMvt,@typeMvt,@nbrpieces,@prix_gros,@prix_u,@totalpaie,@typepaie,@ref_client,@ref_agent,@voirBoss)"; cmd = new MySqlCommand(q, con); cmd.Parameters.Add(new MySqlParameter("@ref_art", mvt.Ref_art)); cmd.Parameters.Add(new MySqlParameter("@libeleMvt", mvt.Lblmvt)); cmd.Parameters.Add(new MySqlParameter("@typeMvt", mvt.Typemvt)); cmd.Parameters.Add(new MySqlParameter("@nbrpieces", mvt.Nbpieces)); cmd.Parameters.Add(new MySqlParameter("@prix_gros", mvt.Prix_gro)); cmd.Parameters.Add(new MySqlParameter("@prix_u", mvt.Prix_U)); cmd.Parameters.Add(new MySqlParameter("@totalpaie", mvt.Totalpaie)); cmd.Parameters.Add(new MySqlParameter("@typepaie", mvt.Typepaie)); cmd.Parameters.Add(new MySqlParameter("@ref_client", mvt.Ref_cl)); cmd.Parameters.Add(new MySqlParameter("@ref_agent", mvt.Ref_agent)); cmd.Parameters.Add(new MySqlParameter("@voirBoss", mvt.VoirBoss)); DialogResult result = MessageBox.Show("Voulez-vous vraiment passer cette vente ?", "VENTE", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { if (cmd.ExecuteNonQuery() == 1) { clsArticle ar = new clsArticle(); ar.CodeArt = mvt.Ref_art; //MessageBox.Show("" + ar.CodeArt); updateStock(ar, mvt.Nbpieces); if (mvt.Typepaie == "Credit") { clsCredit cr = new clsCredit(); cr.Ref_cl = mvt.Ref_cl; cr.Ref_Art = mvt.Ref_art; cr.Qte = mvt.Nbpieces; cr.Montant = mvt.Totalpaie; insertCredit(cr); } return(true); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { cmd.Dispose(); con.Close(); } return(false); }
public bool syncroMvt(clsmvt mvt) { try { InitializeConnectionReplique(); string q = "insert into mouvement(ref_art,libeleMvt,typeMvt,nbrpieces,prix_gros,prix_u,totalpaie,typepaie,ref_client,ref_agent,voirBoss) values(@ref_art,@libeleMvt,@typeMvt,@nbrpieces,@prix_gros,@prix_u,@totalpaie,@typepaie,@ref_client,@ref_agent,@voirBoss)"; cmd = new MySqlCommand(q, con); cmd.Parameters.Add(new MySqlParameter("@ref_art", mvt.Ref_art)); cmd.Parameters.Add(new MySqlParameter("@libeleMvt", mvt.Lblmvt)); cmd.Parameters.Add(new MySqlParameter("@typeMvt", mvt.Typemvt)); cmd.Parameters.Add(new MySqlParameter("@nbrpieces", mvt.Nbpieces)); cmd.Parameters.Add(new MySqlParameter("@prix_gros", mvt.Prix_gro)); cmd.Parameters.Add(new MySqlParameter("@prix_u", mvt.Prix_U)); cmd.Parameters.Add(new MySqlParameter("@totalpaie", mvt.Totalpaie)); cmd.Parameters.Add(new MySqlParameter("@typepaie", mvt.Typepaie)); cmd.Parameters.Add(new MySqlParameter("@ref_client", mvt.Ref_cl)); cmd.Parameters.Add(new MySqlParameter("@ref_agent", mvt.Ref_agent)); cmd.Parameters.Add(new MySqlParameter("@voirBoss", mvt.VoirBoss)); if (cmd.ExecuteNonQuery() == 1) { //clsArticle ar = new clsArticle(); //ar.CodeArt = mvt.Ref_art; ////MessageBox.Show("" + ar.CodeArt); //updateStock(ar, mvt.Nbpieces); //if (mvt.Typepaie == "Credit") //{ // clsCredit cr = new clsCredit(); // cr.Ref_cl = mvt.Ref_cl; // cr.Ref_Art = mvt.Ref_art; // cr.Qte = mvt.Nbpieces; // cr.Montant = mvt.Totalpaie; // insertCredit(cr); //} return(true); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { cmd.Dispose(); con.Close(); } return(false); }
private void simpleButton1_Click(object sender, EventArgs e) { if (cbTypePaie.Text == "Liquide") { typepair = "Liquide"; txtCreditBoss.Text = ""; } else if (cbTypePaie.Text == "Credit") { typepair = "Credit"; txtCreditBoss.Text = ""; } else if (cbTypePaie.Text == "Liquide avec credit Boss") { typepair = "Liquide avec credit Boss"; } if (comboBox1.Text == "En gros") { typemvt = "En gros"; lbtotal.Text = "" + float.Parse(txtnbpiece.Text) * float.Parse(lbprixg.Text); } else if (comboBox1.Text == "Detail") { typemvt = "Detail"; lbtotal.Text = "" + float.Parse(txtnbpiece.Text) * float.Parse(lbprixd.Text); } else { MessageBox.Show("Completer tous les champs!!"); } if (int.Parse(lbqte.Text) < int.Parse(txtnbpiece.Text) || cbTypePaie.Text == "") { MessageBox.Show("Impossible de continuer cette operation \n stock insuffisant pour cet article!! \n verifier type de paiement \n ou type de mouvement"); } else { if (lbcode.Text == "" || lbdesign.Text == "" || lbprixd.Text == "" || lbprixd.Text == "" || lbprixg.Text == "" || lbtotal.Text == "" || txtnbpiece.Text == "") { MessageBox.Show("Operation impossible les champs sont vides"); } else { clsmvt mvt = new clsmvt(); mvt.Ref_art = lbcode.Text; mvt.Ref_cl = txtcodecl.Text; mvt.Lblmvt = lbdesign.Text; mvt.Nbpieces = txtnbpiece.Text; mvt.Prix_gro = lbprixg.Text; mvt.Prix_U = lbprixd.Text; mvt.Totalpaie = lbtotal.Text; mvt.Typemvt = typemvt; mvt.Typepaie = typepair; mvt.Ref_agent = label17.Text; mvt.VoirBoss = txtCreditBoss.Text; if (glos.InsertMvt(mvt) == true) { try { facture j = new facture(); j.DataSource = glossaire.Instance.sortieFacture(mvt.Ref_art); ReportPrintTool printTool = new ReportPrintTool(j); printTool.ShowPreviewDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } glos.GetDatas(gridControl1, "code_art,designation,nbpieces,fss,provenance,prix_u,prix_gros", "article"); lbtotal.Text = "00.0"; lbcode.Text = ""; lbdesign.Text = ""; lbprixd.Text = ""; lbprixg.Text = ""; lbqte.Text = ""; txtnbpiece.Text = ""; txtcodecl.Enabled = true; } } }