public static void InsertAccess(SDAccessLogDTO data) { try { using (SDDatabase.Instance.Connection) { SDDatabase.Instance.Connection.Open(); using (MySqlCommand cmd = new MySqlCommand("INSERT INTO access_log(AccessDateTime, Type, Data) VALUES(@acdt,@type,@data)", SDDatabase.Instance.Connection)) { cmd.Parameters.AddWithValue("@acdt", data.AccessDateTime); cmd.Parameters.AddWithValue("@type", data.Type); cmd.Parameters.AddWithValue("@data", data.Data); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { Console.WriteLine("InsertAccess Exception: " + ex); } }
public static IEnumerable <SDAccessLogDTO> GetAccessLog() { List <SDAccessLogDTO> accessList = new List <SDAccessLogDTO>(); try { using (SDDatabase.Instance.Connection) { SDDatabase.Instance.Connection.Open(); using (MySqlCommand cmd = new MySqlCommand("SELECT LogID, AccessDateTime, Type, Data FROM access_log", SDDatabase.Instance.Connection)) { cmd.ExecuteNonQuery(); using (MySqlDataAdapter adap = new MySqlDataAdapter()) { DataTable dt = new DataTable(); adap.SelectCommand = cmd; adap.Fill(dt); foreach (DataRow dr in dt.Rows) { SDAccessLogDTO logInfo = new SDAccessLogDTO(); logInfo.LogID = (int)dr["LogID"]; logInfo.AccessDateTime = (DateTime)dr["AccessDateTime"]; logInfo.Type = (string)dr["Type"]; logInfo.Data = (string)dr["Data"]; accessList.Add(logInfo); } } } } } catch (Exception ex) { Console.WriteLine("GetAccessLog Exception: " + ex); } return(accessList); }