public void TestRescheduleOUT()
{
const int loanID = 6; //4182; // 1718; // 4439; //3534;
Loan loan = new Loan();
ReschedulingArgument reModel = new ReschedulingArgument();
reModel.LoanType = loan.GetType()
.AssemblyQualifiedName;
reModel.LoanID = loanID;
reModel.ReschedulingDate = DateTime.UtcNow.Date.AddDays(0); //new DateTime(2015, 10, 02);
//reModel.ReschedulingRepaymentIntervalType = RepaymentIntervalTypes.Month;
reModel.SaveToDB = false;
reModel.RescheduleIn = false;
reModel.PaymentPerInterval = 180m;
reModel.StopFutureInterest = false;
var s1 = new RescheduleLoan <Loan>(loan, reModel);
s1.Context.UserID = 357; //25852;
try {
s1.Execute();
this.m_oLog.Debug("RESULT FOR OUT" + s1.Result.ToString());
// ReSharper disable once CatchAllClause
} catch (Exception e) {
Console.WriteLine(e);
}
}
public void TestRescheduleIN()
{
const int loanID = 11;
Loan loan = new Loan();
ReschedulingArgument reModel = new ReschedulingArgument();
reModel.LoanType = loan.GetType()
.AssemblyQualifiedName;
reModel.LoanID = loanID;
reModel.ReschedulingDate = DateTime.UtcNow.Date.AddDays(5);
//reModel.ReschedulingRepaymentIntervalType = RepaymentIntervalTypes.Month;
reModel.RescheduleIn = true;
reModel.SaveToDB = false;
reModel.StopFutureInterest = true;
try {
var s = new RescheduleLoan <Loan>(loan, reModel);
s.Context.UserID = 357; // 25852
s.Execute();
this.m_oLog.Debug("RESULT FOR IN" + s.Result.ToString());
// ReSharper disable once CatchAllClause
} catch (Exception e) {
Console.WriteLine(e);
}
}
public void TestMultipleRescheduling()
{
/*var loans = new[] {
* 18,19,20,22,29,30,31,32,33,34,36,37,38, 35, 4439, 3534, 1846, 2662, 1721,1758,1718,1764,1781,1795,1808,1810,1825,1831,1838,1841,1847,1856,1895,1903,1904,
* 3456,3462,3476,3478,3509,3510,3513,3521,3533,3535,3538,3539,3547,3583,3593,3607,3651,3670,3700,3710,3711,3714,3754,3827,3860,3917,3946,4081,4139,4174,4183,4192,
* 2990,2996,3003,3007,3032,3038,3083,3084,3094,3096,3113,3118,3141,3142,3166,3196,3208,3236,3275,3285,3302
* };
* // select top 10 * from [dbo].[Loan] l left join [dbo].[LoanScheduleDeleted] d on l.Id=d.LoanId where d.Id IS NULL and l.Status <> 'PaidOff' and YEAR(l.Date) = 2015 and DateClosed is null
* foreach (var loanID in loans) {
* try {
* ReschedulingArgument reModel = new ReschedulingArgument();
* Loan loan = new Loan();
* reModel.LoanType = loan.GetType().AssemblyQualifiedName;
* reModel.LoanID = loanID;
* reModel.RescheduleIn = false;
* reModel.SaveToDB = false;
* reModel.ReschedulingDate = DateTime.UtcNow;
* reModel.ReschedulingRepaymentIntervalType = RepaymentIntervalTypes.Month;
* if (reModel.RescheduleIn == false) {
* reModel.PaymentPerInterval = 900m;
* }
* var s = new RescheduleLoan<Loan>(loan, reModel);
* s.Context.UserID = 25852;
* s.Execute();
* m_oLog.Debug(s.Result.ToString());
* } catch (Exception e) {
* Console.WriteLine(e);
* }
* }*/
Loan loan = new Loan();
this.m_oDB.ForEachRowSafe((sr) => {
try {
int loanid = sr["Id"];
// IN
/* ReschedulingArgument reModel = new ReschedulingArgument();
* reModel.LoanID = loanid;
* reModel.LoanType = loan.GetType().AssemblyQualifiedName;
* reModel.RescheduleIn = true;
* reModel.SaveToDB = false;
* reModel.ReschedulingDate = DateTime.UtcNow.Date.AddDays(15);
* reModel.ReschedulingRepaymentIntervalType = RepaymentIntervalTypes.Month;
* var s = new RescheduleLoan<Loan>(loan, reModel);
* s.Context.UserID = 357; //25852;
* s.Execute();
* this.m_oLog.Debug(s.Result.ToString());
* this.m_oLog.Debug("IN_RESULT: {0}", s.Result.ToString());*/
// OUT
ReschedulingArgument reModel1 = new ReschedulingArgument();
Loan loan1 = new Loan();
reModel1.LoanID = loanid;
reModel1.LoanType = loan1.GetType()
.AssemblyQualifiedName;
reModel1.RescheduleIn = false;
reModel1.SaveToDB = false;
reModel1.ReschedulingDate = DateTime.UtcNow.Date.AddDays(44);
reModel1.ReschedulingRepaymentIntervalType = RepaymentIntervalTypes.Month;
reModel1.PaymentPerInterval = 90m;
reModel1.StopFutureInterest = true;
var s1 = new RescheduleLoan <Loan>(loan1, reModel1);
s1.Context.UserID = 357; //25852;
s1.Execute();
this.m_oLog.Debug("OUT_RESULT: {0}", s1.Result.ToString());
} catch (Exception e) {
Console.WriteLine(e);
}
},
"select top 100 l.Id from [dbo].[Loan] l left join [dbo].[LoanScheduleDeleted] d on l.Id=d.LoanId where d.Id IS NULL and l.Status <> 'PaidOff' and DateClosed is null", // order by l.Id desc",
// "select top 10 * from [dbo].[Loan] l left join [dbo].[LoanScheduleDeleted] d on l.Id=d.LoanId where d.Id IS NULL and l.Status <> 'PaidOff' and YEAR(l.Date) = 2015 and DateClosed is null order ",
CommandSpecies.Text); //top 100
}
