public async Task <ActionResult <BoolResult> > All([FromBody] AllRequest request) { if (!await _authManager.HasSitePermissionsAsync(request.SiteId, Types.SitePermissions.Contents)) { return(Unauthorized()); } var site = await _siteRepository.GetAsync(request.SiteId); if (site == null) { return(NotFound()); } var channel = await _channelRepository.GetAsync(request.ChannelId); channel.IsAllContents = request.IsAllContents; await _channelRepository.UpdateAsync(channel); return(new BoolResult { Value = true }); }
public async Task <AllResponseVM <ClaimGroupResponseVM> > GetAllByUser([FromQuery] ClaimGroupAllRequestVM requestVM) { AllRequest <ApplicationClaimGroup> request = requestVM.ConvertAll(); AllResponse <ApplicationClaimGroup> response = await this.ClaimGroupApplication.GetAllByUser(request); AllResponseVM <ClaimGroupResponseVM> responseVM = response.ConvertAll(base.UseDefaultLanguage); return(responseVM); }
public async Task <AllResponseVM <ChannelAllResponseVM> > GetAll([FromQuery] ChannelAllRequestVM requestVm) { AllRequest <Channel> request = requestVm.ConvertAll(); AllResponse <Channel> response = await this.ChannelApplication.GetAll(request); AllResponseVM <ChannelAllResponseVM> responseVm = response.ConvertAll(base.UseDefaultLanguage); return(responseVm); }
public async Task <AllResponseVM <RoleAllResponseVM> > GetAll([FromQuery] RoleAllRequestVM requestVM) { AllRequest <ApplicationRole> request = requestVM.ConvertAll(); AllResponse <ApplicationRole> response = await this.RoleApplication.GetAll(request); AllResponseVM <RoleAllResponseVM> responseVM = response.ConvertAll(base.UseDefaultLanguage); return(responseVM); }
// [AllowAnonymous] public async Task <AllResponseVM <UserAllResponseVM> > GetAll([FromQuery] UserAllRequestVM requestVm) { AllRequest <ApplicationUser> request = requestVm.ConvertAll(); AllResponse <ApplicationUser> response = await this.UserApplication.GetAll(request); AllResponseVM <UserAllResponseVM> responseVm = response.ConvertAll(); return(responseVm); }
/// <summary> /// GetAll fetch and returns queried list of items from database. /// </summary> /// <param name="Channel"></param> /// <returns></returns> public async Task <AllResponse <Channel> > GetAll(AllRequest <Channel> Channel) { var result = new AllResponse <Channel> { Data = new List <Channel>(), Offset = Channel.Offset, PageSize = Channel.PageSize, SortColumn = Channel.SortColumn, SortAscending = Channel.SortAscending }; var totalRecordParamter = base.GetParameterOut(BaseInfrastructure.TotalRecordParameterName, SqlDbType.Int, result.TotalRecord); var parameters = new List <DbParameter> { totalRecordParamter, base.GetParameter(ChannelInfrastructure.ClientIdParameterName, Channel.Data.ClientId), base.GetParameter(BaseInfrastructure.OffsetParameterName, Channel.Offset), base.GetParameter(BaseInfrastructure.PageSizeParameterName, Channel.PageSize), base.GetParameter(BaseInfrastructure.SortColumnParameterName, Channel.SortColumn), base.GetParameter(BaseInfrastructure.SortAscendingParameterName, Channel.SortAscending), base.GetParameter(BaseInfrastructure.CurrentUserIdParameterName, Channel.Data.CreatedById) }; using (var dataReader = await base.ExecuteReader(parameters, ChannelInfrastructure.GetAllStoredProcedureName, CommandType.StoredProcedure)) { if (dataReader != null && dataReader.HasRows) { while (dataReader.Read()) { var ChannelItem = new Channel { ChannelId = dataReader.GetUnsignedIntegerValue(ChannelInfrastructure.ChannelIdColumnName), ClientId = dataReader.GetUnsignedIntegerValue(ChannelInfrastructure.ClientIdColumnName), ChannelName = dataReader.GetStringValue(ChannelInfrastructure.ChannelNameColumnName), Description = dataReader.GetStringValue(ChannelInfrastructure.DescriptionColumnName), Active = dataReader.GetBooleanValue(BaseInfrastructure.ActiveColumnName) }; result.Data.Add(ChannelItem); } if (!dataReader.IsClosed) { dataReader.Close(); } result.TotalRecord = Convert.ToUInt32(totalRecordParamter.Value); } } return(result); }
/// <summary> /// GetAll fetch and returns queried list of items from database. /// </summary> /// <param name="employee"></param> /// <returns></returns> public async Task <AllResponse <Employee> > GetAll(AllRequest <Employee> employee) { var result = new AllResponse <Employee> { Data = new List <Employee>(), Offset = employee.Offset, PageSize = employee.PageSize, SortColumn = employee.SortColumn, SortAscending = employee.SortAscending }; Employee employeeItem = null; var totalRecordParamter = base.GetParameterOut(BaseInfrastructure.TotalRecordParameterName, SqlDbType.Int, result.TotalRecord); var parameters = new List <DbParameter> { totalRecordParamter, base.GetParameter(BaseInfrastructure.OffsetParameterName, employee.Offset), base.GetParameter(BaseInfrastructure.PageSizeParameterName, employee.PageSize), base.GetParameter(BaseInfrastructure.SortColumnParameterName, employee.SortColumn), base.GetParameter(BaseInfrastructure.SortAscendingParameterName, employee.SortAscending), base.GetParameter(BaseInfrastructure.CurrentUserIdParameterName, employee.Data.CreatedById) }; //TODO: Add other parameters. using (var dataReader = await base.ExecuteReader(parameters, EmployeeInfrastructure.GetAllStoredProcedureName, CommandType.StoredProcedure)) { if (dataReader != null && dataReader.HasRows) { while (dataReader.Read()) { employeeItem = new Employee { EmployeeId = dataReader.GetUnsignedIntegerValue(EmployeeInfrastructure.EmployeeIdColumnName), UserTypeId = dataReader.GetUnsignedIntegerValue(EmployeeInfrastructure.UserTypeIdColumnName) //EmployeeName = dataReader.GetStringValue(EmployeeInfrastructure.EmployeeNameColumnName) }; //TODO: Add other Columns. result.Data.Add(employeeItem); } if (!dataReader.IsClosed) { dataReader.Close(); } result.TotalRecord = (uint)totalRecordParamter.Value; } } return(result); }
/// <summary> /// GetAll fetch and returns queried list of items from database. /// </summary> /// <param name="applicationrole"></param> /// <returns></returns> public async Task <AllResponse <ApplicationRole> > GetAll(AllRequest <ApplicationRole> applicationrole) { var result = new AllResponse <ApplicationRole> { Data = new List <ApplicationRole>(), Offset = applicationrole.Offset, PageSize = applicationrole.PageSize, SortColumn = applicationrole.SortColumn, SortAscending = applicationrole.SortAscending }; ApplicationRole applicationroleItem = null; var totalRecordParamter = base.GetParameterOut(BaseInfrastructure.TotalRecordParameterName, SqlDbType.Int, result.TotalRecord); var parameters = new List <DbParameter> { totalRecordParamter, base.GetParameter(BaseInfrastructure.OffsetParameterName, applicationrole.Offset), base.GetParameter(BaseInfrastructure.PageSizeParameterName, applicationrole.PageSize), base.GetParameter(BaseInfrastructure.SortColumnParameterName, applicationrole.SortColumn), base.GetParameter(BaseInfrastructure.SortAscendingParameterName, applicationrole.SortAscending), base.GetParameter(BaseInfrastructure.CurrentUserIdParameterName, applicationrole.Data.CreatedById) }; //TODO: Add other parameters. using (var dataReader = await base.ExecuteReader(parameters, RoleInfrastructure.GetAllStoredProcedureName, CommandType.StoredProcedure)) { if (dataReader != null && dataReader.HasRows) { while (dataReader.Read()) { applicationroleItem = new ApplicationRole { RoleId = dataReader.GetUnsignedIntegerValue(RoleInfrastructure.RoleIdColumnName), RoleName = dataReader.GetStringValue(RoleInfrastructure.RoleNameColumnName), RoleNameTranslation = dataReader.GetStringValue(RoleInfrastructure.RoleNameTranslationColumnName), Active = dataReader.GetBooleanValue(BaseInfrastructure.ActiveColumnName) }; //TODO: Add other Columns. result.Data.Add(applicationroleItem); } if (!dataReader.IsClosed) { dataReader.Close(); } result.TotalRecord = Convert.ToUInt32(totalRecordParamter.Value); } } return(result); }
/// <summary> /// GetAll fetch and returns queried list of items from database. /// </summary> /// <param name="configuration"></param> /// <returns></returns> public async Task <AllResponse <Configuration> > GetAll(AllRequest <Configuration> configuration) { var result = new AllResponse <Configuration> { Data = new List <Configuration>(), Offset = configuration.Offset, PageSize = configuration.PageSize, SortColumn = configuration.SortColumn, SortAscending = configuration.SortAscending }; Configuration configurationItem = null; var totalRecordParamter = base.GetParameterOut(BaseInfrastructure.TotalRecordParameterName, SqlDbType.Int, result.TotalRecord); var parameters = new List <DbParameter> { totalRecordParamter, base.GetParameter(BaseInfrastructure.OffsetParameterName, configuration.Offset), base.GetParameter(BaseInfrastructure.PageSizeParameterName, configuration.PageSize), base.GetParameter(BaseInfrastructure.SortColumnParameterName, configuration.SortColumn), base.GetParameter(BaseInfrastructure.SortAscendingParameterName, configuration.SortAscending), base.GetParameter(BaseInfrastructure.CurrentUserIdParameterName, configuration.Data.CreatedById) }; //TODO: Add other parameters. using (var dataReader = await base.ExecuteReader(parameters, ConfigurationInfrastructure.GetAllStoredProcedureName, CommandType.StoredProcedure)) { if (dataReader != null && dataReader.HasRows) { while (dataReader.Read()) { configurationItem = new Configuration { ConfigurationId = dataReader.GetUnsignedIntegerValue(ConfigurationInfrastructure.ConfigurationIdColumnName), ConfigurationKey = dataReader.GetStringValue(ConfigurationInfrastructure.ConfigurationKeyColumnName), ConfigurationValue = dataReader.GetStringValue(ConfigurationInfrastructure.ConfigurationValueColumnName) }; //TODO: Add other Columns. result.Data.Add(configurationItem); } if (!dataReader.IsClosed) { dataReader.Close(); } result.TotalRecord = Convert.ToUInt32(totalRecordParamter.Value); } } return(result); }
public async Task <AllResponse <UserActivity> > GetAll(AllRequest <UserActivity> UserActivity) { var result = new AllResponse <UserActivity> { Data = new List <UserActivity>(), Offset = UserActivity.Offset, PageSize = UserActivity.PageSize, SortColumn = UserActivity.SortColumn, SortAscending = UserActivity.SortAscending }; return(result); }
/// <summary> /// Convert converts object of BaseRequestAllVM type to AllRequest. /// </summary> /// <param name="vm"></param> /// <returns></returns> public static AllRequest <T> Convert <T>(this BaseAllRequestVM vm) where T : new() { var request = new AllRequest <T> { Data = new T(), Offset = vm.Offset, PageSize = vm.PageSize > 0 ? vm.PageSize : uint.MaxValue, SortColumn = vm.SortColumn, SortAscending = vm.SortAscending, FilterColumnId = vm.FilterColumnId }; return(request); }
public List <T> All <T>(AllRequest request) { var list = All(request); return(ToGenericList <T>(list)); }
public List <Document> All(AllRequest request) { var list = _protocol.All(request); return(list.Cast <Document>().ToList()); }
/// <summary> /// GetAll executes provided stored procedure with provided parameters. /// </summary> /// <param name="applicationClaimGroup"></param> /// <param name="storedProcedureName"></param> /// <returns></returns> private async Task <AllResponse <ApplicationClaimGroup> > GetAll(AllRequest <ApplicationClaimGroup> applicationClaimGroup, string storedProcedureName) { var result = new AllResponse <ApplicationClaimGroup> { Data = new List <ApplicationClaimGroup>(), Offset = applicationClaimGroup.Offset, PageSize = applicationClaimGroup.PageSize, SortColumn = applicationClaimGroup.SortColumn, SortAscending = applicationClaimGroup.SortAscending }; ApplicationClaimGroup applicationClaimGroupItem = null; ApplicationClaimGroup currentGroup = null; ApplicationClaim applicationClaimItem = null; var totalRecordParamter = base.GetParameterOut(BaseInfrastructure.TotalRecordParameterName, SqlDbType.Int, result.TotalRecord); var parameters = new List <DbParameter> { totalRecordParamter, base.GetParameter(BaseInfrastructure.OffsetParameterName, applicationClaimGroup.Offset), base.GetParameter(BaseInfrastructure.PageSizeParameterName, applicationClaimGroup.PageSize), base.GetParameter(BaseInfrastructure.SortColumnParameterName, applicationClaimGroup.SortColumn), base.GetParameter(BaseInfrastructure.SortAscendingParameterName, applicationClaimGroup.SortAscending), base.GetParameter(BaseInfrastructure.CurrentUserIdParameterName, applicationClaimGroup.Data.CreatedById) }; //TODO: Add other parameters. using (var dataReader = await base.ExecuteReader(parameters, storedProcedureName, CommandType.StoredProcedure)) { if (dataReader != null && dataReader.HasRows) { while (dataReader.Read()) { applicationClaimGroupItem = new ApplicationClaimGroup { ClaimGroupId = dataReader.GetUnsignedIntegerValue(ClaimGroupInfrastructure.ClaimGroupIdColumnName), ClaimGroupLabel = dataReader.GetStringValue(ClaimGroupInfrastructure.ClaimGroupLabelColumnName), ClaimGroupLabelTranslation = dataReader.GetStringValue(ClaimGroupInfrastructure.ClaimGroupLabelTranslationColumnName), ClaimGroupCode = dataReader.GetStringValue(ClaimGroupInfrastructure.ClaimGroupCodeColumnName), Claims = new List <ApplicationClaim>() }; //TODO: Add other Columns. result.Data.Add(applicationClaimGroupItem); } if (dataReader.NextResult()) { while (dataReader.Read()) { applicationClaimItem = new ApplicationClaim { ClaimId = dataReader.GetUnsignedIntegerValue(ClaimInfrastructure.ClaimIdColumnName), ClaimGroupId = dataReader.GetUnsignedIntegerValue(ClaimInfrastructure.ClaimGroupIdColumnName), ClaimType = dataReader.GetStringValue(ClaimInfrastructure.ClaimTypeColumnName), ClaimLabel = dataReader.GetStringValue(ClaimInfrastructure.ClaimLabelColumnName), ClaimLabelTranslation = dataReader.GetStringValue(ClaimInfrastructure.ClaimLabelTranslationColumnName), ClaimCode = dataReader.GetStringValue(ClaimInfrastructure.ClaimCodeColumnName), Active = dataReader.GetBooleanValue(ClaimInfrastructure.ActiveColumnName) }; if (currentGroup == null || currentGroup.ClaimGroupId != applicationClaimItem.ClaimGroupId) { currentGroup = result.Data.FirstOrDefault(c => c.ClaimGroupId == applicationClaimItem.ClaimGroupId); } currentGroup?.Claims.Add(applicationClaimItem); } } if (!dataReader.IsClosed) { dataReader.Close(); } result.TotalRecord = Convert.ToUInt32(totalRecordParamter.Value); } } return(result); }
/// <summary> /// GetAllByUser fetch and returns queried list of items from database. /// </summary> /// <param name="applicationClaimGroup"></param> /// <returns></returns> public async Task <AllResponse <ApplicationClaimGroup> > GetAllByUser(AllRequest <ApplicationClaimGroup> applicationClaimGroup) { return(await this.GetAll(applicationClaimGroup, ClaimGroupInfrastructure.GetAllByUserStoredProcedureName)); }
/// <summary> /// GetAllByUser calls ClaimGroupInfrastructure to fetch and returns queried list of items from database. /// </summary> /// <param name="applicationClaimGroup"></param> /// <returns></returns> public async Task <AllResponse <ApplicationClaimGroup> > GetAllByUser(AllRequest <ApplicationClaimGroup> applicationClaimGroup) { return(await this.ClaimGroupInfrastructure.GetAllByUser(applicationClaimGroup)); }
/// <summary> /// GetAll calls ConfigurationInfrastructure to fetch and returns queried list of items from database. /// </summary> /// <param name="configuration"></param> /// <returns></returns> public async Task <AllResponse <Configuration> > GetAll(AllRequest <Configuration> configuration) { return(await this.ConfigurationInfrastructure.GetAll(configuration)); }
/// <summary> /// GetAll calls ChannelInfrastructure to fetch and returns queried list of items from database. /// </summary> /// <param name="Channel"></param> /// <returns></returns> public async Task <AllResponse <Channel> > GetAll(AllRequest <Channel> Channel) { return(await this.ChannelInfrastructure.GetAll(Channel)); }
/// <summary> /// GetAll calls ApplicationClaimInfrastructure to fetch and returns queried list of items from database. /// </summary> /// <param name="applicationClaim"></param> /// <returns></returns> public async Task <AllResponse <ApplicationClaim> > GetAll(AllRequest <ApplicationClaim> applicationClaim) { return(await this.ClaimInfrastructure.GetAll(applicationClaim)); }
/// <summary> /// GetAll calls EmployeeInfrastructure to fetch and returns queried list of items from database. /// </summary> /// <param name="employee"></param> /// <returns></returns> public async Task <AllResponse <Employee> > GetAll(AllRequest <Employee> employee) { return(await this.EmployeeInfrastructure.GetAll(employee)); }
/// <summary> /// GetAll calls ApplicationRoleInfrastructure to fetch and returns queried list of items from database. /// </summary> /// <param name="applicationRole"></param> /// <returns></returns> public async Task <AllResponse <ApplicationRole> > GetAll(AllRequest <ApplicationRole> applicationRole) { return(await this.RoleInfrastructure.GetAll(applicationRole)); }
/// <summary> /// GetAll calls DocumentInfrastructure to fetch and returns queried list of items from database. /// </summary> /// <param name="Document"></param> /// <returns></returns> public async Task <AllResponse <Documents> > GetAll(AllRequest <Documents> Document) { return(await this.DocumentInfrastructure.GetAll(Document)); }
public Task <AllResponse <Documents> > GetAll(AllRequest <Documents> entity) { throw new NotImplementedException(); }
/// <summary> /// GetAll calls UserActivityInfrastructure to fetch and returns queried list of items from database. /// </summary> /// <param name="UserActivity"></param> /// <returns></returns> public async Task <AllResponse <UserActivity> > GetAll(AllRequest <UserActivity> UserActivity) { return(await this.UserActivityInfrastructure.GetAll(UserActivity)); }
public async Task <AllResponse <ApplicationUser> > GetAll(AllRequest <ApplicationUser> user) { return(await this.ApplicationUserInfrastructure.GetAll(user)); }