當前位置: 首頁>>代碼示例>>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;未經允許,請勿轉載。