public int Add()
{
// Add from the database
AuditWizardDataAccess lwDataAccess = new AuditWizardDataAccess();
_alertID = lwDataAccess.AlertAdd(this);
return(_alertID);
}
/// <summary>
/// Add a new Alert to the database
/// </summary>
/// <param name="theAlert"></param>
/// <returns></returns>
public int AlertAdd(Alert aAlert)
{
if (isDebugEnabled)
{
logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " in");
}
int lItemID = 0;
if (compactDatabaseType)
{
try
{
using (SqlCeConnection conn = DatabaseConnection.CreateOpenCEConnection())
{
string commandText =
"INSERT INTO ALERTS " +
"(_TYPE, _CATEGORY ,_MESSAGE ,_FIELD1 ,_FIELD2 ,_STATUS ,_ALERTDATE ,_ASSETNAME ,_ALERTNAME) " +
"VALUES " +
"(@nType, @nCategory, @cMessage, @cField1, @cField2 ,0 ,@dtmDate ,@cAssetName ,@cAlertName)";
SqlCeParameter[] spParams = new SqlCeParameter[8];
spParams[0] = new SqlCeParameter("@nType", (int)aAlert.Type);
spParams[1] = new SqlCeParameter("@nCategory", (int)aAlert.Category);
spParams[2] = new SqlCeParameter("@cMessage", aAlert.Message);
spParams[3] = new SqlCeParameter("@cField1", aAlert.Field1);
spParams[4] = new SqlCeParameter("@cField2", aAlert.Field2);
spParams[5] = new SqlCeParameter("@dtmDate", DateTime.Now);
spParams[6] = new SqlCeParameter("@cAssetName", aAlert.AssetName);
spParams[7] = new SqlCeParameter("@cAlertName", aAlert.AlertName);
using (SqlCeCommand command = new SqlCeCommand(commandText, conn))
{
command.Parameters.AddRange(spParams);
command.ExecuteNonQuery();
}
using (SqlCeCommand commandReturnValue = new SqlCeCommand("SELECT @@IDENTITY", conn))
{
lItemID = Convert.ToInt32(commandReturnValue.ExecuteScalar());
}
}
}
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();
lItemID = lAuditWizardDataAccess.AlertAdd(aAlert);
}
if (isDebugEnabled)
{
logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " out");
}
return(lItemID);
}