public List <MUserVM> ReadListUser(ref string message)
{
List <MUserVM> lstRet = new List <MUserVM>();
MUserRPO usrRPO = new MUserRPO(imap_);
TUserRoleRPO tusrRoleRPO = new TUserRoleRPO(imap_);
usrRPO.BeginTrans();
if (usrRPO.ReadList(ref exec))
{
tusrRoleRPO.SetObjConn(usrRPO.ObjConn);
foreach (var _objUser in usrRPO.Result.Collection)
{
tusrRoleRPO.Conditions(nameof(TuserRole.Username), Operator.Equals(_objUser.Username));
//tusrRoleRPO.Where(nameof(TUserRole.Username)).Equals(_objUser.Username);
if (tusrRoleRPO.ReadList(ref exec))
{
_objUser.Password = "";
lstRet.Add(new MUserVM()
{
objUser = _objUser,
ListRole = tusrRoleRPO.Result.Collection
});
}
else
{
break;
}
}
}
message = exec.Message;
usrRPO.EndTrans(exec);
return(lstRet);
}
private void AddUpdateUserRole(bool isUpdate, MUserVM objMuser, ObjectConnection objc, ref ExecResult exec)
{
TUserRoleRPO trpo = new TUserRoleRPO(imap_);
trpo.SetObjConn(objc);
if (isUpdate)
{
trpo.Conditions(nameof(TuserRole.Username), Operator.Equals(objMuser.objUser.Username));
trpo.Delete(ref exec);
//trpo.Where(nameof(TUserRole.Username)).Equals(objMuser.objUser.Username);
//trpo.Delete(null,ref exec);
}
foreach (var obj in objMuser.ListRole)
{
if (!exec.Success)
{
break;
}
trpo.Insert(obj, ref exec);
}
}