public Guid CreateSession(UserSessionBO obj) { DBEgine dbEngine = new DBEgine(); try { dbEngine.DBOpen(); SqlParameter[] parms = new SqlParameter[3]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "UserId"; p1.SqlDbType = SqlDbType.Int; p1.Value = obj.UserID; parms[0] = p1; SqlParameter p2 = new SqlParameter(); p2.ParameterName = "LanguageID"; p2.SqlDbType = SqlDbType.Int; p2.Value = obj.LanguageID; parms[1] = p2; SqlParameter p3 = new SqlParameter(); p3.ParameterName = "UserSessionID"; p3.SqlDbType = SqlDbType.UniqueIdentifier; p3.Direction = ParameterDirection.Output; parms[2] = p3; dbEngine.ExecNonQueryStoredProc("UM_CreateUserSession", parms); return (Guid)p3.Value; } catch { throw; } finally { dbEngine.DBClose(); } }
public UserSessionBO GetActiveUserSessionBySessionID(UserSessionBO obj) { DBEgine dbEngine = new DBEgine(); try { UserSessionBO us = null; dbEngine.DBOpen(); SqlParameter[] parms = new SqlParameter[1]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "UserSessionID"; p1.SqlDbType = SqlDbType.UniqueIdentifier; p1.Value = obj.UserSessionID; parms[0] = p1; SqlDataReader sqlDr = dbEngine.ExecuteReader("UM_GetActiveUserSessionBySessionID", parms); if (sqlDr != null && sqlDr.HasRows) { us = new UserSessionBO(); while (sqlDr.Read()) { us = Fill(sqlDr); UserSessionLastAccessUpdate(us); } } return us; } catch { throw; } finally { dbEngine.DBClose(); } }
private UserSessionBO Fill(SqlDataReader dr) { var us = new UserSessionBO(); us.UserSessionID = dr.GetGuid(dr.GetOrdinal("UserSessionID")); us.UserID = dr.GetInt32(dr.GetOrdinal("UserID")); us.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn")); us.LastAccessOn = dr.GetDateTime(dr.GetOrdinal("LastAccessOn")); us.IsLogout = dr.GetBoolean(dr.GetOrdinal("IsLogout")); us.LogoutBy = dr.GetInt32(dr.GetOrdinal("LogoutBy")); if (!dr.IsDBNull(dr.GetOrdinal("LogoutTime"))) { us.LogoutTime = dr.GetDateTime(dr.GetOrdinal("LogoutTime")); } if (!dr.IsDBNull(dr.GetOrdinal("Remark"))) { us.Remark = dr.GetValue(dr.GetOrdinal("Remark")).ToString(); } return us; }
public void UsersessionLogoutByUserID(DBEgine dbEngine, UserSessionBO userSession) { try { SqlParameter[] parms = new SqlParameter[3]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "UserSessionID"; p1.SqlDbType = SqlDbType.UniqueIdentifier; p1.Value = userSession.UserSessionID; parms[0] = p1; SqlParameter p2 = new SqlParameter(); p2.ParameterName = "UserID"; p2.SqlDbType = SqlDbType.Int; p2.Value = userSession.UserID; parms[1] = p2; SqlParameter p3 = new SqlParameter(); p3.ParameterName = "Remark"; p3.SqlDbType = SqlDbType.VarChar; p3.Value = userSession.Remark; parms[2] = p3; dbEngine.ExecNonQueryStoredProc("UM_UsersessionLogoutByUserID", parms); } catch { throw; } }
public void UsersessionLogoutByUserID(UserSessionBO obj) { DBEgine dbEngine = new DBEgine(); try { dbEngine.DBOpen(); SqlParameter[] parms = new SqlParameter[3]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "UserSessionID"; p1.SqlDbType = SqlDbType.UniqueIdentifier; p1.Value = obj.UserSessionID; parms[0] = p1; SqlParameter p2 = new SqlParameter(); p2.ParameterName = "UserID"; p2.SqlDbType = SqlDbType.Int; p2.Value = obj.UserID; parms[1] = p2; SqlParameter p3 = new SqlParameter(); p3.ParameterName = "Remark"; p3.SqlDbType = SqlDbType.VarChar; p3.Value = obj.Remark; parms[2] = p3; dbEngine.ExecNonQueryStoredProc("UM_UsersessionLogoutByUserID", parms); } catch { throw; } finally { dbEngine.DBClose(); } }
public void UserSessionLastAccessUpdate(UserSessionBO obj) { DBEgine dbEngine = new DBEgine(); try { dbEngine.DBOpen(); SqlParameter[] parms = new SqlParameter[1]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "UserSessionID"; p1.SqlDbType = SqlDbType.UniqueIdentifier; p1.Value = obj.UserSessionID; parms[0] = p1; dbEngine.ExecNonQueryStoredProc("UM_UserSessionLastAccessUpdate", parms); } catch { throw; } finally { dbEngine.DBClose(); } }
public static void Replace(UserSessionBO sessionHandler) { }
public List<UserSessionBO> SearchUserSession(int BranchId, DateTime FromDate, DateTime ToDate, int LoginStatus) { List<UserSessionBO> listUserSessionDetail = new List<UserSessionBO>(); DBEgine dbEngine = new DBEgine(); try { dbEngine.DBOpen(); SqlParameter[] arrSqlParam = new SqlParameter[4]; SqlParameter pBranchID = new SqlParameter(); pBranchID.ParameterName = "@branchId"; pBranchID.SqlDbType = SqlDbType.Int; pBranchID.Value = BranchId; arrSqlParam[0] = pBranchID; SqlParameter pFromDate = new SqlParameter(); pFromDate.ParameterName = "@FromDate"; pFromDate.SqlDbType = SqlDbType.Date; pFromDate.Value = FromDate; arrSqlParam[1] = pFromDate; SqlParameter pToDate = new SqlParameter(); pToDate.ParameterName = "@ToDate"; pToDate.SqlDbType = SqlDbType.Date; pToDate.Value = ToDate; arrSqlParam[2] = pToDate; SqlParameter pLoginStatus = new SqlParameter(); pLoginStatus.ParameterName = "@loginStatus"; pLoginStatus.SqlDbType = SqlDbType.Int; pLoginStatus.Value = LoginStatus; arrSqlParam[3] = pLoginStatus; SqlDataReader sqlDataReader = dbEngine.ExecuteReader("UM_SearchUserSessionDetails", arrSqlParam); while (sqlDataReader.Read()) { UserSessionBO userSessionDetail = new UserSessionBO(); if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("UserSessionID"))) { userSessionDetail.UserSessionID = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("UserSessionID")); } if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("UserID"))) { userSessionDetail.UserID = sqlDataReader.GetInt32(sqlDataReader.GetOrdinal("UserID")); } if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("UserName"))) { userSessionDetail.UserName = sqlDataReader.GetString(sqlDataReader.GetOrdinal("UserName")); } if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("FullName"))) { userSessionDetail.FullName = sqlDataReader.GetString(sqlDataReader.GetOrdinal("FullName")); } if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("BranchID"))) { userSessionDetail.BranchID = sqlDataReader.GetInt32(sqlDataReader.GetOrdinal("BranchID")); } if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("BranchName"))) { userSessionDetail.BranchName = sqlDataReader.GetString(sqlDataReader.GetOrdinal("BranchName")); } if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("CreatedOn"))) { userSessionDetail.CreatedOn = sqlDataReader.GetDateTime(sqlDataReader.GetOrdinal("CreatedOn")); } if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("LastAccessOn"))) { userSessionDetail.LastAccessOn = sqlDataReader.GetDateTime(sqlDataReader.GetOrdinal("LastAccessOn")); } if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("IsLogout"))) { userSessionDetail.IsLogout = sqlDataReader.GetBoolean(sqlDataReader.GetOrdinal("IsLogout")); } if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("LogoutType"))) { userSessionDetail.LogoutType = sqlDataReader.GetInt32(sqlDataReader.GetOrdinal("LogoutType")); } if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("LogoutBy"))) { userSessionDetail.LogoutBy = sqlDataReader.GetInt32(sqlDataReader.GetOrdinal("LogoutBy")); } if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("LogoutTime"))) { userSessionDetail.LogoutTime = sqlDataReader.GetDateTime(sqlDataReader.GetOrdinal("LogoutTime")); } if (!sqlDataReader.IsDBNull(sqlDataReader.GetOrdinal("Remark"))) { userSessionDetail.Remark = sqlDataReader.GetString(sqlDataReader.GetOrdinal("Remark")); } listUserSessionDetail.Add(userSessionDetail); } } catch { throw; } finally { dbEngine.DBClose(); } return listUserSessionDetail; }