//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(); } }
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")); }
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)); }