public void UpdateBusinessLogoAcceptsData() { //Arrange var logo = new BusinessLogo { BusinessId = 1, LogoDigest = "ABCDEFGHIJKLMNOP", LogoExtension = ".png", LogoId = new Guid() }; //Act businessDao.UpdateBusinessLogo(logo); var business = businessDao.GetByKey(1); //Assert Assert.AreEqual(logo.LogoDigest, business.Logo.LogoDigest); Assert.AreEqual(logo.LogoExtension, business.Logo.LogoExtension); Assert.AreEqual(logo.LogoId, business.Logo.LogoId); }
/// <summary> /// Update the saved Logo information for a Business /// </summary> /// <param name="logo">BusinessLogo object</param> public void UpdateBusinessLogo(BusinessLogo logo) { businessDao.UpdateBusinessLogo(logo); }
/// <summary> /// Update the saved Logo information for a Business /// </summary> /// <param name="logo">Business Logo object</param> public void UpdateBusinessLogo(BusinessLogo logo) { const string SQL = "Update Business.Business SET LogoId = @LogoId, LogoDigest = @LogoDigest, LogoExtension = @LogoExtension WHERE Id = @Id"; var parameters = new List<SqlParameter> { DbHelper.CreateParameter(BusinessMapper.Parameters.Id, logo.BusinessId), DbHelper.CreateParameter(BusinessMapper.Parameters.LogoDigest, logo.LogoDigest), DbHelper.CreateParameter(BusinessMapper.Parameters.LogoExtension, logo.LogoExtension), DbHelper.CreateParameter(BusinessMapper.Parameters.LogoId, logo.LogoId) }; DbHelper.ExecuteNonQueryCommand(SQL, parameters: parameters); }