/// <summary> /// Log out from application /// </summary> protected bool LogoutByNewUser(Guid user_id, string pass) { try { Guid?loggedsession_id = null; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SumonERPContext"].ConnectionString.ToString())) { var sql = "select session_id from sessionManagements where user_id='" + user_id + "' and Password ='******'"; SqlCommand cmd = new SqlCommand(sql, con); con.Open(); SqlDataReader oReader = cmd.ExecuteReader(); if (((System.Data.SqlClient.SqlDataReader)(oReader)).HasRows) { while (oReader.Read()) { loggedsession_id = Guid.Parse(Convert.ToString(oReader["session_id"])); if (loggedsession_id != null) { SecurityServices.CloseSession(loggedsession_id.ToString()); } } } oReader.Close(); return(true); } } catch (Exception) { throw; } }