public void Insert(ClassRoom classroom)
{
NetMvcDb db = new NetMvcDb();
db.ClassRooms.Add(classroom);
db.SaveChanges();
}
public void Update(ClassRoom classroom)
{
NetMvcDb db = new NetMvcDb();
db.ClassRooms.AddOrUpdate(classroom);
db.SaveChanges();
}
public void Insert(Department department)
{
NetMvcDb db = new NetMvcDb();
db.Departments.Add(department);
db.SaveChanges();
}
public void Update(Department department)
{
NetMvcDb db = new NetMvcDb();
db.Departments.AddOrUpdate(department);
db.SaveChanges();
}
public void Update(Student student)
{
NetMvcDb db = new NetMvcDb();
db.Students.AddOrUpdate(student);
db.SaveChanges();
}
public void Insert(Student student)
{
NetMvcDb db = new NetMvcDb();
db.Students.Add(student);
db.SaveChanges();
}
public IEnumerable <Department> GetDepartments()
{
NetMvcDb db = new NetMvcDb();
var list = db.Departments.Where(m => m.IsDelete == false).AsQueryable();
return(list.OrderByDescending(m => m.DepartmentID));
}
public IEnumerable <ClassRoom> GetClassRooms(int?DepartmentID)
{
NetMvcDb db = new NetMvcDb();
var list = db.ClassRooms.Where(m => m.IsDelete == false).AsQueryable();
if (DepartmentID.HasValue)
{
list = list.Where(m => m.DepartmentID == DepartmentID).AsQueryable();
}
return(list.OrderBy(m => m.SortOrder));
}
public ClassRoom FindByKey(int?ClassRoomID)
{
NetMvcDb db = new NetMvcDb();
ClassRoom classroom = new ClassRoom();
if (ClassRoomID.HasValue)
{
classroom = db.ClassRooms.Find(ClassRoomID);
}
return(classroom);
}
public Department FindByKey(int?DepartmentID)
{
NetMvcDb db = new NetMvcDb();
Department department = new Department();
if (DepartmentID.HasValue)
{
department = db.Departments.Find(DepartmentID);
}
return(department);
}
public Student FindByKey(int?StudentID)
{
NetMvcDb db = new NetMvcDb();
Student student = new Student();
if (StudentID.HasValue)
{
student = db.Students.Find(StudentID);
}
return(student);
}
public void Delete(int?ClassRoomID)
{
NetMvcDb db = new NetMvcDb();
ClassRoom classroom = new ClassRoom();
if (ClassRoomID.HasValue)
{
classroom = db.ClassRooms.Find(ClassRoomID);
db.ClassRooms.Remove(classroom);
}
db.SaveChanges();
}
public void Delete(int?DepartmentID)
{
NetMvcDb db = new NetMvcDb();
Department department = new Department();
if (DepartmentID.HasValue)
{
department = db.Departments.Find(DepartmentID);
db.Departments.Remove(department);
}
db.SaveChanges();
}
public void Delete(int?StudentID)
{
NetMvcDb db = new NetMvcDb();
Student student = new Student();
if (StudentID.HasValue)
{
student = db.Students.Find(StudentID);
db.Students.Remove(student);
}
db.SaveChanges();
}
/// <summary>
/// danh sach khoa
/// </summary>
/// <returns></returns>
public IPagedList <Department> GetDepartments(int?DepartmentID, string DepartmentName, int PageCurrent, int PageSize)
{
NetMvcDb db = new NetMvcDb();
var list = db.Departments.Where(m => m.IsDelete == false).AsQueryable();
if (DepartmentID.HasValue)
{
list = list.Where(m => m.DepartmentID == DepartmentID);
}
if (!string.IsNullOrEmpty(DepartmentName))
{
list = list.Where(m => m.DepartmentName.Contains(DepartmentName)).AsQueryable();
}
return(list.OrderByDescending(m => m.DepartmentID).ToPagedList(PageCurrent, PageSize));
}