private List <string> SetDailySchedule(string day)
{
if (EmployerSession.GetClassNumber() != null || BoxClasses.SelectedIndex != -1)
{
List <string> dailySchedule = new List <string>();
string cn = EmployerSession.GetClassNumber();
if (cn == "")
{
cn = (string)BoxClasses.SelectedItem;
}
else
{
cn = EmployerSession.GetClassNumber();
}
SqlConnection connection = new SqlConnection("Server=localhost\\SQLEXPRESS;Database=master;Trusted_Connection=True;");
SqlCommand command = new SqlCommand("USE SchoolBase SELECT [Дата], [Предмет] FROM SchoolSchedule WHERE [Дата] BETWEEN '" + day + " 0:00' AND '" + day + " 23:59' AND [Класс] = '" + cn + "' ORDER BY [Дата]", connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
dailySchedule.Add(reader.GetDateTime(0).ToString("HH:mm") + " " + reader.GetString(1));
}
connection.Close();
return(dailySchedule);
}
return(null);
}
public UserEmployerGrades()
{
InitializeComponent();
studentIdList = new List <int>();
DeleteGradeEnabled = EmployerSession.IsPrincipal();
AddStudentEnabled = EmployerSession.IsPrincipal();
string commandText = "USE SchoolBase SELECT [Идентификатор], [Имя учащегося], [Фамилия учащегося] FROM dbo.SchoolStudents";
if (EmployerSession.GetClassNumber() != "")
{
commandText += " WHERE [Класс] = '" + EmployerSession.GetClassNumber() + "'";
}
SqlConnection connection = new SqlConnection("Server=localhost\\SQLEXPRESS;Database=master;Trusted_Connection=True;");
SqlCommand command = new SqlCommand(commandText, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
studentIdList.Add(reader.GetInt32(0));
ListStudents.Items.Add(reader.GetInt32(0) + " | " +
reader.GetString(1) + " | " +
reader.GetString(2));
}
connection.Close();
}
