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, 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 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);
}
