public BeerCollection UpdateBeerCollection(int id, string name, int type, int rating)
        {
            try
            {
                using (BeerCollectionEntities db = new BeerCollectionEntities())
                {
                    var beer = db.BeerCollections.FirstOrDefault(b => b.ID == id);
                    if (beer != null)
                    {
                        beer.NAME   = name;
                        beer.TYPE   = type;
                        beer.RATING = rating;

                        if (db.SaveChanges() > 0)
                        {
                            return(db.BeerCollections.FirstOrDefault(b => b.ID == id));
                        }
                    }
                }
            }
            catch (Exception ex)
            {
            }
            return(new BeerCollection());
        }
        public string DeleteBeerCollection(int id)
        {
            try
            {
                using (BeerCollectionEntities db = new BeerCollectionEntities())
                {
                    var beer = db.BeerCollections.FirstOrDefault(b => b.ID == id);
                    if (beer != null)
                    {
                        db.BeerCollections.Remove(beer);

                        if (db.SaveChanges() > 0)
                        {
                            return("Beer removed successfully.");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
            }
            return("Error in deleting beer.");
        }
 public BeerCollection AddBeer(string name, int type, int rating)
 {
     try
     {
         using (BeerCollectionEntities db = new BeerCollectionEntities())
         {
             var beer = new BeerCollection()
             {
                 NAME   = name,
                 RATING = rating,
                 TYPE   = type
             };
             db.BeerCollections.Add(beer);
             if (db.SaveChanges() > 0)
             {
                 return(beer);
             }
         }
     }
     catch (Exception ex)
     {
     }
     return(new BeerCollection());
 }
        public BeerCollection UpdateBeerRatingByAverage(int id)
        {
            try
            {
                using (BeerCollectionEntities db = new BeerCollectionEntities())
                {
                    var beer    = db.BeerCollections.FirstOrDefault(b => b.ID == id);
                    var average = db.BeerCollections.Select(b => b.RATING).Average();
                    if (beer != null)
                    {
                        beer.RATING = Convert.ToInt32(average);

                        if (db.SaveChanges() > 0)
                        {
                            return(db.BeerCollections.FirstOrDefault(b => b.ID == id));
                        }
                    }
                }
            }
            catch (Exception ex)
            {
            }
            return(new BeerCollection());
        }