/// <summary> /// Recupere le password du client stocké en BDD /// </summary> /// <param name="nom"></param> /// <param name="prenom"></param> /// <param name="password"></param> /// <returns></returns> public bool CheckPassword(string nom, string prenom, string password) { using (HandicapsEntities bdd = new HandicapsEntities())// Utilisation de la bdd { var requete = (from data in bdd.Client where data.nom == nom && data.prenom == prenom && data.password == password select new { lastName = data.nom, firstName = data.prenom, mdp = data.password }).FirstOrDefault(); if (requete != null) { return true; } } return false; }
/// <summary> /// /// </summary> /// <returns></returns> public Client GetClientById(int idClient) { Client c = new Client(); using (HandicapsEntities bdd = new HandicapsEntities())// Utilisation de la bdd { var requete = (from data in bdd.Client where data.id == idClient select new { id = data.id, nom = data.nom, prenom = data.prenom, adresse = data.adresse, telFixe = data.tel_fixe, telMobile = data.tel_mobile, email = data.email, cp = data.cp, ville = data.ville }).ToList().OrderByDescending(m => id).First(); if (requete != null) { c.id = requete.id; c.nom = requete.nom; c.prenom = requete.prenom; c.adresse = requete.adresse; c.cp = requete.cp; c.ville = requete.ville; c.tel_fixe = requete.telFixe; c.tel_mobile= requete.telMobile; c.email = requete.email; } } return c; }
public List<SelectListItem> GetDropListAntenne() { List<SelectListItem> items = new List<SelectListItem>(); using (HandicapsEntities bdd = new HandicapsEntities()) { var req = (from data in bdd.Antenne select new { text = data.ville, value = data.ville }).ToList(); if (req != null) { foreach (var drop in req) { items.Add(new SelectListItem { Text = drop.text, Value = drop.value }); } } } return items; }
public void GetResultSearch(string type, string motRechercher) { List<Contrat> ls = new List<Contrat>(); using (HandicapsEntities bdd = new HandicapsEntities())// Utilisation de la bdd { switch(type) { case "contrat": var req = (from c in bdd.Contrat where c.id == Convert.ToInt32(motRechercher) select new { numero = result.id, antenne = result.Antenne, type = result.type_intervention, dateSign = result.date_signature, garantie = result.date_echeance }).ToList(); break; case "materiel": var req = (from result in bdd.Contrat where result.id == Convert.ToInt32(motRechercher) select new { numero = result.id, antenne = result.Antenne, type = result.type_intervention, dateSign = result.date_signature, garantie = result.date_echeance }).ToList(); break; case "intervention": var req = (from result in bdd.Contrat where result.id == Convert.ToInt32(motRechercher) select new { numero = result.id, antenne = result.Antenne, type = result.type_intervention, dateSign = result.date_signature, garantie = result.date_echeance }).ToList(); break; default: break; } if (type == "contrat") { if (req != null) { foreach (var l in req) { Contrat c = new Contrat(); c.id = l.numero; c.Antenne = l.antenne; c.type_intervention = l.type; c.date_signature = l.dateSign; c.date_echeance = l.garantie; ls.Add(c); } } } } }
/// <summary> /// MAJ d'un Client en BDD /// </summary> /// <param name="c"></param> public void UpdateClient(Client c) { using (HandicapsEntities bdd = new HandicapsEntities()) { // MAJ d'un client en bdd if (c != null) { var updateClient = bdd.INSERT_UpdateClient(c.id,c.nom, c.prenom, c.adresse, c.cp, c.ville, c.tel_fixe, c.tel_mobile, c.email); } } }
/// <summary> /// Creation d'un client en BDD /// </summary> /// <param name="c"></param> public void InsertClient(Client c) { using (HandicapsEntities bdd = new HandicapsEntities()) { // Insertion d'un client en bdd if (c != null) { var insertClient = bdd.INSERT_AjouterClient(c.nom, c.prenom, c.adresse, c.cp, c.ville, c.tel_fixe, c.tel_mobile, c.email, c.password, c.dateInscription); } } }
public List<Materiel> GetListMaterielById(int idContrat) { List<Materiel> ls = new List<Materiel>(); using (HandicapsEntities bdd = new HandicapsEntities())// Utilisation de la bdd { var req = (from rm in bdd.ReferenceMateriel join m in bdd.Materiel on rm.id equals m.id_reference_materiel join cm in bdd.ContratMateriel on m.num_serie equals cm.id_materiel join c in bdd.Contrat on cm.id_contrat equals c.id where c.id == idContrat select new { dateInstallation = m.date_installation, libelle = rm.libelle, numSerie = m.num_serie, categorie = rm.categorie, dateSignature = c.date_signature, dateEcheance = c.date_echeance }).ToList(); if (req != null) { foreach (var l in req) { Materiel matos = new Materiel(); matos.date_installation = l.dateInstallation; matos.libelle = l.libelle; matos.num_serie = l.numSerie; matos.categorie = l.categorie; matos.dateSignature = (DateTime)l.dateSignature; matos.dateEcheance = (DateTime)l.dateEcheance; ls.Add(matos); } } } return ls; }
/// <summary> /// Retourne la liste de tous les clients en bdd /// </summary> /// <returns></returns> public List<Client> GetListeClient() { ListClient = new List<Client>(); using (HandicapsEntities bdd = new HandicapsEntities())// Utilisation de la bdd { var requete = (from data in bdd.Client select new { id = data.id, nom = data.nom, prenom = data.prenom, adresse = data.adresse, telFixe = data.tel_fixe, telMobile = data.tel_mobile, email = data.email }).ToList().OrderByDescending(m => id); if (requete.Count() > 0) { foreach (var data in bdd.Client) { Client c = new Client(); c.id = data.id; c.nom = data.nom; c.prenom = data.prenom; c.adresse = data.adresse; c.cp = data.cp; c.ville = data.ville; c.tel_fixe = data.tel_fixe; c.tel_mobile = data.tel_mobile; c.email = data.email; ListClient.Add(c);// Ajout du client dans la liste } } } return ListClient; }
/// <summary> /// Récupere la liste des contrats du client /// </summary> /// <param name="idClient"></param> /// <returns></returns> public List<Contrat> GetListContratById(int idClient) { List<Contrat> ls = new List<Contrat>(); using (HandicapsEntities bdd = new HandicapsEntities())// Utilisation de la bdd { var req = ( from data in bdd.Contrat where data.id_client == idClient select new { numero = data.id, antenne = data.Antenne, type = data.type_intervention, dateSign = data.date_signature, garantie = data.date_echeance }).ToList(); if (req != null) { foreach (var l in req) { Contrat c = new Contrat(); c.id = l.numero; c.Antenne = l.antenne; c.type_intervention = l.type; c.date_signature = l.dateSign; c.date_echeance = l.garantie; ls.Add(c); } } } return ls; }