public int Delete(CustomerFeedbackModel model)
{
string sqlDelete = "DELETE FROM CustomerFeedback WHERE Id = @Id";
using (_connection)
{
return(_connection.Execute(sqlDelete, model));
}
}
public int Update(CustomerFeedbackModel model)
{
string sqlUpdate = "UPDATE CustomerFeedback SET Grade = @Grade, Description = @Description," +
" CustomerId = @CustomerId, CarId = @CarId WHERE Id = @Id";
using (_connection)
{
return(_connection.Execute(sqlUpdate, model));
}
}
public int Insert(CustomerFeedbackModel model)
{
string sqlInsert = "INSERT INTO CustomerFeedback (Id, Grade, Description, CustomerId, CarId)" +
"Values (@Id, @Grade, @Description, @CustomerId, @CarId)";
using (_connection)
{
return(_connection.Execute(sqlInsert, model));
}
}
public JsonResult Delete([FromBody] CustomerFeedbackModel customerFeedbackModel)
{
_repsitory.DeleteCustomerFeedback(new CustomerFeedback
{
MovieId = customerFeedbackModel.MovieId,
CustomerMailAddress = User.Identity.Name,
Comment = customerFeedbackModel.Comment,
Rating = customerFeedbackModel.Rating,
FeedbackDate = DateTime.Now
});
return(Json(customerFeedbackModel));
}
/// <summary>
/// Method whose purpose is to insert
/// a new customer feedback record into
/// the database.
/// </summary>
/// <param name="customerFeedback">
/// Newly created customer feedback
/// model object.
/// </param>
/// <returns>Returns true if the query is
/// successfully executed otherwise
/// returns false.
/// </returns>
public bool Insert(CustomerFeedbackModel customerFeedback)
{
return(_customerFeedbackRepository.Insert(customerFeedback) > 0 ? true : false);
}
/// <summary>
/// Method whose purpose is to delete existing
/// customer feedback record from the database.
/// </summary>
/// <param name="customerFeedback">
/// Existing customer feedback model object.
/// </param>
/// <returns>
/// Returns true if the query is successfully
/// executed otherwise returns false.
/// </returns>
public bool Delete(CustomerFeedbackModel customerFeedback)
{
return(_customerFeedbackRepository.Delete(customerFeedback) > 0 ? true : false);
}
