private void choiceCamionAndChauffeur_Load(object sender, EventArgs e)
{
cmbCamion.DataSource = SqlServer_Classes.executeAndReturnTable("select codecamm, Matricule from Camion");
cmbCamion.ValueMember = "codecamm";
cmbCamion.DisplayMember = "Matricule";
cmbChauffeur.DataSource = SqlServer_Classes.executeAndReturnTable("select CodeChauffeur, CIN + ' ' + Upper(Nom) + ' ' + Lower(PreNom) as Name from chauffeur");
cmbChauffeur.ValueMember = "CodeChauffeur";
cmbChauffeur.DisplayMember = "Name";
}
private void btnConfirmerChargement_Click(object sender, EventArgs e)
{
using (choiceCamionAndChauffeur frm = new choiceCamionAndChauffeur())
{
if (frm.ShowDialog() == DialogResult.OK)
{
SqlServer_Classes.ConfirmerChargement_Commande(codeCommande,
int.Parse(frm.cmbChauffeur.SelectedValue.ToString()),
int.Parse(frm.cmbCamion.SelectedValue.ToString()));
btnConfirmerChargement.Enabled = false;
btnLivrerCmd.Enabled = true;
}
}
}
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 Consulter_Tournee_Load(object sender, EventArgs e)
{
DataTable dt = SqlServer_Classes.executeAndReturnTable(@"select *, [dbo].[getNbrCommande](NumeroTournee) from Tournee");
foreach (DataRow r in dt.Rows)
{
userControl = new LTournee_Row(int.Parse(r[0].ToString()), DateTime.Parse(r[1].ToString()), int.Parse(r[2].ToString()));
userControl.Dock = DockStyle.Top;
panelTournees.Controls.Add(userControl);
}
userControl = new LTournee_Title();
userControl.Dock = DockStyle.Top;
panelTournees.Controls.Add(userControl);
}
private void Consulter_Commandes_Load(object sender, EventArgs e)
{
DataTable dt = SqlServer_Classes.executeAndReturnTable(@"select Codecommande, DateCommande, Convert(varchar, Client.Codeclient) + ' : ' + Upper(Nom) + ' ' + Prenom
from Commande inner join Client on Client.Codeclient = Commande.CodeClient");
foreach (DataRow r in dt.Rows)
{
userControl = new LCmd_Row(int.Parse(r[0].ToString()), DateTime.Parse(r[1].ToString()), r[2].ToString());
userControl.Dock = DockStyle.Top;
panelCommandes.Controls.Add(userControl);
}
userControl = new LCmd_Title();
userControl.Dock = DockStyle.Top;
panelCommandes.Controls.Add(userControl);
}
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();
}
private void loadDataMAJ()
{
object o = SqlServer_Classes.ExecuteScalar("select idMAJ from MiseA_Jour order by DateMAJ desc");
if (o != null)
{
DateTime dateM = DateTime.Parse(SqlServer_Classes.ExecuteScalar("select DateMAJ from MiseA_Jour where idMAJ = '" + int.Parse(o.ToString()) + "'").ToString());
lblLastMAJ.Text = dateM.ToString("ddd dd/MM/yyyy à HH:mm");
int Progress = SqlServer_Classes.getProgress(int.Parse(o.ToString()));
lblProgress.Text = Progress + " %";
progressMAJ.Value = Progress;
}
else
{
lblLastMAJ.Text = "Aucune mise à jour n'a été effectué";
lblProgress.Text = "0 %";
progressMAJ.Value = 0;
}
}
public void loadCommande(int CodeCommande)
{
panelProducts.Controls.Clear();
DataTable dt = SqlServer_Classes.executeAndReturnTable(@"select Designation, QteCommande, Unite, QteCommande * PrixUnitaire as mtTotal, ligneCommande.CodeProduit from Commande inner join ligneCommande on Commande.Codecommande = ligneCommande.Codecomm
inner join Produit on Produit.CodeProduit = ligneCommande.CodeProduit
where Commande.Codecommande = '" + CodeCommande + "'");
foreach (DataRow r in dt.Rows)
{
userControl = new Commande_Row(r[0].ToString(), int.Parse(r[1].ToString()), r[2].ToString(), decimal.Parse(r[3].ToString()), -1);
userControl.Name = r[0].ToString();
userControl.Dock = DockStyle.Top;
panelProducts.Controls.Add(userControl);
}
userControl = new Commande_Title();
userControl.Dock = DockStyle.Top;
panelProducts.Controls.Add(userControl);
panelProducts.AutoScroll = false;
panelProducts.HorizontalScroll.Enabled = false;
panelProducts.HorizontalScroll.Visible = false;
panelProducts.HorizontalScroll.Maximum = 0;
panelProducts.AutoScroll = true;
}
private void printBonChargemenet()
{
int CodeChargement = int.Parse(SqlServer_Classes.ExecuteScalar("select IDENT_CURRENT('Chargement')").ToString());
var App = Application.OpenForms["Form1"] as Form1;
Command_UC ucComm = (Command_UC)App.panelContainer.Controls[0];
DataSet Data_Set = SqlServer_Classes.getBonChargement(CodeChargement);
BonDeChargement reportCommande = new BonDeChargement();
reportCommande.SetDataSource(Data_Set);
ReportViewer_UC viewer_UC = new ReportViewer_UC();
viewer_UC.Dock = DockStyle.Fill;
viewer_UC.crystalReportViewer1.ReportSource = reportCommande;
viewer_UC.Refresh();
App.panelContainer.Controls.Clear();
App.panelContainer.Controls.Add(viewer_UC);
}
public void loadCommande(int CodeTournee)
{
panelCommandes.Controls.Clear();
DataTable dt = SqlServer_Classes.executeAndReturnTable(@"select CodeCommande, DateCommande, Convert(varchar, Client.Codeclient) + ' : ' + UPPER(Nom) + ' ' + LOWER(Prenom) from Commande
inner join Client on Client.Codeclient = Commande.CodeClient
where numTournee = '" + CodeTournee + "'");
foreach (DataRow r in dt.Rows)
{
userControl = new LCmd_Row(int.Parse(r[0].ToString()), DateTime.Parse(r[1].ToString()), r[2].ToString());
((LCmd_Row)userControl).btnDetail.Enabled = false;
userControl.Dock = DockStyle.Top;
panelCommandes.Controls.Add(userControl);
}
userControl = new LCmd_Title();
userControl.Dock = DockStyle.Top;
panelCommandes.Controls.Add(userControl);
panelCommandes.AutoScroll = false;
panelCommandes.HorizontalScroll.Enabled = false;
panelCommandes.HorizontalScroll.Visible = false;
panelCommandes.HorizontalScroll.Maximum = 0;
panelCommandes.AutoScroll = true;
}
private void btnCommande_Click(object sender, EventArgs e)
{
try
{
using (OpenFileDialog Ds = new OpenFileDialog())
{
Ds.Filter = "Fichier CSV|*Csv";
Ds.Multiselect = false;
if (Ds.ShowDialog() == DialogResult.OK)
{
Dictionary <int, Commande> commandes = new Dictionary <int, Commande>();
List <ligneCommande> lineCommandes = new List <ligneCommande>();
using (var reader = new StreamReader(Ds.FileName))
{
while (!reader.EndOfStream)
{
string line = reader.ReadLine();
if (line.Trim().Length != 0 && !line.Contains("affectée") && !line.Contains("affected") && !line.Contains("Codecommande"))
{
if (!commandes.ContainsKey(int.Parse(line.Split(',')[0])))
{
commandes.Add(int.Parse(line.Split(',')[0]), new Commande(
int.Parse(line.Split(',')[0]),
DateTime.Parse(line.Split(',')[1]),
int.Parse(line.Split(',')[3])
));
}
lineCommandes.Add(new ligneCommande(
int.Parse(line.Split(',')[0].Trim()),
int.Parse(line.Split(',')[6].Trim()),
int.Parse(line.Split(',')[7].Trim())
));
}
}
}
SqlServer_Classes.ExecuteQuery("insert into MiseA_Jour values(DeFAULT)");
int CodeMAJ = int.Parse(SqlServer_Classes.ExecuteScalar("select IDENT_CURRENT('MiseA_Jour')").ToString());
List <SqlParameter> parameters = new List <SqlParameter>();
foreach (Commande commande in commandes.Values)
{
parameters.Clear();
parameters.Add(new SqlParameter("@dateComm", commande.DateCommande));
parameters.Add(new SqlParameter("@codeDepot", Program.CodeDepot));
parameters.Add(new SqlParameter("@CodeClient", commande.CodeClient));
parameters.Add(new SqlParameter("@numMAJ", CodeMAJ));
SqlServer_Classes.ExecuteQuery("insert into Commande values(@dateComm, @codeDepot, @CodeClient, @numMAJ)", parameters);
int CodeCommande = int.Parse(SqlServer_Classes.ExecuteScalar("select IDENT_CURRENT('Commande')").ToString());
foreach (ligneCommande ligneCommande in lineCommandes)
{
if (ligneCommande.CodeCommande == commande.CodeCommande)
{
parameters.Clear();
parameters.Add(new SqlParameter("@codeComm", CodeCommande));
parameters.Add(new SqlParameter("@codeProduit", ligneCommande.CodeProduit));
parameters.Add(new SqlParameter("@Qte", ligneCommande.Qte));
SqlServer_Classes.ExecuteQuery("insert into ligneCommande values(@codeComm, @codeProduit, @Qte)", parameters);
}
}
}
loadDataMAJ();
MessageBox.Show("la mise à jour a bien été effectué de la base de donnée", "Opération Terminé", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (IOException exept)
{
MessageBox.Show(exept.Message, "Un Erreur a été survenue lors de l'ouverture et lecture du fichier", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnFacturerCommande_Click(object sender, EventArgs e)
{
SqlServer_Classes.FacturerCommande_Print(codeCommande);
}
private void btnLivrerCmd_Click(object sender, EventArgs e)
{
SqlServer_Classes.LivrerCommande_Print(codeCommande);
btnConfirmerChargement.Enabled = false;
btnLivrerCmd.Enabled = false;
}
