// ****************************
// **THIS CURRENTLY GETS ALL EVENTS FROM DB. WILL NEED TO UPDATE IN FRONT END TO GET EVENTS NEAR USER.
public static List<Event> GetNearbyEvents(int Id)
{
List<Event> list = new List<Event>();
DataProvider.ExecuteCmd(GetConnection, "dbo.Event_Select"
, inputParamMapper: delegate (SqlParameterCollection paramCollection)
{ }
, map: delegate (IDataReader reader, short set)
{
int startingIndex = 0;
Event e = new Event();
e.Id = reader.GetSafeInt32(startingIndex++);
e.Name = reader.GetSafeString(startingIndex++);
e.Organization = reader.GetSafeString(startingIndex++);
e.CategoryId = reader.GetSafeInt32(startingIndex++);
e.Address = reader.GetSafeString(startingIndex++);
e.Description = reader.GetSafeString(startingIndex++);
if (list == null)
{
list = new List<Event>();
}
list.Add(e);
}
);
return list;
}
public static Event GetEventById(int Id)
{
Event e = new Event();
DataProvider.ExecuteCmd(GetConnection, "dbo.Event_SelectById"
, inputParamMapper: delegate (SqlParameterCollection paramCollection)
{ paramCollection.AddWithValue("@Id", Id); }
, map: delegate (IDataReader reader, short set)
{
int startingIndex = 0;
e.Id = reader.GetSafeInt32(startingIndex++);
e.Name = reader.GetSafeString(startingIndex++);
e.Organization = reader.GetSafeString(startingIndex++);
e.CategoryId = reader.GetSafeInt32(startingIndex++);
e.Address = reader.GetSafeString(startingIndex++);
e.Description = reader.GetSafeString(startingIndex++);
}
);
return e;
}