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); } }