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