/// <summary> /// Retrieves Get Total Rows of Chapter /// </summary> /// <returns>Int32 type object</returns> public Int32 GetRowCount() { using (ChapterDataAccess data = new ChapterDataAccess(ClientContext)) { return(data.GetRowCount()); } }
/// <summary> /// Retrieve list of Chapter by query String. /// <param name="query"></param> /// </summary> /// <returns>List of Chapter</returns> public ChapterList GetByQuery(String query) { using (ChapterDataAccess data = new ChapterDataAccess(ClientContext)) { return(data.GetByQuery(query)); } }
/// <summary> /// Retrieve list of Chapter by PageRequest. /// <param name="request"></param> /// </summary> /// <returns>List of Chapter</returns> public ChapterList GetPaged(PagedRequest request) { using (ChapterDataAccess data = new ChapterDataAccess(ClientContext)) { return(data.GetPaged(request)); } }
/// <summary> /// Retrieve list of Chapter. /// no parameters required to be passed in. /// </summary> /// <returns>List of Chapter</returns> public ChapterList GetAll() { using (ChapterDataAccess data = new ChapterDataAccess(ClientContext)) { return(data.GetAll()); } }
/// <summary> /// Retrieve Chapter data using unique ID /// </summary> /// <param name="_Id"></param> /// <returns>Chapter Object</returns> public Chapter Get(Int32 _Id) { using (ChapterDataAccess data = new ChapterDataAccess(ClientContext)) { return(data.Get(_Id)); } }
/// <summary> /// Delete operation for Chapter /// <param name="_Id"></param> /// <returns></returns> private bool Delete(Int32 _Id) { using (ChapterDataAccess data = new ChapterDataAccess(ClientContext)) { // return if code > 0 return(data.Delete(_Id) > 0); } }
public ChapterEntity ChapterEntityConversion() { IChapterDataAccess chapterDataAccess = new ChapterDataAccess(); return(new ChapterEntity { Id = this.Id, Name = this.Name, CourseId = this.CourseId }); }
/// <summary> /// Retrieve list of Chapter. /// </summary> /// <param name="fillChild"></param> /// <returns>List of Chapter</returns> public ChapterList GetAll(bool fillChild) { ChapterList chapterList = new ChapterList(); using (ChapterDataAccess data = new ChapterDataAccess(ClientContext)) { chapterList = data.GetAll(); } if (fillChild) { foreach (Chapter chapterObject in chapterList) { FillChapterWithChilds(chapterObject, fillChild); } } return(chapterList); }
/// <summary> /// Update base of Chapter Object. /// Data manipulation processing for: new, deleted, updated Chapter /// </summary> /// <param name="chapterObject"></param> /// <returns></returns> public bool UpdateBase(Chapter chapterObject) { // use of switch for different types of DML switch (chapterObject.RowState) { // insert new rows case BaseBusinessEntity.RowStateEnum.NewRow: return(Insert(chapterObject)); // delete rows case BaseBusinessEntity.RowStateEnum.DeletedRow: return(Delete(chapterObject.Id)); } // update rows using (ChapterDataAccess data = new ChapterDataAccess(ClientContext)) { return(data.Update(chapterObject) > 0); } }
/// <summary> /// Insert new chapter. /// data manipulation for insertion of Chapter /// </summary> /// <param name="chapterObject"></param> /// <returns></returns> private bool Insert(Chapter chapterObject) { // new chapter using (ChapterDataAccess data = new ChapterDataAccess(ClientContext)) { // insert to chapterObject Int32 _Id = data.Insert(chapterObject); // if successful, process if (_Id > 0) { chapterObject.Id = _Id; return(true); } else { return(false); } } }
public Course CourseConversion() { IChapterDataAccess chapterDataAccess = new ChapterDataAccess(); List <Chapter> chapters = new List <Chapter>(); List <ChapterEntity> chapterEntities = new List <ChapterEntity>(); chapterEntities = chapterDataAccess.FindAllChapterByCourse(this.Id); foreach (var chapterEntity in chapterEntities) { chapters.Add(chapterEntity.ChapterConversion()); } return(new Course { Id = this.Id, Name = this.Name, ChapterList = chapters, UserId = this.UserId }); }