public override string[] GetRolesForUser(string username)
{
OWRModels db = new OWRModels();
//string data = db.USUARIO.Where(x => x.LOGIN == username).FirstOrDefault().ROLE;
string data = (from U in db.USUARIO
join R in db.ROLE on U.ID_ROLE equals R.ID_ROLE
where U.LOGIN == username
select R.DESCRICAO).FirstOrDefault();
string[] result = { data };
return(result);
}
public ActionResult Login(USUARIO model, string returnUrl)
{
OWRModels db = new OWRModels();
var dataItem = db.USUARIO.Where(x => x.LOGIN == model.LOGIN && x.SENHA == model.SENHA).FirstOrDefault();
if (dataItem != null)
{
HttpCookie cookie = new HttpCookie("Usuario");
cookie.Value = dataItem.ID_USUARIO.ToString();
DateTime dtNow = DateTime.Now;
TimeSpan tsMinute = new TimeSpan(0, 0, 120, 0);
cookie.Expires = dtNow + tsMinute;
Response.Cookies.Add(cookie);
ViewBag.nome = dataItem.NOME;
var role = (from R in db.ROLE
where R.ID_ROLE == dataItem.ID_ROLE
select R.DESCRICAO).FirstOrDefault();
FormsAuthentication.SetAuthCookie(role.ToString(), false);
if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") && !returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\"))
{
return(Redirect(returnUrl));
}
else
{
FormsAuthentication.SetAuthCookie(role.ToString(), false);
Session["UsuarioLogado"] = dataItem.ID_USUARIO;
return(RedirectToAction("Index"));
}
}
else
{
ModelState.AddModelError("", "Usuário ou senha inválidos");
return(View());
}
}
