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