public async Task <HttpResponseMessage> GetTables(string prepodname) { using (SqlConnection connection = new SqlConnection(connectionString)) { string cmd = $"select * from TableList where ProfessorID = (select ProfessorID from ProfessorTable where EMail = N'{prepodname}')"; SqlCommand command = new SqlCommand(cmd, connection); List <ProfessorTable> tables = new List <ProfessorTable>(); try { await connection.OpenAsync(); SqlDataReader reader = await command.ExecuteReaderAsync(); while (await reader.ReadAsync()) { ProfessorTable table = new ProfessorTable(); table.TableName = reader["TableName"].ToString(); table.SubjectName = reader["SubjectName"].ToString(); table.StudentsGroups = reader["StudentsGroups"].ToString(); table.StudentsCourse = reader["StudentsCourse"].ToString(); table.UniqueCode = reader["UniqueCode"].ToString(); tables.Add(table); } return(Request.CreateResponse(HttpStatusCode.Accepted, tables)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "При обработки запроса возникло исключение: " + ex.Message)); } } }
private void ProfessorTable(int i) { Random random = new Random(); ProfessorTable professor = new ProfessorTable(); using (UniversityContext context = new UniversityContext()) { for (int j = 0; j < 100; j++) { DateTime date1 = new DateTime(1950, 1, 1); date1 = date1.AddYears(random.Next(0, 69)); date1 = date1.AddMonths(random.Next(0, 12)); date1 = date1.AddDays(random.Next(0, 30)); var prepod = Prepod(); professor.CathedraId = random.Next(1, i); professor.Name = prepod.fname; professor.Surname = prepod.lname; professor.Patronymic = prepod.patronymic; professor.WorkPosition = WorkPosition(); professor.AcademicDegree = AcademicDegree(); professor.Other = null; professor.StartDate = date1; context.Professors.Add(professor); context.SaveChanges(); } } }
static void Main(string[] args) { var student = new StudentTable(); student.Add(new Student { FullName = "Azat Mukushev", GroupId = 1 }); var professor = new ProfessorTable(); professor.Add(new Professor { FullName = "Oleg Skidan" }); }