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