private QuestSectionEntity CreateEntity(DataRow row) { QuestSectionEntity entity = new QuestSectionEntity(); entity.Id = DaoSupport.GetIntValue(row, "id"); entity.ChapterNo = DaoSupport.GetIntValue(row, "chapter_no"); entity.SectionNo = DaoSupport.GetIntValue(row, "section_no"); entity.DisplayName = DaoSupport.GetStringValue(row, "display_name"); return(entity); }
public void Update(QuestSectionEntity entity, SqliteDatabase mdb = null) { StringBuilder sb = new StringBuilder(); sb.Append("UPDATE quest_section SET ") .Append("id = ") .Append(entity.Id) .Append(",") .Append("chapter_no = ") .Append(entity.ChapterNo) .Append(",") .Append("section_no = ") .Append(entity.SectionNo) .Append(",") .Append("display_name = ") .Append("'") .Append(entity.DisplayName) .Append("'") .Append(" WHERE id = ") .Append(entity.Id) .Append(";"); if (mdb == null) { DbManager.Instance.ExecuteNonQuery(sb.ToString()); } else { DbManager.Instance.ExecuteNonQuery(sb.ToString(), mdb); } }
public void Insert(QuestSectionEntity entity, SqliteDatabase mdb = null) { StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO quest_section VALUES (") .Append(entity.Id) .Append(",") .Append(entity.ChapterNo) .Append(",") .Append(entity.SectionNo) .Append(",") .Append("'") .Append(entity.DisplayName) .Append("'") .Append(");"); if (mdb == null) { DbManager.Instance.ExecuteNonQuery(sb.ToString()); } else { DbManager.Instance.ExecuteNonQuery(sb.ToString(), mdb); } }