public FrmGestionBudget()
{
InitializeComponent();
GestionBudget.SetchaineConnexion(ConfigurationManager.
ConnectionStrings["AssocBudget"]);
GestionFlux.SetchaineConnexion(ConfigurationManager.
ConnectionStrings["AssocFlux"]);
List <BudgetBO> budgetInitialAS = new List <BudgetBO>();
budgetInitialAS = GestionBudget.GetBudget("AS");
List <BudgetBO> budgetInitialEPS = new List <BudgetBO>();
budgetInitialEPS = GestionBudget.GetBudget("EPS");
List <Flux> listeCredit = new List <Flux>();
listeCredit = GestionFlux.GetFlux(1);
List <Flux> listeDebit = new List <Flux>();
listeDebit = GestionFlux.GetFlux(2);
// Rattachement de la List à la source de données du datagridview
dtgBudgetAS.ColumnHeadersVisible = false;
dtgBudgetEPS.ColumnHeadersVisible = false;
dtgBudgetAS.DataSource = budgetInitialAS;
dtgBudgetEPS.DataSource = budgetInitialEPS;
dtgDebits.DataSource = listeDebit;
dtgCredits.DataSource = listeCredit;
}
private void dtgBudgetAS_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
dtgBudgetAS.AutoGenerateColumns = false;
// Création d'une en-tête de colonne pour la colonne 2
DataGridViewTextBoxColumn BudgetASMontant = new DataGridViewTextBoxColumn();
BudgetASMontant.DataPropertyName = "montantInitial_budget";
dtgBudgetAS.Columns.Add(BudgetASMontant);
// Définition du style apporté au datagridview
dtgBudgetAS.ColumnHeadersVisible = false;
dtgBudgetAS.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
// Création d'un objet List d'Utilisateur à afficher dans le datagridview
List <BudgetBO> budgetInitial = new List <BudgetBO>();
budgetInitial = GestionBudget.GetBudget("AS");
// Rattachement de la List à la source de données du datagridview
dtgBudgetAS.DataSource = budgetInitial;
}
private void btnActualiser_Click(object sender, EventArgs e)
{
dtgBudgetAS.ColumnHeadersVisible = false;
dtgBudgetEPS.ColumnHeadersVisible = false;
dtgBudgetAS.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dtgBudgetEPS.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
// Création d'un objet List d'Utilisateur à afficher dans le datagridview
List <BudgetBO> budgetInitialAS = new List <BudgetBO>();
budgetInitialAS = GestionBudget.GetBudget("AS");
List <BudgetBO> budgetInitialEPS = new List <BudgetBO>();
budgetInitialEPS = GestionBudget.GetBudget("EPS");
// Rattachement de la List à la source de données du datagridview
dtgBudgetAS.DataSource = budgetInitialAS;
dtgBudgetEPS.DataSource = budgetInitialEPS;
}
public void budget(int x, int y)
{
List <Budget> budgets = this.calcBudgetMontant();
Label lblHeadLibelle = new Label();
lblHeadLibelle.Text = "Libelle";
lblHeadLibelle.AutoSize = true;
lblHeadLibelle.Location = new Point(x, y);
lblHeadLibelle.Dock = DockStyle.Fill;
lblHeadLibelle.TextAlign = ContentAlignment.MiddleCenter;
Label lblHeadMontant = new Label();
lblHeadMontant.Text = "Montant Initial";
lblHeadMontant.AutoSize = true;
lblHeadMontant.Location = new Point(x, y);
lblHeadMontant.Dock = DockStyle.Fill;
lblHeadMontant.TextAlign = ContentAlignment.MiddleCenter;
Label lblHeadMontantTotal = new Label();
lblHeadMontantTotal.Text = "Montant Total";
lblHeadMontantTotal.AutoSize = true;
lblHeadMontantTotal.Location = new Point(x, y);
lblHeadMontantTotal.Dock = DockStyle.Fill;
lblHeadMontantTotal.TextAlign = ContentAlignment.MiddleCenter;
Label lblHeadModifier = new Label();
lblHeadModifier.Text = "Modifier";
lblHeadModifier.AutoSize = true;
lblHeadModifier.Location = new Point(x, y);
lblHeadModifier.Dock = DockStyle.Fill;
lblHeadModifier.TextAlign = ContentAlignment.MiddleCenter;
Label lblHeadDelete = new Label();
lblHeadDelete.Text = "Supprimer";
lblHeadDelete.AutoSize = true;
lblHeadDelete.Location = new Point(x, y);
lblHeadDelete.Dock = DockStyle.Fill;
lblHeadDelete.TextAlign = ContentAlignment.MiddleCenter;
this.Controls.Find("pnl", true)[0].Controls.Add(lblHeadLibelle);
this.Controls.Find("pnl", true)[0].Controls.Add(lblHeadMontant);
this.Controls.Find("pnl", true)[0].Controls.Add(lblHeadMontantTotal);
this.Controls.Find("pnl", true)[0].Controls.Add(lblHeadModifier);
this.Controls.Find("pnl", true)[0].Controls.Add(lblHeadDelete);
foreach (Budget budget in budgets)
{
y += 20;
Label lblLibelle = new Label();
lblLibelle.Text = budget.Libelle.Trim();
lblLibelle.AutoSize = true;
lblLibelle.Location = new Point(x, y);
lblLibelle.Dock = DockStyle.Fill;
lblLibelle.TextAlign = ContentAlignment.MiddleCenter;
Label lblMontantInitial = new Label();
lblMontantInitial.Text = budget.MontantInitial.ToString();
lblMontantInitial.AutoSize = true;
lblMontantInitial.Location = new Point(x, y);
lblMontantInitial.Dock = DockStyle.Fill;
lblMontantInitial.TextAlign = ContentAlignment.MiddleCenter;
Label lblMontantTotal = new Label();
lblMontantTotal.Text = budget.MontantTotal.ToString();
lblMontantTotal.AutoSize = true;
lblMontantTotal.Location = new Point(x, y);
lblMontantTotal.Dock = DockStyle.Fill;
lblMontantTotal.TextAlign = ContentAlignment.MiddleCenter;
Button btnUpdate = new Button();
btnUpdate.Tag = GestionBudget.GetBudget(budget.Id);
btnUpdate.Text = "Modifier";
btnUpdate.AutoSize = true;
btnUpdate.Location = new Point(x, y);
btnUpdate.Dock = DockStyle.Fill;
btnUpdate.Click += new EventHandler(btnUpdate_Click);
btnUpdate.TextAlign = ContentAlignment.MiddleCenter;
Button btnDelete = new Button();
btnDelete.Tag = budget;
btnDelete.Text = "Supprimer";
btnDelete.AutoSize = true;
btnDelete.Location = new Point(x, y);
btnDelete.Dock = DockStyle.Fill;
btnDelete.Click += new EventHandler(btnDelete_Click);
btnDelete.TextAlign = ContentAlignment.MiddleCenter;
this.Controls.Find("pnl", true)[0].Controls.Add(lblLibelle);
this.Controls.Find("pnl", true)[0].Controls.Add(lblMontantInitial);
this.Controls.Find("pnl", true)[0].Controls.Add(lblMontantTotal);
this.Controls.Find("pnl", true)[0].Controls.Add(btnUpdate);
this.Controls.Find("pnl", true)[0].Controls.Add(btnDelete);
}
}
