public void AssignmentSelectOutput()
{
string splGetAssignment = "SELECT * FROM Assignment";
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString.connection))
{
conn.Open();
using (SqlCommand cmSelectAssignment = new SqlCommand(splGetAssignment, conn))
{
using (SqlDataReader drAss = cmSelectAssignment.ExecuteReader())
{
Console.ForegroundColor = ConsoleColor.DarkCyan;
Console.WriteLine("----------------------------------------------------------------------------");
Console.WriteLine($"| {"TITLE",-6} | {"COURSE",-8} | {"DESCRIPTION",-12} | {"SUBSCRIBED",-11} | {"ORAL MARK",-10} | {"TOTAL MARK",-10} |");
Console.WriteLine("----------------------------------------------------------------------------");
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
while (drAss.Read())
{
AssTitle = drAss["AssTitle"].ToString();
CourseTitleA = drAss["CourseTitleA"].ToString();
Description = drAss["Description"].ToString();
Subscription = drAss["Subscription"].ToString();
OralMark = drAss["OralMark"].ToString();
TotalMark = drAss["TotalMark"].ToString();
// Split the DATE string so as to get rid of the Time
string[] SubscriptionList = Subscription.Split(' ');
// Remove the unessessary empty space characters from inserted strings
AssTitle = AssTitle.Replace(" ", string.Empty);
CourseTitleA = CourseTitleA.Replace(" ", string.Empty);
Description = Description.Replace(" ", string.Empty);
Subscription = Subscription.Replace(" ", string.Empty);
OralMark = OralMark.Replace(" ", string.Empty);
TotalMark = TotalMark.Replace(" ", string.Empty);
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine($"| {AssTitle,-6} | {CourseTitleA,-8} | {Description,-12} | {SubscriptionList[0],-11} | {OralMark,-10} | {TotalMark,-10} |");
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
}
Console.ForegroundColor = ConsoleColor.DarkCyan;
Console.WriteLine("----------------------------------------------------------------------------");
Console.WriteLine($"| {"TITLE",-6} | {"COURSE",-8} | {"DESCRIPTION",-12} | {"SUBSCRIBED",-11} | {"ORAL MARK",-10} | {"TOTAL MARK",-10} |");
Console.WriteLine("----------------------------------------------------------------------------");
Console.ForegroundColor = ConsoleColor.White;
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public string GetInfo()
{
var sb = new StringBuilder();
sb.Append($"Course[{Assignment.Course.ID}] '{Assignment.Course.Title}' | ")
.Append($"Assignment[{Assignment.ID}] '{Assignment.Title}' '{Assignment.Description}' | ")
.Append($"OM: {(OralMark?.ToString() ?? "N/A")} | ")
.Append($"TM: {TotalMark?.ToString() ?? "N/A"}");
return(sb.ToString());
}
public override string ToString()
{
var sb = new StringBuilder();
sb.AppendLine($"Student[{Student.ID}] {Student.User.FirstName} {Student.User.LastName}")
.AppendLine($"Course[{Assignment.Course.ID}] {Assignment.Course.Title}")
.AppendLine($"Assignment[{Assignment.ID}] '{Assignment.Title}' '{Assignment.Description}'")
.AppendLine($"Submission date: {Assignment.SubmissionDate?.ToString() ?? "not set"}")
.AppendLine($"Oral mark: {(OralMark?.ToString() ?? "not set")}")
.AppendLine($"Total mark: {TotalMark?.ToString() ?? "not set"}")
.AppendLine($"DateSubmitted: {DateSubmitted?.ToString() ?? "not submitted yet"}");
return(sb.ToString());
}
