public ActionResult Submited(Models.Utilizadores formData) { try { if (formData.Email.Contains("@")) { try { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Email", formData.Email.ToLower()) }; var data = context.Database.SqlQuery <Utilizadores>("showPasswordFromEmail @Email", param).ToList(); if (data.Count < 1) { // Encriptar password string passEncrypt = My_Locker_V2.Classes.MyCommonUtilities.Encrypt(formData.Password); int membro; if (formData.Membro == true) { membro = 1; } else { membro = 0; } SqlParameter[] param2 = new SqlParameter[] { new SqlParameter("@Nome", formData.Nome), new SqlParameter("@Apelido", formData.Apelido), new SqlParameter("@Email", formData.Email), new SqlParameter("@Password", passEncrypt), new SqlParameter("@Membro", membro), }; try { context.Database.ExecuteSqlCommand("Add_Utilizador @Nome,@Apelido,@Email,@Password,@Membro", param2); } catch (Exception er) { } } else { ModelState.AddModelError("Email", "Email já registado, Aceda a pagina de login para entrar"); return(View("Index", formData)); } } catch (Exception er) { } } else { ModelState.AddModelError("Email", "Email Inválido"); return(View("Index", formData)); } } catch (Exception er) { } return(View()); }
public ActionResult Submited(Models.Utilizadores formData) { if (formData.Email.Contains("@")) { try { try { // User SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Email", formData.Email) }; var data = context.Database.SqlQuery <Utilizadores>("showPasswordFromEmail @Email", param).ToList(); if (data.Count() != 0) { foreach (var i in data) { var ya = My_Locker_V2.Classes.MyCommonUtilities.Encrypt(formData.Password); if (i.Password == ya) { return(View("~/Views/insideUser/Index.cshtml", formData)); } else { ModelState.AddModelError("Password", "Dados Incorretos"); return(View("Index", formData)); } } } // Staff var dataStaff = context.Database.SqlQuery <Staff>("SELECT * FROM Staff WHERE Email = '" + formData.Email.ToLower() + "'").ToList(); if (dataStaff.Count() != 0) { foreach (var i in data) { var pass = My_Locker_V2.Classes.MyCommonUtilities.Encrypt(formData.Password); if (i.Password == pass) { return(View("~/Views/staff/StaffCentral.cshtml", formData)); } else { ModelState.AddModelError("Password", "Dados Incorretos"); return(View("Index", formData)); } } } } catch (Exception er) { ModelState.AddModelError("Email", "Email Introduzido não está registado"); return(View("Index", formData)); } } catch (Exception er) { } } else { if (formData.Email.ToLower() == "admin" && formData.Password == "admin") { return(View("~/Views/Admin/BackOffice.cshtml", formData)); } ModelState.AddModelError("Email", "Email Introduzido Incorreto"); return(View("Index", formData)); } return(View()); }