private void CollateralForm_Load(object sender, EventArgs e)
{
#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 collateral = l.ListCollaterals(new AltasoftAPI.LoansAPI.ListCollateralsQuery()
{
ControlFlags = AltasoftAPI.LoansAPI.CollateralControlFlags.Basic | AltasoftAPI.LoansAPI.CollateralControlFlags.Attributes,
Id = collateralID,
IdSpecified = true
});
var linked = l.ListLinkedCollaterals(new AltasoftAPI.LoansAPI.ListLinkedCollateralsQuery()
{
CollateralId = collateralID,
CollateralIdSpecified = true,
ControlFlags = AltasoftAPI.LoansAPI.LinkedCollateralControlFlags.Basic | AltasoftAPI.LoansAPI.LinkedCollateralControlFlags.Attributes,
ApplicationIdSpecified = true
});
tbxType.Text = collateral[0].CollateralType;
var customer = c.GetCustomer(AltasoftAPI.CustomersAPI.CustomerControlFlags.Basic | AltasoftAPI.CustomersAPI.CustomerControlFlags.Addresses | AltasoftAPI.CustomersAPI.CustomerControlFlags.Extensions, true, collateral[0].OwnerId.Value, true);
tbxOwner.Text = collateral[0].OwnerId.Value.ToString() + " | " + customer.Name.ValueGeo;
tbxIdNumber.Text = (customer.Entity as AltasoftAPI.CustomersAPI.IndividualEntity).PIN;
tbxBranch.Text = customer.BranchId.Value.ToString();
tbxAgreement.Text = collateral[0].AgreementNo;
tbxAddressLegal.Text = customer.AddressLegal.Value.ValueGeo;
tbxMobile.Text = customer.ContactInfo.MobilePhone;
tbxPhone.Text = customer.ContactInfo.Phone;
var relations = new List<RelationModel>();
foreach (var item in linked)
{
bool? n;
bool n2;
AltasoftAPI.LoansAPI.Application app;
l.GetApplication(AltasoftAPI.LoansAPI.ApplicationControlFlags.Basic | AltasoftAPI.LoansAPI.ApplicationControlFlags.Extended | AltasoftAPI.LoansAPI.ApplicationControlFlags.ExtraFields | AltasoftAPI.LoansAPI.ApplicationControlFlags.Extensions, true, item.ApplicationId.Value, true, out n, out n2, out app);
var loan = l.GetLoan(AltasoftAPI.LoansAPI.LoanControlFlags.Basic, true, app.Id.Value, true);
var customer2 = c.GetCustomer(AltasoftAPI.CustomersAPI.CustomerControlFlags.Basic, true, loan.BorrowerId.Value, true);
var r = new RelationModel()
{
AgreementNo = loan.AgreementNo,
Amount = item.LinkAmount.Amount,
Borrower = customer2.Name.ValueGeo,
Currency = item.LinkAmount.Ccy,
EndDate = loan.Term.End,
StartDate = loan.Term.Start,
LoanAmount = loan.Amount.Amount,
LoanCurrency = loan.Amount.Ccy,
LoanInterest = loan.InterestBasis.ToString() + "%",
Product = l.GetLoanProduct(loan.ProductId.Value, true).Name,
RelationDate = item.LinkDate.Value,
Status = item.State == AltasoftAPI.LoansAPI.CollateralLinkState.Closed ? RelationStatus.დახურული : RelationStatus.მიმდინარე,
};
relations.Add(r);
}
gridRelations.DataSource = relations;
}
private void ViewCollateralsForm_Load(object sender, EventArgs e)
{
#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
AltasoftAPI.LoansAPI.Application app;
bool? n;
bool n2;
l.GetApplication(AltasoftAPI.LoansAPI.ApplicationControlFlags.Basic | AltasoftAPI.LoansAPI.ApplicationControlFlags.Extensions, true, loanId, true, out n, out n2, out app);
var collaterals = l.ListLinkedCollaterals(new AltasoftAPI.LoansAPI.ListLinkedCollateralsQuery()
{
ControlFlags = AltasoftAPI.LoansAPI.LinkedCollateralControlFlags.Basic | AltasoftAPI.LoansAPI.LinkedCollateralControlFlags.Attributes,
ApplicationId = app.Id.Value,
ApplicationIdSpecified = app.IdSpecified
});
List<CollateralModel> list = new List<CollateralModel>();
foreach (var item in collaterals)
{
var coll = l.ListCollaterals(new AltasoftAPI.LoansAPI.ListCollateralsQuery()
{
Id = item.CollateralId,
IdSpecified = item.CollateralIdSpecified,
ControlFlags = AltasoftAPI.LoansAPI.CollateralControlFlags.Basic | AltasoftAPI.LoansAPI.CollateralControlFlags.Attributes
});
var customer = c.GetCustomer(AltasoftAPI.CustomersAPI.CustomerControlFlags.Basic | AltasoftAPI.CustomersAPI.CustomerControlFlags.Addresses, true, coll[0].OwnerId.Value, true);
var col = new CollateralModel()
{
Name = customer.Name.ValueGeo,
AgreementNumber = coll[0].AgreementNo,
CCy = item.LinkAmount.Ccy,
CollateralID = coll[0].CollateralId,
Discount = coll[0].Discount,
LiquidationAmount = item.LinkAmount.Amount,
MarketPrice = coll[0].MarketValue,
CloseDate = item.CloseDate
};
list.Add(col);
}
dataGridView1.DataSource = list;
}
/////////////////////////////////////////////////
public static List<EnforcementLoan> ListEnForcementLoans(User problemManager, params int[] localIds)
{
#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 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 }
}) select x.Id.Value).Except(localIds).ToArray();
var list1 = new List<EnforcementLoan>();
foreach (var i in loansIds)
{
var loan = l.GetLoan(AltasoftAPI.LoansAPI.LoanControlFlags.Basic | AltasoftAPI.LoansAPI.LoanControlFlags.Authorities | AltasoftAPI.LoansAPI.LoanControlFlags.Debts, true, i, true);
if (loan.Authorities.FirstOrDefault(x => x.Role == AltasoftAPI.LoansAPI.AuthorityRole.ProblemManager && x.UserId.Value == problemManager.AltasoftUserID) == null)
continue;
var cus1 = c.GetCustomer(AltasoftAPI.CustomersAPI.CustomerControlFlags.Basic | AltasoftAPI.CustomersAPI.CustomerControlFlags.Addresses | AltasoftAPI.CustomersAPI.CustomerControlFlags.ContactPersons | AltasoftAPI.CustomersAPI.CustomerControlFlags.Extensions, true, loan.BorrowerId.Value, true);
/////////////////////////////////
AltasoftAPI.LoansAPI.Application app;
bool? n;
bool n2;
l.GetApplication(AltasoftAPI.LoansAPI.ApplicationControlFlags.Basic | AltasoftAPI.LoansAPI.ApplicationControlFlags.Extensions, true, i, true, out n, out n2, out app);
var collaterals = l.ListLinkedCollaterals(new AltasoftAPI.LoansAPI.ListLinkedCollateralsQuery()
{
ControlFlags = AltasoftAPI.LoansAPI.LinkedCollateralControlFlags.Basic | AltasoftAPI.LoansAPI.LinkedCollateralControlFlags.Attributes,
ApplicationId = app.Id.Value,
ApplicationIdSpecified = app.IdSpecified
});
/////////////////////////////////
var enf = new EnforcementLoan();
enf.LoanID = loan.Id.Value;
enf.AgreementAndSummaryJudgementTerms = new AgreementAndSummaryJudgementTerms() { End = DateTime.Now, Start = DateTime.Now, PaymentDay = 0 };
try
{
enf.BorrowerAddress = cus1.AddressActual != null ? cus1.AddressActual.Value.ValueGeo : "";
}
catch { }
enf.BorrowerName = cus1.Name != null ? cus1.Name.ValueGeo : "";
enf.BorrowerPhone = cus1.ContactInfo != null ? cus1.ContactInfo.MobilePhone : "";
enf.CreditExpert = loan.Authorities.FirstOrDefault(x => x.Role == AltasoftAPI.LoansAPI.AuthorityRole.Operator).Name;
enf.LoanAgreementNumber = loan.AgreementNo;
enf.Status = EnforcementLoanStatus.Active;
enf.GivePLD = DateTime.Now;
enf.ProblemManagerName = loan.Authorities.FirstOrDefault(x => x.Role == AltasoftAPI.LoansAPI.AuthorityRole.ProblemManager).Name;
enf.ProblemManagerID = loan.Authorities.FirstOrDefault(x => x.Role == AltasoftAPI.LoansAPI.AuthorityRole.ProblemManager).UserId.Value;
enf.BorrowerPrivateNumber = (cus1.Entity as AltasoftAPI.CustomersAPI.IndividualEntity).PIN;
enf.CaseStatus = EnforcementCaseStatus.NewCase;
///////////////////////////////////////////
enf.LoanPrincipal = loan.Debts.Where(x => x.Name.Contains("overdue_principal#")).Sum(x => x.Amount) //OverduePrincipalInGel
+ loan.Debts.Where(x => x.Name == ("undue_principal")).Sum(x => x.Amount) //PrincipalInGel
+ loan.Debts.Where(x => x.Name == ("principal")).Sum(x => x.Amount) //CurrentPrincipalInGel
+ loan.Debts.Where(x => x.Name.ToLower().Contains("late") && x.Name.ToLower().Contains("principal")).Sum(x => x.Amount); //LatePrincipalInGel
enf.LoanInterest = loan.Debts.Where(x => x.Name.Contains("overdue_interest#") || x.Name.Contains("overdue_principal_interest")).Sum(x => x.Amount) //OverdueInterestInGel
+ loan.Debts.Where(x => x.Name == ("interest")).Sum(x => x.Amount); //AccruedInterestInGel
enf.LoanPenalty = loan.Debts.Where(x => x.Name.Contains("overdue_interest_penalty")).Sum(x => x.Amount) //InterestPenaltyInGel
+ loan.Debts.Where(x => x.Name.Contains("overdue_principal_penalty")).Sum(x => x.Amount); //PrincipalPenaltyInGel
enf.TotalLoanDebt = loan.Debts.Sum(x => x.Amount);
///////////////////////////////////////////
enf.ApplicationSubmitDate = DateTime.Now;
enf.LoanStartDate = loan.Term.Start;
if (collaterals.Count() > 0)
{
var coll = l.ListCollaterals(new AltasoftAPI.LoansAPI.ListCollateralsQuery()
{
Id = collaterals.FirstOrDefault().CollateralId,
IdSpecified = collaterals.FirstOrDefault().CollateralIdSpecified,
ControlFlags = AltasoftAPI.LoansAPI.CollateralControlFlags.Basic | AltasoftAPI.LoansAPI.CollateralControlFlags.Attributes
});
var col1 = c.GetCustomer(AltasoftAPI.CustomersAPI.CustomerControlFlags.Basic | AltasoftAPI.CustomersAPI.CustomerControlFlags.Addresses, true, coll[0].OwnerId.Value, true);
}
if (loan.Authorities.FirstOrDefault(x => x.Role == AltasoftAPI.LoansAPI.AuthorityRole.ProblemManager) != null)
list1.Add(enf);
}
return list1;
}
public static DailyPaymentAndLoan GetLoanAndDailyModel(int loanId)
{
#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 result = new DailyPaymentAndLoan();
var loan = l.GetLoan(AltasoftAPI.LoansAPI.LoanControlFlags.Authorities | AltasoftAPI.LoansAPI.LoanControlFlags.Debts | AltasoftAPI.LoansAPI.LoanControlFlags.Basic, true, loanId, true);
var bbbb = from x in loan.Debts
select x.Name;
#region Create Item
var pm = loan.Authorities.LastOrDefault(x => x.Role == AltasoftAPI.LoansAPI.AuthorityRole.ProblemManager);
var item = new DailyPayment()
{
LoanID = loanId,
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),
LatePrincipalInGel = loan.Debts.Where(x => x.Name.ToLower().Contains("late") && x.Name.ToLower().Contains("principal")).Sum(x => x.Amount),
ProblemManager = pm != null ? pm.Name : ""
};
result.OperatorID = loan.Authorities.LastOrDefault(x => x.Role == AltasoftAPI.LoansAPI.AuthorityRole.PrimaryResponsible).UserId.Value;
item.ResponsibleUser = loan.Authorities.FirstOrDefault(x => x.Role == AltasoftAPI.LoansAPI.AuthorityRole.PrimaryResponsible).Name;
loan = l.GetLoan(AltasoftAPI.LoansAPI.LoanControlFlags.Basic, true, loanId, true);
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);
if (customer2.ContactInfo != null)
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 && customer3.AddressActual.Value != 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);
if (app.Businesses != null)
item.BusinessAddress = app.Businesses.FirstOrDefault().Address;
result.DailyPayment = item;
#endregion
return result;
}
/////////////////////////////////////////////////
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> GetDailyByDeptId(int deptId)
{
#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>();
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);
foreach (var loanId in loansIds)
{
var loan = l.GetLoan(AltasoftAPI.LoansAPI.LoanControlFlags.Authorities | AltasoftAPI.LoansAPI.LoanControlFlags.Debts | AltasoftAPI.LoansAPI.LoanControlFlags.Basic, true, loanId, true);
if (loan.BranchId == deptId)
{
var item = new DailyPayment()
{
LoanID = loanId,
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)
};
loan = l.GetLoan(AltasoftAPI.LoansAPI.LoanControlFlags.Basic, true, loanId, true);
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();
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);
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;
list.Add(item);
}
}
//list.AddRange(GetDailyByDeptId() as IEnumerable<DailyPayment>);
return list.OrderBy(x => x.ClientNo).ToList();
}
public static int GetCollateralIdByLoanId(int loanId)
{
#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
AltasoftAPI.LoansAPI.Application app;
bool? n;
bool n2;
l.GetApplication(AltasoftAPI.LoansAPI.ApplicationControlFlags.Basic | AltasoftAPI.LoansAPI.ApplicationControlFlags.Extensions, true, loanId, true, out n, out n2, out app);
var collaterals = l.ListLinkedCollaterals(new AltasoftAPI.LoansAPI.ListLinkedCollateralsQuery()
{
ControlFlags = AltasoftAPI.LoansAPI.LinkedCollateralControlFlags.Basic | AltasoftAPI.LoansAPI.LinkedCollateralControlFlags.Attributes,
ApplicationId = app.Id.Value,
ApplicationIdSpecified = app.IdSpecified
});
//var collateral = l.ListCollaterals(new AltasoftAPI.LoansAPI.ListCollateralsQuery()
// {
// ControlFlags = AltasoftAPI.LoansAPI.CollateralControlFlags.Basic | AltasoftAPI.LoansAPI.CollateralControlFlags.Attributes,
// AccountId = loan.AccountIdentifier,
// AccountIdSpecified = loan.AccountIdentifierSpecified,
// CollateralType = "03"
// });
return collaterals.FirstOrDefault().CollateralId.Value;
}
