protected void Page_Load(object sender, EventArgs e)
{
using (SqlConnection dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString))
{
if (dbconn.State == ConnectionState.Open)
{
dbconn.Close();
}
dbconn.Open();
var favoriteService = new FavoritesService();
if (Auth.Check())
//if (favoriteService.IsChurchAlreadyInFavorites(Auth.user().Id, churchh.SimbahanID))
{
//AddFav.Attributes.Add("style", "display: none;");
//RemoveFav.Attributes.Add("style", "display: block;");
}
if (Auth.Check())
{
Name.InnerHtml = Auth.user().FullName;
firstName.InnerHtml = Auth.user().FirstName;
lastName.InnerHtml = Auth.user().LastName;
email.InnerHtml = Auth.user().Email;
gender.InnerHtml = Auth.user().Gender;
birthday.InnerHtml = Auth.user().DateOfBirth;
if (Auth.user().RoleID == 3)
{
manage.Attributes["href"] = "#" + tab5.ClientID;
SqlCommand cmd = new SqlCommand("SELECT Simbahan.SimbahanID, Simbahan.Parish FROM Simbahan INNER JOIN ChurchRoles ON ChurchRoles.SimbahanID = Simbahan.SimbahanID WHERE ChurchRoles.RegID = '" + Auth.user().Id + "'", dbconn);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var li = new HtmlGenericControl("li");
li.InnerHtml = string.Format("<a href=\"{0}\">{1}</a>", "http://www.mycatholicportal.org/Churches?id=" + reader["SimbahanID"], reader["Parish"]);
ManageableChurch.Controls.Add(li);
}
tab5.Visible = true;
manage.Visible = true;
}
else
{
tab5.Visible = false;
manage.Visible = false;
}
var churches = favoriteService.GetFavoriteChurches(Auth.user().Id);
favoriteChurches.InnerHtml = "";
foreach (var church in churches)
{
var churchItem = new ChurchItem(church.SimbahanID, church.Parish, church.CompleteAddress,
church.ChurchPhotos[0].ChurchPhotos);
favoriteChurches.InnerHtml += churchItem.ToHtml();
}
var favoriteServices = new FavoritesService();
var announcements = favoriteServices.GetFavoriteAnnouncements(Auth.user().Id);
favoriteAnnouncements.InnerHtml = "";
foreach (var announcement in announcements)
{
var announcementItem = new AnnouncementItem(announcement.SimbahanId, announcement.Title, announcement.Venue,
announcement.ImagePath);
favoriteAnnouncements.InnerHtml += announcementItem.ToHtml();
}
var favoriteServicess = new FavoritesService();
var organnouncements = favoriteServices.GetFavoriteOrgAnnouncements(Auth.user().Id);
favoriteAnnouncementss.InnerHtml = "";
foreach (var organnouncement in organnouncements)
{
var announcementItem = new OrganizationAnnouncementItem(organnouncement.Id, organnouncement.OrganizationId, organnouncement.Title, organnouncement.Venue,
organnouncement.ImagePath);
favoriteAnnouncementss.InnerHtml += announcementItem.ToHtml();
}
var organizations = favoriteService.GetFavoriteOrganizations(Auth.user().Id);
favoriteOrganizations.InnerHtml = "";
foreach (var organization in organizations)
{
var organizationItem =
new OrganizationItem(organization.Id, organization.Name, organization.Address, "");
favoriteOrganizations.InnerHtml += organizationItem.ToHtml();
}
var verses = favoriteService.GetFavoriteBibleVerses(Auth.user().Id);
favoriteBibleVerses.InnerHtml = "";
foreach (var verse in verses)
{
var verseItem = new BibleVerseItem(verse);
favoriteBibleVerses.InnerHtml += verseItem.ToHtml();
}
var quotes = favoriteService.GetFavoriteReligiousQuotes(Auth.user().Id);
favoriteReligiousQuotes.InnerHtml = "";
foreach (var quote in quotes)
{
var quoteItem = new ReligiousQuoteItem(quote);
favoriteReligiousQuotes.InnerHtml += quoteItem.ToHtml();
}
var prayers = favoriteService.GetFavoriteBasicCatholicPrayer(Auth.user().Id);
favoriteBasicCatholicPrayers.InnerHtml = "";
foreach (var prayer in prayers)
{
var prayerItem = new BasicCatholicPrayerItem(prayer);
favoriteBasicCatholicPrayers.InnerHtml += prayerItem.ToHtml();
}
var devotes = favoriteService.GetFavoriteDevotion(Auth.user().Id);
favoriteDevotions.InnerHtml = "";
foreach (var devote in devotes)
{
var devoteItem = new DevotionItem(devote);
favoriteDevotions.InnerHtml += devoteItem.ToHtml();
}
var otps = favoriteService.GetFavoriteOtherCatholicPrayer(Auth.user().Id);
favoriteOtherCatholicPrayers.InnerHtml = "";
foreach (var otp in otps)
{
var otpItem = new OtherCatholicPrayerItem(otp);
favoriteOtherCatholicPrayers.InnerHtml += otpItem.ToHtml();
}
var saints = favoriteService.GetFavoriteSaint(Auth.user().Id);
favoriteSaints.InnerHtml = "";
//var favoriteService = new FavoritesService();
foreach (var saint in saints)
{
var saintItem = new SaintItem(saint);
favoriteSaints.InnerHtml += saintItem.ToHtml();
}
}
else
{
Response.Redirect("Login.aspx");
}
getUnreadDocuments();
countii();
}
}