public List <PRODUCT> GetAllProduct()
        {
            entity = new INVENTORYEntities();
            var lstPrd = entity.PRODUCTs.ToList();

            return(lstPrd);
        }
        public PRODUCT GetProdById(string pID)
        {
            entity = new INVENTORYEntities();
            PRODUCT prod = entity.PRODUCTs.Find(int.Parse(pID));

            return(prod);
        }
 public bool AddNewProduct(PRODUCT prod)
 {
     entity = new INVENTORYEntities();
     entity.PRODUCTs.Add(prod);
     entity.SaveChanges();
     return(true);
 }
        public bool DeleteProductByID(string pID)
        {
            entity = new INVENTORYEntities();
            PRODUCT prod = entity.PRODUCTs.Find(int.Parse(pID));

            entity.PRODUCTs.Remove(prod);
            entity.SaveChanges();
            return(true);
        }