private static int AddCourseMaterial(StudentSystemData data)
{
Material material = new Material
{
Name = "JSAdvanced Simulating OOP Homework",
Link = "https://softuni.bg/downloads/svn/javascript-oop/March-2015/2.%20Simulating-OOP-in-JavaScript-Homework.docx",
MaterialType = MaterialType.HomeworkAssignment
};
data.Materials.Add(material);
return data.SaveChanges();
}
private static int AddStudent(StudentSystemData data)
{
Student student = new Student
{
Name = "Gergana Gencheva",
RegistrationDate = DateTime.Now,
BirthDay = new DateTime(1825, 02, 02),
PhoneNumber = "123469899"
};
data.Students.Add(student);
return data.SaveChanges();
}
public static void Main(string[] args)
{
var studentDb = new StudentSystemData();
var newResource = new Resource { Link = "www.abv.bg", Name = "Email", Type = ResourceType.Other };
studentDb.Resources.Add(newResource);
Student student = new Student
{
FirstName = "Ta Pepelqqq",
LastName = "Ne vyrvi",
Birthday = new DateTime(1825, 02, 02),
PhoneNumber = "123469899"
};
studentDb.Students.Add(student);
Course course = new Course { Description = "Za Strugari", Name = "Strug mania", Price = 1.1M, EndDate = new DateTime(2016, 12, 1), StartDate = DateTime.Now };
course.Resources.Add(newResource);
studentDb.Courses.Add(course);
studentDb.SaveChanges();
var studentsHomeworks = GetStudentsWithHomeworks(studentDb);
foreach (var studentHomeworks in studentsHomeworks)
{
Console.WriteLine(studentHomeworks.FirstName + " " + studentHomeworks.LastName);
var homeworks = studentHomeworks.Homeworks;
foreach (var homework in homeworks)
{
Console.WriteLine(" " + homework.CourseName + "-" + homework.SentOn.Date);
}
Console.WriteLine();
}
var coursesWithResources = GetCoursesWithResources(studentDb);
foreach (var courseWithResources in coursesWithResources)
{
Console.WriteLine(courseWithResources.Name);
var resources = courseWithResources.Resources;
foreach (var resource in resources)
{
Console.WriteLine(" " + resource.Name + "-" + resource.Link);
}
Console.WriteLine();
}
}
private static IEnumerable<dynamic> GetStudentsWithHomeworks(StudentSystemData studentDb)
{
var studentsHomeworks =
studentDb.Students.All()
.Select(
s =>
new
{
s.FirstName,
s.LastName,
Homeworks = s.Homeworks.Select(h => new { CourseName = h.Course.Name, h.SentOn })
});
return studentsHomeworks.ToList();
}
private static void ListCoursesWithMaterials(StudentSystemData data)
{
StringBuilder sb = new StringBuilder();
var courses = data.Courses.All().ToList();
foreach (Course course in courses.ToList())
{
sb.AppendFormat("Course {0}", course.Name);
sb.Append("\n\tMaterials:");
foreach (var material in course.Materials)
{
sb.AppendFormat("\n\t\tMaterial: {0}", material.Name);
}
sb.AppendLine();
}
Console.WriteLine(sb.ToString());
}
private static int AddCourseWithMaterials(StudentSystemData data)
{
Course course = new Course
{
Name = "JS Advanced",
Description = "JavaScript course for advanced programmers",
StartDate = new DateTime(2015, 02, 27),
EndDate = new DateTime(2015, 04, 21),
Price = 0m
};
Material material = new Material
{
Name = "JSAdvanced Function Expressions Demo",
Link = "https://github.com/SoftUni/Advanced-JavaScript/tree/master/1.%20Functions-and-Function-Expressions",
MaterialType = MaterialType.CodeStubs
};
data.Materials.Add(material);
course.Materials.Add(material);
//material.Courses.Add(course);
data.Courses.Add(course);
return data.SaveChanges();
}
private static void ListStudentsWithHomeworks(StudentSystemData data)
{
StringBuilder sb = new StringBuilder();
var students = data.Students.All().ToList();
foreach (Student student in students.ToList())
{
sb.AppendFormat("Student {0}", student.Name);
sb.Append("\n\tHomeworks:");
foreach (var hw in student.Homeworks)
{
sb.AppendFormat("\n\t\tHomework Sent on:{0}, Course: {1}", hw.SentDate.ToString(), hw.Course.Name);
}
sb.AppendLine();
}
Console.WriteLine(sb.ToString());
}
static void Main(string[] args)
{
var data = new StudentSystemData();
string input = string.Empty;
do
{
PrintMenu();
input = Console.ReadLine();
switch (input.ToLower())
{
case "1":
ListStudentsWithHomeworks(data);
break;
case "2":
ListCoursesWithMaterials(data);
break;
case "3":
if (AddCourseWithMaterials(data) > 0)
{
Console.WriteLine("Course with material added successfully");
}
break;
case "4":
if (AddStudent(data) > 0)
{
Console.WriteLine("Student added successfully");
}
break;
case "5":
if (AddCourseMaterial(data) > 0)
{
Console.WriteLine("Course material added successfully");
}
break;
case "end":
Console.WriteLine("Good Bye!");
break;
default:
Console.WriteLine("Invalid Input. Try again".ToUpper());
break;
}
} while (input.ToLower() != "end");
}
protected BaseApiController()
{
var context = new StudentSystemDbContext();
this.Data = new StudentSystemData(context);
}
private static List<Course> GetCoursesWithResources(StudentSystemData studentDb)
{
var coursesResources = studentDb.Courses.All().Include(s => s.Resources);
return coursesResources.ToList();
}
public static void Main()
{
var data = new StudentSystemData();
//var firstStudentContactInfo = new ContactInfo()
//{
// Email = "*****@*****.**",
// Number = "53453465352353",
// Skype = "sdfsdgdfgdfgd"
//};
#region filling some date
//var courses = new[]
//{
// new Course { Name = "EF Course" },
// new Course { Name = ".NET MVC" }
//};
//data.Courses.Add(courses[0]);
//data.Courses.Add(courses[1]);
//data.Courses.SaveChanges();
//var firstStudent = new Student()
//{
// FirstName = "Vani",
// LastName = "Banani",
// Age = 27,
// StudentStatus = StudentStatus.Online,
// ContactInfo = firstStudentContactInfo,
// Courses = courses
//};
//data.Students.Add(firstStudent);
//data.Students.SaveChanges();
//var secodnStudentContactInfo = new ContactInfo()
//{
// Email = "*****@*****.**"
//};
//var secondStudent = new Student()
//{
// FirstName = "Goshkata",
// LastName = "Goshkov",
// Age = 23,
// ContactInfo = secodnStudentContactInfo,
// Courses = data.Courses.All().ToList()
//};
//data.Students.Add(secondStudent);
//data.Students.SaveChanges();
#endregion
Console.WriteLine("Students:");
foreach (var student in data.Students.All())
{
Console.WriteLine(student + Environment.NewLine);
}
Console.WriteLine("Courses:");
foreach (var course in data.Courses.All())
{
Console.WriteLine(course);
}
}
