public User GetUser(int id)
{
try
{
using (var ctx = new FollowersDBContext())
{
var user = ctx.Users.Find(id);
return(user);
}
}
catch (Exception e)
{
throw;
}
}
public List <UserDetails> GetUsers()
{
try
{
using (var ctx = new FollowersDBContext())
{
var usersList = ctx.Database.SqlQuery <UserDetails>("exec sp_GetUsersTbl").ToList();
return(usersList);
}
}
catch (Exception ex)
{
//Log exception
throw;
}
}
public void UpdateUsers(int user, int userToFollow)
{
try
{
using (var ctx = new FollowersDBContext())
{
var rowsEffected = ctx.Database.ExecuteSqlCommand(
"sp_UpdateFollowers @userId, @followingUserId",
new SqlParameter("userId", user),
new SqlParameter("followingUserId", userToFollow)
);
}
}
catch (Exception ex)
{
//Log exception
throw;
}
}
