private SEC001P001DTO GetByID(SEC001P001DTO dto)
{
dto.Model = _DBManger.VSMS_CTRLLOG
.Where(m => m.TBL_NAME == dto.Model.TBL_NAME)
.FirstOrDefault().ToNewObject(new SEC001P001Model());
dto.Model.TBL_NAME = dto.Model.TBL_NAME;
return(dto);
}
private SEC001P001DTO GetAll(SEC001P001DTO dto)
{
dto.Models = _DBManger.VSMS_CTRLLOG
.Where((m => ((dto.Model.TBL_NAME == null || dto.Model.TBL_NAME == string.Empty) || m.TBL_NAME.Contains(dto.Model.TBL_NAME)) &&
((dto.Model.TBL_TYPE == null || dto.Model.TBL_TYPE == string.Empty) || m.TBL_TYPE.Contains(dto.Model.TBL_TYPE)) &&
((dto.Model.LOG_STATUS == null || dto.Model.LOG_STATUS == string.Empty) || m.LOG_STATUS.Contains(dto.Model.LOG_STATUS))
))
//.OrderBy(m => new { m.COM_CODE, m.COM_CODE })
.Select(m => new SEC001P001Model
{
COM_CODE = m.COM_CODE,
TBL_NAME = m.TBL_NAME,
TBL_TYPE = m.TBL_TYPE,
LOG_STATUS = m.LOG_STATUS
}).ToList();
return(dto);
}
public SEC001P001DA()
{
DTO = new SEC001P001DTO();
}
