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); } }