public JsonResult put(PersonPhoneModel personPhone) { string query = @" update dbo.PersonPhone set ('" + personPhone.phoneNumber + @", '" + personPhone.phoneNumberTypeID + @" where businessEntityID = " + personPhone.businessEntityID; DataTable table = new DataTable(); string sqlDataSource = _configuration.GetConnectionString("PhonePersonAppCon"); SqlDataReader myReader; using (SqlConnection myCon = new SqlConnection(sqlDataSource)) { myCon.Open(); using (SqlCommand myCommand = new SqlCommand(query, myCon)) { myReader = myCommand.ExecuteReader(); table.Load(myReader); myReader.Close(); if (myCon != null) { myCon.Close(); } } return(new JsonResult("Updated Successfully")); } }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test PersonPhoneModel inserted = new PersonPhoneModel(); inserted.BusinessEntityID = TestSession.Random.Next(); inserted.PhoneNumber = TestSession.Random.RandomString(25); inserted.PhoneNumberTypeID = TestSession.Random.Next(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new PersonPhoneModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, PhoneNumber = inserted.PhoneNumber, PhoneNumberTypeID = inserted.PhoneNumberTypeID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterInsert.BusinessEntityID); Assert.AreEqual(inserted.PhoneNumber, selectedAfterInsert.PhoneNumber); Assert.AreEqual(inserted.PhoneNumberTypeID, selectedAfterInsert.PhoneNumberTypeID); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new PersonPhoneModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, PhoneNumber = inserted.PhoneNumber, PhoneNumberTypeID = inserted.PhoneNumberTypeID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterUpdate.BusinessEntityID); Assert.AreEqual(inserted.PhoneNumber, selectedAfterUpdate.PhoneNumber); Assert.AreEqual(inserted.PhoneNumberTypeID, selectedAfterUpdate.PhoneNumberTypeID); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new PersonPhoneModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, PhoneNumber = inserted.PhoneNumber, PhoneNumberTypeID = inserted.PhoneNumberTypeID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }