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