public string GetDocumentTypeName(Int64 DocumentTypeID)
{
using (var db = new DBConnect(TenantSchema))
{
DocumentTypeMaster doc = db.DocumentTypeMaster.AsNoTracking().Where(l => l.DocumentTypeID == DocumentTypeID).FirstOrDefault();
if (doc != null)
{
return(doc.DisplayName);
}
}
return(string.Empty);
}
public List <DocumentTypeMaster> GetCustLoanDocTypes(Int64 CustomerID, Int64 LoanTypeID)
{
List <DocumentTypeMaster> docTypes = new List <DocumentTypeMaster>();
using (var db = new DBConnect(TenantSchema))
{
List <CustLoanDocMapping> CustReviewLoanDocMapping = db.CustLoanDocMapping.AsNoTracking()
.Where(d => d.CustomerID == CustomerID && d.LoanTypeID == LoanTypeID).ToList();
if (CustReviewLoanDocMapping != null)
{
foreach (var item in CustReviewLoanDocMapping)
{
DocumentTypeMaster doc = db.DocumentTypeMaster.AsNoTracking().Where(dm => dm.DocumentTypeID == item.DocumentTypeID).FirstOrDefault();
docTypes.Add(doc);
}
}
}
return(docTypes);
}
public Dictionary <long, string> GetLoanDocTypes(Int64 CustomerID, Int64 LoanTypeID)
{
Dictionary <long, string> docTypeID = new Dictionary <long, string>();
using (var db = new DBConnect(TenantSchema))
{
List <CustLoanDocMapping> CustReviewLoanDocMapping = db.CustLoanDocMapping.AsNoTracking()
.Where(d => d.CustomerID == CustomerID && d.LoanTypeID == LoanTypeID).ToList();
if (CustReviewLoanDocMapping != null)
{
foreach (var item in CustReviewLoanDocMapping)
{
DocumentTypeMaster doc = db.DocumentTypeMaster.AsNoTracking().Where(dm => dm.DocumentTypeID == item.DocumentTypeID).FirstOrDefault();
docTypeID[doc.DocumentTypeID] = doc.DisplayName;
}
docTypeID = docTypeID.OrderBy(d => d.Key).ToDictionary(d => d.Key, d => d.Value);
}
}
return(docTypeID);
}
