public DEVICES_C GetDevices(string DeviceID)
{
DEVICES_C devices_details = new DEVICES_C();
Query = @"SELECT DID,UID,DEVICE_NAME,HOST_NAME,DEVICE_ID,DEVICE_KYE,CONNECTION_STATUS,TXRX_LIMIT,BANDWIDTH,DATE_FORMAT(UPTIME,'%d/%m/%Y') AS UPTIME,USER_NAME FROM DEVICES WHERE DID=@DID";
DataTable DataTable_DEVICES = db.ExecuteSelect(Query, new MySqlParameter("@DID", DeviceID));
if (DataTable_DEVICES.Rows.Count > 0)
{
foreach (DataRow item in DataTable_DEVICES.Rows)
{
devices_details.DID = item["DID"].ToString();
devices_details.UID = item["UID"].ToString();
devices_details.DEVICE_NAME = item["DEVICE_NAME"].ToString();
devices_details.HOST_NAME = item["HOST_NAME"].ToString();
devices_details.DEVICE_ID = item["DEVICE_ID"].ToString();
devices_details.DEVICE_KYE = item["DEVICE_KYE"].ToString();
devices_details.CONNECTION_STATUS = item["CONNECTION_STATUS"].ToString();
devices_details.TXRX_LIMIT = item["TXRX_LIMIT"].ToString();
devices_details.BANDWIDTH = item["BANDWIDTH"].ToString();
devices_details.UPTIME = item["UPTIME"].ToString();
devices_details.USER_NAME = item["USER_NAME"].ToString();
}
}
return(devices_details);
}
public List <DEVICES_C> GetAllDevices()
{
List <DEVICES_C> list_devices_details = new List <DEVICES_C>();
Query = @"SELECT DID,UID,DEVICE_NAME,HOST_NAME,DEVICE_ID,DEVICE_KYE,CONNECTION_STATUS,TXRX_LIMIT,BANDWIDTH,DATE_FORMAT(UPTIME,'%d/%m/%Y') AS UPTIME,USER_NAME FROM DEVICES";
DataTable DataTable_DEVICES = db.ExecuteSelect(Query);
if (DataTable_DEVICES.Rows.Count > 0)
{
foreach (DataRow item in DataTable_DEVICES.Rows)
{
DEVICES_C devices_details = new DEVICES_C();
devices_details.DID = item["DID"].ToString();
devices_details.UID = item["UID"].ToString();
devices_details.DEVICE_NAME = item["DEVICE_NAME"].ToString();
devices_details.HOST_NAME = item["HOST_NAME"].ToString();
devices_details.DEVICE_ID = item["DEVICE_ID"].ToString();
devices_details.DEVICE_KYE = item["DEVICE_KYE"].ToString();
devices_details.CONNECTION_STATUS = item["CONNECTION_STATUS"].ToString();
devices_details.TXRX_LIMIT = item["TXRX_LIMIT"].ToString();
devices_details.BANDWIDTH = item["BANDWIDTH"].ToString();
devices_details.UPTIME = item["UPTIME"].ToString();
devices_details.USER_NAME = item["USER_NAME"].ToString();
list_devices_details.Add(devices_details);
}
}
return(list_devices_details);
}
public void GetDevices(string DeviceID)
{
DEVICES_C devices = dbop.GetDevices(DeviceID);
if (string.IsNullOrWhiteSpace(devices.DID))
{
devices = null;
}
System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
Context.Response.Write(js.Serialize(devices));
}
