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 <APIResult> GetById(int id)
{
var rs = await cultureFieldQueries.GetByIdAsync(id);
return(new APIResult()
{
Result = 0,
Data = rs
});
}
public override async Task <int> HandleCommand(InsertMaterialHistoryCommand request, CancellationToken cancellationToken)
{
var id = 0;
var cultureField = await _cultureFieldQueries.GetByIdAsync(request.Model.CultureFieldId);
if (cultureField == null)
{
throw new BusinessException("CultureField.NotExist");
}
using (var conn = DALHelper.GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
switch (cultureField.DataType)
{
case "text":
break;
case "number":
break;
case "boolean":
break;
case "date":
{
DateTime dtmp;
if (DateTime.TryParse(request.Model.Value, out dtmp))
{
request.Model.Value = dtmp.ToString("MM/dd/yyyy");
}
}
break;
case "time":
{
DateTime dtmp;
if (DateTime.TryParse(request.Model.Value, out dtmp))
{
request.Model.Value = dtmp.ToString("hh:mm tt");
}
}
break;
case "datetime":
{
DateTime dtmp;
if (DateTime.TryParse(request.Model.Value, out dtmp))
{
request.Model.Value = dtmp.ToString("MM/dd/yyyy hh:mm tt");
}
}
break;
case "list":
default:
break;
}
request.Model.CreatedDate = DateTime.Now;
request.Model.CreatedBy = request.LoginSession.Id;
request.Model.DeletedDate = null;
request.Model.DeletedBy = null;
id = await _materialHistoryRepository.AddAsync(request.Model);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (id > 0)
{
trans.Commit();
}
else
{
try { trans.Rollback(); } catch { }
}
}
}
}
return(id);
}
