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); }