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