///end-add student-class //begin add studentinfo&&student-class public int Addstudentandclass(List <class_student> c_studl, List <StudInfo1> studentl) { Exercise_ERContainer cn = new Exercise_ERContainer(); System.Data.Entity.DbContextTransaction tr = cn.Database.BeginTransaction(); try { foreach (StudInfo1 student in studentl) { if (cn.StudInfo1Set.Find(student.studentid) == null) { cn.StudInfo1Set.Add(student); } } foreach (class_student c_stud in c_studl) { cn.class_student.Add(c_stud); } cn.SaveChanges(); tr.Commit(); return(1); } //catch (DbEntityValidationException ex) catch (Exception ex) { Console.WriteLine(ex.Message); tr.Rollback(); return(0); } }
///////////////////endstuinfo //////////////begin add student-class public int Addstudenttoclass(class_student c_stud) { try { Exercise_ERContainer cn = new Exercise_ERContainer(); cn.class_student.Add(c_stud); cn.SaveChanges(); return(1); } //catch (DbEntityValidationException ex) catch (Exception ex) { Console.WriteLine(ex.Message); return(0); } }
//end add studentinfo&&student-class /////////////////////search class student by id public List <Studenttemp> searchstubyclassid(int classid) { List <Studenttemp> lstu = new List <Studenttemp>(); Exercise_ERContainer cn = new Exercise_ERContainer(); var query = from st in cn.StudInfo1Set join cs in cn.class_student on st.studentid equals cs.studentid where cs.classid == classid select new { sid = st.studentid, sname = st.name, sno = cs.classno }; foreach (var result in query) { Studenttemp st2 = new Studenttemp(); st2.studentid = result.sid; st2.name = result.sname; st2.no = (int)result.sno; lstu.Add(st2); } return(lstu); }
public int Addstudent(StudInfo1 student) { try { Exercise_ERContainer cn = new Exercise_ERContainer(); if (cn.StudInfo1Set.Find(student.studentid) == null) { cn.StudInfo1Set.Add(student); } cn.SaveChanges(); return(1); } //catch (DbEntityValidationException ex) catch (Exception ex) { Console.WriteLine(ex.Message); return(0); } }
//end add studentinfo&&student-class /////////////////////search class student by id public List <Studenttemp> searchstubyclassid(int classid) { List <Studenttemp> lstu = new List <Studenttemp>(); Exercise_ERContainer cn = new Exercise_ERContainer(); classinfo tempc = cn.classinfo.Find(classid); int ccid = (int)tempc.courseid; var query = from st in cn.StudInfo1Set join cs in cn.class_student on st.studentid equals cs.studentid where cs.classid == classid orderby cs.classno select new { sid = st.studentid, sname = st.name, sno = cs.classno, sclassid = cs.classid, spd = st.pd }; foreach (var result in query) { Studenttemp st2 = new Studenttemp(); st2.studentid = result.sid; st2.name = result.sname; st2.no = (int)result.sno; st2.pd = result.spd; st2.classid = result.sclassid; st2.courseid = ccid; lstu.Add(st2); } return(lstu); }