public bool Insert(StudentDetailtObjects ob) { var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_StudentDetailt_INSERT(ob.StdId, ob.StudetId, ob.CoId, ob.Description); return(true); }
public List <StudentDetailtObjects> GetCourseByStudentID(Guid StudentId) //Hiếu { List <StudentDetailtObjects> lst = new List <StudentDetailtObjects>(); var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_StudentDetailt_GetCoursebyStudentID(StudentId); foreach (var item in list) { StudentDetailtObjects ob = new StudentDetailtObjects(); ob.StdId = item.StdId; ob.StudetId = item.StudetId; ob.CoId = item.CoId; ob.Description = item.Description; ob.StatusSC = (bool)item.StatusSC; ob.StudentJoin = new StudentObjects(); ob.StudentJoin.FullName = item.FullName; ob.CoursesJoin = new CoursesObjects(); ob.CoursesJoin.EndDate = item.EndDate; ob.CoursesJoin.StartDate = item.StartDate; ob.CoursesJoin.CourseId = item.CourseId; ob.CoursesJoin.CourseName = item.CourseName; lst.Add(ob); } return(lst); }
public bool Update(StudentDetailtObjects ob) { var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_StudentDetailt_UPDATE(ob.StdId, ob.StudetId, ob.CoId, ob.Description, ob.StatusSC); return(true); }
public ActionResult Create(Guid?coursesId) { List <StudentObjects> LisStudent = new StudentBCL().GetAllNOTCLASS(); /*FeaIdObject objFeat = LisFeat.Single(x => x.FeaId.Equals(0)); * LisFeat.Remove(objFeat);*/ ViewBag.ALl = new CoursesBCL().GetAll(); if (coursesId != null) { var name = new CoursesBCL().GetByCoId((Guid)coursesId); ViewBag.Name = name; } ViewBag.ListStudent = LisStudent; ViewBag.coursesId = coursesId; List <CoursesObjects> lisCourses = new CoursesBCL().GetAll(); /* AccountObject objAccount = lisFeat.Single(x => x.FeaId.Equals(0)); * lisFeat.Remove(objFeat);*/ ViewBag.ListCourses = lisCourses; StudentDetailtObjects ob = new StudentDetailtObjects() { CoId = coursesId }; return(View(ob)); }
public ActionResult Create(StudentDetailtObjects obj, int IsOption = 0) { var oke = !new StudentDetailtBCL().GetJoin().Any(q => q.CoId == obj.CoId && q.StudetId == obj.StudetId); if (oke) { obj.StdId = Guid.NewGuid(); if (new StudentDetailtBCL().Insert(obj)) { if (IsOption == 0) { return(RedirectToAction("Index", "StudentDetail")); } else { return(RedirectToAction("Index", "Courses")); } } else { ModelState.AddModelError("", "Thêm học viên thất bại!"); } } else { List <StudentObjects> LisStudent = new StudentBCL().GetAll(); ViewBag.ListStudent = LisStudent; ModelState.AddModelError("", "Học viên này đã học ở lớp này!"); } return(View()); }
public JsonResult AddStudentinClass(string StudentID, string ClassID) { StudentDetailtObjects obj = new StudentDetailtObjects(); obj.StdId = Guid.NewGuid(); obj.StudetId = Guid.Parse(StudentID); obj.CoId = Guid.Parse(ClassID); new StudentDetailtBCL().Insert(obj); return(Json(new { result = true, message = "Thêm thành công!" })); }
public StudentDetailtObjects GetByStdId(StudentDetailtObjects ob) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_StudentDetailt_GetByStdId(ob.StdId); foreach (var item in list) { StudentDetailtObjects obj = new StudentDetailtObjects(); obj.StdId = item.StdId; obj.StudetId = item.StudetId; obj.CoId = item.CoId; obj.Description = item.Description; return(obj); } return(null); }
public List <StudentDetailtObjects> GetAll() { var lit = new eTrainingScheduleEntities().sp_tbl_S07_StudentDetailt_GetAll(); List <StudentDetailtObjects> lst = new List <StudentDetailtObjects>(); foreach (var item in lit) { StudentDetailtObjects obj = new StudentDetailtObjects(); obj.StdId = item.StdId; obj.CoId = item.CoId; obj.Description = item.Description; obj.StudetId = item.StudetId; lst.Add(obj); } return(lst); }
public List <StudentDetailtObjects> GetJoin() { List <StudentDetailtObjects> lst = new List <StudentDetailtObjects>(); var db = new eTrainingScheduleEntities(); var list = db.sp_StudentDetailt_Join(); foreach (var item in list) { if (item.DeletedStudent == true || item.DeletedCourses == true) { continue; } StudentDetailtObjects ob = new StudentDetailtObjects(); ob.StdId = item.StdId; ob.StudetId = item.StudetId; ob.CoId = item.CoId; ob.Description = item.DescriptionStudent; ob.CoursesJoin = new CoursesObjects() { CoId = (Guid)item.CoId, CourseId = item.CourseId, CourseName = item.CourseName, Deleted = item.DeletedCourses, Description = item.DescriptionCourses, EndDate = item.EndDate, StartDate = item.StartDate, Status = item.StatusCourses, TotalNumber = item.TotalNumber }; ob.StudentJoin = new StudentObjects() { Address = item.Address, Deleted = item.DeletedStudent, Email = item.Email, FullName = item.FullName, Mobile = item.Mobile, Status = item.StatusStudent, StudetId = (Guid)item.StudetId }; lst.Add(ob); } return(lst); }
public ActionResult Edit(StudentDetailtObjects obj, int IsOption = 0) { if (new StudentDetailtBCL().Update(obj)) { if (IsOption == 0) { return(RedirectToAction("Index", "StudentDetail")); } else if (IsOption == 2) { return(RedirectToAction("ChiTietByHieu", "StudentDetail", new { ID = obj.StudetId })); } else { return(RedirectToAction("Edit", "Courses", new { ID = obj.CoId })); } } return(View()); }
public List <StudentDetailtObjects> GetJoin() { List <StudentDetailtObjects> lst = new List <StudentDetailtObjects>(); var db = new eTrainingScheduleEntities(); var list = db.sp_StudentDetailt_Join(); foreach (var item in list) { StudentDetailtObjects ob = new StudentDetailtObjects(); ob.StdId = item.StdId; ob.StudetId = item.StudetId; ob.CoId = item.CoId; ob.Description = item.DescriptionStudent; ob.StatusSC = (bool)item.StatusSC; ob.CoursesJoin = new CoursesObjects() { CoId = (Guid)item.CoId, CourseId = item.CourseId, CourseName = item.CourseName, Deleted = item.DeletedCourses, Description = item.DescriptionCourses, EndDate = item.EndDate, StartDate = item.StartDate, Status = item.StatusCourses == true, TotalNumber = item.TotalNumber }; ob.StudentJoin = new StudentObjects() { Address = item.Address, Deleted = item.DeletedStudent, Email = new SecurityConexts().DecryptInfo(item.Email), Mobile = new SecurityConexts().DecryptInfo(item.Mobile), FullName = item.FullName, Status = item.StatusStudent.Value, StudetId = (Guid)item.StudetId }; lst.Add(ob); } return(lst); }
public StudentDetailtObjects GetByStdId(Guid?ob) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_StudentDetailt_GetByStdId(ob); foreach (var item in list) { StudentDetailtObjects obj = new StudentDetailtObjects(); obj.StdId = item.StdId; obj.StudetId = item.StudetId; obj.CoId = item.CoId; obj.Description = item.Description; obj.StatusSC = (bool)item.StatusSC; obj.StudentJoin = new StudentObjects { FullName = item.FullName }; return(obj); } return(null); }
public bool Insert(StudentDetailtObjects ob) { return(new StudentDetailtDao().Insert(ob)); }
public StudentDetailtObjects GetByStdId(StudentDetailtObjects ob) { return(new StudentDetailtDao().GetByStdId(ob)); }
public bool Update(StudentDetailtObjects ob) { return(new StudentDetailtDao().Update(ob)); }