private SECS01P001DTO DeleteDetail(SECS01P001DTO dto)
{
if (dto.Models.Count() > 0)
{
foreach (var item in dto.Models)
{
var items = _DBManger.VSMS_ISSUE.Where(m => m.COM_CODE == item.COM_CODE && m.MODULE == item.MODULE && m.RESPONSE_BY == item.USER_ID);
if (items.Count() > 0)
{
dto.Result.IsResult = false;
dto.Result.ResultMsg = "Data is useed!";
break;
}
else
{
dto.Result.IsResult = true;
//var del = _DBManger.VSMS_MODULE.Where(m => m.COM_CODE == item.COM_CODE && m.MODULE == item.MODULE && m.USER_ID == item.USER_ID);
//_DBManger.VSMS_MODULE.RemoveRange(del);
}
}
}
return(dto);
}
private SECS01P001DTO GetByID(SECS01P001DTO 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 SECS01P001Model());
dto.Model.COM_CODE = dto.Model.COM_CODE;
dto.Model.COM_BRANCH = dto.Model.COM_BRANCH;
return(dto);
}
private SECS01P001DTO Delete(SECS01P001DTO dto)
{
foreach (var item in dto.Models)
{
var items = _DBManger.VSMS_COMPANY.Where(m => m.COM_CODE == item.COM_CODE && m.COM_BRANCH == item.COM_BRANCH);
_DBManger.VSMS_COMPANY.RemoveRange(items);
}
return(dto);
}
private SECS01P001DTO GetComLicenseID(SECS01P001DTO dto)
{
dto.Model = _DBManger.VSMS_COMPANY
.Where(m => m.COM_CODE == dto.Model.COM_CODE)
.Select(m => new SECS01P001Model
{
COM_LICENSE_ID = m.COM_LICENSE_ID
})
.FirstOrDefault().ToNewObject(new SECS01P001Model());
return(dto);
}
private SECS01P001DTO GetDetailByID(SECS01P001DTO dto)
{
dto.Model.Details = _DBManger.VSMS_MODULE
.Where((m => ((m.COM_CODE == dto.Model.COM_CODE))
))
.Select(m => new SECS01P001DetailPModel
{
COM_CODE = m.COM_CODE,
MODULE = m.MODULE,
USER_ID = m.USER_ID
}).ToList();
return(dto);
}
private SECS01P001DTO UpdateDetail(SECS01P001DTO dto)
{
if (dto.Model.Details.Count() > 0)
{
foreach (var item in dto.Model.Details)
{
var items = _DBManger.VSMS_MODULE.Where(m => m.COM_CODE == dto.Model.COM_CODE);
_DBManger.VSMS_MODULE.RemoveRange(items);
}
InsertDetail(dto);
}
return(dto);
}
private SECS01P001DTO Insert(SECS01P001DTO dto)
{
if (dto.Model.COM_USE_LANGUAGE != null)
{
dto.Model.COM_USE_LANGUAGE = dto.Model.COM_USE_LANGUAGE.Trim();
}
var model = dto.Model.ToNewObject(new VSMS_COMPANY());
var COM_CODE = model.COM_CODE;
var COM_BRANCH = model.COM_BRANCH;
model.COM_CODE = COM_CODE;
model.COM_BRANCH = COM_BRANCH;
model.CRET_BY = model.CRET_BY.Trim();
model.MNT_BY = model.MNT_BY.Trim();
_DBManger.VSMS_COMPANY.Add(model);
return(dto);
}
private SECS01P001DTO GetAll(SECS01P001DTO 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 SECS01P001Model
{
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);
}
private SECS01P001DTO InsertDetail(SECS01P001DTO dto)
{
var items = _DBManger.VSMS_MODULE.Where(m => m.COM_CODE == dto.Model.COM_CODE);
_DBManger.VSMS_MODULE.RemoveRange(items);
if (dto.Model.Details.Count() > 0)
{
foreach (var item in dto.Model.Details)
{
var m = item.ToNewObject(new VSMS_MODULE());
m.CRET_BY = dto.Model.CRET_BY;
m.USER_ID = "N/G";
m.CRET_DATE = dto.Model.CRET_DATE;
m.COM_CODE = dto.Model.COM_CODE;
_DBManger.VSMS_MODULE.Add(m);
}
}
return(dto);
}
public SECS01P001DA()
{
DTO = new SECS01P001DTO();
}