public ContentResult GetStudents() { var students = SelectStudent.SelectAvailable(); return(new ContentResult { Content = JsonSerializer.Serialize(students), ContentType = "application/json", StatusCode = (int)HttpStatusCode.OK }); }
public ContentResult GetStudentsFor(GroupModel group) { var students = SelectStudent.Select(group); return(new ContentResult { Content = JsonSerializer.Serialize(students), ContentType = "application/json", StatusCode = (int)HttpStatusCode.OK }); }
private static void RunDemo(SqlConnection connection) { var selectStudent = new SelectStudent(); var insertStudent = new InsertUser(); var deleteStudent = new DeleteUser(); var elev = new Student { Name = "", Path = "[dbo].[Student]" }; Console.Write("You can Delete, Insert, Update or Select a user {Template: [Command] [User]}: "); var input = Console.ReadLine(); if (!string.IsNullOrEmpty(input)) { var command = input.Split(' '); switch (command[0].ToLower()) { case "delete": elev.Name = command[1]; deleteStudent.DeleteUser(connection, elev.Name, elev.Path); Console.WriteLine($"Deleting user {elev.Name}..."); break; case "insert": elev.Name = command[1]; insertStudent.AddUser(connection, elev.Name, elev.Path); Console.WriteLine($"Creating new user {elev.Name}..."); break; case "update": break; case "select": break; default: Console.WriteLine("Invalid input, please try again..." + Environment.NewLine); break; } } else { Console.WriteLine("Invalid input, please try again..." + Environment.NewLine); } Console.WriteLine("Outputting list of all students: "); var students = selectStudent.GetAllStudents(connection); foreach (var student in students) { Console.WriteLine(student); } }
private static void RunDemo(SqlConnection connection) { var selectStudent = new SelectStudent(); Console.WriteLine("Kjører GetStudent"); Console.WriteLine(selectStudent.GetStudent(connection, 2)); Console.WriteLine("Kjører GetAllStudents"); var allStudents = selectStudent.GetAllStudent(connection); foreach (var student in allStudents) { Console.WriteLine(student); } }