public void AddAddress(UserAccount account, BillerAddAddressIM im)
{
var count = new BillerAddressDAC().GetAllAddresses(account.Id).Count;
if (count >= 500)
{
throw new CommonException(ReasonCode.BillerOverMaxAddressCount, Resources.BillerOverAddressMaxCount);
}
if (new BillerAddressDAC().GetAllAddresses(account.Id).Any(item =>
item.BillerCode == im.BillerCode && im.ReferenceNumber == item.ReferenceNumber))
{
throw new CommonException(ReasonCode.BillerAddressExisted, Resources.BillerAddressExisted);
}
var address = new BillerAddress()
{
BillerCode = im.BillerCode,
IconIndex = im.IconIndex,
ReferenceNumber = im.ReferenceNumber,
Tag = im.Tag,
AccountId = account.Id,
Timestamp = DateTime.UtcNow
};
new BillerAddressDAC().Insert(address);
}
public void Update(BillerAddress address)
{
const string sql =
@"UPDATE [dbo].[BillerAddresses] SET [BillerCode] = @BillerCode ,[ReferenceNumber] = @ReferenceNumber ,[Tag] = @Tag ,[Timestamp] = @Timestamp ,[IconIndex] = @IconIndex WHERE Id = @Id";
using (var con = WriteConnection())
{
con.Execute(sql, address);
}
}
public void Insert(BillerAddress address)
{
const string sql =
@"INSERT INTO [dbo].[BillerAddresses] ([AccountId],[BillerCode],[ReferenceNumber],[Tag],[IconIndex],[Timestamp])
VALUES (@AccountId,@BillerCode,@ReferenceNumber,@Tag,@IconIndex,@Timestamp);";
using (var con = WriteConnection())
{
con.Execute(sql, address);
}
}
