public CentralConnectCode CreateDevice(Device device)
{
ClientAction clientAction = new ClientAction(this.ConnectString);
List<Client> clients = clientAction.RetrieveClientByClientNameAndDomain(device.ClientName, device.ClientDomain);
if (clients.Count != 1)
{
return CentralConnectCode.ClientNotFound;
}
if (Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(this.ConnectString, "SP_CreateCentralConnectDevice", device.DeviceName, device.Domain, device.ProductNumber, device.SerialNumber, device.CoreSystemModel, device.OSName, device.OSVersion, device.ClientName, device.ClientDomain, device.CreateBy) != 1)
{
return CentralConnectCode.CreateDeviceFail;
}
return CentralConnectCode.Success;
}
public List<Device> RetrieveRegisterDeviceByEnvironmentAndClientNameAndClientDomain(string environment, string clientName, string domain)
{
DataSet dataSet = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(this.ConnectString, "SP_RetrieveCentralConnectRegisterDeviceByEnvironmentAndClientNameAndClientDomain", environment,clientName, domain);
List<Device> devices = new List<Device>();
foreach (DataRow item in dataSet.Tables[0].Rows)
{
Device device = new Device();
device.DeviceName = item["DeviceName"] as string;
device.Domain = item["Domain"] as string;
device.ProductNumber = item["ProductNumber"] as string;
device.SerialNumber = item["SerialNumber"] as string;
device.CoreSystemModel = item["CoreSystemModel"] as string;
device.MAC = item["MAC"] as string;
device.OSName = item["OSName"] as string;
device.OSVersion = item["OSVersion"] as string;
device.IPAddress = HP.TS.Devops.Core.IPHelper.NumberToIP((int)item["IPAddress"]);
device.ClientName = item["ClientName"] as string;
device.ClientDomain = item["ClientDomain"] as string;
device.CreateBy = item["CreateBy"] as string;
devices.Add(device);
}
return devices;
}
