/// <summary>
/// Create business provider
/// </summary>
/// <param name="provider">Provider</param>
/// <returns>true if create succeeds</returns>
public bool CreateProvider(Provider provider)
{
const string SQL_CREATE_BUSINESSPROVIDER_STATEMENT = @"
INSERT INTO [Business].[Provider]
(Id,
[ProviderTypeCode],
[RoomCount],
[ContentId],
[UpdatedByUserId])
VALUES(
@Id,
@ProviderTypeCode,
@RoomCount,
@ContentId,
@UpdatedByUserId)";
var providerParameters = new List<SqlParameter>
{
DbHelper.CreateParameter(BusinessMapper.Parameters.Id, provider.Id),
DbHelper.CreateParameter(BusinessMapper.Parameters.RoomCount, provider.RoomCount),
DbHelper.CreateParameter(BusinessMapper.Parameters.ContentId, provider.ContentId),
DbHelper.CreateParameter(BusinessMapper.Parameters.ProviderTypeCode, provider.ProviderTypeCode)
};
AuditFieldsHelper.PopulateAuditFields(providerParameters);
try
{
DbHelper.ExecuteNonQueryCommand(SQL_CREATE_BUSINESSPROVIDER_STATEMENT, parameters: providerParameters);
}
catch (SqlException exception)
{
throw new ExpectedResultException(ErrorFactory.CreateAndLogError(Errors.SRVEX30099, "BusinessDao.CreateProvider", additionalDescriptionParameters: (new object[] { exception.Message }), arguments: new object[] { provider.GetType().Name, provider.Id }));
}
return true;
}
/// <summary>
/// Modify a provider in db
/// </summary>
/// <param name="provider">provider info from business</param>
public void ModifyProvider(Provider provider)
{
const string SQL_UPDATE_PROVIDER_STATEMENT = @"
DECLARE @OriginalContentId varchar(25)
DECLARE @ItemId int
SELECT @OriginalContentId = ContentId
FROM Business.Provider
WHERE Id = @Id
UPDATE Business.Provider
SET
RoomCount = @RoomCount,
ContentId = @ContentId,
ProviderTypeCode = @ProviderTypeCode
WHERE
Id = @Id
IF @@ROWCOUNT > 0 AND @OriginalContentId != @ContentId
BEGIN
EXEC Business.AddBusinessChangeToPushQueue @BusinessId=@Id, @Action='AttributeChange', @IsOptinActive=1, @UserId=@CreatedByUserId, @ItemId=@ItemId output
END";
var providerParameters = new List<SqlParameter>
{
DbHelper.CreateParameter(BusinessMapper.Parameters.Id, provider.Id),
DbHelper.CreateParameter(BusinessMapper.Parameters.RoomCount, provider.RoomCount),
DbHelper.CreateParameter(BusinessMapper.Parameters.ContentId, provider.ContentId),
DbHelper.CreateParameter(BusinessMapper.Parameters.ProviderTypeCode, provider.ProviderTypeCode),
DbHelper.CreateParameter(BusinessMapper.Parameters.CreatedByUserId, AuditFieldsHelper.GetUserId())
};
// Add auditing parameters
AuditFieldsHelper.PopulateAuditFields(providerParameters);
try
{
DbHelper.ExecuteNonQueryCommand(SQL_UPDATE_PROVIDER_STATEMENT, parameters: providerParameters);
}
catch (SqlException exception)
{
throw new ExpectedResultException(ErrorFactory.CreateAndLogError(Errors.SRVEX30099, "BusinessDao.ModifyProvider", additionalDescriptionParameters: (new object[] { exception.Message }), arguments: new object[] { provider.GetType().Name, provider.Id }));
}
}