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); } }