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