本文整理汇总了C#中evmsService.DataAccess.DAL.Dispose方法的典型用法代码示例。如果您正苦于以下问题:C# DAL.Dispose方法的具体用法?C# DAL.Dispose怎么用?C# DAL.Dispose使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类evmsService.DataAccess.DAL
的用法示例。
在下文中一共展示了DAL.Dispose方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ViewPublish
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!"));
}
}
示例2: ParticipantViewEvents
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;
}