public void UserLocationHistory(string PhoneUID, int RecordNumners) { DBConnection DBop = new DBConnection(); ResponsePhoneInfo messeageResponsePhoneInfo = new ResponsePhoneInfo(); DataTable dataTable = new DataTable(); JavaScriptSerializer ser = new JavaScriptSerializer(); dataTable = DBop.NewConectionDLL.SelectDataSet("Tracking", "top " + RecordNumners + " *", "PhoneUID = '" + PhoneUID + "'", " DateRecord desc").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { PhonesInfo[] phonelist = new PhonesInfo[dataTable.Rows.Count]; for (int i = 0; i < dataTable.Rows.Count; i++) { phonelist[i] = new PhonesInfo(null, null, (int)dataTable.Rows[i]["BatteryLevel"], Convert.ToDouble(dataTable.Rows[i]["Latitude"]), Convert.ToDouble(dataTable.Rows[i]["longitude"]), Convert.ToString(dataTable.Rows[i]["DateRecord"])); } messeageResponsePhoneInfo.UsersPhonesInfo = phonelist; messeageResponsePhoneInfo.ErrorID = (int)ErrorNumbers.Found; HttpContext.Current.Response.Write(ser.Serialize(messeageResponsePhoneInfo)); return; } else { messeageResponsePhoneInfo.ErrorID = (int)ErrorNumbers.NotFound; HttpContext.Current.Response.Write(ser.Serialize(messeageResponsePhoneInfo)); return; } }
public void UsersPhoneLocations(string UserUID) { DBConnection DBop = new DBConnection(); ResponsePhoneInfo messeageResponsePhoneInfo = new ResponsePhoneInfo(); DataTable dataTable = new DataTable(); JavaScriptSerializer ser = new JavaScriptSerializer(); dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " UserID ", " UserUID = '" + UserUID + "'").Tables[0]; if ((dataTable == null) || (dataTable.Rows.Count == 0)) { messeageResponsePhoneInfo.ErrorID = (int)ErrorNumbers.NotFound; HttpContext.Current.Response.Write(ser.Serialize(messeageResponsePhoneInfo)); return; } int UserID = (int)dataTable.Rows[0]["UserID"]; ColProcedureParam[] Coloumns1 = new ColProcedureParam[1]; Coloumns1[0] = new ColProcedureParam("UserID", Convert.ToString(UserID)); dataTable = DBop.NewConectionDLL.SelectDataSetProcedureTable("GetUpdateLocation", Coloumns1).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { PhonesInfo[] phonelist = new PhonesInfo[dataTable.Rows.Count]; for (int i = 0; i < dataTable.Rows.Count; i++) { phonelist[i] = new PhonesInfo( Convert.ToString(dataTable.Rows[i]["PhoneUID"]), Convert.ToString(dataTable.Rows[i]["PhoneName"]), (int)dataTable.Rows[i]["BatteryLevel"], Convert.ToDouble(dataTable.Rows[i]["Latitude"]), Convert.ToDouble(dataTable.Rows[i]["longitude"]), Convert.ToString(dataTable.Rows[i]["DateRecord"])); } messeageResponsePhoneInfo.UsersPhonesInfo = phonelist; messeageResponsePhoneInfo.ErrorID = (int)ErrorNumbers.Found; HttpContext.Current.Response.Write(ser.Serialize(messeageResponsePhoneInfo)); return; } else { messeageResponsePhoneInfo.ErrorID = (int)ErrorNumbers.NotFound; HttpContext.Current.Response.Write(ser.Serialize(messeageResponsePhoneInfo)); return; } }