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