Exemple #1
0
    void SendResultInfoAsJson(AddCarResponse res)
    {
        string strJson = JsonConvert.SerializeObject(res);

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(strJson);
        Response.End();
    }
        public AddCarResponse Delete(int id)
        {
            var response = new AddCarResponse
            {
                Errors = new List <string>()
            };

            _carRepository.Delete(id);

            response.Success = true;
            return(response);
        }
Exemple #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        AddCarResponse res = new AddCarResponse();
        AddCarRequest  req;

        res.error = String.Empty;

        // Need passed in store id and number of requested results.
        // 1. Deserialize the incoming Json.
        try
        {
            req = GetRequestInfo();
        }
        catch (Exception ex)
        {
            res.error = ex.Message.ToString();

            // Return the results as Json.
            SendResultInfoAsJson(res);

            return;
        }

        SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

        try
        {
            connection.Open();

            string sql = String.Format("insert into Cars (Make,Model,Year) VALUES ('{0}','{1}',{2})",
                                       req.make, req.model, req.year);

            SqlCommand command = new SqlCommand(sql, connection);
            command.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            res.error = ex.Message.ToString();
        }
        finally
        {
            if (connection.State == ConnectionState.Open)
            {
                connection.Close();
            }
        }

        // Return the results as Json.
        SendResultInfoAsJson(res);
    }
        public AddCarResponse AddCar(AddCarRequest request)
        {
            var response = new AddCarResponse
            {
                Errors = new List <string>()
            };

            //TODO: validari


            _carRepository.Add(new Car
            {
                UserId             = request.UserId,
                Make               = request.Make,
                Manufacturer       = request.Manufacturer,
                Plant              = request.Plant,
                ModelYear          = request.ModelYear,
                Model              = request.Model,
                Body               = request.Body,
                Drive              = request.Drive,
                NumberofSeats      = request.NumberofSeats,
                NumberofDoors      = request.NumberofDoors,
                Steering           = request.Steering,
                EngineDisplacement = request.EngineDisplacement,
                EngineCylinders    = request.EngineCylinders,
                NumberofGears      = request.NumberofGears,
                Engine             = request.Engine,
                Made               = request.Made,
                Color              = request.Color,
                Fuel               = request.Fuel,
                Cc        = request.Cc,
                Power     = request.Power,
                Emissions = request.Emissions,
                Odometer  = request.Odometer,
                Vin       = request.Vin,
                License   = request.License,
                CarImage  = request.CarImage
            });

            response.Success = true;
            return(response);
        }