private SEC007P001DTO UpdateUsgPriv(SEC007P001DTO dto)
{
var dels = dto.Model.PRIV_MODEL.Where(m => m.ROLE_SEARCH != "T" && !m.USRGRPPRIV_ID.IsNullOrEmpty()).Select(m => m.USRGRPPRIV_ID);
if (dels != null && dels.Count() > 0)
{
var del = _DBManger.VSMS_USRGRPPRIV.Where(m =>
m.COM_CODE == dto.Model.COM_CODE &&
m.USG_ID == dto.Model.USG_ID &&
m.SYS_CODE == dto.Model.SYS_CODE &&
dels.Contains(m.USRGRPPRIV_ID));
_DBManger.VSMS_USRGRPPRIV.RemoveRange(del);
}
var update = dto.Model.PRIV_MODEL.Where(m => m.ROLE_SEARCH == "T");
if (update != null && update.Count() > 0)
{
foreach (var item in update)
{
var model = _DBManger.VSMS_USRGRPPRIV.Where(m => m.COM_CODE == dto.Model.COM_CODE && m.USG_ID == dto.Model.USG_ID && m.SYS_CODE == dto.Model.SYS_CODE && m.USRGRPPRIV_ID == item.USRGRPPRIV_ID).FirstOrDefault();
if (model != null)
{
model = model.MergeObject(item);
model = model.MergeObject(dto.Model);
}
else
{
var newModel = item.ToNewObject(new VSMS_USRGRPPRIV());
newModel = newModel.MergeObject(dto.Model);
_DBManger.VSMS_USRGRPPRIV.Add(newModel);
}
}
}
return(dto);
}
private SEC007P001DTO GetByID(SEC007P001DTO dto)
{
dto.Model = _DBManger.VSMS_USRGROUP
.Where(m => m.COM_CODE == dto.Model.COM_CODE && m.USG_ID == dto.Model.USG_ID)
.FirstOrDefault().ToNewObject(new SEC007P001Model());
return(dto);
}
private SEC007P001DTO UpdateData(SEC007P001DTO dto)
{
var model = _DBManger.VSMS_USRGROUP.Where(m => m.COM_CODE == dto.Model.COM_CODE && m.USG_ID == dto.Model.USG_ID).FirstOrDefault();
model = model.MergeObject(dto.Model);
return(dto);
}
private SEC007P001DTO InsertData(SEC007P001DTO dto)
{
var model = dto.Model.ToNewObject(new VSMS_USRGROUP());
_DBManger.VSMS_USRGROUP.Add(model);
return(dto);
}
private SEC007P001DTO GetPrgSeq(SEC007P001DTO dto)
{
var cmd = @"
select t1.COM_CODE, t1.PRG_CODE, t1.PRG_SEQ, t2.PRG_NAME_TH, t2.PRG_NAME_EN
from (select t1.COM_CODE, t1.PRG_CODE, t1.PRG_SEQ
from VSMS_USRGRPPRIV t1
inner join VSMS_CONFIG_GENERAL t2
on t1.COM_CODE = t2.COM_CODE
and t1.SYS_CODE = t2.SYS_CODE
where t1.COM_CODE = @COM_CODE
and t1.USG_ID = @USG_ID
and t1.SYS_CODE = @SYS_CODE
and t2.NAME = @SYS_GROUP_NAME) t1
inner join VSMS_PROGRAM t2
on t1.COM_CODE = t2.COM_CODE
and t1.PRG_CODE = t2.PRG_CODE
order by PRG_SEQ
";
var parameters = CreateParameter();
parameters.AddParameter("COM_CODE", dto.Model.COM_CODE);
parameters.AddParameter("USG_ID", dto.Model.USG_ID);
parameters.AddParameter("SYS_CODE", dto.Model.SYS_CODE);
parameters.AddParameter("SYS_GROUP_NAME", dto.Model.SYS_GROUP_NAME);
var result = _DBMangerNoEF.ExecuteDataSet(cmd, parameters, CommandType.Text);
if (result.Success(dto))
{
dto.Model.PRIV_MODEL = result.OutputDataSet.Tables[0].ToList <SEC007P00101Model>();
}
return(dto);
}
private SEC007P001DTO DeleteData(SEC007P001DTO dto)
{
foreach (var item in dto.Models)
{
var model = _DBManger.VSMS_USRGROUP.Where(m => m.COM_CODE == item.COM_CODE && m.USG_ID == item.USG_ID);
_DBManger.VSMS_USRGROUP.RemoveRange(model);
}
return(dto);
}
private SEC007P001DTO GetUsgPriv(SEC007P001DTO dto)
{
var cmd = @"
select t1.SYS_CODE,
t1.PRG_CODE,
t1.PRG_SEQ,
t4.SYS_SEQ,
t2.PRG_NAME_EN,
t2.PRG_NAME_TH,
t2.PRG_TYPE,
ISNULL(t3.ROLE_SEARCH,'F') ROLE_SEARCH,
ISNULL(t3.ROLE_ADD,'F') ROLE_ADD,
ISNULL(t3.ROLE_EDIT,'F') ROLE_EDIT,
ISNULL(t3.ROLE_DEL,'F') ROLE_DEL,
ISNULL(t3.ROLE_PRINT,'F') ROLE_PRINT,
t3.USRGRPPRIV_ID
from (select *
from VSMS_SYS_PGC
where COM_CODE = @COM_CODE
and SYS_CODE = @SYS_CODE) t1
inner join VSMS_PROGRAM t2
on t1.PRG_CODE = t2.PRG_CODE
left join (select * from VSMS_USRGRPPRIV where USG_ID = @USG_ID) t3
on t1.COM_CODE = t3.COM_CODE
and t1.SYS_CODE = t3.SYS_CODE
and t1.PRG_CODE = t3.PRG_CODE
inner join VSMS_SYSTEM t4
on t1.COM_CODE = t4.COM_CODE
and t1.SYS_CODE = t4.SYS_CODE
order by t1.PRG_SEQ
";
var parameters = CreateParameter();
parameters.AddParameter("COM_CODE", dto.Model.COM_CODE);
parameters.AddParameter("SYS_CODE", dto.Model.SYS_CODE);
parameters.AddParameter("USG_ID", dto.Model.USG_ID);
var result = _DBMangerNoEF.ExecuteDataSet(cmd, parameters, CommandType.Text);
if (result.Success(dto))
{
dto.Model.PRIV_MODEL = result.OutputDataSet.Tables[0].ToList <SEC007P00101Model>();
}
return(dto);
}
private SEC007P001DTO GetAll(SEC007P001DTO dto)
{
dto.Models = (from t1 in _DBManger.VSMS_USRGROUP.AsEnumerable()
where (dto.Model.USG_NAME_TH.IsNullOrEmpty() || t1.USG_NAME_TH.Contains(dto.Model.USG_NAME_TH)) &&
(dto.Model.USG_NAME_EN.IsNullOrEmpty() || t1.USG_NAME_EN.Contains(dto.Model.USG_NAME_EN)) &&
(dto.Model.USG_CODE.IsNullOrEmpty() || t1.USG_NAME_TH.Contains(dto.Model.USG_CODE)) &&
(dto.Model.USG_STATUS.IsNullOrEmpty() || t1.USG_STATUS == dto.Model.USG_STATUS)
select new SEC007P001Model
{
COM_CODE = t1.COM_CODE,
USG_ID = t1.USG_ID,
USG_CODE = t1.USG_CODE,
USG_NAME_TH = t1.USG_NAME_TH,
USG_NAME_EN = t1.USG_NAME_EN,
USG_STATUS = t1.USG_STATUS
}).ToList();
return(dto);
}
private SEC007P001DTO UpdatePrgSeq(SEC007P001DTO dto)
{
var update = from t1 in _DBManger.VSMS_USRGRPPRIV
join t2 in _DBManger.VSMS_CONFIG_GENERAL on new { t1.COM_CODE, t1.SYS_CODE } equals new { t2.COM_CODE, t2.SYS_CODE }
where t1.COM_CODE == dto.Model.COM_CODE && t1.USG_ID == dto.Model.USG_ID && t1.SYS_CODE == dto.Model.SYS_CODE && t2.NAME == dto.Model.SYS_GROUP_NAME
select t1;
if (update != null && update.Any())
{
var i = 0;
foreach (var item in dto.Model.PRIV_MODEL)
{
var models = update.Where(m => m.PRG_CODE == item.PRG_CODE);
if (models != null && models.Any())
{
models.ToList().ForEach(m => m.PRG_SEQ = i);
}
i++;
}
}
return(dto);
}
public SEC007P001DA()
{
DTO = new SEC007P001DTO();
}