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 RemplireComboBox() { List <C_t_entreprise> entreprises = new G_t_entreprise(SChonn).Lire("Nom"); List <C_t_interimeur> interimeurs = new G_t_interimeur(SChonn).Lire("IdCateg"); foreach (var entreprise in entreprises) { cbEntre2.Items.Add(entreprise.nom_entre); } foreach (var interimeur in interimeurs) { cbInte2.Items.Add(interimeur.nom_inte); } }
private void btnConfirmer_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(tbId.Text)) // id must be empty { if (string.IsNullOrEmpty(tbNom.Text) || string.IsNullOrEmpty(tbPrenom.Text) || string.IsNullOrEmpty(tbBonus.Text)) // names must not be empty { MessageBox.Show(@"Please fill all require information"); } else // creation { //string query = "INSERT INTO dbo.t_interimeur (nom_inte,prenom_inte,specialisation,bonus_sal,date_naissance) VALUES(@nom_inte,@prenom_inte,@specialisation,@bonus_sal,@date_naissance);"; //using (SqlConnection con = new SqlConnection(SChonn)) //using (SqlCommand cmd = new SqlCommand(query, con)) //{ // cmd.Parameters.Add("@nom_inte", SqlDbType.Text).Value = tbNom.Text.ToString(); // cmd.Parameters.Add("@prenom_inte", SqlDbType.Text).Value = tbPrenom.Text.ToString(); // cmd.Parameters.Add("@specialisation", SqlDbType.Text).Value = cbMetier.SelectedItem; // cmd.Parameters.Add("@bonus_sal", SqlDbType.Int).Value = Convert.ToInt32( tbBonus.Text); // cmd.Parameters.Add("@date_naissance", SqlDbType.Date).Value = dtpNaissance.Value.Date; // con.Open(); // cmd.ExecuteNonQuery(); // con.Close(); //} var nId = new G_t_interimeur(SChonn).Ajouter(tbNom.Text, tbPrenom.Text, Convert.ToString(cbMetier.SelectedItem), Convert.ToDouble(tbBonus.Text), dtpNaissance.Value); DtInterimeur.Rows.Add(nId, tbNom, tbPrenom, cbMetier.SelectedItem, tbBonus, dtpNaissance.Value); //C_t_entreprise entreprise = Entreprises.Find(x => x.nom_entre == cbEntreprise.Text); //chaque fois qu on va creer un interimaire une factures va se creer //var nId_fact = new G_t_facture(SChonn).Ajouter(DateTime.Today, nId, entreprise.id_entre); } } else // modification { var nId = int.Parse(tbId.Text); new G_t_interimeur(SChonn).Modifier(nId, tbNom.Text, tbPrenom.Text, Convert.ToString(cbMetier.SelectedItem), Convert.ToDouble(tbBonus.Text), dtpNaissance.Value); dgvInterimeur.SelectedRows[0].Cells["NomInte"].Value = tbNom.Text; dgvInterimeur.SelectedRows[0].Cells["PrenomInte"].Value = tbPrenom.Text; dgvInterimeur.SelectedRows[0].Cells["IdSpec"].Value = cbMetier.SelectedItem; dgvInterimeur.SelectedRows[0].Cells["BonusSal"].Value = tbBonus.Text; dgvInterimeur.SelectedRows[0].Cells["date_naissance"].Value = dtpNaissance.Value; BsInterimeur.EndEdit(); Activer(true); } RefreshDgv(); ClearTb(); }
private void btnEditer_Click(object sender, EventArgs e) { if (dgvInterimeur.SelectedRows.Count > 0) { Activer(false); tbId.Text = dgvInterimeur.SelectedRows[0].Cells["IdInte"].Value.ToString(); var interimeur = new G_t_interimeur(SChonn).Lire_ID(int.Parse(tbId.Text)); tbNom.Text = interimeur.nom_inte; tbPrenom.Text = interimeur.prenom_inte; tbBonus.Text = Convert.ToString(interimeur.bonus_sal, CultureInfo.CurrentCulture); cbMetier.Text = interimeur.specialisation; } 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() { _info.CurrencySymbol = " (%) "; DtInterimeur = new DataTable(); DtInterimeur.Columns.Add(new DataColumn("IdInte", Type.GetType("System.Int32") ?? throw new InvalidOperationException())); DtInterimeur.Columns.Add("NomInte"); DtInterimeur.Columns.Add("PrenomInte"); DtInterimeur.Columns.Add("IdSpec"); DtInterimeur.Columns.Add("BonusSal"); DtInterimeur.Columns.Add("date_naissance"); List <C_t_interimeur> interimeurs = new G_t_interimeur(SChonn).Lire("Nom"); foreach (C_t_interimeur interimeur in interimeurs) { DtInterimeur.Rows.Add(interimeur.id_inte, interimeur.nom_inte, interimeur.prenom_inte, interimeur.specialisation, string.Format("{0:P1}", interimeur.bonus_sal / 100), interimeur.date_naissance.ToString("dd/MM/yyyy")); } BsInterimeur = new BindingSource { DataSource = DtInterimeur }; dgvInterimeur.DataSource = BsInterimeur; }