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