当前位置: 首页>>代码示例>>C#>>正文


C# DAL.Dispose方法代码示例

本文整理汇总了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!"));
            }
        }
开发者ID:allanckw,项目名称:GEMS-Web,代码行数:29,代码来源:PublishController.cs

示例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;
        }
开发者ID:allanckw,项目名称:GEMS-Web,代码行数:39,代码来源:PublishController.cs


注:本文中的evmsService.DataAccess.DAL.Dispose方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。