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