static void Main(string[] args)
{
using (var db = new SchoolContext())
{
var std = new Standard() { StandardName = "國小" };
std.Students.Add(new Student()
{
StudentName = "Will",
Weight = 30,
Height = 170,
DateOfBirth = DateTime.Now
});
std.Students.Add(new Student()
{
StudentName = "Will 2",
Weight = 50,
Height = 170,
DateOfBirth = DateTime.Now
});
db.Standards.Add(std);
db.SaveChanges();
foreach (var item in db.Students)
{
Console.WriteLine(item.StudentName + "\t" + item.Standard.StandardName);
}
}
}
public ActionResult Student()
{
var db=new SchoolContext();
var StudentList = (from student in db.Students
select student).ToList();
return View(StudentList);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, SchoolContext context)
{
loggerFactory.AddConsole(Configuration.GetSection("Logging"));
loggerFactory.AddDebug();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseDatabaseErrorPage();
app.UseBrowserLink();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseStaticFiles();
app.UseIdentity();
// Add external authentication middleware below. To configure them please see http://go.microsoft.com/fwlink/?LinkID=532715
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
DbInitializer.Initialize(context);
}
public UnitOfWork(SchoolContext ctx)
{
this.context = ctx;
CoursesFromGenericRepo = new CourseRepository(context);
CourseRepo = new CourseRepository(context);
StudentGenericRepo = new StudentRepository(context);
StudentRepo = new StudentRepository(context);
}
public void TestMethod1()
{
using (var context = new SchoolContext())
{
foreach (var p in context.People)
{
Console.WriteLine($"{p.FirstName} {p.LastName}");
}
}
}
static void Main(string[] args)
{
using (var ctx = new SchoolContext())
{
Student stud = new Student() { StudentName = "New Student" };
ctx.Students.Add(stud);
ctx.SaveChanges();
}
}
public ActionResult Detail(int? id)
{
var db = new SchoolContext();
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
Student student = db.Students.Find(id);
if (student == null)
{
return HttpNotFound();
}
return View(student);
}
static void Main(string[] args)
{
//using (var ctx = new SchoolContext())
//{
// var osmaci = ctx.Classes.FirstOrDefault(c => c.ClassName.Contains("8.A"));
// var stud = new Student() { StudentName = "Marek", Class = osmaci };
// if (osmaci == null)
// {
// osmaci = new Class() { ClassName = "8.A" };
// ctx.Classes.Add(osmaci);
// }
// ctx.Students.Add(stud);
// ctx.SaveChanges();
// var students = ctx.Students.ToList();
// var studentMarek = ctx.Students.FirstOrDefault(s => s.StudentName.Contains("Marek"));
// studentMarek.StudentName = "Marek Skotnica";
// ctx.SaveChanges();
//}
using (var ctx = new SchoolContext())
{
var marek = ctx.Students.FirstOrDefault(s => s.StudentName.Contains("Marek"));
ctx.Students.Remove(marek);
ctx.SaveChanges();
}
//if (marek != null)
//{
// marek.StudentName = "Marek Skotnica";
//}
//using (var ctx = new SchoolContext())
//{
// ctx.Entry(marek).State = System.Data.Entity.EntityState.Modified;
// ctx.SaveChanges();
//}
}
public ActionResult CreateStudent(Student model)
{
try
{
if (ModelState.IsValid)
{
var db = new SchoolContext();
db.Students.Add(model);
db.SaveChanges();
TempData["success"] = "true";
TempData["message"] = "The Student has been added successfully";
return RedirectToAction("Student");
}
}
catch (RetryLimitExceededException ex)
{
TempData["error"] = "true";
TempData["message"] = "An error has ocurred while added the Student";
return RedirectToAction("Student");
}
return View();
}
void OnInsertCommand(string param)
{
using (var ctx = new SchoolContext())
{
if (param == "Student")
{
ctx.Student.Add(new Student() { Name = "Jerry" });
ctx.SaveChanges();
}
else if (param == "Teacher")
{
ctx.Teacher.Add(new Teacher() { Name = "Kim" });
ctx.SaveChanges();
}
else if (param == "Course")
{
ctx.Course.Add(new Course() { Name = "Biology" });
ctx.SaveChanges();
}
else
{
;
}
}
}
public QueryHandler(SchoolContext db, MapperConfiguration config)
{
_db = db;
_config = config;
}
public InstructorsController(SchoolContext context)
{
_context = context;
}
public EFUnitOfWork(string connectionString)
{
_context = new SchoolContext(connectionString);
}
public EconomicPermissionsController(SchoolContext context)
{
_context = context;
}
public InstructorRepository(SchoolContext schoolContext)
{
this.context = schoolContext;
}
public StudentsController(SchoolContext context, IEmailSender emailSender)
{
_context = context;
_emailSender = emailSender;
}
public Handler(SchoolContext db) => _db = db;
public CreateModel(SchoolContext context)
{
_context = context;
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, SchoolContext context)
{
loggerFactory.AddConsole(Configuration.GetSection("Logging"));
loggerFactory.AddDebug();
app.UseApplicationInsightsRequestTelemetry();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseBrowserLink();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseApplicationInsightsExceptionTelemetry();
app.UseStaticFiles();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
DbInitializer.Initialize(context);
}
public EnrollmentsController(SchoolContext context)
{
_context = context;
}
public GenericRepository(SchoolContext context) {
_context = context;
}
public static void Initialize(SchoolContext context)
{
//context.Database.EnsureCreated();
// Look for any students.
if (context.Students.Any())
{
return; // DB has been seeded
}
var students = new Student[]
{
new Student { FirstMidName = "Carson", LastName = "Alexander",
EnrollmentDate = DateTime.Parse("2010-09-01") },
new Student { FirstMidName = "Meredith", LastName = "Alonso",
EnrollmentDate = DateTime.Parse("2012-09-01") },
new Student { FirstMidName = "Arturo", LastName = "Anand",
EnrollmentDate = DateTime.Parse("2013-09-01") },
new Student { FirstMidName = "Gytis", LastName = "Barzdukas",
EnrollmentDate = DateTime.Parse("2012-09-01") },
new Student { FirstMidName = "Yan", LastName = "Li",
EnrollmentDate = DateTime.Parse("2012-09-01") },
new Student { FirstMidName = "Peggy", LastName = "Justice",
EnrollmentDate = DateTime.Parse("2011-09-01") },
new Student { FirstMidName = "Laura", LastName = "Norman",
EnrollmentDate = DateTime.Parse("2013-09-01") },
new Student { FirstMidName = "Nino", LastName = "Olivetto",
EnrollmentDate = DateTime.Parse("2005-09-01") }
};
foreach (Student s in students)
{
context.Students.Add(s);
}
context.SaveChanges();
var instructors = new Instructor[]
{
new Instructor { FirstMidName = "Kim", LastName = "Abercrombie",
HireDate = DateTime.Parse("1995-03-11") },
new Instructor { FirstMidName = "Fadi", LastName = "Fakhouri",
HireDate = DateTime.Parse("2002-07-06") },
new Instructor { FirstMidName = "Roger", LastName = "Harui",
HireDate = DateTime.Parse("1998-07-01") },
new Instructor { FirstMidName = "Candace", LastName = "Kapoor",
HireDate = DateTime.Parse("2001-01-15") },
new Instructor { FirstMidName = "Roger", LastName = "Zheng",
HireDate = DateTime.Parse("2004-02-12") }
};
foreach (Instructor i in instructors)
{
context.Instructors.Add(i);
}
context.SaveChanges();
var departments = new Department[]
{
new Department { Name = "English", Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorID = instructors.Single( i => i.LastName == "Abercrombie").ID },
new Department { Name = "Mathematics", Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorID = instructors.Single( i => i.LastName == "Fakhouri").ID },
new Department { Name = "Engineering", Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorID = instructors.Single( i => i.LastName == "Harui").ID },
new Department { Name = "Economics", Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorID = instructors.Single( i => i.LastName == "Kapoor").ID }
};
foreach (Department d in departments)
{
context.Departments.Add(d);
}
context.SaveChanges();
var courses = new Course[]
{
new Course {CourseID = 1050, Title = "Chemistry", Credits = 3,
DepartmentID = departments.Single( s => s.Name == "Engineering").DepartmentID
},
new Course {CourseID = 4022, Title = "Microeconomics", Credits = 3,
DepartmentID = departments.Single( s => s.Name == "Economics").DepartmentID
},
new Course {CourseID = 4041, Title = "Macroeconomics", Credits = 3,
DepartmentID = departments.Single( s => s.Name == "Economics").DepartmentID
},
new Course {CourseID = 1045, Title = "Calculus", Credits = 4,
DepartmentID = departments.Single( s => s.Name == "Mathematics").DepartmentID
},
new Course {CourseID = 3141, Title = "Trigonometry", Credits = 4,
DepartmentID = departments.Single( s => s.Name == "Mathematics").DepartmentID
},
new Course {CourseID = 2021, Title = "Composition", Credits = 3,
DepartmentID = departments.Single( s => s.Name == "English").DepartmentID
},
new Course {CourseID = 2042, Title = "Literature", Credits = 4,
DepartmentID = departments.Single( s => s.Name == "English").DepartmentID
},
};
foreach (Course c in courses)
{
context.Courses.Add(c);
}
context.SaveChanges();
var officeAssignments = new OfficeAssignment[]
{
new OfficeAssignment {
InstructorID = instructors.Single( i => i.LastName == "Fakhouri").ID,
Location = "Smith 17" },
new OfficeAssignment {
InstructorID = instructors.Single( i => i.LastName == "Harui").ID,
Location = "Gowan 27" },
new OfficeAssignment {
InstructorID = instructors.Single( i => i.LastName == "Kapoor").ID,
Location = "Thompson 304" },
};
foreach (OfficeAssignment o in officeAssignments)
{
context.OfficeAssignments.Add(o);
}
context.SaveChanges();
var courseInstructors = new CourseAssignment[]
{
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID,
InstructorID = instructors.Single(i => i.LastName == "Kapoor").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID,
InstructorID = instructors.Single(i => i.LastName == "Harui").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Microeconomics" ).CourseID,
InstructorID = instructors.Single(i => i.LastName == "Zheng").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Macroeconomics" ).CourseID,
InstructorID = instructors.Single(i => i.LastName == "Zheng").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Calculus" ).CourseID,
InstructorID = instructors.Single(i => i.LastName == "Fakhouri").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Trigonometry" ).CourseID,
InstructorID = instructors.Single(i => i.LastName == "Harui").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Composition" ).CourseID,
InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Literature" ).CourseID,
InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID
},
};
foreach (CourseAssignment ci in courseInstructors)
{
context.CourseAssignments.Add(ci);
}
context.SaveChanges();
var enrollments = new Enrollment[]
{
new Enrollment {
StudentID = students.Single(s => s.LastName == "Alexander").ID,
CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID,
Grade = Grade.A
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Alexander").ID,
CourseID = courses.Single(c => c.Title == "Microeconomics" ).CourseID,
Grade = Grade.C
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Alexander").ID,
CourseID = courses.Single(c => c.Title == "Macroeconomics" ).CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Alonso").ID,
CourseID = courses.Single(c => c.Title == "Calculus" ).CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Alonso").ID,
CourseID = courses.Single(c => c.Title == "Trigonometry" ).CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Alonso").ID,
CourseID = courses.Single(c => c.Title == "Composition" ).CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Anand").ID,
CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Anand").ID,
CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Barzdukas").ID,
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Li").ID,
CourseID = courses.Single(c => c.Title == "Composition").CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Justice").ID,
CourseID = courses.Single(c => c.Title == "Literature").CourseID,
Grade = Grade.B
}
};
foreach (Enrollment e in enrollments)
{
var enrollmentInDataBase = context.Enrollments.Where(
s =>
s.Student.ID == e.StudentID &&
s.Course.CourseID == e.CourseID).SingleOrDefault();
if (enrollmentInDataBase == null)
{
context.Enrollments.Add(e);
}
}
context.SaveChanges();
}
// constructor will set the value of the contex base on the passing parameter
public StudentRepository(SchoolContext context)
{
this.context = context; // using "this" key word to access to the private data
}
public Handler(SchoolContext db, IMapper mapper)
{
_db = db;
this.mapper = mapper;
}
public SubjectsController(SchoolContext db) : base(db)
{
this.repository = new SubjectRepository(db);
}
public ProjectMemberOrchestrator()
{
_schoolContext = new SchoolContext();
}
public OfficeAssigmentRepository(SchoolContext schoolContext)
{
this.context = schoolContext;
}
public SqlServer(SchoolContext schoolContext)
{
_context = schoolContext;
}
public AccountController(SchoolContext context, UserManager <ApplicationUser> userManager)
{
_context = context;
_userManager = userManager;
}
public IndexModel(SchoolContext context)
{
_context = context;
}
public QueryHandler(SchoolContext db)
{
_db = db;
}
public TableController(SchoolContext context)
{
db = context;
}
public DepartmentsController(SchoolContext context)
{
_context = context;
}
public DepartmentsController(SchoolContext context)
{
_context = context;
}
void OnDeleteCommand(string param)
{
using (var ctx = new SchoolContext())
{
if (param == "Student")
{
Student student = ctx.Student.FirstOrDefault(s => s.Name == "Lisa");
if (student != null)
ctx.Student.Remove(student);
student = ctx.Student.FirstOrDefault(s => s.Name == "Jerry");
if (student != null)
ctx.Student.Remove(student);
ctx.SaveChanges();
}
else if (param == "Teacher")
{
Teacher teacher = ctx.Teacher.FirstOrDefault(t => t.Name == "Clause");
ctx.Teacher.Remove(teacher);
ctx.SaveChanges();
}
else if (param == "Course")
{
Course course = ctx.Course.FirstOrDefault(c => c.Name == "Arts");
ctx.Course.Remove(course);
ctx.SaveChanges();
}
else
{
;
}
}
}
public CoursesController(SchoolContext context)
{
_context = context;
}
public static void Initialize(SchoolContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Students.Any())
{
return; // DB has been seeded
}
var students = new Student[]
{
new Student{FirstMidName="Carson",LastName="Alexander",EnrollmentDate=DateTime.Parse("2005-09-01")},
new Student{FirstMidName="Meredith",LastName="Alonso",EnrollmentDate=DateTime.Parse("2002-09-01")},
new Student{FirstMidName="Arturo",LastName="Anand",EnrollmentDate=DateTime.Parse("2003-09-01")},
new Student{FirstMidName="Gytis",LastName="Barzdukas",EnrollmentDate=DateTime.Parse("2002-09-01")},
new Student{FirstMidName="Yan",LastName="Li",EnrollmentDate=DateTime.Parse("2002-09-01")},
new Student{FirstMidName="Peggy",LastName="Justice",EnrollmentDate=DateTime.Parse("2001-09-01")},
new Student{FirstMidName="Laura",LastName="Norman",EnrollmentDate=DateTime.Parse("2003-09-01")},
new Student{FirstMidName="Nino",LastName="Olivetto",EnrollmentDate=DateTime.Parse("2005-09-01")}
};
foreach (Student s in students)
{
context.Students.Add(s);
}
context.SaveChanges();
var courses = new Course[]
{
new Course{CourseID=1050,Title="Chemistry",Credits=3,},
new Course{CourseID=4022,Title="Microeconomics",Credits=3,},
new Course{CourseID=4041,Title="Macroeconomics",Credits=3,},
new Course{CourseID=1045,Title="Calculus",Credits=4,},
new Course{CourseID=3141,Title="Trigonometry",Credits=4,},
new Course{CourseID=2021,Title="Composition",Credits=3,},
new Course{CourseID=2042,Title="Literature",Credits=4,}
};
foreach (Course c in courses)
{
context.Courses.Add(c);
}
context.SaveChanges();
var enrollments = new Enrollment[]
{
new Enrollment{StudentID=1,CourseID=1050,Grade=Grade.A},
new Enrollment{StudentID=1,CourseID=4022,Grade=Grade.C},
new Enrollment{StudentID=1,CourseID=4041,Grade=Grade.B},
new Enrollment{StudentID=2,CourseID=1045,Grade=Grade.B},
new Enrollment{StudentID=2,CourseID=3141,Grade=Grade.F},
new Enrollment{StudentID=2,CourseID=2021,Grade=Grade.F},
new Enrollment{StudentID=3,CourseID=1050},
new Enrollment{StudentID=4,CourseID=1050,},
new Enrollment{StudentID=4,CourseID=4022,Grade=Grade.F},
new Enrollment{StudentID=5,CourseID=4041,Grade=Grade.C},
new Enrollment{StudentID=6,CourseID=1045},
new Enrollment{StudentID=7,CourseID=3141,Grade=Grade.A},
};
foreach (Enrollment e in enrollments)
{
context.Enrollments.Add(e);
}
context.SaveChanges();
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, SchoolContext context)
{
loggerFactory.AddConsole(Configuration.GetSection("Logging"));
loggerFactory.AddDebug();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseDatabaseErrorPage();
app.UseBrowserLink();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseStaticFiles();
app.UseIdentity();
// Add external authentication middleware below. To configure them please see http://go.microsoft.com/fwlink/?LinkID=532715
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
DbInitializer.Initialize(context);
}
public InstructorController(SchoolContext db)
{
this.db = db;
}
public ActionResult EditStudent(Student student)
{
try
{
var db = new SchoolContext();
db.Entry(student).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
TempData["success"] = "true";
TempData["message"] = "The student has been updated";
return RedirectToAction("Student");
}
catch (Exception ex)
{
TempData["error"] = "true";
TempData["message"] = "An error has ocurred while update the student";
return RedirectToAction("Student");
}
}
public DeleteModel(SchoolContext context)
{
_context = context;
}
public LecturesController(SchoolContext context)
{
_context = context;
}
public JsonResult DeleteStudent(int? id)
{
try
{
var db = new SchoolContext();
Student student = db.Students.Find(id);
db.Students.Remove(student);
db.SaveChanges();
return Json(new { result = "ok", message = "The Student has been deleted" });
}
catch (Exception ex)
{
return Json(new { result = "error", message = "An error has ocurred while delete student" });
}
}
public SchoolContext Init()
{
return dbContext ?? (dbContext = new SchoolContext());
}
public HomeController(SchoolContext context, IStringLocalizer<HomeController> localizer)
{
_context = context;
_localizer = localizer;
}
public StudentRepository(SchoolContext SchoolContext) : base(SchoolContext)
{
_schoolContext = SchoolContext;
}
public ActionResult EditStudent(int? id)
{
var db=new SchoolContext();
Student student = db.Students.Find(id);
return View(student);
}
public SotrudnikDetailsController(SchoolContext context)
{
_context = context;
}
public StudentProfile()
{
context = new SchoolContext();
}
public DatAssignment(SchoolContext schoolContext)
{
_schoolContext = schoolContext;
}
public DepartmentRepository(SchoolContext schoolContext)
{
this.context = schoolContext;
}
public StudentsController(SchoolContext context)
{
_context = context;
}
public CoursesController(SchoolContext context)
{
_context = context;
}
public HomeController(SchoolContext context)
{
_context = context;
}
public Handler(SchoolContext db, IConfigurationProvider configuration)
{
_db = db;
_configuration = configuration;
}
public DepartmentController(SchoolContext schoolContext)
{
db = schoolContext;
}
public StudentsController(SchoolContext context)
{
_context = context;
}
public InstructorsController(SchoolContext context)
{
_context = context;
}
public StudentRepository(SchoolContext context)
{
this.context = context;
}
public StoredProcedure(SchoolContext db)
{
_db = db;
}
