private static void AddStudent()
{
using (var ctx = new EntityConnector())
{
Student stud1 = new Student();
stud1.FirstMidName = "Pelle";
stud1.LastName = "Svenson";
stud1.EnrollmentDate = new DateTime(2015, 10, 10);
ctx.Students.Add(stud1);
Student stud2 = new Student();
stud2.FirstMidName = "Erik";
stud2.LastName = "Jönson";
stud2.EnrollmentDate = new DateTime(2016, 12, 20);
ctx.Students.Add(stud2);
Student stud3 = new Student();
stud3.FirstMidName = "Jonas";
stud3.LastName = "Sheik.khalil";
stud3.EnrollmentDate = new DateTime(2016, 6, 15);
ctx.Students.Add(stud3);
ctx.SaveChanges();
}
Console.WriteLine("Students added successfully");
}
private static void AddEnrollment()
{
using (var ctx = new EntityConnector())
{
Enrollment enr1 = new Enrollment();
enr1.EnrollmentName = "Asp.Net Development";
enr1.CourseId = 1;
enr1.Grade = "Good";
ctx.Enrollments.Add(enr1);
Enrollment enr2 = new Enrollment();
enr2.EnrollmentName = "Android Development";
enr2.CourseId = 2;
enr2.Grade = "Awsome";
ctx.Enrollments.Add(enr2);
Enrollment enr3 = new Enrollment();
enr3.EnrollmentName = "iOS Development";
enr3.CourseId = 3;
enr3.Grade = "Average";
ctx.Enrollments.Add(enr3);
ctx.SaveChanges();
}
Console.WriteLine("Enrollments added successfully");
}
public static bool Delete(int id)
{
using (var ec = new TestProjectEntities1())
{
var tbUser = ec.tb_user.FirstOrDefault(i => i.id == id);
if (tbUser == null)
{
return(false);
}
ec.tb_user.Remove(tbUser);
EntityConnector.SaveChanges(ec);
return(true);
}
}
public static bool Add(User user)
{
using (var ec = new TestProjectEntities1())
{
var tbUser = new tb_user
{
name = user.Name,
language_id = user.LanguageId,
creation_date = DateTime.Now,
};
ec.tb_user.Add(tbUser);
EntityConnector.SaveChanges(ec);
return(true);
}
}
private static void AddCourse()
{
using (var ctx = new EntityConnector())
{
Course cour1 = new Course();
cour1.CourseName = "Entity Framework";
cour1.Credits = 15;
ctx.Courses.Add(cour1);
Course cour2 = new Course();
cour2.CourseName = "Java";
cour2.Credits = 30;
ctx.Courses.Add(cour2);
Course cour3 = new Course();
cour3.CourseName = "Objective-C";
cour3.Credits = 30;
ctx.Courses.Add(cour3);
ctx.SaveChanges();
}
Console.WriteLine("Courses added successfully");
}