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();
}
}
static void Main(string[] args)
{
//You may need to change the data source of the connection string in the App.cofig file because I am using .\SQLEXPRESS!!!
var data = new StudentSystemData();
while (true)
{
Console.WriteLine("Enter 1 to list all students\n 2 to list all courses\n 3 to list all materials\n 4 to list all homeworks\n exit to exit the program");
string command = Console.ReadLine();
switch (command)
{
case "1":
var students = data.Students.All();
foreach (var student in students)
{
Console.WriteLine(student.FirstName + " " + student.LastName + " " + student.Number);
}
break;
case "2":
var courses = data.Courses.All();
foreach (var course in courses)
{
Console.WriteLine(course.Name);
Console.WriteLine(course.Description);
}
break;
case "3":
var materials = data.Materials.All();
foreach (var material in materials)
{
Console.WriteLine(material.Content + " " + material.Course.Name);
}
break;
case "4":
var homeworks = data.Homeworks.All();
foreach (var homework in homeworks)
{
Console.WriteLine(homework.Content + " " + homework.TimeSent);
}
break;
case "exit":
Console.WriteLine("Goodbye");
return;
default:
Console.WriteLine("Unknown comand");
break;
}
}
}
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());
}
static void Main(string[] args)
{
// this can be set in StudentSystemDbContext.cs
//Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentSystemDbContext, Configuration>());
// OR
//Database.SetInitializer(new DropCreateDatabaseAlways<StudentSystemDbContext>());
//var db = new StudentSystemDbContext();
//var studentsDB = new GenericRepository<Student>(db);
var data = new StudentSystemData();
foreach (var student in data.Students.All())
{
Console.WriteLine(student.FirstName);
}
data.Students.Add(new Student
{
FirstName = "Goshko",
LastName = "Peshkov"
});
data.Students.SaveChanges();
//db.Database.Initialize(true);
//var student = new Student
//{
// FirstName = "Boyan",
// LastName = "Ivanov",
// Age = 32,
// ContactInfo = new StudentContactInfo
// {
// Email = "*****@*****.**"
// },
// StudentStatus = StudentStatus.Online
//};
//student.Courses.Add(new Course
//{
// Name = "Entity Framework",
// Description = "Entity Framework for Dumies"
//});
//db.Students.Add(student);
//db.SaveChanges();
//var savedStudent = db.Students.First();
//Console.WriteLine(savedStudent.FirstName + " " + savedStudent.LastName + " Age: " + savedStudent.Age + " Status: " + savedStudent.StudentStatus);
}
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());
}
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");
}
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 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 List <IGrouping <int, PdfRow> > GetSalesByDate()
{
StudentSystemData db = new StudentSystemData();
List <IGrouping <int, PdfRow> > collection;
collection = db.Students.All().Select(x => new PdfRow
{
FirstName = x.FirstName,
LastName = x.LastName,
Age = x.Age,
Number = x.Number
})
.GroupBy(x => x.Age)
.ToList();
return(collection);
}
public static void Main()
{
var data = new StudentSystemData();
IQueryable<Course> courses = data.Courses.All();
foreach (var course in courses)
{
Console.WriteLine(course.Name);
}
data.Courses.Add(new Course
{
Name = "Repo Pattern",
Description = "Cool"
});
data.SaveChanges();
}
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 void Main()
{
var data = new StudentSystemData();
var hw = new Homework
{
FileName = "Domestic rakia",
Deadline = new DateTime(2014, 08, 31),
TimeSent = new DateTime(2014, 08, 29)
};
var student = new Student
{
FirstName = "Pesho",
LastName = "Piandeto",
PhoneNumber = "082569875",
Homeworks = new List <Homework> {
hw
}
};
data.Homeworks.Add(hw);
data.Students.Add(student);
data.Courses.Add(new Course
{
Name = "Kukuruz seller",
Description = "Corn, corn, corn",
Students = new List <Student> {
student
}
});
data.SaveChanges();
}
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());
}
public HomeController()
{
this.data = new StudentSystemData();
}
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 students = data.Students.All();
var count = 1;
foreach (var student in students)
{
student.FirstName += count.ToString();
count++;
}
data.SaveChanges();
var updatedStudents = data.Students.All();
foreach (var student in updatedStudents)
{
data.Students.Delete(student);
}
var selectedStudents =
data.Students
.All()
.Where(st => st.FirstName.Contains("Ivaylo"))
.Select(st => new
{
FirstName = st.FirstName,
LastName = st.LastName
})
.ToList();
Console.WriteLine(selectedStudents.Count());
data.SaveChanges();
Console.WriteLine(data.Students.All().Count());
var course = new Course
{
Name = "Pesho's course",
Description = "The best course in the world"
};
data.Courses.Add(course);
data.SaveChanges();
var someStudent = new Student
{
FirstName = "Peshlqka",
LastName = "Goshlqka",
Information = new StudentInfo
{
Email = "*****@*****.**"
},
StudentNumber = 12345
};
data.Students.Add(someStudent);
data.SaveChanges();
someStudent.Courses.Add(course);
var homework = new Homework
{
FileUrl = "pesho.com/pesho.zip",
Course = course,
TimeSent = DateTime.Now
};
someStudent.Homeworks.Add(homework);
data.SaveChanges();
var studentFromDB = data.Students.All().FirstOrDefault();
Console.WriteLine(studentFromDB.Homeworks.FirstOrDefault().FileUrl);
}
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);
}
}
