public async Task <int> Add(PesticideCategory pesticideCategory) { var cmd = QueriesCreatingHelper.CreateQueryInsert(pesticideCategory); cmd += ";SELECT LAST_INSERT_ID();"; return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First()); }
public async Task <int> Update(PesticideCategory pesticideCategory) { var cmd = QueriesCreatingHelper.CreateQueryUpdate(pesticideCategory); return(await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection)); }
public AddCommand(PesticideCategory pesticideCategory) { PesticideCategory = pesticideCategory; }
public UpdateCommand(PesticideCategory pesticideCategory) { PesticideCategory = pesticideCategory; }