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