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