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