public List <Report> GetReportList(bool onlyNotResolved)
{
List <Report> reportList = new List <Report>();
using (var db = new SolvrContext())
{
var Query = from report in db.Reports where report.IsResolved == false select report;
foreach (Report item in Query)
{
reportList.Add(item);
}
if (!onlyNotResolved)
{
Query = from report in db.Reports where report.IsResolved == true select report;
foreach (Report item in Query)
{
reportList.Add(item);
}
}
}
return(reportList);
}
public Post GetPost(int id)
{
using (var db = new SolvrContext())
{
return((from post in db.Posts where post.Id == id select post).First());
}
}
public User GetUser(int id)
{
using (var db = new SolvrContext())
{
return((from user in db.Users where user.Id == id select user).First());
}
}
public Report GetReport(int id)
{
using (var db = new SolvrContext())
{
return((from report in db.Reports where report.Id == id select report).First());
}
}
public Report InsertReport(Report report)
{
using (var db = new SolvrContext())
{
db.Reports.InsertOnSubmit(report);
db.SubmitChanges();
}
return(report);
}
public Post InsertPost(Post post)
{
using (var db = new SolvrContext())
{
db.Posts.InsertOnSubmit(post);
db.SubmitChanges();
}
return(post);
}
public Comment InsertComment(Comment comment)
{
using (var db = new SolvrContext())
{
db.Comments.InsertOnSubmit(comment);
db.SubmitChanges();
}
return(comment);
}
public Comment UpdateComment(Comment comment)
{
try
{
if (comment.CommentType.Equals("Comment"))
{
using (var db = new SolvrContext())
{
var Query = (from comm in db.Comments where comm.Id == comment.Id && comm.LastEdited == comment.LastEdited select comm).First();
Query.Text = comment.Text;
Query.IsDisabled = comment.IsDisabled;
Query.LastEdited = DateTime.Now;
db.SubmitChanges();
}
return(comment);
}
else
{
SolvrComment solvrComment = (SolvrComment)comment;
using (var db = new SolvrContext())
{
var Query = (from solvrComm in db.Comments.OfType <SolvrComment>() where solvrComm.Id == comment.Id && solvrComm.LastEdited == comment.LastEdited select solvrComm).First();
Query.IsAccepted = solvrComment.IsAccepted;
Query.TimeAccepted = solvrComment.TimeAccepted;
Query.Text = solvrComment.Text;
Query.IsDisabled = solvrComment.IsDisabled;
Query.LastEdited = DateTime.Now;
db.SubmitChanges();
}
return(solvrComment);
}
}
catch (Exception e)
{
//if an exception occurs this checks if there even is a comment with the ID, if there is then ít has been changed from another place.
using (var db = new SolvrContext())
{
var Query = from comm in db.Comments where comm.Id == comment.Id select comm;
if (Query.Count() == 0)
{
//Concurrency error
throw new NotImplementedException();
}
else
{
//Standard error
throw new NotImplementedException();
}
}
}
}
public Report UpdateReport(Report report)
{
using (var db = new SolvrContext())
{
var Query = (from rep in db.Reports where rep.Id == report.Id select rep).First();
Query.Title = report.Title;
Query.Description = report.Description;
Query.IsResolved = report.IsResolved;
db.SubmitChanges();
}
return(report);
}
public Comment GetComment(int id)
{
try
{
using (var db = new SolvrContext())
{
return((from comment in db.Comments where comment.Id == id select comment).First());
}
}
catch (Exception)
{
throw new FaultException("0918 - 57 - No comment exists with the given ID");
}
}
public Category GetCategory(int id)
{
try
{
using (var db = new SolvrContext())
{
return((from category in db.Categories where category.Id == id select category).First());
}
}
catch (Exception)
{
throw new FaultException("0918 - 42 - No category exists with the given ID");
}
}
public User GetUser(string username)
{
try
{
using (var db = new SolvrContext())
{
return((from user in db.Users where user.Username == username select user).First());
}
}
catch (Exception)
{
throw new FaultException("0918 - 87 - No user exists with the given ID");
}
}
public bool DatabaseExists()
{
try
{
using (var db = new SolvrContext())
{
return(db.DatabaseExists());
}
}
catch (Exception)
{
throw new FaultException("0919 - 25 - No connection to the Database.");
}
}
public List <Vote> GetVoteList(int commentId)
{
List <Vote> voteList = new List <Vote>();
using (var db = new SolvrContext())
{
var Query = from vote in db.Votes select vote;
foreach (Vote item in Query)
{
voteList.Add(item);
}
}
return(voteList);
}
public List <Post> GetPostList(int offSet, int loadCount)
{
List <Post> postList = new List <Post>();
using (var db = new SolvrContext())
{
var Query = from post in db.Posts.OrderByDescending(b => b.BumpTime).Skip(offSet).Take(loadCount) where post.IsDisabled == false select post;
foreach (Post item in Query)
{
postList.Add(item);
}
}
return(postList);
}
public List <Category> GetCategoryList()
{
List <Category> categoryList = new List <Category>();
using (var db = new SolvrContext())
{
var Query = from category in db.Categories select category;
foreach (Category item in Query)
{
categoryList.Add(item);
}
}
return(categoryList);
}
public List <Comment> GetCommentList(int postId)
{
List <Comment> commentList = new List <Comment>();
using (var db = new SolvrContext())
{
var Query = from comment in db.Comments where comment.PostId == postId select comment;
foreach (Comment item in Query)
{
commentList.Add(item);
}
}
return(commentList);
}
public User InsertUser(User user)
{
try
{
using (var db = new SolvrContext())
{
db.Users.InsertOnSubmit(user);
db.SubmitChanges();
}
return(user);
}
catch (Exception e)
{
throw new FaultException(e.Message);
}
}
public Post UpdatePost(Post post)
{
try
{
if (post.PostType.Equals("Post"))
{
using (var db = new SolvrContext())
{
var Query = (from pos in db.Posts where pos.Id == post.Id && pos.LastEdited == post.LastEdited select pos).First();
Query.Title = post.Title;
Query.Description = post.Description;
Query.BumpTime = post.BumpTime;
Query.CategoryId = post.CategoryId;
Query.IsDisabled = post.IsDisabled;
//Somewhere in MVC, miliseconds gets erased, so here it is just removed entirely.
DateTime dt = DateTime.Now;
Query.LastEdited = dt.AddMilliseconds(-dt.Millisecond);
db.SubmitChanges();
}
return(post);
}
else
{
PhysicalPost physicalPost = (PhysicalPost)post;
using (var db = new SolvrContext())
{
var Query = (from physPost in db.Posts.OfType <PhysicalPost>() where physPost.Id == physicalPost.Id && physPost.LastEdited == post.LastEdited select physPost).First();
Query.Title = physicalPost.Title;
Query.Description = physicalPost.Description;
Query.BumpTime = physicalPost.BumpTime;
Query.CategoryId = physicalPost.CategoryId;
Query.IsDisabled = physicalPost.IsDisabled;
Query.IsLocked = physicalPost.IsLocked;
Query.AltDescription = physicalPost.AltDescription;
Query.Zipcode = physicalPost.Zipcode;
Query.Address = physicalPost.Address;
//Somewhere in MVC, miliseconds gets erased, so here it is just removed entirely.
DateTime dt = DateTime.Now;
Query.LastEdited = dt.AddMilliseconds(-dt.Millisecond);
db.SubmitChanges();
}
return(physicalPost);
}
}
catch (Exception e)
{
//if an exception occurs this checks if there even is a comment with the ID, if there is then ít has been changed from another place.
using (var db = new SolvrContext())
{
//another query to see if a post with the postId actually exists
var Query = from pos in db.Posts where pos.Id == post.Id select pos;
//Query is a form of collection so we can check how many objects that is returned.
if (Query.Count() > 0)
{
//Concurrency error
throw new FaultException("0917 - 316 - Edit timer Mismatch");
}
else
{
throw new FaultException("0918 - 320 - A post with the ID doesnt exists");
}
}
//Standard error
throw new FaultException("0916 - 327 - Something went wrong");
}
}
