public void Navigate()
{
while (userInput != e)
{
// NAVIGATION PANEL
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine("____________________________TYPE TO NAVIGATE________________________________");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("============================================================================");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| {"(1) STUDENTS",-12} | {"(2) TRAINERS",-12} | {"(3) ASSIGNMENTS",-12} | {"(4) COURSES",-11} | {"(E) RETURN",-9} |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("============================================================================");
Console.ForegroundColor = ConsoleColor.White;
userInput = Console.ReadLine();
// Simple SELECT QUERYS
if (userInput == one)
{
sqlStudent MyS1 = new sqlStudent();
MyS1.StudentSelectOutput();
}
else if (userInput == two)
{
sqlTrainer MyT1 = new sqlTrainer();
MyT1.TrainerSelectOutput();
}
else if (userInput == three)
{
sqlAssignment MyA1 = new sqlAssignment();
MyA1.AssignmentSelectOutput();
}
else if (userInput == four)
{
sqlCourse MyC1 = new sqlCourse();
MyC1.CourseSelectOutput();
}
// Exit and Wrong Input Cases
else if (userInput == e)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("EXIT");
Console.ForegroundColor = ConsoleColor.White;
}
else
{
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("Unindentified Input, Please Choose Again");
Console.ForegroundColor = ConsoleColor.White;
}
}
}
public void InsertIntoTrainer()
{
// Display TRAINERS
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| EXISTING TRAINERS |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
sqlTrainer MyT2 = new sqlTrainer();
MyT2.TrainerSelectOutput();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Insert a 5 Character KEY (example: TR099) >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Trainer ID: ");
Trainer_ID = Console.ReadLine();
Console.Write("Input First name: ");
FirstName = Console.ReadLine();
Console.Write("Input Last Name: ");
LastName = Console.ReadLine();
Console.Write("Input Subject of Teaching: ");
Subject = Console.ReadLine();
// Display COURSES
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| EXISTING COURSES |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
sqlCourse MyC2 = new sqlCourse();
MyC2.CourseSelectOutput();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Choose from the existing Courses Table Above >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Course Title: ");
CourseTitle = Console.ReadLine();
string sqlInsertTrainer =
"INSERT INTO Trainer(Trainer_ID, FirstName, LastName, Subject, CourseTitle) " +
"VALUES (@trainerid, @firstname, @lastname, @sub, @coursetitle)";
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString.connection))
{
conn.Open();
using (SqlCommand cmInsert = new SqlCommand(sqlInsertTrainer, conn))
{
cmInsert.Parameters.Add(new SqlParameter("trainerid", Trainer_ID));
cmInsert.Parameters.Add(new SqlParameter("firstname", FirstName));
cmInsert.Parameters.Add(new SqlParameter("lastname", LastName));
cmInsert.Parameters.Add(new SqlParameter("sub", Subject));
cmInsert.Parameters.Add(new SqlParameter("coursetitle", CourseTitle));
int rowsAffected = cmInsert.ExecuteNonQuery();
// Display A message for the Inserted TRAINER
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| Trainers Inserted Succesfully: {rowsAffected,-26} |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
// Bring the Table TRAINER to see our newly Input TRAINER
sqlTrainer MyIT1 = new sqlTrainer();
MyIT1.TrainerSelectOutput();
// Again, Show that the Trainer was Inserted at the end of the Table TRAINER
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| Trainers Inserted Succesfully: {rowsAffected,-26} |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void InsertIntoStudentPerCourse()
{
// Bring the Table STUDENT to see/choose a specific STUDENT KEY
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| EXISTING STUDENTS |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
sqlStudent MyS2 = new sqlStudent();
MyS2.StudentSelectOutput();
// Input Data
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Insert KEY of choosen STUDENT from the Table above >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Student ID: ");
Student_ID = Console.ReadLine();
// Bring the Table COURSES to see/choose a specific COURSE KEY
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| EXISTING COURSES |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
sqlCourse MyC2 = new sqlCourse();
MyC2.CourseSelectOutput();
// Input Data
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Insert KEY of choosen COURSE from the Table above >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Course Title: ");
CourseTitle = Console.ReadLine();
string splInsertStudentCourse = "INSERT INTO CourseStudent(CourseTitle, Student_ID ) " +
"VALUES (@coursetitle, @studentid)";
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString.connection))
{
conn.Open();
using (SqlCommand cmInsert = new SqlCommand(splInsertStudentCourse, conn))
{
cmInsert.Parameters.Add(new SqlParameter("CourseTitle", CourseTitle));
cmInsert.Parameters.Add(new SqlParameter("studentid", Student_ID));
int rowsAffected = cmInsert.ExecuteNonQuery();
// Display A message for the Inserted STUDENT
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| Successful Insertion: {rowsAffected,-30} |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
// Bring the Table STUDENT/COURSE
sqlStudentsPerCourse MySperC2 = new sqlStudentsPerCourse();
MySperC2.StudentCoursetOutput();
// Display A message for the Inserted STUDENT again
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| Successful Insertion: {rowsAffected,-30} |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void SelectSpecificAssPerStuPerCourse()
{
// Bring the Table COURSES to see/choose a specific COURSE KEY
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| EXISTING COURSES |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
sqlCourse MyC2 = new sqlCourse();
MyC2.CourseSelectOutput();
// Input Data
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Insert KEY of choosen COURSE from the Table above >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Course Title: ");
CourseTitle = Console.ReadLine();
// Bring the STUDENTS in this COURSE
StudentPerSpecificCourse();
// Bring the ASSIGNMENTS in this COURSE
AssesPerSpecificCourse();
// NAVIGATION PANEL
while (userInput != three)
{
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine("____________________________TYPE TO CONTINUE________________________________");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("============================================================================");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| {"(1) INSERT STUDENT",-22} | {"(2) INSERT ASSIGNMENT",-22} | {"(3) CONTINUE",-22} |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("============================================================================");
Console.ForegroundColor = ConsoleColor.White;
userInput = Console.ReadLine();
if (userInput == one)
{
sqlInsertToStudents IS1 = new sqlInsertToStudents();
IS1.InsertIntoStudent();
}
else if (userInput == two)
{
sqlInsertAsses IA1 = new sqlInsertAsses();
IA1.InsertIntoAss();
}
// Exit and Wrong Input Cases
else if (userInput == three)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("EXIT");
Console.ForegroundColor = ConsoleColor.White;
}
else
{
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("Unindentified Input, Please Choose Again");
Console.ForegroundColor = ConsoleColor.White;
}
}
// Input Data
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Insert KEY of choosen STUDENT from the Table above >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Student ID: ");
Student_ID = Console.ReadLine();
// Display Title after the Table STUDENT/COURSE
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| ASSIGNMENTS FOR THE CHOOSEN STUDENT |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
AssOfChoosenStudent();
}
public void InsertIntoTrainersPerCourse()
{
// Bring the Table COURSES to see/choose a specific COURSE KEY
sqlCourse MyIC1 = new sqlCourse();
MyIC1.CourseSelectOutput();
// Input Data
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Insert KEY of choosen COURSE from the Table above >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Course Title: ");
CourseTitle = Console.ReadLine();
// Bring the Table TRAINER as Existing TRAINERS
// And ask Input of a new TRAINER
// (That is because a TRAINER can teach ONLY ONE COURSE)
// Display Title for the Table TRAINERS
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| EXISTING TRAINERS |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
sqlTrainer MyIT1 = new sqlTrainer();
MyIT1.TrainerSelectOutput();
// Display Title for the Table TRAINERS
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| INPUT NEW TRAINER FOR THE CHOOSEN COURSE |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
// Input Data
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Insert a 5 Character KEY (As seen in the above Table) >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Trainer ID: ");
Trainer_ID = Console.ReadLine();
Console.Write("Input First name: ");
FirstName = Console.ReadLine();
Console.Write("Input Last Name: ");
LastName = Console.ReadLine();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: The subject description is suggested to match the COURSE previously choosen >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Subject of Teaching: ");
Subject = Console.ReadLine();
string sqlInsertTrainer =
"INSERT INTO Trainer(Trainer_ID, FirstName, LastName, Subject, CourseTitle) " +
"VALUES (@trainerid, @firstname, @lastname, @sub, @coursetitle)";
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString.connection))
{
conn.Open();
using (SqlCommand cmInsert = new SqlCommand(sqlInsertTrainer, conn))
{
cmInsert.Parameters.Add(new SqlParameter("trainerid", Trainer_ID));
cmInsert.Parameters.Add(new SqlParameter("firstname", FirstName));
cmInsert.Parameters.Add(new SqlParameter("lastname", LastName));
cmInsert.Parameters.Add(new SqlParameter("sub", Subject));
cmInsert.Parameters.Add(new SqlParameter("coursetitle", CourseTitle));
int rowsAffected = cmInsert.ExecuteNonQuery();
// Display A message for the Inserted TRAINER
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| Trainers Inserted Succesfully: {rowsAffected,-26} |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
// Bring the Table TRAINER to see our newly Input TRAINER
sqlTrainer MyNEWIT1 = new sqlTrainer();
MyNEWIT1.TrainerSelectOutput();
// Again, Show that the Trainer was Inserted at the end of the Table TRAINER
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| Trainers Inserted Succesfully: {rowsAffected,-26} |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
// Bring the Table TRAINER/COURSE to see our newly Input TRAINER
sqlTrainersPerCourse MyTperC1NT = new sqlTrainersPerCourse();
MyTperC1NT.TrainerCoursetOutput();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void InsertNewCourse()
{
// Display COURSES
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| EXISTING COURSES |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
sqlCourse MyC2 = new sqlCourse();
MyC2.CourseSelectOutput();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Insert a 5 Character KEY (example: BCZ00) >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Course Title: ");
CourseTitle = Console.ReadLine();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Full-Time or Part-Time >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Course Stream: ");
Stream = Console.ReadLine();
Console.Write("Input Course Type: ");
CourseType = Console.ReadLine();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Insert Format YYYY/MM/DD (example: 2012/02/22) >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Starting Date: ");
StartDate = Console.ReadLine();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Insert Format YYYY/MM/DD (example: 2019/04/15) >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input End Date: ");
EndDate = Console.ReadLine();
string sqlInsertCourse =
"INSERT INTO Course(CourseTitle, Stream, CourseType, StartDate, EndDate) " +
"VALUES (@coursetitle, @stream, @coursetype, @start, @end)";
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString.connection))
{
conn.Open();
using (SqlCommand cmInsert = new SqlCommand(sqlInsertCourse, conn))
{
cmInsert.Parameters.Add(new SqlParameter("coursetitle", CourseTitle));
cmInsert.Parameters.Add(new SqlParameter("stream", Stream));
cmInsert.Parameters.Add(new SqlParameter("coursetype", CourseType));
cmInsert.Parameters.Add(new SqlParameter("start", StartDate));
cmInsert.Parameters.Add(new SqlParameter("end", EndDate));
int rowsAffected = cmInsert.ExecuteNonQuery();
// Display A message for the Inserted COURSE
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| Courses Inserted Succesfully: {rowsAffected,-26} |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
// Bring the Table COURSES to see our newly Input COURSE
sqlCourse MyIC1 = new sqlCourse();
MyIC1.CourseSelectOutput();
// Again, Show the Inserted COURSE
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| Courses Inserted Succesfully: {rowsAffected,-26} |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void InsertIntoAss()
{
// Display ASSIGNMENTS
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| EXISTING ASSIGNMENTS |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
sqlAssignment MyA2 = new sqlAssignment();
MyA2.AssignmentSelectOutput();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Insert a 5 Character KEY (example: ASA19) >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Assignment Title: ");
AssTitle = Console.ReadLine();
// Display COURSES
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| EXISTING COURSES |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
sqlCourse MyC2 = new sqlCourse();
MyC2.CourseSelectOutput();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Choose from the existing Courses Table Above >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Course Title: ");
CourseTitleA = Console.ReadLine();
Console.Write("Input Assignment Description: ");
Description = Console.ReadLine();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"< TIP: Insert Format YYYY/MM/DD (example: 2010/01/25) >");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
Console.Write("Input Subscription Date: ");
Subscription = Console.ReadLine();
Console.Write("Input Oral Mark: ");
OralMark = Console.ReadLine();
Console.Write("Input Total Mark: ");
TotalMark = Console.ReadLine();
string sqlInsertAss =
"INSERT INTO Assignment(AssTitle, CourseTitleA, Description, Subscription, OralMark, TotalMark) " +
"VALUES (@asstitle, @coursetitle, @description, @sub, @oralmark, @totalmark)";
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString.connection))
{
conn.Open();
using (SqlCommand cmInsert = new SqlCommand(sqlInsertAss, conn))
{
cmInsert.Parameters.Add(new SqlParameter("asstitle", AssTitle));
cmInsert.Parameters.Add(new SqlParameter("coursetitle", CourseTitleA));
cmInsert.Parameters.Add(new SqlParameter("description", Description));
cmInsert.Parameters.Add(new SqlParameter("sub", Subscription));
cmInsert.Parameters.Add(new SqlParameter("oralmark", OralMark));
cmInsert.Parameters.Add(new SqlParameter("totalmark", TotalMark));
int rowsAffected = cmInsert.ExecuteNonQuery();
// Display A message for the Inserted ASSIGNMENT
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| Assignments Inserted Succesfully: {rowsAffected,-26} |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
// Bring the Table ASSIGNMENT to see our newly Input ASSIGNMENT
sqlAssignment MyIA1 = new sqlAssignment();
MyIA1.AssignmentSelectOutput();
// Again, Show the Inserted ASSIGNMENT
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"| Assignments Inserted Succesfully: {rowsAffected,-26} |");
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("#==========================================================================#");
Console.ForegroundColor = ConsoleColor.White;
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}