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