private void button1_Click(object sender, EventArgs e)
{
try
{
data = new SqlDataAdapter("select * from Livraison where CodeLivr=" + textBox8.Text, con);
data.Fill(set, "Livraison");
data = new SqlDataAdapter("select cha.* from Charge_Commande as cha inner join Chargement as ch on ch.CodeChargement=cha.CodeChargement inner Join Livraison as l on l.CodeChargement=ch.CodeChargement where l.CodeLivr=" + textBox8.Text, con);
data.Fill(set, "Charge_Commande");
data = new SqlDataAdapter("select ch.* from Chargement as ch inner Join Livraison as l on l.CodeChargement=ch.CodeChargement where l.CodeLivr=" + textBox8.Text, con);
data.Fill(set, "Chargement");
data = new SqlDataAdapter("select chau.* from chauffeur as chau inner join Chargement as ch on chau.CodeChauffeur=ch.CodeChauf inner Join Livraison as l on l.CodeChargement=ch.CodeChargement where l.CodeLivr=" + textBox8.Text, con);
data.Fill(set, "Chauffeur");
data = new SqlDataAdapter("select C.* from Commande as C inner Join Charge_Commande as char on C.Codecommande=char.CodeCommande inner join Chargement as ch on ch.CodeChargement=char.CodeChargement inner Join Livraison as l on l.CodeChargement=ch.CodeChargement where l.CodeLivr=" + textBox8.Text, con);
data.Fill(set, "Commande");
data = new SqlDataAdapter("select Cl.* from Client as Cl inner Join Commande as C on C.CodeClient=Cl.Codeclient inner Join Charge_Commande as char on C.Codecommande=char.CodeCommande inner join Chargement as ch on ch.CodeChargement=char.CodeChargement inner Join Livraison as l on l.CodeChargement=ch.CodeChargement where l.CodeLivr=" + textBox8.Text, con);
data.Fill(set, "Client");
BonLivraison b = new BonLivraison();
b.SetDataSource(set);
Report_Viewer_Form r = new Report_Viewer_Form();
r.Text = "Bon de Livraison N° " + textBox8.Text;
r.crystalReportViewer1.ReportSource = b;
r.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.Text != null)
{
try
{
data = new SqlDataAdapter("select * from Facture where CodeComm=" + comboBox1.Text, con);
data.Fill(set, "Facture");
data = new SqlDataAdapter("select C.* from Commande as C inner Join Facture as F on C.Codecommande=F.CodeComm where F.CodeComm=" + comboBox1.Text, con);
data.Fill(set, "Commande");
data = new SqlDataAdapter("select Cl.* from Client as Cl inner join Commande as C on C.CodeClient=Cl.Codeclient inner Join Facture as F on C.Codecommande=F.CodeComm where F.CodeComm=" + comboBox1.Text, con);
data.Fill(set, "Client");
Facturation f = new Facturation();
f.SetDataSource(set);
Report_Viewer_Form r = new Report_Viewer_Form();
r.Text = "Facture N° " + comboBox1.Text;
r.crystalReportViewer1.ReportSource = f;
r.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Voulez choisir une Facture", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnBonCmd_Click(object sender, EventArgs e)
{
Report_Viewer_Form frm = new Report_Viewer_Form();
DataSet Data_Set = SqlServer_Classes.getBonCommande(codeCommande);
BonCommande reportCommande = new BonCommande();
reportCommande.SetDataSource(Data_Set);
frm.Text = "Bon De Commande N°= " + codeCommande;
frm.crystalReportViewer1.ReportSource = reportCommande;
frm.Show();
}
private void btnPrintBonCmd_Click(object sender, EventArgs e)
{
Report_Viewer_Form frm = new Report_Viewer_Form();
frm.Text = "Bon De Commande N°= " + lblCodeCommande.Text;
DataSet set = SqlServer_Classes.getBonCommande(int.Parse(lblCodeCommande.Text));
BonCommande reportCommande = new BonCommande();
reportCommande.SetDataSource(set);
frm.crystalReportViewer1.ReportSource = reportCommande;
frm.Show();
}
public static void FacturerCommande_Print(int CodeCommande)
{
try
{
int CodeFacture = int.Parse(ExecuteScalar("select CodeFacture from Facture where CodeComm = '" + CodeCommande + "'").ToString());
DataSet Data_Set = getFacture(CodeCommande);
Facturation reportCommande = new Facturation();
reportCommande.SetDataSource(Data_Set);
Report_Viewer_Form frm = new Report_Viewer_Form();
frm.Text = "Facture N°: " + CodeFacture + " pour la commande N°: " + CodeCommande;
frm.crystalReportViewer1.ReportSource = reportCommande;
frm.Show();
}
catch (Exception Err)
{
MessageBox.Show(Err.Message, "Un Erreur est survenue", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static void ConfirmerChargement_Commande(int CodeCommande, int CodeChauffeur, int CodeCamion)
{
try
{
string CodeTour = DateTime.Now.Year + "" + CodeCommande;
int CodeTournee = int.Parse(CodeTour);
ExecuteQuery("insert into Tournee values(@CodeTournee, @DateTournee)", new SqlParameter[] { new SqlParameter("@DateTournee", DateTime.Now), new SqlParameter("@CodeTournee", CodeTournee) });
SqlParameter[] parametre = new SqlParameter[]
{
new SqlParameter("@CodeChauf", CodeChauffeur),
new SqlParameter("@CodeCamion", CodeCamion),
new SqlParameter("@CodeTournee", CodeTournee)
};
ExecuteQuery("update Commande set numTournee = @CodeTournee where Codecommande = @CodeComm", new SqlParameter[]
{
new SqlParameter("CodeTournee", CodeTournee),
new SqlParameter("@CodeComm", CodeCommande)
});
ExecuteQuery("insert into Chargement(CodeChauf, CodeCamion, CodeTournee) values(@CodeChauf, @CodeCamion, @CodeTournee)", parametre);
int CodeChargement = int.Parse(ExecuteScalar("select IDENT_CURRENT('Chargement')").ToString());
DataSet Data_Set = getBonChargement(CodeChargement);
BonDeChargement reportCommande = new BonDeChargement();
reportCommande.SetDataSource(Data_Set);
Report_Viewer_Form frm = new Report_Viewer_Form();
frm.Text = "Bon De Chargement N°: " + CodeChargement + " pour la commande N°: " + CodeCommande;
frm.crystalReportViewer1.ReportSource = reportCommande;
frm.Show();
}
catch (Exception Err)
{
MessageBox.Show(Err.Message, "Un Erreur est survenue", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
data = new SqlDataAdapter("select CodeFacture,Total from Facture where CodeComm=" + textBox6.Text, con);
data.Fill(set, "Facture");
data = new SqlDataAdapter("select C.CodeDepot,C.CodeClient,C.DateCommande,C.Codecommande from Commande as C inner Join Facture as F on C.Codecommande=F.CodeComm where F.CodeComm=" + textBox6.Text, con);
data.Fill(set, "Commande");
data = new SqlDataAdapter("select Cl.Nom,Cl.Prenom,Cl.Cin,Cl.Tel,Cl.Adresse,Cl.Email from Client as Cl inner join Commande as C on C.CodeClient=Cl.Codeclient inner Join Facture as F on C.Codecommande=F.CodeComm where F.CodeComm=" + textBox6.Text, con);
data.Fill(set, "Client");
Facturation f = new Facturation();
f.SetDataSource(set);
Report_Viewer_Form r = new Report_Viewer_Form();
r.Text = "Facture N° " + textBox6.Text;
r.crystalReportViewer1.ReportSource = f;
r.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static void LivrerCommande_Print(int CodeCommande)
{
try
{
int CodeTournee = int.Parse(ExecuteScalar("select numTournee from Commande where Codecommande = '" + CodeCommande + "'").ToString());
int CodeChargement = int.Parse(ExecuteScalar("select CodeChargement from Chargement where CodeTournee = '" + CodeTournee + "'").ToString());
ExecuteQuery("insert into Livraison(CodeChargement) values('" + CodeChargement + "')");
int CodeLivraison = int.Parse(ExecuteScalar("select IDENT_CURRENT('Livraison')").ToString());
DataSet Data_Set = getBonLivraison(CodeLivraison);
BonLivraison reportCommande = new BonLivraison();
reportCommande.SetDataSource(Data_Set);
Report_Viewer_Form frm = new Report_Viewer_Form();
frm.Text = "Bon De Livraison N°: " + CodeLivraison + " pour la commande N°: " + CodeCommande;
frm.crystalReportViewer1.ReportSource = reportCommande;
frm.Show();
}
catch (Exception Err)
{
MessageBox.Show(Err.Message, "Un Erreur est survenue", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
