public static void createTestData()
{
using (var DbContext = new EMPDBEntities2())
{
var dept = new dept();
dept.dept_id = 20;
dept.dept_name = "Chemistry";
var emp = new employee();
emp.emp_id = 4;
emp.emp_name = "Mamata Patra";
emp.mgr_id = 1;
emp.dept_id = 20;
emp.dob = new DateTime(1978, 7, 2);
//var course = new courses();
//course.course_id = 1;
//course.course_name = "Elementary Physics";
//var instructor = new instructor();
//instructor.ins_id = 1;
//instructor.ins_name = "H.C. Verma";
DbContext.dept.Add(dept);
DbContext.employee.Add(emp);
//DbContext.courses.Add(course);
//DbContext.instructor.Add(instructor);
DbContext.SaveChanges();
}
}
public void saveToDisk()
{
if (_logStorage.Count > 0)
{
using (var dbContext = new EMPDBEntities2())
{
dbContext.databaselog.AddRange(_logStorage);
dbContext.SaveChanges();
}
}
}
public static void updateTestDate()
{
using (var DbContext = new EMPDBEntities2())
{
var course1 = DbContext.courses.Where((s) => s.course_name == "Elementary Physics").FirstOrDefault();
var emp = DbContext.employee.Find(1);
emp.courses.Add(course1);
course1.employee.Add(emp);
var ins = DbContext.instructor.Find(1);
course1.instructor.Add(ins);
//emp.emp_name = "Suvendu Patra";
DbContext.SaveChanges();
}
}
