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);
}