public void GetConfigMessages(MBaseParameterModel parameterModel) { var mBaseMessageType = as400Service.GetMBaseMessages(parameterModel); foreach (var message in mBaseMessageType) { sQLService.AddMBaseMessage(message); } }
public IEnumerable <MessageTypeModel> GetMBaseMessages(MBaseParameterModel parameterModel) { if (string.IsNullOrEmpty(parameterModel.TranCode)) { SQL = $@"SELECT * FROM LHBDDATSMB.MBP003 WHERE INPUTR = '{ parameterModel.MessageType }' ORDER BY FISEQ ASC"; } else { SQL = $@"SELECT * FROM LHBDDATSMB.MBP003 WHERE MTRAN = { parameterModel.TranCode } AND INPUTR = '{ parameterModel.MessageType }' ORDER BY FISEQ ASC"; } return(ExecuteGetMessage(SQL)); }
public void FetchMBaseMessageForDevelopOnly([FromBody] MBaseParameterModel model) { mBaseService.GetConfigMessages(model); }