public ActionResult Edit(ExpertsDetailtObjects ob, FormCollection collection, int IsOption = 0) { //try //{ // TODO: Add update logic here //var oke = new ExpertsDetailtBCL().GetJoin().Count(q => q.ExpertId == ob.ExpertId && q.CoId == ob.CoId) == 1; //if (oke) //{ if (new ExpertsDetailtBCL().Update(ob)) { if (IsOption == 0) { return(RedirectToAction("Index")); } else { return(RedirectToAction("Edit", "Courses", new { ID = ob.CoId })); } } // } // else // { // ModelState.AddModelError("", "Không thêm giáo viên dạy một lớp quá hai lần!"); // } //} //catch //{ //} return(View()); }
public bool Insert(ExpertsDetailtObjects ob) { var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_ExpertsDetailt_INSERT(ob.ExId, ob.ExpertId, ob.CoId, ob.Description); return(true); }
public ActionResult Create(ExpertsDetailtObjects ob, int IsOption = 0) { try { // TODO: Add insert logic here var oke = !new ExpertsDetailtBCL().GetJoin().Any(q => q.ExpertId == ob.ExpertId && q.CoId == ob.CoId); if (oke) { ob.ExId = Guid.NewGuid(); if (new ExpertsDetailtBCL().Insert(ob)) { if (IsOption == 0) { return(RedirectToAction("Index")); } else { return(RedirectToAction("Index", "Courses")); } } else { ModelState.AddModelError("", "Tạo mới thất bại"); } } else { ModelState.AddModelError("", "Giáo viên này đang dạy lớp hiện tại"); } } catch { } return(View(ob)); }
public ExpertsDetailtObjects GetByExId(Guid ExId) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_ExpertsDetailt_GetByExId(ExId); foreach (var item in list) { ExpertsDetailtObjects obj = new ExpertsDetailtObjects(); obj.ExId = item.ExId; obj.ExpertId = item.ExpertId; obj.CoId = item.CoId; obj.Description = item.Description; return(obj); } return(null); }
public List <ExpertsDetailtObjects> GetAll() { List <ExpertsDetailtObjects> lst = new List <ExpertsDetailtObjects>(); var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_ExpertsDetailt_GetAll(); foreach (var item in list) { ExpertsDetailtObjects ob = new ExpertsDetailtObjects(); ob.ExId = item.ExId; ob.ExpertId = item.ExpertId; ob.CoId = item.CoId; ob.Description = item.Description; lst.Add(ob); } return(lst); }
public JsonResult AddExpertINClass(Guid ExpertID, Guid ClassID) { var oke = !new ExpertsDetailtBCL().GetJoin().Any(q => q.ExpertId == ExpertID && q.CoId == ClassID); if (oke) { ExpertsDetailtObjects obj = new ExpertsDetailtObjects(); obj.ExId = Guid.NewGuid(); obj.ExpertId = ExpertID; obj.CoId = ClassID; new ExpertsDetailtBCL().Insert(obj); return(Json(new { result = true, message = "Thêm thành công!" })); } return(Json(new { result = false, message = "Đã Tồn Tại Rồi!" })); }
public List <ExpertsDetailtObjects> GetByCoId(Guid CoId) { List <ExpertsDetailtObjects> lst = new List <ExpertsDetailtObjects>(); var db = new eTrainingScheduleEntities(); var list = db.WEB_QLGD01_sp_ExpertsDetailt_GetByCoId(CoId); foreach (var item in list) { ExpertsDetailtObjects ob = new ExpertsDetailtObjects(); ob.ExId = item.ExId; ob.ExpertId = item.ExpertId; ob.CoId = item.CoId; ob.Description = item.DescriptionExpertsDetailt; 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.StartDateCourses, Status = item.StatusCourses == true, TotalNumber = item.TotalNumber }; ob.ExpertsJoin = new ExpertsObjects() { Address = item.Address, Deleted = item.DeletedExperts, Description = item.DescriptionExperts, Email = item.Email, ExpertId = (Guid)item.ExpertId, FullName = item.FullName, Mobile = item.Mobile, Specialize = item.Specialize, StartDate = item.StartDateExperts, Status = item.StatusExperts == true, }; lst.Add(ob); } return(lst); }
public bool Insert(ExpertsDetailtObjects ob) { return(new ExpertsDetailtDao().Insert(ob)); }
public bool Update(ExpertsDetailtObjects ob) { return(new ExpertsDetailtDao().Update(ob)); }