/// <summary> /// Gets user transactions by userid /// </summary> /// <param name="userId"></param> /// <returns>Trasaction collection</returns> public static IList <Transaction> GetUserTransactionsByUserId(int userId) { MiniStatementContext miniStatementContext; var transactions = new List <Transaction>(); try { using (miniStatementContext = new MiniStatementContext()) { transactions = miniStatementContext.Transactions.Include("User").Include("Account").Where(x => x.UserId == userId).ToList(); } } catch (Exception) { } return(transactions); }
/// <summary> /// Gets Account by AccountId. /// </summary> /// <param name="AccountId"></param> /// <returns>Account</returns> public static Account GetAccountByAccountId(int accountId) { MiniStatementContext miniStatementContext; var account = new Account(); try { using (miniStatementContext = new MiniStatementContext()) { account = miniStatementContext.Accounts.Where(x => x.AccountId == accountId).FirstOrDefault(); } } catch (Exception) { } return(account); }
/// <summary> /// Gets user accounts by userId. /// </summary> /// <param name="userId"></param> /// <returns>User Accounts</returns> public static List <UserAccounts> GetUserAccountsByUserId(int userId) { MiniStatementContext miniStatementContext; var userAccounts = new List <UserAccounts>(); try { using (miniStatementContext = new MiniStatementContext()) { userAccounts = miniStatementContext.UserAccounts.Include("Account").Where(x => x.UserId == userId).ToList(); } } catch (Exception) { } return(userAccounts); }
/// <summary> /// Gets user by email. /// </summary> /// <param name="email"></param> /// <returns>User Data</returns> public static User GetUserByEmail(string email) { MiniStatementContext miniStatementContext; var user = new User(); try { using (miniStatementContext = new MiniStatementContext()) { user = miniStatementContext.Users.Where(x => x.Email.ToUpper() == email.ToUpper()).FirstOrDefault(); } } catch (Exception ex) { var z = ex.StackTrace; } return(user); }