// Обновляем информацию об ученике в БД (класс изменяется).
public static void UpdatePupilWithClass(int pupilId, string name, string surname, string patronymic, int classID)
{
PupilFullInformation pupil = new PupilFullInformation();
string connectionString = @"Data Source=DESKTOP-81JSABO\SQLEXPRESS;Initial Catalog=ElectronicJournal;Integrated Security=True";
string sqlExpression = "[sp_UpdatePupilInf]";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(sqlExpression, connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pupilIDParam = new SqlParameter
{
ParameterName = "@Pupil_ID",
Value = pupilId
};
SqlParameter pupilNameParam = new SqlParameter
{
ParameterName = "@Name",
Value = name
};
SqlParameter pupilSurnameParam = new SqlParameter
{
ParameterName = "@Surname",
Value = surname
};
SqlParameter pupilPatronymicParam = new SqlParameter
{
ParameterName = "@Patronymic",
Value = patronymic
};
SqlParameter pupilClassIDParam = new SqlParameter
{
ParameterName = "@Class_ID",
Value = classID
};
command.Parameters.Add(pupilIDParam);
command.Parameters.Add(pupilNameParam);
command.Parameters.Add(pupilSurnameParam);
command.Parameters.Add(pupilPatronymicParam);
command.Parameters.Add(pupilClassIDParam);
command.ExecuteNonQuery();
}
}
// Получаем полную информацыю об ученике из БД.
public static PupilFullInformation GetPupilsFullInformation(int ID)
{
PupilFullInformation pupil = new PupilFullInformation();
string connectionString = @"Data Source=DESKTOP-81JSABO\SQLEXPRESS;Initial Catalog=ElectronicJournal;Integrated Security=True";
string sqlExpression = "sp_GetFullInformation";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(sqlExpression, connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter nameParam = new SqlParameter
{
ParameterName = "@Pupil_ID",
Value = ID
};
command.Parameters.Add(nameParam);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read()) // построчно считываем данные
{
int id = reader.GetInt32(0);
string name = reader.GetString(1);
string surname = reader.GetString(2);
string patronymic = reader.GetString(3);
string pupilClass = reader.GetString(4);
DateTime date_Of_Birth = reader.GetDateTime(5);
int age = reader.GetInt32(6);
string pupil_Phone = reader.GetString(7);
string parent_Phone = reader.GetString(8);
string address = reader.GetString(9);
pupil = new PupilFullInformation(id, name, surname, patronymic, pupilClass, date_Of_Birth, age, pupil_Phone, parent_Phone, address);
}
}
reader.Close();
}
return(pupil);
}