protected void Page_Load(object sender, EventArgs e)
{
btnAddToFav.Src = "http://" + HttpContext.Current.Request.Url.Host + "/Images/star.png";
var churchId = 0;
Sample();
if (Request["id"] == null && Page.RouteData.Values["church-id"] == null && Page.RouteData.Values["church-id"] == null)
{
return;
}
if (Request["id"] != null)
{
churchId = Convert.ToInt32(Request["id"]);
}
else if (Page.RouteData.Values["church-id"] != null)
{
churchId = Convert.ToInt32(Page.RouteData.Values["church-id"]);
}
var service = new ChurchService();
var favoriteService = new FavoritesService();
var timeStandard = new TimeStandard();
churches = service.Find(churchId);
Master.MetaTitle = $"{churches.MetaTitle}";
Master.MetaDescription = $"{churches.MetaDescription}";
maskData.Value = churches.MaskData;
simbahanID.Value = churchId.ToString();
churchName.InnerHtml = churches.Parish;
churchAddress.InnerHtml = churches.CompleteAddress;
churchLastUpdate.InnerHtml = churches.LastUpdate.ToString("MMM d, yyyy");
churchHistory.InnerHtml = HttpUtility.HtmlDecode(churches.ChurchHistory) == ""
? "<h3>No Data Available.</h3>"
: "<strong>" + churches.Parish + "</strong> " + HttpUtility.HtmlDecode(churches.ChurchHistory);
churchType.InnerHtml = ChurchType.parseInt(churches.ChurchTypeID);
churchEstablished.InnerHtml = churches.DateEstablished;
churchFeastDay.InnerHtml = churches.FeastDay;
churchPriest.InnerHtml = churches.Priest;
churchVicariate.InnerHtml = churches.Vicariate;
churchDiocese.InnerHtml = churches.Diocese;
churchContact.InnerHtml = churches.ContactNo;
churchWeb.HRef = "http://www." + churches.Website;
churchWebsite.InnerHtml = churches.Website;
adorationSchedule.InnerHtml = churches.AdorationDisplayText;
churchMapAddress.InnerHtml = churches.CompleteAddress;
churchMapDestination.Value = churches.CompleteAddress;
baptismSchedule.InnerHtml = churches.BaptismDetails;
weddingSchedule.InnerHtml = churches.WeddingDetails;
officeHours.InnerHtml = churches.OfficeHours;
devotionSchedule.InnerHtml = churches.DevotionSchedule;
latitude.Value = churches.Latitude.ToString();
longitude.Value = churches.Longitude.ToString();
editChurchHistory.InnerHtml = churches.ChurchHistory;
if (Auth.Check())
{
if (favoriteService.IsChurchAlreadyInFavorites(Auth.user().Id, churches.SimbahanID))
{
AddFav.Attributes.Add("style", "display: none;");
RemoveFav.Attributes.Add("style", "display: block;");
}
else
{
AddFav.Attributes.Add("style", "display: block;");
RemoveFav.Attributes.Add("style", "display: none;");
}
}
else
{
RemoveFav.Attributes.Add("style", "display: none");
}
List <MassDetailsModel> schedules;
switch (DateTime.UtcNow.DayOfWeek)
{
case DayOfWeek.Sunday:
schedules = churches.SundayMassSchedule;
break;
case DayOfWeek.Monday:
schedules = churches.MondayMassSchedule;
break;
case DayOfWeek.Tuesday:
schedules = churches.TuesdayMassSchedule;
break;
case DayOfWeek.Wednesday:
schedules = churches.WednesdayMassSchedule;
break;
case DayOfWeek.Thursday:
schedules = churches.ThursdayMassSchedule;
break;
case DayOfWeek.Friday:
schedules = churches.FridayMassSchedule;
break;
case DayOfWeek.Saturday:
schedules = churches.SaturdayMassSchedule;
break;
default:
schedules = new List <MassDetailsModel>();
break;
}
var languages = new List <string>();
var massSchedules = new List <string>();
foreach (var mass in schedules)
{
if (mass.Language != "" && !languages.Contains(mass.Language))
{
languages.Add(mass.Language);
}
massSchedules.Add(mass.Time);
}
var massDate = "No Mass Schedule for " + DateTime.UtcNow.DayOfWeek;
churchMassLanguages.Attributes.Add("style", "display: none;");
if (massSchedules.Count > 0)
{
massDate = DateTime.UtcNow.DayOfWeek + " - " + string.Join(", ", massSchedules);
churchMassLanguages.Attributes.Add("style", "display: block;");
}
churchMassDates.InnerHtml = massDate;
churchMassLanguages.InnerHtml = string.Join(", ", languages);
adorationChapelSchedule.InnerHtml = churches.AdorationDisplayText;
confessionSchedule.InnerHtml = churches.ConfessionDetails.Count > 0
? churches.ConfessionDetails[0].Text
: "";
if (!string.IsNullOrEmpty(churches.LocationType))
{
var locationLabel = new CheckLabel(churches.LocationType);
churchLocation.InnerHtml = locationLabel.ToHtml();
}
foreach (var ventilation in churches.Ventilations)
{
var ventilationLabel = new CheckLabel(ventilation.VentType);
churchVentilations.InnerHtml += ventilationLabel.ToHtml();
}
foreach (var ventilation in churches.AdorationVentilations)
{
var ventilationLabel = new CheckLabel(ventilation);
adorationVentilations.InnerHtml += ventilationLabel.ToHtml();
}
foreach (var parking in churches.ChurchParking)
{
var parkingLabel = new CheckLabel(parking.ParkingType);
churchParking.InnerHtml += parkingLabel.ToHtml();
}
for (var i = 5; i <= 22; i++)
{
var row = new HtmlTableRow();
var dayTime = new HtmlTableCell();
var sundayMass = new HtmlTableCell();
var mondayMass = new HtmlTableCell();
var tuesdayMass = new HtmlTableCell();
var wednesdayMass = new HtmlTableCell();
var thursdayMass = new HtmlTableCell();
var fridayMass = new HtmlTableCell();
var saturdayMass = new HtmlTableCell();
var sundayTime = churches.SundayMassSchedule.FirstOrDefault(schedule => schedule.TimeStandardId == i);
var mondayTime = churches.MondayMassSchedule.FirstOrDefault(schedule => schedule.TimeStandardId == i);
var tuesdayTime = churches.TuesdayMassSchedule.FirstOrDefault(schedule => schedule.TimeStandardId == i);
var wednesdayTime =
churches.WednesdayMassSchedule.FirstOrDefault(schedule => schedule.TimeStandardId == i);
var thursdayTime =
churches.ThursdayMassSchedule.FirstOrDefault(schedule => schedule.TimeStandardId == i);
var fridayTime = churches.FridayMassSchedule.FirstOrDefault(schedule => schedule.TimeStandardId == i);
var saturdayTime =
churches.SaturdayMassSchedule.FirstOrDefault(schedule => schedule.TimeStandardId == i);
dayTime.InnerHtml = timeStandard.Time[i - 1];
sundayMass.InnerHtml =
sundayTime != null ? sundayTime.Time + "<br/>" + sundayTime.Language : "";
mondayMass.InnerHtml =
mondayTime != null ? mondayTime.Time + "<br/>" + mondayTime.Language : "";
tuesdayMass.InnerHtml =
tuesdayTime != null ? tuesdayTime.Time + "<br/>" + tuesdayTime.Language : "";
wednesdayMass.InnerHtml =
wednesdayTime != null ? wednesdayTime.Time + "<br/>" + wednesdayTime.Language : "";
thursdayMass.InnerHtml =
thursdayTime != null ? thursdayTime.Time + "<br/>" + thursdayTime.Language : "";
fridayMass.InnerHtml =
fridayTime != null ? fridayTime.Time + "<br/>" + fridayTime.Language : "";
saturdayMass.InnerHtml =
saturdayTime != null ? saturdayTime.Time + "<br/>" + saturdayTime.Language : "";
row.Cells.Add(dayTime);
row.Cells.Add(sundayMass);
row.Cells.Add(mondayMass);
row.Cells.Add(tuesdayMass);
row.Cells.Add(wednesdayMass);
row.Cells.Add(thursdayMass);
row.Cells.Add(fridayMass);
row.Cells.Add(saturdayMass);
row.Attributes.Add("class", "text-center");
massScheduleTable.Rows.Add(row);
}
if (churches.Announcements.Count > 0)
{
foreach (var announcement in churches.Announcements)
{
var announcementControl = new Components.Announcement(announcement);
churchAnnouncementContainer.InnerHtml += announcementControl.ToHtml();
}
}
else
{
churchAnnouncementContainer.InnerHtml += "<h4>No Announcement Found.</h4>";
}
foreach (var review in churches.ChurchReviews)
{
var reviewItem = new Components.ChurchReview(review);
churchReviewsContainer.InnerHtml += reviewItem.ToHtml();
}
//var path = HttpContext.Current.Request.Url.AbsolutePath;
//string[] QueryArray = path.Split('/');
//var newPath = QueryArray[1];
//var root = QueryArray[0];
//if (newPath == "Churches")
//{
// ResolveUrl("Churches.aspx");
// var carousel = new Carousel();
// if (churches.ChurchPhotos.Count > 0)
// {
// //carousel.FirstImage = churches.ChurchPhotos[0].ChurchPhotos;
// for (var i = 0; i < churches.ChurchPhotos.Count; i++)
// carousel.AddImage(i, churches.ChurchPhotos[i].ChurchPhotos);
// cssSlider.InnerHtml = carousel.ToHtml();
// }
// else
// {
// cssSlider.InnerHtml = "<h3 class=\"text-center\">No Photos Available.</h3>";
// }
//} else
//{
var carousel = new Carousel();
if (churches.ChurchPhotos.Count > 0)
{
//carousel.FirstImage = churches.ChurchPhotos[0].ChurchPhotos;
for (var i = 0; i < churches.ChurchPhotos.Count; i++)
{
carousel.AddImage(i, churches.ChurchPhotos[i].ChurchPhotos);
}
cssSlider.InnerHtml = carousel.ToHtml();
}
else
{
cssSlider.InnerHtml = "<h3 class=\"text-center\">No Photos Available.</h3>";
}
//}
if (churches.AdorationPhotos.Count > 0)
{
for (var i = 0; i < churches.AdorationPhotos.Count; i++)
{
var imagePath = ResolveUrl(churches.AdorationPhotos[i]);
var newLi = new HtmlGenericControl("li")
{
InnerHtml = "<img src=\"" + imagePath +
"\" alt=\"\" title=\"\" id=\"wows1_" + i + "\" />"
};
adorationImageList.Controls.Add(newLi);
var newA = new HtmlGenericControl("a");
newA.Attributes.Add("href", "#");
newA.InnerHtml = "<a href=\"#\" title=\"\"><span><img src=\"" + imagePath +
"\" alt=\"\" />" + (i + 1) + "</span></a>";
adorationLinkList.Controls.Add(newA);
}
}
else
{
adorationImageContainer.InnerHtml = "<h3>No Photos Available</h3>";
}
Master.GoogleMetaDescription = massDate;
Page.Title = churches.Parish;
}
protected void Page_Init(object sender, EventArgs e)
{
GoogleMetaDescription = "Your single access to all your catholic needs.";
if (Page.RouteData.Values["bible-verse-id"] != null)
{
var bibleVerseService = new BibleVerseService();
var verse = bibleVerseService.Find(Convert.ToInt32(Page.RouteData.Values["bible-verse-id"]));
MetaDescription = verse.BibleVerseContent;
GoogleMetaDescription = MetaDescription;
MetaTitle = "Bible Verse";
MetaUrl = "http://www.mycatholicportal.org/BibleVerse.aspx";
MetaImage = "http://www.mycatholicportal.org/Images/BibleVerse.png";
}
if (Page.RouteData.Values["religious-quote-id"] != null)
{
var religiousQuoteService = new ReligiousQuoteService();
var religiousQuote =
religiousQuoteService.Find(Convert.ToInt32(Page.RouteData.Values["religious-quote-id"]));
MetaDescription = religiousQuote.Quote;
GoogleMetaDescription = MetaDescription;
MetaTitle = "Religious Quote";
MetaUrl = "http://www.mycatholicportal.org/ReligiousQuote.aspx";
MetaImage = "http://www.mycatholicportal.org/Images/RelQuotes.png";
}
if (Page.RouteData.Values["music-id"] != null)
{
var musicalInspirationService = new MusicalInspirationService();
var music =
musicalInspirationService.Find(Convert.ToInt32(Page.RouteData.Values["music-id"]));
MetaDescription = "Currently playing " + music.SongTitle + " by " + music.Artist;
GoogleMetaDescription = MetaDescription;
MetaTitle = "Musical Inspiration";
MetaUrl = "http://www.mycatholicportal.org/MusicalInspirations.aspx";
MetaImage = "http://www.mycatholicportal.org/Images/Musical.png";
}
if (Page.RouteData.Values["church-id"] != null)
{
var churchService = new ChurchService();
var church = churchService.Find(Convert.ToInt32(Page.RouteData.Values["church-id"]));
char[] separator = { ',' };
MetaTitle = church.Parish;
MetaDescription = church.ChurchHistory.Split(separator)[0];
GoogleMetaDescription = MetaDescription;
MetaUrl = "http://www.mycatholicportal.org/Church/" + church.SimbahanID;
MetaImage = church.ChurchPhotos.Count > 0
? "http://www.mycatholicportal.org/Images/" + church.ChurchPhotos[0].ChurchPhotos
: "";
}
if (Page.RouteData.Values["organization-id"] != null)
{
var organizationService = new OrganizationService();
var church = organizationService.Find(Convert.ToInt32(Page.RouteData.Values["organization-id"]));
char[] separator = { ',' };
MetaTitle = church.Name;
MetaDescription = "";
MetaUrl = "http://www.mycatholicportal.org/Organization/" + church.Id;
MetaImage = "";
}
if (Page.RouteData.Values["devote-id"] != null)
{
var devotionService = new DevotionService();
var devotion = devotionService.Find(Convert.ToInt32(Page.RouteData.Values["devote-id"]));
char[] separator = { ',' };
MetaTitle = devotion.Title;
MetaDescription = devotion.Prayer.Split(separator)[0];
GoogleMetaDescription = MetaDescription;
MetaUrl = "http://www.mycatholicportal.org/Dvote/" + devotion.Id;
//MetaImage = church.ChurchPhotos.Count > 0 ? "http://www.mycatholicportal.org/Images/" + church.ChurchPhotos[0].ChurchPhotos : "";
}
if (Page.RouteData.Values["prayer-id"] != null)
{
var bcpService = new BasicCatholicPrayerService();
var bcp = bcpService.Find(Convert.ToInt32(Page.RouteData.Values["prayer-id"]));
char[] separator = { ',' };
MetaTitle = bcp.Title;
MetaDescription = bcp.Prayer.Split(separator)[0];
GoogleMetaDescription = MetaDescription;
MetaUrl = "http://www.mycatholicportal.org/Prayer/" + bcp.Id;
//MetaImage = church.ChurchPhotos.Count > 0 ? "http://www.mycatholicportal.org/Images/" + church.ChurchPhotos[0].ChurchPhotos : "";
}
if (Page.RouteData.Values["other-prayer-id"] != null)
{
var ocpService = new OtherCatholicPrayerService();
var ocp = ocpService.Find(Convert.ToInt32(Page.RouteData.Values["other-prayer-id"]));
char[] separator = { ',' };
MetaTitle = ocp.Title;
MetaDescription = ocp.Prayer.Split(separator)[0];
GoogleMetaDescription = MetaDescription;
MetaUrl = "http://www.mycatholicportal.org/OtherPrayer/" + ocp.Id;
//MetaImage = church.ChurchPhotos.Count > 0 ? "http://www.mycatholicportal.org/Images/" + church.ChurchPhotos[0].ChurchPhotos : "";
}
if (Page.RouteData.Values["saint-id"] != null)
{
var saintService = new SaintService();
var saint = saintService.Find(Convert.ToInt32(Page.RouteData.Values["saint-id"]));
MetaTitle = saint.Name;
MetaDescription = saint.Biography;
GoogleMetaDescription = MetaDescription;
MetaUrl = "http://www.mycatholicportal.org/Saint/" + saint.Id;
}
if (Page.RouteData.Values["gospel-id"] != null)
{
var dailyGospelService = new DailyGospelService();
int id;
Models.DailyGospel gospel;
if (int.TryParse(Page.RouteData.Values["gospel-id"].ToString(), out id))
{
gospel = dailyGospelService.Find(id);
}
else if (Page.RouteData.Values["gospel-id"].ToString().Length > 1)
{
gospel = dailyGospelService.FindByDate(Convert.ToDateTime(Page.RouteData.Values["gospel-id"]));
}
else
{
gospel = dailyGospelService.FindByDate(DateTime.Now);
}
MetaDescription = gospel.FirstReadingContent;
GoogleMetaDescription = MetaDescription;
MetaTitle = "Daily Gospel";
MetaUrl = "http://www.mycatholicportal.org/Gospel/" + gospel.Id;
MetaImage = "http://www.mycatholicportal.org/Images/dailyreadings.jpg";
}
if (Page.RouteData.Values["daily-reflection-id"] != null)
{
var reflectionService = new DailyReflectionService();
int id;
Models.DailyReflection reflection;
if (int.TryParse(Page.RouteData.Values["daily-reflection-id"].ToString(), out id))
{
reflection = reflectionService.Find(id);
}
else if (Page.RouteData.Values["daily-reflection-id"].ToString().Length > 1)
{
reflection =
reflectionService.FindByDate(Convert.ToDateTime(Page.RouteData.Values["daily-reflection-id"]));
}
else
{
reflection = reflectionService.FindByDate(DateTime.Now);
}
MetaDescription = reflection.FirstContentTitle;
GoogleMetaDescription = MetaDescription;
MetaTitle = "Daily Reflection";
MetaImage = "http://www.mycatholicportal.org/Images/dailyreadings.jpg";
MetaUrl = "http://www.mycatholicportal.org/Reflection/" + reflection.Id;
}
if (Page.RouteData.Values["announcement-id"] != null)
{
var announcementService = new AnnouncementService();
var announcement = announcementService.Find(Convert.ToInt32(Page.RouteData.Values["announcement-id"]));
char[] separator = { ',' };
MetaTitle = announcement.Title;
MetaDescription = announcement.Description;
GoogleMetaDescription = MetaDescription;
MetaUrl = "http://www.mycatholicportal.org/Announcement/" + announcement.Id;
//MetaImage = church.ChurchPhotos.Count > 0 ? "http://www.mycatholicportal.org/Images/" + church.ChurchPhotos[0].ChurchPhotos : "";
}
// The code below helps to protect against XSRF attacks
var requestCookie = Request.Cookies[AntiXsrfTokenKey];
Guid requestCookieGuidValue;
if (requestCookie != null && Guid.TryParse(requestCookie.Value, out requestCookieGuidValue))
{
// Use the Anti-XSRF token from the cookie
_antiXsrfTokenValue = requestCookie.Value;
Page.ViewStateUserKey = _antiXsrfTokenValue;
}
else
{
// Generate a new Anti-XSRF token and save to the cookie
_antiXsrfTokenValue = Guid.NewGuid().ToString("N");
Page.ViewStateUserKey = _antiXsrfTokenValue;
var responseCookie = new HttpCookie(AntiXsrfTokenKey)
{
HttpOnly = true,
Value = _antiXsrfTokenValue
};
if (FormsAuthentication.RequireSSL && Request.IsSecureConnection)
{
responseCookie.Secure = true;
}
Response.Cookies.Set(responseCookie);
}
Page.PreLoad += master_Page_PreLoad;
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
int simbahanId = Convert.ToInt32(Request["id"]);
using (SqlConnection dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString))
{
if (dbconn.State == ConnectionState.Open)
{
dbconn.Close();
}
dbconn.Open();
//Table Simabahan
//using (SqlCommand cmd = new SqlCommand("SELECT SimbahanID, Parish, CompleteAddress, City, StateOrProvince, Vicariate, FeastDay, ParishPriest, Diocese, DateEstablished, ContactNo, EmailAddress, Website, LocationID, HasAdorationChapel, OfficeHours, DevotionSchedule FROM Simbahan where SimbahanID = " + simbahanId, dbconn))
//using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
var churchService = new ChurchService();
var church = churchService.Find(simbahanId);
//using (DataTable table = new DataTable())
{
//adapter.Fill(table);
try
{
churchName.Value = church.Parish;
address.Value = church.CompleteAddress;
city.Value = church.City;
province.Value = church.StateProvince;
vicariate.Value = church.Vicariate;
feastDay.Value = church.FeastDay;
parishPriest.Value = church.Priest;
diocese.Value = church.Diocese;
dateEstablished.Value = church.DateEstablished;
phoneNo.Value = church.ContactNo;
emailAdd.Value = church.EmailAddress;
website.Value = church.Website;
OfficeSchedule.Value = church.OfficeHours;
SchedOfDevotion.Value = church.DevotionSchedule;
int locID;
if (Convert.IsDBNull(church.LocationID))
{
locID = 0;
}
else
{
locID = Convert.ToInt32(church.LocationID);
}
int HasAdo;
if (Convert.IsDBNull(church.HasAdorationChapel))
{
HasAdo = 0;
}
else
{
HasAdo = Convert.ToInt32(church.HasAdorationChapel);
}
//LocationID
if (locID == 1)
{
locSeparate.Checked = true;
}
else if (locID == 2)
{
locConvent.Checked = true;
}
else if (locID == 3)
{
locMall.Checked = true;
}
else if (locID == 5)
{
locHospital.Checked = true;
}
else if (locID == 4)
{
locSchool.Checked = true;
}
if (HasAdo == 0)
{
hasAdoNo.Checked = true;
}
else if (HasAdo == 1)
{
hasAdoYes.Checked = true;
}
}
catch (Exception ex)
{
}
}
SimbahanId.Value = simbahanId.ToString();
SimbahanVentilation();
SimbahanParking();
Adoration();
AdorationVentulation();
MassDetails();
ConfessionDetails();
AdorationDetails();
BaptismSchedules();
WeddingSchedules();
EventDetails();
adoration();
}
}
