public DailyPaymentsForm(User user)
{
User = user;
InitializeComponent();
cbxPorts.Items.AddRange(SerialPort.GetPortNames());
}
public ChangePasswordForm(User user, bool forced = false)
{
InitializeComponent();
User = user;
if (forced)
btnCancel.Enabled = false;
}
public SingleOrderForm(DailyPayment payment, User user)
{
InitializeComponent();
Payment = payment;
User = user;
dtpDate.Value = Payment.CalculationDate;
cbxCcy.SelectedIndex = 0;
cbxCashDeskSymbol.SelectedIndex = 0;
}
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 AddCommentForm(int dailyPaymentID, User user)
{
User = user;
DailyPaymentID = dailyPaymentID;
InitializeComponent();
LoadData();
cbxCommentType.Items.AddRange((from x in Enum.GetValues(typeof(CommentType)).Cast<CommentType>().ToList()
select new { DisplayMember = GetEnumDescription((CommentType)x), ValueMember = x }).Cast<object>().ToArray());
}
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 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 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;
}
private static ExceptionLog CreateExceptionLog(Exception ex, User user, bool isInner = false)
{
var exLog = new ExceptionLog();
exLog.Date = DateTime.Now;
exLog.User = user;
exLog.IsInner = isInner;
exLog.Message = ex.Message;
exLog.Source = ex.Source;
exLog.StackTrace = ex.StackTrace;
if (ex.InnerException != null)
exLog.InnerException = CreateExceptionLog(ex.InnerException, user, true);
return exLog;
}
public CommentsForm(User user)
{
User = user;
InitializeComponent();
}
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 OrderLogsForm(User user)
{
InitializeComponent();
}
public LoggingForm(LogType type, User user)
{
InitializeComponent();
LogType = type;
}
public EnforcementForm(User user)
{
User = user;
InitializeComponent();
}
/////////////////////////////////////////////////
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 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;
}
}
