public static void AddCredit(Crdit credit, int UserID)
{
SuperGmachEntities db = new SuperGmachEntities();
User user = db.Users.FirstOrDefault(u => u.UserId == UserID);
Credit credit1 = db.Credits.FirstOrDefault(c => c.UserId == UserID);
credit1.CVV = credit.CVV.ToString();
credit1.Number = credit.Number.Substring(credit.Number.Length - 4);
credit1.Owner = credit.idOwners;
credit1.UserId = UserID;
db.SaveChanges();
}
public static List <StatusDTO> GetList()
{
List <StatusDTO> list = new List <StatusDTO>();
using (SuperGmachEntities db = new SuperGmachEntities())
{
foreach (Status s in db.Statuses)
{
list.Add(StatusConvert.DALtoDTO(s));
}
}
return(list);
}
public static List <Management_statusDTO> GetManagement_statusList()
{
List <Management_statusDTO> userList = new List <Management_statusDTO>();
using (SuperGmachEntities db = new SuperGmachEntities())
{
foreach (Management_status status in db.ManagementStatuses)
{
userList.Add(Mangagment_status_convert.DALtoDTO(status));
}
}
return(userList);
}
public static List <IncomeDTO> GetList()
{
List <IncomeDTO> list = new List <IncomeDTO>();
using (SuperGmachEntities db = new SuperGmachEntities())
{
foreach (Income i in db.Incoms)
{
list.Add(IncomeConvert.DALtoDTO(i));
}
}
return(list);
}
static public List <ExpenditureDTO> GetExpendituresList()
{
List <ExpenditureDTO> list = new List <ExpenditureDTO>();
using (SuperGmachEntities db = new SuperGmachEntities())
{
foreach (Expenditure ex in db.Expenditure)
{
list.Add(ExpenditureConvert.DALtoDTO(ex));
}
}
return(list);
}
public static Management_statusDTO GetByName(string nameStatuse)
{
SuperGmachEntities db = new SuperGmachEntities();
{
foreach (Management_status status in db.ManagementStatuses)
{
if (status.NameManagement_status == nameStatuse)
{
return(Mangagment_status_convert.DALtoDTO(status));
}
}
return(null);
}
}
public static IncomeDTO GetById(int id)
{
SuperGmachEntities db = new SuperGmachEntities();
{
foreach (Income income in db.Incoms)
{
if ((int)income.Id == id)
{
return(IncomeConvert.DALtoDTO(income));
}
}
return(null);
}
}
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 StatusDTO GetByName(string name)
{
SuperGmachEntities db = new SuperGmachEntities();
{
var status = db.Statuses.FirstOrDefault(s => s.NameStatus == name);
{
if (status != null)
{
return(StatusConvert.DALtoDTO(status));
}
}
return(null);
}
}
public static UserDTO DALtoDTO(User user)
{
UserDTO newUser = new UserDTO()
{
Id_user = user.UserId,
last_Debit_order = user.last_Debit_order,
Id = user.UserId,
First_name = user.firstName,
Last_name = user.lastname,
Vip = user.VIP,
Friend = user.frirnd,
//Status_user = (Status_userE)user.status_User.GetValueOrDefault(),
Father_name = user.father_name,
Status_reason = user.Status_reason,
Scoring = user.Scoring,
Remarks = user.remarks,
MaritalStatus = user.MaritalStatus,
Communication_ways = new Communication(user.phon1, user.phon2, user.email_addres, user.city, user.street, user.num_street),
// Bank_Details = new Bank_details(user.bankName, user.brunchName, user.account_number.GetValueOrDefault(), user.Bank_account_owner),
Joining_date = (DateTime)user.joining_date,
Management_status = Management_statusBL.GetByName(user.NameManagement_status),
_Manager = (int)user.Manager_permissions.GetValueOrDefault()
};
SuperGmachEntities db = new SuperGmachEntities();
Credit credit = db.Credits.FirstOrDefault(c => c.UserId == user.UserId);
if (credit != null)
{
newUser.Crdit = new Crdit()
{
CVV = credit.CVV,
Number = credit.Number,
Token = credit.Token,
};
}
BankDetails bankDetails = db.BankDetails.FirstOrDefault(b => b.UserId == user.UserId);
newUser.Bank_Details = new Bank_details()
{
Account = bankDetails.Account,
Bank = bankDetails.Bank,
Brunch = bankDetails.Branch,
Owner = bankDetails.owner,
UserId = bankDetails.UserId.ToString()
};
return(newUser);
}
public static DepositDetails GetById(int id)
{
DepositDetails depositDetails = new DepositDetails();
try
{
DB db = new SuperGmachEntities();
Deposit deposit = db.Deposits.FirstOrDefault(d => d.DepositId == id);
depositDetails = DepositConvert.DALtoDepositDetails(deposit);
}
catch (Exception e)
{
throw e;
}
return(depositDetails);
}
public static void collectDebit_order(Debit_order debit_Order)
{
SuperGmachEntities db = new SuperGmachEntities();
User user = db.Users.FirstOrDefault(u => u.UserId == debit_Order.UserID);
user.last_Debit_order = DateTime.Now;
Income Debit_order = new Income()
{
Amount = debit_Order.amount,
Date = DateTime.Now,
From = " מנוי " + debit_Order.UserID,
Remarks = "הוראת קבע"
};
db.Incoms.Add(Debit_order);
db.SaveChanges();
}
public static List <AlertsUsers> GetAlerts()
{
List <AlertsUsers> alertsUsers = new List <AlertsUsers> ();
using (SuperGmachEntities db = new SuperGmachEntities()) {
// var today = DateTime.Today;
// AlertsUsers alert = new AlertsUsers()
// {
// UserId = user.UserId,
// Alret = " פג תוקף האשראי לחבר " + user.lastname + " "+user.firstName
// };
// alertsUsers.Add(alert);
// }
}
return(alertsUsers);
}
static public ExpenditureDTO GetByID(int id)
{
ExpenditureDTO exDTO = new ExpenditureDTO();
using (SuperGmachEntities db = new SuperGmachEntities())
{
try
{
var e = db.Expenditure.FirstOrDefault(exp => exp.Id == id);
exDTO = ExpenditureConvert.DALtoDTO(e);
}
catch (Exception ex)
{
throw ex;
}
}
return(exDTO);
}
public static List <DepositDetails> GetList()
{
List <DepositDetails> deposits = new List <DepositDetails>();
try
{
DB db = new SuperGmachEntities();
foreach (var deposit in db.Deposits)
{
deposits.Add(DepositConvert.DALtoDepositDetails(deposit));
}
}
catch (Exception e)
{
throw e;
}
return(deposits);
}
public static UserDetalis UserDetalis(int id)
{
List <User_in_fund> fundList;
UserDetalis detalis = new UserDetalis();
using (SuperGmachEntities db = new SuperGmachEntities()) {
fundList = db.UserInFunds.Where(uif => uif.UserId == id).ToList();
foreach (var User_in_fund in fundList)
{
UserFund userFund = new UserFund();
userFund.Balance = (int)User_in_fund.balance;
userFund.DateJoin = (DateTime)User_in_fund.date_join;
userFund.FundName = (db.Funds.FirstOrDefault(fund => fund.FundId == User_in_fund.FundId)).fund_name;
}
}
//detalis.User = GetUserById(id);
return(detalis);
}
public static void Update(DepositDetails deposit)
{
DB db = new SuperGmachEntities();
Deposit _deposit = db.Deposits.FirstOrDefault(dep => dep.DepositId == deposit.Id);
if (deposit == null)
{
throw new Exception("deposits not found");
}
else
{
_deposit.Amount = deposit.amount;
_deposit.Date = deposit.date;
_deposit.FundId = deposit.fund_id.ToString();
// _deposit. = deposit.status;
_deposit.Type = deposit.type;
db.SaveChanges();
}
}
public static List <DepositDetails> GetByFundId(string FundId)
{
List <DepositDetails> deposits = new List <DepositDetails>();
try
{
DB db = new SuperGmachEntities();
List <Deposit> deposits_DAL = db.Deposits.Where(d => d.FundId == FundId).ToList();
foreach (var deposit in deposits_DAL)
{
deposits.Add(DepositConvert.DALtoDepositDetails(deposit));
}
}
catch (Exception e)
{
throw e;
}
return(deposits);
}
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 void cancelExpenditure(int ExpenditureId)
{
try
{
using (SuperGmachEntities db = new SuperGmachEntities())
{
Expenditure expenditure = db.Expenditure.FirstOrDefault(ex => ex.Id == ExpenditureId);
if (expenditure == null)
{
throw new Exception("expenditure not found");
}
expenditure.NameStatus = "canceled";
FundBL.AddBalance(expenditure.Amount);
}
}
catch (Exception e)
{
throw e;
}
}
public static string AddStatus(Management_statusDTO status)
{
using (SuperGmachEntities db = new SuperGmachEntities())
{
try
{
Management_status s = Mangagment_status_convert.DTOtoDAL(status);
Console.WriteLine(s.NameManagement_status + " " + s.Color);
db.ManagementStatuses.Add(s);
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("err on add status: " + e.ToString());
return("err on add status: " + e.ToString());
}
return("status add Successfully");
}
}
static public void AddExpenditure(ExpenditureDTO Expenditure)
{
using (SuperGmachEntities db = new SuperGmachEntities())
{
try
{
Expenditure e = ExpenditureConvert.TDOtoDAL(Expenditure);
db.Expenditure.Add(e);
//fundId 1 is for the main fund
if (Expenditure.NameStatus == "performed")
{
FundBL.Subtract_Balance(Expenditure.Amount, "1");
}
db.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
}
public static void updateExpenditure(ExpenditureDTO expenditure)
{
using (SuperGmachEntities db = new SuperGmachEntities())
{
try
{
Expenditure update_expenditure = db.Expenditure.FirstOrDefault(e => e.Id == expenditure.Id);
if (update_expenditure != null)
{
update_expenditure.Amount = expenditure.Amount;
update_expenditure.Date = expenditure.Date;
//update_expenditure.future_date = expenditure.future_date;
update_expenditure.Purpose = expenditure.Purpose;
update_expenditure.Receives = expenditure.Receives;
///chack if its became performed
if (expenditure.NameStatus != update_expenditure.NameStatus)
{
if (expenditure.NameStatus == "performed")
{
FundBL.Subtract_Balance(expenditure.Amount);
}
else
{
///check if it was performed and change to canceled
if (expenditure.NameStatus == "canceled" && update_expenditure.NameStatus == "performed")
{
FundBL.AddBalance(expenditure.Amount);
}
}
update_expenditure.NameStatus = expenditure.NameStatus;
}
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
}
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 int Edite(UserDTO user)
{
SuperGmachEntities db = new SuperGmachEntities();
User userDal = db.Users.FirstOrDefault(u => u.UserId == user.Id_user);
userDal.father_name = user.Father_name;
userDal.lastname = user.Last_name;
userDal.VIP = user.Vip;
userDal.Status_reason = user.Status_reason;
userDal.frirnd = user.Friend;
userDal.email_addres = user.Communication_ways.Email_addres;
userDal.phon1 = user.Communication_ways.Phon1;
userDal.phon2 = user.Communication_ways.Phon2;
userDal.city = user.Communication_ways.City;
userDal.num_street = user.Communication_ways.Num_street;
userDal.street = user.Communication_ways.Street;
userDal.remarks = user.Remarks;
userDal.MaritalStatus = user.MaritalStatus;
userDal.NameManagement_status = user.NameManagement_status;
db.SaveChanges();
return(userDal.UserId);
}
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);
}
