public static int DoRegisterNewDevice(StorageDeviceInfo DeviceDetails) { int returnVal = 0; MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection(); try { //define the command reference MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand(); //define the connection used by the command object msqlCommand.Connection = msqlConnection; msqlCommand.CommandText = "INSERT INTO Device(DeviceId,lastScannedDate,lastUsedHost,files,remark) " + "VALUES(@DeviceId,@lastScannedDate,@lastUsedHost,@files,@filesBackupHere,@remark)"; msqlCommand.Parameters.AddWithValue("@DeviceId", DeviceDetails.deviceId); msqlCommand.Parameters.AddWithValue("@files", DeviceDetails.files); msqlCommand.Parameters.AddWithValue("@lastScannedDate", DeviceDetails.lastScannedDate); msqlCommand.Parameters.AddWithValue("@lastUsedHost", DeviceDetails.lastUsedHost); msqlCommand.ExecuteNonQuery(); returnVal = 1; } catch (Exception er) { returnVal = 0; } finally { //always close the connection msqlConnection.Close(); } return returnVal; }
/// <summary> /// Queries all device list. /// </summary> /// <returns></returns> private static List<StorageDeviceInfo> QueryAllDeviceList() { List<StorageDeviceInfo> DeviceList = new List<StorageDeviceInfo>(); MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection(); try { //define the command reference MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand(); msqlCommand.Connection = msqlConnection; msqlCommand.CommandText = "Select * From Device ;"; MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader(); while (msqlReader.Read()) { StorageDeviceInfo Device = new StorageDeviceInfo(); /* Device.deviceId = msqlReader.GetString("DeviceId"); Device.lastScannedDate = msqlReader.GetString("lastScannedDate"); Device.lastUsedHost = msqlReader.GetString("lastUsedHost"); Device.lastUsedHost = msqlReader.GetString("lastUsedHost"); Device.files = msqlReader.GetString("files"); */ DeviceList.Add(Device); } } catch (Exception er) { } finally { //always close the connection msqlConnection.Close(); } return DeviceList; }