fenetre du vente
unknown
apex
4 years ago
19 kB
3
Indexable
using System;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data;
namespace GestionDeSctock1.Forms
{
public partial class addvente : MetroFramework.Forms.MetroForm
{
public addvente(string message)
{
InitializeComponent();
client.Text = message;
}
SqlConnection cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=gestion2;Integrated Security=True;");
SqlCommand cmd;
SqlCommand cmd1;
SqlCommand cmd2;
SqlCommand cmd4;
SqlCommand cmd3;
SqlCommand cmd5;
SqlCommand cmd6;
SqlDataAdapter da;
DataTable dt = new DataTable();
private void addvente_Load(object sender, EventArgs e)
{
select();
}
//select product
public void select()
{
dt.Clear();
da = new SqlDataAdapter(@"SELECT [id]
,[Désignation]
,[Qté_initiale] as [Qté initiale]
,[Poids_dunité] as [Poids d'unité]
,[Prix_de_production] as [Prix de production]
,[Prix_Vente_Détail] as [Prix vente détail]
,[Prix_Vente_Gros] as [Prix vente gros]
FROM [dbo].[produitFinal]", cn);
da.Fill(dt);
this.metroGrid1.DataSource = dt;
}
// calculattion
public void calcul()
{
if (remise.Text != "" && puv.Text == "" && Qte.Text != "")
{
int qte = int.Parse(Qte.Text);
int puuv = 0;
int remis = int.Parse(remise.Text);
int stock = int.Parse(prixprodstock.Text);
int vers = int.Parse(versement.Text);
int res;
res = (qte * puuv) - remis;
int rend;
rend = res - vers;
int bef = res - (stock * qte);
int berf = (bef * 100) / res;
resultat.Text = Convert.ToString(res);
benefis.Text = Convert.ToString(bef);
benpercent.Text = Convert.ToString(berf);
rendu.Text = Convert.ToString(rend);
}
if (remise.Text == "" && puv.Text != "" && Qte.Text != "")
{
int qte = int.Parse(Qte.Text);
int puuv = int.Parse(puv.Text);
int remis = 0;
int stock = int.Parse(prixprodstock.Text);
if (versement.Text == "")
{
int res;
res = (qte * puuv) - remis;
resultat.Text = Convert.ToString(res);
}
else
{
int res;
res = (qte * puuv) - remis;
int vers = int.Parse(versement.Text);
int rend;
rend = res - vers;
int bef = res - (stock * qte);
int berf = (bef * 100) / res;
benefis.Text = Convert.ToString(bef);
benpercent.Text = Convert.ToString(berf);
rendu.Text = Convert.ToString(rend);
resultat.Text = Convert.ToString(res);
}
}
if (remise.Text != "" && puv.Text == "" && Qte.Text == "")
{
int qte = 0;
int puuv = int.Parse(puv.Text);
int remis = int.Parse(remise.Text);
int stock = int.Parse(prixprodstock.Text);
if (versement.Text == "")
{
int res;
res = (qte * puuv) - remis;
resultat.Text = Convert.ToString(res);
}
else
{
int res;
res = (qte * puuv) - remis;
int vers = int.Parse(versement.Text);
int rend;
rend = res - vers;
int bef = res - (stock * qte);
int berf = (bef * 100) / res;
benefis.Text = Convert.ToString(bef);
benpercent.Text = Convert.ToString(berf);
rendu.Text = Convert.ToString(rend);
resultat.Text = Convert.ToString(res);
}
}
if (remise.Text != "" && puv.Text != "" && Qte.Text != "")
{
int qte = int.Parse(Qte.Text);
int puuv = int.Parse(puv.Text);
int remis = int.Parse(remise.Text);
int stock = int.Parse(prixprodstock.Text);
if (versement.Text == "")
{
int res;
res = (qte * puuv) - remis;
resultat.Text = Convert.ToString(res);
}
else
{
int res;
res = (qte * puuv) - remis;
int vers = int.Parse(versement.Text);
int rend;
rend = res - vers;
int bef = res - (stock * qte);
int berf = (bef * 100) / res;
benefis.Text = Convert.ToString(bef);
benpercent.Text = Convert.ToString(berf);
rendu.Text = Convert.ToString(rend);
resultat.Text = Convert.ToString(res);
}
}
}
public void add()
{
if (designation.Text == "" && puv.Text == "" && Qte.Text == "" && client.Text == "" && mode.Text == "")
{
MessageBox.Show("Les entrées ne doivent pas être vides ! ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (heure.Text == "")
{
calcul();
DateTime now = DateTime.Now;
heure.Text = now.ToString("t");
try
{
// get client id
cmd1 = new SqlCommand(@"SELECT id FROM client WHERE Nom_client = '" + client.Text + "' ", cn);
cn.Open();
SqlDataReader sdr = cmd1.ExecuteReader();
while (sdr.Read())
{
textBox1.Text = sdr["id"].ToString();
}
cn.Close();
}
catch
{
MessageBox.Show("S'il vous plaît ,premierement ajouter un fournisseur ! ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
try
{
// get product id
cmd2 = new SqlCommand(@"SELECT id FROM produitFinal WHERE Désignation = '" + designation.Text + "' ", cn);
cn.Open();
SqlDataReader sdr3 = cmd2.ExecuteReader();
while (sdr3.Read())
{
textBox3.Text = sdr3["id"].ToString();
}
cn.Close();
}
catch
{
MessageBox.Show("S'il vous plaît ,premierement ajouter un produit ! ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
// get the last factur id
cmd3 = new SqlCommand("SELECT MAX(id) FROM facturevente", cn);
cn.Open();
try
{
double result = (Convert.ToDouble(cmd3.ExecuteScalar()));
textBox2.Text = result.ToString();
}
catch
{
textBox2.Text = "1";
}
finally
{
cn.Close();
}
// insert operation
cmd = new SqlCommand(@"INSERT INTO [dbo].[facturevente]
([Date_facture]
,[Versement]
,[Remise]
,[idclient])
VALUES ('" + dtp.Value.Date.ToString("MM/dd /yyyy") + "' , '" + versement.Text + "' , '" + remise.Text + "' , '" + textBox1.Text + "' )", cn);
cmd4 = new SqlCommand(@"INSERT INTO [dbo].[factureventeDe]
([Mode_Vente]
,[Date]
,[Heure]
,[Qte]
,[prix_vente]
,[Bénifis]
,[Bénifis_percent]
,[idproduit]
,[idfacturevente])
VALUES('" + mode.Text + "' , '" + dtp.Value.Date.ToString("MM/dd /yyyy") + "' , '" + heure.Text + "' , '" + Qte.Text + "' ,'"+resultat.Text+"', '" + benefis.Text + "' , '" + benpercent.Text + "' , '" + textBox3.Text + "' , '" + textBox2.Text + "' )", cn);
cmd5 = new SqlCommand(@"INSERT INTO [dbo].[vente_countoire]
([mode_vente]
,[Désigniation]
,[Quantité]
,[Date]
,[Heure]
,[prix_vente]
,[Remise]
,[Versement]
,[Client])
VALUES ('" + mode.Text + "' , '" + designation.Text + "' , '" + Qte.Text + "' , '" + dtp.Value.Date.ToString("MM/dd /yyyy") + "' , '" + heure.Text + "' , '"+resultat.Text+"','" + remise.Text + "' , '" + versement.Text + "' , '" + benefis.Text + "' )", cn);
cmd6 = new SqlCommand(@"UPDATE [dbo].[produitFinal] SET [Qté_initiale] = [Qté_initiale] - '" + Qte.Text + "' WHERE id = '" + textBox4.Text + "' ", cn);
cn.Open();
cmd.ExecuteNonQuery();
cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
cmd3.ExecuteNonQuery();
cmd4.ExecuteNonQuery();
cmd5.ExecuteNonQuery();
cmd6.ExecuteNonQuery();
cn.Close();
var resul = MessageBox.Show("Votre Donné été ajouté correctement ! ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (resul == DialogResult.OK)
{
this.Close();
}
select();
}
else
{
calcul();
try
{
// get client id
cmd1 = new SqlCommand(@"SELECT id FROM client WHERE Nom_client = '" + client.Text + "' ", cn);
cn.Open();
SqlDataReader sdr = cmd1.ExecuteReader();
while (sdr.Read())
{
textBox1.Text = sdr["id"].ToString();
}
cn.Close();
}
catch
{
MessageBox.Show("S'il vous plaît ,premierement ajouter un client ! ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
try
{
// get product id
cmd2 = new SqlCommand(@"SELECT id FROM produitFinal WHERE Désignation = '" + designation.Text + "' ", cn);
cn.Open();
SqlDataReader sdr3 = cmd2.ExecuteReader();
while (sdr3.Read())
{
textBox3.Text = sdr3["id"].ToString();
}
cn.Close();
}
catch
{
MessageBox.Show("S'il vous plaît ,premierement ajouter un produit ! ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
// get the last factur id
cmd3 = new SqlCommand("SELECT MAX(id) FROM facturevente", cn);
try
{
cn.Open();
double result = (Convert.ToDouble(cmd3.ExecuteScalar()));
textBox2.Text = result.ToString();
}
catch
{
textBox2.Text = "1";
}
finally
{
cn.Close();
}
try
{
// insert operation
cmd = new SqlCommand(@"INSERT INTO [dbo].[facturevente]
([Date_facture]
,[Versement]
,[Remise]
,[idclient])
VALUES ('" + dtp.Value.Date.ToString("MM/dd /yyyy") + "' , '" + versement.Text + "' , '" + remise.Text + "' , '" + textBox1.Text + "' )", cn);
cmd4 = new SqlCommand(@"INSERT INTO [dbo].[factureventeDe]
([Mode_Vente]
,[Date]
,[Heure]
,[Qte]
,[prix_vente]
,[Bénifis]
,[Bénifis_percent]
,[idproduit]
,[idfacturevente])
VALUES('" + mode.Text + "' , '" + dtp.Value.Date.ToString("MM/dd /yyyy") + "' , '" + heure.Text + "' , '" + Qte.Text + "' ,'" + resultat.Text + "', '" + benefis.Text + "' , '" + benpercent.Text + "' , '" + textBox3.Text + "' , '" + textBox2.Text + "' )", cn);
cmd5 = new SqlCommand(@"INSERT INTO [dbo].[vente_countoire]
([mode_vente]
,[Désigniation]
,[Quantité]
,[Date]
,[Heure]
,[prix_vente]
,[Remise]
,[Versement]
,[Bénifis]
,[Bénifis_percent]
,[Client])
VALUES ('" + mode.Text + "' , '" + designation.Text + "' , '" + Qte.Text + "' , '" + dtp.Value.Date.ToString("MM/dd /yyyy") + "' , '" + heure.Text + "' , '" + resultat.Text + "','" + remise.Text + "' , '" + versement.Text + "' , '" + benefis.Text + "' , '" + benpercent.Text + "' , '" + client.Text + "')", cn);
cmd6 = new SqlCommand(@"UPDATE [dbo].[produitFinal] SET [Qté_initiale] = [Qté_initiale] - '" + Qte.Text + "' WHERE id = '" + textBox4.Text + "' ", cn);
cn.Open();
cmd.ExecuteNonQuery();
cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
cmd3.ExecuteNonQuery();
cmd4.ExecuteNonQuery();
cmd5.ExecuteNonQuery();
cmd6.ExecuteNonQuery();
cn.Close();
var resul = MessageBox.Show("Votre Donné été ajouté correctement ! ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (resul == DialogResult.OK)
{
this.Close();
}
select();
}
catch
{
MessageBox.Show("Les entrées ne doivent pas être vides ! ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
// get data from dgv in textbox
private void metroGrid1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
DataGridViewRow row = metroGrid1.Rows[e.RowIndex];
textBox4.Text = row.Cells[0].Value.ToString();
designation.Text = row.Cells[1].Value.ToString();
Qte.Text = row.Cells[2].Value.ToString();
puv.Text = row.Cells[6].Value.ToString();
prixprodstock.Text = row.Cells[4].Value.ToString();
}
}
private void addbtn_Click(object sender, EventArgs e)
{
add();
}
private void cancelbtn_Click(object sender, EventArgs e)
{
this.Close();
}
private void calculer_Click(object sender, EventArgs e)
{
calcul();
}
private void client_DoubleClick(object sender, EventArgs e)
{
Forms.choseclient ch = new choseclient();
ch.ShowDialog();
}
}
}
Editor is loading...