public int TriByYear(int CurYear)
{
using (var connexion = connect.ConnexionFileBDD())
{
string pourcent = "%/%/" + CurYear;
LT = connexion.Query <TRIMESTRE>("select * from TRIMESTRE where TRIMESTRE.DAT_PART LIKE ?", pourcent);
if (LT.Count() != 0)
{
for (int i = 0; i < LT.Count(); i++)
{
}
}
if (LT.Count() != 0)
{
switch (LT.Count())
{
case 4: return(4);
case 8: return(8);
case 12: return(12);
case 16: return(16);
}
}
else
{
return(0);
}
}
return(0);
}
public List <CREANCIER> SelectAllCre()
{
using (var connexion = connect.ConnexionFileBDD())
{
LC = connexion.Query <CREANCIER>("SELECT * FROM CREANCIER");
return(LC);
}
}
public int InitTables(SQLiteConnection Co)
{
var connect = new ConnexionBDD();
using (var connexion = connect.ConnexionFileBDD())
{
return(0);
}
}
public string GetMDP()
{
using (var connexion = connect.ConnexionFileBDD())
{
List <M_D_P> LMDP = new List <M_D_P>();
LMDP = connexion.Query <M_D_P>("SELECT * FROM MDP");
if (LMDP.Count != 0)
{
string mdpass = LMDP[0].MDP;
return(mdpass);
}
return("000");
}
}
public List <LOT> SelectAllLot()
{ //{#1} connexion à la base de données
using (var connexion = connect.ConnexionFileBDD())
{
//{#2} Déclaration d'une liste de LOT
List <LOT> ListeLot = new List <LOT>();
//{#3} implémentation de la liste via la base de données
ListeLot = connexion.Query <LOT>("SELECT * FROM LOT");
//{#4}renvoie de la liste
return(ListeLot);
}
}
public List <CHARGE> SelectAllCha()
{
using (var connexion = connect.ConnexionFileBDD())
{
LC = connexion.Query <CHARGE>("SELECT CHARGE.NUM_CHA,CHARGE.NUM_LOT,CHARGE.LIB_CHA,CHARGE.MNT_CHA,CHARGE.DAT_CHA,CHARGE.MNT_PAI,CHARGE.DAT_PAI,CHARGE.COD_PAI,CHARGE.ID_PAI FROM CHARGE INNER JOIN PROPRIETAIRE ON CHARGE.NUM_LOT = PROPRIETAIRE.NUM_LOT WHERE PROPRIETAIRE.DAT_DEP =? ORDER BY (substr(DAT_CHA,7,9)||substr(DAT_CHA,1,2)||substr(DAT_CHA,4,2))", "");
return(LC);
}
}
public List <PROPRIETAIRE> SelectProByLot()
{
using (var connexion = connect.ConnexionFileBDD())
{
string vide = "";
string espace = " ";
LP = connexion.Query <PROPRIETAIRE>("SELECT PROPRIETAIRE.NUM_LOT, PROPRIETAIRE.NOM_PRO, LOT.ADRESSE, LOT.COD_PART FROM LOT INNER JOIN PROPRIETAIRE ON LOT.NUM_LOT = PROPRIETAIRE.NUM_LOT WHERE(PROPRIETAIRE.DAT_DEP =? OR PROPRIETAIRE.DAT_DEP =?) GROUP BY LOT.NUM_LOT", vide, espace);
return(LP);
}
}
