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(); } } }
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);