public long Insert(tbl_FeedBack feedBack)
{
feedBack.CreatedDate = DateTime.Now;
feedBack.Status = true;
feedBack.CreatedDate = DateTime.Now;
db.tbl_FeedBack.Add(feedBack);
db.SaveChanges();
return(feedBack.ID);
}
public void Reply(tbl_FeedBack model)
{
object[] parameters =
{
new SqlParameter("@ID", model.ID),
new SqlParameter("@Status", model.Status),
};
_entities.Database.ExecuteSqlCommand("Sp_Feedback_Reply @ID,@Status", parameters);
}
public void Add(tbl_FeedBack model)
{
object[] parameters =
{
new SqlParameter("@FullName", model.FullName),
new SqlParameter("@Phone", model.Phone),
new SqlParameter("@Email", (object)model.Email ?? DBNull.Value),
new SqlParameter("@Title", model.Title),
new SqlParameter("@Contents", model.Contents),
new SqlParameter("@Status", false),
};
_entities.Database.ExecuteSqlCommand("Sp_Feedback_Insert @FullName,@Phone,@Email,@Title,@Contents,@Status", parameters);
}
public void addComment(tbl_FeedBack tbl_FeedBack)
{
try
{
tbl_FeedBack.isDelete = false;
db.tbl_FeedBack.Add(tbl_FeedBack);
db.SaveChanges();
}
catch (Exception ee)
{
throw ee;
}
}
public bool Update(tbl_FeedBack feedBack)
{
try
{
var feed = db.tbl_FeedBack.Find(feedBack.ID);
feed.Name = feedBack.Name;
feed.Phone = feedBack.Phone;
feed.Status = feedBack.Status;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
//Post FeedBack
public ActionResult Comment(tbl_FeedBack tbl_FeedBack)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
_feedBackService.addComment(tbl_FeedBack);
return(Json(new { status = true, message = "Trả lời thành công" }));
}
else
{
return(Json(new { status = false, message = "Trả lời thất bại!" }));
}
}
catch (Exception)
{
return(Json(new { status = false, message = "Trả lời thất bại!" }));
}
}
