public static List <Mensualite> getListMensualite(String query)
{
NpgsqlConnection con = Connexion.Connection();
try
{
List <Mensualite> l = new List <Mensualite>();
NpgsqlCommand Lcmd = new NpgsqlCommand(query, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
if (lect.HasRows)
{
while (lect.Read())
{
Mensualite a = new Mensualite();
a.Id = Convert.ToInt64(lect["id"].ToString());
a.DateMensualite = (DateTime)((lect["date_reglement"] != null) ? ((!lect["date_reglement"].ToString().Trim().Equals("")) ? lect["date_reglement"] : DateTime.Now) : DateTime.Now);
a.Etat = lect["etat"].ToString();
a.Montant = (Double)((lect["montant"] != null) ? ((!lect["montant"].ToString().Trim().Equals("")) ? lect["montant"] : 0) : 0);
a.Facture = ((lect["facture"] != null)
? (!lect["facture"].ToString().Trim().Equals("")
? new Facture(Convert.ToInt64(lect["facture"].ToString()))
: new Facture())
: new Facture());
a.Reglements = BLL.PieceCaisseBll.Liste("select * from yvs_base_piece_tresorerie where id_externe = " + a.Id + " and table_externe = '" + Constantes.TABLE_EXTERNE_PIECE + "'");
foreach (PieceCaisse p in a.Reglements)
{
a.MontantVerse += p.Montant;
}
a.MontantReste = a.Montant - a.MontantVerse;
if (a.MontantReste <= 0)
{
a.MontantReste = 0;
a.Etat = Constantes.ETAT_REGLE;
}
else
{
a.IsOut = (DateTime.Compare(DateTime.Now, a.DateMensualite) < 0);
a.Etat = a.IsOut ? Constantes.ETAT_RETARD : a.Etat;
}
a.Update = true;
l.Add(a);
}
lect.Close();
}
return(l);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
private void FullReglement(Mensualite m)
{
if ((m != null) ? m.Id > 0 : false)
{
foreach (PieceCaisse p in m.Reglements)
{
AddRowReglement(p);
}
}
}
private void dgv_mensualite_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgv_mensualite.CurrentRow.Cells[0].Value != null)
{
long id = Convert.ToInt64(dgv_mensualite.CurrentRow.Cells[0].Value.ToString());
if (id > 0)
{
Form_Caisse_Saisie f = (Form_Caisse_Saisie)F_parent;
Mensualite c = f.facture.Mensualites.Find(x => x.Id == id);
PopulateViewMensualite(c);
}
}
}
catch (Exception ex)
{
Messages.Exception(ex);
}
}
public static bool getUpdateMensualite(Mensualite a)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string update = "update yvs_com_mensualite_facture_vente set "
+ " date_reglement = '" + a.DateMensualite + "', facture = " + a.Facture.Id + ", montant = " + a.Montant + ", etat = '" + a.Etat + "'"
+ " where id = " + a.Id;
NpgsqlCommand Ucmd = new NpgsqlCommand(update, con);
Ucmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
Messages.Exception(e);
return(false);
}
finally
{
Connexion.Deconnection(con);
}
}
public static Mensualite getAjoutMensualite(Mensualite a)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string insert = "insert into yvs_com_mensualite_facture_vente"
+ "(date_reglement, facture, montant, etat)"
+ "values ('" + a.DateMensualite + "', " + a.Facture.Id + ", " + a.Montant + ", '" + a.Etat + "')";
NpgsqlCommand cmd = new NpgsqlCommand(insert, con);
cmd.ExecuteNonQuery();
a.Id = getCurrent();
return(a);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
private void AddRowMensualite(Mensualite m)
{
dgv_mensualite.Rows.Add(new object[] { m.Id, m.DateMensualite, m.Montant, m.MontantVerse, m.MontantReste, m.Etat, m.IsOut });
}
private void PopulateViewMensualite(Mensualite m)
{
ResetFicheMensualite();
mensualite = m;
FullReglement(m);
}
private void ResetFicheMensualite()
{
mensualite = new Mensualite();
dgv_reglement.Rows.Clear();
ResetFicheReglement();
}
public MensualiteBll(Mensualite unMensualite)
{
mensualite = unMensualite;
}
