public override async Task <int> HandleCommand(AddCommand request, CancellationToken cancellationToken)
{
var rs = -1;
using (var conn = DALHelper.GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
categoryRepository.JoinTransaction(conn, trans);
categoryQueries.JoinTransaction(conn, trans);
if (request.Category == null)
{
throw new BusinessException("AddWrongInformation");
}
request.Category.Code = await storageQueries.GenarateCodeAsync(StorageKeys.CategoryCode);
request.Category = CreateBuild(request.Category, request.LoginSession);
var categoryId = await categoryRepository.Add(request.Category);
// languages
foreach (var item in request.Category.Languages)
{
item.CategoryId = categoryId;
await categoryRepository.AddOrUpdateLanguage(item);
}
rs = 0;
}
finally
{
if (rs == 0)
{
trans.Commit();
}
else
{
try
{
trans.Rollback();
}
catch { }
}
}
}
}
return(rs);
}
public override async Task <int> HandleCommand(UpdateCommand request, CancellationToken cancellationToken)
{
if (request.Category == null || request.Category.Id == 0)
{
throw new BusinessException("Category.NotExisted");
}
var category = await categoryQueries.GetById(request.Category.Id);
if (category == null)
{
throw new BusinessException("Category.NotExisted");
}
var rs = -1;
using (var conn = DALHelper.GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
request.Category.CreatedDate = category.CreatedDate;
request.Category.CreatedBy = category.CreatedBy;
request.Category = UpdateBuild(request.Category, request.LoginSession);
//request.Category.Code = category.Code;
rs = await categoryRepository.Update(request.Category);
if (rs == 0)
{
return(-1);
}
//for language
// languages
foreach (var item in request.Category.Languages)
{
item.CategoryId = request.Category.Id;
await categoryRepository.AddOrUpdateLanguage(item);
}
rs = 0;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (rs == 0)
{
trans.Commit();
}
else
{
try
{
trans.Rollback();
}
catch { }
}
}
}
}
return(rs);
}