public int Delete(PurchaseHistoryDto Dto)
 {
     try
     {
         int x = FactorySingleton.GetDal().Dal.PurchaseHistory().Delete(new PurchaseHistoryEntity
                                                                            (user_id, FactorySingleton.GetDal().Dal.Product().GetByFieldName("name", Dto.Name)[0].ID.Value, Dto.Date));
         FactorySingleton.GetDal().Dal.Product().DeleteByFieldName("id", FactorySingleton.GetDal().Dal.Product().GetByFieldName("name", Dto.Name)[0].ID.Value);
         return(x);
     }
     catch
     {
         return(0);
     }
 }
        public int Add(PurchaseHistoryDto Dto)
        {
            try
            {
                FactorySingleton.GetDal().Dal.Product().Insert(new ProductEntity(Dto.Name, Dto.Cost.Value, Dto.Brand, Dto.Brand));
                FactorySingleton.GetDal().Dal.PurchaseHistory().Insert(
                    new PurchaseHistoryEntity(user_id, FactorySingleton.GetDal().Dal.Product().GetByFieldName("name", Dto.Name)[0].ID.Value, DateTime.Now));

                return(1);
            }
            catch
            {
                return(0);
            }
        }
 public int Edit(PurchaseHistoryDto Dto, string productOldName)
 {
     try
     {
         FactorySingleton.GetDal().Dal.Product().UpdateByEntity(new ProductEntity(Dto.Name, Dto.Cost.Value, Dto.Type, Dto.Brand)
         {
             ID = FactorySingleton.GetDal().Dal.Product().GetByFieldName("name", productOldName)[0].ID.Value
         });
         return(1);
     }
     catch
     {
         return(0);
     }
 }