public static Publish ViewPublish(int EventID)
{
try
{
DAL dalDataContext = new DAL();
DateTime now = DateTime.Now;
//Publish p = (from ps in dalDataContext.publishs
// where ps.EventID == EventID &&
// ps.StartDateTime <= now &&
// ps.EndDateTime >= now
// select ps).SingleOrDefault();
//dalDataContext.Dispose();
Publish p = (from ps in dalDataContext.publishs
where ps.EventID == EventID
select ps).SingleOrDefault();
dalDataContext.Dispose();
return p;
}
catch
{
throw new FaultException<SException>(new SException(),
new FaultReason("An Error occured Retrieving Publish Data, Please Try Again!"));
}
}
public static List<ParticipantEvent> ParticipantViewEvents(string participantEmail, DateTime start, DateTime end, bool paid)
{
end = end.AddDays(1).AddMilliseconds(-1);
DAL dalDataContext = new DAL();
List<Events> existingEvents;
//DateTime now = DateTime.Now;
existingEvents = (from events in dalDataContext.events
join publish in dalDataContext.publishs on
events.EventID equals publish.EventID
where events.StartDateTime >= start
&& events.EndDateTime <= end
// && now >= publish.StartDateTime
// && now <= publish.EndDateTime
orderby events.StartDateTime ascending
select events).ToList<Events>();
dalDataContext.Dispose();
existingEvents = existingEvents.OrderBy(s => s.StartDateTime).ToList<Events>();
List<ParticipantEvent> lstpe = new List<ParticipantEvent>();
foreach (Events e in existingEvents)
{
Publish p = PublishController.GetPublish(e.EventID);
Participant part = ParticipantController.GetParticipant(e.EventID, participantEmail);
if (part != null)
{
if (part.Paid == paid)
{
ParticipantEvent pe = new ParticipantEvent(e.EventID, e.Name, e.StartDateTime, e.EndDateTime, p.PaymentAMount, part.Paid);
lstpe.Add(pe);
}
}
}
return lstpe;
}