//=====================================================================
/*
*
*
*
*/
// Methods to combine data from database ==============================
/// <summary>
/// Inserts students in a Course
/// </summary>
public static void StudentsPerCourse()
{
// Course selection
ReadDB.Courses();
Console.Write("Choose the id of the course: ");
int courseSelection = IntInput();
// Student selection
ReadDB.Students();
Console.Write("Choose the id of the student: ");
int studentSelection = IntInput();
string insertqr = "Insert into Courses_Students (CourseID, StudentID ) " +
"values (@CourseID, @StudentID)";
try
{
using (SqlConnection dbcon = new SqlConnection(connectionString))
{
dbcon.Open();
var command = new SqlCommand(insertqr, dbcon);
command.Parameters.AddWithValue("@CourseID", courseSelection);
command.Parameters.AddWithValue("@StudentID", studentSelection);
command.ExecuteNonQuery();
}
Console.WriteLine("Student related successfully to the course!");
}
catch (SqlException e)
{
Console.WriteLine("Error Type: " + e.Message);
}
finally { }
}
/// <summary>
/// Inserts assignments in a Course per Student
/// </summary>
public static void AssignmentsPerCoursePerStudent()
{
// Course selection
ReadDB.Courses();
Console.Write("Choose the id of the course: ");
int courseSelection = IntInput();
// Student selection
ReadDB.Students();
Console.Write("Choose the id of the student: ");
int studentSelection = IntInput();
// Assignment selection
ReadDB.Assignments();
Console.Write("Choose the id of the assignment: ");
int assignmentSelection = IntInput();
Console.WriteLine("Is the assignment submitted?");
if (BoolInput())
{
// Assignment selection
Console.Write("Insert the oral mark (if exists): ");
int?OralMark = MarkInput();
// Assignment selection
Console.Write("Insert the total mark (if exists): ");
int?TotalMark = MarkInput();
string insertqr = "Insert into AssignmentPerCoursePerStudent (StudentID, CourseID, AssignmentID, Submited, OralMark, TotalMark) " +
"values (@StudentID, @CourseID, @AssignmentID, @Submited, @OralMark, @TotalMark)";
try
{
using (SqlConnection dbcon = new SqlConnection(connectionString))
{
dbcon.Open();
var command = new SqlCommand(insertqr, dbcon);
command.Parameters.AddWithValue("@CourseID", courseSelection);
command.Parameters.AddWithValue("@StudentID", studentSelection);
command.Parameters.AddWithValue("@AssignmentID", assignmentSelection);
command.Parameters.AddWithValue("@Submited", true);
command.Parameters.AddWithValue("@OralMark", OralMark);
command.Parameters.AddWithValue("@TotalMark", TotalMark);
command.ExecuteNonQuery();
}
Console.WriteLine("Assignment related successfully to the course and to the student!");
}
catch (SqlException e)
{
Console.WriteLine("Error Type: " + e.Message);
}
finally { }
}
else
{
string insertqr = "Insert into AssignmentPerCoursePerStudent (StudentID, CourseID, AssignmentID, Submited) " +
"values (@StudentID, @CourseID, @AssignmentID, @Submited)";
try
{
using (SqlConnection dbcon = new SqlConnection(connectionString))
{
dbcon.Open();
var command = new SqlCommand(insertqr, dbcon);
command.Parameters.AddWithValue("@CourseID", courseSelection);
command.Parameters.AddWithValue("@StudentID", studentSelection);
command.Parameters.AddWithValue("@AssignmentID", assignmentSelection);
command.Parameters.AddWithValue("@Submited", false);
command.ExecuteNonQuery();
}
Console.WriteLine("Assignment related successfully to the course and to the student!");
}
catch (SqlException e)
{
Console.WriteLine("Error Type: " + e.Message);
}
finally { }
}
}
/// <summary>
/// Enters the choice from "ViewMenu()" method and enters to the selected choice
/// </summary>
/// <param name="input"></param>
static void ViewChoiceSwitch(string input)
{
switch (input)
{
case "1":
{
ReadDB.Courses();
break;
}
case "2":
{
ReadDB.Trainers();
break;
}
case "3":
{
ReadDB.Students();
break;
}
case "4":
{
ReadDB.Assignments();
break;
}
case "5":
{
ReadDB.StudentsPerCourse();
break;
}
case "6":
{
ReadDB.TrainersPerCourse();
break;
}
case "7":
{
ReadDB.AssignmentsPerCourse();
break;
}
case "8":
{
ReadDB.AssignmentsPerCoursePerStudent();
break;
}
case "9":
{
ReadDB.StudentsOver1Course();
break;
}
default:
{
Console.WriteLine("Invalid selection! Please try again");
break;
}
}
}