// DELETE: api/GpsData/5
        public HttpResponseMessage Delete(int id)
        {
            HttpResponseMessage answer   = null;
            Response            response = new Response();

            try
            {
                int rowCount = GpsDataDB.gpsDataDelete(id);

                if (rowCount > 0)
                {
                    response.code    = 1;
                    response.message = "Eliminado";
                }
                else
                {
                    response.code    = 0;
                    response.message = "NO eliminado";
                }

                answer = Request.CreateResponse(response);
            }
            catch (Exception ex)
            {
                response.code    = -1;
                response.message = ex.ToString();
                answer           = Request.CreateResponse(response);
            }

            return(answer);
        }
        // PUT: api/GpsData/
        public HttpResponseMessage Put([FromBody] GpsData values)
        {
            HttpResponseMessage answer   = null;
            Response            response = new Response();

            try
            {
                int rowCount = GpsDataDB.gpsDataUpdate(values);

                if (rowCount > 0)
                {
                    response.code    = 1;
                    response.message = "Actualizado";
                }
                else
                {
                    response.code    = 0;
                    response.message = "NO Actualizado";
                }

                answer = Request.CreateResponse(response);
            }
            catch (Exception ex)
            {
                response.code    = -1;
                response.message = ex.ToString();
                answer           = Request.CreateResponse(response);
            }

            return(answer);
        }
        // POST: api/GpsData
        public HttpResponseMessage Post([FromBody] GpsData values)
        {
            HttpResponseMessage answer   = null;
            Response            response = new Response();

            try
            {
                int index = GpsDataDB.gpsDataAdd(values);

                if (index > 0)
                {
                    response.code    = 1;
                    response.message = "Guardado";
                }
                else
                {
                    response.code    = 0;
                    response.message = "NO Guardado";
                }

                answer = Request.CreateResponse(response);
            }
            catch (Exception ex)
            {
                response.code    = -1;
                response.message = ex.ToString();
                answer           = Request.CreateResponse(response);
            }

            return(answer);
        }
        // GET: api/GpsData
        public HttpResponseMessage Get()
        {
            HttpResponseMessage answer   = null;
            Response            response = new Response();

            try
            {
                using (DataSet data = GpsDataDB.gpsDataGetAll())
                {
                    if (data != null)
                    {
                        response.code    = 1;
                        response.message = "Ok";

                        if (data.Tables[0].Rows.Count > 0)
                        {
                            GpsData[] list = new GpsData[data.Tables[0].Rows.Count];

                            for (int i = 0; i < data.Tables[0].Rows.Count; i++)
                            {
                                GpsData obj = new GpsData();

                                obj.id         = Convert.ToInt32(data.Tables[0].Rows[i][0]);
                                obj.dateSystem = Convert.ToString(data.Tables[0].Rows[i][1]);
                                obj.dateEvent  = Convert.ToString(data.Tables[0].Rows[i][2]);
                                obj.latitude   = Convert.ToSingle(data.Tables[0].Rows[i][3]);
                                obj.longitude  = Convert.ToSingle(data.Tables[0].Rows[i][4]);

                                obj.battery = Convert.ToInt32(data.Tables[0].Rows[i][5]);
                                obj.source  = Convert.ToInt32(data.Tables[0].Rows[i][6]);
                                obj.type    = Convert.ToInt32(data.Tables[0].Rows[i][7]);

                                list[i] = obj;
                            }

                            response.values = list;
                        }

                        answer = Request.CreateResponse(response);
                    }
                    else
                    {
                        response.code    = -1;
                        response.message = "ups!! algo salió mal°°";
                        answer           = Request.CreateResponse(response);
                    }
                }
            }
            catch (Exception ex) {
                response.code    = -1;
                response.message = ex.ToString();
                answer           = Request.CreateResponse(response);
            }

            return(answer);
        }