public static List <BanksList> GetBanksList()
 {
     using (AprosysAccountingEntities db = new AprosysAccountingEntities())
     {
         try
         {
             return(db.GetBanksWithBalances().Select(x => new BanksList {
                 bankID = x.BankID, bankName = x.BANKNAME, amount = x.AMOUNT
             }).OrderBy(x => x.bankName).ToList());
         }
         catch { throw; }
     }
 }