public static int AddnewUser(UserDTO u) { // User user = Userconvert.DTOtoDAL(u); using (SuperGmachEntities db = new SuperGmachEntities()) { try { User userDAL = Userconvert.DTOtoDAL(u); var date = DateTime.Now; userDAL.joining_date = DateTime.Now; userDAL.last_Debit_order = date.AddMonths(-1); userDAL = db.Users.Add(userDAL).Entity; User_in_fund user_In_Fund = new User_in_fund() { balance = 0, UserId = userDAL.UserId, FundId = "1", date_join = DateTime.Now }; db.UserInFunds.Add(user_In_Fund); db.SaveChanges(); return(userDAL.UserId); } catch (Exception e) { throw new Exception(e.ToString()); } } }
public static List <UserDTO> GetUsersList() { var sumPayThisMonth = 0; List <UserDTO> userList = new List <UserDTO> (); List <AlertsUsers> alertsUsers = new List <AlertsUsers> (); using (SuperGmachEntities db = new SuperGmachEntities()) { foreach (User u in db.Users) { UserDTO user = Userconvert.DALtoDTO(u); //cheac if the user Proper else add alret if (user.Management_status.Id != "Proper") { AlertsUsers alert = new AlertsUsers() { UserId = user.Id_user, Alret = " סטטוס ניהול לחבר " + user.Last_name + " " + user.First_name + " " + user.Management_status.Name + " סיבת הסטטוס " + user.Status_reason }; alertsUsers.Add(alert); } /// cheack if the user have active loan Loan loan = db.Loans.FirstOrDefault(l => l.UserId == u.UserId && l.NameManagement_status != "performed"); if (loan != null) { var thisMonth = DateTime.Now.Month; List <Repayments> repayments = db.Repayments.Where(r => r.LoanId == loan.LoanId && r.NameStatus != "performed").ToList(); List <Repayments> pastRepayments = repayments.Where(r => r.Date.Month < thisMonth && r.Date.Month != thisMonth).ToList(); foreach (var repayment in pastRepayments) { sumPayThisMonth += repayment.Amount; } if (pastRepayments.ToArray().Length > 0) { // user.payThisMonth = ":החזר הלוואה מחודשים קודמים שטרם החזרו" + sumPayThisMonth.ToString (); AlertsUsers alert = new AlertsUsers() { UserId = user.Id_user, Alret = " יש החזרים מחודשים קודמים שלא שולמו לחבר " + user.Last_name + " " + user.First_name }; alertsUsers.Add(alert); } Repayments repaymentThisMonth = repayments.FirstOrDefault(r => r.Date.Month == thisMonth); if (repaymentThisMonth != null) { // user.payThisMonth += " :תשלום פררעון לחודש זה" + repaymentThisMonth.Amount.ToString (); sumPayThisMonth += repaymentThisMonth.Amount; } } user.Loans = loan != null?LoanBL.Balance(loan.LoanId) : 0; User_in_fund rachelLea = db.UserInFunds.FirstOrDefault(uf => u.UserId == uf.UserId && uf.FundId == "rachelLea"); user.RachelLea = rachelLea != null ? (int)rachelLea.balance : 0; // Repayment repayment=db.Repayments.Where(r=>r. userList.Add(user); } } return(userList); }
public static void Add(WithdrawalsDTO withdrawalDTO) { withdrawing withdrawal = WithdrawalsConvert.DTOtoDAL(withdrawalDTO); db DB = new db(); DB.Withdrawing.Add(withdrawal); DB.SaveChanges(); if (withdrawalDTO.Status == "performed") { FundBL.Subtract_Balance(withdrawalDTO.Amount, withdrawalDTO.FundId); User_in_fund user = DB.UserInFunds.FirstOrDefault(u => u.UserId == withdrawal.UserId && u.FundId == withdrawal.FundId); user.balance -= withdrawal.Amount; } DB.SaveChanges(); }
public static void AddFriends(int[] frinds, string fundID) { DateTime Today = DateTime.Now; DB Sgmach = new DB(); int Length = frinds.Length; for (var i = 0; i < Length; i++) { User_in_fund user_In_Fund = new User_in_fund(); user_In_Fund.balance = 0; user_In_Fund.date_join = Today; user_In_Fund.FundId = fundID; user_In_Fund.UserId = frinds[i]; Sgmach.UserInFunds.Add(user_In_Fund); Sgmach.SaveChanges(); } }
public static void AddDeposit(DepositDTO deposit) { DB db = new SuperGmachEntities(); try { Deposit deposit_DAL = new Deposit(); deposit_DAL = DepositConvert.DTOtoDAL(deposit); // System.Console.WriteLine(deposit+" DAL/n "+deposit_DAL); db.Deposits.Add(deposit_DAL); User user = db.Users.FirstOrDefault(); db.SaveChanges(); user.Scoring = (int)((int)user.Scoring + deposit.Amount * 0.5); User_in_fund user_In_Fund = db.UserInFunds.FirstOrDefault(u => u.UserId == deposit.UserId && u.FundId == deposit.FundId); user_In_Fund.balance += deposit.Amount; FundBL.AddBalance((int)deposit.Amount, deposit.FundId); db.SaveChanges(); } catch (Exception e) { throw e; } }
public static ListUsers GetUsersList() { var sumPayThisMonth = 0; // List<UserDTO> userList = new List<UserDTO> (); ListUsers userList = new ListUsers(); using (SuperGmachEntities db = new SuperGmachEntities()) { foreach (User u in db.Users) { UserDTO user = Userconvert.DALtoDTO(u); //cheac if the user Proper else add alret if (user.Management_status.Id != "Proper") { AlertsUsers alert = new AlertsUsers() { UserId = user.Id_user, Alret = " סטטוס ניהול לחבר " + user.Last_name + " " + user.First_name + " " + user.Management_status.Name + " סיבת הסטטוס " + user.Status_reason }; userList.alertsUsers.Add(alert); } /// cheack if the user have active loan Loan loan = db.Loans.FirstOrDefault(l => l.UserId == u.UserId && l.NameStatus != "performed"); if (loan != null) { var today = DateTime.Now; var thisMonth = DateTime.Now.Month; List <Repayments> repayments = db.Repayments.Where(r => r.LoanId == loan.LoanId && r.NameStatus != "performed").ToList(); List <Repayments> pastRepayments = repayments.Where(r => r.Date < today && r.Date != today).ToList(); foreach (var repayment in pastRepayments) { sumPayThisMonth += repayment.Amount; } if (pastRepayments.ToArray().Length > 0) { // user.payThisMonth = ":החזר הלוואה מחודשים קודמים שטרם החזרו" + sumPayThisMonth.ToString (); AlertsUsers alert = new AlertsUsers() { UserId = user.Id_user, Alret = " יש החזרים מחודשים קודמים שלא שולמו לחבר " + user.Last_name + " " + user.First_name }; userList.alertsUsers.Add(alert); } Repayments repaymentThisMonth = repayments.FirstOrDefault(r => r.Date.Month == thisMonth); if (repaymentThisMonth != null) { // user.payThisMonth += " :תשלום פררעון לחודש זה" + repaymentThisMonth.Amount.ToString (); sumPayThisMonth += repaymentThisMonth.Amount; } } if (loan != null) { switch (loan.NameManagement_status) { case "Invalid": user.Loans = " לא תקין " + LoanBL.Balance(loan.LoanId).ToString(); break; case "Unauthorized": user.Loans = "לא מאושר"; break; case "Proper": user.Loans = loan.NameStatus == "active" ? ("-" + LoanBL.Balance(loan.LoanId).ToString()) : "ממתין לאישור"; break; case "Approved": user.Loans = loan.NameStatus == "future" ? loan.Amount.ToString() + " עתידי" : loan.Amount.ToString() + "מאושר "; break; } } // user.Loans = loan != IChangeTracking null ? LoanBL.Balance (loan.LoanId) : 0; User_in_fund rachelLea = db.UserInFunds.FirstOrDefault(uf => u.UserId == uf.UserId && uf.FundId == "2"); user.RachelLea = rachelLea != null ? (int)rachelLea.balance : 0; // Repayment repayment=db.Repayments.Where(r=>r. userList.Users.Add(user); } } return(userList); }