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 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 OrganizationReviewService()
{
_organizationReviewTransformer = new OrganizationReviewTransformer();
_organizationTransformer = new OrganizationTransformer();
_userTransformer = new UserTransformer();
}
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);
}
