public string checkMedal(long acc) { BankEntities2 dbContext2 = new BankEntities2(); int amt; CustomerClass obj = new CustomerClass(); Account account = dbContext.Accounts.Where(val => val.accountNo == acc).Single <Account>(); amt = (int)(account.amount); CustomerMedal medal = dbContext2.CustomerMedals.Where(val => val.min <amt && val.max> amt).Single <CustomerMedal>(); account.type = medal.type; dbContext.SaveChanges(); return(account.type); }
public void insTrans(long acc1, long acc2, int amt, string type, string comment) { BankEntities2 dbContext = new BankEntities2(); string date = DateTime.Now.ToString(); Transaction transactionInsert = new Transaction { fromAccountNo = acc1, toAccountNo = acc2, transactionDate = date, amount = amt, transactionType = type, comments = comment }; dbContext.Transactions.Add(transactionInsert); dbContext.SaveChanges(); }