public List <LogonModel> readList() { List <LogonModel> logonModelList = new List <LogonModel>(); openConnection(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = connection; cmd.CommandText = string.Format("select brugerId, lastLogon, logonCnt from Logon"); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { LogonModel logonModel = new LogonModel(); logonModel.brugerId = reader.GetString("brugerId"); logonModel.lastlogon = reader.GetDateTime("lastlogon"); logonModel.logonCnt = reader.GetInt32("logonCnt"); logonModelList.Add(logonModel); } closeConnection(); return(logonModelList); }
public LogonModel read(string id) { openConnection(); LogonModel logonModel = new LogonModel(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = connection; cmd.CommandText = string.Format("select brugerId, lastLogon, logonCnt from Logon where brugerId='{0}'", id); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { logonModel.brugerId = reader.GetString("brugerId"); logonModel.lastlogon = reader.GetDateTime("lastlogon"); logonModel.logonCnt = reader.GetInt32("logonCnt"); } closeConnection(); return(logonModel); }