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