/// <summary>
/// Fills object from a SqlClient Data Reader
/// </summary>
/// <remarks></remarks>
public void Fill(Microsoft.Data.SqlClient.SqlDataReader dr)
{
_ID = (int)dr[db_ID];
_Name = (string)dr[db_Name];
_IndexNumber = (int)dr[db_IndexNumber];
_Professor = (int)dr[db_Professor];
}
public async Task UpsertStatuses(IReadOnlyCollection <ResourceSearchParameterStatus> statuses, CancellationToken cancellationToken)
{
EnsureArg.IsNotNull(statuses, nameof(statuses));
if (!statuses.Any())
{
return;
}
if (_schemaInformation.Current < SchemaVersionConstants.SearchParameterStatusSchemaVersion)
{
throw new BadRequestException(Resources.SchemaVersionNeedsToBeUpgraded);
}
using (IScoped <SqlConnectionWrapperFactory> scopedSqlConnectionWrapperFactory = _scopedSqlConnectionWrapperFactory())
using (SqlConnectionWrapper sqlConnectionWrapper = await scopedSqlConnectionWrapperFactory.Value.ObtainSqlConnectionWrapperAsync(cancellationToken, true))
using (SqlCommandWrapper sqlCommandWrapper = sqlConnectionWrapper.CreateSqlCommand())
{
VLatest.UpsertSearchParams.PopulateCommand(sqlCommandWrapper, _updateSearchParamsTvpGenerator.Generate(statuses.ToList()));
using (SqlDataReader sqlDataReader = await sqlCommandWrapper.ExecuteReaderAsync(CommandBehavior.SequentialAccess, cancellationToken))
{
while (await sqlDataReader.ReadAsync(cancellationToken))
{
// The upsert procedure returns the search parameters that were new.
(short searchParamId, string searchParamUri) = sqlDataReader.ReadRow(VLatest.SearchParam.SearchParamId, VLatest.SearchParam.Uri);
// Add the new search parameters to the FHIR model dictionary.
_fhirModel.TryAddSearchParamIdToUriMapping(searchParamUri, searchParamId);
}
}
}
}
// TODO: Make cancellation token an input.
public async Task <IReadOnlyCollection <ResourceSearchParameterStatus> > GetSearchParameterStatuses()
{
// If the search parameter table in SQL does not yet contain status columns
if (_schemaInformation.Current < SchemaVersionConstants.SearchParameterStatusSchemaVersion)
{
// Get status information from file.
return(await _filebasedSearchParameterStatusDataStore.GetSearchParameterStatuses());
}
using (IScoped <SqlConnectionWrapperFactory> scopedSqlConnectionWrapperFactory = _scopedSqlConnectionWrapperFactory())
using (SqlConnectionWrapper sqlConnectionWrapper = await scopedSqlConnectionWrapperFactory.Value.ObtainSqlConnectionWrapperAsync(CancellationToken.None, true))
using (SqlCommandWrapper sqlCommandWrapper = sqlConnectionWrapper.CreateSqlCommand())
{
VLatest.GetSearchParamStatuses.PopulateCommand(sqlCommandWrapper);
var parameterStatuses = new List <ResourceSearchParameterStatus>();
using (SqlDataReader sqlDataReader = await sqlCommandWrapper.ExecuteReaderAsync(CommandBehavior.SequentialAccess, CancellationToken.None))
{
while (await sqlDataReader.ReadAsync())
{
(string uri, string stringStatus, DateTimeOffset? lastUpdated, bool?isPartiallySupported) = sqlDataReader.ReadRow(
VLatest.SearchParam.Uri,
VLatest.SearchParam.Status,
VLatest.SearchParam.LastUpdated,
VLatest.SearchParam.IsPartiallySupported);
if (string.IsNullOrEmpty(stringStatus) || lastUpdated == null || isPartiallySupported == null)
{
// These columns are nullable because they are added to dbo.SearchParam in a later schema version.
// They should be populated as soon as they are added to the table and should never be null.
throw new NullReferenceException(Resources.SearchParameterStatusShouldNotBeNull);
}
var status = Enum.Parse <SearchParameterStatus>(stringStatus, true);
var resourceSearchParameterStatus = new ResourceSearchParameterStatus()
{
Uri = new Uri(uri),
Status = status,
IsPartiallySupported = (bool)isPartiallySupported,
LastUpdated = (DateTimeOffset)lastUpdated,
};
if (SqlServerSortingValidator.SupportedParameterUris.Contains(resourceSearchParameterStatus.Uri))
{
resourceSearchParameterStatus.SortStatus = SortParameterStatus.Enabled;
}
else
{
resourceSearchParameterStatus.SortStatus = SortParameterStatus.Supported;
}
parameterStatuses.Add(resourceSearchParameterStatus);
}
}
return(parameterStatuses);
}
}
public virtual bool Fill(Microsoft.Data.SqlClient.SqlDataReader reader, bool closeReader)
{
try {
if ((reader.Read() == false))
{
reader.Close();
return(false);
}
else
{
if ((reader["column_name"].Equals(System.DBNull.Value) == false))
{
this.ColumnName = ((string)(System.Convert.ChangeType(reader["column_name"], typeof(string))));
}
if ((reader["data_type"].Equals(System.DBNull.Value) == false))
{
this.DataType = ((string)(System.Convert.ChangeType(reader["data_type"], typeof(string))));
}
if ((reader["character_maximum_length"].Equals(System.DBNull.Value) == false))
{
this.CharMaximum = ((int)(System.Convert.ChangeType(reader["character_maximum_length"], typeof(int))));
}
return(true);
}
}
catch (System.Exception ex) {
throw new System.ApplicationException("Error in the Auto-Generated: ColumnInfo.Fill(SqlDataReader) Method", ex);
}
finally {
if ((closeReader == true))
{
reader.Close();
}
}
}
/// <summary>
/// Fills object from a SqlClient Data Reader
/// </summary>
/// <remarks></remarks>
public void Fill(Microsoft.Data.SqlClient.SqlDataReader dr)
{
_ID = (int)dr[db_ID];
_FirstName = (string)dr[db_FirstName];
_LastName = (string)dr[db_LastName];
_Office = (int)dr[db_Office];
}
public async Task <IActionResult> PromoteStudents(EnrStud input)
{
SqlConnection conn = new SqlConnection(_connectionString);
SqlCommand com = new SqlCommand();
com.Connection = conn;
com.CommandText =
@"select
e.IdEnrollment, e.Semester, e.StartDate, s.IdStudy, s.Name
from Enrollment e
left join Studies s on s.IdStudy = e.IdStudy
where
s.Name = @studyName
and e.Semester = @semester";
com.Parameters.AddWithValue("studyName", input.Studies);
com.Parameters.AddWithValue("semester", input.Semester);
conn.Open();
SqlDataReader dataReader = await com.ExecuteReaderAsync();
await dataReader.ReadAsync();
Enrollment enr = new Enrollment
{
IdEnrollment = int.Parse(dataReader["IdEnrollment"].ToString()),
Semester = int.Parse(dataReader["Semester"].ToString()),
StartDate = DateTime.Parse(dataReader["StartDate"].ToString()),
Study = new Study
{
IdStudy = int.Parse(dataReader["IdStudy"].ToString()),
Name = dataReader["Name"].ToString(),
}
};
if (enr == null)
{
return(NotFound());
}
conn = new SqlConnection(_connectionString);
com = new SqlCommand();
com.Connection = conn;
com.CommandType = System.Data.CommandType.StoredProcedure;
com.CommandText = "PromoteStudents";
com.Parameters.AddWithValue("studies", input.Studies);
com.Parameters.AddWithValue("semester", input.Semester);
conn.Open();
await com.ExecuteNonQueryAsync();
return(StatusCode(200));
}
/// <summary>
/// Fills object from a SqlClient Data Reader
/// </summary>
/// <remarks></remarks>
public void Fill(Microsoft.Data.SqlClient.SqlDataReader dr)
{
_ID = (int)dr[db_ID];
_FirstName = (string)dr[db_FirstName];
_LastName = (string)dr[db_LastName];
_Age = (int)dr[db_Age];
_NickName = (string)dr[db_NickName];
_FavoriteColor = (string)dr[db_FavoriteColor];
}
public virtual bool Fill(Microsoft.Data.SqlClient.SqlDataReader reader, bool closeReader)
{
try {
if ((reader.Read() == false))
{
reader.Close();
return(false);
}
else
{
if ((reader["ScriptFileName"].Equals(System.DBNull.Value) == false))
{
this.ScriptFileName = ((string)(System.Convert.ChangeType(reader["ScriptFileName"], typeof(string))));
}
if ((reader["ScriptId"].Equals(System.DBNull.Value) == false))
{
this.ScriptId = new System.Guid(reader["ScriptId"].ToString());
}
if ((reader["Sequence"].Equals(System.DBNull.Value) == false))
{
this.Sequence = ((int)(System.Convert.ChangeType(reader["Sequence"], typeof(int))));
}
if ((reader["ScriptText"].Equals(System.DBNull.Value) == false))
{
this.ScriptText = ((string)(System.Convert.ChangeType(reader["ScriptText"], typeof(string))));
}
if ((reader["Database"].Equals(System.DBNull.Value) == false))
{
this.Database = ((string)(System.Convert.ChangeType(reader["Database"], typeof(string))));
}
if ((reader["Tag"].Equals(System.DBNull.Value) == false))
{
this.Tag = ((string)(System.Convert.ChangeType(reader["Tag"], typeof(string))));
}
return(true);
}
}
catch (System.Exception ex) {
throw new System.ApplicationException("Error in the Auto-Generated: RebuilderData.Fill(SqlDataReader) Method", ex);
}
finally {
if ((closeReader == true))
{
reader.Close();
}
}
}
public virtual bool Fill(Microsoft.Data.SqlClient.SqlDataReader reader, bool closeReader)
{
try {
if ((reader.Read() == false))
{
reader.Close();
return(false);
}
else
{
if ((reader["ObjectName"].Equals(System.DBNull.Value) == false))
{
this.ObjectName = ((string)(System.Convert.ChangeType(reader["ObjectName"], typeof(string))));
}
if ((reader["ObjectType"].Equals(System.DBNull.Value) == false))
{
this.ObjectType = ((string)(System.Convert.ChangeType(reader["ObjectType"], typeof(string))));
}
if ((reader["CreateDate"].Equals(System.DBNull.Value) == false))
{
this.CreateDate = ((System.DateTime)(System.Convert.ChangeType(reader["CreateDate"], typeof(System.DateTime))));
}
if ((reader["AlteredDate"].Equals(System.DBNull.Value) == false))
{
this.AlteredDate = ((System.DateTime)(System.Convert.ChangeType(reader["AlteredDate"], typeof(System.DateTime))));
}
if ((reader["SchemaOwner"].Equals(System.DBNull.Value) == false))
{
this.SchemaOwner = ((string)(System.Convert.ChangeType(reader["SchemaOwner"], typeof(string))));
}
return(true);
}
}
catch (System.Exception ex) {
throw new System.ApplicationException("Error in the Auto-Generated: ObjectData.Fill(SqlDataReader) Method", ex);
}
finally {
if ((closeReader == true))
{
reader.Close();
}
}
}
public virtual bool Fill(Microsoft.Data.SqlClient.SqlDataReader reader, bool closeReader)
{
try {
if ((reader.Read() == false))
{
reader.Close();
return(false);
}
else
{
if ((reader["BuildFileName"].Equals(System.DBNull.Value) == false))
{
this.BuildFileName = ((string)(System.Convert.ChangeType(reader["BuildFileName"], typeof(string))));
}
if ((reader["ScriptCount"].Equals(System.DBNull.Value) == false))
{
this.ScriptCount = ((int)(System.Convert.ChangeType(reader["ScriptCount"], typeof(int))));
}
if ((reader["commitDate"].Equals(System.DBNull.Value) == false))
{
this.CommitDate = ((System.DateTime)(System.Convert.ChangeType(reader["commitDate"], typeof(System.DateTime))));
}
if ((reader["database"].Equals(System.DBNull.Value) == false))
{
this.Database = ((string)(System.Convert.ChangeType(reader["database"], typeof(string))));
}
return(true);
}
}
catch (System.Exception ex) {
throw new System.ApplicationException("Error in the Auto-Generated: CommittedBuildData.Fill(SqlDataReader) Method", ex);
}
finally {
if ((closeReader == true))
{
reader.Close();
}
}
}
internal Course(Microsoft.Data.SqlClient.SqlDataReader dr)
{
Fill(dr);
}
public async Task <IReadOnlyCollection <ResourceSearchParameterStatus> > GetSearchParameterStatuses(CancellationToken cancellationToken)
{
// If the search parameter table in SQL does not yet contain status columns
if (_schemaInformation.Current < SchemaVersionConstants.SearchParameterStatusSchemaVersion)
{
// Get status information from file.
return(await _filebasedSearchParameterStatusDataStore.GetSearchParameterStatuses(cancellationToken));
}
using (IScoped <SqlConnectionWrapperFactory> scopedSqlConnectionWrapperFactory = _scopedSqlConnectionWrapperFactory())
using (SqlConnectionWrapper sqlConnectionWrapper = await scopedSqlConnectionWrapperFactory.Value.ObtainSqlConnectionWrapperAsync(cancellationToken, true))
using (SqlCommandWrapper sqlCommandWrapper = sqlConnectionWrapper.CreateSqlCommand())
{
VLatest.GetSearchParamStatuses.PopulateCommand(sqlCommandWrapper);
var parameterStatuses = new List <ResourceSearchParameterStatus>();
using (SqlDataReader sqlDataReader = await sqlCommandWrapper.ExecuteReaderAsync(CommandBehavior.SequentialAccess, cancellationToken))
{
while (await sqlDataReader.ReadAsync(cancellationToken))
{
short id;
string uri;
string stringStatus;
DateTimeOffset?lastUpdated;
bool? isPartiallySupported;
ResourceSearchParameterStatus resourceSearchParameterStatus;
if (_schemaInformation.Current >= SchemaVersionConstants.SearchParameterSynchronizationVersion)
{
(id, uri, stringStatus, lastUpdated, isPartiallySupported) = sqlDataReader.ReadRow(
VLatest.SearchParam.SearchParamId,
VLatest.SearchParam.Uri,
VLatest.SearchParam.Status,
VLatest.SearchParam.LastUpdated,
VLatest.SearchParam.IsPartiallySupported);
if (string.IsNullOrEmpty(stringStatus) || lastUpdated == null || isPartiallySupported == null)
{
// These columns are nullable because they are added to dbo.SearchParam in a later schema version.
// They should be populated as soon as they are added to the table and should never be null.
throw new SearchParameterNotSupportedException(Resources.SearchParameterStatusShouldNotBeNull);
}
var status = Enum.Parse <SearchParameterStatus>(stringStatus, true);
resourceSearchParameterStatus = new SqlServerResourceSearchParameterStatus
{
Id = id,
Uri = new Uri(uri),
Status = status,
IsPartiallySupported = (bool)isPartiallySupported,
LastUpdated = (DateTimeOffset)lastUpdated,
};
}
else
{
(uri, stringStatus, lastUpdated, isPartiallySupported) = sqlDataReader.ReadRow(
VLatest.SearchParam.Uri,
VLatest.SearchParam.Status,
VLatest.SearchParam.LastUpdated,
VLatest.SearchParam.IsPartiallySupported);
if (string.IsNullOrEmpty(stringStatus) || lastUpdated == null || isPartiallySupported == null)
{
// These columns are nullable because they are added to dbo.SearchParam in a later schema version.
// They should be populated as soon as they are added to the table and should never be null.
throw new SearchParameterNotSupportedException(Resources.SearchParameterStatusShouldNotBeNull);
}
var status = Enum.Parse <SearchParameterStatus>(stringStatus, true);
resourceSearchParameterStatus = new ResourceSearchParameterStatus
{
Uri = new Uri(uri),
Status = status,
IsPartiallySupported = (bool)isPartiallySupported,
LastUpdated = (DateTimeOffset)lastUpdated,
};
}
if (_schemaInformation.Current >= SchemaVersionConstants.AddMinMaxForDateAndStringSearchParamVersion)
{
// For schema versions starting from AddMinMaxForDateAndStringSearchParamVersion we will check
// whether the corresponding type of the search parameter is supported.
SearchParameterInfo paramInfo = null;
try
{
paramInfo = _searchParameterDefinitionManager.GetSearchParameter(resourceSearchParameterStatus.Uri.OriginalString);
}
catch (SearchParameterNotSupportedException)
{
}
if (paramInfo != null && SqlServerSortingValidator.SupportedSortParamTypes.Contains(paramInfo.Type))
{
resourceSearchParameterStatus.SortStatus = SortParameterStatus.Enabled;
}
else
{
resourceSearchParameterStatus.SortStatus = SortParameterStatus.Disabled;
}
}
else
{
if (_sortingValidator.SupportedParameterUris.Contains(resourceSearchParameterStatus.Uri))
{
resourceSearchParameterStatus.SortStatus = SortParameterStatus.Enabled;
}
else
{
resourceSearchParameterStatus.SortStatus = SortParameterStatus.Disabled;
}
}
parameterStatuses.Add(resourceSearchParameterStatus);
}
}
return(parameterStatuses);
}
}
internal Instructor(Microsoft.Data.SqlClient.SqlDataReader dr)
{
Fill(dr);
}
public async Task <IActionResult> registerStudent(StdEnr input)
{
SqlConnection conn = new SqlConnection(_connectionString);
SqlCommand com = new SqlCommand();
Study study;
{
com.Connection = conn;
com.CommandText = "select IdStudy, Name from Studies where Name = @name";
com.Parameters.AddWithValue("name", input.Studies);
conn.Open();
try
{
SqlDataReader dataReader = await com.ExecuteReaderAsync();
await dataReader.ReadAsync();
study = new Study
{
IdStudy = int.Parse(dataReader["IdStudy"].ToString()),
Name = dataReader["Name"].ToString()
};
if (study == null)
{
return(BadRequest());
}
}
catch
{
return(null);
}
}
conn = new SqlConnection(_connectionString);
com = new SqlCommand();
conn.Open();
SqlTransaction transaction = conn.BeginTransaction();
com.Connection = conn;
com.Transaction = transaction;
com.CommandText =
@"declare @enrollmentId int
select
@enrollmentId = e.IdEnrollment
from Enrollment e
left join Studies s on e.IdStudy = s.IdStudy
where e.IdStudy = @studyId and e.Semester = 1
if @enrollmentId is null
begin
select @enrollmentId = max(IdEnrollment) + 1 from Enrollment
insert into Enrollment values (@enrollmentId, 1, @studyId, getdate());
end
insert into Student values (@index, @firstName, @lastName, @birthDate, @enrollmentId)";
com.Parameters.AddWithValue("studyId", study.IdStudy);
com.Parameters.AddWithValue("index", input.IndexNumber);
com.Parameters.AddWithValue("firstName", input.FirstName);
com.Parameters.AddWithValue("lastName", input.LastName);
com.Parameters.AddWithValue("birthDate", input.BirthDate);
try
{
await com.ExecuteNonQueryAsync();
await transaction.CommitAsync();
}
catch (Exception e)
{
await transaction.RollbackAsync();
}
return(StatusCode(200));
}
internal Student(Microsoft.Data.SqlClient.SqlDataReader dr)
{
Fill(dr);
}
/// <summary> /// ''' This function is called by the Security DAL to load this object from the database /// ''' </summary> public abstract void Fill(Microsoft.Data.SqlClient.SqlDataReader dr);
