/// <summary>
        /// All orders
        /// </summary>
        /// <returns></returns>
        public int DeleteProduct(int itemId)
        {
            var ctx = new OnlineShopping.DAL.Online_ShoppingEntities();
            var x   = (from y in ctx.Tbl_Product
                       where y.ProductId == itemId
                       select y).FirstOrDefault();

            ctx.Tbl_Product.Remove(x);
            ctx.SaveChanges();
            return(1);
        }
        /// <summary>
        /// Delete Category
        /// </summary>
        /// <param name="itemId"></param>
        /// <returns></returns>
        public int DeleteCategory(int itemId)
        {
            var ctx = new OnlineShopping.DAL.Online_ShoppingEntities();
            var x   = (from y in ctx.Tbl_Category
                       where y.CategoryId == itemId
                       select y).FirstOrDefault();

            ctx.Tbl_Category.Remove(x);
            ctx.SaveChanges();
            return(1);
        }