public bool Insert(CoursesJournalObjects ob)
{
var db = new eTrainingScheduleEntities();
var data = db.sp_tbl_S07_CoursesJournal_INSERT(ob.CJId, ob.CoId, ob.DayOf, ob.Contents, ob.Description);
return(true);
}
public List <CoursesJournalObjects> GetJoin()
{
List <CoursesJournalObjects> lst = new List <CoursesJournalObjects>();
var db = new eTrainingScheduleEntities();
var list = db.sp_CoursesJournal_Join();
foreach (var item in list)
{
CoursesJournalObjects ob = new CoursesJournalObjects();
ob.CJId = item.CJId; ob.CoId = item.CoId; ob.DayOf = item.DayOf; ob.Contents = item.Contents; ob.Description = item.DescriptionCoursesJournal;
ob.CoursesJoin = new CoursesObjects()
{
CoId = (Guid)item.CoId,
CourseId = item.CourseId,
CourseName = item.CourseName,
Deleted = item.Deleted,
Description = item.DescriptionCourses,
EndDate = item.EndDate,
StartDate = item.StartDate,
Status = item.Status,
TotalNumber = item.TotalNumber
};
lst.Add(ob);
}
return(lst);
}
public CoursesJournalObjects GetByCJId(Guid ob)
{
var db = new eTrainingScheduleEntities();
var list = db.sp_tbl_S07_CoursesJournal_GetByCJId(ob);
foreach (var item in list)
{
CoursesJournalObjects obj = new CoursesJournalObjects();
obj.CJId = item.CJId; obj.CoId = item.CoId; obj.DayOf = item.DayOf; obj.Contents = item.Contents; obj.Description = item.Description;
return(obj);
}
return(null);
}
public List <CoursesJournalObjects> GetAll()
{
List <CoursesJournalObjects> lst = new List <CoursesJournalObjects>();
var db = new eTrainingScheduleEntities().sp_tbl_S07_CoursesJournal_GetAll();
foreach (var item in db)
{
CoursesJournalObjects ob = new CoursesJournalObjects();
ob.CJId = item.CJId;
ob.Contents = item.Contents;
ob.DayOf = item.DayOf;
ob.Description = item.Description;
ob.CoId = item.CoId;
lst.Add(ob);
}
return(lst);
}
public ActionResult Edit(CoursesJournalObjects model, int IsOption)
{
var b = new CoursesJournalBCL().Update(model);
if (b)
{
if (IsOption == 1)
{
return(RedirectToAction("Edit", "Courses", new { Id = model.CoId }));
}
else
{
return(RedirectToAction("Index", "CoursesJournal", new { }));
}
}
else
{
ModelState.AddModelError("", "them moi that bai");
}
return(View());
}
public ActionResult Create(CoursesJournalObjects objCJ, int IsOption = 0)
{
var b = new CoursesJournalBCL().Insert(objCJ);
if (b)
{
if (IsOption == 0)
{
return(RedirectToAction("Index", "CoursesJournal"));
}
else
{
return(RedirectToAction("Edit", "Courses", new { Id = objCJ.CoId }));
}
}
else
{
ModelState.AddModelError("", "them moi that bai");
}
return(View());
}
// GET: CoursesJournal/Create
public ActionResult Create(Guid?Coursesid = null)
{
if (Coursesid.HasValue)
{
var nk = new CoursesJournalBCL().GetAll().FirstOrDefault(q => q.CoId.Value == Coursesid.Value && q.DayOf.Value.ToShortDateString().Equals(DateTime.Now.ToShortDateString()));
if (nk != null)
{
return(RedirectToAction("Edit", new { Id = nk.CJId }));
}
}
ViewBag.Coursesid = Coursesid;
if (Coursesid == null)
{
Coursesid = (Guid) new CoursesBCL().GetAll().Select(x => x.CoId).FirstOrDefault();
}
ViewBag.LisStudent = new StudentDetailtBCL().GetJoin().Where(x => x.CoId.Equals(Coursesid)).ToList();
CoursesJournalObjects ob = new CoursesJournalObjects()
{
CJId = Guid.NewGuid()
};
return(View(ob));
}
public bool Insert(CoursesJournalObjects ob)
{
return(new CoursesJournalDao().Insert(ob));
}
public bool Update(CoursesJournalObjects ob)
{
return(new CoursesJournalDao().Update(ob));
}
