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