Example #1
0
        //Updates a record into the database and returns an Id
        public void Update(DogsUpdateRequest model)
        {
            using (SqlConnection conn = new SqlConnection(_connection))
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = "spFamilyDogs_Update";
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@Name", model.Name);
                cmd.Parameters.AddWithValue("@Breed", model.Breed);
                cmd.Parameters.AddWithValue("@Color", model.Color ?? (object)DBNull.Value);
                cmd.Parameters.AddWithValue("@Size", model.Size);
                cmd.Parameters.AddWithValue("@LivingArea", model.LivingArea);
                cmd.Parameters.AddWithValue("@LifeExpt", model.LifeExpectancy);
                cmd.Parameters.AddWithValue("@ShedScore", model.ShedScore);
                cmd.Parameters.AddWithValue("@AggressiveScore", model.AgressiveScore);
                cmd.Parameters.AddWithValue("@ExerciseScore", model.ExerciseScore);
                cmd.Parameters.AddWithValue("@ImageUrl", model.Image ?? (object)DBNull.Value);
                cmd.Parameters.AddWithValue("@Id", model.Id);

                conn.Open();
                cmd.ExecuteNonQuery();
            }
        }
Example #2
0
        public ActionResult Edit(DogsUpdateRequest model)
        {
            if (!ModelState.IsValid)
            {
                return(View("Edit", model));
            }

            if (model.ImageUpload != null && model.ImageUpload.ContentLength > 0)
            {
                string fileName  = Path.GetFileNameWithoutExtension(model.ImageUpload.FileName);
                string extension = Path.GetExtension(model.ImageUpload.FileName);
                fileName    = fileName + extension;
                model.Image = "~/Image/" + fileName;
                fileName    = Path.Combine(Server.MapPath("~/Image/"), fileName);
                model.ImageUpload.SaveAs(fileName);
            }

            if (model.ImageUpload == null || model.ImageUpload.ContentLength == 0)
            {
                model.Image = "~/Image/image-not-found.png";
            }

            DogService ds = new DogService();

            ds.Update(model);
            return(RedirectToAction("DogsIndex"));
        }
Example #3
0
        public ActionResult Edit(int id)
        {
            var dog = ds.GetById(id);

            if (dog == null)
            {
                return(HttpNotFound());
            }

            DogsUpdateRequest model = new DogsUpdateRequest();

            model.Id             = dog.Id;
            model.Name           = dog.Name;
            model.Breed          = dog.Breed;
            model.Color          = dog.Color;
            model.Size           = dog.Size;
            model.LivingArea     = dog.LivingArea;
            model.LifeExpectancy = dog.LifeExpectancy;
            model.ShedScore      = dog.ShedScore;
            model.AgressiveScore = dog.AgressiveScore;
            model.ExerciseScore  = dog.ExerciseScore;
            model.Image          = dog.Image;

            return(View(model));
        }
        public HttpResponseMessage Update(DogsUpdateRequest model)
        {
            if (!ModelState.IsValid)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
            }

            SuccessResponse response = new SuccessResponse();

            ds.Update(model);
            return(Request.CreateResponse(HttpStatusCode.OK, response));
        }