public void Save(IType iType, int idPessoa, int idHierarquia)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_SaveEstrutura";
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idHierarquia";
paran1.Value = idHierarquia;
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 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 BindRepeater()
{
DataSet ds = new DataSet();
ds.Tables.Add("Messages");
ds.Tables.Add("CompainUsers");
string sql;
if (this.IsAdministrator)
{
sql = @"SELECT ForumComplaints.UserID AS ComplainUserID, ForumMessages.MessageID, ForumMessages.Body, ForumMessages.CreationDate, ForumTopics.TopicID, ForumTopics.Subject, ForumUsers.UserName, ForumMessages.UserID, ForumUsers.PostsCount, ForumUsers.AvatarFileName, ForumUsers.FirstName, ForumUsers.LastName
FROM ((ForumMessages LEFT JOIN ForumUsers ON ForumMessages.UserID=ForumUsers.UserID)
INNER JOIN ForumTopics ON ForumMessages.TopicID=ForumTopics.TopicID)
INNER JOIN ForumComplaints ON ForumMessages.MessageID=ForumComplaints.MessageID
ORDER BY ForumMessages.MessageID DESC" ;
}
else
{
sql = @"SELECT ForumComplaints.UserID AS ComplainUserID, ForumMessages.MessageID, ForumMessages.Body, ForumMessages.CreationDate, ForumTopics.TopicID, ForumTopics.Subject, ForumUsers.UserName, ForumMessages.UserID, ForumUsers.PostsCount, ForumUsers.AvatarFileName, ForumUsers.FirstName, ForumUsers.LastName
FROM ((ForumMessages LEFT JOIN ForumUsers ON ForumMessages.UserID=ForumUsers.UserID)
INNER JOIN ForumTopics ON ForumMessages.TopicID=ForumTopics.TopicID)
INNER JOIN ForumComplaints ON ForumMessages.MessageID=ForumComplaints.MessageID
WHERE ForumTopics.ForumID IN (SELECT DISTINCT ForumID FROM ForumModerators WHERE UserID=" + CurrentUserID + @")
ORDER BY ForumMessages.MessageID DESC" ;
}
DbDataReader dr = Cn.ExecuteReader(sql, false);
ds.Tables[0].Load(dr);
dr.Close();
//now get complainers
dr = Cn.ExecuteReader("SELECT UserID, UserName FROM ForumUsers WHERE UserID IN (SELECT UserID FROM ForumComplaints)");
ds.Tables[1].Load(dr);
dr.Close();
ds.Relations.Add(new DataRelation("MessagesUsers", ds.Tables[0].Columns["ComplainUserID"], ds.Tables[1].Columns["UserID"], false));
PagedDataSource pagedSrc = new PagedDataSource();
pagedSrc.DataSource = ds.Tables[0].DefaultView;
pagedSrc.AllowPaging = true;
pagedSrc.PageSize = this.PageSize;
int curPage = 0;
if (Request.QueryString["page"] != null)
{
int.TryParse(Request.QueryString["page"], out curPage);
}
pagedSrc.CurrentPageIndex = curPage;
//prepare a string for the "pager" at the bottom
pagerString = Utils.Various.GetPaginationString(curPage, pagedSrc.PageCount, "complaints.aspx");
this.rptMessagesList.DataSource = pagedSrc;
this.rptMessagesList.DataBind();
rptMessagesList.Visible = (rptMessagesList.Items.Count > 0);
divNothingFound.Visible = !rptMessagesList.Visible;
}
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 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!";
}
private void BindGroupsList()
{
Cn.Open();
ddlGroups.DataSource = Cn.ExecuteReader("SELECT * FROM ForumUserGroups ORDER BY Title");
ddlGroups.DataBind();
Cn.Close();
}
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();
}
}
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 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();
}
}
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;
}
}
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 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();
}
}
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);
}
/// <summary>
/// Gets the SQL executed by a given procedure.
/// </summary>
/// <returns>
/// The source of the given procedure.
/// </returns>
public virtual string GetProcedureSQL(string Procedure)
{
DataTable dt;
dt = Cn.GetSchema
("Procedures", new string[] { null, null, Procedure, null });
return((string)dt.Rows[0]["PROCEDURE_DEFINITION"]);
}
/// <summary>
/// Gets the SQL executed by a given VIEW.
/// </summary>
/// <returns>
/// The source of the given view.
/// </returns>
public virtual string GetViewSQL(string View)
{
DataTable dt;
dt = Cn.GetSchema
("Views", new string[] { null, null, View });
return((string)dt.Rows[0]["VIEW_DEFINITION"]);
}
/// <summary>
/// Executes the SQL command passed as a string.
/// </summary>
/// <param name="SQL">One or more SQL commands semicolon delimited.</param>
/// <param name="paramaters">The parameters to pass to the SQL.</param>
public virtual void ExecuteSqlCommand(string SQL, DbParameter [] parameters)
{
using (DbCommand cmd = Cn.CreateCommand()) {
cmd.CommandText = SQL;
cmd.Parameters.AddRange(parameters);
cmd.ExecuteNonQuery();
}
}
public Sesion Crear(long idAlumno)
{
try
{
using (var oCnn = Cn.OracleCn())
{
OracleCommand oCmd = null;
oCnn.Open();
oCmd = new OracleCommand("SP_CREARSESION", oCnn)
{
CommandType = CommandType.StoredProcedure
};
oCmd.Parameters.Add(new OracleParameter("pIdAlumno", OracleDbType.Int64)).Value = idAlumno;
oCmd.Parameters.Add(new OracleParameter("pRpta", OracleDbType.Int64)).Direction = ParameterDirection.Output;
oCmd.ExecuteScalar();
var idSesion = oCmd.Parameters["pRpta"].Value;
if (idSesion != null)
{
var sesion = new Sesion()
{
IdSesion = UtilConverter.ConvertirInt64(idSesion.ToString()),
IdAlumno = idAlumno,
FechaInicio = DateTime.Now
};
return(sesion);
}
}
}
catch (Exception)
{
}
//try
//{
// var db = Database.OpenNamedConnection(ConnectionName);
// var result = db.SP_CREARSESION(idAlumno);
// var gsavSesion = db.GSAV_SESION.Get(result.OutputValues["PRPTA"]);
// var sesion = new Sesion()
// {
// IdSesion = gsavSesion.IDSESION,
// IdAlumno = gsavSesion.IDALUMNO,
// FechaInicio = gsavSesion.FECHAINICIO
// };
// return sesion;
//}
//catch (Exception ex)
//{
// LogError(ex);
//}
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="solicitud"></param>
/// <returns></returns>
public ReturnObject <List <Solicitud> > ConsultarSolicitudes(Solicitud solicitud)
{
ReturnObject <List <Solicitud> > obj = new ReturnObject <List <Solicitud> >();
obj.OneResult = new List <Solicitud>();
try
{
using (var oCnn = Cn.OracleCn())
{
OracleCommand oCmd = null;
oCnn.Open();
oCmd = new OracleCommand("SP_CONSULTAR_SOLICITUDES", oCnn);
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.Parameters.Add(new OracleParameter("P_IDSOLICITUD", OracleDbType.Int64)).Value = solicitud.IdSolicitud;
oCmd.Parameters.Add(new OracleParameter("P_ESTADO", OracleDbType.Varchar2)).Value = solicitud.Estado;
oCmd.Parameters.Add(new OracleParameter("P_CODIGOALUMNO", OracleDbType.Varchar2)).Value = solicitud.CodigoAlumno;
oCmd.Parameters.Add(new OracleParameter("P_NOMBREALUMNO", OracleDbType.Varchar2)).Value = solicitud.Nombre;
oCmd.Parameters.Add(new OracleParameter("P_FECHA_INICIO", OracleDbType.Varchar2)).Value = solicitud.FechaInicio;
oCmd.Parameters.Add(new OracleParameter("P_FECHA_FIN", OracleDbType.Varchar2)).Value = solicitud.FechaFin;
oCmd.Parameters.Add(new OracleParameter("P_IDEMPLEADO", OracleDbType.Int64)).Value = solicitud.IdEmpleado;
oCmd.Parameters.Add(new OracleParameter("P_IDALUMNO", OracleDbType.Int64)).Value = solicitud.IdAlumno;
oCmd.Parameters.Add(new OracleParameter("P_RC", OracleDbType.RefCursor)).Direction = ParameterDirection.Output;
OracleDataReader rd = oCmd.ExecuteReader();
if (rd.HasRows)
{
while (rd.Read())
{
var solicitud_ = new Solicitud();
solicitud_.IdSolicitud = rd.GetInt32(rd.GetOrdinal("IDSOLICITUD"));
solicitud_.FechaRegistro = rd.GetDateTime(rd.GetOrdinal("FECHAREGISTRO"));
solicitud_.Canal = rd.GetValue(rd.GetOrdinal("CANAL")) == DBNull.Value ? string.Empty : rd.GetString(rd.GetOrdinal("CANAL"));
solicitud_.Intencion = rd.GetValue(rd.GetOrdinal("INTENCION")) == DBNull.Value ? string.Empty : rd.GetString(rd.GetOrdinal("INTENCION"));
solicitud_.CodigoAlumno = rd.GetValue(rd.GetOrdinal("CODIGOALUMNO")) == DBNull.Value ? string.Empty : rd.GetString(rd.GetOrdinal("CODIGOALUMNO"));
solicitud_.Nombre = rd.GetValue(rd.GetOrdinal("NOMBRE")) == DBNull.Value ? string.Empty : rd.GetString(rd.GetOrdinal("NOMBRE"));
solicitud_.ApellidoPat = rd.GetValue(rd.GetOrdinal("APELLIDOPAT")) == DBNull.Value ? string.Empty : rd.GetString(rd.GetOrdinal("APELLIDOPAT"));
solicitud_.ApellidoMat = rd.GetValue(rd.GetOrdinal("APELLIDOMAT")) == DBNull.Value ? string.Empty : rd.GetString(rd.GetOrdinal("APELLIDOMAT"));
solicitud_.Estado = rd.GetValue(rd.GetOrdinal("ESTADO")) == DBNull.Value ? string.Empty : rd.GetString(rd.GetOrdinal("ESTADO"));
solicitud_.Consulta = rd.GetValue(rd.GetOrdinal("CONSULTA")) == DBNull.Value ? string.Empty : rd.GetString(rd.GetOrdinal("CONSULTA"));
solicitud_.Solucion = rd.GetValue(rd.GetOrdinal("SOLUCION")) == DBNull.Value ? string.Empty : rd.GetString(rd.GetOrdinal("SOLUCION"));
obj.OneResult.Add(solicitud_);
}
}
obj.Success = true;
}
}
catch (Exception ex)
{
obj.Success = false;
obj.ErrorMessage = ex.Message;
}
return(obj);
}
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 BindForumsDropDown()
{
DbDataReader dr = Cn.ExecuteReader("SELECT ForumID, Title FROM Forums");
DataTable dt = new DataTable();
dt.Load(dr);
dr.Close();
ddlForumsTop.DataSource = dt;
ddlForumsTop.DataBind();
}
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 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);
}
/// <summary>
/// Gets the SQL executed by a given TABLE.
/// </summary>
/// <remarks>
/// Posted by Rasha in http://sqlite.phxsoftware.com/forums/thread/2272.aspx
/// </remarks>
/// <returns>
/// The DDL of the given table.
/// </returns>
public virtual string GetTableSQL(string Table)
{
using (SQLiteCommand cmd = (SQLiteCommand)Cn.CreateCommand()) {
cmd.CommandText = "SELECT sql FROM sqlite_master " +
"WHERE name = @tablename";
cmd.Parameters.Add("@tablename", DbType.String);
cmd.Parameters["@tablename"].Value = Table;
return((string)cmd.ExecuteScalar());
}
}
private void BindSettings()
{
Cn.Open();
DbDataReader dr = Cn.ExecuteReader("SELECT * FROM ForumConfig ORDER BY CfgKey");
gridSettings.DataSource = dr;
gridSettings.DataBind();
dr.Close();
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();
}
/// <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();
}
}
}
private void BindForums()
{
this.Cn.Open();
DbDataReader dr = Cn.ExecuteReader("SELECT * FROM Forums ORDER BY OrderByNumber");
this.gridForums.DataSource = dr;
this.gridForums.DataBind();
dr.Close();
this.Cn.Close();
lblNoForums.Visible = (gridForums.Items.Count == 0);
}
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 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();
}
}
/// <summary>
///
/// </summary>
/// <param name="format"></param>
/// <param name="arg"></param>
/// <param name="formatProvider"></param>
/// <returns></returns>
public string Format(string format, object arg, IFormatProvider formatProvider)
{
if (arg is IHoliday == false) throw new ChineseDateTimeException(11002.106);
IHoliday holiday = arg as IHoliday;
CultureInfo cul = formatProvider as CultureInfo ?? CultureInfo.CurrentCulture;
HolidayToString holidayToString;
switch (cul.Name.Substring(0, 2))
{
case "en":
holidayToString = new En(format, holiday, cul);
break;
case "zh":
{
holidayToString = new Cn(format, holiday, cul);
}
break;
default:
holidayToString = new En(format, holiday, cul);
break;
}
return holidayToString.ToFormat();
}
public static void Main(string[] args)
{
Cns = new Cn();
bool isAvailableArgs = args.Length > 0;
if (!isAvailableArgs)
{
PutUsage();
return;
}
var opts = new List<string>();
var names = new List<string>();
bool isOptEnd = false;
foreach (var v in args)
{
isOptEnd |= v.StartsWith("--");
if (v.StartsWith("-") && !isOptEnd)
{
opts.Add(v);
}
else
{
names.Add(v);
}
}
bool isShuffle = false;
if (isAvailableArgs)
{
foreach (var v in opts)
{
if (v.Contains("-q"))
{
Cns = new NCn();
}
if (v.Contains("-h"))
{
PutUsage();
return;
}
if (v.Contains("-r"))
{
isShuffle |= true;
}
}
}
string supportFormat = "(png|gif|jpg|tiff|bmp|ico)";
foreach(var v in names)
{
if (!File.Exists(v))
{
Cns.Error("ImageFile {0} Is Not Exist", v);
continue;
}
if (!Regex.IsMatch(v.ToLower(), supportFormat))
{
Cns.Error("ImageFile {0} Is Not Support Format", v);
continue;
}
using (BitmapFast img = new BitmapFast(new Bitmap(v)))
{
var dvx = 16;
var dvy = 16;
var SC = 16;
var CostC = 300;
var CostS = 100;
var sps = Path.GetFileName(v).Split('_', '.');
if (sps.Length < 7)
{
Cns.Warning("FileName not Contains Params (You'll read Readme.txt), Use Default Params");
}
else
{
var cpt = new string[sps.Length - 2];
Array.Copy(sps, 1, cpt, 0, sps.Length - 2);
var toA = cpt.Select(int.Parse).ToArray();
dvx = toA[0];
dvy = toA[1];
SC = toA[2];
CostC = toA[3];
CostS = toA[4];
}
// Filename _ DVX _ DVY _ SetectableCount _ CostRateX _ CostRateY . 拡張子
string fname = Regex.Replace(v.ToLower(), supportFormat, "ppm");
int w = img.Width;
int h = img.Height;
//Cns.WriteLine("({0}, {1})", w, h);
if (w % 16 != 0 || h % 16 != 0)
{
Cns.Warning("Width or Height should be multiples of 16");
}
using (StreamWriter sw = new StreamWriter(fname))
{
sw.WriteLine("P6");
sw.WriteLine("# {0} {1}", dvx, dvy);
sw.WriteLine("# {0}", SC);
sw.WriteLine("# {0} {1}", CostC, CostS);
sw.WriteLine("{0} {1}", w, h);
sw.WriteLine("255");
}
Shuffler sf = new Shuffler(dvx, dvy, SC, w / dvx, h / dvy);
sf.Init();
if (isShuffle)
{
sf.Shuffle();
}
//w = 1024
//h = 512
int dix = w / dvx;
int diy = h / dvy;
//dix = 1024 / 16 = 64
using (FileStream fs = new FileStream(fname, FileMode.Append, FileAccess.Write))
{
for (int j = 0; j < h; j++)
{
for (int i = 0; i < w; i++)
{
int inX = i / dix;
int inY = j / diy;
int lvX = sf[inX, inY].FromX;
int lvY = sf[inX, inY].FromY;
int toX = lvX * dix + i % dix;
int toY = lvY * diy + j % diy;
Color c = img.GetPixel(toX, toY);
fs.WriteByte(c.R);
fs.WriteByte(c.G);
fs.WriteByte(c.B);
}
}
}
//Cns.WriteLine("Yeah");
}
}
}
/// <summary>
/// 将数据临时保持到map
/// </summary>
/// <param name="key"></param>
/// <param name="chartData"></param>
public static void putChartData(string key, Cn.Loosoft.Zhisou.SunPower.Common.ChartData chartData)
{
string cacheKey = CacheKeyUtil.buildChartDataKey(key);
MemcachedClientSatat.getInstance().Set(cacheKey, chartData);
}
