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