private EntDiscover DataReaderToObject(SqlCeDataReader reader)
{
EntDiscover machine = new EntDiscover();
machine.MachineID = reader.GetInt32(reader.GetOrdinal("MachineID"));
machine.IPAddr = reader.GetString(reader.GetOrdinal("IPAddress"));
machine.LastChecked = reader.GetDateTime(reader.GetOrdinal("LastChecked"));
machine.Discovered = reader.GetBoolean(reader.GetOrdinal("Discovered"));
machine.StatusMessage = reader.GetString(reader.GetOrdinal("StatusMessage"));
machine.DomainName = reader.GetString(reader.GetOrdinal("DomainName"));
machine.MachineName = reader.GetString(reader.GetOrdinal("MachineName"));
machine.CredentialID = reader.GetInt32(reader.GetOrdinal("CredentialID"));
return machine;
}
public DBCode InsertDiscover(EntDiscover discover)
{
DBCode retCode = DBCode.Ok;
try
{
using (DbTransaction transaction = Connection.BeginTransaction())
{
using (SqlCeCommand command = Connection.CreateCommand())
{
command.CommandText = @"
INSERT INTO Discover
(IPAddress, LastChecked, Discovered, StatusMessage, DomainName, MachineName, CredentialID)
VALUES (?, ?, ?, ?, ?, ?, ?)";
command.Parameters.Add(new SqlCeParameter("IPAddress",
SqlDbType.NVarChar, 20)).Value = discover.IPAddr;
command.Parameters.Add(new SqlCeParameter("LastChecked",
SqlDbType.DateTime)).Value = DateTime.Now;
command.Parameters.Add(new SqlCeParameter("Discovered",
SqlDbType.Bit)).Value = discover.Discovered;
command.Parameters.Add(new SqlCeParameter("StatusMessage",
SqlDbType.NVarChar, 512)).Value = discover.StatusMessage;
command.Parameters.Add(new SqlCeParameter("DomainName",
SqlDbType.NVarChar, 200)).Value = discover.DomainName;
command.Parameters.Add(new SqlCeParameter("MachineName",
SqlDbType.NVarChar, 200)).Value = discover.MachineName;
command.Parameters.Add(new SqlCeParameter("CredentialID",
SqlDbType.Int, 4)).Value = discover.CredentialID;
command.ExecuteNonQuery();
}
transaction.Commit();
retCode = DBCode.Ok;
}
}
catch (Exception)
{
retCode = DBCode.Error;
}
return retCode;
}
public DBCode UpdateDiscover(EntDiscover discover)
{
DBCode retCode = DBCode.Ok;
try
{
using (DbTransaction transaction = Connection.BeginTransaction())
{
using (SqlCeCommand command = Connection.CreateCommand())
{
command.CommandText = @"
UPDATE Discover SET LastChecked = ?, Discovered = ?, StatusMessage = ? WHERE MachineID = ?";
command.Parameters.Add(new SqlCeParameter("LastChecked",
SqlDbType.DateTime)).Value = DateTime.Now;
command.Parameters.Add(new SqlCeParameter("Discovered",
SqlDbType.Bit)).Value = discover.Discovered;
command.Parameters.Add(new SqlCeParameter("StatusMessage",
SqlDbType.NVarChar, 512)).Value = discover.StatusMessage;
command.Parameters.Add(new SqlCeParameter("MachineID",
SqlDbType.Int, 4)).Value = discover.MachineID;
command.ExecuteNonQuery();
}
transaction.Commit();
retCode = DBCode.Ok;
}
}
catch (Exception)
{
retCode = DBCode.Error;
}
return retCode;
}
/// <summary>
/// function called when the Machine found event is raised by the nethelper
/// </summary>
/// <param name="sender">Nethelper object</param>
/// <param name="args">MachineDetailsArgs class contains machine details</param>
private void netHelper_MachineFound(object sender, MachineDetailsArgs args)
{
_logger.Info("Found machine "+args.MachineName);
EntDiscover objDbMachine = new EntDiscover();
objDbMachine.DomainName = args.DomainName;
objDbMachine.MachineName = args.MachineName;
objDbMachine.IPAddr = args.IPAddress;
objDbMachine.CredentialID = args.CredentialID;
objDbMachine.StatusMessage = args.StatusMessage;
objDbMachine.Discovered = args.Discovered;
FireStatusMessage("Found machine: " + args.MachineName);
if (disDB.InsertDiscover(objDbMachine) == DBCode.Ok)
{
if (MachineFound != null)
{
MachineFound(this, args);
}
}
objDbMachine = null;
}