public bool UpdateProgram(NaitProgram SelectedProgram)
{
bool Success = false;
SqlConnection BAIS3150Connection = null;
SqlCommand UpdateProgramCommand = null;
SqlParameter ProgramParameter;
try
{
BAIS3150Connection = new SqlConnection()
{
ConnectionString = _connectionString
};
BAIS3150Connection.Open();
UpdateProgramCommand = new SqlCommand
{
Connection = BAIS3150Connection,
CommandType = CommandType.StoredProcedure,
CommandText = "UpdateProgramDescription"
};
ProgramParameter = new SqlParameter
{
ParameterName = "@ProgramCode",
DbType = DbType.String,
Direction = ParameterDirection.Input,
SqlValue = SelectedProgram.ProgramCode
};
UpdateProgramCommand.Parameters.Add(ProgramParameter);
ProgramParameter = new SqlParameter
{
ParameterName = "@Description",
DbType = DbType.String,
Direction = ParameterDirection.Input,
SqlValue = SelectedProgram.Description
};
UpdateProgramCommand.Parameters.Add(ProgramParameter);
UpdateProgramCommand.ExecuteNonQuery();
Success = true;
}
finally
{
if (BAIS3150Connection != null)
{
BAIS3150Connection.Close();
}
if (UpdateProgramCommand != null)
{
UpdateProgramCommand.Dispose();
}
}
return(Success);
}
public void OnPost()
{
searchedProgram = _requestDirector.FindProgram(SearchBox);
ProgramCode = searchedProgram.ProgramCode;
Description = searchedProgram.Description;
EnrolledStudents = searchedProgram.EnrolledStudent;
if (searchedProgram == null)
{
Message = "Program Does Not Exist";
}
}
public NaitProgram GetProgram(string ProgramCode)
{
NaitProgram SearchedProgram = null;
SqlConnection BAIS3150Connection = null;
SqlCommand GetProgramCommand = null;
SqlDataReader GetProgramDataReader = null;
StudentServices StudentArray = new StudentServices(_connectionString);
try
{
BAIS3150Connection = new SqlConnection()
{
ConnectionString = _connectionString
};
BAIS3150Connection.Open();
GetProgramCommand = new SqlCommand
{
Connection = BAIS3150Connection,
CommandType = CommandType.StoredProcedure,
CommandText = "GetProgramByProgramCode"
};
SqlParameter ProgramCodeParameter = new SqlParameter
{
ParameterName = "@ProgramCode",
DbType = DbType.String,
Direction = ParameterDirection.Input,
SqlValue = ProgramCode
};
GetProgramCommand.Parameters.Add(ProgramCodeParameter);
GetProgramDataReader = GetProgramCommand.ExecuteReader();
if (GetProgramDataReader.HasRows)
{
GetProgramDataReader.Read();
SearchedProgram = new NaitProgram
{
Description = GetProgramDataReader[GetProgramDataReader.GetOrdinal("Description")].ToString()
};
SearchedProgram.ProgramCode = ProgramCode;
SearchedProgram.EnrolledStudent = StudentArray.GetStudents(ProgramCode);
}
}
finally
{
if (GetProgramDataReader != null)
{
GetProgramDataReader.Close();
}
if (GetProgramCommand != null)
{
GetProgramCommand.Dispose();
}
if (BAIS3150Connection != null)
{
BAIS3150Connection.Close();
}
}
return(SearchedProgram);
}
