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