public static List<CommentSection> GetAllCommentSectionsForComment(Comment aComment)
{
PortugalVillasContext _db = new PortugalVillasContext();
List<CommentSection> theCommentSections = new List<CommentSection>();
theCommentSections = _db.CommentSections.Where(x => x.CommentID == aComment.CommentID).ToList();
return theCommentSections;
}
public void Create(FormCollection theFormCollection)
{
Comment comment = new Comment();
comment.WhenCreated = DateTime.Now;
comment.Username = theFormCollection["Username"];
comment.StarRating = 1;
comment.PropertyID = Convert.ToInt64(theFormCollection["PropertyID"]);
try
{
var date = DateTime.ParseExact(theFormCollection["StartdateOfStay"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
comment.StartdateOfStay = date;
}
catch (Exception ex)
{
}
if (theFormCollection["StarRating"].ToString() != "")
{
comment.StarRating = Convert.ToInt32(theFormCollection["StarRating"]);
}
comment.Text = theFormCollection["Text"];
try
{
if (ModelState.IsValid)
{
comment.Approved = true;
//comment.WhenCreated = DateTime.Now;
db.Comments.Add(comment);
db.SaveChanges();
}
}
catch (DbEntityValidationException dataValidationException)
{
//do nothing
}
catch (Exception ex)
{
throw ex;
}
string RootURL = Request.Url.Authority;
RootURL += "/Home/FullPropertyResult?PropertyID=" + comment.PropertyID;
Response.Redirect("http://" + RootURL);
}
public ActionResult Edit(Comment comment)
{
if (ModelState.IsValid)
{
db.Entry(comment).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.PropertyID = new SelectList(db.Properties, "PropertyID", "LegacyReference", comment.PropertyID);
return View(comment);
}