Esempio n. 1
0
        public int DeleteProductById(ProductCom objCom)
        {
            DbCommand cmd = Db.GetStoredProcCommand("sp_delete_product");

            Db.AddInParameter(cmd, "@product_id", DbType.Int32, objCom.productId);
            return(Db.ExecuteNonQuery(cmd));
        }
Esempio n. 2
0
        public DataTable SelectProductById(ProductCom objCom)
        {
            DbCommand cmd = Db.GetStoredProcCommand("sp_fetch_product_by_id");

            Db.AddInParameter(cmd, "@product_id", DbType.Int32, objCom.productId);
            DataTable dt = new DataTable();
            var       ds = Db.ExecuteDataSet(cmd);

            if (ds != null && ds.Tables.Count != 0)
            {
                dt = ds.Tables[0];
            }
            return(dt);
        }
Esempio n. 3
0
 public int AddProducts(ProductCom objCom)
 {
     try
     {
         DbCommand cmd = Db.GetStoredProcCommand("sp_add_product");
         Db.AddInParameter(cmd, "@product_name", DbType.String, objCom.productName);
         Db.AddInParameter(cmd, "@category", DbType.String, objCom.productCategory);
         Db.AddInParameter(cmd, "@rate", DbType.String, objCom.productRate);
         Db.AddInParameter(cmd, "@user_id", DbType.Int32, objCom.userId);
         Db.AddInParameter(cmd, "@is_active", DbType.Boolean, objCom.isActive);
         return(Db.ExecuteNonQuery(cmd));
     }
     catch (Exception e)
     {
         return(0);
     }
 }