static void Main(string[] args)
{
var lib = new StudentLib();
//insert a student (elmer fudd)
var ef = new Student
{
Id = 0,
Firstname = "Elmer",
Lastname = "Fudd",
Sat = 600,
Gpa = 1.5,
IsFulltime = true,
MajorId = 1
};
var ok = lib.InsertStudent(ef);
Console.WriteLine(ef);
Console.WriteLine((ok ? "Insert Successful!" : "Insert Failed!"));
//remove a student
var johnsmith = lib.GetStudent(2);
lib.DeleteStudent(johnsmith);
//update jon smith id=(2)
var jonsmith = lib.GetStudent(2);
jonsmith.Firstname = "John";
var success = lib.UpdateStudent(jonsmith);
//get list of all students
var students = lib.ListStudents();
foreach (var s in students)
{
Console.WriteLine($"{s.Firstname} {s.Lastname} {s.Major?.Description}");
}
//get a student by primary key
var student = lib.GetStudent(1);
if (student == null)
{
Console.WriteLine("Student Not Found");
}
else
{
Console.WriteLine($"S4: {student.Firstname} {student.Lastname}");
}
//this should fail
var s444 = lib.GetStudent(444);
if (s444 == null)
{
Console.WriteLine("Student not found");
}
else
{
Console.WriteLine($"S444: {student.Firstname} {student.Lastname}");
}
}
static void Main(string[] args)
{
var lib = new StudentLib();
// add elmer fudd
var ef = new Student {
Id = 0, Firstname = "Elmer", Lastname = "Fudd",
Sat = 600, Gpa = 1.5, IsFulltime = true, MajorId = 1
};
var ok = lib.InsertStudent(ef);
Console.WriteLine(ef);
Console.WriteLine((ok ? "Insert Successful!" : "Insert Failed!"));
// update elmer fudd
var elmerfudd = lib.GetStudent(ef.Id);
if (elmerfudd == null)
{
throw new Exception("Student not found!");
}
elmerfudd.Firstname = "Johnny";
var success = lib.UpdateStudent(elmerfudd);
Console.WriteLine(elmerfudd);
Console.WriteLine((success ? "Update Successful!" : "Update Failed!"));
// remove elmer fudd
var ef1 = new Student {
Id = ef.Id
};
var rc = lib.DeleteStudent(ef);
Console.WriteLine(ef1);
Console.WriteLine((rc ? "Delete Successful!" : "Delete Failed!"));
//// get list of all students
//var students = lib.ListStudents();
//foreach(var student in students) {
// Console.WriteLine($"{student.Firstname} {student.Lastname} {student.Major?.Description}");
//}
//// get a student by primary key
//// this should work
//var s4 = lib.GetStudent(2);
//if(s4 == null) {
// Console.WriteLine("Student not found!");
//} else {
// Console.WriteLine($"S4: {s4.Firstname} {s4.Lastname} {s4.Major.Description}");
//}
//// this should fail
//var s444 = lib.GetStudent(444);
//if(s444 == null) {
// Console.WriteLine("Student not found!");
//} else {
// Console.WriteLine($"S444: {s444.Firstname} {s444.Lastname} {s444.Major.Description}");
//}
}
static void Main(string[] args)
{
var lib = new StudentLib();
var pat = new Student();
pat.Firstname = "Patrick";
pat.Lastname = "Star";
pat.Gpa = 1.4;
pat.Sat = 900;
pat.IsFulltime = true;
pat.MajorId = 3;
lib.InsertStudent(pat);
// var del = lib.GetStudent(7);
//lib.DeleteStudent(del);
//update Alex id 1
var al = lib.GetStudent(1);
if (al == null)
{
throw new Exception("Student not found");
}
al.Firstname = "Alexzncdf";
var success = lib.UpdateStudent(al);
System.Console.WriteLine(success);
var students = lib.ListStudents();
foreach (var stud in students)
{
System.Console.WriteLine($"{stud.Firstname} {stud.Lastname} {stud.Major.Description}");
}
var st = new StudentLib();
var stu = st.GetStudent(50);
if (stu == null)
{
System.Console.WriteLine("Student not found");
}
else
{
System.Console.WriteLine(stu.Firstname);
}
}
static void Main(string[] args)
{
//var about = StudentLib.About; //To reference Studentlib since its in a different namespace or add a using statement
//BrianasUtilitiesLibrary.Console.Print(about);
//get list of all students
var lib = new StudentLib();
//To Insert Elmer Fudd
var ef = new Student
{
Id = 0,
Firstname = "Elmer",
Lastname = "Fudd",
Sat = 600,
Gpa = 1.5,
IsFulltime = true,
MajorId = 1
};
var ok = lib.InsertStudent(ef);
Console.WriteLine(ef);
Console.WriteLine((ok ? "Insert Successful!" : "Insert Failed!"));
//To Delete Jane Doe
var janedoe = lib.GetStudent(1);
lib.RemoveStudent(janedoe);
//To UPDATE John to Jon
//var jonsmith = lib.GetStudent(2);
//jonsmith.Firstname = "Jon";
//var success = lib.UpdateStudent(jonsmith);
var students = lib.ListStudents();
foreach (var student in students)
{
Console.WriteLine($"{student.Firstname} {student.Lastname} {student.Major?.Description}");
}
// get a student by primary key
var s4 = lib.GetStudent(4);
if (s4 == null)
{
Console.WriteLine("Student not found");
}
else
{
Console.WriteLine($"S4: {s4.Firstname} {s4.Lastname} {s4.Major?.Description}");
}
//this should fail
var s444 = lib.GetStudent(444);
if (s444 == null)
{
Console.WriteLine("Student not found!");
}
else
{
Console.WriteLine($"S444: {s444.Firstname} {s444.Lastname} {s444.Major.Description}");
}
}
