Exemplo n.º 1
0
        public User Login(User user)
        {
            try
            {
                using (CapitalContext context = new CapitalContext())
                {
                    var checkUser = context.Users
                            .Where(x =>
                                x.Email.ToLower().Equals(user.Email.ToLower()) &&
                                x.Password.Equals(user.Password))
                            .FirstOrDefault();

                    if (checkUser != null)
                    {
                        if (user.Devices != null)
                        {
                            if (user.Devices.Count > 0)
                            {
                                Device temp = user.Devices.SingleOrDefault();

                                if (context.Devices.Where(x => x.UserId == checkUser.UserId && x.UniqueDeviceId == temp.UniqueDeviceId).FirstOrDefault() == null)
                                {
                                    // New Phone
                                    temp.UserId = checkUser.UserId;
                                    temp.CreationDate = DateTime.Now;
                                    context.Devices.Add(temp);
                                    context.SaveChanges();
                                }
                            }
                        }

                        checkUser.LastAccessDate = DateTime.Now;
                        context.SaveChanges();
                    }
                    else
                    {
                        throw new ModelException("Invalid Email Address and/or Password!");
                    }

                    return checkUser;
                }
            }
            catch (ModelException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                LogError(user, ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
                throw ex;
            }
        }
Exemplo n.º 2
0
        public User CreateUser(User user)
        {
            try
            {
                using (CapitalContext context = new CapitalContext())
                {
                    if (context.Users.Where(x => x.Email.ToLower() == user.Email.ToLower()).FirstOrDefault() == null)
                    {
                        user.CreationDate = DateTime.Now;
                        user.LastAccessDate = DateTime.Now;

                        ValidationContext valContext = new ValidationContext(this, null, null);
                        var errors = user.Validate(valContext);

                        if (errors.Count() == 0)
                        {
                            context.Users.Add(user);
                            context.SaveChanges();
                            return context.Users.FirstOrDefault(x => x.Email == user.Email);
                        }
                        else
                            throw new ModelException(errors);
                    }
                    else
                    {
                        throw new ModelException("Email Address Already Exists!");
                    }
                }
            }
            catch (DbEntityValidationException ex)
            {
                throw new ModelException(ex);
            }
            catch (DbUnexpectedValidationException ex)
            {
                throw new ModelException(ex);
            }
            catch (ModelException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                LogError(user, ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
                throw ex;
            }
        }
Exemplo n.º 3
0
 public IEnumerable<Account> GetAccounts(User source)
 {
     try
     {
         AccountManagement accountManagement = new AccountManagement();
         return accountManagement.GetAccounts(source);
     }
     catch (ModelException ex)
     {
         CapitalError error = new CapitalError(ex);
         throw new FaultException<CapitalError>(error, error.Message);
     }
     catch (Exception)
     {
         return null;
     }
 }
Exemplo n.º 4
0
 public User Login(User user)
 {
     try
     {
         UserManagement userManagement = new UserManagement();
         return userManagement.Login(user);
     }
     catch (ModelException ex)
     {
         CapitalError error = new CapitalError(ex);
         throw new FaultException<CapitalError>(error, error.Message);
     }
     catch (Exception)
     {
         return null;
     }
 }
Exemplo n.º 5
0
        public IEnumerable<Account> GetAccounts(User source)
        {
            try
            {
                using (CapitalContext context = new CapitalContext())
                {
                    // Compare Accounts for that UserID
                    List<Account> accounts = context.Accounts.Where(x => x.UserId == source.UserId).OrderBy(x => x.AccountName).ToList();

                    foreach (Account acc in accounts)
                    {
                        //acc.Balance = acc.Balance - (context.Statements.Where(x => x.AccountId == acc.AccountId && x.IsPaid == true).AsEnumerable().Sum(x => x.PaidAmount));

                        acc.IsShare = false;
                        acc.PermissionLevel = 0;
                    }

                    // LINK SHARED ACCOUNTS
                    var shares = context.Share.Where(x => x.UserId == source.UserId);
                    foreach(Share share in shares)
                    {
                        Account account = context.Accounts.FirstOrDefault(x => x.AccountId == share.AccountId);

                        if (account != null)
                        {
                            account.IsShare = true;
                            account.PermissionLevel = share.PermissionLevelId;

                            accounts.Add(account);
                        }
                    }

                    return accounts;
                }
            }
            catch (Exception ex)
            {
                LogError(source, ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
                return null;
            }
        }
Exemplo n.º 6
0
        private void AgeAccounts(User user, CapitalContext context)
        {
            try
            {
                IEnumerable<Account> accounts = context.Accounts.Where(x => x.UserId == user.UserId).Include(x => x.Frequency).AsEnumerable();

                foreach (Account acc in accounts)
                {
                    int? count = context.Statements.Where(x => x.Account.AccountId == acc.AccountId).Count();

                    if (count == 0)
                    {
                        Statement statement = new Statement();
                        statement.AccountId = acc.AccountId;
                        statement.Balance = acc.DefaultPayment;
                        statement.IsPaid = false;
                        statement.CreationDate = DateTime.Now;
                        statement.PaidAmount = 0;
                        statement.PaidDate = null;

                        // int freqDays = context.Frequency.Where(x => x.FrequencyId == context.Accounts.Where(y => y.AccountId == acc.AccountId).FirstOrDefault().FrequencyId).FirstOrDefault().Days;
                        statement.DueDate = acc.StartDate;
                        context.Statements.Add(statement);
                    }
                    else
                    {
                        int id = context.Statements.Where(x => x.Account.UserId == user.UserId).Max(x => x.StatementId);

                        Statement latestStatement = context.Statements.Where(x => x.StatementId == id).FirstOrDefault();

                        TimeSpan difference = DateTime.Now - (DateTime)latestStatement.DueDate;

                        // Make sure the existing unPaid statement doesn't fall within the 7 day period

                        //if (difference.Days >= (acc.Frequency.Days - 7) && difference.Days > 7)
                        if (latestStatement.IsPaid)
                        {
                            // Get Average of previous payments
                            decimal sumPayments = (decimal)context.Statements.Where(x => x.AccountId == acc.AccountId && x.IsPaid == true).AsEnumerable().Sum(x => x.PaidAmount);
                            int totalPayments = (int)context.Statements.Where(x => x.AccountId == acc.AccountId && x.IsPaid == true).Count();


                            Statement statement = new Statement();
                            statement.AccountId = acc.AccountId;
                            //statement.Balance = acc.Payment;
                            if (totalPayments != 0)
                                statement.Balance = (double)Math.Round(sumPayments / totalPayments, 2);
                            else
                                statement.Balance = latestStatement.Balance;
                            statement.IsPaid = false;
                            statement.CreationDate = DateTime.Now;
                            statement.PaidAmount = 0;
                            statement.PaidDate = null;

                            Frequency freq = context.Accounts.Where(x => x.AccountId == acc.AccountId).FirstOrDefault().Frequency;

                            int freqDays = context.Accounts.Where(x => x.AccountId == acc.AccountId).FirstOrDefault().Frequency.Days;
                            statement.DueDate = DateTime.Now.AddDays(freqDays);
                            context.Statements.Add(statement);

                            MessengerUtil messenger = new MessengerUtil();
                            messenger.SendToast(user, string.Format("New {0} Statement!", statement.Account.AccountName), "");
                        }
                    }
                    context.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                LogError(user, ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
                throw new Exception("Error Aging Account", ex);
            }
        }
Exemplo n.º 7
0
        public Statement GetStatementById(User user, int statementId)
        {
            try
            {
                using (CapitalContext context = new CapitalContext())
                {
                    Statement statement = context.Statements.Include(x => x.Account).Where(x => x.Account.UserId == user.UserId && x.StatementId == statementId).FirstOrDefault();

                    Statement result = statement;
                    result.AccountName = statement.Account.AccountName;
                    statement.Account = null;
                    return result;
                }
            }
            catch(Exception ex)
            {
                LogError(new object[] { user, statementId }, ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
                return null;
            }
        }
Exemplo n.º 8
0
        public IEnumerable<Statement> GetStatements(User user)
        {
            try
            {
                using (var transaction = TransactionUtils.CreateTransactionScope())
                {
                    using (CapitalContext context = new CapitalContext())
                    {
                        // Age Accounts
                        AgeAccounts(user, context);

                        // Get Statements
                        List<Statement> statementCollection = new List<Statement>();
                        var statements = context.Statements.Where(x => x.IsPaid == false && x.Account.UserId == user.UserId).AsEnumerable().OrderBy(x => x.DueDate);

                        foreach (Statement statement in statements)
                        {
                            statement.AccountName = statement.Account.AccountName;
                            statement.Account = null;
                            statementCollection.Add(statement);
                        }

                        var recentStatements = context.Statements.Where(x => x.IsPaid == true && x.Account.UserId == user.UserId && SqlFunctions.DateDiff("DAY", x.PaidDate, DateTime.Now).Value <= 30).Include(x => x.Account).AsEnumerable();
                        foreach (Statement statement in recentStatements)
                        {
                            statement.AccountName = statement.Account.AccountName;
                            statement.Account = null;
                            statementCollection.Add(statement);
                        }

                        transaction.Complete();
                        return statementCollection;
                    }
                }
            }
            catch (Exception ex)
            {
                LogError(user, ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
                return null;
            }
        }
Exemplo n.º 9
0
        public void SendToast(User user, string title, string subTitle)
        {
            try
            {
                using (CapitalContext context = new CapitalContext())
                {
                    Registration registration = context.Registration.FirstOrDefault(x => x.UserId == user.UserId);

                    if (registration != null)
                    {
                        //toastPushNotificationMessage.Title = title;
                        //toastPushNotificationMessage.SubTitle = subTitle;
                        //toastPushNotificationMessage.SendAsync(new Uri(registration.URI, UriKind.Absolute), (result) => { }, (result) => { });
                    }
                }
            }
            catch(Exception ex)
            {
                LogError(new object[] { user, title, subTitle }, ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
            }
        } 
Exemplo n.º 10
0
 public void SendToast(User user, string title, string subTitle)
 {
     try
     {
         MessengerUtil messenger = new MessengerUtil();
         messenger.SendToast(user, title, subTitle);
     }
     catch (ModelException ex)
     {
         CapitalError error = new CapitalError(ex);
         throw new FaultException<CapitalError>(error, error.Message);
     }
     catch (Exception)
     {
         return;
     }
 }
Exemplo n.º 11
0
 public Statement GetStatementById(User user, int id)
 {
     try
     {
         AccountManagement accountManagement = new AccountManagement();
         return accountManagement.GetStatementById(user, id);
     }
     catch (ModelException ex)
     {
         CapitalError error = new CapitalError(ex);
         throw new FaultException<CapitalError>(error, error.Message);
     }
     catch (Exception)
     {
         return null;
     }
 }