Example #1
0
     public    static void Remove_ActiveSession(string userName)
        {
            using (SessionsDataDataContext dc = new SessionsDataDataContext(SessionMannager.SessionsConnectionString))
            {

                ActiveSession a = dc.ActiveSessions.Where(s=> s.UserName.Equals(userName)).FirstOrDefault<ActiveSession>();
                if (a != null)
                {
                    SessionHistory wSessionHistory = new SessionHistory();

                    wSessionHistory.UserName = a.UserName;
                    wSessionHistory.SessionID = a.SessionID;
                    wSessionHistory.StatusDate = a.LoggedInDate;
                    wSessionHistory.Status = "Log_In";

                    dc.SessionHistories.InsertOnSubmit(wSessionHistory);


                    wSessionHistory = new SessionHistory();

                    wSessionHistory.UserName = a.UserName;
                    wSessionHistory.SessionID = a.SessionID;
                    wSessionHistory.StatusDate = DateTime.Now;
                    wSessionHistory.Status = "Log_Out";

                    dc.SessionHistories.InsertOnSubmit(wSessionHistory);

                    dc.ActiveSessions.DeleteOnSubmit(a);

                    dc.SubmitChanges();
                }
            
            }
        }
Example #2
0
        public static void Remove_ActiveSession(string userName)
        {
            using (SessionsDataDataContext dc = new SessionsDataDataContext(SessionMannager.SessionsConnectionString))
            {
                ActiveSession a = dc.ActiveSessions.Where(s => s.UserName.Equals(userName)).FirstOrDefault <ActiveSession>();
                if (a != null)
                {
                    SessionHistory wSessionHistory = new SessionHistory();

                    wSessionHistory.UserName   = a.UserName;
                    wSessionHistory.SessionID  = a.SessionID;
                    wSessionHistory.StatusDate = a.LoggedInDate;
                    wSessionHistory.Status     = "Log_In";

                    dc.SessionHistories.InsertOnSubmit(wSessionHistory);


                    wSessionHistory = new SessionHistory();

                    wSessionHistory.UserName   = a.UserName;
                    wSessionHistory.SessionID  = a.SessionID;
                    wSessionHistory.StatusDate = DateTime.Now;
                    wSessionHistory.Status     = "Log_Out";

                    dc.SessionHistories.InsertOnSubmit(wSessionHistory);

                    dc.ActiveSessions.DeleteOnSubmit(a);

                    dc.SubmitChanges();
                }
            }
        }
 partial void DeleteSessionHistory(SessionHistory instance);
 partial void UpdateSessionHistory(SessionHistory instance);
 partial void InsertSessionHistory(SessionHistory instance);
 partial void DeleteSessionHistory(SessionHistory instance);
 partial void UpdateSessionHistory(SessionHistory instance);
 partial void InsertSessionHistory(SessionHistory instance);