public List <Organization> GetFavoriteOrganizations(int userId) { var organizationTransformer = new OrganizationTransformer(); var organizations = new List <Organization>(); using (var sp = new StoredProcedure("spGetFavoriteOrganization")) { sp.SqlCommand.Parameters.AddWithValue("@userID", userId); var reader = sp.SqlCommand.ExecuteReader(); while (reader.Read()) { var organization = organizationTransformer.Transform(reader); //char[] separator = { ',' }; //var photos = reader["ChurchPhotos"].ToString().Split(separator, StringSplitOptions.None); //church.ChurchPhotos = new List<ChurchPhotosModel>(); //foreach (var strPix in photos) // church.ChurchPhotos.Add(new ChurchPhotosModel // { // ChurchPhotos = strPix == string.Empty ? "" : @"Images\Photos\" + strPix // }); organizations.Add(organization); } } return(organizations); }
public OrganizationReview Create(OrganizationReview model) { var organizationReview = new OrganizationReview(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spInsertOrganizationReview", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userID", model.UserId); cmd.Parameters.AddWithValue("@organizationID", model.OrganizationId); cmd.Parameters.AddWithValue("@name", model.Name); cmd.Parameters.AddWithValue("@title", model.Title); cmd.Parameters.AddWithValue("@rate", model.StarCount); cmd.Parameters.AddWithValue("@content", model.Comment); var reader = cmd.ExecuteReader(); while (reader.Read()) { organizationReview = _organizationReviewTransformer.Transform(reader); if (organizationReview.UserId != 0) { organizationReview.User = _userTransformer.Transform(reader); } organizationReview.Organization = _organizationTransformer.Transform(reader); } } catch (Exception) { // ignored } } } return(organizationReview); }
public List <Organization> GetFavoriteOrganizations(int userId) { var organizationTransformer = new OrganizationTransformer(); var organizations = new List <Organization>(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spGetFavoriteOrganization", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userID", userId); var reader = cmd.ExecuteReader(); while (reader.Read()) { var organization = organizationTransformer.Transform(reader); //char[] separator = { ',' }; //var photos = reader["ChurchPhotos"].ToString().Split(separator, StringSplitOptions.None); //church.ChurchPhotos = new List<ChurchPhotosModel>(); //foreach (var strPix in photos) // church.ChurchPhotos.Add(new ChurchPhotosModel // { // ChurchPhotos = strPix == string.Empty ? "" : @"Images\Photos\" + strPix // }); organizations.Add(organization); } } catch (Exception) { // ignored } } } return(organizations); }
public List <Organization> Search(string keyword, string location, string organizationName, string useSchedule, string time, string language, string day, string activities, string attendees, string ventilation, string parking, string venue) { var organizationTransformer = new OrganizationTransformer(); var organizations = new List <Organization>(); char[] commaSeparator = { ',' }; char[] pipeSeparator = { '|' }; using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spSearchOrganizations", 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("@organizationName", organizationName); cmd.Parameters.AddWithValue("@schedule", useSchedule); cmd.Parameters.AddWithValue("@scheduleDay", day); cmd.Parameters.AddWithValue("@scheduleTime", time); cmd.Parameters.AddWithValue("@scheduleLanguage", language); cmd.Parameters.AddWithValue("@activities", activities); cmd.Parameters.AddWithValue("@attendees", attendees); cmd.Parameters.AddWithValue("@ventilation", ventilation); cmd.Parameters.AddWithValue("@parking", parking); cmd.Parameters.AddWithValue("@venue", venue); var reader = cmd.ExecuteReader(); while (reader.Read()) { var organization = organizationTransformer.Transform(reader); //TODO: Organization Photos var schedules = reader["Schedules"].ToString().Split(commaSeparator, StringSplitOptions.None); foreach (var scheduleItem in schedules) { if (scheduleItem == "") { continue; } var schedule = scheduleItem.Split(pipeSeparator, StringSplitOptions.None); string araw = ""; //LOL switch (Convert.ToInt32(schedule[1])) { case 1: araw = "Sunday"; break; case 2: araw = "Monday"; break; case 3: araw = "Tuesday"; break; case 4: araw = "Wednesday"; break; case 5: araw = "Thursday"; break; case 6: araw = "Friday"; break; case 7: araw = "Saturday"; break; } organization.Masses.Add(new OrganizationMass { Id = Convert.ToInt32(schedule[0]), ScheduleId = Convert.ToInt32(schedule[1]), Time = schedule[2], TimeStandardId = Convert.ToInt32(schedule[3]), Day = araw }); } var photos = reader["OrganizationPhotos"].ToString().Split(commaSeparator, StringSplitOptions.None); foreach (var photo in photos) { if (photo == "") { organization.Photos.Add("Images/default-org.jpg"); break; } organization.Photos.Add("Images/Organizations/" + photo); } organizations.Add(organization); } } catch (Exception) { // ignored } } } return(organizations); }
public Organization Find(int id) { var organizationTransformer = new OrganizationTransformer(); var organization = new Organization(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spFindOrganization", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@organizationID", id); var reader = cmd.ExecuteReader(); while (reader.Read()) { organization = organizationTransformer.Transform(reader); } reader.NextResult(); while (reader.Read()) { organization.Locations.Add(reader["OrgLocation"].ToString()); } reader.NextResult(); while (reader.Read()) { organization.Ventilations.Add(reader["OrgVentilationType"].ToString()); } reader.NextResult(); while (reader.Read()) { // TODO: Implement } reader.NextResult(); while (reader.Read()) { organization.Parkings.Add(reader["OrgVehicleParkingType"].ToString()); } reader.NextResult(); while (reader.Read()) { organization.Attendees.Add(reader["AttendeesType"].ToString()); } reader.NextResult(); while (reader.Read()) { organization.Activities.Add(reader["ActivityName"].ToString()); } reader.NextResult(); while (reader.Read()) { organization.Masses.Add(new OrganizationMass { Id = Convert.ToInt32(reader["OrgMassID"]), ScheduleId = Convert.ToInt32(reader["ScheduleID"]), TimeStandardId = Convert.ToInt32(reader["TimeStandardID"]), OrganizationId = Convert.ToInt32(reader["OrganizationID"]), Day = reader["Days"].ToString(), Time = reader["Time"].ToString() }); } reader.NextResult(); while (reader.Read()) { organization.BibleStudySchedules.Add(new OrganizationMass { Id = Convert.ToInt32(reader["OrgBibleScheduleID"]), ScheduleId = Convert.ToInt32(reader["ScheduleID"]), TimeStandardId = Convert.ToInt32(reader["TimeStandardID"]), OrganizationId = Convert.ToInt32(reader["OrganizationID"]), Day = reader["Days"].ToString(), Time = reader["Time"].ToString() }); } reader.NextResult(); while (reader.Read()) { organization.WorshipSchedules.Add(new OrganizationMass { Id = Convert.ToInt32(reader["OrgWorshipScheduleID"]), ScheduleId = Convert.ToInt32(reader["ScheduleID"]), TimeStandardId = Convert.ToInt32(reader["TimeStandardID"]), OrganizationId = Convert.ToInt32(reader["OrganizationID"]), Day = reader["Days"].ToString(), Time = reader["Time"].ToString() }); } } catch (Exception) { // ignored } } } return(organization); }
public List <Organization> Search(string keyword, string location, string organizationName, string useSchedule, string time, string language, string day, string activities, string attendees, string ventilation, string parking, string venue) { var organizationTransformer = new OrganizationTransformer(); var organizations = new List <Organization>(); char[] commaSeparator = { ',' }; char[] pipeSeparator = { '|' }; using (var sp = new StoredProcedure("spSearchOrganizations")) { sp.SqlCommand.Parameters.AddWithValue("@keyword", keyword); sp.SqlCommand.Parameters.AddWithValue("@location", location); sp.SqlCommand.Parameters.AddWithValue("@organizationName", organizationName); sp.SqlCommand.Parameters.AddWithValue("@schedule", useSchedule); sp.SqlCommand.Parameters.AddWithValue("@scheduleDay", day); sp.SqlCommand.Parameters.AddWithValue("@scheduleTime", time); sp.SqlCommand.Parameters.AddWithValue("@scheduleLanguage", language); sp.SqlCommand.Parameters.AddWithValue("@activities", activities); sp.SqlCommand.Parameters.AddWithValue("@attendees", attendees); sp.SqlCommand.Parameters.AddWithValue("@ventilation", ventilation); sp.SqlCommand.Parameters.AddWithValue("@parking", parking); sp.SqlCommand.Parameters.AddWithValue("@venue", venue); var reader = sp.SqlCommand.ExecuteReader(); while (reader.Read()) { var organization = organizationTransformer.Transform(reader); //TODO: Organization Photos if (!HasColumn(reader, "Schedules")) { organizations.Add(organization); continue; } var schedules = reader["Schedules"].ToString().Split(commaSeparator, StringSplitOptions.None); foreach (var scheduleItem in schedules) { var schedule = scheduleItem.Split(pipeSeparator, StringSplitOptions.None); var araw = ""; // LOL switch (Convert.ToInt32(schedule[1])) { case 1: araw = "Sunday"; break; case 2: araw = "Monday"; break; case 3: araw = "Tuesday"; break; case 4: araw = "Wednesday"; break; case 5: araw = "Thursday"; break; case 6: araw = "Friday"; break; case 7: araw = "Saturday"; break; } organization.Masses.Add(new OrganizationMass { Id = Convert.ToInt32(schedule[0]), ScheduleId = Convert.ToInt32(schedule[1]), Time = schedule[2], TimeStandardId = Convert.ToInt32(schedule[3]), Day = araw }); } organizations.Add(organization); } } return(organizations); }
public Organization Find(int id) { var organizationTransformer = new OrganizationTransformer(); var organization = new Organization(); using (var sp = new StoredProcedure("spFindOrganization")) { sp.SqlCommand.Parameters.AddWithValue("@organizationID", id); var reader = sp.SqlCommand.ExecuteReader(); while (reader.Read()) { organization = organizationTransformer.Transform(reader); } reader.NextResult(); while (reader.Read()) { organization.Locations.Add(reader["OrgLocation"].ToString()); } reader.NextResult(); while (reader.Read()) { organization.Ventilations.Add(reader["OrgVentilationType"].ToString()); } reader.NextResult(); while (reader.Read()) { // TODO: Implement } reader.NextResult(); while (reader.Read()) { organization.Parkings.Add(reader["OrgVehicleParkingType"].ToString()); } reader.NextResult(); while (reader.Read()) { organization.Attendees.Add(reader["AttendeesType"].ToString()); } reader.NextResult(); while (reader.Read()) { organization.Activities.Add(reader["ActivityName"].ToString()); } reader.NextResult(); while (reader.Read()) { organization.Masses.Add(new OrganizationMass { Id = Convert.ToInt32(reader["OrgMassID"]), ScheduleId = Convert.ToInt32(reader["ScheduleID"]), TimeStandardId = Convert.ToInt32(reader["TimeStandardID"]), OrganizationId = Convert.ToInt32(reader["OrganizationID"]), Day = reader["Days"].ToString(), Time = reader["Time"].ToString() }); } reader.NextResult(); while (reader.Read()) { organization.BibleStudySchedules.Add(new OrganizationMass { Id = Convert.ToInt32(reader["OrgBibleScheduleID"]), ScheduleId = Convert.ToInt32(reader["ScheduleID"]), TimeStandardId = Convert.ToInt32(reader["TimeStandardID"]), OrganizationId = Convert.ToInt32(reader["OrganizationID"]), Day = reader["Days"].ToString(), Time = reader["Time"].ToString() }); } reader.NextResult(); while (reader.Read()) { organization.WorshipSchedules.Add(new OrganizationMass { Id = Convert.ToInt32(reader["OrgWorshipScheduleID"]), ScheduleId = Convert.ToInt32(reader["ScheduleID"]), TimeStandardId = Convert.ToInt32(reader["TimeStandardID"]), OrganizationId = Convert.ToInt32(reader["OrganizationID"]), Day = reader["Days"].ToString(), Time = reader["Time"].ToString() }); } } return(organization); }