public List <ChurchInfo> GetCoordinates(Coordinate coordinate, int limit)
{
var churches = new List <ChurchInfo>();
using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString))
{
if (dbconn.State == ConnectionState.Open)
{
dbconn.Close();
}
dbconn.Open();
using (var cmd = new SqlCommand("spGetChurchesNearby", dbconn))
{
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@latitude", coordinate.Latitude);
cmd.Parameters.AddWithValue("@longitude", coordinate.Longitude);
cmd.Parameters.AddWithValue("@limit", limit);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var church = _churchTransformer.Transform(reader);
// Ventilation Processing...
char[] separator = { ',' };
var ventilations = reader["Ventilations"]
.ToString()
.Split(separator, StringSplitOptions.None);
foreach (var ventilation in ventilations)
{
church.Ventilations.Add(new VentilationModel {
VentType = ventilation
});
}
// Mass Schedules Processing...
if (!Convert.IsDBNull(reader["MassSchedules"]))
{
var schedules = reader["MassSchedules"]
.ToString()
.Split(separator, StringSplitOptions.None);
foreach (var schedule in schedules)
{
char[] pipeSeparator = { '|' };
var massSchedule = schedule.Split(pipeSeparator, StringSplitOptions.None);
var massDetail =
new MassDetailsModel
{
Id = massSchedule[0] == "" ? 0 : Convert.ToInt32(massSchedule[0]),
Language = massSchedule[2],
Time = massSchedule[3],
TimeStandardId =
massSchedule[4] == "" ? 0 : Convert.ToInt32(massSchedule[4]),
DateCreated = massSchedule[5] == ""
? DateTime.UtcNow
: Convert.ToDateTime(massSchedule[5])
};
switch (Convert.ToInt32(massSchedule[1]))
{
case 1:
massDetail.Days = "Sunday";
massDetail.ScheduleId = 1;
church.SundayMassSchedule.Add(massDetail);
break;
case 2:
massDetail.Days = "Monday";
massDetail.ScheduleId = 2;
church.MondayMassSchedule.Add(massDetail);
break;
case 3:
massDetail.Days = "Tuesday";
massDetail.ScheduleId = 3;
church.TuesdayMassSchedule.Add(massDetail);
break;
case 4:
massDetail.Days = "Wednesday";
massDetail.ScheduleId = 4;
church.WednesdayMassSchedule.Add(massDetail);
break;
case 5:
massDetail.Days = "Thursday";
massDetail.ScheduleId = 5;
church.ThursdayMassSchedule.Add(massDetail);
break;
case 6:
massDetail.Days = "Friday";
massDetail.ScheduleId = 6;
church.FridayMassSchedule.Add(massDetail);
break;
case 7:
massDetail.Days = "Saturday";
massDetail.ScheduleId = 7;
church.SaturdayMassSchedule.Add(massDetail);
break;
}
}
}
switch (DateTime.UtcNow.DayOfWeek)
{
case DayOfWeek.Sunday:
church.MassSchedules = church.SundayMassSchedule;
break;
case DayOfWeek.Monday:
church.MassSchedules = church.MondayMassSchedule;
break;
case DayOfWeek.Tuesday:
church.MassSchedules = church.TuesdayMassSchedule;
break;
case DayOfWeek.Wednesday:
church.MassSchedules = church.WednesdayMassSchedule;
break;
case DayOfWeek.Thursday:
church.MassSchedules = church.ThursdayMassSchedule;
break;
case DayOfWeek.Friday:
church.MassSchedules = church.FridayMassSchedule;
break;
case DayOfWeek.Saturday:
church.MassSchedules = church.SaturdayMassSchedule;
break;
}
// Church Reviews Processing...
var reviews = reader["Reviews"].ToString().Split(separator, StringSplitOptions.None);
foreach (var review in reviews)
{
church.ChurchReviews.Add(new ChurchReview
{
Comment = review
});
}
// Church Photos Processing...
var photos = reader["ChurchPhotos"].ToString().Split(separator, StringSplitOptions.None);
foreach (var photo in photos)
{
church.ChurchPhotos.Add(new ChurchPhotosModel
{
ChurchPhotos = photo == string.Empty ? "" : @"Images\Photos\" + photo
});
}
// Baptism
church.BaptismDetails = reader["BaptismSched"].ToString();
// Confession
char[] splitter = { ',', '|' };
var confession = reader["ConfessionSched"]
.ToString()
.Split(splitter, StringSplitOptions.None);
if (confession.Length > 1)
{
int i = 0, j = 1;
for (; i < confession.Length;)
{
church.ConfessionDetails.Add(new ConfessionSchedule
{
Confess_Day = confession[i],
Confess_Time = confession[j]
});
i = i + 2;
j = j + 2;
}
}
// Wedding
church.WeddingDetails = reader["WeddingSched"].ToString();
// Parking
var parkings = reader["ParkingSlot"].ToString().Split(separator, StringSplitOptions.None);
foreach (var parking in parkings)
{
church.ChurchParking.Add(new ParkingSlot {
ParkingType = parking
});
}
churches.Add(church);
}
}
catch (Exception)
{
// ignored
}
}
}
return(churches);
}
public List <ChurchInfo> Search(string parish, string stateProvince, string churchTypeId,
string churchLocationId,
string hasAdorationChapel, string massScheduleId, string massTime, string massLanguage,
string confessionTime, string confessionScheduleId, string ventilation, string parking,
string countryId)
{
var churches = new List <ChurchInfo>();
using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString))
{
if (dbconn.State == ConnectionState.Open)
{
dbconn.Close();
}
dbconn.Open();
using (var cmd = new SqlCommand("spSearchChurches", dbconn))
{
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@parish", parish);
cmd.Parameters.AddWithValue("@stateOrProvince", stateProvince);
cmd.Parameters.AddWithValue("@churchTypeID", churchTypeId);
cmd.Parameters.AddWithValue("@churchLocationID", churchLocationId);
cmd.Parameters.AddWithValue("@hasAdorationChapel", hasAdorationChapel);
cmd.Parameters.AddWithValue("@massScheduleID", massScheduleId);
cmd.Parameters.AddWithValue("@massTime", massTime);
cmd.Parameters.AddWithValue("@massLanguage", massLanguage);
cmd.Parameters.AddWithValue("@confessionScheduleID", confessionScheduleId);
cmd.Parameters.AddWithValue("@confessionTime", confessionTime);
cmd.Parameters.AddWithValue("@ventilation", ventilation);
cmd.Parameters.AddWithValue("@parking", parking);
cmd.Parameters.AddWithValue("@countries", countryId);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var church = _churchTransformer.Transform(reader);
// Ventilation Processing...
char[] separator = { ',' };
var ventilations = reader["Ventilations"]
.ToString()
.Split(separator, StringSplitOptions.None);
foreach (var ventilationItem in ventilations)
{
church.Ventilations.Add(new VentilationModel {
VentType = ventilationItem
});
}
// Mass Schedules Processing...
if (!Convert.IsDBNull(reader["MassSchedules"]))
{
var schedules = reader["MassSchedules"]
.ToString()
.Split(separator, StringSplitOptions.None);
foreach (var schedule in schedules)
{
char[] pipeSeparator = { '|' };
var massSchedule = schedule.Split(pipeSeparator, StringSplitOptions.None);
var massDetail =
new MassDetailsModel
{
Id = massSchedule[0] == "" ? 0 : Convert.ToInt32(massSchedule[0]),
Language = massSchedule[2],
Time = massSchedule[3],
TimeStandardId =
massSchedule[4] == "" ? 0 : Convert.ToInt32(massSchedule[4]),
DateCreated = massSchedule[5] == ""
? DateTime.UtcNow
: Convert.ToDateTime(massSchedule[5])
};
switch (Convert.ToInt32(massSchedule[1]))
{
case 1:
massDetail.Days = "Sunday";
massDetail.ScheduleId = 1;
church.SundayMassSchedule.Add(massDetail);
break;
case 2:
massDetail.Days = "Monday";
massDetail.ScheduleId = 2;
church.MondayMassSchedule.Add(massDetail);
break;
case 3:
massDetail.Days = "Tuesday";
massDetail.ScheduleId = 3;
church.TuesdayMassSchedule.Add(massDetail);
break;
case 4:
massDetail.Days = "Wednesday";
massDetail.ScheduleId = 4;
church.WednesdayMassSchedule.Add(massDetail);
break;
case 5:
massDetail.Days = "Thursday";
massDetail.ScheduleId = 5;
church.ThursdayMassSchedule.Add(massDetail);
break;
case 6:
massDetail.Days = "Friday";
massDetail.ScheduleId = 6;
church.FridayMassSchedule.Add(massDetail);
break;
case 7:
massDetail.Days = "Saturday";
massDetail.ScheduleId = 7;
church.SaturdayMassSchedule.Add(massDetail);
break;
default:
massDetail.Days = DateTime.UtcNow.DayOfWeek.ToString();
massDetail.ScheduleId = (int)DateTime.UtcNow.DayOfWeek + 1;
church.MondayMassSchedule.Add(massDetail);
break;
}
}
}
if (massScheduleId != string.Empty)
{
switch (massScheduleId)
{
case "1":
church.MassSchedules = church.SundayMassSchedule;
break;
case "2":
church.MassSchedules = church.MondayMassSchedule;
break;
case "3":
church.MassSchedules = church.TuesdayMassSchedule;
break;
case "4":
church.MassSchedules = church.WednesdayMassSchedule;
break;
case "5":
church.MassSchedules = church.ThursdayMassSchedule;
break;
case "6":
church.MassSchedules = church.FridayMassSchedule;
break;
case "7":
church.MassSchedules = church.SaturdayMassSchedule;
break;
default:
church.MassSchedules = church.MondayMassSchedule;
break;
}
}
else
{
switch (DateTime.UtcNow.DayOfWeek)
{
case DayOfWeek.Sunday:
church.MassSchedules = church.SundayMassSchedule;
break;
case DayOfWeek.Monday:
church.MassSchedules = church.MondayMassSchedule;
break;
case DayOfWeek.Tuesday:
church.MassSchedules = church.TuesdayMassSchedule;
break;
case DayOfWeek.Wednesday:
church.MassSchedules = church.WednesdayMassSchedule;
break;
case DayOfWeek.Thursday:
church.MassSchedules = church.ThursdayMassSchedule;
break;
case DayOfWeek.Friday:
church.MassSchedules = church.FridayMassSchedule;
break;
case DayOfWeek.Saturday:
church.MassSchedules = church.SaturdayMassSchedule;
break;
}
}
// Church Reviews Processing...
var reviews = reader["Reviews"].ToString().Split(separator, StringSplitOptions.None);
foreach (var review in reviews)
{
church.ChurchReviews.Add(new ChurchReview
{
Comment = review
});
}
// Church Photos Processing...
var photos = reader["ChurchPhotos"].ToString().Split(separator, StringSplitOptions.None);
bool thumbnailFound = false;
for (int i = 0; i < photos.Length; i++)
{
var photo = photos[i];
string thumbnailPath = ChurchPhoto.GetChurchThumbnail(church.SimbahanID, photo);
if (thumbnailPath != "")
{
thumbnailFound = true;
church.ChurchThumbnails.Add(new ChurchPhotosModel
{
ChurchPhotos = thumbnailPath
});
}
church.ChurchPhotos.Add(new ChurchPhotosModel
{
ChurchPhotos = photo == string.Empty ? "" : @"Images\Photos\" + photo
});
if (photos.Length == i + 1)
{
if (thumbnailFound == false)
{
church.ChurchThumbnails.Add(new ChurchPhotosModel
{
ChurchPhotos = Helpers.GenerateURL(@"Images\default.jpg")
});
}
}
}
// Baptism
church.BaptismDetails = reader["BaptismSched"].ToString();
// Confession
char[] splitter = { ',', '|' };
var confession = reader["ConfessionSched"]
.ToString()
.Split(splitter, StringSplitOptions.None);
if (confession.Length > 1)
{
int i = 0, j = 1;
for (; i < confession.Length;)
{
church.ConfessionDetails.Add(new ConfessionSchedule
{
Confess_Day = confession[i],
Confess_Time = confession[j]
});
i = i + 2;
j = j + 2;
}
}
// Wedding
church.WeddingDetails = reader["WeddingSched"].ToString();
// Parking
var parkings = reader["ParkingSlot"].ToString().Split(separator, StringSplitOptions.None);
foreach (var parkingItem in parkings)
{
church.ChurchParking.Add(new ParkingSlot {
ParkingType = parkingItem
});
}
churches.Add(church);
}
}
catch (Exception)
{
// ignored
}
}
}
return(churches);
}
public List <Church> Search(string parish, string stateProvince, string churchTypeId,
string churchLocationId,
string hasAdorationChapel, string massScheduleId, string massTime, string massLanguage,
string confessionTime, string confessionScheduleId, string ventilation, string parking,
string countryId)
{
var churches = new List <Church>();
using (var sp = new StoredProcedure("spSearchChurches"))
{
sp.SqlCommand.Parameters.AddWithValue("@parish", parish);
sp.SqlCommand.Parameters.AddWithValue("@stateOrProvince", stateProvince);
sp.SqlCommand.Parameters.AddWithValue("@churchTypeID", churchTypeId);
sp.SqlCommand.Parameters.AddWithValue("@churchLocationID", churchLocationId);
sp.SqlCommand.Parameters.AddWithValue("@hasAdorationChapel", hasAdorationChapel);
sp.SqlCommand.Parameters.AddWithValue("@massScheduleID", massScheduleId);
sp.SqlCommand.Parameters.AddWithValue("@massTime", massTime);
sp.SqlCommand.Parameters.AddWithValue("@massLanguage", massLanguage);
sp.SqlCommand.Parameters.AddWithValue("@confessionScheduleID", confessionScheduleId);
sp.SqlCommand.Parameters.AddWithValue("@confessionTime", confessionTime);
sp.SqlCommand.Parameters.AddWithValue("@ventilation", ventilation);
sp.SqlCommand.Parameters.AddWithValue("@parking", parking);
sp.SqlCommand.Parameters.AddWithValue("@countries", countryId);
var reader = sp.SqlCommand.ExecuteReader();
while (reader.Read())
{
var church = _churchTransformer.Transform(reader);
// Ventilation Processing...
char[] separator = { ',' };
var ventilations = reader["Ventilations"]
.ToString()
.Split(separator, StringSplitOptions.None);
foreach (var ventilationItem in ventilations)
{
church.Ventilations.Add(ventilationItem);
}
// Mass Schedules Processing...
if (!Convert.IsDBNull(reader["MassSchedules"]))
{
var schedules = reader["MassSchedules"]
.ToString()
.Split(separator, StringSplitOptions.None);
foreach (var schedule in schedules)
{
char[] pipeSeparator = { '|' };
var massSchedule = schedule.Split(pipeSeparator, StringSplitOptions.None);
var massDetail =
new MassDetailsModel
{
Id = massSchedule[0] == "" ? 0 : Convert.ToInt32(massSchedule[0]),
Language = massSchedule[2],
Time = massSchedule[3],
TimeStandardId =
massSchedule[4] == "" ? 0 : Convert.ToInt32(massSchedule[4]),
DateCreated = massSchedule[5] == ""
? DateTime.UtcNow
: Convert.ToDateTime(massSchedule[5])
};
switch (Convert.ToInt32(massSchedule[1]))
{
case 1:
massDetail.Days = "Sunday";
massDetail.ScheduleId = 1;
church.SundayMassSchedule.Add(massDetail);
break;
case 2:
massDetail.Days = "Monday";
massDetail.ScheduleId = 2;
church.MondayMassSchedule.Add(massDetail);
break;
case 3:
massDetail.Days = "Tuesday";
massDetail.ScheduleId = 3;
church.TuesdayMassSchedule.Add(massDetail);
break;
case 4:
massDetail.Days = "Wednesday";
massDetail.ScheduleId = 4;
church.WednesdayMassSchedule.Add(massDetail);
break;
case 5:
massDetail.Days = "Thursday";
massDetail.ScheduleId = 5;
church.ThursdayMassSchedule.Add(massDetail);
break;
case 6:
massDetail.Days = "Friday";
massDetail.ScheduleId = 6;
church.FridayMassSchedule.Add(massDetail);
break;
case 7:
massDetail.Days = "Saturday";
massDetail.ScheduleId = 7;
church.SaturdayMassSchedule.Add(massDetail);
break;
}
}
}
switch (DateTime.UtcNow.DayOfWeek)
{
case DayOfWeek.Sunday:
church.MassSchedules = church.SundayMassSchedule;
break;
case DayOfWeek.Monday:
church.MassSchedules = church.MondayMassSchedule;
break;
case DayOfWeek.Tuesday:
church.MassSchedules = church.TuesdayMassSchedule;
break;
case DayOfWeek.Wednesday:
church.MassSchedules = church.WednesdayMassSchedule;
break;
case DayOfWeek.Thursday:
church.MassSchedules = church.ThursdayMassSchedule;
break;
case DayOfWeek.Friday:
church.MassSchedules = church.FridayMassSchedule;
break;
case DayOfWeek.Saturday:
church.MassSchedules = church.SaturdayMassSchedule;
break;
}
// Church Reviews Processing...
var reviews = reader["Reviews"].ToString().Split(separator, StringSplitOptions.None);
foreach (var review in reviews)
{
church.ChurchReviews.Add(new ChurchReview
{
Comment = review
});
}
// Church Photos Processing...
var photos = reader["ChurchPhotos"].ToString().Split(separator, StringSplitOptions.None);
foreach (var photo in photos)
{
church.ChurchThumbnails.Add(
photo == string.Empty ? "" : @"Images\Photos\Thumbnails\" + photo
);
church.ChurchPhotos.Add(
photo == string.Empty ? "" : @"Images\Photos\" + photo
);
}
// Baptism
church.BaptismDetails = reader["BaptismSched"].ToString();
// Confession
char[] splitter = { ',', '|' };
var confession = reader["ConfessionSched"]
.ToString()
.Split(splitter, StringSplitOptions.None);
if (confession.Length > 1)
{
int i = 0, j = 1;
for (; i < confession.Length;)
{
church.ConfessionDetails.Add(new ConfessionSchedule
{
Day = confession[i],
Time = confession[j]
});
i = i + 2;
j = j + 2;
}
}
// Wedding
church.WeddingDetails = reader["WeddingSched"].ToString();
// Parking
var parkings = reader["ParkingSlot"].ToString().Split(separator, StringSplitOptions.None);
foreach (var parkingItem in parkings)
{
church.ChurchParking.Add(parkingItem);
}
churches.Add(church);
}
}
return(churches);
}
public List <Adoration> Search(string keyword, string location, string day, string time, string chapelLocation,
string ventilation, string parkings)
{
var adorations = new List <Adoration>();
var churchTransformer = new ChurchTransformer();
using (var sp = new StoredProcedure("spSearchAdorations"))
{
sp.SqlCommand.Parameters.AddWithValue("@keyword", keyword);
sp.SqlCommand.Parameters.AddWithValue("@location", location);
sp.SqlCommand.Parameters.AddWithValue("@scheduleTime", time);
sp.SqlCommand.Parameters.AddWithValue("@scheduleDay", day);
sp.SqlCommand.Parameters.AddWithValue("@chapelLocation", chapelLocation);
sp.SqlCommand.Parameters.AddWithValue("@ventilation", ventilation);
sp.SqlCommand.Parameters.AddWithValue("@parkings", parkings);
var reader = sp.SqlCommand.ExecuteReader();
while (reader.Read())
{
var adoration = new Adoration
{
AdorationId = Convert.ToInt32(reader["AdorationID"]),
ChurchId = Convert.ToInt32(reader["SimbahanId"]),
Is247 = Convert.ToBoolean(reader["IsOpen24By7"]),
DisplayText = reader["DisplayText"].ToString()
};
char[] separator = { ',' };
char[] pipeSeparator = { '|' };
var ventilations = reader["Ventilations"].ToString().Split(separator, StringSplitOptions.None);
foreach (var ventilationItem in ventilations)
{
adoration.Ventilations.Add(ventilationItem);
}
var photos = reader["AdorationPhotos"].ToString().Split(separator, StringSplitOptions.None);
foreach (var photo in photos)
{
adoration.Images.Add(photo == string.Empty ? "" : @"Images\Photos\" + photo);
}
var masses = reader["Masses"].ToString().Split(separator, StringSplitOptions.None);
foreach (var massDb in masses)
{
var massDetail = massDb.Split(pipeSeparator, StringSplitOptions.None);
var mass = new MassDetailsModel
{
ScheduleId = Convert.ToInt32(massDetail[2]),
Time = massDetail[3],
TimeStandardId = Convert.ToInt32(massDetail[4])
};
switch (Convert.ToInt32(massDetail[2]))
{
case 1:
mass.Days = "Sunday";
adoration.SundaySchedule.Add(mass);
break;
case 2:
mass.Days = "Monday";
adoration.MondaySchedule.Add(mass);
break;
case 3:
mass.Days = "Tuesday";
adoration.TuesdaySchedule.Add(mass);
break;
case 4:
mass.Days = "Wednesday";
adoration.WednesdaySchedule.Add(mass);
break;
case 5:
mass.Days = "Thursday";
adoration.ThursdaySchedule.Add(mass);
break;
case 6:
mass.Days = "Friday";
adoration.FridaySchedule.Add(mass);
break;
case 7:
mass.Days = "Saturday";
adoration.SaturdaySchedule.Add(mass);
break;
}
}
adoration.Church = churchTransformer.Transform(reader);
adorations.Add(adoration);
}
}
return(adorations);
}
public Adoration Find(int id)
{
var adoration = new Adoration();
var churchTransformer = new ChurchTransformer();
using (var sp = new StoredProcedure("spFindAdoration"))
{
sp.SqlCommand.Parameters.AddWithValue("@adorationID", id);
var reader = sp.SqlCommand.ExecuteReader();
while (reader.Read())
{
adoration.Church = churchTransformer.Transform(reader);
adoration.Is247 = Convert.ToBoolean(reader["IsOpen24By7"]);
adoration.ChurchId = Convert.ToInt32(reader["SimbahanID"]);
adoration.AdorationId = Convert.ToInt32(reader["AdorationID"]);
adoration.DisplayText = reader["DisplayText"].ToString();
}
// Adoration Schedule
reader.NextResult();
while (reader.Read())
{
var mass = new MassDetailsModel()
{
Id = Convert.ToInt32(reader["AdorationID"]),
ScheduleId = Convert.ToInt32(reader["ScheduleID"]),
TimeStandardId = Convert.ToInt32(reader["TimeStandardID"]),
Time = reader["Time"].ToString()
};
switch (Convert.ToInt32(reader["ScheduleID"]))
{
case 1:
mass.Days = "Sunday";
adoration.SundaySchedule.Add(mass);
break;
case 2:
mass.Days = "Monday";
adoration.MondaySchedule.Add(mass);
break;
case 3:
mass.Days = "Tuesday";
adoration.TuesdaySchedule.Add(mass);
break;
case 4:
mass.Days = "Wednesday";
adoration.WednesdaySchedule.Add(mass);
break;
case 5:
mass.Days = "Thursday";
adoration.ThursdaySchedule.Add(mass);
break;
case 6:
mass.Days = "Friday";
adoration.FridaySchedule.Add(mass);
break;
case 7:
mass.Days = "Saturday";
adoration.SaturdaySchedule.Add(mass);
break;
}
adoration.Masses.Add(mass);
}
reader.NextResult();
while (reader.Read())
{
adoration.Ventilations.Add(reader["VentType"].ToString());
}
reader.NextResult();
while (reader.Read())
{
adoration.Images.Add("Images/Photos/" + reader["ImagePath"]);
}
}
return(adoration);
}
public List <Adoration> Search(string keyword, string location, string day, string time, string chapelLocation,
string ventilation)
{
var adorations = new List <Adoration>();
var churchTransformer = new ChurchTransformer();
using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString))
{
if (dbconn.State == ConnectionState.Open)
{
dbconn.Close();
}
dbconn.Open();
using (var cmd = new SqlCommand("spSearchAdorations", dbconn))
{
try
{
if (day == "8")
{
day = (int)DateTime.Now.DayOfWeek + 1 + "";
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@keyword", keyword);
cmd.Parameters.AddWithValue("@location", location);
cmd.Parameters.AddWithValue("@scheduleTime", time);
cmd.Parameters.AddWithValue("@scheduleDay", day);
cmd.Parameters.AddWithValue("@chapelLocation", chapelLocation);
cmd.Parameters.AddWithValue("@ventilation", ventilation);
var dr = cmd.ExecuteReader();
while (dr.Read())
{
var adoration = new Adoration
{
AdorationID = Convert.ToInt32(dr["AdorationID"]),
SimbahanID = Convert.ToInt32(dr["SimbahanId"]),
Is247 = Convert.ToBoolean(dr["IsOpen24By7"]),
DisplayText = dr["DisplayText"].ToString()
};
char[] separator = { ',' };
char[] pipeSeparator = { '|' };
var ventilations = dr["Ventilations"].ToString().Split(separator, StringSplitOptions.None);
foreach (var ventilationItem in ventilations)
{
adoration.Ventilations.Add(ventilationItem);
}
var photos = dr["AdorationPhotos"].ToString().Split(separator, StringSplitOptions.None);
foreach (var photo in photos)
{
if (photo != string.Empty)
{
adoration.Images.Add(@"Images\Photos\" + photo);
}
}
if (photos.Length == 0)
{
adoration.Images.Add(@"Images\Photos\default.jpg");
}
var masses = dr["Masses"].ToString().Split(separator, StringSplitOptions.None);
foreach (var massDb in masses)
{
var massDetail = massDb.Split(pipeSeparator, StringSplitOptions.None);
var mass = new MassDetailsModel
{
ScheduleId = Convert.ToInt32(massDetail[2]),
Time = massDetail[3],
TimeStandardId = Convert.ToInt32(massDetail[4])
};
switch (Convert.ToInt32(massDetail[2]))
{
case 1:
mass.Days = "Sunday";
adoration.SundaySchedule.Add(mass);
break;
case 2:
mass.Days = "Monday";
adoration.MondaySchedule.Add(mass);
break;
case 3:
mass.Days = "Tuesday";
adoration.TuesdaySchedule.Add(mass);
break;
case 4:
mass.Days = "Wednesday";
adoration.WednesdaySchedule.Add(mass);
break;
case 5:
mass.Days = "Thursday";
adoration.ThursdaySchedule.Add(mass);
break;
case 6:
mass.Days = "Friday";
adoration.FridaySchedule.Add(mass);
break;
case 7:
mass.Days = "Saturday";
adoration.SaturdaySchedule.Add(mass);
break;
}
}
adoration.Church = churchTransformer.Transform(dr);
adorations.Add(adoration);
}
}
catch (Exception)
{
// ignored
}
}
}
return(adorations);
}
