private SEC000P001DTO GetByID(SEC000P001DTO dto)
{
dto.Model = _DBManger.VSMS_COMPANY
.Where(m => m.COM_CODE == dto.Model.COM_CODE && m.COM_BRANCH == dto.Model.COM_BRANCH)
.FirstOrDefault().ToNewObject(new SEC000P001Model());
dto.Model.COM_CODE = dto.Model.COM_CODE;
dto.Model.COM_BRANCH = dto.Model.COM_BRANCH;
return(dto);
}
private SEC000P001DTO GetComLicenseID(SEC000P001DTO dto)
{
dto.Model = _DBManger.VSMS_COMPANY
.Where(m => m.COM_CODE == dto.Model.COM_CODE)
.Select(m => new SEC000P001Model
{
COM_LICENSE_ID = m.COM_LICENSE_ID
})
.FirstOrDefault().ToNewObject(new SEC000P001Model());
return(dto);
}
private SEC000P001DTO GetAll(SEC000P001DTO dto)
{
dto.Models = _DBManger.VSMS_COMPANY
.Where((m => ((dto.Model.COM_CODE == null || dto.Model.COM_CODE == string.Empty) || m.COM_CODE.Contains(dto.Model.COM_CODE)) &&
((dto.Model.COM_BRANCH == null || dto.Model.COM_BRANCH == string.Empty) || m.COM_BRANCH.Contains(dto.Model.COM_BRANCH)) &&
((dto.Model.COM_NAME_E == null || dto.Model.COM_NAME_E == string.Empty) || m.COM_NAME_E.Contains(dto.Model.COM_NAME_E)) &&
((dto.Model.COM_FAC_NAME_E == null || dto.Model.COM_FAC_NAME_E == string.Empty) || m.COM_FAC_NAME_E.Contains(dto.Model.COM_FAC_NAME_E)) &&
((dto.Model.COM_BRANCH_E == null || dto.Model.COM_BRANCH_E == string.Empty) || m.COM_BRANCH_E.Contains(dto.Model.COM_BRANCH_E))
))
//.OrderBy(m => new { m.COM_CODE, m.COM_CODE })
.Select(m => new SEC000P001Model
{
COM_CODE = m.COM_CODE,
COM_BRANCH = m.COM_BRANCH,
COM_NAME_E = m.COM_NAME_E,
COM_NAME_T = m.COM_NAME_T,
COM_BRANCH_E = m.COM_BRANCH_E
}).ToList();
return(dto);
}
public SEC000P001DA()
{
DTO = new SEC000P001DTO();
}