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