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());
}
