/// <summary> /// Fills Chapter object /// </summary> /// <param name="chapterObject">The object to be filled</param> /// <param name="reader">The reader to use to fill a single object</param> /// <param name="start">The ordinal position from which to start reading the reader</param> protected void FillObject(ChapterBase chapterObject, SqlDataReader reader, int start) { chapterObject.Id = reader.GetInt32(start + 0); if (!reader.IsDBNull(1)) { chapterObject.ChapterNo = reader.GetString(start + 1); } if (!reader.IsDBNull(2)) { chapterObject.Name = reader.GetString(start + 2); } if (!reader.IsDBNull(3)) { chapterObject.Type = reader.GetString(start + 3); } if (!reader.IsDBNull(4)) { chapterObject.Description = reader.GetString(start + 4); } if (!reader.IsDBNull(5)) { chapterObject.PageUrl = reader.GetString(start + 5); } FillBaseObject(chapterObject, reader, (start + 6)); chapterObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow; }
/// <summary> /// Add common parameters before calling a procedure /// </summary> /// <param name="cmd">command object, where parameters will be added</param> /// <param name="chapterObject"></param> private void AddCommonParams(SqlCommand cmd, ChapterBase chapterObject) { AddParameter(cmd, pNVarChar(ChapterBase.Property_ChapterNo, 50, chapterObject.ChapterNo)); AddParameter(cmd, pNVarChar(ChapterBase.Property_Name, 500, chapterObject.Name)); AddParameter(cmd, pNVarChar(ChapterBase.Property_Type, 50, chapterObject.Type)); AddParameter(cmd, pNVarChar(ChapterBase.Property_Description, chapterObject.Description)); }
/// <summary> /// Updates Chapter /// </summary> /// <param name="chapterObject">Object to be updated</param> /// <returns>Number of rows affected</returns> public long Update(ChapterBase chapterObject) { try { SqlCommand cmd = GetSPCommand(UPDATECHAPTER); AddParameter(cmd, pInt32(ChapterBase.Property_Id, chapterObject.Id)); AddCommonParams(cmd, chapterObject); long result = UpdateRecord(cmd); if (result > 0) { chapterObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow; } return(result); } catch (SqlException x) { throw new ObjectUpdateException(chapterObject, x); } }
/// <summary> /// Inserts Chapter /// </summary> /// <param name="chapterObject">Object to be inserted</param> /// <returns>Number of rows affected</returns> public long Insert(ChapterBase chapterObject) { try { SqlCommand cmd = GetSPCommand(INSERTCHAPTER); AddParameter(cmd, pInt32Out(ChapterBase.Property_Id)); AddCommonParams(cmd, chapterObject); long result = InsertRecord(cmd); if (result > 0) { chapterObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow; chapterObject.Id = (Int32)GetOutParameter(cmd, ChapterBase.Property_Id); } return(result); } catch (SqlException x) { throw new ObjectInsertException(chapterObject, x); } }
/// <summary> /// Fills Chapter object /// </summary> /// <param name="chapterObject">The object to be filled</param> /// <param name="reader">The reader to use to fill a single object</param> protected void FillObject(ChapterBase chapterObject, SqlDataReader reader) { FillObject(chapterObject, reader, 0); }
public void AddToListOfInfoAddOnToProcess (InformationenAddOn Entry) { int ChapterIndex = 0; bool InsertedBefore = false; foreach (ChapterBase Base in UsedChapterBase) { if (Base.InformationenAddOnLinkedWithThisChapter.Contains(Entry)) { InsertedBefore = true; break; } ChapterIndex++; } if (InsertedBefore) return; ChapterBase ChapterToProcess = new ChapterBase(ChapterIndex) { ChapterName = Entry.GetChapterText () }; ChapterToProcess.InformationenAddOnLinkedWithThisChapter.Add(Entry); UsedChapterBase.Add(ChapterToProcess); JoinResourcesUsed(); }