private void button3_Click(object sender, EventArgs e)
{
try
{
//System.Data.DataTable dt = Dynamic_Classe.Instance().ExportDatagrod_toDatatable(dataGridView1, dtable);
//Dynamic_Classe.Instance().GeneratePDF(dtable, @"E:\Liste_client.pdf", "Friend List");
//System.Diagnostics.Process.Start(@"E:\Liste_client.pdf");
Preview_form report = new Preview_form();
report.Size = new Size(825, 620);
if (comboBox2.Text.Equals(""))
{
Dynamic_Classe.Instance().Call_Report_Historic_credit(report.reportViewp, "JosaleApp.Report.Credit.rdlc", Convert.ToInt32(comboBox1.Text.Trim()));
}
else
{
string mois = comboBox2.Text.Trim();
Dynamic_Classe.Instance().Call_Report_Historic_credit_ym(report.reportViewp, "JosaleApp.Report.Credit.rdlc", Convert.ToInt32(comboBox1.Text.Trim()), mois);
}
report.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show("Error " + ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
Preview_form previewF = new Preview_form();
Dynamic_Classe.Instance().Call_Report(previewF.reportViewp, "JosaleApp.Report.Recu.rdlc", Id);
previewF.ShowDialog();
}
void PreviewHistoric()
{
Preview_form frmp = new Preview_form();
frmp.Size = new Size(825, 601);
Dynamic_Classe.Instance().Call_Report_Historic_Debit(frmp.reportViewp, "JosaleApp.Report.Loan_historic.rdlc", Convert.ToInt32(text_annee.Text));
frmp.Show();
}
private void textBox4_TextChanged(object sender, EventArgs e)
{
try
{
Dynamic_Classe.Instance().Search_Emprunt(dataGridView2, textBox4.Text.Trim());
} catch (Exception ex)
{
MessageBox.Show("Error " + ex.Message, "Error...", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//Autres méthodes
void Load_Somme()
{
sommePret = Dynamic_Classe.Instance().Count_data_prets("prets", "code_pret", sommePret);
label18.Text = "All credits " + "(" + sommePret.ToString() + ")";
sommeCustomer = Dynamic_Classe.Instance().Count_data("client", "code_cli", sommeCustomer);
label6.Text = "All customers " + "(" + sommeCustomer.ToString() + ")";
sommeDebt = Dynamic_Classe.Instance().Count_data("emprunts", "code_emprunt", sommeDebt);
label9.Text = "All debits " + "(" + sommeDebt.ToString() + ")";
sommeSupplier = Dynamic_Classe.Instance().Count_data("tier", "code_tier", sommeSupplier);
label15.Text = "All suppliers " + "(" + sommeSupplier.ToString() + ")";
}
void Display_recu()
{
try
{
Dynamic_Classe.Instance().Call_Report_Recu_Rembou(reportViewer1, "JosaleApp.Report.Recu_rembou.rdlc", Id);
}
catch (Exception ex)
{
MessageBox.Show("Error " + ex.Message, "Error...", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
void Display_Historic()
{
try
{
Dynamic_Classe.Instance().Call_Report_Historic_Rembou(reportViewer1, "JosaleApp.Report.Historic_Credit.rdlc",
Convert.ToInt32(text_annee.Text), comboBox2.Text.Trim());
}
catch (Exception ex)
{
MessageBox.Show("Error " + ex.Message, "Error...", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Load_Clients(IClient client_list)
{
gridClient.DataSource = client_list.AllClient();
Dynamic_Classe.Instance().Load_Credit_2(dataGridView1);
}
void Get_Credit()
{
dataGridView1.Rows.Clear();
Dynamic_Classe.Instance().Load_Credit(dataGridView1);
}
void Get_gage()
{
listView1.Items.Clear();
Dynamic_Classe.Instance().Load_gage(Id, listView1);
}
void Load_annee()
{
Dynamic_Classe.Instance().Get_Annee_combo(comboBox1);
}
void Somme_emprunt()
{
Dynamic_Classe.Instance().Get_Somme_debt(label20, DateTime.Now.Month);
}
private void text_search_TextChanged(object sender, EventArgs e)
{
Dynamic_Classe.Instance().Search_Credit(dataGridView1, text_search.Text.Trim());
}
void Show_recu()
{
Dynamic_Classe.Instance().Call_Report(Report_preview, "JosaleApp.Report.Recu.rdlc", Id);
}
void loadGage()
{
dataGridView2.DataSource = Dynamic_Classe.Instance().Get_Data("gage", "ref_pret", id);
}
//Méthode
void Load_Interet()
{
dataGridView1.DataSource = Dynamic_Classe.Instance().Get_Data("Affichage_Interet");
}
void Somme_emprunt_annee()
{
Dynamic_Classe.Instance().Get_Somme_debt_annee(label21, DateTime.Now.Year);
}
void Load_Historic()
{
Dynamic_Classe.Instance().Call_Report_Historic_Debit(reportViewer1, "JosaleApp.Report.Loan_historic.rdlc", Convert.ToInt32(text_annee.Text));
}
void Get_gage()
{
listView1.Items.Clear();
Dynamic_Classe.Instance().Load_gage(Id, listView1);
Dynamic_Classe.Instance().Get_Data_one("prets", Id, "montant_remb", label9);
}
void Get_Emprunt()
{
dataGridView2.Rows.Clear();
Dynamic_Classe.Instance().Load_Emprunt(dataGridView2);
}
