Esempio n. 1
0
 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;
     }
 }
Esempio n. 2
0
        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);
            }
        }