public static void InsertCourse()
{
using (var db = new PrivateSchoolContext())
{
Console.WriteLine("Enter course details");
Console.Write("Title: ");
string Title = Console.ReadLine();
Console.Write("Stream: ");
string Stream = Console.ReadLine();
Console.Write("Type: ");
string Type = Console.ReadLine();
Console.Write("Start date in format yyyy-MM-dd : ");
DateTime Start_Date = Convert.ToDateTime(Console.ReadLine());
Console.Write("End date in format yyyy-MM-dd : ");
DateTime End_Date = Convert.ToDateTime(Console.ReadLine());
var course = new Course
{
title = Title,
stream = Stream,
type = Type,
start_date = Start_Date,
end_date = End_Date
};
db.Courses1.Add(course);
db.SaveChanges();
Console.WriteLine("");
Console.WriteLine("LOADING...");
Console.WriteLine("");
Console.WriteLine("...DATA SUCCESSFULLY SAVED");
}
}
public static void InsertTrainer()
{
using (var db = new PrivateSchoolContext())
{
Console.WriteLine("Enter trainer details");
Console.Write("First name: ");
string tFirstName = Console.ReadLine();
Console.Write("Last name: ");
string tLastName = Console.ReadLine();
Console.Write("Subject (Python, Java, Csharp): ");
string Subject = Console.ReadLine();
Console.Write("Course Id: ");
int CourseId = Convert.ToInt32(Console.ReadLine());
var trainer = new Trainer
{
firstName = tFirstName,
lastName = tLastName,
subject = Subject,
courseid = CourseId
};
db.Trainers.Add(trainer);
db.SaveChanges();
Console.WriteLine("");
Console.WriteLine("LOADING...");
Console.WriteLine("");
Console.WriteLine("...DATA SUCCESSFULLY SAVED");
}
}
public static void InsertAssignment()
{
using (var db = new PrivateSchoolContext())
{
Console.WriteLine("Enter assignment details");
Console.Write("Title: ");
string aTitle = Console.ReadLine();
Console.Write("Description: ");
string Description = Console.ReadLine();
Console.Write("Submission date in format yyyy-MM-dd : ");
DateTime Sub_Date = Convert.ToDateTime(Console.ReadLine());
Console.Write("Oral Mark: ");
int OralMark = Convert.ToInt32(Console.ReadLine());
Console.Write("Total Mark: ");
int TotalMark = Convert.ToInt32(Console.ReadLine());
Console.Write("Course Id: ");
int CourseId = Convert.ToInt32(Console.ReadLine());
var assignment = new Assignment
{
title = aTitle,
description = Description,
sub_date = Sub_Date,
oralMark = OralMark,
totalMark = TotalMark,
courseid = CourseId
};
db.Assignments.Add(assignment);
db.SaveChanges();
Console.WriteLine("");
Console.WriteLine("LOADING...");
Console.WriteLine("");
Console.WriteLine("...DATA SUCCESSFULLY SAVED");
}
}
public static void InsertStudentsPerCourse()
{
using (var db = new PrivateSchoolContext())
{
try
{
Console.WriteLine("Enter student id");
Console.Write("ID: ");
int sId = Convert.ToInt32(Console.ReadLine());
var student1 = db.Students.Where(s => s.id == sId).FirstOrDefault();
Console.WriteLine("Enter first course id");
Console.Write("ID: ");
int c1id = Convert.ToInt32(Console.ReadLine());
var course1 = db.Courses1.Where(c => c.id == c1id).FirstOrDefault();
student1.Courses.Add(course1);
db.SaveChanges();
Console.WriteLine("");
Console.WriteLine("LOADING...");
Console.WriteLine("");
Console.WriteLine("...DATA SUCCESSFULLY SAVED");
Console.WriteLine("Type 1 to insert second course for this student or 2 go back");
Console.Write("Please type number: ");
int decision;
decision = Convert.ToInt32(Console.ReadLine());
if (decision == 1)
{
Console.WriteLine("Enter second course id");
Console.Write("ID: ");
int c2id = Convert.ToInt32(Console.ReadLine());
var course2 = db.Courses1.Where(c => c.id == c2id).FirstOrDefault();
student1.Courses.Add(course2);
db.SaveChanges();
Console.WriteLine("");
Console.WriteLine("LOADING...");
Console.WriteLine("");
Console.WriteLine("");
Console.WriteLine("LOADING...");
Console.WriteLine("");
Console.WriteLine("...DATA SUCCESSFULLY SAVED");
}
else if (decision == 2)
{
return;
}
else
{
Console.WriteLine("Wrong input! Please try again..\n");
}
db.SaveChanges();
}
catch (FormatException ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine("Please try again..\n");
}
}
}
public static void InsertTrainersPerCourse()
{
using (var db = new PrivateSchoolContext())
{
try
{
Console.WriteLine("Enter course id");
Console.Write("ID: ");
int c1id = Convert.ToInt32(Console.ReadLine());
var course1 = db.Courses1.Where(c => c.id == c1id).FirstOrDefault();
Console.WriteLine("Enter trainer id");
Console.Write("ID: ");
int tId = Convert.ToInt32(Console.ReadLine());
var trainer1 = db.Trainers.Where(t => t.id == tId).FirstOrDefault();
course1.Trainers.Add(trainer1);
db.SaveChanges();
Console.WriteLine("");
Console.WriteLine("LOADING...");
Console.WriteLine("");
Console.WriteLine("...DATA SUCCESSFULLY SAVED");
Console.WriteLine("Type 1 to insert another trainer for this course or 2 go back");
Console.Write("Please type number: ");
int decision;
decision = Convert.ToInt32(Console.ReadLine());
if (decision == 1)
{
Console.WriteLine("Enter trainer id");
Console.Write("ID: ");
int t2Id = Convert.ToInt32(Console.ReadLine());
var trainer2 = db.Trainers.Where(t => t.id == t2Id).FirstOrDefault();
course1.Trainers.Add(trainer2);
db.SaveChanges();
Console.WriteLine("");
Console.WriteLine("LOADING...");
Console.WriteLine("");
Console.WriteLine("...DATA SUCCESSFULLY SAVED");
}
else if (decision == 2)
{
return;
}
else
{
Console.WriteLine("Wrong input! Please try again..\n");
}
db.SaveChanges();
}
catch (FormatException ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine("Please try again..\n");
}
}
}
public static void InsertStudent()
{
using (var db = new PrivateSchoolContext())
{
while (true)
{
try
{
Console.WriteLine("Enter student details");
Console.Write("First name: ");
string FirstName = Console.ReadLine();
Console.Write("Last name: ");
string LastName = Console.ReadLine();
Console.Write("Date of birth in format yyyy-MM-dd : ");
DateTime DateOfBirth = Convert.ToDateTime(Console.ReadLine());
Console.Write("Tuition fees: ");
double TuitionFees = Convert.ToDouble(Console.ReadLine());
var student = new Student
{
firstName = FirstName,
lastName = LastName,
dateOfBirth = DateOfBirth,
tuitionFees = TuitionFees
};
db.Students.Add(student);
db.SaveChanges();
Console.WriteLine("");
Console.WriteLine("LOADING...");
Console.WriteLine("");
Console.WriteLine("...DATA SUCCESSFULLY SAVED");
}
catch (FormatException ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine("Please try again..\n");
}
}
}
}
public static void Output()
{
using (var db = new PrivateSchoolContext())
{
var query1 = from s in db.Students
select s;
Console.WriteLine("\nLIST OF ALL THE STUDENTS");
Console.WriteLine("---+-------------------------------+-------------------------------+-------------------+---------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29} | {"Last Name",-29} | {"Birth Date",-17} | {"Tuituin Fees"}");
Console.WriteLine("---+-------------------------------+-------------------------------+-------------------+---------------");
foreach (var item in query1)
{
Console.WriteLine($"{item.id,-3}| {item.firstName}| {item.lastName}| {item.dateOfBirth.ToString("dd/MM/yyyy"),-18}| {item.tuitionFees}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+-------------------+---------------");
var query2 = from t in db.Trainers
select t;
Console.WriteLine("\nLIST OF ALL THE TRAINERS");
Console.WriteLine("---+-------------------------------+-------------------------------+------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29} | {"Last Name",-29} | {"Subject"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------");
foreach (var item in query2)
{
Console.WriteLine($"{item.id,-3}| {item.firstName,13}| {item.lastName,-16}| {item.subject}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------");
var query3 = from a in db.Assignments
select a;
Console.WriteLine("\nLIST OF ALL THE ASSIGNMENTS");
Console.WriteLine("---+--------------------------------+-------------------------------+-------------------+----------+----------");
Console.WriteLine($"{"ID",-2} | {"Title",-30} | {"Description",-29} |{"Submission Date",-18} |{"Oral Mark",-7} |{"Total Mark"} ");
Console.WriteLine("---+--------------------------------+-------------------------------+-------------------+----------+----------");
foreach (var item in query3)
{
Console.WriteLine($"{item.id,-3}| {item.title} | {item.description}| {item.sub_date.ToString("dd/MM/yyyy"),-18}| {item.oralMark,-9}| {item.totalMark}");
}
Console.WriteLine("---+--------------------------------+-------------------------------+-------------------+----------+----------");
var query4 = from c in db.Courses1
select c;
Console.WriteLine("\nLIST OF ALL THE COURSES");
Console.WriteLine("---+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------");
Console.WriteLine($"{"ID",-2} | {"Title",-29} | {"Stream",-29} |{"Type",-30} |{"Start Date",-16} |{"End Date"}");
Console.WriteLine("---+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------");
foreach (var item in query4)
{
Console.WriteLine($"{item.id,-3}| {item.title}| {item.stream}| {item.type}| {item.start_date.ToString("dd/MM/yyyy"),-16}| {item.end_date.ToString("dd/MM/yyyy")}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------");
var query5 = from s in db.Students
from c in s.Courses
where c.id == 1
select new
{
sId = s.id,
sFirstName = s.firstName,
sLastName = s.lastName,
cTitle = c.title
};
Console.WriteLine("\nLIST OF ALL THE STUDENTS PER COURSE");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29} | {"Last Name",-29} | {"Course Title"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
foreach (var item in query5)
{
Console.WriteLine($"{item.sId,-3}| {item.sFirstName}| {item.sLastName}| {item.cTitle}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
var query6 = from s in db.Students
from c in s.Courses
where c.id == 2
select new
{
sId = s.id,
sFirstName = s.firstName,
sLastName = s.lastName,
cTitle = c.title
};
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29} | {"Last Name",-29} | {"Course Title"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
foreach (var item in query6)
{
Console.WriteLine($"{item.sId,-3}| {item.sFirstName}| {item.sLastName}| {item.cTitle}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
var query7 = from s in db.Students
from c in s.Courses
where c.id == 3
select new
{
sId = s.id,
sFirstName = s.firstName,
sLastName = s.lastName,
cTitle = c.title
};
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29} | {"Last Name",-29} | {"Course Title"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
foreach (var item in query7)
{
Console.WriteLine($"{item.sId,-3}| {item.sFirstName}| {item.sLastName}| {item.cTitle}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
var query8 = from s in db.Students
from c in s.Courses
where c.id == 4
select new
{
sId = s.id,
sFirstName = s.firstName,
sLastName = s.lastName,
cTitle = c.title
};
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29} | {"Last Name",-29} | {"Course Title"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
foreach (var item in query8)
{
Console.WriteLine($"{item.sId,-3}| {item.sFirstName}| {item.sLastName}| {item.cTitle}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
var query9 = from t in db.Trainers
from c in db.Courses1
where c.id == 1
select new
{
tId = t.id,
tFirstName = t.firstName,
tLastName = t.lastName,
cTitle = c.title
};
Console.WriteLine("\nLIST OF ALL THE TRAINERS PER COURSE");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29} | {"Last Name",-29} | {"Course Title"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
foreach (var item in query9)
{
Console.WriteLine($"{item.tId,-3}| {item.tFirstName}| {item.tLastName}| {item.cTitle}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
var query10 = from t in db.Trainers
from c in db.Courses1
where c.id == 2
select new
{
tId = t.id,
tFirstName = t.firstName,
tLastName = t.lastName,
cTitle = c.title
};
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29} | {"Last Name",-29} | {"Course Title"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
foreach (var item in query10)
{
Console.WriteLine($"{item.tId,-3}| {item.tFirstName}| {item.tLastName}| {item.cTitle}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
var query11 = from t in db.Trainers
from c in db.Courses1
where c.id == 3
select new
{
tId = t.id,
tFirstName = t.firstName,
tLastName = t.lastName,
cTitle = c.title
};
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29} | {"Last Name",-29} | {"Course Title"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
foreach (var item in query11)
{
Console.WriteLine($"{item.tId,-3}| {item.tFirstName}| {item.tLastName}| {item.cTitle}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
var query12 = from t in db.Trainers
from c in db.Courses1
where c.id == 4
select new
{
tId = t.id,
tFirstName = t.firstName,
tLastName = t.lastName,
cTitle = c.title
};
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29} | {"Last Name",-29} | {"Course Title"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
foreach (var item in query12)
{
Console.WriteLine($"{item.tId,-3}| {item.tFirstName}| {item.tLastName}| {item.cTitle}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
var query13 = from a in db.Assignments
from c in db.Courses1
where c.id == 1
select new
{
aId = a.id,
aTitle = a.title,
aDescription = a.description,
cTitle = c.title
};
Console.WriteLine("\nLIST OF ALL THE ASSIGNMENTS PER COURSE");
Console.WriteLine("-----------------------------------CB8 CSHARP FULL TIME-------------------------------------");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
Console.WriteLine($"{"ID",-2} | {"Title",-29} | {"Description",-29} | {"Course Title"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
foreach (var item in query13)
{
Console.WriteLine($"{item.aId,-3}| {item.aTitle}| {item.aDescription}| {item.cTitle}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
var query14 = from a in db.Assignments
from c in db.Courses1
where c.id == 2
select new
{
aId = a.id,
aTitle = a.title,
aDescription = a.description,
cTitle = c.title
};
Console.WriteLine("\n-----------------------------------CB8 CSHARP PART TIME-------------------------------------");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
Console.WriteLine($"{"ID",-2} | {"Title",-29} | {"Description",-29} | {"Course Title"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
foreach (var item in query14)
{
Console.WriteLine($"{item.aId,-3}| {item.aTitle}| {item.aDescription}| {item.cTitle}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
var query15 = from a in db.Assignments
from c in db.Courses1
where c.id == 3
select new
{
aId = a.id,
aTitle = a.title,
aDescription = a.description,
cTitle = c.title
};
Console.WriteLine("\n-----------------------------------CB8 JAVA FULL TIME---------------------------------------");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
Console.WriteLine($"{"ID",-2} | {"Title",-29} | {"Description",-29} | {"Course Title"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
foreach (var item in query15)
{
Console.WriteLine($"{item.aId,-3}| {item.aTitle}| {item.aDescription}| {item.cTitle}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
var query16 = from a in db.Assignments
from c in db.Courses1
where c.id == 4
select new
{
aId = a.id,
aTitle = a.title,
aDescription = a.description,
cTitle = c.title
};
Console.WriteLine("\n-----------------------------------CB8 JAVA PART TIME---------------------------------------");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
Console.WriteLine($"{"ID",-2} | {"Title",-29} | {"Description",-29} | {"Course Title"}");
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
foreach (var item in query16)
{
Console.WriteLine($"{item.aId,-3}| {item.aTitle}| {item.aDescription}| {item.cTitle}");
}
Console.WriteLine("---+-------------------------------+-------------------------------+------------------------");
var query17 = from s in db.Students
from a in s.Assignments
where a.Courses.id == 1
select new
{
sId = s.id,
sFirstName = s.firstName,
sLastName = s.lastName,
aTitle = a.title,
aDescription = a.description,
Ctitle = a.Courses.title
};
Console.WriteLine("\nLIST OF ALL THE ASSIGNMENTS PER STUDENT PER COURSE");
Console.WriteLine("------------------------------------------------------------------------CB8 CSHARP FULL TIME-----------------------------------------------------------------");
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29}| {"Last Name",-29} | {"Title",-29} | {"Description",-29} | {"Course Title"}");
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
foreach (var item in query17)
{
Console.WriteLine($"{item.sId,-3}|{item.sFirstName}|{item.sLastName} | {item.aTitle}| {item.aDescription}| {item.Ctitle}");
}
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
var query18 = from s in db.Students
from a in s.Assignments
where a.Courses.id == 2
select new
{
sId = s.id,
sFirstName = s.firstName,
sLastName = s.lastName,
aTitle = a.title,
aDescription = a.description,
Ctitle = a.Courses.title
};
Console.WriteLine("\n------------------------------------------------------------------------CB8 CSHARP PART TIME-----------------------------------------------------------------");
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29}| {"Last Name",-29} | {"Title",-29} | {"Description",-29} | {"Course Title"}");
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
foreach (var item in query18)
{
Console.WriteLine($"{item.sId,-3}|{item.sFirstName}| {item.sLastName}| {item.aTitle}| {item.aDescription}| {item.Ctitle}");
}
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
var query19 = from s in db.Students
from a in s.Assignments
where a.Courses.id == 3
select new
{
sId = s.id,
sFirstName = s.firstName,
sLastName = s.lastName,
aTitle = a.title,
aDescription = a.description,
Ctitle = a.Courses.title
};
Console.WriteLine("\n--------------------------------------------------------------------------CB8 JAVA FULL TIME-----------------------------------------------------------------");
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29}| {"Last Name",-29} | {"Title",-29} | {"Description",-29} | {"Course Title"}");
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
foreach (var item in query19)
{
Console.WriteLine($"{item.sId,-3}|{item.sFirstName}| {item.sLastName}| {item.aTitle}| {item.aDescription}| {item.Ctitle}");
}
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
var query20 = from s in db.Students
from a in s.Assignments
where a.Courses.id == 4
select new
{
sId = s.id,
sFirstName = s.firstName,
sLastName = s.lastName,
aTitle = a.title,
aDescription = a.description,
Ctitle = a.Courses.title
};
Console.WriteLine("\n--------------------------------------------------------------------------CB8 JAVA PART TIME-----------------------------------------------------------------");
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
Console.WriteLine($"{"ID",-2} | {"First Name",-29}| {"Last Name",-29} | {"Title",-29} | {"Description",-29} | {"Course Title"}");
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
foreach (var item in query20)
{
Console.WriteLine($"{item.sId,-3}|{item.sFirstName}| {item.sLastName}| {item.aTitle}| {item.aDescription}| {item.Ctitle}");
}
Console.WriteLine("---+------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------------------");
}
}
