public ActionResult RemoveWishlistItem(WishlistItemIDModel wlireq) { using (var db = new WishlistContext()) { var wli = db.WishlistItems.FirstOrDefault(wli2 => wli2.WishlistItemId == wlireq.ID); if (wli == null) { return(Json(new { Success = false, Exception = "Invalid wishlist item id." })); } else if (wli.Wishlist.UserId != WebSecurity.CurrentUserId) { return(Json(new { Success = false, Exception = "Removal requested by an unauthorized user." })); } else { db.WishlistItems.Remove(wli); db.SaveChanges(); return(Json(new { Success = true })); } } }
public List <Desejos> Listar() { using (WishlistContext ctx = new WishlistContext()) { return(ctx.Desejos.ToList()); } }
public Usuarios BuscarUsuarioPorEmailESenha(LoginViewModel login) { using (WishlistContext ctx = new WishlistContext()) { return(ctx.Usuarios.FirstOrDefault(x => x.Email == login.Email && x.Senha == login.Senha)); } }
public ActionResult NewWishlist() { using (var db = new WishlistContext()) { var wl = new Models.Wishlist { UserId = WebSecurity.CurrentUserId, WishlistTitle = "New Wishlist" }; db.Wishlists.Add(wl); db.SaveChanges(); return(Json(new { Success = true, Result = new WishlistFullJsonModel { Info = new WishlistJsonModel { ID = wl.WishlistId, Title = wl.WishlistTitle, IsPublic = wl.IsPublic }, WishlistItems = new WishlistItemJsonModel[] { } } })); } }
public ActionResult ChangeWishlist(WishlistJsonModel model) { using (var db = new WishlistContext()) { var wl = db.Wishlists.FirstOrDefault(wl2 => wl2.WishlistId == model.ID); if (wl == null) { return(Json(new { Success = false, Exception = "Invalid wishlist id." })); } else if (wl.UserId != WebSecurity.CurrentUserId) { return(Json(new { Success = false, Exception = "Change requested by an unauthorized user." })); } else { wl.WishlistTitle = model.Title; wl.IsPublic = model.IsPublic; db.SaveChanges(); return(Json(new { Success = true })); } } }
public ActionResult GetFriends(int userId) { using (var db = new WishlistContext()) { var upperFriends = from fs in db.Friendships where fs.UserIdLower == userId join u in db.UserProfiles on fs.UserIdUpper equals u.UserId select new { u.UserId, u.UserName }; var lowerFriends = from fs in db.Friendships where fs.UserIdUpper == userId join u in db.UserProfiles on fs.UserIdLower equals u.UserId select new { u.UserId, u.UserName }; var friends = upperFriends.Concat(lowerFriends) .AsEnumerable() .Select(u => new UserInfoJsonModel { ID = u.UserId, UserName = u.UserName }); return(Json(friends)); } }
public Usuarios BuscarUsuarioPorId(int id) { using (WishlistContext ctx = new WishlistContext()) { return(ctx.Usuarios.Find(id)); } }
public List <Usuarios> Listar() { using (WishlistContext ctx = new WishlistContext()) { return(ctx.Usuarios.ToList()); } }
public ActionResult ChangeProfilePhoto(HttpPostedFileBase image) { using (var db = new WishlistContext()) { var userID = WebSecurity.CurrentUserId; var user = db.webpages_Membership.FirstOrDefault(u => u.UserId == userID); if (user == null) { ModelState.AddModelError("", "The current user does not exist."); return(View()); } else { try { var origImg = new Image(image.InputStream); var img128 = origImg.Resize(128, 128).SerializeJpeg(); var img32 = origImg.Resize(32, 32).SerializeJpeg(); user.ProfilePicture128 = img128; user.ProfilePicture32 = img32; db.SaveChanges(); return(RedirectToAction("Manage", new { Message = ManageMessageId.ChangeProfilePhotoSuccess })); } catch (Exception ex) { ModelState.AddModelError("", ex.Message); return(View()); } } } }
public List <Verbos> ListarTodosVerbos() { using (WishlistContext ctx = new WishlistContext()) { return(ctx.Verbos.ToList()); } }
public Usuarios BuscarPorEmailESenha(string email, string senha) { using (WishlistContext ctx = new WishlistContext()) { Usuarios usuarioProcurado = ctx.Usuarios.FirstOrDefault(x => x.Email == email && x.Senha == senha); return(usuarioProcurado); } }
public void Cadastrar(Usuarios usuario) { using (WishlistContext ctx = new WishlistContext()) { ctx.Add(usuario); ctx.SaveChanges(); } }
public void DeletarDesejo(Desejos desejo) { using (WishlistContext ctx = new WishlistContext()) { ctx.Desejos.Remove(desejo); ctx.SaveChanges(); } }
public void CadastrarDesejo(Desejos desejo) { using (WishlistContext ctx = new WishlistContext()) { ctx.Desejos.Add(desejo); ctx.SaveChanges(); } }
public Desejos BuscarDesejoPorId(int id) { using (WishlistContext ctx = new WishlistContext()) { return(ctx.Desejos .Include(x => x.IdUsuarioNavigation) .FirstOrDefault(x => x.Id == id)); } }
public void Cadastrar(Desejos desejo) { desejo.Datacriacao = DateTime.Now; using (WishlistContext ctx = new WishlistContext()) { ctx.Desejos.Add(desejo); ctx.SaveChanges(); } }
public void Deletar(int id) { using (WishlistContext ctx = new WishlistContext()) { Desejos desejo = ctx.Desejos.Find(id); ctx.Desejos.Remove(desejo); ctx.SaveChanges(); } }
public List <DesejosViewModel> ListarDesejosPorVerbo(string verboNome) { using (WishlistContext ctx = new WishlistContext()) { return(TranformarEmDesejosViewModel(ctx.Desejos .Where(x => x.IdVerboNavigation.Nome == verboNome) .Include(x => x.IdUsuarioNavigation) .ToList())); } }
public void Deletar(int id) { using (WishlistContext ctx = new WishlistContext()) { Usuarios usuarioProcurado = ctx.Usuarios.Find(id); ctx.Usuarios.Remove(usuarioProcurado); ctx.SaveChanges(); } }
public List <DesejosViewModel> ListarTodosDesejos() { using (WishlistContext ctx = new WishlistContext()) { return(TranformarEmDesejosViewModel(ctx.Desejos .Include(x => x.IdUsuarioNavigation) .Include(x => x.IdVerboNavigation) .ToList())); } }
public Desejos BuscaDesejoId(int id) { using (WishlistContext ctx = new WishlistContext()) { Desejos desejoProcurado = ctx.Desejos.Include(x => x.IdusuarioNavigation).FirstOrDefault(x => x.Id == id); if (desejoProcurado == null) { return(null); } return(desejoProcurado); } }
public Usuarios BuscarPorId(int id) { using (WishlistContext ctx = new WishlistContext()) { Usuarios usuarioProc = ctx.Usuarios.Find(id); if (usuarioProc == null) { return(null); } return(usuarioProc); } }
public ActionResult RoleCreate(string roleName) { using (var context = new WishlistContext()) { var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); roleManager.Create(new IdentityRole(roleName)); context.SaveChanges(); } ViewBag.ResultMessage = "Role created successfully !"; return(RedirectToAction("RoleIndex", "Account")); }
// [Authorize(Roles = "Admin")] public ActionResult RoleIndex() { List <string> roles; using (var context = new WishlistContext()) { var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); roles = (from r in roleManager.Roles select r.Name).ToList(); } return(View(roles.ToList())); }
//[AllowAnonymous] public ActionResult ViewUser(UserInfoIDModel ureq) { using (var db = new WishlistContext()) { var userProfile = db.UserProfiles.FirstOrDefault(u => u.UserId == ureq.ID); var userModel = new UserInfoJsonModel { ID = ureq.ID, UserName = userProfile == null ? "" : userProfile.UserName }; return(View(userModel)); } }
public void AtualizarDesejo(Desejos desejoCadastrado, Desejos desejoNovo) { if (desejoNovo.Descricao != null) { desejoCadastrado.Descricao = desejoNovo.Descricao; } desejoCadastrado.DataCriacao = DateTime.Now; using (WishlistContext ctx = new WishlistContext()) { ctx.Desejos.Update(desejoCadastrado); ctx.SaveChanges(); } }
public ActionResult DeleteRoleForUser(string userName, string roleName) { List <string> userRoles; List <string> roles; List <string> users; using (var context = new WishlistContext()) { var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); roles = (from r in roleManager.Roles select r.Name).ToList(); var userStore = new UserStore <WishlistUser>(context); var userManager = new UserManager <WishlistUser>(userStore); users = (from u in userManager.Users select u.UserName).ToList(); var user = userManager.FindByName(userName); if (user == null) { throw new Exception("User not found!"); } if (userManager.IsInRole(user.Id, roleName)) { userManager.RemoveFromRole(user.Id, roleName); context.SaveChanges(); ViewBag.ResultMessage = "Role removed from this user successfully !"; } else { ViewBag.ResultMessage = "This user doesn't belong to selected role."; } var userRoleIds = (from r in user.Roles select r.RoleId); userRoles = (from id in userRoleIds let r = roleManager.FindById(id) select r.Name).ToList(); } ViewBag.RolesForThisUser = userRoles; ViewBag.Roles = new SelectList(roles); ViewBag.Users = new SelectList(users); return(View("RoleAddToUser")); }
//[ValidateAntiForgeryToken] public ActionResult RoleAddToUser(string roleName, string userName) { List <string> roles; List <string> users; using (var context = new WishlistContext()) { var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); var userStore = new UserStore <WishlistUser>(context); var userManager = new UserManager <WishlistUser>(userStore); users = (from u in userManager.Users select u.UserName).ToList(); var user = userManager.FindByName(userName); if (user == null) { throw new Exception("User not found!"); } var role = roleManager.FindByName(roleName); if (role == null) { throw new Exception("Role not found!"); } if (userManager.IsInRole(user.Id, role.Name)) { ViewBag.ResultMessage = "This user already has the role specified !"; } else { userManager.AddToRole(user.Id, role.Name); context.SaveChanges(); ViewBag.ResultMessage = "Username added to the role succesfully !"; } roles = (from r in roleManager.Roles select r.Name).ToList(); } ViewBag.Roles = new SelectList(roles); ViewBag.Users = new SelectList(users); return(View()); }
public ActionResult SearchUser(string userNameQuery) { using (var db = new WishlistContext()) { var users = db.UserProfiles .Where(u => u.UserName.Contains(userNameQuery)) .AsEnumerable() .Select(u => new UserInfoJsonModel { ID = u.UserId, UserName = u.UserName, }); return(Json(users)); } }
public ActionResult NewWishlistItem(WishlistIDModel wlreq) { using (var db = new WishlistContext()) { var wl = db.Wishlists.FirstOrDefault(wl2 => wl2.WishlistId == wlreq.ID); if (wl == null) { return(Json(new { Success = false, Exception = "Invalid wishlist id." })); } else if (wl.UserId != WebSecurity.CurrentUserId) { return(Json(new { Success = false, Exception = "Add requested by an unauthorized user." })); } else { var wli = new Models.WishlistItem { WishlistId = wl.WishlistId, WishlistItemContent = "New Wishlist Item" }; db.WishlistItems.Add(wli); db.SaveChanges(); return(Json(new { Success = true, Result = new WishlistItemJsonModel { ID = wli.WishlistItemId, Content = wli.WishlistItemContent } })); } } }