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