//Update Ingredients

        public Boolean UpdateIngredients(Ingredient I)//Ingredients Object, LastUpdateBy
        {
            INGREDIENT result = (from p in db.INGREDIENT
                                 where p.ID == I.IID
                                 select p).SingleOrDefault();

            result.PRICE             = I.Price;
            result.FILENAME          = I.Filename;
            result.MIMETYPE          = I.MIMETYPE;
            result.INGREDIENT_IMAGE  = I.Ingredient_Image;
            result.DESCRIPTION       = I.Description;
            result.LOCATION_TOP      = I.Location_Top;
            result.LOCATION_BOTTOM   = I.Location_Bottom;
            result.LOCATION_CHOC     = I.Location_Choc;
            result.CATEGORY_ID       = I.CategoryId;
            result.NAME              = I.Name;
            result.QUANTITY          = I.Quantity;
            result.IMAGE_LAST_UPDATE = I.Image_Last_Update;
            result.FRONTEND_ID       = I.FrontendID;
            result.MANUFACTURER_ID   = I.ManufacturerID;
            try
            {
                db.SaveChanges();
                return(true);
            }

            catch (DbUpdateException ex)
            {
                return(false);
            }
        }
        public Boolean UpdateIngredientsMID(decimal iid, decimal?mid, string lub) //IngredientID, ManufacturerID, LastUpdateBy
        {
            INGREDIENT result = (from p in db.INGREDIENT
                                 where p.ID == iid
                                 select p).SingleOrDefault();

            result.MANUFACTURER_ID = mid;
            result.LAST_UPDATED_BY = lub;
            try
            {
                db.SaveChanges();
                return(true);
            }

            catch (DbUpdateException ex)
            {
                return(false);
            }
        }
        public void AddIngredient(Ingredient I)
        {
            INGREDIENT it = new INGREDIENT();

            it.ID                = I.IID;
            it.PRICE             = I.Price;
            it.FILENAME          = I.Filename;
            it.MIMETYPE          = I.MIMETYPE;
            it.INGREDIENT_IMAGE  = I.Ingredient_Image;
            it.DESCRIPTION       = I.Description;
            it.LOCATION_TOP      = I.Location_Top;
            it.LOCATION_BOTTOM   = I.Location_Bottom;
            it.LOCATION_CHOC     = I.Location_Choc;
            it.CATEGORY_ID       = I.CategoryId;
            it.NAME              = I.Name;
            it.QUANTITY          = I.Quantity;
            it.IMAGE_LAST_UPDATE = I.Image_Last_Update;
            it.FRONTEND_ID       = I.FrontendID;
            it.MANUFACTURER_ID   = I.ManufacturerID;
            db.INGREDIENT.Add(it);
            db.SaveChanges();
        }