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;
}
