public static StudentModel ToModel(this StudentsDb stu)
{
return(new StudentModel()
{
OStudentId = stu.Id,
Name = stu.Name,
Surname = stu.Surname,
BirthYear = stu.BirthYear,
Klase = stu.Klase,
});
}
public ActionResult GetById(int id)
{
// get student from the database
StudentsDb StDb = new StudentsDb();
Student st = new Student();
List <Student> stud = new List <Student>();
//st = StDb.GetStudents().Where(s => s.StudentId == id).FirstOrDefault();
//stud.Add(st);
return(View(stud));
}
//api/studentsRW
public IHttpActionResult Get()
{
try
{
return(Ok(StudentsDb.GetAllStudents()));
}
catch (Exception ex)
{
//return BadRequest(ex.Message);
return(Content(HttpStatusCode.InternalServerError, ex));
}
}
public IHttpActionResult Get(int id)
{
try
{
Student s = StudentsDb.GetStudentByID(id);
if (s == null)
{
return(Content(HttpStatusCode.NotFound, $"student with id = {id} was not found:("));
}
return(Ok(s));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.BadRequest, ex));
}
}
//// GET: Student
//public ActionResult Index()
//{
// return View();
//}
// HOW TO CREAT VIEW, So, open a StudentController class -> right click inside Index method -> click Add View..
//GET: Student
public ActionResult Index(int id = 0)
{
//StudentsDb StDb = new StudentsDb();
//return View(StDb.GetStudents());
//return "This is Index action method of StudentController";
//******************************//
// get student from the database
StudentsDb StDb = new StudentsDb();
StudentFullDetails studentFD = new StudentFullDetails();
Student st = new Student();
List <Student> stud = new List <Student>();
List <StudentFullDetails> studFull = new List <StudentFullDetails>();
studentFD = StDb.GetStudents().Where(s => s._Student.StudentId == id).FirstOrDefault();
if (studentFD == null)
{
return(View());
}
stud.Add(studentFD._Student);
studFull.Add(studentFD);
// return View(stud);
return(View(studFull));
}
static async Task Main(string[] args)
{
const string connection_str = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=StudentsDb;Integrated Security=True;";
//var services_collection = new ServiceCollection();
//services_collection.AddDbContext<StudentsDb>(options => options.UseSqlServer(connection_str));
//var services = services_collection.BuildServiceProvider();
//using (var db = services.GetRequiredService<StudentsDb>())
//{
//}
using (var db = new StudentsDb(new DbContextOptionsBuilder <StudentsDb>().UseSqlServer(connection_str).Options))
{
await db.Database.EnsureCreatedAsync();
var students_count = await db.Students.CountAsync();
Console.WriteLine($"Число студентов в базе = {students_count}");
}
using (var db = new StudentsDb(new DbContextOptionsBuilder <StudentsDb>().UseSqlServer(connection_str).Options))
{
int k = 0;
if (await db.Students.CountAsync() == 0)
{
for (var i = 0; i < 10; i++)
{
var group = new Group
{
Name = $"Группа {i}",
Description = $"Описание группы {i}",
Students = new List <Student>()
};
for (var j = 0; j < 10; j++)
{
var student = new Student
{
Name = $"Студент{k}",
Surname = $"Фамилия {k}",
Patronymic = $"Отчество{k}",
//Description = $"Описание студента{k}"
};
k++;
group.Students.Add(student);
}
db.Groups.Add(group);
}
await db.SaveChangesAsync();
}
}
using (var db = new StudentsDb(new DbContextOptionsBuilder <StudentsDb>().UseSqlServer(connection_str).Options))
{
var students = await db.Students
.Include(s => s.Group)
.Where(s => s.Group.Name == "Группа 5").ToArrayAsync();
foreach (var student in students)
{
Console.WriteLine($"[{student.Id}] {student.Name} {student.Group.Name}");
}
}
Console.WriteLine("Главный поток работу закончил");
Console.ReadLine();
}
public StudentFullDetails GetStudnet(int id)
{
StudentsDb StDb = new StudentsDb();
return(StDb.GetStudents().Where(s => s._Student.StudentId == id).FirstOrDefault());
}
