public void LoadGridData() { //remplir data grid view : testé et validé ! using (Facturation_DBEntities db = new Facturation_DBEntities()) { var req = (from cl in db.CLIENTs select new { cl.NumeroSerie, cl.NomAgenceOuClient, cl.NumeroTelephoneClient, cl.VILLE.LblVille }); MyDataGrid.DataSource = req.ToList(); } if (MyDataGrid.Columns.Count < 6) { MyDataGrid.Columns.Add(new DataGridViewButtonColumn { Name = "columnSupr", UseColumnTextForButtonValue = true, Text = "Supprimer !", HeaderText = "", SortMode = DataGridViewColumnSortMode.NotSortable, Width = 488, AutoSizeMode = DataGridViewAutoSizeColumnMode.NotSet, MinimumWidth = 3 }); } }
public void LoadGridData() { //remplir data grid view : testé et validé ! using (Facturation_DBEntities db = new Facturation_DBEntities()) { var req = (from ing in db.INGENIEURs select new { ing.IdIngenieur, ing.noming, ing.NumeroTelephoneIngenieur }); MyDataGrid.DataSource = req.ToList(); } if (MyDataGrid.Columns.Count < 3) { MyDataGrid.Columns.Add(new DataGridViewButtonColumn { Name = "columnSupr", UseColumnTextForButtonValue = true, Text = "Supprimer !", HeaderText = "", SortMode = DataGridViewColumnSortMode.NotSortable, Width = 488, AutoSizeMode = DataGridViewAutoSizeColumnMode.NotSet, MinimumWidth = 3 }); } }
public void LoadGridData() { //remplir data grid view : testé et validé ! using (Facturation_DBEntities db = new Facturation_DBEntities()) { var req = (from s in db.SECRETAIREs select new { s.id, s.nom, s.prenom, s.email, s.mdp }); MyDataGrid.DataSource = req.ToList(); } if (MyDataGrid.Columns.Count < 5) { MyDataGrid.Columns.Add(new DataGridViewButtonColumn { Name = "columnSupr", UseColumnTextForButtonValue = true, Text = "Supprimer !", HeaderText = "", SortMode = DataGridViewColumnSortMode.NotSortable, Width = 488, AutoSizeMode = DataGridViewAutoSizeColumnMode.NotSet, MinimumWidth = 3 }); } }
private void BtnSoumettre_Click(object sender, EventArgs e) { using (Facturation_DBEntities db = new Facturation_DBEntities()) { var admin = db.ADMINNs.Where(adminn => adminn.email.Equals(Email_Input.Text)).FirstOrDefault(); if (!(admin is null)) { Validation(admin.nom + " " + admin.prenom, true); EnvoyerEmail(admin.email, admin.mdp); }
private void bunifuMaterialTextbox4_Leave(object sender, EventArgs e) { using (Facturation_DBEntities db = new Facturation_DBEntities()) { var secretaire = db.SECRETAIREs.Where(secretairee => secretairee.email.Equals(EmailInput.Text)).FirstOrDefault(); if (!(secretaire is null)) { informationSplashScreen = $"secrétaire : {secretaire.nom} {secretaire.prenom} !"; pictureVerificationEmail.Image = Facturation.Properties.Resources.verified; }
public void loaddata() { //remplissage comboBox data grid view : testé et validé ! using (Facturation_DBEntities db = new Facturation_DBEntities()) { dropListVille.DisplayMember = "LblVille"; dropListVille.ValueMember = "IdVille"; dropListVille.DataSource = db.VILLEs.ToList(); } LoadGridData(); }
public void Modifier_Click(object sender, EventArgs e) { //modifier : testé et validé ! using (Facturation_DBEntities db = new Facturation_DBEntities()) { INGENIEUR ing = db.INGENIEURs.Find(InputCode.Text); ing.noming = InputNom.Text; ing.NumeroTelephoneIngenieur = InputTel.Text; db.SaveChanges(); btnAnnuler_Click(sender, e); } AnimationFeedback("Modifié avec succées !", Properties.Resources.good); }
private void MyDataGrid_CellClick(object sender, DataGridViewCellEventArgs e) { // testé et validé ! // intégre les donnée lli kaynine f la ligne dans les champs de l'interface d'ajout if (e.ColumnIndex.Equals(0)) { using (Facturation_DBEntities db = new Facturation_DBEntities()) { bunifuTransition1.HideSync(bunifuShadowPanel1, false, BunifuAnimatorNS.Animation.HorizSlide); this.Ajouter.ButtonText = "Confirmer !"; this.Ajouter.Location = new System.Drawing.Point(423, 67); this.Ajouter.Size = new System.Drawing.Size(92, 32); if (this.InputCode.Enabled) { { this.Ajouter.Click -= new EventHandler(Ajouter_Click); this.Ajouter.Click += new EventHandler(Modifier_Click); InputCode.Enabled = false; } var ing = db.INGENIEURs.Find(MyDataGrid.Rows[e.RowIndex].Cells["idIngenieur"].Value); InputCode.Text = ing.IdIngenieur.ToString(); InputNom.Text = ing.noming; InputTel.Text = ing.NumeroTelephoneIngenieur.ToString(); bunifuButton4.Visible = true; bunifuTransition1.ShowSync(bunifuShadowPanel1, false, BunifuAnimatorNS.Animation.HorizSlide); } } } else if (e.ColumnIndex.Equals(5) || e.ColumnIndex.Equals(1)) { if ( DialogResult.Yes == MessageBox.Show($"Etes vous sur de vouloir supprimer <{MyDataGrid.Rows[e.RowIndex].Cells["nom"].Value}> de la base de donnée ?? Cette action est irréversible !", "Supression", MessageBoxButtons.YesNo, MessageBoxIcon.Question) ) { using (Facturation_DBEntities db = new Facturation_DBEntities()) { db.CLIENTs.Remove(db.CLIENTs.Find(MyDataGrid.Rows[e.RowIndex].Cells["idIngenieur"].Value)); db.SaveChangesAsync(); AnimationFeedback("Suprimé avec succées !", Properties.Resources.good); } } } }
public void Modifier_Click(object sender, EventArgs e) { //modifier : testé et validé ! using (Facturation_DBEntities db = new Facturation_DBEntities()) { CLIENT client = db.CLIENTs.Find(InputCode.Text); client.NumeroTelephoneClient = InputTel.Text; client.NomAgenceOuClient = InputNom.Text; client.VILLE = db.VILLEs.Find(dropListVille.SelectedValue); db.SaveChanges(); btnAnnuler_Click(sender, e); } AnimationFeedback("Modifié avec succées !", Properties.Resources.good); }
private void IdentityVerification() { if (!Program.form.IsAdmin) { this.label10.Visible = this.label11.Visible = this.LB_NbrSecrtr.Visible = this.LB_NbrAdmin.Visible = false; } else { using (Facturation_DBEntities db = new Facturation_DBEntities()) { this.LB_NbrSecrtr.Text = db.SECRETAIREs.Count <SECRETAIRE>().ToString(); this.LB_NbrAdmin.Text = db.ADMINNs.Count <ADMINN>().ToString(); } } }
private void bunifuImageButton1_Click(object sender, EventArgs e) { //rechercher : testé et validé ! using (Facturation_DBEntities db = new Facturation_DBEntities()) { MyDataGrid.DataSource = (from ing in db.INGENIEURs select new { ing.IdIngenieur, ing.noming, ing.NumeroTelephoneIngenieur }).Where(INGENIEUR => INGENIEUR.noming.Contains(bunifuMetroTextbox1.Text)) .ToList(); } }
private void bunifuImageButton1_Click(object sender, EventArgs e) { //rechercher : testé et validé ! using (Facturation_DBEntities db = new Facturation_DBEntities()) { MyDataGrid.DataSource = (from cl in db.CLIENTs select new { cl.NumeroSerie, cl.NomAgenceOuClient, cl.NumeroTelephoneClient, cl.VILLE.LblVille }).Where(client => client.NomAgenceOuClient.Contains(bunifuMetroTextbox1.Text)) .ToList(); } }
public void LoadData() { Canvas canvas; DataPoint dataPoint = new DataPoint(BunifuDataViz._type.Bunifu_doughnut); using (Facturation_DBEntities db = new Facturation_DBEntities()) { int pourcentageClientEntreprises = db.CLIENTs.Where(client => client.NumeroSerie.StartsWith("En")).Count(); dataPoint.addLabely("Entreprises", pourcentageClientEntreprises); int pourcentageClientParticuler = db.CLIENTs.Where(client => client.NumeroSerie.StartsWith("Pa")).Count(); dataPoint.addLabely("Particuler", pourcentageClientParticuler); canvas = new Canvas(); canvas.addData(dataPoint); bunifuDataViz1.Render(canvas); dataPoint.clear(); // ***Statistiques*** //manque remplissage de Dataviz 2 et 3 this.LB_NbrClient.Text = db.CLIENTs.Count <CLIENT>().ToString(); this.LB_NbrIngenieur.Text = db.INGENIEURs.Count <INGENIEUR>().ToString(); this.LB_FactureImp.Text = db.FACTURATIONs.Where(facture => facture.EstImprime == true).ToList().Count <FACTURATION>().ToString(); this.LB_FactureNoImp.Text = db.FACTURATIONs.Where(facture => facture.EstImprime == false).ToList().Count <FACTURATION>().ToString(); this.LB_NbrPieces.Text = db.PIECEs.Count <PIECE>().ToString(); IdentityVerification(); OutilConnect.Connect(); OutilConnect.sqlCommand = new System.Data.SqlClient.SqlCommand("select top 1 LblVille , count(*) as countt from client c inner join ville v on c.Id_Class# = v.IdVille group by LblVille order by countt desc", OutilConnect.sqlConnection); OutilConnect.reader = OutilConnect.sqlCommand.ExecuteReader(); OutilConnect.table = new DataTable(); OutilConnect.table.Load(OutilConnect.reader); this.LB_VilleMax.Text = OutilConnect.table.Rows[0]["LblVille"].ToString(); OutilConnect.reader.Close(); OutilConnect.sqlCommand = new System.Data.SqlClient.SqlCommand("select top 1 c.NomAgenceOuClient , count(*) as countt from Appel a inner join CLIENT c on c.NumeroSerie = a.IdClient# group by c.NomAgenceOuClient order by countt desc", OutilConnect.sqlConnection); OutilConnect.reader = OutilConnect.sqlCommand.ExecuteReader(); OutilConnect.table.Load(OutilConnect.reader); this.LB_ClientEx.Text = String.IsNullOrEmpty(OutilConnect.table.Rows[0]["NomAgenceOuClient"].ToString()) ? "Digital Factory" : OutilConnect.table.Rows[0]["NomAgenceOuClient"].ToString(); OutilConnect.reader.Close(); OutilConnect.DeConnect(); } }
private void Ajouter_Click(object sender, EventArgs e) { //ajouter : testé et validé ! using (Facturation_DBEntities db = new Facturation_DBEntities()) { if (db.INGENIEURs.Find(InputCode.Text) is null) { db.INGENIEURs.Add(new INGENIEUR { IdIngenieur = Convert.ToInt32(InputCode.Text), noming = InputNom.Text, NumeroTelephoneIngenieur = InputTel.Text, }); db.SaveChanges(); AnimationFeedback("Ajouté avec succées !", Properties.Resources.good); } else { AnimationFeedback("Client déja existant !", Properties.Resources.notValid); } } }
public void Ajouter_Click(object sender, EventArgs e) { //ajouter : testé et validé ! using (Facturation_DBEntities db = new Facturation_DBEntities()) { if (db.CLIENTs.Find(InputCode.Text) is null) { db.CLIENTs.Add(new CLIENT { NumeroSerie = InputCode.Text, NumeroTelephoneClient = InputTel.Text, NomAgenceOuClient = InputNom.Text, VILLE = db.VILLEs.Find(dropListVille.SelectedValue) }); db.SaveChanges(); AnimationFeedback("Ajouté avec succées !", Properties.Resources.good); } else { AnimationFeedback("Client déja existant !", Properties.Resources.notValid); } } }
private void bunifuButton1_Click(object sender, EventArgs e) { //ajouter : testé et validé ! using (Facturation_DBEntities db = new Facturation_DBEntities()) { if (db.SECRETAIREs.Find(InputCode.Text) is null) { db.SECRETAIREs.Add(new SECRETAIRE { id = int.Parse(InputCode.ToString()), nom = bunifuMaterialTextbox1.Text, prenom = bunifuMaterialTextbox2.Text, email = bunifuMaterialTextbox3.Text, mdp = bunifuMaterialTextbox4.Text }); db.SaveChanges(); AnimationFeedback("Ajouté avec succées !", Properties.Resources.good); } else { AnimationFeedback("Client déja existant !", Properties.Resources.notValid); } } }