protected void LinkButtonDelete_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
HiddenField hd = (HiddenField)lb.FindControl("HiddenFieldStudID");
int studentID = int.Parse(hd.Value);
var ac = new AttendanceControl();
var studentToRemove = studentsControl.GetAllStudents().Where(x => x.Id == studentID).FirstOrDefault();
if (studentToRemove.Attendance.Count > 0)
{
ac.RemoveAttendanceByStudentID(studentID);
}
if (studentToRemove != null)
{
studentsControl.RemoveStudent(studentID);
var pc = new PeopleControl();
pc.RemovePeople(studentToRemove.PersonId);
}
BindGrid();
}
static void Main(string[] args)
{
var control = new StudentControl();
var students = control.GetAllStudents();
Console.WriteLine("Students\n-----------------------------------------------");
foreach (var s in students)
{
Console.WriteLine("Name: " + s.People.FirstName + " " + s.People.LastName);
foreach (var g in s.Grades)
{
Console.WriteLine("Course: " + g.Courses.CourseName + " Grade: " + g.Grade);
Console.WriteLine("--------------------------------------------------------");
}
}
var peopleCtx = new PeopleControl();
//var people = peopleCtx.GetAllPeople();
//// Insert
//peopleCtx.InsertPeople(new People() { FirstName = "Algot", LastName = "Alfredsson", Email = "*****@*****.**" });
//people.ToList().ForEach(x => Console.WriteLine($"{x.Id} {x.FirstName} {x.LastName} {x.Email}"));
//Delete
//var input = Console.ReadLine();
//var toDelete = peopleCtx.PeopleByID(int.Parse(input));
//peopleCtx.RemovePeople(toDelete);
//var newPeople = peopleCtx.GetAllPeople();
//newPeople.ToList().ForEach(x => Console.WriteLine($"{x.Id} {x.FirstName} {x.LastName} {x.Email}"));
//Update
//Console.WriteLine("id: ");
//var nameID = Console.ReadLine();
//Console.WriteLine("New Name:");
//var namechange = Console.ReadLine();
//var nameChangePerson = peopleCtx.PeopleByID(int.Parse(nameID));
//nameChangePerson.FirstName = namechange;
//peopleCtx.UpdatePeople(nameChangePerson);
//var newPeople2 = peopleCtx.GetAllPeople();
//newPeople2.ToList().ForEach(x => Console.WriteLine($"{x.Id} {x.FirstName} {x.LastName} {x.Email}"));
//Insert Student
var ppl = new People()
{
FirstName = "Lisa", LastName = "Sävås", Email = "Lisa@Sävås.se"
};
peopleCtx.InsertPeople(ppl);
var studentClass = new StudentClasses()
{
ClassName = "WIN15"
};
var studentClassesCtx = new ClassesControl();
studentClassesCtx.InsertorUpdateClass(studentClass);
var educationCTX = new EducationsControl();
var education = new Educations()
{
EducationName = "Administration"
};
educationCTX.InsertorUpdateEducation(education);
var newStudent = new Students()
{
PersonId = ppl.Id,
StudentClass_Id = studentClass.Id,
EducationId = education.Id
};
control.InsertStudent(newStudent);
var newStudentContext = new StudentControl();
var studentsList = newStudentContext.GetAllStudents().ToList();
Console.WriteLine("Added new student Lisa");
Console.WriteLine("-------Students Again-------");
foreach (var stud in studentsList)
{
Console.WriteLine("Name: " + stud.People.FirstName + " " + stud.People.LastName);
Console.WriteLine("CourseID: " + stud.StudentClasses.Id + " Class: " + stud.StudentClasses.ClassName);
Console.WriteLine("ID: " + stud.Educations.Id + " Education Name: " + stud.Educations.EducationName);
Console.WriteLine("--------------------------------------------------------------------------------");
}
var AttendanceControl = new AttendanceControl();
Attendance att = new Attendance()
{
Date = new DateTime(2016, 11, 02), StudentID = newStudent.Id, CourseID = 2, Attendance1 = false
};
AttendanceControl.InsertAttendance(att);
var lisa = newStudentContext.StudentsByID(newStudent.Id);
var attendance = new AttendanceControl();
var attendanceObj = attendance.AttendaceByStudentAndCourseID(newStudent.Id, 2);
Console.WriteLine("Added new attendance for Lisa");
Console.WriteLine("-----Attendance-----");
Console.WriteLine($"{lisa.People.FirstName} {lisa.People.LastName} Närvaro i {attendanceObj.Courses.CourseName} den {attendanceObj.Date}: {attendanceObj.Attendance1}");
Console.WriteLine();
AttendanceControl.RemoveAttendance(att);
//educationCTX.RemoveEducation(education);
control.RemoveStudent(newStudent);
studentClassesCtx.RemoveClass(studentClass);
educationCTX.RemoveEducation(education);
peopleCtx.RemovePeople(ppl);
Console.ReadKey();
}