//
// GET: /InfoClient/Client/
public ActionResult Index()
{
Client client = new Client();
client.ListClient = client.GetListeClient();
return View("ListClient", client);
}
public ActionResult LoginConnect(IdentificationModel model)
{
if (ModelState.IsValid)
{
Client c = new Client();
// Recherche du mdp en bdd
bool mdpOk = c.CheckPassword(model.Nom, model.Prenom, model.Password);
if (mdpOk)
{
switch (Convert.ToInt32(model.Type))
{
case 0://Assistant
return RedirectToAction("DashboardAssistant", "Assistant");
case 1://Commercial
return RedirectToAction("DashboardCommercial", "Commercial");
default://Technicien
return RedirectToAction("DashboardTechnicien", "Technicien");
}
}
}
ViewBag.Message = "Les identifiants ou le mot de passe sont invalides.";
return View();
}
public ActionResult DetailContrat(Contrat contrat)
{
Contrat c = new Contrat();
Client client = new Client();
c.DetailClient = client.GetClientById(contrat.id_client);
return RedirectToAction("DetailContrat", contrat);
}
/// <summary>
/// Récupere les infos du formulaire pour une MAJ d'un client
/// </summary>
/// <param name="client"></param>
/// <returns></returns>
public ActionResult ModifierInfoClient(Client client)
{
Client c = new Client();
c.nom = client.nom;
c.prenom = client.prenom;
c.adresse = client.adresse;
c.cp = client.cp;
c.ville = client.ville;
c.tel_fixe = client.tel_fixe;
c.tel_mobile = client.tel_mobile;
c.email = client.email;
// Appel de la méthode pour inserer un client en bdd
c.UpdateClient(c);
return RedirectToAction("Index");
}
/// <summary>
/// Récupere les infos du formulaire pour une insertion d'un client
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult InscriptionClient(AjoutClientModel model)
{
Client c = new Client();
c.nom = model.Nom;
c.prenom = model.Prenom;
c.adresse = model.Adresse;
c.cp = model.CodePostal;
c.ville = model.Ville;
c.tel_fixe = model.TelephoneFixe;
c.tel_mobile = model.TelephoneMobile;
c.email = model.Email;
c.password = model.Password;
c.dateInscription = DateTime.Now;
// Appel de la méthode pour inserer un client en bdd
c.InsertClient(c);
return RedirectToAction("Index");
}
public ActionResult ListClient()
{
Client client = new Client();
client.ListClient = client.GetListeClient();
if (client.ListClient.Count() > 0 & client.ListClient.Count() == 1)
{
ViewData["Result"] = "Il y a " + client.ListClient.Count().ToString() + " client.";
}
if (client.ListClient.Count() > 1)
{
ViewData["Result"] = "Il y a " + client.ListClient.Count().ToString() + " clients.";
}
else
{
ViewData["Result"] = "Liste vide";
}
return View("ListClient", client);
}
/// <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 ActionResult InformationClient(Client c)
{
return View("InformationClient", 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);
}
}
}
/// <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;
}
