public static CategoryInfo CopyCategoryToBO(OleDbDataReader rdr)
{
//CAT_ID, CAT_NAME, CAT_STATUS, CAT_MODERATION, CAT_SUBSCRIPTION, CAT_ORDER
CategoryInfo category = new CategoryInfo
{
Id = rdr.GetInt32(0),
Name = rdr.SafeGetString(1),
Status = rdr.GetInt16(2),
ModerationLevel = rdr.SafeGetInt32(3),
SubscriptionLevel = rdr.SafeGetInt32(4),
Order = rdr.GetInt32(5)
};
return category;
}
public static ForumInfo CopyForumToBO(OleDbDataReader rdr)
{
//"F.FORUM_ID,F.CAT_ID,F.F_STATUS,F.F_SUBJECT,F.F_URL,F.F_TOPICS" +
//",F.F_COUNT,F.F_LAST_POST,F.F_PRIVATEFORUMS,F.F_TYPE,F.F_LAST_POST_AUTHOR,F.F_A_TOPICS,F.F_A_COUNT,F.F_MODERATION" +
//",F.F_SUBSCRIPTION,F.F_ORDER, F.F_COUNT_M_POSTS,F.F_LAST_POST_TOPIC_ID,F.F_LAST_POST_REPLY_ID,F.F_POLLS,F.F_DESCRIPTION" +
//",F.F_L_ARCHIVE,F.F_ARCHIVE_SCHED,T.T_SUBJECT,M.M_NAME ";
ForumInfo forum = new ForumInfo
{
Id = rdr.GetInt32(0),
CatId = rdr.GetInt32(1),
Status = rdr.GetInt16(2),
Subject = rdr.SafeGetString(3),
Url = rdr.SafeGetString(4),
TopicCount = rdr.GetInt32(5),
PostCount = rdr.GetInt32(6),
LastPostDate = rdr.GetSnitzDate(7),
AuthType = rdr.SafeGetInt32(8),
Type = rdr.GetInt16(9),
LastPostAuthorId = rdr.SafeGetInt32(10),
ArchivedTopicCount = rdr.SafeGetInt32(11),
ArchivedPostCount = rdr.SafeGetInt32(12),
ModerationLevel = rdr.SafeGetInt32(13),
SubscriptionLevel = rdr.SafeGetInt32(14),
Order = rdr.GetInt32(15),
UpdatePostCount = rdr.GetInt16(16) == 1,
LastPostTopicId = rdr.SafeGetInt32(17),
LastPostReplyId = rdr.SafeGetInt32(18),
AllowPolls = rdr.GetInt32(19) == 1,
Description = rdr.SafeGetString(20),
LastArchived = rdr.GetSnitzDate(21),
ArchiveFrequency = rdr.SafeGetInt32(22),
LastPostSubject = rdr.SafeGetString(23),
LastPostAuthorName = rdr.SafeGetString(24)
};
return forum;
}
protected void Page_Load(object sender, EventArgs e) {
paramSexo = "";
paramNome = "";
try {
paramSexo = Request["RadioButtonList1"];
paramNome = Request["TextBox1"];
if (paramSexo == null) paramSexo = "";
if (paramNome == null) paramNome = "";
}
catch(Exception){};
Label1.Text = "Registros encontrados:";
String filtro1 = "", filtro2 = "";
if (paramSexo.Equals("Todos")) {
filtro1 = " TRUE ";
}
else if (paramSexo.Equals("Masculino")) {
filtro1 = " (sexo='M') ";
}
else if (paramSexo.Equals("Feminino"))
{
filtro1 = " (sexo='F') ";
}
else
{
filtro1 = " FALSE ";
Label1.Text = "";
}
filtro2 = " (nomeprof LIKE '%" + paramNome + "%') ";
try {
conexao = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/temp/Escola.mdb");
conexao.Open();
string sql = "select * from professores WHERE "
+ filtro1 + " AND " + filtro2 + " ORDER BY nomeprof";
stm = new OleDbCommand(sql, conexao);
dr = stm.ExecuteReader();
String strHTML = "";
if (dr.HasRows) { //mostramos o cabeçalho da <table> somente se temos registros
strHTML = "<TABLE name=profs border=1 width='65%'> <TR style='font-size: 14px; font-family: verdana; text-align: center; font-weight: 900; color: #009;'>"
+ "<TD> Código </TD><TD> Nome </TD>"
+ "<TD> Sexo </TD><TD> Salário </TD></TR>";
}
while (dr.Read()) {
int codigo = dr.GetInt16(0); //codprof
String nome = dr.GetString(1); //nome
String sexo = dr.GetString(2); //sexo
float salario = dr.GetFloat(3); //salário
strHTML += "<TR><TD style='font-size: 12px; font-family: verdana; text-align: center;'>" + codigo
+ "</TD><TD style='font-size: 12px; font-family: verdana; text-align: left;'> "
+ nome + "</TD><TD style='font-size: 12px; font-family: verdana; text-align: center;'>"
+ sexo + "</TD><TD style='font-size: 12px; font-family: verdana; text-align: center;'>"
+ salario + "</TD></TR>";
}
strHTML += "</TABLE> <br/><br/><br/>";
LiteralControl lc = new LiteralControl(strHTML);
Panel2.Controls.Add(lc);
stm.Dispose();
dr.Close();
conexao.Close();
} catch (Exception exc) {
Label1.Text = "Erro no processamento do BD - " + exc.Message;
}
}
public Element(OleDbDataReader reader)
{
this._strName = reader.GetString(1);
if (!reader.IsDBNull(2))
this._strLocation = reader.GetString(2);
else
this._strLocation = "";
if (!reader.IsDBNull(3))
this._strSize = reader.GetString(3);
else
this._strSize = "";
if (!reader.IsDBNull(4))
this._strBgImage = reader.GetString(4);
else
this._strBgImage = "";
if (!reader.IsDBNull(5))
this._strFontFamily = reader.GetString(5);
else
this._strFontFamily = "";
if (!reader.IsDBNull(6))
this._strContent = reader.GetString(6);
else
this._strContent = "";
if (!reader.IsDBNull(7))
this._intFontSize = reader.GetInt16(7);
else
this._intFontSize = 0;
if (!reader.IsDBNull(8))
this._strFontColor = reader.GetString(8);
else
this._strFontColor = "";
if (!reader.IsDBNull(9))
this._strCtlName = reader.GetString(9);
else
this._strCtlName = "";
}
private int GetValue(OleDbDataReader oData)
{
int intValue;
string strFieldType;
strFieldType = Convert.ToString(oData.GetFieldType(0));
switch (strFieldType)
{
case "System.Int16":
intValue = Convert.ToInt32(oData.GetInt16(0));
break;
case "System.Int32":
intValue = oData.GetInt32(0);
break;
case "System.Double":
intValue = Convert.ToInt32(oData.GetDouble(0));
break;
default:
intValue = oData.GetInt32(0);
break;
}
return intValue;
}
public static MemberInfo CopyMemberToBO(OleDbDataReader rdr)
{
MemberInfo member = null;
try
{
member = new MemberInfo();
member.Id = rdr.GetInt32(0);
member.Status = rdr.GetInt16(1);
member.Username = rdr.GetString(2);
member.NTUsername = rdr.SafeGetString(3);
member.Email = rdr.SafeGetString(4);
member.Country = rdr.SafeGetString(5);
member.HomePage = rdr.SafeGetString(6);
member.Signature = rdr.SafeGetString(7);
member.MemberLevel = rdr.GetInt16(8);
member.AIM = rdr.SafeGetString(9);
member.Yahoo = rdr.SafeGetString(10);
member.ICQ = rdr.SafeGetString(11);
member.Skype = rdr.SafeGetString(12);
member.PostCount = rdr.SafeGetInt32(13) ?? 0;
member.MemberSince = rdr.GetSnitzDate(14) == null ? DateTime.UtcNow : rdr.GetSnitzDate(14).Value;
member.LastVisitDate = rdr.GetSnitzDate(15);
member.LastPostDate = rdr.GetSnitzDate(16);
member.Title = rdr.SafeGetString(17); //member.MemberTitle(rdr.SafeGetString(17));
member.AllowSubscriptions = rdr.SafeGetInt16(18) == 1;
member.HideEmail = rdr.SafeGetInt16(19) == 1;
member.ReceiveEmails = rdr.SafeGetInt16(20) == 1;
member.MembersIP = rdr.SafeGetString(21);
member.ViewSignatures = rdr.SafeGetInt16(22) == 1;
member.UseSignature = rdr.SafeGetInt16(23) == 1;
member.Voted = rdr.SafeGetInt32(24) == 1;
member.AllowEmail = rdr.SafeGetInt16(25) == 1;
member.Avatar = rdr.SafeGetString(26);
member.Theme = rdr.SafeGetString(27);
member.TimeOffset = rdr.SafeGetDouble(28);
member.DateOfBirth = rdr.SafeGetString(29);
member.Age = rdr.SafeGetString(30);
member.Password = rdr.GetString(31);
member.ValidationKey = rdr.SafeGetString(32);
member.IsValid = rdr.SafeGetInt32(33) == 1;
member.LastUpdateDate = rdr.GetSnitzDate(34);
member.MaritalStatus = rdr.SafeGetString(35);
member.Firstname = rdr.SafeGetString(36);
member.Lastname = rdr.SafeGetString(37);
member.Occupation = rdr.SafeGetString(38);
member.Gender = rdr.SafeGetString(39);
member.Hobbies = rdr.SafeGetString(40);
member.LatestNews = rdr.SafeGetString(41);
member.FavouriteQuote = rdr.SafeGetString(42);
member.Biography = rdr.SafeGetString(43);
member.FavLink1 = rdr.SafeGetString(44);
member.FavLink2 = rdr.SafeGetString(45);
member.City = rdr.SafeGetString(46);
member.State = rdr.SafeGetString(47);
member.UseDaylightSaving = rdr.SafeGetInt16(48) == 1;
member.TimeZone = rdr.SafeGetString(49);
}
catch (Exception ex)
{
throw new Exception("Error copying reader to BO");
OleDbDataReader rdrtest = rdr;
string test = ex.Message;
}
string title = member.Title;
//member.Rank = new RankInfo(member.Username, ref title, member.PostCount);
member.Title = title;
return member;
}
public static TopicInfo CopyTopicToBO(OleDbDataReader rdr)
{
TopicInfo topic;
try
{
topic = new TopicInfo
{
Id = rdr.GetInt32(0),
CatId = rdr.GetInt32(1),
ForumId = rdr.GetInt32(2),
Status = rdr.GetInt16(3),
Subject = rdr.SafeGetString(4),
AuthorId = rdr.GetInt32(5),
ReplyCount = rdr.GetInt32(6),
Views = rdr.GetInt32(7),
LastPostDate = rdr.GetSnitzDate(8),
Date = rdr.GetSnitzDate(9).Value,
PosterIp = rdr.SafeGetString(10),
LastPostAuthorId = rdr.SafeGetInt32(11),
IsSticky = rdr.GetInt16(12) == 1,
LastEditDate = rdr.GetSnitzDate(13),
LastEditedById = rdr.SafeGetInt32(14),
UseSignatures = rdr.GetInt16(15) == 1,
LastReplyId = rdr.SafeGetInt32(16),
UnModeratedReplies = rdr.GetInt32(17),
Message = rdr.SafeGetString(18)
};
if (rdr.FieldCount > 19)
{
topic.AuthorName = rdr.SafeGetString(19);
topic.LastPostAuthorName = rdr.SafeGetString(20);
topic.EditorName = rdr.SafeGetString(21);
if (rdr.FieldCount > 22)
{
topic.AuthorViewSig = rdr.GetInt16(22) == 1;
topic.AuthorSignature = rdr.SafeGetString(23);
}
}
}
catch (Exception)
{
return null;
}
return topic;
}
public static SearchResult CopySearchResultToBO(OleDbDataReader rdr, ref int rowcount)
{
SearchResult result = new SearchResult
{
CategoryStatus = rdr.GetInt16(0),
CategorySubscriptionLevel = rdr.GetInt32(1),
CategoryTitle = rdr.SafeGetString(2),
ForumSubject = rdr.SafeGetString(3),
ForumSubscriptionLevel = rdr.GetInt32(4),
ForumStatus = rdr.GetInt16(5),
ForumAccessType = rdr.GetInt32(6),
ForumPassword = rdr.SafeGetString(7),
CatId = rdr.GetInt32(8),
ForumId = rdr.GetInt32(9),
Id = rdr.GetInt32(10),
AuthorId = rdr.GetInt32(11),
Subject = rdr.SafeGetString(12),
Status = rdr.GetInt16(13),
LastPostDate = rdr.GetSnitzDate(14),
LastPostAuthorId = rdr.SafeGetInt32(15),
LastReplyId = rdr.SafeGetInt32(16),
ReplyCount = rdr.GetInt32(17),
UnModeratedReplies = rdr.GetInt32(18),
Views = rdr.GetInt32(19),
AuthorName = rdr.SafeGetString(21),
LastPostAuthorName = rdr.SafeGetString(22)
};
//rowcount = rdr.GetInt32(24);
return result;
}
public static ReplyInfo CopyReplyToBO(OleDbDataReader rdr)
{
ReplyInfo reply = new ReplyInfo
{
Id = rdr.GetInt32(0),
CatId = rdr.GetInt32(1),
ForumId = rdr.GetInt32(2),
TopicId = rdr.GetInt32(3),
AuthorId = rdr.GetInt32(4),
Date = rdr.GetSnitzDate(5).Value,
PosterIp = rdr.SafeGetString(6),
Status = rdr.GetInt16(7),
LastEditDate = rdr.GetSnitzDate(8),
LastEditedById = rdr.SafeGetInt32(9),
UseSignatures = rdr.GetInt16(10) == 1,
Message = rdr.SafeGetString(11)
};
if (rdr.FieldCount > 12)
{
reply.AuthorName = rdr.SafeGetString(12);
reply.EditorName = rdr.SafeGetString(13);
reply.AuthorViewSig = rdr.GetInt16(14) == 1;
reply.AuthorSignature = rdr.SafeGetString(15).Replace(">", "]").Replace("<", "[");
}
return reply;
}
