/// <summary>
/// Update the specified Asset Type
/// </summary>
/// <param name="theAsset"></param>
/// <returns></returns>
public int AssetTypeUpdate(AssetType aAssetType)
{
if (isDebugEnabled)
{
logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " in");
}
if (compactDatabaseType)
{
try
{
using (SqlCeConnection conn = DatabaseConnection.CreateOpenCEConnection())
{
string commandText =
"UPDATE ASSET_TYPES " +
"SET " +
"_NAME = @cName, " +
"_PARENTID = @nParentID, " +
"_ICON = @cIcon " +
"WHERE _ASSETTYPEID = @nAssetTypeID";
SqlCeParameter[] spParams = new SqlCeParameter[4];
spParams[0] = new SqlCeParameter("@nAssetTypeID", aAssetType.AssetTypeID);
spParams[1] = new SqlCeParameter("@cName", aAssetType.Name);
if (aAssetType.ParentID == 0)
{
spParams[2] = new SqlCeParameter("@nParentID", DBNull.Value);
}
else
{
spParams[2] = new SqlCeParameter("@nParentID", aAssetType.ParentID);
}
spParams[3] = new SqlCeParameter("@cIcon", aAssetType.Icon);
using (SqlCeCommand command = new SqlCeCommand(commandText, conn))
{
command.Parameters.AddRange(spParams);
command.ExecuteNonQuery();
}
}
}
catch (SqlCeException ex)
{
Utility.DisplayErrorMessage("A database error has occurred in AuditWizard." + Environment.NewLine + Environment.NewLine +
"Please see the log file for further details.");
logger.Error("Exception in " + System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
}
catch (Exception ex)
{
Utility.DisplayErrorMessage("A database error has occurred in AuditWizard." + Environment.NewLine + Environment.NewLine +
"Please see the log file for further details.");
logger.Error("Exception in " + System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
}
}
else
{
AuditWizardDataAccess lAuditWizardDataAccess = new AuditWizardDataAccess();
lAuditWizardDataAccess.AssetTypeUpdate(aAssetType);
}
if (isDebugEnabled)
{
logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " out");
}
return(0);
}