public List <DocumentsMasterDTO> Getdocumentidprofftypes(LoanIdDTO Documents)
{
try
{
return(obj.Getdocumentidprofftypes(Con, Documents));
}
catch (Exception ex)
{
throw new FinstaAppException(ex.ToString());
}
}
public List <DocumentsMasterDTO> Getdocumentidprofftypes(string ConnectionString, LoanIdDTO Documents)
{
List <DocumentsMasterDTO> lstdocumentidprofftypes = new List <DocumentsMasterDTO>();
try
{
dr1 = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select documentgroupid,documentgroupname from tblmstdocumentgroup");
if (Documents.pLoanId > 0)
{
dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select '' as contacttype,documentid,documentgroupid,documentgroupname,documentname,'false'::BOOLEAN as mandatory,'false'::BOOLEAN as required from tblmstdocumentproofs where statusid=1 and documentid not in(select documentid from tblmstloanwisedocumentproofs where statusid=1 and loanid=" + Documents.pLoanId + ") union select y.contacttype,x.documentid,x.documentgroupid,x.documentgroupname,x.documentname,y.isdocumentrequired as mandatory,y.isdocumentrequired required from tblmstdocumentproofs x right join tblmstloanwisedocumentproofs y on x.documentid = y.documentid where y.statusid = 1 and y.loanid = " + Documents.pLoanId + ";");
}
else
{
dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select '' as contacttype,documentid,documentgroupid,documentgroupname,documentname,'false'::BOOLEAN as mandatory,'false'::BOOLEAN as required from tblmstdocumentproofs where statusid=1");
}
while (dr1.Read())
{
DocumentsMasterDTO objdocumentidproofs = new DocumentsMasterDTO();
objdocumentidproofs.pDocumentGroupId = Convert.ToInt64(dr1["documentgroupid"]);
objdocumentidproofs.pDocumentGroup = dr1["documentgroupname"].ToString();
objdocumentidproofs.pDocumentsList = new List <pIdentificationDocumentsDTO>();
while (dr.Read())
{
if (dr1["documentgroupname"].ToString() == dr["documentgroupname"].ToString())
{
objdocumentidproofs.pDocumentsList.Add(new pIdentificationDocumentsDTO {
pContactType = dr["contacttype"].ToString(),
pDocumentId = Convert.ToInt64(dr["documentid"]), pDocumentName = dr["documentname"].ToString(),
pDocumentMandatory = Convert.ToBoolean(dr["mandatory"]),
pDocumentRequired = Convert.ToBoolean(dr["required"]), pDocumentgroupId = Convert.ToInt64(dr["documentgroupid"]),
pLoantypeId = Documents.pLoanId
});
}
}
lstdocumentidprofftypes.Add(objdocumentidproofs);
}
}
catch (Exception ex)
{
throw ex;
}
return(lstdocumentidprofftypes);
}
