/// <summary> /// Returns a new SessionDetails instance filled with the DataReader's current record data /// </summary> protected virtual SessionDetails GetSessionFromReader(DbDataReader reader) { SessionDetails session = new SessionDetails(); if (reader.HasRows) { session.LoginNo = GetReaderValue_Int32(reader, "LoginNo", 0); //From: [Table] session.SessionName = GetReaderValue_String(reader, "SessionName", ""); //From: [Table] session.SessionTimestamp = GetReaderValue_DateTime(reader, "SessionTimestamp", DateTime.MinValue); //From: [Table] session.StartTime = GetReaderValue_DateTime(reader, "StartTime", DateTime.MinValue); //From: [Table] session.IPAddress = GetReaderValue_String(reader, "IPAddress", ""); //From: [Table] session.EmployeeName = GetReaderValue_String(reader, "EmployeeName", ""); //From: [usp_selectAll_Audit_authorisation_for_SalesOrder] } return(session); }
/// <summary> /// Get /// Calls [usp_select_Session] /// </summary> public static Session Get(System.Int32?loginNo) { Rebound.GlobalTrader.DAL.SessionDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Session.Get(loginNo); if (objDetails == null) { return(null); } else { Session obj = new Session(); obj.LoginNo = objDetails.LoginNo; obj.SessionName = objDetails.SessionName; obj.SessionTimestamp = objDetails.SessionTimestamp; obj.StartTime = objDetails.StartTime; obj.IPAddress = objDetails.IPAddress; objDetails = null; return(obj); } }