public bool DeleteEvaluation(Evaluation_ evaluation) { using (MFDatabaseEntities moodFullDb = new MFDatabaseEntities()) { try { int evaluationID = Convert.ToInt32(evaluation.EvaluationId); Evaluation xe = moodFullDb.Evaluations.Single(x => x.EvaluationId == evaluationID); moodFullDb.Evaluations.Remove(xe); moodFullDb.SaveChanges(); return(true); } catch { return(false); } } }
public bool EditEvaluation(Evaluation_ evaluation) { using (MFDatabaseEntities moodFullDb = new MFDatabaseEntities()) { try { int evaluationId = Convert.ToInt32(evaluation.EvaluationId); Evaluation xe = moodFullDb.Evaluations.Single(x => x.EvaluationId == evaluationId); xe.UserId = evaluation.UserId; xe.RestaurantId = evaluation.RestaurantId; xe.MoodRating = evaluation.MoodRating; xe.Price = evaluation.Price; xe.Experience = evaluation.Experience; moodFullDb.SaveChanges(); return(true); } catch { return(false); } }; }
public bool CreateEvaluation(Evaluation_ evaluation) { using (MFDatabaseEntities moodFullDb = new MFDatabaseEntities()) { try { Evaluation xe = new Evaluation(); xe.UserId = evaluation.UserId; xe.RestaurantId = evaluation.RestaurantId; xe.MoodRating = evaluation.MoodRating; xe.Price = evaluation.Price; xe.Experience = evaluation.Experience; moodFullDb.Evaluations.Add(xe); moodFullDb.SaveChanges(); return(true); } catch { return(false); } } }