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);
}
