private async Task <SqlCommand> AddReportAsync(SqlCommand command, Report model)
{
command.CommandText = RegistrationProcessRequestSQL.QueryAddReport();
command.Parameters.AddWithValue("@ReportID", model.ID);
command.Parameters.AddWithValue("@Title", model.Title);
command.Parameters.AddWithValue("@ReportDescription", model.ReportDescription);
command.Parameters.AddWithValue("@ReportSource", model.ReportSource);
command.Parameters.AddWithValue("@LevelTypeID", model.LevelTypeID);
command.Parameters.AddWithValue("@Events", model.Events);
command.Parameters.AddWithValue("@Details", model.Details);
await command.ExecuteNonQueryAsync();
return(command);
}
private async Task <SqlCommand> AddRegistrationProcessAsync(SqlCommand command, RegistrationProcess model)
{
command.CommandText = RegistrationProcessRequestSQL.QueryAddRegistrationProcess();
command.Parameters.AddWithValue("@RegistrationProcessID", model.ID);
command.Parameters.AddWithValue("@CreatedDate", model.CreatedDate);
command.Parameters.AddWithValue("@IsActive", model.IsActive);
command.Parameters.AddWithValue("@ReportIDRegistrationProcess", model.ReportID);
command.Parameters.AddWithValue("@OwnerID", model.OwnerID);
command.Parameters.AddWithValue("@EnvironmentTypeID", model.EnvironmentTypeID);
await command.ExecuteNonQueryAsync();
return(command);
}
public override async Task <GetAllRegistrationProcessResponse> FilterRegistrationProcess(FilterRegistrationProcessRequest request, ServerCallContext context)
{
var registrationProcess = new GetAllRegistrationProcessResponse();
using (var sql = new SqlConnection(_connectionString))
{
using var command = new SqlCommand(RegistrationProcessRequestSQL.QueryFilterRegistrationProcess(), sql);
await sql.OpenAsync();
command.Parameters.AddWithValue("@EnvFilterValue", request.EnvFilter);
command.Parameters.AddWithValue("@LevelFilterValue", request.LevelFilter);
command.Parameters.AddWithValue("@OrderByValue", request.OrderBy.ToLower().Equals("level") ? "level" : "events");
command.Parameters.AddWithValue("@SortDirectionValue", request.SortDirection.ToLower().Equals("asc") ? "asc" : "desc");
command.Parameters.AddWithValue("@SearchTypeValue", request.SearchType.ToLower().Equals("reportsource") ? "reportSource" : "reportDescription");
command.Parameters.AddWithValue("@SearchValueQ", request.SearchValue);
command.Parameters.AddWithValue("@IsActiveValue", request.IsActive);
var reader = await command.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
registrationProcess.List.Add(new GetAllRegistrationProcessObject
{
LevelTypeName = reader.GetString(0),
EnvironmentTypeName = reader.GetString(1),
Events = reader.GetInt32(2),
ReportDescription = reader.GetString(3),
ReportSource = reader.GetString(4),
RegistrationProcessID = reader.GetGuid(5).ToString(),
CreatedDate = reader.GetDateTimeOffset(6).ToString()
});
}
reader.Close();
sql.Close();
}
return(registrationProcess);
}
