public ActionResult Index(string TB_Username, string TB_Password, string TB_UsernameRemind, string btn_login, string btn_send)
{
PoneySeller.Models.Users desUsagers = new PoneySeller.Models.Users(Session["MyPonies"]);
if (!string.IsNullOrWhiteSpace(btn_login))
{
bool connexionreussite = true;
if (TB_Username == "" || TB_Password == "")
{
ViewBag.ErrorTBVide = "Tout les champs doivent être remplis";
connexionreussite = false;
}
if (!desUsagers.VerifierConnection(TB_Username, TB_Password))
{
ViewBag.ErrorConnexion = "Informations invalides. ";
connexionreussite = false;
}
if (connexionreussite)
{
Session["UserValid"] = true;
Session["Username"] = TB_Username;
}
}
else if (!string.IsNullOrWhiteSpace(btn_send))
{
bool envoitreussi = true;
if (TB_UsernameRemind == "")
{
envoitreussi = false;
ViewBag.ErreurVide = "Tout les champs doivent être remplis";
}
if (desUsagers.ExecuteCommandBoolReturn("SELECT * FROM USAGERS WHERE EMAIL ='" + TB_Username + "'"))
{
envoitreussi = false;
ViewBag.ErreurUsername = "******";
}
if (envoitreussi)
{
if (EnvoyerLeEmail(TB_UsernameRemind, desUsagers))
{
ViewBag.Reussi = "Un message a été envoyé à votre adresse courriel.";
}
else
{
ViewBag.NonReussi = "Erreur dans l'envoit du message.";
}
}
}
return View(new PoneySeller.Models.Jumbotron());
}
public ActionResult Inscription(string TB_Telephone, string TB_FullName, string TB_Adresse, string TB_Ville, string TB_Password, string TB_PasswordConfirm, string TB_Email, string TB_EmailConfirm)
{
PoneySeller.Models.Users desUsagers = new PoneySeller.Models.Users(Session["MyPonies"]);
bool inscriptionreussite = true;
bool TextBoxRempli = false;
if (TB_Password != TB_PasswordConfirm)
{
ViewBag.ErrorMDP = "Les mots de passe doivent correspondre";
inscriptionreussite = false;
}
if (TB_Email != TB_EmailConfirm)
{
ViewBag.ErrorEmail = "Les emails doivent correspondre";
inscriptionreussite = false;
}
if (desUsagers.ExecuteCommandBoolReturn("SELECT * FROM USAGERS WHERE EMAIL ='" + TB_Email + "'"))
{
ViewBag.NomUtilise = "Email deja utilisé";
inscriptionreussite = false;
}
if (TB_Telephone != "" && TB_Ville != "" && TB_Adresse != "" && TB_FullName != "" && TB_Email != "" && TB_EmailConfirm != "" && TB_PasswordConfirm != "" && TB_Password != "")
{
TextBoxRempli = true;
}
else
{
ViewBag.ErrorTBVide = "Tout les champs doivent être remplis";
inscriptionreussite = false;
}
if (inscriptionreussite && TextBoxRempli)
{
string sqlcommand = "insert into usagers (nomcomplet, password, adresse, ville, telephone, email) values ("
+ "'" + TB_FullName + "','" + TB_Password + "','" + TB_Adresse
+ "','" + TB_Ville + "','" + TB_Telephone + "','" + TB_Email + "')";
if (desUsagers.ExecuteCommandIntReturn(sqlcommand) > 0)
{
return RedirectToAction("Index", "Home");
}
else
{
ViewBag.NonReussi = "Inscription non reussite";
}
}
return View(new PoneySeller.Models.Jumbotron());
}