public double NextValue()
{
var sqlSelect = String.Empty;
var rs = new Recordset();
try
{
Cn.Open();
sqlSelect = "VALUES NEXTVAL FOR TabelaJogador";
rs = KRecordSet.Open(sqlSelect, Cn);
if (!rs.EOF)
{
return(Convert.ToDouble(rs.Fields[0].Value));
}
return(0);
}
catch (Exception ex)
{
throw new SQLException(Cn.activeConnection.Errors, sqlSelect, ex);
}
finally
{
rs.Close();
Cn.Close();
}
}
public IType BuscarHomePagina(IType iType, int idCliente)
{
Cn = DataBaseGeneric.CreateConnection(BaseType, iType.InstanceConectionString);
Cn.Open();
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_SYS_BuscarHomePagina";
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idCliente";
paran2.Value = idCliente;
Cmd.Parameters.Add(paran2);
OpenConnection(iType);
DbDataReader dr = Cmd.ExecuteReader();
if (dr.Read())
{
return(SetObject(dr, (IType)Activator.CreateInstance(iType.GetType())));
}
return(null);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
protected void btnChangePsw_Click(object sender, System.EventArgs e)
{
if (tbNewPsw1.Text == "" || tbNewPsw2.Text == "" || tbNewPsw1.Text != tbNewPsw2.Text)
{
lblResult.Text = Resources.various.ErrorPasswordsDoNotMatch;
return;
}
if (tbNewPsw1.Text.Length < Utils.Settings.MinPasswordLength)
{
lblResult.Text = string.Format("Password is too short, {0} characters minimum", Utils.Settings.MinPasswordLength);
return;
}
Cn.Open();
var res = Cn.ExecuteScalar("SELECT UserID FROM ForumUsers WHERE (Password=?) AND UserID=?",
Utils.Password.CalculateHash(tbOldPsw.Text), _editedUserID);
if (IsAdministrator || res != null)
{
Cn.ExecuteNonQuery("UPDATE ForumUsers SET [Password]=? WHERE UserID=?", Utils.Password.CalculateHash(tbNewPsw1.Text), _editedUserID);
lblResult.Text = Resources.various.PasswordChanged;
}
else
{
lblResult.Text = Resources.various.ErrorWrongOldPassword;
}
Cn.Close();
}
public IType BuscarHomePaginaRestrito(IType iType, int idUsuario, int idCampanha)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_SYS_BUSCA_HIERARQUIA_POR_CREDENCIAL";
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@idcredencial";
paran.Value = idUsuario;
Cmd.Parameters.Add(paran);
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idcampanha";
paran1.Value = idCampanha;
Cmd.Parameters.Add(paran1);
OpenConnection(iType);
DbDataReader dr = Cmd.ExecuteReader();
if (dr.Read())
{
return(SetObject(dr, (IType)Activator.CreateInstance(iType.GetType())));
}
return(null);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public void DeletePai(IType iType, int idPessoa, int idPessoaPai)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_DeleteEstruturaPessoaPai";
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idPessoaPai";
paran1.Value = idPessoaPai;
Cmd.Parameters.Add(paran1);
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idPessoa";
paran2.Value = idPessoa;
Cmd.Parameters.Add(paran2);
OpenConnectionTrans(iType);
Cmd.ExecuteNonQuery();
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
private void BindMemberGroups()
{
var groups = Utils.User.GetGroupIdsForUser(_editedUserID);
Cn.Open();
if (groups.Any())
{
var drMember = Cn.ExecuteReader(
@"SELECT ForumUserGroups.GroupID, ForumUserGroups.Title
FROM ForumUserGroups
WHERE GroupID IN (" + groups.Select(x => x.ToString()).Aggregate((x, y) => x + "," + y) + @")
ORDER BY Title" );
rptMember.DataSource = drMember;
rptMember.DataBind();
drMember.Close();
}
var drNotmember = Cn.ExecuteReader(
@"SELECT ForumUserGroups.GroupID, ForumUserGroups.Title
FROM ForumUserGroups " +
(groups.Any() ? @"WHERE GroupID NOT IN (" + groups.Select(x => x.ToString()).Aggregate((x, y) => x + "," + y) + ") " : "") +
"ORDER BY Title");
rptNotMember.DataSource = drNotmember;
rptNotMember.DataBind();
Cn.Close();
}
public bool EFilhoDaPessoaCargo(IType iType, int idPessoaPai, int idPessoa)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "Sp_PessoaEFilhoDaPessoaCargo";
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idPessoaPai";
paran1.Value = idPessoaPai;
Cmd.Parameters.Add(paran1);
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idPessoa";
paran2.Value = idPessoa;
Cmd.Parameters.Add(paran2);
SetObjectToGet(iType);
return(iType.Id != null);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string username = Request.QueryString["user"];
string code = Request.QueryString["code"];
if (username == null || code == null)
{
Response.End();
return;
}
Cn.Open();
object res = Cn.ExecuteScalar(
"select UserID from ForumUsers WHERE UserName=? AND ActivationCode=?",
username,
code);
Cn.Close();
if (res != null)
{
Utils.User.EnableUser(Convert.ToInt32(res), false);
lblSuccess.Visible = true;
lblError.Visible = false;
}
else
{
lblError.Visible = true;
lblSuccess.Visible = false;
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
try
{
userID = int.Parse(Request.QueryString["UserID"]);
}
catch
{
Response.Write("Invalid UserID passed");
Response.End();
return;
}
Cn.Open();
DbDataReader dr = this.Cn.ExecuteReader("SELECT UserName, AvatarFileName, FirstName, LastName FROM ForumUsers WHERE UserID=" + userID);
if (dr.Read())
{
lblUser.Text = userName = dr["UserName"].ToString();
avatarFileName = dr["AvatarFileName"].ToString();
firstName = dr["FirstName"].ToString();
lastName = dr["LastName"].ToString();
}
dr.Close();
BindRepeater();
Cn.Close();
Title = "Posts from \"" + userName + "\"";
MetaDescription = Settings.ForumTitle + " - viewing all forum posts from user \"" + userName + "\"";
}
public IType GetPessoaCampanha(IType iType, int IDUsuario, int idCampanha)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "Sp_GetPessoaPorCampanha";
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idCampanha";
paran1.Value = idCampanha;
Cmd.Parameters.Add(paran1);
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@idCredencial";
paran.Value = IDUsuario;
Cmd.Parameters.Add(paran);
SetObjectToGet(iType);
return(iType);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
private void BindRepeaters()
{
var usersInGroup = Utils.User.GetUserIdsInGroup(_groupID);
Cn.Open();
//bind allowed users
if (usersInGroup.Any())
{
rptAllowed.DataSource = Cn.ExecuteOrm <UserInfo>(@"SELECT ForumUsers.UserID, ForumUsers.UserName
FROM ForumUsers
WHERE UserID IN (" + usersInGroup.Select(x => x.ToString()).Aggregate((x, y) => x + "," + y) + ") ORDER BY UserName");
}
else
{
rptAllowed.DataSource = null;
}
rptAllowed.DataBind();
//bind denied users
rptDenied.DataSource = Cn.ExecuteOrm <UserInfo>(@"SELECT ForumUsers.UserID, ForumUsers.UserName FROM ForumUsers
WHERE Disabled=0
" + (usersInGroup.Any() ? "AND UserID NOT IN (" + usersInGroup.Select(x => x.ToString()).Aggregate((x, y) => x + "," + y) + ")" : "") + " ORDER BY UserName");
rptDenied.DataBind();
Cn.Close();
lblNoUsersInGroup.Visible = (rptAllowed.Items.Count == 0);
}
protected void btnPurge_Click(object sender, EventArgs e)
{
List <int> topicIds = new List <int>();
Cn.Open();
var dr = Cn.ExecuteReader(
@"SELECT ForumTopics.TopicID
FROM ForumTopics
INNER JOIN ForumMessages ON ForumTopics.LastMessageID=ForumMessages.MessageID
WHERE ForumMessages.CreationDate<?" , DateTime.Parse(tbDateFrom.Text));
while (dr.Read())
{
topicIds.Add(Convert.ToInt32(dr[0]));
}
dr.Close();
foreach (int topicId in topicIds)
{
Topic.DeleteTopic(topicId, Cn);
}
Cn.Close();
lblRes.Text = "OK!";
}
public IType BuscarPorUsuario(IType iType, int idUsuario, int idCampanha)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_SYS_BUSCA_HIERARQUIA_POR_CREDENCIAL";
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@idcredencial";
paran.Value = idUsuario;
Cmd.Parameters.Add(paran);
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idcampanha";
paran1.Value = idCampanha;
Cmd.Parameters.Add(paran1);
SetObjectToGet(iType);
return(iType);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public LIType ListaByHierarquia(IType iType, int idPessoa, int idCampanha)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "Sp_Ambev_Lista_RelacionaPessoa";
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idPessoa";
paran1.Value = idPessoa;
Cmd.Parameters.Add(paran1);
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idcampanha";
paran2.Value = idCampanha;
Cmd.Parameters.Add(paran2);
return(MakeListToGet(iType));
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public LIType BuscarPorHierarquiaENivel(IType iType, int idHierarquia, int idSubNivel, int idCampanha)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "Sp_Ambev_Lista_Nivel_Hierarquia_dsPessoa";
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@nivel";
paran.Value = idSubNivel;
Cmd.Parameters.Add(paran);
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idHierarquiaPai";
paran1.Value = idHierarquia;
Cmd.Parameters.Add(paran1);
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idcampanha";
paran2.Value = idCampanha;
Cmd.Parameters.Add(paran2);
return(MakeListToGet(iType));
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
private void SaveAvatarFromTwitter(int userId, string avatarUrl)
{
//save avatar from twitter
Cn.Open();
Cn.ExecuteNonQuery("UPDATE ForumUsers SET UseGravatar=?, AvatarFileName=? WHERE UserID=?", false, avatarUrl, userId);
Cn.Close();
}
protected void gridGroups_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if (e.CommandName == "delete")
{
string groupid = e.Item.Cells[0].Text;
Cn.Open();
Cn.ExecuteNonQuery("DELETE FROM ForumGroupPermissions WHERE GroupID=" + groupid + " AND ForumID=" + _forumId);
Cn.Close();
Forum.ClearFrontPageCacheForGuests();
BindPermissionsGrid();
return;
}
if (e.CommandName == "save")
{
string groupid = e.Item.Cells[0].Text;
CheckBox chkAllowReading = (CheckBox)e.Item.Cells[2].FindControl("chkAllowReading");
CheckBox chkAllowPosting = (CheckBox)e.Item.Cells[2].FindControl("chkAllowPosting");
Cn.Open();
Cn.ExecuteNonQuery("UPDATE ForumGroupPermissions SET AllowReading=?, AllowPosting=? WHERE GroupID=" + groupid + " AND ForumID=" + _forumId,
chkAllowReading.Checked, chkAllowPosting.Checked);
Cn.Close();
Forum.ClearFrontPageCacheForGuests();
BindPermissionsGrid();
return;
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (CurrentUserID == 0)
{
lblNotLoggedIn.Visible = true;
return;
}
lblNotLoggedIn.Visible = false;
_userId = Request.QueryString["UserID"] == null ? 0 : int.Parse(Request.QueryString["UserID"]);
if (_userId != 0)
{
rptConversationsList.Visible = false;
Cn.Open();
BindBodiesRepeater();
MarkAllAsRead();
Cn.Close();
}
else
{
rptMessagesList.Visible = false;
Cn.Open();
BindConversationsRepeater();
Cn.Close();
}
}
private void BindGroupsList()
{
Cn.Open();
ddlGroups.DataSource = Cn.ExecuteReader("SELECT * FROM ForumUserGroups ORDER BY Title");
ddlGroups.DataBind();
Cn.Close();
}
private void BindForumProperties()
{
Cn.Open();
DbDataReader dr = Cn.ExecuteReader("SELECT * FROM ForumGroups ORDER BY OrderByNumber");
ddlForumGroup.DataSource = dr;
ddlForumGroup.DataBind();
dr.Close();
dr = Cn.ExecuteReader("SELECT * FROM Forums WHERE ForumID=" + _forumId);
if (dr.Read())
{
tbTitle.Text = dr["Title"].ToString();
tbDescr.Text = dr["Description"].ToString();
cbPremoderated.Checked = Convert.ToBoolean(dr["Premoderated"]);
cbMembersOnly.Checked = Convert.ToBoolean(dr["MembersOnly"]);
cbRestrictTopicCreation.Checked = Convert.ToBoolean(dr["RestrictTopicCreation"]);
ddlForumGroup.SelectedValue = dr["GroupID"].ToString();
imgForumIcon.ImageUrl = forums.GetForumIcon(dr["IconFile"].ToString());
}
dr.Close();
Cn.Close();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
int parentid = 0, subforumid = 0;
int.TryParse(ddlParentForum.SelectedValue, out parentid);
int.TryParse(ddlSubForum.SelectedValue, out subforumid);
Cn.Open();
//reverse subforum check
object res = Cn.ExecuteScalar("SELECT ParentForumID FROM ForumSubforums WHERE ParentForumID=" + subforumid + " AND SubForumID=" + parentid);
if (parentid != 0 && parentid != subforumid && res == null)
{
lblError.Visible = false;
Cn.ExecuteNonQuery("INSERT INTO ForumSubforums (ParentForumID, SubForumID) VALUES (?, ?)", parentid, subforumid);
}
else
{
lblError.Visible = true;
}
Cn.Close();
BindDropDownLists();
BindSubForums();
}
protected void btnQuickReply_Click(object sender, EventArgs e)
{
string WhoAmI = cboWhoAmI.SelectedValue;
if (WhoAmI == "")
{
return;
}
string msg = tbQuickReply.Text.Trim();
if (msg == "")
{
return;
}
msg = msg.Replace("<", "<").Replace(">", ">");
Cn.Open();
int messageId = Utils.Message.AddMessage(Cn, _topicID, msg, !_premoderated || _isModerator, Utils.Various.GetUserIpAddress(Request), false, WhoAmI);
if (_premoderated && !_isModerator)
{
Cn.Close();
Response.Redirect("premoderatedmessage.aspx");
}
else
{
//count messages to compute the number of pages
//(needed to get the user redirected to the last page)
string url = Utils.Topic.GetNewlyPostedMessageUrl(_topicID, messageId, Cn, PageSize);
Cn.Close();
Response.Redirect(url);
}
}
protected void btnRequest_Click(object sender, System.EventArgs e)
{
if (txEmail.Text.Trim() != "")
{
if (tbImgCode.Text == (string)Session["CaptchaImageText"])
{
this.Cn.Open();
object res = Cn.ExecuteScalar("SELECT UserName FROM ForumUsers WHERE Email=?", txEmail.Text.Trim());
if (res == null)
{
Cn.Close();
lblEmailNotFound.Visible = true;
return; //no user found
}
string newPsw = CryptoUtils.GenerateRandomCode(7);
string newPswHash = Utils.Password.CalculateHash(newPsw);
Cn.ExecuteNonQuery("UPDATE ForumUsers SET [Password]=? WHERE Email=?", newPswHash, txEmail.Text.Trim());
this.Cn.Close();
SendPsw(txEmail.Text.Trim(), res.ToString(), newPsw);
tblMain.Visible = false;
lblOk.Visible = true;
}
else
{
lblWrongCode.Visible = true;
}
}
}
private string GetRssXML()
{
if (Cache["RecentRSS"] != null)
{
return(Cache["RecentRSS"] as string);
}
string retval = "";
retval += "<?xml version=\"1.0\"?>\r\n";
retval += "<rss version=\"2.0\">\r\n";
retval += "<channel>\r\n";
retval += "<title>" + Utils.Settings.ForumTitle.Replace("&", "&") + " - Recent Posts</title>\r\n";
retval += "<link>" + Utils.Various.ForumURL + "recent.aspx</link>\r\n";
retval += "<description>" + Utils.Settings.ForumTitle.Replace("&", "&") + " - Recent Posts</description>\r\n";
retval += "<language>en-us</language>\r\n";
retval += "<docs>http://blogs.law.harvard.edu/tech/rss</docs>\r\n";
retval += "<generator>Jitbit AspNetForum</generator>\r\n";
Cn.Open();
DbDataReader dr = Cn.ExecuteReader(@"SELECT TOP 30 ForumMessages.Body, ForumMessages.CreationDate, ForumTopics.TopicID, ForumTopics.Subject,
ForumUsers.UserName, ForumUsers.FirstName, ForumUsers.LastName, ForumMessages.UserID, ForumUsers.PostsCount
FROM (ForumMessages INNER JOIN ForumTopics ON ForumMessages.TopicID=ForumTopics.TopicID)
LEFT JOIN ForumUsers ON ForumMessages.UserID=ForumUsers.UserID
WHERE ForumTopics.ForumID NOT IN (SELECT ForumID FROM ForumGroupPermissions WHERE AllowReading=?)
AND ForumTopics.ForumID NOT IN (SELECT ForumID FROM Forums WHERE MembersOnly=?)
ORDER BY ForumMessages.MessageID DESC" , true, true);
if (dr.HasRows)
{
int i = 0;
while (dr.Read())
{
if (i == 0) //first record
{
retval += string.Format("<pubDate>{0}</pubDate>\r\n", ((DateTime)dr["CreationDate"]).ToString("r"));
retval += string.Format("<lastBuildDate>{0}</lastBuildDate>\r\n", ((DateTime)dr["CreationDate"]).ToString("r"));
}
i++;
//items
retval += "<item>\r\n";
retval += string.Format("<link>{0}</link>\r\n", Utils.Various.ForumURL + Utils.Various.GetTopicURL(dr["TopicID"], dr["Subject"]));
retval += "<title>Topic "" + dr["Subject"].ToString().Replace("&", "&") + "" a message from " + Utils.User.GetUserDisplayName(dr["UserName"], dr["FirstName"], dr["LastName"]).Replace("&", "&") + "</title>\r\n";
retval += string.Format("<description><![CDATA[{0}]]></description>\r\n", Utils.Formatting.FormatMessageHTML(dr["Body"].ToString()));
retval += string.Format("<pubDate>{0}</pubDate>\r\n", ((DateTime)dr["CreationDate"]).ToString("r"));
retval += "</item>\r\n";
}
}
dr.Close();
Cn.Close();
retval += "</channel>\r\n";
retval += "</rss>\r\n";
Cache.Add("RecentRSS", retval.ToString(), null, DateTime.Now.AddMinutes(15), Cache.NoSlidingExpiration, CacheItemPriority.Normal, null);
return(retval);
}
protected void btnSave_Click(object sender, System.EventArgs e)
{
if (tbForumGroup.Text.Trim() == "" && ddlForumGroup.Items.Count == 0)
{
Response.Write("error");
return;
}
Cn.Open();
int forumGroup = 0;
if (tbForumGroup.Text.Trim() != "")
{
Cn.ExecuteNonQuery("INSERT INTO ForumGroups (GroupName) VALUES (?)", tbForumGroup.Text);
forumGroup = Convert.ToInt32(Cn.ExecuteScalar("SELECT GroupID FROM ForumGroups WHERE GroupName='" + tbForumGroup.Text + "'"));
}
else
{
forumGroup = int.Parse(ddlForumGroup.SelectedValue);
}
string uploadDir = Attachments.GetIconsDirAbsolutePath();
string iconFileName = iconUpload.PostedFile.FileName;
if (iconFileName != "" && !Attachments.IsExtForbidden(iconFileName))
{
//deleting old iconfile form disk
object res = Cn.ExecuteScalar("SELECT IconFile FROM Forums WHERE ForumID=" + _forumId);
if (res != null && res.ToString() != "")
{
File.Delete(uploadDir + "\\" + res);
}
iconFileName = Path.GetFileName(iconFileName);
//rename if the file already exists
iconFileName = Utils.Attachments.ChangeFileNameIfAlreadyExists(iconFileName, uploadDir);
iconUpload.PostedFile.SaveAs(uploadDir + "\\" + iconFileName);
//saving icon to DB
Cn.ExecuteNonQuery("UPDATE Forums SET IconFile=? WHERE ForumID=?", iconFileName, _forumId);
}
Cn.ExecuteNonQuery("UPDATE Forums SET Title=?, Description=?, Premoderated=?, GroupID=?, MembersOnly=?, RestrictTopicCreation=? WHERE ForumID=?",
tbTitle.Text, tbDescr.Text, cbPremoderated.Checked, forumGroup, cbMembersOnly.Checked, cbRestrictTopicCreation.Checked, _forumId);
Cn.Close();
//to update the front-page with new name, icon etc.
Forum.ClearFrontPageCacheForGuests();
Response.Redirect("admin.aspx", true);
//tbForumGroup.Text = "";
//BindForumProperties();
}
private void BindSettings()
{
Cn.Open();
DbDataReader dr = Cn.ExecuteReader("SELECT * FROM ForumConfig ORDER BY CfgKey");
gridSettings.DataSource = dr;
gridSettings.DataBind();
dr.Close();
Cn.Close();
}
private void BindModeratorsGrid()
{
Cn.Open();
gridModerators.DataSource = Cn.ExecuteReader(@"SELECT ForumModerators.UserID, ForumUsers.UserName
FROM ForumModerators INNER JOIN ForumUsers ON ForumModerators.UserID = ForumUsers.UserID
WHERE ForumModerators.ForumID=" + _forumId);
gridModerators.DataBind();
Cn.Close();
lblNoModerators.Visible = (gridModerators.Items.Count == 0);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (this.tbForumGroup.Text.Trim() != "")
{
Cn.Open();
Cn.ExecuteNonQuery("INSERT INTO ForumGroups (GroupName) VALUES (?)", tbForumGroup.Text);
Cn.Close();
BindGroups(_groupID);
}
}
/// <summary>
/// Fecha a conexão com o banco de dados
/// </summary>
protected internal void CloseConnection(IType iType)
{
if (Cn != null)
{
if (Cn.State == ConnectionState.Open && iType.Transaction == null)
{
Cn.Close();
Cn.Dispose();
}
}
}
protected void gridModerators_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if (e.CommandName == "delete")
{
Cn.Open();
Cn.ExecuteNonQuery("DELETE FROM ForumModerators WHERE UserID=? AND ForumID=?", int.Parse(e.Item.Cells[0].Text), _forumId);
Cn.Close();
BindModeratorsGrid();
}
}
