public async Task <CaptionMultipleLanguage> GetByIdAsync(int id)
{
string cmd = $@"SELECT c.*, cl.* FROM aritrace.`caption` c
LEFT JOIN aritrace.`caption_language` cl ON c.`id` = cl.`caption_id`
WHERE c.`id` = '{id}' AND c.`is_deleted` = 0;";
var conn = DbConnection;
if (conn == null)
{
conn = DALHelper.GetConnection();
}
try
{
CaptionMultipleLanguage caption = null;
using (var reader = await conn.QueryMultipleAsync(cmd, transaction: DbTransaction))
{
return(reader.Read <UI.Captions.Models.Caption, UI.CaptionLanguages.Models.CaptionLanguage, CaptionMultipleLanguage>(
(captionRs, captionLanguageRs) =>
{
if (caption == null)
{
var serializedParent = JsonConvert.SerializeObject(captionRs);
caption = JsonConvert.DeserializeObject <CaptionMultipleLanguage>(serializedParent);
}
if (captionLanguageRs != null)
{
if (caption.Languages == null)
{
caption.Languages = new List <UI.CaptionLanguages.Models.CaptionLanguage>();
}
caption.Languages.Add(captionLanguageRs);
}
return caption;
}
).FirstOrDefault());
}
}
catch (Exception)
{
throw;
}
finally
{
if (DbConnection == null)
{
conn.Dispose();
}
}
}
public override async Task <int> HandleCommand(UpdateCaptionCommand request, CancellationToken cancellationToken)
{
CaptionMultipleLanguage caption = null;
if (request.Model == null || request.Model.Id == 0)
{
throw new BusinessException("Caption.NotExisted");
}
else
{
caption = await captionQueries.GetByIdAsync(request.Model.Id);
if (caption == null)
{
throw new BusinessException("Caption.NotExisted");
}
}
var rs = -1;
using (var conn = DALHelper.GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
if (request.Model.Languages != null && request.Model.Languages.Count > 0)
{
foreach (var clang in request.Model.Languages)
{
if (!string.IsNullOrWhiteSpace(clang.Caption))
{
if (clang.Id <= 0)
{
await captionLanguageRepository.AddAsync(clang);
}
else
{
await captionLanguageRepository.UpdateAsync(clang);
}
}
else if (clang.Id > 0)
{
await captionLanguageRepository.DeleteAsync(clang.Id);
}
}
}
request.Model.ModifiedDate = DateTime.Now;
request.Model.ModifiedBy = request.LoginSession.Id;
if (await captionRepository.UpdateAsync(request.Model) > 0)
{
rs = 0;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (rs == 0)
{
trans.Commit();
}
else
{
try { trans.Rollback(); } catch { }
}
}
}
}
return(rs);
}
public UpdateCaptionCommand(CaptionMultipleLanguage caption)
{
Model = caption;
}
public InsertCaptionCommand(CaptionMultipleLanguage caption)
{
Model = caption;
}
