/// <summary>
/// Get all device info from DB
/// </summary>
/// <returns>List of device</returns>
public static List <Device> LoadAllDevices()
{
List <Device> devices = new List <Device>();
DataTable dt = null;
try
{
ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient();
DataSet ds = client.DeviceQuery("Q", "", "", "");
dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
string Id = dr["deviceId"].ToString();
string Name = dr["deviceName"].ToString();
string ip = dr["deviceIP"].ToString();
Device device = new Device(Id, Name, ip);
devices.Add(device);
}
return(devices);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// Get device by device id from DB
/// </summary>
/// <param name="deviceId">Id of device need get</param>
/// <returns>One device object</returns>
public static Device LoadDeviceById(string deviceId)
{
Device device = new Device();
DataTable dt = null;
try
{
ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient();
DataSet ds = client.DeviceQuery("Q", deviceId, "", "");
dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
string Id = dr["deviceId"].ToString();
string Name = dr["deviceName"].ToString();
string ip = dr["deviceIP"].ToString();
device = new Device(Id, Name, ip);
}
return(device);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// Auto generate device id base on max device id on DB
/// </summary>
/// <returns>Device ID: DExxxxxxxx </returns>
public static string GenId()
{
string id = "";
DataTable dt = null;
try
{
ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient();
DataSet ds = client.DeviceQuery("S", "", "", "");
dt = ds.Tables[0];
id = dt.Rows[0][0].ToString();
return(id);
}
catch (Exception ex)
{
return(id);
}
}
