public IHttpActionResult Post([FromBody] RequestSkyData value)
{
try
{
//value = null;
logger.Info("Datos recibidos -> Post([FromBody]string value) " + value.ToString());
RequestSkyData item = value;// Newtonsoft.Json.JsonConvert.DeserializeObject<Request>(value);
logger.Info("Serialize Datos recibidos -> { JsonConvert.SerializeObject(item) " + value.ToString());
logger.Info("Resultado -> " + InsertValues(item));
return(Ok("Salio OK"));
}
catch (Exception ex)
{
logger.Info("Error -> " + ex.Message);
throw;
}
}
private static string InsertValues(RequestSkyData request)
{
try
{
string connetionString = null;
SqlConnection connection;
SqlDataAdapter adapter;
SqlCommand command = new SqlCommand();
SqlParameter param;
SqlParameter paramReturnErrorCode;
SqlParameter paramReturnErrorMessage;
string strResponse;
string longitud;
string latitud;
ConnectionStringSettings mySetting = ConfigurationManager.ConnectionStrings["cnnSkyData"];
if (mySetting == null || string.IsNullOrEmpty(mySetting.ConnectionString))
{
throw new Exception("Fatal error: missing connecting string in web.config file");
}
connetionString = mySetting.ConnectionString;
connection = new SqlConnection(connetionString);
connection.Open();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "sp_AddGpsHistoricoMovilesActuales";
param = new SqlParameter("@patente", request.license_plate ?? "");
param.Direction = ParameterDirection.Input;
param.DbType = DbType.String;
command.Parameters.Add(param);
if (!request.lon.ToString().Contains(InitSepDecimal()))
{
longitud = request.lon.ToString().Replace(OtroSepDecimal(), InitSepDecimal());
}
else
{
longitud = request.lon.ToString();
}
if (!request.lat.ToString().Contains(InitSepDecimal()))
{
latitud = request.lat.ToString().Replace(OtroSepDecimal(), InitSepDecimal());
}
else
{
latitud = request.lat.ToString();
}
param = new SqlParameter("@latitud", Convert.ToDecimal(latitud));
param.Direction = ParameterDirection.Input;
param.DbType = DbType.Decimal;
command.Parameters.Add(param);
param = new SqlParameter("@longitud", Convert.ToDecimal(longitud));
param.Direction = ParameterDirection.Input;
param.DbType = DbType.Decimal;
command.Parameters.Add(param);
param = new SqlParameter("@fecHorTransmision", request.event_time);
param.Direction = ParameterDirection.Input;
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
paramReturnErrorCode = new SqlParameter("@errorCode", " ");
paramReturnErrorCode.Direction = ParameterDirection.Output;
paramReturnErrorCode.DbType = DbType.String;
command.Parameters.Add(paramReturnErrorCode);
paramReturnErrorMessage = new SqlParameter("@errorMessage", SqlDbType.VarChar, 100);
paramReturnErrorMessage.Direction = ParameterDirection.Output;
paramReturnErrorMessage.DbType = DbType.String;
command.Parameters.Add(paramReturnErrorMessage);
command.ExecuteNonQuery();
adapter = new SqlDataAdapter(command);
if (paramReturnErrorCode.Value.ToString() == string.Empty)
{
strResponse = "Se inserto el registro correactamente: " + request.license_plate;
}
else
{
strResponse = "Se inserto el registro con error: " + request.license_plate + " - " + paramReturnErrorMessage.Value.ToString();
}
connection.Close();
return(strResponse);
}
catch (Exception e)
{
logger.Error(e);
return(e.Message);
}
}