public async Task <User> UpdateUser(User user)
{
try
{
using (var context = new UserDatabaseEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
var bdUser = await context.User.FindAsync(user.Id);
var userToReturn = new User();
if (bdUser != null)
{
context.Entry(bdUser).CurrentValues.SetValues(user);
await context.SaveChangesAsync();
userToReturn = await context.User.FindAsync(user.Id);
}
else
{
userToReturn = null;
}
return(userToReturn);
}
}
catch (Exception ex)
{
return(null);
}
}
public async Task <bool> DeleteUser(Guid userId)
{
try
{
using (var context = new UserDatabaseEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
var bdUser = await context.User.FindAsync(userId);
if (bdUser != null)
{
context.User.Remove(bdUser);
await context.SaveChangesAsync();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
return(false);
}
}
public async Task <User> GetUserByNameAndPassword(string name, string password)
{
try
{
using (var context = new UserDatabaseEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
var user = context.User.Where(u => u.Name.ToLower().Equals(name.ToLower()) && u.Password.ToLower().Equals(password.ToLower())).FirstOrDefault();
return(user);
}
}
catch (Exception ex)
{
return(null);
}
}
public async Task <User> GetUserById(Guid id)
{
try
{
using (var context = new UserDatabaseEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
var user = await context.User.FindAsync(id);
return(user);
}
}
catch (Exception ex)
{
return(null);
}
}
public async Task <List <User> > GetAllUsers()
{
try
{
using (var context = new UserDatabaseEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
var users = context.User.ToList();
return(users);
}
}
catch (Exception ex)
{
throw;
}
}
public ActionResult SocialEngineeringFive()
{
UserDatabaseEntities1 nd = new UserDatabaseEntities1();
return(View(nd.Fun_Quiz()));
}
