public void SetCardCredit(Entity.Usager usager, float newCredit) { var query = "UPDATE Carte SET Credit=\"" + newCredit + "\"" + " WHERE MatriculeCarte=(SELECT MatriculeCarte FROM Usager WHERE Matricule=\"" + usager.Matricule + "\"" + ")"; Debug.WriteLine(query); MySqlDataReader mySqlDataReader = _sQLService.Load(query); mySqlDataReader.Close(); }
public void SetCardCredit(Entity.Usager usager, float newCredit) { try { _usagerDAL.SetCardCredit(usager, newCredit); } catch (Exception ex) { throw new Exception(ex.Message); } }
public float GetCardCredit(Entity.Usager usager) { try { return(_usagerDAL.GetCardCredit(usager)); } catch (Exception ex) { throw new Exception(ex.Message); } }
public float GetCardCredit(Entity.Usager usager) { float credit = 0; var query = "SELECT Credit FROM Carte WHERE MatriculeCarte=\"" + usager.MatriculeCarte + "\""; MySqlDataReader mySqlDataReader = _sQLService.Load(query); try { while (mySqlDataReader.Read()) { credit = (float)mySqlDataReader["Credit"]; } } catch { throw new Exception("Problème(s) lors de l'accès au crédit de l'usager !"); } mySqlDataReader.Close(); return(credit); }
public List <Entity.Usager> GetAllUsagersNonUtilisateur() { var query = "SELECT * FROM Usager WHERE Matricule NOT IN (SELECT idUtilisateur FROM Utilisateur)"; MySqlDataReader mySqlDataReader = _sQLService.Load(query); try { List <Entity.Usager> list = new List <Entity.Usager>(); while (mySqlDataReader.Read()) { Entity.Usager usager = new Entity.Usager( (DateTime)mySqlDataReader["DateEntree"], (int)mySqlDataReader["Matricule"], (int)mySqlDataReader["CodeFonction"], (int)mySqlDataReader["Service"], mySqlDataReader["Nom"] as string, mySqlDataReader["Prenom"] as string, mySqlDataReader["Titre"] as string, mySqlDataReader["Paiement"] as string, (int)mySqlDataReader["MatriculeCarte"], mySqlDataReader["DateFinC"] as DateTime? ); list.Add(usager); } return(list); } catch (MySqlException) { throw new Exception("Problème(s) lors du chargement des usagers !"); } finally { mySqlDataReader.Close(); } }
public Entity.Usager GetUsagerByMatriculeCarte(int matricule) { var query = "SELECT * FROM Usager WHERE MatriculeCarte=" + "\"" + matricule + "\""; MySqlDataReader mySqlDataReader = _sQLService.Load(query); try { List <Entity.Usager> list = new List <Entity.Usager>(); while (mySqlDataReader.Read()) { Entity.Usager usager = new Entity.Usager( (DateTime)mySqlDataReader["DateEntree"], (int)mySqlDataReader["Matricule"], (int)mySqlDataReader["CodeFonction"], (int)mySqlDataReader["Service"], mySqlDataReader["Nom"] as string, mySqlDataReader["Prenom"] as string, mySqlDataReader["Titre"] as string, mySqlDataReader["Paiement"] as string, (int)mySqlDataReader["MatriculeCarte"], mySqlDataReader["DateFinC"] as DateTime? ); list.Add(usager); } return(list[0]); } catch (MySqlException) { throw new Exception("Problème(s) lors l'obtention de l'usager !"); } finally { mySqlDataReader.Close(); } }