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