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