public static User Authenticate(string username, string password, int deptId, out bool authenticated, out string message) { using (var db = new AltasoftDailyContext()) { var userByName = db.Users.FirstOrDefault(x => x.Username == username); // //if (userByName == null) //{ // authenticated = false; // message = "მომხმარებლის სახელი არასწორია!"; // return null; //} //else if (!EncryptionManagement.Validate(userByName.Password, password, userByName.Salt)) //{ // authenticated = false; // message = "მომხმარებლის პაროლი არასწორია!"; // return null; //} //else if (userByName.DeptID != deptId) //{ // authenticated = false; // message = "მომხმარებელი ფილიალში არ მოიძებნა!"; // return null; //} authenticated = true; message = "მომხმარებელი იდენტიფიცირებულია!"; return userByName; } }
private void btnOk_Click(object sender, EventArgs e) { if (EncryptionManagement.Validate(User.Password, ctrlChangePassword.PasswordOld, User.Salt)) { if (ctrlChangePassword.PasswordNew != ctrlChangePassword.PasswordOld) { if (ctrlChangePassword.PasswordNew == ctrlChangePassword.PasswordNewRe) { using (var db = new AltasoftDailyContext()) { var dbUser = db.Users.FirstOrDefault(x => x.UserID == User.UserID); var salt = EncryptionManagement.CreateSalt(); dbUser.Salt = salt; dbUser.Password = EncryptionManagement.Encrypt(ctrlChangePassword.PasswordNewRe, salt); dbUser.LastPasswordChange = DateTime.Now; dbUser.ForceUserToChangePassword = false; db.SaveChanges(); } MessageBox.Show("პაროლი წარმატებით შეიცვალა!"); DialogResult = System.Windows.Forms.DialogResult.OK; } else { MessageBox.Show("გთხოვთ სწორად გაიმეოროთ პაროლი!"); } } else { MessageBox.Show("იგივე პაროლის გამოყენება აკრძალულია!"); } } else { MessageBox.Show("ძველი პაროლი არასწორია!"); } }
private void btnAdd_Click(object sender, EventArgs e) { using (var db = new AltasoftDailyContext()) { db.DailyPayments.FirstOrDefault(x => x.DailyPaymentID == Payment.DailyPaymentID).Payment = Payment.Payment; db.SaveChanges(); } DailyManagement.SubmitOrder(Payment.TaxOrderNumber, Payment.LoanCCY, Payment.CalculationDate, Payment.ClientAccountIban, decimal.Parse(tbxAmount.Text), Payment.AgreementNumber, "120", User.AltasoftUserID, User.DeptID); }
private void SyncUsers() { #region Initialize Services #region OrdersService AltasoftAPI.OrdersAPI.OrdersService o = new AltasoftAPI.OrdersAPI.OrdersService(); o.RequestHeadersValue = new AltasoftAPI.OrdersAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #region CustomersService AltasoftAPI.CustomersAPI.CustomersService c = new AltasoftAPI.CustomersAPI.CustomersService(); c.RequestHeadersValue = new AltasoftAPI.CustomersAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #region AccountsService AltasoftAPI.AccountsAPI.AccountsService a = new AltasoftAPI.AccountsAPI.AccountsService(); a.RequestHeadersValue = new AltasoftAPI.AccountsAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #region LoansService AltasoftAPI.LoansAPI.LoansService l = new AltasoftAPI.LoansAPI.LoansService(); l.RequestHeadersValue = new AltasoftAPI.LoansAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #endregion var apiUsers = l.ListUsers(new AltasoftAPI.LoansAPI.ListUsersQuery()); using (var db = new AltasoftDailyContext()) { var dbUsers = db.Users.ToList(); foreach (var user in apiUsers) { var dbUser = dbUsers.FirstOrDefault(x => x.AltasoftUserID == user.Id); if (dbUser == null) { var newUser = new User(); newUser.Username = user.LoginName.Replace("@businesscredit.ge", ""); newUser.AltasoftUserID = user.Id; newUser.DeptID = user.DeptId; newUser.Name = user.DisplayName.Split(' ').FirstOrDefault(); newUser.Password = "******"; newUser.LastName = user.DisplayName.Split(' ').LastOrDefault(); newUser.LastPasswordChange = DateTime.Now; db.Users.Add(newUser); } } var saved = db.SaveChanges(); } }
public OrderLogsFilterForm() { using (var db = new AltasoftDailyContext()) { comboBox1.Items.AddRange((from u in db.Users.ToArray() select new { FullName = u.Name + " " + u.LastName, ID = u.UserID }).ToArray()); } InitializeComponent(); comboBox1.DisplayMember = "FullName"; comboBox1.ValueMember = "ID"; }
public static bool LogException(Exception ex, User user) { if (ex == null) return false; using (var db = new AltasoftDailyContext()) { db.ExceptionLogs.Add(CreateExceptionLog(ex, user != null ? db.Users.FirstOrDefault(x => x.UserID == user.UserID) : null)); db.SaveChanges(); } return true; }
public EditAgreementTermsForm(int AgreementAndSummaryJudgementTermsID, AltasoftDailyContext db) { ID = AgreementAndSummaryJudgementTermsID; Terms = db.AgreementAndSummaryJudgementTerms.FirstOrDefault(x => x.ID == AgreementAndSummaryJudgementTermsID); this.Text = db.EnforcementLoans.FirstOrDefault(x => x.AgreementAndSummaryJudgementTerms.ID == AgreementAndSummaryJudgementTermsID).BorrowerName; _db = db; InitializeComponent(); tbxAdmittedAmount.Text = Terms.AdmittedAmount.ToString(); tbxPayment.Text = Terms.Payment.ToString(); tbxPaymentDay.Text = Terms.PaymentDay.ToString(); dtpStartDate.Value = Terms.Start; dtpEndDate.Value = Terms.End; }
public static bool ChangePassword(User user, string oldPassword, string newPassword) { using (var db = new AltasoftDailyContext()) { var dbUser = db.Users.FirstOrDefault(x => x.UserID == user.UserID); if (dbUser.Password == oldPassword) { user.Password = newPassword; db.SaveChanges(); return true; } return false; } }
public static bool LogSign(SignType signType, User user) { using (var db = new AltasoftDailyContext()) { var sign = db.SignLogs.Create(); sign.User = user != null ? db.Users.FirstOrDefault(x => x.UserID == user.UserID) : null; sign.Date = DateTime.Now; sign.InternalUsername = Environment.UserName; sign.SignType = signType; db.SignLogs.Add(sign); db.SaveChanges(); } return true; }
public static bool LogComment(DailyPayment payment, User user) { using (var db = new AltasoftDailyContext()) { var comment = db.CommentLogs.Create(); comment.User = db.Users.FirstOrDefault(x => user.UserID == x.UserID); comment.CommentValue = payment.Comment; comment.Date = DateTime.Now; comment.LocalPayment = db.DailyPayments.FirstOrDefault(x => x.DailyPaymentID == payment.DailyPaymentID); db.CommentLogs.Add(comment); db.SaveChanges(); } return true; }
public static bool DeleteOrder(DailyPayment payment) { #region OrdersService AltasoftAPI.OrdersAPI.OrdersService o = new AltasoftAPI.OrdersAPI.OrdersService(); o.RequestHeadersValue = new AltasoftAPI.OrdersAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion if (!payment.OrderID.HasValue) return false; using (var db = new AltasoftDailyContext()) { var user = db.Users.FirstOrDefault(x => x.UserID == payment.LocalUserID); o.DeleteOrder(new AltasoftAPI.OrdersAPI.UserAndDeptId() { DeptId = user.DeptID, DeptIdSpecified = true, UserIdentification = new AltasoftAPI.OrdersAPI.UserIdentification() { Id = user.AltasoftUserID, IdSpecified = true } }, payment.OrderID, payment.OrderID.HasValue, Guid.NewGuid().ToString(), true, true); db.DailyPayments.FirstOrDefault(x => x.DailyPaymentID == payment.DailyPaymentID).OrderID = null; db.SaveChanges(); } return true; }
public static bool LogOrder(DailyPayment payment, User user) { if (!payment.OrderID.HasValue) return false; using (var db = new AltasoftDailyContext()) { var order = db.OrderLogs.Create(); order.Amount = payment.Payment; order.Date = DateTime.Now; order.LocalPayment = db.DailyPayments.FirstOrDefault(x => x.DailyPaymentID == payment.DailyPaymentID); order.OrderID = payment.OrderID.Value; order.User = db.Users.FirstOrDefault(x => x.UserID == user.UserID); db.OrderLogs.Add(order); db.SaveChanges(); } return true; }
static void Main() { #region Initialize Services #region OrdersService AltasoftAPI.OrdersAPI.OrdersService o = new AltasoftAPI.OrdersAPI.OrdersService(); o.RequestHeadersValue = new AltasoftAPI.OrdersAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #region CustomersService AltasoftAPI.CustomersAPI.CustomersService c = new AltasoftAPI.CustomersAPI.CustomersService(); c.RequestHeadersValue = new AltasoftAPI.CustomersAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #region AccountsService AltasoftAPI.AccountsAPI.AccountsService a = new AltasoftAPI.AccountsAPI.AccountsService(); a.RequestHeadersValue = new AltasoftAPI.AccountsAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #region LoansService AltasoftAPI.LoansAPI.LoansService l = new AltasoftAPI.LoansAPI.LoansService(); l.RequestHeadersValue = new AltasoftAPI.LoansAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #endregion List<DailyPaymentAndLoan> data = new List<DailyPaymentAndLoan>(); var loans = new HashSet<Loan>(l.ListLoans(new ListLoansQuery() { ControlFlags = LoanControlFlags.Basic | LoanControlFlags.Authorities | LoanControlFlags.Debts, Status = new LoanStatus[] { LoanStatus.Overdue, LoanStatus.Current, LoanStatus.Late } })); foreach (var loan in loans) { var customer = c.GetCustomer( CustomerControlFlags.Basic, true, loan.BorrowerId.Value, true ); } return; (from x in l.ListLoans(new AltasoftAPI.LoansAPI.ListLoansQuery() { ControlFlags = AltasoftAPI.LoansAPI.LoanControlFlags.Basic, Status = new AltasoftAPI.LoansAPI.LoanStatus[] { AltasoftAPI.LoansAPI.LoanStatus.Overdue, AltasoftAPI.LoansAPI.LoanStatus.Current, AltasoftAPI.LoansAPI.LoanStatus.Late } }) select x.Id.Value).ToList().OrderBy(x => x).Where(x => x != 2331 /*&& x != 6*/).ToList().ForEach(x => data.Add(DailyManagement.GetLoanAndDailyModel(x))); using (var db = new AltasoftDailyContext()) { foreach (var p in data) { } } }
public static List<DailyPayment> UpdateCommentsInDaily(List<DailyPayment> list) { var result = new List<DailyPayment>(); using (var db = new AltasoftDailyContext()) { //Collection was modified; enumeration operation may not execute. foreach (var comment in list) { var payment = db.DailyPayments.FirstOrDefault(x => x.DailyPaymentID == comment.DailyPaymentID); if (payment.Comment != comment.Comment) { payment.Comment = comment.Comment; result.Add(comment); } } db.SaveChanges(); } return result; }
public static List<DailyPaymentIDOrderID> SubmitOrdersFromDatabase(User user) { List<DailyPaymentIDOrderID> result = new List<DailyPaymentIDOrderID>(); var calcDate = GetCalculationDate(); using (var db = new AltasoftDailyContext()) { var localPayments = db.DailyPayments.Where(x => x.CalculationDate == calcDate && x.LocalUserID == user.UserID && x.Payment > 0 && x.OrderID == null).ToList(); foreach (var item in localPayments) { DeleteOrder(item); result.Add(new DailyPaymentIDOrderID() { OrderID = SubmitOrder(item.TaxOrderNumber, "GEL", item.CalculationDate.Date, item.ClientAccountIban, item.Payment, item.AgreementNumber, "09", user.AltasoftUserID, user.DeptID), PaymentID = item.DailyPaymentID, CoverLoanID = !item.IsOld ? CoverLoan(item.LoanID, item.Payment) : "Not Covered" }); } } return result; }
public static bool UpdatePaymentsInDaily(List<DailyPayment> payments) { using (var db = new AltasoftDailyContext()) { foreach (var payment in payments) { db.DailyPayments.FirstOrDefault(x => x.DailyPaymentID == payment.DailyPaymentID).Payment = payment.Payment; } db.SaveChanges(); } return true; }
public static int GetUpdatesByAltasoftUser(User user) { var calcDate = GetCalculationDate(); List<DailyPayment> result = new List<DailyPayment>(); using (var db = new AltasoftDailyContext()) { var localPayments = db.DailyPayments.Where(x => x.CalculationDate == calcDate && x.LocalUserID == user.UserID && !x.IsOld).ToList(); var localPaymentsIds = from x in localPayments select x.LoanID; var lmsPayments = GetDailyByUser(user.AltasoftUserID).Where(x => x.CalculationDate == calcDate && x.LoanID != 2331); var lmsPaymentsIds = from x in lmsPayments select x.LoanID; var newPaymentsIds = lmsPaymentsIds.Except(localPaymentsIds).ToList(); var oldPaymentsIds = localPaymentsIds.Except(lmsPaymentsIds).ToList(); var newPayments = lmsPayments.Where(x => newPaymentsIds.Contains(x.LoanID)); var oldPayments = localPayments.Where(x => oldPaymentsIds.Contains(x.LoanID)); int count = 0; if (localPayments.Count > 0) count = localPayments.Max(x => x.TaxOrderNumber); foreach (var item in newPayments) { count++; item.LocalUserID = user.UserID; item.TaxOrderNumber = int.Parse(user.DeptID + user.AltasoftUserID.ToString() + count); } if (newPaymentsIds.Count > 0) db.DailyPayments.AddRange(newPayments); if (oldPaymentsIds.Count > 0) db.DailyPayments.RemoveRange(oldPayments); db.SaveChanges(); return newPaymentsIds.Count; } }
///////////////////////////////////////////////// public static List<DailyPayment> GetDailyByUserTest(int altasoftUserId) { #region Initialize Services #region OrdersService AltasoftAPI.OrdersAPI.OrdersService o = new AltasoftAPI.OrdersAPI.OrdersService(); o.RequestHeadersValue = new AltasoftAPI.OrdersAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #region CustomersService AltasoftAPI.CustomersAPI.CustomersService c = new AltasoftAPI.CustomersAPI.CustomersService(); c.RequestHeadersValue = new AltasoftAPI.CustomersAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #region AccountsService AltasoftAPI.AccountsAPI.AccountsService a = new AltasoftAPI.AccountsAPI.AccountsService(); a.RequestHeadersValue = new AltasoftAPI.AccountsAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #region LoansService AltasoftAPI.LoansAPI.LoansService l = new AltasoftAPI.LoansAPI.LoansService(); l.RequestHeadersValue = new AltasoftAPI.LoansAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #endregion List<DailyPayment> list = new List<DailyPayment>(); List<DailyPaymentAndLoan> data = new List<DailyPaymentAndLoan>(); var loanss = l.ListLoans(new AltasoftAPI.LoansAPI.ListLoansQuery() { ControlFlags = AltasoftAPI.LoansAPI.LoanControlFlags.Authorities | AltasoftAPI.LoansAPI.LoanControlFlags.Debts | AltasoftAPI.LoansAPI.LoanControlFlags.Basic, Status = new AltasoftAPI.LoansAPI.LoanStatus[] { AltasoftAPI.LoansAPI.LoanStatus.Overdue, AltasoftAPI.LoansAPI.LoanStatus.Current, AltasoftAPI.LoansAPI.LoanStatus.Late } }); foreach (var loan in loanss) { var result = new DailyPaymentAndLoan(); #region Create Item var item = new DailyPayment() { LoanID = loan.Id.Value, CurrentDebtInGel = loan.Debts.Where(x => !x.Name.Contains("undue_principal")).Sum(x => x.Amount), TotalDebtInGel = loan.Debts.Sum(x => x.Amount), InterestPenaltyInGel = loan.Debts.Where(x => x.Name.Contains("overdue_interest_penalty")).Sum(x => x.Amount), PrincipalPenaltyInGel = loan.Debts.Where(x => x.Name.Contains("overdue_principal_penalty")).Sum(x => x.Amount), OverdueInterestInGel = loan.Debts.Where(x => x.Name.Contains("overdue_interest#") || x.Name.Contains("overdue_principal_interest")).Sum(x => x.Amount), AccruedInterestInGel = loan.Debts.Where(x => x.Name == ("interest")).Sum(x => x.Amount), OverduePrincipalInGel = loan.Debts.Where(x => x.Name.Contains("overdue_principal#")).Sum(x => x.Amount), PrincipalInGel = loan.Debts.Where(x => x.Name == ("undue_principal")).Sum(x => x.Amount), CurrentPrincipalInGel = loan.Debts.Where(x => x.Name == ("principal")).Sum(x => x.Amount) }; result.OperatorID = loan.Authorities.FirstOrDefault(x => x.Role == AltasoftAPI.LoansAPI.AuthorityRole.Operator).UserId.Value; item.ResponsibleUser = loan.Authorities.FirstOrDefault(x => x.Role == AltasoftAPI.LoansAPI.AuthorityRole.PrimaryResponsible).Name; item.DeptID = loan.BranchId.Value; item.CalculationDate = loan.CalcDate.Value.Date; item.LoanAmountInGel = loan.Amount.Amount; item.LoanCCY = loan.Amount.Ccy; item.ClientNo = loan.BorrowerId.Value; item.AgreementNumber = loan.AgreementNo; item.StartDate = loan.Term.Start.ToShortDateString(); item.EndDate = loan.Term.End.ToShortDateString(); result.ClientID = loan.BorrowerId.Value; result.DeptID = loan.BranchId.Value; var customer = c.GetCustomer(AltasoftAPI.CustomersAPI.CustomerControlFlags.Basic, true, loan.BorrowerId.Value, true); AltasoftAPI.CustomersAPI.Customer customer2; var account = a.GetAccount(AltasoftAPI.AccountsAPI.AccountControlFlags.Basic, true, new AltasoftAPI.AccountsAPI.InternalAccountIdentification() { Id = loan.AccountIdentifier, IdSpecified = true }, item.LoanCCY); customer2 = c.GetCustomer(AltasoftAPI.CustomersAPI.CustomerControlFlags.Extensions, true, loan.BorrowerId.Value, true); item.Phone = customer2.ContactInfo.MobilePhone; item.ClientAccountDescrip = account.DisplayName.ValueGeo; item.ClientName = customer.Name.ValueGeo; item.FirstName = (customer.Entity as AltasoftAPI.CustomersAPI.IndividualEntity).Name.FirstName.ValueGeo; item.LastName = (customer.Entity as AltasoftAPI.CustomersAPI.IndividualEntity).Name.LastName.ValueGeo; item.PersonalID = (customer.Entity as AltasoftAPI.CustomersAPI.IndividualEntity).PIN; item.ClientAccountBranchCode = customer.BranchId.Value.ToString(); item.ClientAccountIban = account.IBAN; AltasoftAPI.CustomersAPI.Customer customer3; customer3 = c.GetCustomer(AltasoftAPI.CustomersAPI.CustomerControlFlags.Addresses, true, loan.BorrowerId.Value, true); if (customer3.AddressActual != null) { item.ClientAddressFact = customer3.AddressActual.Value.ValueGeo; } item.NextScheduledPaymentInGel = l.GetLoanSchedule(AltasoftAPI.LoansAPI.DebtComponentDetalization.Detailed, true, AltasoftAPI.LoansAPI.GetLoanScheduleControlFlags.Full, true, item.LoanID, true).FirstOrDefault(x => x.Date == DateTime.Today) != null ? l.GetLoanSchedule(AltasoftAPI.LoansAPI.DebtComponentDetalization.Detailed, true, AltasoftAPI.LoansAPI.GetLoanScheduleControlFlags.Full, true, item.LoanID, true).FirstOrDefault(x => x.Date == DateTime.Today).Elements.Where(x => x.Name != "balance").Sum(x => x.Amount) : 0; AltasoftAPI.LoansAPI.Application app; bool? notm; bool notms; l.GetApplication(AltasoftAPI.LoansAPI.ApplicationControlFlags.ExtraFields, true, loan.Id.Value, true, out notm, out notms, out app); item.BusinessAddress = app.Businesses.FirstOrDefault().Address; result.DailyPayment = item; data.Add(result); #endregion } using (var db = new AltasoftDailyContext()) { var user = db.Users.FirstOrDefault(x => x.AltasoftUserID == altasoftUserId); try { if (user.Filter.IsDeptFilterEnabled && data != null) data = data.Where(x => x != null && user.Filter.FilterData.Any(y => y.DeptID == x.DeptID)).ToList(); if (user.Filter.IsCustomerFilterEnabled && data != null) data = data.Where(x => x != null && user.Filter.FilterData.Any(y => y.ClientID == x.ClientID)).ToList(); if (user.Filter.IsOperatorFilterEnabled && data != null) data = data.Where(x => x != null && user.Filter.FilterData.Any(y => y.OperatorID == x.OperatorID)).ToList(); } catch (NullReferenceException) { return new List<DailyPayment>(); } if (data != null) data.ForEach(x => { if (x != null) list.Add(x.DailyPayment); }); } return list.OrderBy(x => x.LoanID).ToList(); }
public static List<DailyPayment> GetDailyByUser(int altasoftUserId) { #region Initialize Services #region OrdersService AltasoftAPI.OrdersAPI.OrdersService o = new AltasoftAPI.OrdersAPI.OrdersService(); o.RequestHeadersValue = new AltasoftAPI.OrdersAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #region CustomersService AltasoftAPI.CustomersAPI.CustomersService c = new AltasoftAPI.CustomersAPI.CustomersService(); c.RequestHeadersValue = new AltasoftAPI.CustomersAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #region AccountsService AltasoftAPI.AccountsAPI.AccountsService a = new AltasoftAPI.AccountsAPI.AccountsService(); a.RequestHeadersValue = new AltasoftAPI.AccountsAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #region LoansService AltasoftAPI.LoansAPI.LoansService l = new AltasoftAPI.LoansAPI.LoansService(); l.RequestHeadersValue = new AltasoftAPI.LoansAPI.RequestHeaders() { ApplicationKey = "BusinessCreditClient", RequestId = Guid.NewGuid().ToString() }; #endregion #endregion List<DailyPayment> list = new List<DailyPayment>(); List<DailyPaymentAndLoan> data = new List<DailyPaymentAndLoan>(); var loansIds = (from x in l.ListLoans(new AltasoftAPI.LoansAPI.ListLoansQuery() { ControlFlags = AltasoftAPI.LoansAPI.LoanControlFlags.Basic, Status = new AltasoftAPI.LoansAPI.LoanStatus[] { AltasoftAPI.LoansAPI.LoanStatus.Overdue, AltasoftAPI.LoansAPI.LoanStatus.Current, AltasoftAPI.LoansAPI.LoanStatus.Late } }) select x.Id.Value).ToList().OrderBy(x => x); using (var db = new AltasoftDailyContext()) { var user = db.Users.FirstOrDefault(x => x.AltasoftUserID == altasoftUserId); loansIds.Where(x => x != 2331 /*&& x != 6*/).ToList().ForEach(x => data.Add(GetLoanAndDailyModel(x))); try { if (user.Filter.IsDeptFilterEnabled && data != null) data = data.Where(x => x != null && user.Filter.FilterData.Any(y => y.DeptID == x.DeptID)).ToList(); if (user.Filter.IsCustomerFilterEnabled && data != null) data = data.Where(x => x != null && user.Filter.FilterData.Any(y => y.ClientID == x.ClientID)).ToList(); if (user.Filter.IsOperatorFilterEnabled && data != null) data = data.Where(x => x != null && user.Filter.FilterData.Any(y => y.OperatorID == x.OperatorID)).ToList(); } catch (NullReferenceException) { return new List<DailyPayment>(); } if (data != null) data.ForEach(x => { if (x != null) list.Add(x.DailyPayment); }); } return list.OrderBy(x => x.LoanID).ToList(); }