public void DeleteTakeClassList()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
List <ClassWeb.Repository.Entity.TakeClass> takeClassList = DBEntity.TakeClass.Where(o => o.TakeClass_Student == StudentNo).ToList();
DBEntity.TakeClass.RemoveRange(takeClassList);
DBEntity.SaveChanges();
}
}
//取得查詢資料
public void GetSearchList()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
classList = DBEntity.Class.Where(o => !string.IsNullOrEmpty(No) ? o.Class_No == No : true &&
!string.IsNullOrEmpty(Name) ? o.Class_Name.Contains(Name) : true &&
!string.IsNullOrEmpty(Credit.ToString()) && Credit != 0 ? o.Class_Credit == Credit : true &&
!string.IsNullOrEmpty(Place) ? o.Class_Place.Contains(Place) : true &&
!string.IsNullOrEmpty(Teacher)? o.Class_Teacher.Contains(Teacher) : true).ToList();
}
}
public void UpdateStudent()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Student student = DBEntity.Student.Where(o => o.Student_No == No).FirstOrDefault();
student.Student_Name = Name;
student.Student_Birthday = Convert.ToDateTime(Birthday);
student.Student_Email = Email;
DBEntity.SaveChanges();
}
}
//新增資料
public void InsertStudent()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Student student = new Repository.Entity.Student();
student.Student_No = GetNewStudentNo();
student.Student_Name = Name;
student.Student_Birthday = Convert.ToDateTime(Birthday);
student.Student_Email = Email;
DBEntity.Student.Add(student);
DBEntity.SaveChanges();
}
}
public void UpdateClass()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Class classData = DBEntity.Class.Where(o => o.Class_No == No).FirstOrDefault();
classData.Class_Name = Name;
classData.Class_Credit = Credit;
classData.Class_Place = Place;
classData.Class_Teacher = Teacher;
DBEntity.SaveChanges();
}
}
//新增資料
public void InsertClass()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Class classData = new Repository.Entity.Class();
classData.Class_No = GetNewClassNo();
classData.Class_Name = Name;
classData.Class_Credit = Credit;
classData.Class_Place = Place;
classData.Class_Teacher = Teacher;
DBEntity.Class.Add(classData);
DBEntity.SaveChanges();
}
}
public string GetNewClassNo()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Class lastData = DBEntity.Class.OrderByDescending(o => o.Class_No).FirstOrDefault();
if (lastData != null)
{
return(string.Concat("C", string.Format("{0:000}", (Convert.ToInt32(lastData.Class_No.Substring(1, 3)) + 1))));
}
else
{
return("C001");
}
}
}
public void DeleteClass()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Class classData = DBEntity.Class.Where(o => o.Class_No == No).FirstOrDefault();
DBEntity.Class.Remove(classData);
//一併刪除該學生修課紀錄避免資料關聯異常
List <ClassWeb.Repository.Entity.TakeClass> takeClass = DBEntity.TakeClass.Where(o => o.TakeClass_Class == No).ToList();
DBEntity.TakeClass.RemoveRange(takeClass);
DBEntity.SaveChanges();
}
}
public void GetSearchList()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
string birthday = "";
if (!string.IsNullOrEmpty(Birthday.ToString("yyyy-MM-dd")) && Birthday.ToString("yyyy-MM-dd") != "0001-01-01")
{
birthday = Birthday.ToString("yyyy-MM-dd");
}
studentList = DBEntity.Student.Where(o => !string.IsNullOrEmpty(No) ? o.Student_No == No : true &&
!string.IsNullOrEmpty(Name) ? o.Student_Name.Contains(Name) : true &&
!string.IsNullOrEmpty(birthday) ? o.Student_Birthday == Birthday : true &&
!string.IsNullOrEmpty(Email) ? o.Student_Email == Email : true).ToList();
}
}
//將修課資料塞入顯示清單
public void GetTakeClassList()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
dataItemList = DBEntity.TakeClass.Join(DBEntity.Class, t => t.TakeClass_Class, c => c.Class_No, (t, c) => new
{
StudenNo = t.TakeClass_Student,
ClassNo = t.TakeClass_Class,
ClassName = c.Class_Name
}).GroupBy(o => o.StudenNo)
.Select(o => new DataItem {
Student = o.Key, Class = o.Select(g => g.ClassName).ToList()
}).ToList();
}
}
public void DeleteStudent()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Student student = DBEntity.Student.Where(o => o.Student_No == No).FirstOrDefault();
DBEntity.Student.Remove(student);
//一併刪除該學生修課紀錄避免資料關聯異常
List <ClassWeb.Repository.Entity.TakeClass> takeClass = DBEntity.TakeClass.Where(o => o.TakeClass_Student == No).ToList();
DBEntity.TakeClass.RemoveRange(takeClass);
DBEntity.SaveChanges();
}
}
//取得學生資料 並塞入下拉清單
public void GetStudentList()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
List <ClassWeb.Repository.Entity.Student> studnetList = DBEntity.Student.ToList();
StudentSelectList.Add(new SelectListItem {
Value = string.Empty, Text = string.Empty
});
foreach (ClassWeb.Repository.Entity.Student student in studnetList)
{
StudentSelectList.Add(new SelectListItem()
{
Value = student.Student_No, Text = string.Concat(student.Student_No, " ", student.Student_Name)
});
}
}
}
//取得詳細資料
public bool GetDetail()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Student student = DBEntity.Student.Where(o => o.Student_No == No).FirstOrDefault();
if (student != null)
{
Name = student.Student_Name;
Birthday = student.Student_Birthday;//.ToString("yyyy-MM-dd");
Email = student.Student_Email;
}
else
{
ErrMsg = string.Format("學號:{0} 查無學生資料, 請檢查", No);
return(false);
}
return(true);
}
}
public void AddTakeClassList()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
List <ClassWeb.Repository.Entity.TakeClass> takeClassList = DBEntity.TakeClass.Where(o => o.TakeClass_Student == StudentNo).ToList();
DBEntity.TakeClass.RemoveRange(takeClassList);
foreach (var ClassIsChk in ClassNoList.Where(o => o.IsCheck))
{
ClassWeb.Repository.Entity.TakeClass takeClass = new ClassWeb.Repository.Entity.TakeClass();
takeClass.TakeClass_Student = StudentNo;
takeClass.TakeClass_Class = ClassIsChk.ClassNo;
DBEntity.TakeClass.Add(takeClass);
}
DBEntity.SaveChanges();
StudentNo = string.Empty;
ClassNoList = new List <ClassItem>();
}
}
//取得詳細資料
public bool GetDetail()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Class classData = DBEntity.Class.Where(o => o.Class_No == No).FirstOrDefault();
if (classData != null)
{
Name = classData.Class_Name;
Credit = classData.Class_Credit;
Place = classData.Class_Place;
Teacher = classData.Class_Teacher;
}
else
{
ErrMsg = string.Format("課程:{0} 查無課程資料, 請檢查", No);
return(false);
}
return(true);
}
}
//取得課程選取清單
public void GetClassList()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
List <ClassWeb.Repository.Entity.TakeClass> takeClassList = new List <Repository.Entity.TakeClass>();
//當為修改時,將資料帶出
if (ActionMode == "Update")
{
takeClassList = DBEntity.TakeClass.Where(o => o.TakeClass_Student == StudentNo).ToList();
}
ClassNoList = new List <ClassItem>();
foreach (ClassWeb.Repository.Entity.Class classData in DBEntity.Class.ToList())
{
ClassNoList.Add(new ClassItem()
{
ClassNo = classData.Class_No,
ClassName = classData.Class_Name,
IsCheck = takeClassList.Count > 0? takeClassList.Exists(o => o.TakeClass_Class == classData.Class_No) : false
});
}
}
}
