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 int AddnewUser(UserDTO u) { // User user = Userconvert.DTOtoDAL(u); using (SuperGmachEntities db = new SuperGmachEntities()) { try { User userDAL = Userconvert.DTOtoDAL(u); userDAL = db.Users.Add(userDAL).Entity; db.SaveChanges(); return(userDAL.UserId); } catch (Exception e) { throw new Exception(e.ToString()); } } }
public static UserDTO GetUserById(int id) { User userDal = new User(); try { using (SuperGmachEntities db = new SuperGmachEntities()) { userDal = db.Users.FirstOrDefault(u => u.UserId == id); UserDTO user = Userconvert.DALtoDTO(userDal); ///cheack pay thisMonth var sumPayThisMonth = 0; Loan loan = db.Loans.FirstOrDefault(l => l.UserId == id && 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; } user.payThisMonth.Add(" תשלום פרעות מחודשים קודמים שטרם שלמו :" + sumPayThisMonth.ToString()); ; Repayments repaymentThisMonth = repayments.FirstOrDefault(r => r.Date.Month == thisMonth); if (repaymentThisMonth != null) { user.payThisMonth.Add("תשלום פררעון לחודש זה :" + repaymentThisMonth.Amount.ToString()); sumPayThisMonth += repaymentThisMonth.Amount; } } if (user.Friend == true) { sumPayThisMonth += 50; user.payThisMonth.Add(" הוראת קבע: 50 "); } user.payThisMonth.Add("סהכ :" + sumPayThisMonth.ToString()); return(user); } } catch (Exception e) { throw e; } }
public static List <UserDTO> GetUsersToAdd(string fundId) { List <UserDTO> users = new List <UserDTO>(); //List<User> usersDAL = new List<User>(); DB Sgmach = new DB(); Fund fund = Sgmach.Funds.FirstOrDefault(f => f.FundId == fundId); DateTime Today = DateTime.Today; //usersDAL = Sgmach.Users.Where(u =>u.joining_date.GetValueOrDefault().AddMonths((int)fund.required_months) <= Today //&&(fund.required_vip==true&&u.VIP==true||fund.required_vip==false)).ToList(); var query = from u in Sgmach.Users where (u.joining_date.AddMonths((int)fund.required_months)) <= Today where !(from uf in Sgmach.UserInFunds where uf.FundId == fund.FundId select uf.UserId).Contains(u.UserId) select u; foreach (User user in query) { users.Add(Userconvert.DALtoDTO(user)); } return(users); }
public static UserDTO GetUserById(int id) { User userDal = new User(); try { using (SuperGmachEntities db = new SuperGmachEntities()) { userDal = db.Users.FirstOrDefault(u => u.UserId == id); UserDTO user = Userconvert.DALtoDTO(userDal); ///cheack pay thisMonth var sumPayThisMonth = 0; var paid = 0; Loan loan = db.Loans.FirstOrDefault(l => l.UserId == id && 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(); if (pastRepayments.ToArray().Length > 0) { foreach (var repayment in pastRepayments) { sumPayThisMonth += repayment.Amount; } user.payThisMonth.Add(" תשלום פרעות מחודשים קודמים שטרם שלמו :" + sumPayThisMonth.ToString());; } Repayments repaymentThisMonth = repayments.FirstOrDefault(r => r.Date.Month == thisMonth); if (repaymentThisMonth != null) { sumPayThisMonth += repaymentThisMonth.Amount; if (repaymentThisMonth.NameStatus != "performed") { user.payThisMonth.Add("תשלום פררעון לחודש זה :" + repaymentThisMonth.Amount.ToString()); } else { user.payThisMonth.Add("תשלום פררעון לחודש זה :" + repaymentThisMonth.Amount.ToString() + " -שולם "); paid += repaymentThisMonth.Amount; } } } if (user.Friend == true) { var last_Debit_order = user.last_Debit_order; var today = DateTime.Now; var month = ((today.Year - last_Debit_order.Year) * 12) + today.Month - last_Debit_order.Month; if (month == 0) { sumPayThisMonth += 50; paid += 50; user.payThisMonth.Add(" שולם:הוראת קבע: 50 "); } else { var amount = 50 * month; sumPayThisMonth += amount; user.payThisMonth.Add("הוראת קבע: " + amount.ToString()); } } user.payThisMonth.Add("סהכ :" + sumPayThisMonth.ToString()); user.payThisMonth.Add("שולם :" + paid.ToString()); var toPay = sumPayThisMonth - paid; user.payThisMonth.Add("סהכ לתשלום :" + toPay.ToString()); return(user); } } 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); }