public void Update(Interface.IbankAccounts bankAccounts) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var bankAccUpdateing = dbContext.tblBankAccounts.SingleOrDefault( x => x.Id == bankAccounts.Id); bankAccUpdateing.accountName = bankAccounts.AccountName; bankAccUpdateing.accountNo = bankAccounts.AccountNo; bankAccUpdateing.balance = Convert.ToDecimal(bankAccounts.Balance); bankAccUpdateing.bank = bankAccounts.Bank; bankAccUpdateing.regNo = bankAccounts.RegNo; dbContext.SubmitChanges(); } }
public void Add(Interface.IbankAccounts bankAccounts) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var newBankAcc = new tblBankAccount() { accountName = bankAccounts.AccountName, accountNo = bankAccounts.AccountNo, balance = Convert.ToDecimal(bankAccounts.Balance), bank = bankAccounts.Bank, regNo = bankAccounts.RegNo, }; dbContext.tblBankAccounts.InsertOnSubmit(newBankAcc); dbContext.SubmitChanges(); } }