// Μεταφορά Assignment στην Βάση δεδομένων
public static void AssignmentTransfer(string description, string title, object subDate, object oral, object total)
{
SqlConnection con = new SqlConnection(ConString);
string qr = "Insert into Assignment ( Title ,Description, SubDateTime , Oralmark, TotalMark) VALUES (@Title, @Description , @SubDateTime , @Oralmark, @TotalMark)";
SqlCommand cmd = new SqlCommand(qr, con);
cmd.Parameters.AddWithValue("@Title", title);
cmd.Parameters.AddWithValue("@Description", description);
cmd.Parameters.AddWithValue("@SubDateTime", subDate);
cmd.Parameters.AddWithValue("@Oralmark", oral ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@TotalMark", total ?? (object)DBNull.Value);
try
{
con.Open();
cmd.ExecuteNonQuery();
Standard_Messages.SuccessfullInsert();
Interaction.ContinueAddingAsOrNot();
}
catch (SqlException e)
{
Standard_Messages.Error();
Console.WriteLine(e.ToString());
}
finally
{
con.Close();
Console.ReadKey();
}
}
// Μεταφορά Μαθητή στην Βάση δεδομένων
public static void StudentTransfer(string firstName, string lastName, DateTime dateOfBirth, object tuitionFees)
{
SqlConnection con = new SqlConnection(ConString);
string qr = "Insert into Student (FirstName, LastName , DateOfBirth , TuitionFees) VALUES (@FirstName, @LastName , @DateOfBirth , @TuitionFees)";
SqlCommand cmd = new SqlCommand(qr, con);
cmd.Parameters.AddWithValue("@FirstName", firstName);
cmd.Parameters.AddWithValue("@LastName", lastName);
cmd.Parameters.AddWithValue("@DateOfBirth", dateOfBirth);
cmd.Parameters.AddWithValue("@TuitionFees", tuitionFees ?? (object)DBNull.Value);
try
{
con.Open();
cmd.ExecuteNonQuery();
Standard_Messages.SuccessfullInsert();
Interaction.ContinueAddingStudOrNot();
}
catch (SqlException e)
{
Standard_Messages.Error();
Console.WriteLine(e.ToString());
}
finally
{
con.Close();
Console.ReadKey();
}
}
// Δημιουργία μιας νέας τριπλής σχέσης μεταξύ Μαθητή , Μαθήματος και Assignment .Μεταφορά σχέσης στην Βάση δεδομένων
public static void AssignmentPerCoursePerStudentTransfer(int course_id, int assignment_id, int studentId)
{
SqlConnection con = new SqlConnection(ConString);
string qr = @"Insert into AssignmentPerCourse (Course_ID , Assignment_ID ) VALUES (@Course_ID , @Assignment_ID)
Insert into StudentPerCourse (Course_ID , Student_ID) VALUES (@Course_ID , @Student_ID)";
SqlCommand cmd = new SqlCommand(qr, con);
cmd.Parameters.AddWithValue("@Course_ID", course_id);
cmd.Parameters.AddWithValue("@Assignment_ID", assignment_id);
cmd.Parameters.AddWithValue("@Student_ID", studentId);
try
{
con.Open();
cmd.ExecuteNonQuery();
Standard_Messages.SuccessfullInsert();
Interaction.ContinueAddingAssignmentPerCourseOrNot();
}
catch (SqlException e) when(e.Number == 2627 || e.Number == 547)
{
Standard_Messages.Error();
Standard_Messages.AlreadyExists();
Interaction.ContinueAddingAssignmentPerCourseOrNot();
}
finally
{
con.Close();
Console.ReadKey();
}
}
// Δημιουργία μιας νέας σχέσης Καθηγητή και Μαθήματος .Μεταφορά σχέσης στην Βάση δεδομένων
public static void TrainerPerCourseTransfer(int course_id, int trainer_id)
{
SqlConnection con = new SqlConnection(ConString);
string qr = "Insert into TrainerPerCourse (Course_ID , Trainer_ID) VALUES (@Course_ID , @Trainer_ID)";
SqlCommand cmd = new SqlCommand(qr, con);
cmd.Parameters.AddWithValue("@Course_ID", course_id);
cmd.Parameters.AddWithValue("@Trainer_ID", trainer_id);
try
{
con.Open();
cmd.ExecuteNonQuery();
Standard_Messages.SuccessfullInsert();
Interaction.ContinueAddingTrainerPerCourseOrNot();
}
catch (SqlException e) when(e.Number == 2627 || e.Number == 547)
{
Standard_Messages.Error();
Standard_Messages.AlreadyExists();
Interaction.ContinueAddingTrainerPerCourseOrNot();
}
finally
{
con.Close();
Console.ReadKey();
}
}
// Μεταφορά Μαθήματος στην Βάση
public static void CourseTransfer(string title, string stream, string type, DateTime startDate, DateTime endDate)
{
SqlConnection con = new SqlConnection(ConString);
string qr = "Insert into Course (Title, Stream , Type , StartDate , EndDate) VALUES (@Title, @Stream , @Type ,@StartDate , @EndDate)";
SqlCommand cmd = new SqlCommand(qr, con);
cmd.Parameters.AddWithValue("@Title", title);
cmd.Parameters.AddWithValue("@Stream", stream);
cmd.Parameters.AddWithValue("@Type", type);
cmd.Parameters.AddWithValue("@StartDate", startDate);
cmd.Parameters.AddWithValue("@EndDate", endDate);
try
{
con.Open();
cmd.ExecuteNonQuery();
Standard_Messages.SuccessfullInsert();
Interaction.ContinueAddingCourseOrNot();
}
catch (SqlException e)
{
Standard_Messages.Error();
e.ToString();
}
finally
{
con.Close();
Console.ReadKey();
}
}
// Μεταφορά Καθηγητή στην Βάση δεδομένων
public static void TrainerTransfer(string firstname, string lastname, string subject)
{
SqlConnection con = new SqlConnection(ConString);
string qr = "Insert into Trainer (FirstName , LastName , Subject) VALUES (@FirstName , @LastName , @Subject)";
SqlCommand cmd = new SqlCommand(qr, con);
cmd.Parameters.AddWithValue("@FirstName", firstname);
cmd.Parameters.AddWithValue("@LastName", lastname);
cmd.Parameters.AddWithValue("@Subject", subject);
try
{
con.Open();
cmd.ExecuteNonQuery();
Standard_Messages.SuccessfullInsert();
Interaction.ContinueAddingTrainerOrNot();
}
catch (SqlException e)
{
Standard_Messages.Error();
Console.WriteLine(e.ToString());
}
finally
{
con.Close();
Console.ReadKey();
}
}
