public async Task <int> UpdateItem(RetailerOrderItem item)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(item);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);;
}
public async Task <int> AddItem(RetailerOrderItem item)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(item);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
