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));
}
