public void Delete(GroupInfo group) { string strSql = "DELETE FROM " + Config.ForumTablePrefix + "GROUPS WHERE GROUP_ID=@GroupId; DELETE FROM FORUM_GROUP_NAMES WHERE GROUP_ID=@GroupId;"; List<SqlParameter> parms = new List<SqlParameter> { new SqlParameter("@GroupId", SqlDbType.Int) {Value = @group.Id} }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, parms.ToArray()); }
public int Add(GroupInfo group) { string strSql = "INSERT INTO " + Config.ForumTablePrefix + "GROUP_NAMES (GROUP_NAME,GROUP_DESCRIPTION,GROUP_ICON,GROUP_IMAGE) VALUES (@Name,@Description,@Icon,@Image); SELECT SCOPE_IDENTITY();"; List<SqlParameter> parms = new List<SqlParameter>(); parms.Add(new SqlParameter("@Name",SqlDbType.NVarChar){Value = group.Name}); parms.Add(new SqlParameter("@Description", SqlDbType.NVarChar) { Value = group.Name }); parms.Add(new SqlParameter("@Icon", SqlDbType.NVarChar) { Value = group.Icon.ConvertDBNull(), IsNullable = true }); parms.Add(new SqlParameter("@Image", SqlDbType.NVarChar) { Value = group.Name.ConvertDBNull(), IsNullable = true }); return Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql, parms.ToArray())); }
public static void UpdateGroup(GroupInfo group) { IGroup dal = Factory<IGroup>.Create("Group"); dal.Update(group); }
public static int AddGroup(GroupInfo group) { IGroup dal = Factory<IGroup>.Create("Group"); return dal.Add(group); }
public GroupInfo GetById(int id) { string strSql = "SELECT GROUP_NAME,GROUP_DESCRIPTION,GROUP_ICON,GROUP_IMAGE FROM " + Config.ForumTablePrefix + "GROUP_NAMES WHERE GROUP_ID=@Group"; GroupInfo group = null; SqlParameter parm = new SqlParameter("@Group", SqlDbType.Int) { Value = id }; using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, strSql, parm)) { while (rdr.Read()) { group = new GroupInfo { Id=rdr.GetInt32(0), Name = rdr.GetString(1), Description = rdr.SafeGetString(2), Icon = rdr.SafeGetString(3), Image = rdr.SafeGetString(4) }; } } return group; }
public void Update(GroupInfo group) { string strSql = "UPDATE " + Config.ForumTablePrefix + "GROUP_NAMES SET GROUP_NAME=@Name,GROUP_DESCRIPTION=@Description,GROUP_ICON=@Icon,GROUP_IMAGE=@Image) WHERE GROUP_ID=@GroupId"; List<SqlParameter> parms = new List<SqlParameter> { new SqlParameter("@GroupId", SqlDbType.Int) {Value = @group.Id}, new SqlParameter("@Name", SqlDbType.NVarChar) {Value = @group.Name}, new SqlParameter("@Description", SqlDbType.NVarChar) {Value = @group.Name}, new SqlParameter("@Icon", SqlDbType.NVarChar) {Value = @group.Icon.ConvertDBNull(), IsNullable = true}, new SqlParameter("@Image", SqlDbType.NVarChar) {Value = @group.Name.ConvertDBNull(), IsNullable = true} }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, parms.ToArray()); }