public string Add(TControllerRoleAccess obj)
        {
            TControllerRoleAccessRPO roleRPO = new TControllerRoleAccessRPO(imap_);

            roleRPO.Insert(obj, ref exec);
            return(exec.Message);
        }
        public string UpdateRoleAccess(TControllerRoleAccess obj)
        {
            TControllerRoleAccessRPO RPO = new TControllerRoleAccessRPO(imap_);
            //RPO.Where(nameof(TControllerRoleAccess.ControllerName)).Equals(obj.ControllerName);
            //RPO.Where(nameof(TControllerRoleAccess.RoleID)).Equals(obj.RoleID);
            Conditions cnd = new Conditions();

            cnd.AddFilter(nameof(TControllerRoleAccess.ControllerName), Operator.Equals(obj.ControllerName));
            cnd.AddFilter(nameof(TControllerRoleAccess.RoleID), Operator.Equals(obj.RoleID));
            RPO.Conditions(cnd);
            RPO.Update(obj, ref exec);
            return(exec.Message);
        }
        public List <TControllerRoleAccess> ReadListRoleAccess(ref string message)
        {
            TControllerRoleAccessRPO RPO = new TControllerRoleAccessRPO(imap_);

            if (RPO.ReadList(ref exec))
            {
                return(RPO.Result.Collection);
            }
            else
            {
                message = "Internal Server Error";
            }

            return(null);
        }
        public string AddBulk(List <TControllerRoleAccess> lstObjRole)
        {
            TControllerRoleAccessRPO roleRPO = new TControllerRoleAccessRPO(imap_);

            foreach (var obj in lstObjRole)
            {
                if (exec.Success)
                {
                    roleRPO.Insert(obj, ref exec);
                }
                else
                {
                    break;
                }
            }
            return(exec.Message);
        }
        public bool CheckDuplicateRoleAccess(string controllerName, string roleID, ref string message)
        {
            TControllerRoleAccessRPO crRPO = new TControllerRoleAccessRPO(imap_);
            Conditions cnd = new Conditions();

            cnd.AddFilter(nameof(TControllerRoleAccess.ControllerName), Operator.Equals(controllerName));
            cnd.AddFilter(nameof(TControllerRoleAccess.RoleID), Operator.Equals(roleID));
            crRPO.Conditions(cnd);
            //crRPO.Where(nameof(TControllerRoleAccess.ControllerName)).Equals(controllerName);
            //crRPO.Where(nameof(TControllerRoleAccess.RoleID)).Equals(roleID);
            if (crRPO.ReadList(ref exec))
            {
                return(crRPO.Result.AffectedRow > 0);
            }
            else
            {
                message = exec.Message;
            }

            return(true);
        }