public void Update_Test()
{
//arrange
People initial = svc.GetById(4);
PeopleUpdateRequest updateModel = new PeopleUpdateRequest
{
Id = initial.Id,
FirstName = initial.FirstName,
MiddleInitial = initial.MiddleInitial,
LastName = initial.LastName,
DOB = initial.DOB,
ModifiedBy = initial.ModifiedBy
};
//act
svc.Update(updateModel);
People updated = svc.GetById(4);
//assert
Assert.IsTrue(initial.Id == updated.Id, "The Update has failed!");
Assert.IsTrue(initial.FirstName == updated.FirstName, "The Update has failed!");
Assert.IsTrue(initial.MiddleInitial == updated.MiddleInitial, "The Update has failed!");
Assert.IsTrue(initial.LastName == updated.LastName, "The Update has failed!");
Assert.IsTrue(initial.DOB == updated.DOB, "The Update has failed!");
Assert.IsTrue(initial.CreatedDate == updated.CreatedDate, "The Update has failed!");
Assert.IsFalse(initial.ModifiedDate == updated.ModifiedDate, "The Update has failed!");
Assert.IsTrue(initial.ModifiedBy == updated.ModifiedBy, "The Update has failed!");
}
public void Update(PeopleUpdateRequest model)
{
cmd.CommandText = "People_Update";
cmd.Parameters.AddWithValue("@Id", model.Id);
cmd.Parameters.AddWithValue("@FirstName", model.FirstName);
cmd.Parameters.AddWithValue("@MiddleInitial", model.MiddleInitial);
cmd.Parameters.AddWithValue("@LastName", model.LastName);
cmd.Parameters.AddWithValue("@DOB", model.DOB);
cmd.Parameters.AddWithValue("@ModifiedBy", model.ModifiedBy);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public HttpResponseMessage Put([FromBody] PeopleUpdateRequest model)
{
try
{
if (ModelState.IsValid)
{
//placeholder before authentication in place
model.ModifiedBy = "me";
SuccessResponse response = new SuccessResponse();
svc.Update(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public async Task <ApiResultLite> UpdateAsync(PeopleUpdateRequest request)
{
People people = await _context.Peoples.FindAsync(request.Id);
if (people == null)
{
return(new ApiErrorResultLite("Không tìm thấy"));
}
else
{
people.Id = request.Id;
people.DOB = request.DOB;
people.Description = request.Description;
people.Name = request.Name;
_context.Update(people);
int rs = await _context.SaveChangesAsync();
if (rs == 0)
{
return(new ApiErrorResultLite("Cập nhật thất bại"));
}
return(new ApiSuccessResultLite("Cập nhật thành công"));
}
}
public async Task <ApiResultLite> UpdateAsync(PeopleUpdateRequest request)
{
var result = await _PeopleService.UpdateAsync(request);
return(result);
}
public async Task <ApiResultLite> UpdateAsync(PeopleUpdateRequest request)
{
return(await PutAsync <ApiResultLite>("Api/People/Update", request));
}
