public void GetLoanApplicationWithBalance_LoanAmountUnder1000_NullValuesReturned()
{
var name = "sumon";
var loanApplication = new tblLoanApplication
{
Name = name,
Amount = 140,
Id = 1
};
var balance = new tblBalance
{
Name = "sumon",
Balance = 3500,
Id = 3
};
_loanApplicationUow.Setup(l => l.Repository <tblLoanApplication>().Get(It.IsAny <Func <tblLoanApplication, bool> >()))
.Returns(loanApplication);
_loanApplicationUow.Setup(l => l.Repository <tblBalance>().Get(It.IsAny <Func <tblBalance, bool> >()))
.Returns(balance);
var result = _loanApplicationService.GetLoanApplicationWithBalance(name);
(result.BalanceAmount).Should().Be(null);
(result.LoanAmount).Should().Be(null);
}
public override void FillSelectedRecordInContent(object RecordToFill)
{
LoanApplicationEditListModel EditingRecord = (LoanApplicationEditListModel)RecordToFill;
tblLoanApplication SaveModel = DALObject.FindSaveModelByPrimeKey(EditingRecord.LoanApplicationID);
if (SaveModel == null)
{
return;
}
deLoanApplicationDate.DateTime = SaveModel.LoanApplicationDate;
lookupLoanApplicationNoPrefix.EditValue = SaveModel.LoanApplicationNoPrefixID;
txtLoanApplicationNo.EditValue = SaveModel.LoanApplicationNo;
lookupEmployee.EditValue = SaveModel.EmployeeID;
deDateFrom.DateTime = new DateTime(SaveModel.YearFrom, SaveModel.MonthFrom, 1);
deDateTo.DateTime = new DateTime(SaveModel.YearTo, SaveModel.MonthTo, 1);
txtLoanAmount.EditValue = SaveModel.LoanAmount;
InstallmentAmount = SaveModel.InstallmentAmount;
txtLoanPurpose.Text = SaveModel.LoanPurpose;
txtRemarks.Text = SaveModel.Remarks;
txtDocument.Text = SaveModel.ApplicationDocumentFileName;
base.FillSelectedRecordInContent(RecordToFill);
}
public SavingResult SaveNewRecord(tblLoanApplication SaveModel)
{
SavingResult res = new SavingResult();
//-- Perform Validation
//res.ExecutionResult = eExecutionResult.ValidationError;
//res.ValidationError = "Validation error message";
//return res;
//--
using (dbVisionEntities db = new dbVisionEntities())
{
//tblLoanApplication SaveModel;
if (SaveModel.LoanApplicationNo == 0)
{
res.ValidationError = "Please enter Loan Application No.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
else if (IsDuplicateRecord(SaveModel.LoanApplicationNoPrefixID, SaveModel.LoanApplicationNo, SaveModel.LoanApplicationID, db))
{
res.ValidationError = "Can not accept duplicate value. The Loan Application No. is already exists.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
if (SaveModel.LoanApplicationID == 0) // New Entry
{
SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.rcdt = DateTime.Now;
SaveModel.CompanyID = Model.CommonProperties.LoginInfo.LoggedInCompany.CompanyID;
SaveModel.FinPeriodID = Model.CommonProperties.LoginInfo.LoggedInFinPeriod.FinPeriodID;
db.tblLoanApplications.Add(SaveModel);
}
else
{
SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.redt = DateTime.Now;
db.tblLoanApplications.Attach(SaveModel);
db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
}
//--
try
{
db.SaveChanges();
res.PrimeKeyValue = SaveModel.LoanApplicationID;
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
return(res);
}
public void Create_AddAnotherLoanApplication_LoanApplicationCreated()
{
var loan = new tblLoanApplication
{
Name = "Kamal",
Amount = 300,
};
LoanService.CreteLoan(loan);
var result = LoanService.GetLoan(loan.Id);
(result.Name).Should().Be("Kamal");
}
static void Main(string[] args)
{
var kernel = new StandardKernel();
kernel.Bind <ILoanService>().To <LoanService>();
kernel.Bind <ILoanApplicationUnitOfWork>().To <LoanApplicationUnitOfWork>();
var loanService = kernel.Get <ILoanService>();
var result = loanService.GetLoan(1);
Console.WriteLine(result.Name);
var loan = new tblLoanApplication
{
Name = "Test",
Amount = 3400,
Id = 3434
};
loanService.CreteLoan(loan);
}
public void Get_AddTwoLoans_CorrectLoanIsRetrived()
{
var loan1 = new tblLoanApplication
{
Id = 1,
Name = "sumon",
Amount = 25000
};
var loan2 = new tblLoanApplication
{
Id = 2,
Name = "Kamal",
Amount = 3580
};
_mockLoanApplications.SetSource(new[] { loan1, loan2 });
var result = _loanApplicationRespository.Get(c => c.Id == 1);
(result).Should().NotBeNull();
(result.Amount).Should().Be(25000);
}
public void Create_AddALoanApplication_LoanApplicationCreated()
{
var firstLoan = new tblLoanApplication
{
Amount = 33434,
Name = "Mostofa"
};
LoanUnitOfWork.Repository <tblLoanApplication>().Add(firstLoan);
LoanUnitOfWork.SaveChanges();
var loan = new tblLoanApplication
{
Name = "Sumon",
Amount = 4509,
};
LoanService.CreteLoan(loan);
var result = LoanService.GetLoan(loan.Id);
(result.Amount).Should().Be(4509);
}
public SavingResult DeleteRecord(long DeleteID)
{
SavingResult res = new SavingResult();
using (dbVisionEntities db = new dbVisionEntities())
{
if (DeleteID != 0)
{
tblLoanApplication RecordToDelete = db.tblLoanApplications.FirstOrDefault(r => r.LoanApplicationID == DeleteID);
if (RecordToDelete == null)
{
res.ValidationError = "Selected record not found. May be it has been deleted by another user over network.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
else
{
//db.tblLoanApplications.Remove(RecordToDelete);
byte RecordState_Deleted = (byte)eRecordState.Deleted;
RecordToDelete.rstate = RecordState_Deleted;
db.tblLoanApplications.Attach(RecordToDelete);
db.Entry(RecordToDelete).State = System.Data.Entity.EntityState.Modified;
}
try
{
db.SaveChanges();
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
}
return(res);
}
public void CreteLoan(tblLoanApplication loan)
{
_uow.Repository <tblLoanApplication>().Add(loan);
_uow.SaveChanges();
}
public override void SaveRecord(SavingParemeter Paras)
{
DAL.tblLoanApplication SaveModel = null;
if (Paras.SavingInterface == SavingParemeter.eSavingInterface.AddNew || EditRecordDataSource == null)
{
SaveModel = new tblLoanApplication();
}
else
{
SaveModel = DALObject.FindSaveModelByPrimeKey(((LoanApplicationEditListModel)EditRecordDataSource).LoanApplicationID);
if (SaveModel == null)
{
Paras.SavingResult = new SavingResult();
Paras.SavingResult.ExecutionResult = eExecutionResult.ValidationError;
Paras.SavingResult.ValidationError = "Can not edit. Selected record not found, it may be deleted by another user.";
return;
}
}
SaveModel.LoanApplicationDate = deLoanApplicationDate.DateTime.Date;
SaveModel.LoanApplicationNoPrefixID = (int)lookupLoanApplicationNoPrefix.EditValue;
SaveModel.LoanApplicationNo = Model.CommonFunctions.ParseInt(txtLoanApplicationNo.Text);
SaveModel.EmployeeID = (int)lookupEmployee.EditValue;
SaveModel.MonthFrom = deDateFrom.DateTime.Month;
SaveModel.YearFrom = deDateFrom.DateTime.Year;
SaveModel.MonthTo = deDateTo.DateTime.Month;
SaveModel.YearTo = deDateTo.DateTime.Year;
SaveModel.LoanAmount = Model.CommonFunctions.ParseDecimal(txtLoanAmount.Text);
SaveModel.InstallmentAmount = InstallmentAmount;
SaveModel.LoanPurpose = txtLoanPurpose.Text;
SaveModel.Remarks = txtRemarks.Text;
// if new record or document has been changed then update it.
if (Paras.SavingInterface == SavingParemeter.eSavingInterface.AddNew || SaveModel.ApplicationDocumentFileName != txtDocument.Text)
{
SaveModel.ApplicationDocumentFileName = null;
if (!String.IsNullOrWhiteSpace(txtDocument.Text) && System.IO.File.Exists(txtDocument.Text))
{
string DocumentNewPath = Path.GetFullPath(Path.Combine(CommonProperties.LoginInfo.SoftwareSettings.DocumentLocation_LoanApplicationDocument));
string DocumentNewFileName = Path.Combine(DocumentNewPath,
"LAD" + CommonProperties.LoginInfo.LoggedInCompany.CompanyID.ToString("000") + CommonProperties.LoginInfo.LoggedInFinPeriod.FinPeriodID.ToString("000") +
SaveModel.LoanApplicationNo.ToString("0000000000") + Path.GetExtension(txtDocument.Text));
try
{
if (!Directory.Exists(DocumentNewPath))
{
Directory.CreateDirectory(DocumentNewPath);
}
// Allow to overwrite the document only if in edit mode
File.Copy(txtDocument.Text, DocumentNewFileName, (SaveModel.LoanApplicationID != 0));
}
catch (System.IO.IOException ex)
{
SavingResult res = new SavingResult();
DAL.CommonFunctions.GetFinalError(res, ex);
Paras.SavingResult = res;
return;
}
SaveModel.ApplicationDocumentFileName = DocumentNewFileName;
}
}
Paras.SavingResult = DALObject.SaveNewRecord(SaveModel);
base.SaveRecord(Paras);
}
