private static bool CheckIfCommentCanBeAdded(Workshop_Comments comment)
{
// TODO:
// Check if there is any sense in here
// I have no idea if it works correctly xD
var mustBeOlderThat = DateTime.Now.AddDays(-minTimeBetweenCommentsInDays);
var db = new ITAPPCarWorkshopServiceDBEntities();
if (!db.Workshop_Comments.Any(n => n.Workshop_ID == comment.Workshop_ID && n.Client_ID == comment.Client_ID))
{
return(true);
}
var list = db.Workshop_Comments.Where(n => n.Workshop_ID == comment.Workshop_ID && n.Client_ID == comment.Client_ID).OrderByDescending(n => n.Comment_date).ToList();
var lastCommentDate = list.First().Comment_date;
if (lastCommentDate < mustBeOlderThat)
{
return(true);
}
return(false);
}
public static void EditComment(Workshop_Comments editedComment)
{
// TODO:
// check if the comment exists - method - may throw exception
// get the comment to be edited
// edit the comment to be edited
// save changes to DB
// return the result
// remember about mutex
}
public static void AddComment(Workshop_Comments newComment)
{
// TODO:
// check if the user has already added a comment of the workshop in last XXX hours/days/weeks/months - method - may throw exception
// check if user exists - method from user manager - may throw exception
// check if workshop exists - method from workshop profile manager - may throw exception
// add a new comment to DB
// return the result
// remember about mutex
}
public Response_String Add_Comment([FromBody] Workshop_Comments New_Comment)
{
using (var db = new ITAPPCarWorkshopServiceDBEntities())
{
db.Workshop_Comments.Add(New_Comment);
db.SaveChanges();
return(new Response_String()
{
Response = "Item was added"
});
}
}
public Response_String Modify_Comment([FromBody] Workshop_Comments Modify_Comment)
{
using (var db = new ITAPPCarWorkshopServiceDBEntities())
{
var Old = db.Workshop_Comments.FirstOrDefault(p => Modify_Comment.Comment_ID == p.Comment_ID);
if (Old != null)
{
var ID = Old.Comment_ID;
Old = Modify_Comment;
Old.Comment_ID = ID;
db.SaveChanges();
return(new Response_String()
{
Response = "Item was modify"
});
}
return(new Response_String()
{
Response = "Item does not exsists"
});
}
}
