public void SendRequest(tblUser sendUser, tblUser recieveUser)
{
try
{
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
tblUser sendUserInDb = (from u in context.tblUsers
where u.UserID == sendUser.UserID
select u).First();
tblUser recieveUserInDb = (from u in context.tblUsers
where u.UserID == recieveUser.UserID
select u).First();
recieveUserInDb.tblUsers.Add(sendUserInDb);
//recieveUserInDb.tblUsers.Add(sendUserInDb);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public UsersViewModel(Users usersView, tblUser userLogedIn)
{
view = usersView;
User = userLogedIn;
userService = new UserService();
var listOfUsers = userService.GetUsers().Where(u => u.UserID != User.UserID).ToList();
UserList = new List <tblUser>();
SelectedUser = listOfUsers.FirstOrDefault();
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
tblUser userInDb = (from x in context.tblUsers
where x.UserID == User.UserID
select x).First();
var list = userInDb.tblUsers.Select(item => item.UserID).ToList();
MessageBox.Show(list.Count.ToString());
foreach (var us in listOfUsers)
{
if (!list.Contains(us.UserID))
{
UserList.Add(us);
}
}
}
SelectedUser = UserList.FirstOrDefault();
}
public tblUser AddUser(tblUser user)
{
try
{
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
tblUser newUser = new tblUser();
newUser.FirstName = user.FirstName;
newUser.LastName = user.LastName;
newUser.Email = user.Email;
newUser.Gender = user.Gender;
newUser.Location = user.Location;
newUser.DateOfBirth = user.DateOfBirth;
newUser.Username = user.Username;
newUser.Password = user.Password;
context.tblUsers.Add(newUser);
context.SaveChanges();
return(newUser);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public void LikePost(tblPost post, tblUser user)
{
try
{
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
tblPost postInDB = (from x in context.tblPosts
where x.PostID == post.PostID
select x).First();
tblUser userInDb = (from x in context.tblUsers
where x.UserID == user.UserID
select x).First();
if (postInDB.NumberOfLikes == null)
{
postInDB.NumberOfLikes = 1;
}
else
{
postInDB.NumberOfLikes += 1;
}
postInDB.tblUsers.Add(userInDb);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public FriendRequestsViewModel(FriendRequests friendRequests, tblUser userLogedIn)
{
view = friendRequests;
User = userLogedIn;
userService = new UserService();
var listOfUsers = userService.GetUsers().Where(u => u.UserID != User.UserID).ToList();
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
tblUser userInDb = (from x in context.tblUsers
where x.UserID == User.UserID
select x).First();
UserList = userInDb.tblUsers.ToList();
}
SelectedUser = UserList.FirstOrDefault();
}
public List <tblUser> GetUsers()
{
try
{
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
List <tblUser> list = new List <tblUser>();
list = (from x in context.tblUsers select x).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblUser GetUserByUserNameAndPassword(string username, string password)
{
try
{
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
tblUser user = (from x in context.tblUsers
where x.Username.Equals(username) &&
x.Password.Equals(password)
select x).First();
return(user);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblUser GetUserById(int id)
{
try
{
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
tblUser user = (from x in context.tblUsers
where x.UserID == id
select x).First();
return(user);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
private bool CanSendRequestExecute()
{
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
if (SelectedUser != null)
{
tblUser userInDb = (from x in context.tblUsers
where x.UserID == SelectedUser.UserID
select x).First();
var list = userInDb.tblUsers.Select(item => item.UserID).ToList();
if (list.Contains(User.UserID))
{
return(false);
}
}
}
return(true);
}
public List <tblUser> UsersThatLikedPost(int id)
{
try
{
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
tblPost postInDB = (from x in context.tblPosts
where x.PostID == id
select x).First();
return(postInDB.tblUsers.ToList());
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
private void AcceptExecute()
{
try
{
userService.AcceptRequest(SelectedUser, User);
string friend = SelectedUser.Username;
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
tblUser userInDb = (from x in context.tblUsers
where x.UserID == User.UserID
select x).First();
UserList = userInDb.tblUsers.ToList();
}
Thread.Sleep(1000);
string str = string.Format("You are now friend with {0} .", friend);
MessageBox.Show(str);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public List <tblUser> GetFriends(tblUser user)
{
try
{
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
tblUser userInDb = (from x in context.tblUsers
where x.UserID == user.UserID
select x).First();
List <tblUser> list = new List <tblUser>();
list = userInDb.tblUsers1.ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblPost AddPost(tblPost post)
{
try
{
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
tblPost newPost = new tblPost();
newPost.PostText = post.PostText;
newPost.DateOfPost = DateTime.Now;
newPost.UserID = post.UserID;
context.tblPosts.Add(newPost);
context.SaveChanges();
return(newPost);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
