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(); } }
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(); }
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(); }
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(); } }
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 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; } }
private void BindGroupsList() { Cn.Open(); ddlGroups.DataSource = Cn.ExecuteReader("SELECT * FROM ForumUserGroups ORDER BY Title"); ddlGroups.DataBind(); Cn.Close(); }
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(); }
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(); } }
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 + "\""; }
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; } }
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!"; }
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 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(); }
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(); }
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); } }
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 btnUnsubscribe_Click(object sender, System.EventArgs e) { if (CurrentUserID == 0) { return; //just in case } Cn.Open(); Utils.SendNotifications.UpdateTopicNotificationSettings(CurrentUserID, _topicID, false, Cn); SubscribeButtonVisibility(); Cn.Close(); }
protected void btnVote_Click(object sender, EventArgs e) { if (rblOptions.SelectedValue == "") { return; } Cn.Open(); Cn.ExecuteNonQuery("INSERT INTO ForumPollAnswers (UserID, OptionID) VALUES (?, ?)", CurrentUserID, rblOptions.SelectedValue); ShowPollIfAny(); Cn.Close(); }
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(); } }
private void BindPermissionsGrid() { Cn.Open(); gridGroups.DataSource = Cn.ExecuteReader(@"SELECT ForumUserGroups.GroupID, ForumUserGroups.Title, ForumGroupPermissions.AllowReading, ForumGroupPermissions.AllowPosting FROM ForumUserGroups INNER JOIN ForumGroupPermissions ON ForumGroupPermissions.GroupID = ForumUserGroups.GroupID WHERE ForumGroupPermissions.ForumID=" + _forumId); gridGroups.DataBind(); Cn.Close(); lblFFA.Visible = (gridGroups.Items.Count == 0); gridGroups.Visible = (gridGroups.Items.Count != 0); }
protected void btnUnsubscribeMsgs_Click(object sender, System.EventArgs e) { if (CurrentUserID == 0) { return; //just in case } Cn.Open(); Cmd.CommandText = "DELETE FROM ForumNewForumMsgSubscriptions WHERE UserID=" + CurrentUserID + " AND ForumID=" + _forumID; Cmd.ExecuteNonQuery(); SubscribeButtonVisibility(); Cn.Close(); }
/// <summary> /// saves the current order of forums in which they ALREADY APPEAR inthe grid /// </summary> private void SaveCurrentOrderOfSectinsCategories() { Cn.Open(); foreach (DataGridItem item in gridForums.Items) { if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem) { Cn.ExecuteNonQuery(@"UPDATE Forums SET OrderByNumber = ? WHERE ForumID=?", item.ItemIndex, item.Cells[0].Text); } } Cn.Close(); }
protected void btnSave_Click(object sender, System.EventArgs e) { //reset avatar cache for current user (BECAUSE email can change!!!!) if (Utils.User.CurrentUserID == _editedUserID) { Session["AvatarPath"] = null; } string username = tbUsername.Text.Replace("<", "<").Replace(">", ">"); string email = tbEmail.Text.Replace("<", "<").Replace(">", ">"); string interests = tbInterests.Text.Replace("<", "<").Replace(">", ">"); string homepage = tbHomepage.Text.Replace("<", "<").Replace(">", ">"); string firstName = tbFirstName.Text.Trim().Replace("<", "<").Replace(">", ">"); string lastName = tbLastName.Text.Trim().Replace("<", "<").Replace(">", ">"); string signature = tbSignature.Text.Trim().Replace("<", "<").Replace(">", ">"); signature = (signature.Length > 1000 ? signature.Substring(0, 1000) : signature); //check is a user tries to change his username but IntegratedAuth is ON if (Utils.Settings.IntegratedAuthentication && _editedUserID == CurrentUserID && tbUsername.Text.ToLower() != Session["aspnetforumUserName"].ToString().ToLower()) { lblResult.Text = Resources.various.ErrorIntegratedUserName; return; } //check username uniqueness Cn.Open(); var res = Cn.ExecuteScalar("SELECT UserID FROM ForumUsers WHERE UserName=? AND UserID<>?", username, _editedUserID); if (res != null) { Cn.Close(); lblResult.Text = string.Format(Resources.various.ErrorUserExists, username); return; } //update settings Cn.ExecuteNonQuery("UPDATE ForumUsers SET UserName=?, Email=?, Homepage=?, Interests=?, Signature=?, FirstName=?, LastName=?, HidePresence=? WHERE UserID=?", username, email, homepage, interests, signature, firstName, lastName, cbHidePresence.Checked, _editedUserID); Cn.Close(); if (_editedUserID == CurrentUserID) { Session["aspnetforumUserName"] = username; } lblResult.Text = Resources.various.ProfileSaved; //to show avatar img ShowUserInfo(); }
public int Insert(JogadorDto obj) { var sqlInsert = string.Empty; try { Cn.Open(); sqlInsert = "INSERT INTO TabelaJogador "; sqlInsert += "(idJogaor"; sqlInsert += "(NOME"; sqlInsert += ", SOBRENOME"; sqlInsert += ", POSICAO"; sqlInsert += ", IDADE"; sqlInsert += ", GENERO"; sqlInsert += ", ALTURA"; sqlInsert += ", PESO"; sqlInsert += ", GOLSMARCADOS"; sqlInsert += ", NUMERODEJOGOS"; sqlInsert += ", QUANTIDADECARTAOAMARELO"; sqlInsert += ", QUANTIDADECARTAOVERMELHO"; sqlInsert += ", QUANTIDADEEXPULSAO"; sqlInsert += ") VALUES ("; sqlInsert += KConvert.ConvDB2(obj.IdJogador); sqlInsert += "," + KConvert.ConvDB2(obj.Nome); sqlInsert += "," + KConvert.ConvDB2(obj.Sobrenome); sqlInsert += "," + KConvert.ConvDB2(obj.Posicao); sqlInsert += "," + KConvert.ConvDB2(obj.Idade); sqlInsert += "," + KConvert.ConvDB2(obj.Genero); sqlInsert += "," + KConvert.ConvDB2(obj.Altura); sqlInsert += "," + KConvert.ConvDB2(obj.Peso); sqlInsert += "," + KConvert.ConvDB2(obj.GolsMarcados); sqlInsert += "," + KConvert.ConvDB2(obj.NumeroDeJogos); sqlInsert += "," + KConvert.ConvDB2(obj.QuantidadeCartaoAmarelo); sqlInsert += "," + KConvert.ConvDB2(obj.QuantidadeCartaoVermelho); sqlInsert += "," + KConvert.ConvDB2(obj.QuantidadeExpulsao); sqlInsert += ")"; return(Cn.Execute(sqlInsert)); } catch (Exception ex) { throw new SQLException(Cn.activeConnection.Errors, sqlInsert, ex); } finally { if (!IsParameter) { Cn.Close(); } } }
protected void gridForumGroups_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "delete") { string groupid = e.Item.Cells[0].Text; this.Cn.Open(); Cn.ExecuteNonQuery("DELETE FROM ForumGroups WHERE GroupID=? and GroupID NOT IN (SELECT GroupID FROM Forums)", groupid); this.Cn.Close(); BindGroups(_groupID); } else if (e.CommandName == "up" || e.CommandName == "down") { SaveCurrentOrderOfSectinsCategories(); //save current picture string groupId = e.Item.Cells[0].Text; if (e.CommandName == "up") { if (e.Item.ItemIndex > 0) { DataGridItem previousItem = gridForumGroups.Items[e.Item.ItemIndex - 1]; if (previousItem.ItemType == ListItemType.Item || previousItem.ItemType == ListItemType.AlternatingItem) { string previousGroupId = previousItem.Cells[0].Text; Cn.Open(); Cn.ExecuteNonQuery(@"UPDATE ForumGroups SET OrderByNumber = OrderByNumber-1 WHERE GroupID=?", groupId); Cn.ExecuteNonQuery(@"UPDATE ForumGroups SET OrderByNumber = OrderByNumber+1 WHERE GroupID=?", previousGroupId); Cn.Close(); BindGroups(_groupID); } } } if (e.CommandName == "down") { if (e.Item.ItemIndex < gridForumGroups.Items.Count - 1) { DataGridItem nextItem = gridForumGroups.Items[e.Item.ItemIndex + 1]; if (nextItem.ItemType == ListItemType.Item || nextItem.ItemType == ListItemType.AlternatingItem) { string nextGroupId = nextItem.Cells[0].Text; Cn.Open(); Cn.ExecuteNonQuery(@"UPDATE ForumGroups SET OrderByNumber = OrderByNumber+1 WHERE GroupID=?", groupId); Cn.ExecuteNonQuery(@"UPDATE ForumGroups SET OrderByNumber = OrderByNumber-1 WHERE GroupID=?", nextGroupId); Cn.Close(); BindGroups(_groupID); } } } } }
private void MoveTopic(DropDownList forumDropDown) { if (forumDropDown.SelectedValue == "") { return; } int forumId = int.Parse(forumDropDown.SelectedValue); Utils.Topic.MoveTopic(_topicID, forumId); Cn.Open(); GetGeneralTopicInfo(); Cn.Close(); }