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; }