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