Ejemplo n.º 1
0
        public async Task <int> UpdateItem(CFShippingItem shippingItem)
        {
            var cmd = QueriesCreatingHelper.CreateQueryUpdate(shippingItem);
            var rs  = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);

            return(rs == 0 ? -1 : 0);
        }
Ejemplo n.º 2
0
        public async Task <int> AddItem(CFShippingItem shippingItem)
        {
            var cmd = QueriesCreatingHelper.CreateQueryInsert(shippingItem);

            cmd += ";SELECT LAST_INSERT_ID();";
            return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
        }