public static UserAccessLog GetByUserId(string userId) { UserAccessLog record = null; string sql = @"SELECT * FROM UserAccessLog WHERE UserId=@UserId"; try { using (SqlConnection conn = new SqlConnection(DataConnection.AppData)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@UserId", userId); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { record = new UserAccessLog(reader); } } } } catch (Exception e) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrLogger.Log(_className, methodName, e.Message); record = null; } return record; }
public void UserAccesLogTest() { UserAccessLog log = new UserAccessLog(); log.UserId = "3707cf22-2ab7-4e4e-9dc2-1eb25155e922"; log.Resource = "Login"; log = log.Insert(); Assert.IsTrue(log != null); return ; }
private bool Add(string userId, string resource) { bool result = false; if (userId != null) { UserAccessLog record = new UserAccessLog(userId, resource); record = record.Insert(); result = record != null; } return result; }