//DELETE: api/Movimientos/1
public HttpResponseMessage Delete(int id)
{
HttpResponseMessage answer = null;
MovResponse response = new MovResponse();
try
{
int rowCount = MovDataDb.movDelete(id);
if (rowCount > 0)
{
response.Code = 1;
response.Message = "Eliminado";
}
else
{
response.Code = 0;
response.Message = "Error al eliminar";
}
answer = Request.CreateResponse(response);
}
catch (Exception ex)
{
response.Code = -1;
response.Message = ex.ToString();
answer = Request.CreateResponse(response);
}
return(answer);
}
//PUT: api/Movimientos/
public HttpResponseMessage Put([FromBody] Movimientos values)
{
HttpResponseMessage answer = null;
MovResponse response = new MovResponse();
try
{
int rowCount = MovDataDb.movUpdate(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/Movimientos
public HttpResponseMessage Post([FromBody] Movimientos values)
{
HttpResponseMessage answer = null;
MovResponse response = new MovResponse();
try
{
int index = MovDataDb.movAdd(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/Movimientos
public HttpResponseMessage Get()
{
HttpResponseMessage answer = null;
MovResponse response = new MovResponse();
try
{
using (DataSet data = MovDataDb.movGetAll())
{
if (data != null)
{
response.Code = 1;
response.Message = "Ok";
if (data.Tables[0].Rows.Count > 0)
{
Movimientos[] list = new Movimientos[data.Tables[0].Rows.Count];
for (int i = 0; i < data.Tables[0].Rows.Count; i++)
{
Movimientos obj = new Movimientos();
obj.id = Convert.ToInt32(data.Tables[0].Rows[i][0]);
obj.cantidad = Convert.ToInt32(data.Tables[0].Rows[i][1]);
obj.tipo_movimiento = Convert.ToInt32(data.Tables[0].Rows[i][2]);
obj.descripcion = Convert.ToString(data.Tables[0].Rows[i][3]);
obj.fecha_movimiento = Convert.ToString(data.Tables[0].Rows[i][4]);
obj.latitud = Convert.ToDouble(data.Tables[0].Rows[i][5]);
obj.longitud = Convert.ToDouble(data.Tables[0].Rows[i][6]);
obj.id_usuario = Convert.ToInt32(data.Tables[0].Rows[i][7]);
list[i] = obj;
}
response.Values = list;
}
answer = Request.CreateResponse(response);
}
else
{
response.Code = -1;
response.Message = "mmm algo ha salido mal";
answer = Request.CreateResponse(response);
}
}
}
catch (Exception ex)
{
response.Code = -1;
response.Message = ex.ToString();
answer = Request.CreateResponse(response);
}
return(answer);
}
