/// <summary> /// Method to get one recoder by primary key /// </summary> public MDLCBlogCategory GetModel(int BlogCategoryId) { //Set up a return value MDLCBlogCategory model = null; StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT [BlogCategoryId], [BlogCategoryName], [Sequence] "); strSql.Append(" FROM [CBlogCategory] "); strSql.Append(" WHERE [BlogCategoryId]=" + BlogCategoryId.ToString()); using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString())) { if (sdr.Read()) model = new MDLCBlogCategory(sdr.GetInt32(0), sdr.GetString(1), sdr.GetInt32(2)); else model = new MDLCBlogCategory(); } return model; }
/// <summary> /// Method to get recoders with condition /// </summary> public IList<MDLCBlogCategory> GetList() { IList<MDLCBlogCategory> list = new List<MDLCBlogCategory>(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT [BlogCategoryId], [BlogCategoryName], [Sequence] "); strSql.Append(" FROM [CBlogCategory] "); using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (sdr.Read()) { MDLCBlogCategory item = new MDLCBlogCategory(sdr.GetInt32(0), sdr.GetString(1), sdr.GetInt32(2)); list.Add(item); } } return list; }
/// <summary> /// Add one record /// </summary> public int Add(MDLCBlogCategory model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO [CBlogCategory]("); strSql.Append("[BlogCategoryName],[Sequence]"); strSql.Append(")"); strSql.Append(" VALUES ("); strSql.Append("'" + model.BlogCategoryName + "',"); strSql.Append("" + model.Sequence + ""); strSql.Append(")"); strSql.Append(";SELECT @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return 1; } else { return Convert.ToInt32(obj); } }
/// <summary> /// Update one record /// </summary> public void Update(MDLCBlogCategory model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE [CBlogCategory] SET "); strSql.Append("[BlogCategoryName]='" + model.BlogCategoryName + "',"); strSql.Append("[Sequence]=" + model.Sequence + ""); strSql.Append(" WHERE [BlogCategoryId]=" + model.BlogCategoryId + ""); DbHelperSQL.ExecuteSql(strSql.ToString()); }
/// <summary> /// Update one record /// </summary> public void Update(MDLCBlogCategory model) { dal.Update(model); }
/// <summary> /// Add one record /// </summary> public int Add(MDLCBlogCategory model) { return dal.Add(model); }