public tblPost AddPost(tblPost post)
{
try
{
using (BetweenUsEntities context = new BetweenUsEntities())
{
if (post.PostID == 0)
{
tblPost newPost = new tblPost
{
PostID = post.PostID,
PostText = post.PostText,
DateTimePost = post.DateTimePost,
VisiblePost = post.VisiblePost,
UserPost = post.UserPost
};
context.tblPosts.Add(newPost);
context.SaveChanges();
post.PostID = newPost.PostID;
return(post);
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
public List <Tuple <string, string, string, string, DateTime> > GetMyPost(int id)
{
try
{
using (BetweenUsEntities context = new BetweenUsEntities())
{
List <Tuple <string, string, string, string, DateTime> > list = new List <Tuple <string, string, string, string, DateTime> >();
list = (
from a in context.tblPosts
join c in context.tblUsers
on a.UserPost equals c.UserID
where c.UserID == id
orderby a.DateTimePost descending
select(new { a.PostText, c.UserName, c.UserSurname, c.UserUsername, a.DateTimePost })
)
.AsEnumerable()
.Select(t =>
new Tuple <string, string, string, string, DateTime>(t.PostText, t.UserName, t.UserSurname, t.UserUsername, t.DateTimePost))
.ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblUser AddUser(tblUser user)
{
try
{
using (BetweenUsEntities context = new BetweenUsEntities())
{
if (user.UserID == 0)
{
tblUser newUser = new tblUser
{
UserID = user.UserID,
UserName = user.UserName,
UserSurname = user.UserSurname,
UserUsername = user.UserUsername,
UserPassword = user.UserPassword,
DateOfBirth = user.DateOfBirth,
VisibleDate = user.VisibleDate,
Gender = user.Gender,
VisibleGender = user.VisibleGender
};
context.tblUsers.Add(newUser);
context.SaveChanges();
user.UserID = newUser.UserID;
return(user);
}
else
{
tblUser userToEdit = (from r in context.tblUsers where r.UserID == user.UserID select r).First();
userToEdit.UserID = user.UserID;
userToEdit.UserName = user.UserName;
userToEdit.UserSurname = user.UserSurname;
userToEdit.UserUsername = user.UserUsername;
userToEdit.UserPassword = user.UserPassword;
userToEdit.DateOfBirth = user.DateOfBirth;
userToEdit.VisibleDate = user.VisibleDate;
userToEdit.Gender = user.Gender;
userToEdit.VisibleGender = user.VisibleGender;
context.SaveChanges();
return(user);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Gets all posts from view vwPost in database.
/// </summary>
/// <returns></returns>
public List <vwPost> GetAllPosts()
{
try
{
using (BetweenUsEntities context = new BetweenUsEntities())
{
return((from l in context.vwPosts select l).ToList());
}
}
catch
{
return(null);
}
}
/// <summary>
/// Adds new post to tblPost in database.
/// </summary>
/// <param name="account"></param>
/// <param name="text"></param>
public void Post(tblAccount account, string text)
{
using (BetweenUsEntities context = new BetweenUsEntities())
{
tblPost post = new tblPost
{
AccountID = account.AccountID,
Content = text,
PostTime = DateTime.Now,
LikesNumber = 0
};
context.tblPosts.Add(post);
context.SaveChanges();
}
}
/// <summary>
/// Adds new account to a database table.
/// </summary>
/// <param name="account"></param>
public void AddAccount(tblAccount account)
{
using (BetweenUsEntities context = new BetweenUsEntities())
{
tblAccount newAccount = new tblAccount
{
FirstName = account.FirstName,
LastName = account.LastName,
Gender = account.Gender,
UserName = account.UserName,
Pass = account.Pass
};
context.tblAccounts.Add(newAccount);
context.SaveChanges();
}
}
public List <tblUser> GetAllUserSurname(string surname)
{
try
{
using (BetweenUsEntities context = new BetweenUsEntities())
{
List <tblUser> list = new List <tblUser>();
list = (from e in context.tblUsers where e.UserSurname == surname orderby e.UserUsername ascending select e).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblUser GetAllUserID(int ID)
{
try
{
using (BetweenUsEntities context = new BetweenUsEntities())
{
tblUser user = (from e in context.tblUsers where e.UserID == ID select e).First();
return(user);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Checks if account with username and password exists in tblAccount in database BetweenUs.
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public bool IsUser(string username, string password, out tblAccount account)
{
try
{
using (BetweenUsEntities context = new BetweenUsEntities())
{
tblAccount accountToLogIn = (from a in context.tblAccounts where a.UserName == username && a.Pass == password select a).First();
account = accountToLogIn;
return(true);
}
}
catch
{
account = null;
return(false);
}
}
public tblUser GetUserUsername(string username)
{
try
{
using (BetweenUsEntities context = new BetweenUsEntities())
{
string usernameFromDB = (from e in context.tblUsers where e.UserUsername == username select e.UserUsername).FirstOrDefault();
if (username == usernameFromDB)
{
return((from e in context.tblUsers where e.UserUsername == username select e).FirstOrDefault());
}
return(null);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public void Like(vwPost post, tblAccount account)
{
using (BetweenUsEntities context = new BetweenUsEntities())
{
try
{
tblLike like = (from l in context.tblLikes where l.PostID == post.PostID && l.AccountID == account.AccountID select l).First();
MessageBox.Show("You already like this post");
}
catch
{
tblLike like = new tblLike
{
PostID = post.PostID,
AccountID = account.AccountID
};
context.tblLikes.Add(like);
tblPost postToLike = (from p in context.tblPosts where p.PostID == post.PostID select p).First();
postToLike.LikesNumber++;
context.SaveChanges();
}
}
}
