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 UserModel GetUserByLogin(string name, string password) { if (name.Equals("")) { throw new ArgumentOutOfRangeException(); } if (password.Equals("")) { throw new ArgumentOutOfRangeException(); } DataTable dt = new DataTable(); UserModel userModel = new UserModel(); using (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(DataQueryStringsSql.ReturnUserByNamePassword(name, password)); } foreach (DataRow ms in dt.Rows) { userModel = UserModel.ToObject(ms); } return(userModel); }
public bool IsFollowedByMe(int followedID, int followerID) { if (followedID < 0) { throw new ArgumentOutOfRangeException(); } if (followerID < 0) { throw new ArgumentOutOfRangeException(); } DataTable dt = new DataTable(); int followed = 0; using (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(DataQueryStringsSql.IsFollowedByMe(followedID, followerID)); } foreach (DataRow ms in dt.Rows) { followed = int.Parse(ms[0].ToString()); } if (followed == 0) { return(false); } else { return(true); } }
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); }