public static UserForTableModel ToObject(DataRow reader)
{
UserForTableModel userForTableModel = new UserForTableModel();
userForTableModel.userID = int.Parse(reader[0].ToString());
userForTableModel.userName = reader[1].ToString();
userForTableModel.groupName = reader[2].ToString();
userForTableModel.userNumberOfFollowers = int.Parse(reader[3].ToString());
try
{
userForTableModel.followedByMe = int.Parse(reader[4].ToString()) > 0;
}
catch (Exception ex)
{
Debug.WriteLine("trying to parse mysql followedByMe: " + ex.Message);
}
try
{
userForTableModel.followedByMe = bool.Parse(reader[4].ToString());
}
catch (Exception ex)
{
Debug.WriteLine("trying to parse mssql followedByMe: " + ex.Message);
}
Debug.WriteLine("userForTableModel:" + userForTableModel.ToString());
return(userForTableModel);
}
public UserForTableModel DeleteFollower(int followedID, int followerID)
{
if (followedID < 0)
{
throw new ArgumentOutOfRangeException();
}
if (followerID < 0)
{
throw new ArgumentOutOfRangeException();
}
DataTable dt = new DataTable();
UserForTableModel userModel = new UserForTableModel();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(DataQueryStringsSql.DeleteFollower(followedID, followerID));
}
foreach (DataRow ms in dt.Rows)
{
userModel = UserForTableModel.ToObject(ms);
}
return(userModel);
}
public UserForTableModel GetOneUserForTableById(int followerID, int followedID)
{
if (followerID < 0)
{
throw new ArgumentOutOfRangeException();
}
if (followedID < 0)
{
throw new ArgumentOutOfRangeException();
}
var resultQuary = from users in _users.AsQueryable()
join groups in _group.AsQueryable() on users.userGroupId equals groups.groupID into joinedGroups
where (users.userID == followedID)
select new UserForTableModel
{
userID = users.userID,
userName = users.userName,
groupName = joinedGroups.First().groupName,
userNumberOfFollowers = users.userNumberOfFollowers
};
UserForTableModel userForTableModel = resultQuary.SingleOrDefault();
userForTableModel.followedByMe = IsFollowedByMe(followedID, followerID);
return(userForTableModel);
}
public HttpResponseMessage GetOneUserForTableById(int followedID)
{
try
{
int followerID = int.Parse(base.ControllerContext.RequestContext.Principal.Identity.Name);
UserForTableModel user = userRepository.GetOneUserForTableById(followerID, followedID);
return(Request.CreateResponse(HttpStatusCode.OK, user));
}
catch (Exception ex)
{
Errors errors = ErrorsHelper.GetErrors(ex);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, errors));
}
}
public List <UserForTableModel> GetUsersForTable(int myId)
{
DataTable dt = new DataTable();
List <UserForTableModel> arrUsers = new List <UserForTableModel>();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(DataQueryStringsSql.GetUsersForTable(myId));
}
foreach (DataRow ms in dt.Rows)
{
arrUsers.Add(UserForTableModel.ToObject(ms));
}
return(arrUsers);
}