protected override BaseDTO DoUpdate(BaseDTO baseDTO)
{
var dto = (MSTS01P001DTO)baseDTO;
var parameters = CreateParameter();
parameters.AddParameter("error_code", null, ParameterDirection.Output);
parameters.AddParameter("COM_CODE", dto.Model.APP_CODE); //checked
parameters.AddParameter("ISSUE_TYPE", dto.Model.ISSUE_TYPE);
parameters.AddParameter("TYPE_RATE", dto.Model.TYPE_RATE);
parameters.AddParameter("MAN_PLM_SA", dto.Model.MAN_PLM_SA);
parameters.AddParameter("MAN_PLM_QA", dto.Model.MAN_PLM_QA);
parameters.AddParameter("MAN_PLM_PRG", dto.Model.MAN_PLM_PRG);
parameters.AddParameter("CRET_BY", dto.Model.CRET_BY);
parameters.AddParameter("CRET_DATE", dto.Model.CRET_DATE);
var result = _DBMangerNoEF.ExecuteDataSet("[bond].[SP_VSMS_MANDAY_001]", parameters, CommandType.StoredProcedure);
if (!result.Status)
{
dto.Result.IsResult = false;
dto.Result.ResultMsg = result.ErrorMessage;
}
else
{
if (result.OutputData["error_code"].ToString().Trim() != "0")
{
dto.Result.IsResult = false;
dto.Result.ResultMsg = result.OutputData["error_code"].ToString().Trim();
}
}
return(dto);
}
/// <summary>
/// 在执行Result之前由 MVC 框架调用
/// </summary>
/// <param name="context"></param>
public override void OnResultExecuting(ResultExecutingContext context)
{
if (context.ModelState.IsValid)
{
//根据实际需求进行具体实现
if (context.Result is ObjectResult)
{
var objectResult = context.Result as ObjectResult;
var result = new BaseDTO <object>();
if (objectResult.Value == null)
{
result.Code = StatusCodes.Status204NoContent;
result.Msg = nameof(StatusCodes.Status204NoContent);
}
else
{
result.Code = StatusCodes.Status200OK;
result.Msg = nameof(StatusCodes.Status200OK);
}
result.Data = objectResult.Value;
context.Result = new OkObjectResult(result);
}
else if (context.Result is EmptyResult)
{
var result = new BaseDTO <object>()
{
Code = StatusCodes.Status204NoContent,
Msg = nameof(StatusCodes.Status204NoContent),
Data = context.Result
};
context.Result = new OkObjectResult(result);
}
else if (context.Result is ContentResult)
{
var contentResult = context.Result as ContentResult;
var result = new BaseDTO <object>()
{
Code = StatusCodes.Status200OK,
Msg = nameof(StatusCodes.Status200OK),
Data = contentResult.Content
};
context.Result = new OkObjectResult(result);
}
else if (context.Result is StatusCodeResult)
{
var statusCodeResult = context.Result as StatusCodeResult;
var result = new BaseDTO <object>()
{
Code = statusCodeResult.StatusCode,
Msg = ((HttpStatusCode)statusCodeResult.StatusCode).ToString(),
Data = context.Result
};
context.Result = new OkObjectResult(result);
}
}
base.OnResultExecuting(context);
}
public BaseDTO Delete(string id)
{
Response response = new Response();
BaseDTO baseDTO = new BaseDTO();
var token = AuthorizationService.Authorize(_authParameters.ClientId, _authParameters.ClientSecret, _authParameters.StoreName);
var url = HelperFunctions.CreateUrlFromParts(_authParameters.StoreName, Constants.apiCustomer, "?id=" + id, token.access_token);
var result = HelperFunctions.HttpDelete(url).GetAwaiter().GetResult();
if (result.IsSuccessStatusCode)
{
response.HttpStatusCode = result.StatusCode;
response.Result = result.Content.ReadAsAsync <BaseDTO>().Result;
if (response.Result != null)
{
baseDTO = (BaseDTO)response.Result;
}
else
{
return(default(BaseDTO));
}
}
else
{
baseDTO.status = result.StatusCode.ToString();
baseDTO.code = (int)result.StatusCode;
return(baseDTO);
}
return(baseDTO);
}
public void Update(BaseDTO dtoName)
{
Type currentType = dtoName.GetType();
if (currentType.Name.Equals("ProductDTO"))
{
ProductsDAL updateProduct = new ProductsDAL();
updateProduct.UpdateProduct((dtoName as ProductDTO).ProductOldName,
(dtoName as ProductDTO).ProductNewName,
(dtoName as ProductDTO).CategoryName,
(dtoName as ProductDTO).VendorName,
(dtoName as ProductDTO).ProductPrice,
(dtoName as ProductDTO).Quantity,
(dtoName as ProductDTO).StoreName,
(dtoName as ProductDTO).TownName);
resultMessage = updateProduct.GetCRUDResult();
}
if (currentType.Name.Equals("VendorDTO"))
{
VendorsDAL updateVendor = new VendorsDAL();
updateVendor.UpdateVendor((dtoName as VendorDTO).VendorOldName, (dtoName as VendorDTO).VendorName);
resultMessage = updateVendor.GetCRUDResult();
}
if (currentType.Name.Equals("CategoryDTO"))
{
CategoriesDAL updateCategory = new CategoriesDAL();
updateCategory.UpdateCategory((dtoName as CategoryDTO).CategoryOldName, (dtoName as CategoryDTO).CategoryName);
resultMessage = updateCategory.GetCRUDResult();
}
else
{
//MessageBox.Show("Pone stigna do tuk v update seckciqta");
}
}
public async Task <BaseDTO <bool> > Withdraw(int accountId, float amount)
{
var result = new BaseDTO <bool>();
var account = await _accountRepository.GetById(accountId);
if (account == null)
{
result.AddError($"Account {accountId} not found");
return(result);
}
if (amount > account.Balance)
{
result.AddError("Insufficient balance.");
return(result);
}
var accountType = await _accountTypeRepository.GetById(account.AccountTypeId);
if (accountType.Type == AccountTypeEnum.DepositAccount)
{
if ((DateTime.UtcNow.Date - account.DateCreated.Date).TotalDays < accountType.DepositPeriodInDays)
{
result.AddError("Withdraw can be made only at maturity.");
return(result);
}
}
account.Balance -= amount;
result.Data = await _accountRepository.Update(account);
return(result);
}
public void Delete(BaseDTO dtoName)
{
Type currentType = dtoName.GetType();
if (currentType.Name.Equals("ProductDTO"))
{
ProductsDAL deleteProduct = new ProductsDAL();
deleteProduct.DeleteProduct((dtoName as ProductDTO).ProductNewName);
resultMessage = deleteProduct.GetCRUDResult();
}
if (currentType.Name.Equals("VendorDTO"))
{
VendorsDAL deleteVendor = new VendorsDAL();
deleteVendor.DeleteVendor((dtoName as VendorDTO).VendorName);
resultMessage = deleteVendor.GetCRUDResult();
}
if (currentType.Name.Equals("CategoryDTO"))
{
CategoriesDAL deleteCategory = new CategoriesDAL();
deleteCategory.DeleteCategory((dtoName as CategoryDTO).CategoryName);
resultMessage = deleteCategory.GetCRUDResult();
}
else
{
//MessageBox.Show("Pone stigna do tuk v update seckciqta");
}
}
private void ModelView_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e)
{
if (e.PropertyName == BaseDTO.PropName(() => ModelView.SelectedReport))
{
this.SelectedReport = ModelView.SelectedReport;
}
}
/// <summary>
/// 在Action执行之前由 MVC 框架调用。
/// </summary>
/// <param name="context"></param>
public override void OnActionExecuting(ActionExecutingContext context)
{
if (!context.ModelState.IsValid)
{
_logger.LogInformation("模型绑定失败！");
var modelStateErrorMsgs = new List <ModelStateErrorMsg>();
foreach (var modelStatePair in context.ModelState)
{
var key = modelStatePair.Key;
var errors = modelStatePair.Value.Errors;
if (errors != null && errors.Count > 0)
{
var errorMessages = errors.Select(error =>
{
return(string.IsNullOrEmpty(error.ErrorMessage) ?
"The input was not valid." : error.ErrorMessage);
}).ToArray();
modelStateErrorMsgs.Add(new ModelStateErrorMsg(key, errorMessages));
}
}
var result = new BaseDTO <List <ModelStateErrorMsg> >()
{
Code = StatusCodes.Status400BadRequest,
Msg = nameof(StatusCodes.Status400BadRequest),
Data = modelStateErrorMsgs
};
context.Result = new BadRequestObjectResult(result);
}
base.OnActionExecuting(context);
}
public GameObject GeneratePositionedObjectWithData(string tag, BaseDTO data, Vector3 position, Quaternion quaternion, bool activate = true)
{
GameObject go = GeneratePositionedObject(tag, position, quaternion, activate);
go.GetComponent <DataReciverBase>().ReceiveData(data);
return(go);
}
protected override BaseDTO DoSelect(BaseDTO baseDTO)
{
var dto = (MISS01P002DTO)baseDTO;
switch (dto.Execute.ExecuteType)
{
case MISS01P002ExecuteType.GetAllOpening: return(GetAllOpening(dto));
case MISS01P002ExecuteType.GetAllOnProcess: return(GetAllOnProcess(dto));
case MISS01P002ExecuteType.GetByIdOpening: return(GetByIdOpening(dto));
case MISS01P002ExecuteType.GetFiexd: return(GetFiexd(dto));
case MISS01P002ExecuteType.GetAllFixed: return(GetAllFixed(dto));
case MISS01P002ExecuteType.GetAllFollowUp: return(GetAllFollowUp(dto));
case MISS01P002ExecuteType.GetAllGolive: return(GetAllGolive(dto));
case MISS01P002ExecuteType.GetFilePacket: return(GetFilePacket(dto));
case MISS01P002ExecuteType.GetAllClose: return(GetAllClose(dto));
}
return(dto);
}
/// <summary>
/// 预加载
/// </summary>
public void Initialize()
{
//加载所有DTO
BaseDTO.ToList().ForEach(s => {
var dtpye = Activator.CreateInstance(s) as IAutoMapper;
ioc.build.RegisterInstance(dtpye).As <MapperConfigurationImpl>().SingleInstance().PropertiesAutowired();
});
//加载所有的仓储
Repository.ToList().ForEach(s => {
if (s.IsClass == true && s.IsGenericType == false)
{
var dtpye = Activator.CreateInstance(s);
ioc.build.RegisterType(dtpye.GetType()).As(dtpye.GetType());
}
});
//加载所有服务
Services.ToList().ForEach(s =>
{
if (s.IsClass == true)
{
var stype = Activator.CreateInstance(s);
ioc.build.RegisterType(stype.GetType()).As(stype.GetType());
}
});
PostInit();
EventBus.bus.RegisterAllHandler(assembles);
}
protected override BaseDTO DoSelect(BaseDTO baseDTO)
{
var dto = (SECS02P002DTO)baseDTO;
switch (dto.Execute.ExecuteType)
{
case SECS02P002ExecuteType.GetAll: return(GetAll(dto));
case SECS02P002ExecuteType.GetByID: return(GetByID(dto));
case SECS02P002ExecuteType.GetUser: return(GetUser(dto));
case SECS02P002ExecuteType.GetOldPwd: return(GetOldPwd(dto));
case SECS02P002ExecuteType.GetQuerySearchAll: return(GetQuerySearchAll(dto));
case SECS02P002ExecuteType.GetQueryCheckUserAdmin: return(GetQueryCheckUserAdmin(dto));
case SECS02P002ExecuteType.GetDetailByID: return(GetDetailByID(dto));
case SECS02P002ExecuteType.CheckAdmin: return(CheckAdmin(dto));
case SECS02P002ExecuteType.GetFullAppName: return(GetFullAppName(dto));
}
return(dto);
}
protected override BaseDTO DoDelete(BaseDTO baseDTO)
{
var dto = (MISS02P001DTO)baseDTO;
if (dto.Models.Count() > 0)
{
foreach (var item in dto.Models)
{
string strSQL1 = @"DELETE FROM [dbo].[VSMS_DEPLOY]
WHERE COM_CODE = @COM_CODE
AND YEAR = @YEAR";
var parameters1 = CreateParameter();
parameters1.AddParameter("COM_CODE", item.COM_CODE);
parameters1.AddParameter("YEAR", item.YEAR);
var result = _DBMangerNoEF.ExecuteNonQuery(strSQL1, parameters1, CommandType.Text);
if (!result.Success(dto))
{
dto.Result.IsResult = false;
dto.Result.ResultMsg = result.ErrorMessage;
break;
}
}
}
return(dto);
}
public void RollbackTrasaction(BaseDTO DTO)
{
if (DTO.DataClient.SqlTransaction != null)
{
DTO.DataClient.SqlTransaction.Rollback();
}
}
protected override BaseDTO DoAfterInsert(BaseDTO baseDTO)
{
var dto = (SECS02P003DTO)baseDTO;
dto.Model.TITLE_ID = dto.ModelEF.TITLE_ID;
return(dto);
}
protected override BaseDTO DoInsert(BaseDTO baseDTO)
{
var dto = (SEC006P001DTO)baseDTO;
#region delete insert USERCOM //insert ไม่ต้อง
//var USER_ID = dto.Model.USER_ID.AsString();
//var COM_CODE = dto.Model.COM_CODE.AsString();
//var items = _DBManger.VSMS_USERCOM.Where(m => (m.USER_ID.Trim() == USER_ID.Trim() && m.COM_CODE.Trim() == COM_CODE.Trim()));
//_DBManger.VSMS_USERCOM.RemoveRange(items);
//foreach (var item in dto.Model.ComUserModel)
//{
// _DBManger.VSMS_USERCOM.Add(item.ToNewObject(new VSMS_USERCOM()));
//}
#endregion
var USER_ID = dto.Model.USER_ID.AsString();
var model = dto.Model.ToNewObject(new VSMS_USER());
_DBManger.VSMS_USER.Add(model);
if (dto.Result.IsResult)
{
foreach (var item in dto.Model.ComUserModel)
{
item.USER_ID = USER_ID;
_DBManger.VSMS_USERCOM.Add(item.ToNewObject(new VSMS_USERCOM()));
}
}
return(dto);
}
protected override BaseDTO DoUpdate(BaseDTO baseDTO)
{
var dto = (MISS01P002DTO)baseDTO;
switch (dto.Execute.ExecuteType)
{
case MISS01P002ExecuteType.UpdateAssignment: return(UpdateAssignment(dto));
case MISS01P002ExecuteType.ConfirmTest: return(ConfirmTest(dto));
case MISS01P002ExecuteType.MoveToFollowUp: return(ConfirmTest(dto));
case MISS01P002ExecuteType.MoveToGolive: return(ConfirmTest(dto));
case MISS01P002ExecuteType.UpdateFilePacket: return(UpdateFilePacket(dto));
case MISS01P002ExecuteType.TimeStemp: return(TimeStemp(dto));
case MISS01P002ExecuteType.MoveToClose: return(ConfirmTest(dto));
case MISS01P002ExecuteType.MoveToCancel: return(ConfirmCancel(dto));
case MISS01P002ExecuteType.ReDo: return(ConfirmReDo(dto));
}
return(dto);
}
protected override BaseDTO DoDelete(BaseDTO baseDTO)
{
var dto = (SEC011P001DTO)baseDTO;
return(dto);
}
public static string GetLog(BaseDTO dto)
{
var sb = InitLogLine(Enum.GetName(typeof(EventType), dto.EventType));
sb.Append(dto.ToJSON());
return(sb.ToString());
}
public void CommitTransaction(BaseDTO DTO)
{
//Commint Transaction กรณีที่เป็นการเปิด Connection ที่ตัวหลัก
if (DTO.DataClient.SqlTransaction != null && DTO.DataClient.SqlCountConnection == 1)
{
DTO.DataClient.SqlTransaction.Commit();
}
}
protected override BaseDTO DoDelete(BaseDTO baseDTO)
{
var dto = (AutocompleteDTO)baseDTO;
DeleteNotInTable(dto);
return(dto);
}
protected void ValidateDTO <TDTO>(BaseDTO <TEntity, TDTO> dto) where TDTO : class
{
if (!dto.IsValid())
{
string json = JsonSerializer.Serialize(dto.ValidationErrors);
throw new RequestException(StatusCodes.Status400BadRequest, json);
}
}
protected override BaseDTO DoInsert(BaseDTO baseDTO)
{
var dto = (SECS02P003DTO)baseDTO;
dto.ModelEF = dto.Model.ToNewObject(new VSMS_TITLE());
_DBManger.VSMS_TITLE.Add(dto.ModelEF);
return(dto);
}
protected override BaseDTO DoUpdate(BaseDTO baseDTO)
{
var dto = (SECS02P003DTO)baseDTO;
var TITLE_ID = dto.Model.TITLE_ID.AsDecimal();
var model = _DBManger.VSMS_TITLE.First(m => m.TITLE_ID == TITLE_ID);
model.MergeObject(dto.Model);
return(dto);
}
protected override BaseDTO DoInsert(BaseDTO baseDTO)
{
var dto = (SEC004P001DTO)baseDTO;
var model = dto.Model.ToNewObject(new VSMS_SYSTEM());
_DBManger.VSMS_SYSTEM.Add(model);
return(dto);
}
public static TModel ToModel <TModel>(this BaseDTO baseDTO) where TModel : BaseModel
{
if (baseDTO == null)
{
return(null);
}
return(baseDTO.Map <TModel>());
}
/// <summary>
/// Execute a mapping from the model to a new entity
/// </summary>
/// <typeparam name="TEntity">Entity type</typeparam>
/// <param name="model">Model to map from</param>
/// <returns>Mapped entity</returns>
public static TEntity ToEntity <TEntity>(this BaseDTO model) where TEntity : BaseEntity
{
if (model == null)
{
throw new ArgumentNullException(nameof(model));
}
return(model.Map <TEntity>());
}
protected override BaseDTO DoUpdate(BaseDTO baseDTO)
{
var dto = (SEC003P001DTO)baseDTO;
var DEPT_ID = dto.Model.DEPT_ID.AsDecimal();
var model = _DBManger.VSMS_DEPARTMENT.First(m => m.DEPT_ID == DEPT_ID);
model.MergeObject(dto.Model);
return(dto);
}
protected override BaseDTO DoUpdate(BaseDTO baseDTO)
{
var dto = (MSTS03P001DTO)baseDTO;
switch (dto.Execute.ExecuteType)
{
case MSTS03P001ExecuteType.Update: return(Update(dto));
}
return(dto);
}
protected override BaseDTO DoInsert(BaseDTO baseDTO)
{
var dto = (MSTS03P001DTO)baseDTO;
switch (dto.Execute.ExecuteType)
{
case MSTS03P001ExecuteType.Insert: return(Insert(dto));
}
return(dto);
}
