private void InitialiseListClasses() { // this function is going to initialise all of my list classes every time i call it Categories = new G_t_categorie(SChonn).Lire("IdCateg"); Entreprises = new G_t_entreprise(SChonn).Lire("IdEntre"); Interimeurs = new G_t_interimeur(SChonn).Lire("IdInte"); Factures = new G_t_facture(SChonn).Lire("IdFact"); Prestations = new G_t_travail(SChonn).Lire("IdTravail"); }
private void btnEditer_Click(object sender, EventArgs e) { if (dgvFacture.SelectedRows.Count > 0) { Activer(false); tbId.Text = dgvFacture.SelectedRows[0].Cells["IdFact"].Value.ToString(); var facture = new G_t_facture(SChonn).Lire_ID(int.Parse(tbId.Text)); C_t_entreprise entreprise = Entreprises.Find(x => x.id_entre == facture.id_entre); C_t_interimeur interimeur = Interimeurs.Find(x => x.id_inte == facture.id_inte); dtpFacture.Value = facture.date_fact; cbEntre2.Text = entreprise.nom_entre.ToString(); cbInte2.Text = interimeur.nom_inte.ToString(); } else { MessageBox.Show(@"There is no row selected!"); } }
//constructor #endregion public MainForm() { InitializeComponent(); var skinManager = MaterialSkin.MaterialSkinManager.Instance; //Material theme initialization skinManager.ColorScheme = new MaterialSkin.ColorScheme(MaterialSkin.Primary.BlueGrey600, MaterialSkin.Primary.Amber700, MaterialSkin.Primary.Amber500, MaterialSkin.Accent.Green400, MaterialSkin.TextShade.WHITE); // changing the color theme to bleu and amber Travails = new G_t_categorie(SChonn).Lire("IdTravail"); //initialization of category list Interimaires = new G_t_interimeur(SChonn).Lire("IdInte"); //initialization of Interimaire list Entreprises = new G_t_entreprise(SChonn).Lire("IdEntre"); //initialization of Entreprise list Prestations = new G_t_travail(SChonn).Lire("IdPresta"); //initialization of Prestation list Factures = new G_t_facture(SChonn).Lire("IdFact"); //initialization of Facture list RemplirDgvInterimeur(); RemplirDgvEntreprise(); RemplirDgvTravail(); RemplirDgvFacture(); RemplirDgvPrestations(); SelectFirstRow(dgvInterimeur, dgvEntreprise, dgvTravails, dgvFacture, dgvTravails); }
private void RemplireDgv() { DtFacture = new DataTable(); DtFacture.Columns.Add(new DataColumn("IdFact", Type.GetType("System.Int32") ?? throw new InvalidOperationException())); DtFacture.Columns.Add("DateFact"); DtFacture.Columns.Add("IdEntre"); DtFacture.Columns.Add("IdInte"); List <C_t_facture> factures = new G_t_facture(SChonn).Lire("Nom"); foreach (C_t_facture facture in factures) { C_t_entreprise entreprise = Entreprises.Find(x => x.id_entre == facture.id_entre); C_t_interimeur interimeur = Interimeurs.Find(x => x.id_inte == facture.id_inte); DtFacture.Rows.Add(facture.id_fact, facture.date_fact.ToString("dd/MM/yyyy"), entreprise.nom_entre, interimeur.nom_inte); } BsFacture = new BindingSource { DataSource = DtFacture }; dgvFacture.DataSource = BsFacture; }
private void btnConfirmer_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(tbId.Text)) { var nId = new G_t_facture(SChonn).Ajouter(dtpFacture.Value, Convert.ToInt32(cbEntre.SelectedItem), Convert.ToInt32(cbInte.SelectedItem)); DtFacture.Rows.Add(nId, DtFacture, cbEntre.SelectedItem, cbInte.SelectedItem); } else { var nId = int.Parse(tbId.Text); C_t_interimeur interimeur = Interimeurs.Find(x => x.nom_inte == cbInte2.Text); C_t_entreprise entreprise = Entreprises.Find(x => x.nom_entre == cbEntre2.Text); new G_t_facture(SChonn).Modifier(nId, dtpFacture.Value, interimeur.id_inte, entreprise.id_entre); dgvFacture.SelectedRows[0].Cells["DateFact"].Value = DtFacture; dgvFacture.SelectedRows[0].Cells["IdEntre"].Value = cbEntre.Text; dgvFacture.SelectedRows[0].Cells["IdInte"].Value = cbInte.Text; BsFacture.EndEdit(); Activer(true); } RefreshDgv(); ClearTb(); }