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