public bool IsRemoved()
{
try
{
mysqlConnectie.Open();
var RemoveLicense = new MySqlCommand("DELETE FROM license WHERE licenseID= " + LicenseID, mysqlConnectie);
mysqlConnectie.Close();
return(true);
}
catch (MySqlException ex)
{
var exep = new MySqlExceptionHandler(ex, "License");
throw new Exception(exep.ReturnMessage());
}
}
/// <summary>
/// Binds the event ID with hardware.
/// </summary>
public void BindEventID()
{
try
{
MySqlConnection mysqlConnectie = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
mysqlConnectie.Open();
MySqlCommand bindEventIDWithHardware = new MySqlCommand("UPDATE hardware SET eventID = '" + EventID + "' WHERE internalNr LIKE '" +
InternalNr + "'", mysqlConnectie);
bindEventIDWithHardware.ExecuteNonQuery();
bindEventIDWithHardware.Dispose();
mysqlConnectie.Close();
}
catch (MySqlException ex)
{
var handler = new MySqlExceptionHandler(ex, "Hardware");
throw new Exception(handler.ExceptionType);
}
}
/// <summary>
/// Returns the datatable of searched hardware .
/// </summary>
/// <param name="searchType">Type of the search.</param>
/// <param name="searchValue">The search value.</param>
/// <returns>System.Data.DataTable. searched hardware</returns>
public DataTable ReturnSearchDatatable(string searchType, string searchValue)
{
try
{
MySqlConnection mysqlConnectie = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
mysqlConnectie.Open();
MySqlCommand searchItem = new MySqlCommand("SELECT pictureLocation, DATE_FORMAT(purchaseDate, '%Y-%m-%d') 'purchaseDate', type, manufacturerName , serialNr, internalNr , warranty , extraInfo , DATE_FORMAT(addedDate, '%Y-%m-%d') 'addedDate', attachmentLocation, modelNr FROM hardware WHERE " + searchType + " COLLATE UTF8_GENERAL_CI LIKE '%" + searchValue + "%';", mysqlConnectie);
var searchReader = searchItem.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(searchReader);
mysqlConnectie.Close();
return(dt);
}
catch (MySqlException ex)
{
var handler = new MySqlExceptionHandler(ex, "Hardware");
throw new Exception(handler.ExceptionType);
}
}
/// <summary>
/// Returns the datatable hardware from the internal number.
/// </summary>
/// <returns>DataTable internal nr corresponsing hardware.</returns>
public DataTable ReturnDatatableHardwareFromInternal()
{
try
{
MySqlConnection mysqlConnectie = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
mysqlConnectie.Open();
MySqlCommand getCorrespondingPeople = new MySqlCommand("SELECT pictureLocation, DATE_FORMAT(purchaseDate, '%Y-%m-%d') 'purchaseDate', type , manufacturerName, serialNr , internalNr, warranty, extraInfo , DATE_FORMAT(addedDate, '%Y-%m-%d') 'addedDate', attachmentLocation, modelNr FROM hardware WHERE internalNr = '" + InternalNr + "'", mysqlConnectie);
var dataReader = getCorrespondingPeople.ExecuteReader();
var dt = new DataTable();
dt.Load(dataReader);
mysqlConnectie.Close();
return(dt);
}
catch (MySqlException ex)
{
var handler = new MySqlExceptionHandler(ex, "Hardware");
throw new Exception(handler.ExceptionType);
}
}
/// <summary>
/// Archives the assigned hardware.
/// </summary>
/// <param name="strSerialNr">The string serial nr.</param>
/// <param name="strInternalNr">The string internal nr.</param>
/// <param name="intEventID">The int event identifier.</param>
public void ArchiveAssignedHardware(String strSerialNr, String strInternalNr, int intEventID)
{
try
{
MySqlConnection mysqlConnectie = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
String dteAssignedDate = DateTime.Today.ToString("yyyy-MM-dd");
mysqlConnectie.Open();
MySqlCommand archiveAssigned = new MySqlCommand("Insert into archive ( assignedDate, serialNr, internalNr, eventID ) values (@assignedDate, @serialNr, @internalNr, @eventID)", mysqlConnectie);
archiveAssigned.Parameters.AddWithValue("@assignedDate", dteAssignedDate);
archiveAssigned.Parameters.AddWithValue("@serialNr", strSerialNr);
archiveAssigned.Parameters.AddWithValue("@internalNr", strInternalNr);
archiveAssigned.Parameters.AddWithValue("@eventID", intEventID);
archiveAssigned.ExecuteNonQuery();
archiveAssigned.Dispose();
mysqlConnectie.Close();
}
catch (MySqlException ex)
{
var handler = new MySqlExceptionHandler(ex, "Hardware");
throw new Exception(handler.ExceptionType);
}
}
