public void Get_Credit(IPrets credit)
{
dataGridView1.DataSource = credit.Allcredit();
Load_annee();
comboBox1.SelectedIndex = 0;
Load_Chart(pret);
}
void Save_Pret(bool btn)
{
try
{
prets = new Prets();
prets.Id = Convert.ToInt32(id);
prets.Montant = float.Parse(textBox7.Text.Trim());
prets.RefCli = Convert.ToInt32(id);
prets.RefInteret = Convert.ToInt32(code_interet);
prets.DateRembour = dateTimePicker1.Value.Date;
if (btn)
{
prets.Save(prets);
MessageBox.Show("Saved successfully !!!", "Message...", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
prets.Delete(id);
}
}
catch (Exception ex)
{
MessageBox.Show("Error " + ex.Message, "Error...", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
void Nouveau_Client_Pret()
{
client = new Client();
prets = new Prets();
gage = new Gage();
code_cli = client.Nouveau();
code_pret = prets.Nouveau();
code_gage = gage.Nouveau();
}
void Load_Chart(IPrets chart_loaded)
{
if (comboBox1.Items.Count >= 1)
{
chart_loaded.Show_Chat(chart1, Convert.ToInt32(comboBox1.Text.Trim()));
}
else
{
chart_loaded.Show_Chat(chart1, 2018);
}
}
public void Save(IPrets prets)
{
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "INSERT_PRETS";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@code", 10, DbType.Int32, Id));
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@montant", 10, DbType.Double, Montant));
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@refcli", 10, DbType.Int32, RefCli));
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@refinter", 10, DbType.Int32, RefInteret));
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@daterembour", 20, DbType.Date, DateRembour));
cmd.ExecuteNonQuery();
//MessageBox.Show("Saved successfully !!!", "Message...", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
void Get_Credit_annee_mois(IPrets credit)
{
dataGridView1.DataSource = credit.Allcredit_Tri_moi(Convert.ToInt32(comboBox1.Text.Trim()), comboBox2.Text.Trim());
}
void Get_Rembourssement(IPrets rembou)
{
dataGridView1.DataSource = rembou.AllRembou();
}
