public async Task <int> AddAsync(CultureField cultureField)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(cultureField);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public override async Task <int> HandleCommand(DeleteCultureFieldCommand request, CancellationToken cancellationToken)
{
CultureField cultureField = null;
if (request.Model == 0)
{
throw new BusinessException("CultureField.NotSelected");
}
else
{
cultureField = await cultureFieldQueries.GetByIdAsync(request.Model);
if (cultureField == null)
{
throw new BusinessException("CultureField.NotSelected");
}
}
var rs = -1;
using (var conn = DALHelper.GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
cultureField.IsDeleted = true;
cultureField.ModifiedDate = DateTime.Now;
cultureField.ModifiedBy = request.LoginSession.Id;
if (await cultureFieldRepository.UpdateAsync(cultureField) > 0)
{
rs = 0;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (rs == 0)
{
trans.Commit();
}
else
{
try { trans.Rollback(); } catch { }
}
}
}
}
return(rs);
}
public async Task <int> UpdateAsync(CultureField cultureField)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(cultureField);
return(await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection));
}
public InsertCultureFieldCommand(CultureField cultureField)
{
Model = cultureField;
}
public UpdateCultureFieldCommand(CultureField cultureField)
{
Model = cultureField;
}
