Time: 29/10/2025 11:14:53 AM
PageName: DataTableResult
String str:  SELECT isnull(a.BranchName,'N/A')+' ('+isnull(a.BranchId,'')+')'AS BranchName, isnull(a.LoanOfficerName,'N/A')+' ('+isnull(a.LoanOfficerId,'')+')'AS LoanOfficerName,isnull(a.CenterName, 'N/A') + ' (' + isnull(a.CenterId, '') + ')'AS CenterName, isnull(a.GroupName, 'N/A')AS GroupName, isnull(c.MeetingType, 'N/A')AS MeetingType,CASE WHEN c.MeetingType = 'Monthly' THEN convert(CHAR, c.MeetingDate) WHEN c.MeetingType IN('Weekly', 'BiWeekly') THEN c.MeetingDay ELSE '' END AS MeetingDay,isnull(c.MeetingTime, 'N/A')AS MeetingTime, isnull(c.MeetingDetail, 'N/A')AS MeetingDetail, isnull(a.MemberId, 'N/A')AS MemberId, isnull(a.MemberName, 'N/A')AS MemberName,isnull(b.MemberGender, 'N/A')AS MemberGender, CASE WHEN b.MemberDOB IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, b.MemberDOB, 106)) END + ' (' + CASE WHEN b.MemberAge IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, b.MemberAge)) END + ' Year)' AS MemberDOBAge, isnull(b.GuardianSalutation, '') + ' ' + isnull(b.MemberGuardianName, 'N/A')AS MemberGuardianName, isnull(b.MemberMobileNo, 'N/A')AS MemberMobileNo, isnull(b.NomineeMobileNo, 'N/A')AS NomineeMobileNo, isnull(b.MemberAddress, 'N/A')AS MemberAddress,isnull(b.MemberOccupation, 'N/A')AS MemberOccupation, isnull(Convert(CHAR, b.MemberAnnualIncome), 'N/A')AS MemberAnnualIncome, isnull(a.NomineeName, 'N/A')AS NomineeName, CASE WHEN a.NomineeDOB IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.NomineeDOB, 106)) END + ' (' + CASE WHEN a.NomineeAge IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.NomineeAge)) END + ')' AS NomineeDOBAge, isnull(a.NomineeRelation, 'N/A')AS NomineeRelation, isnull(a.NomineeAddress, 'N/A')AS NomineeAddress,isnull(a.LoanId, 'N/A')AS LoanId, CASE WHEN a.LoanCycle IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanCycle)) END AS LoanCycle, isnull(a.GLoanTypeName, 'N/A')AS GLoanTypeName, isnull(a.GLoanTypeNo, 'N/A')AS GLoanTypeNo, CASE WHEN a.LoanTerm IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanTerm)) END + '-' + isnull (a.LoanTermMode, 'N/A')AS LoanTerm, CASE WHEN a.LoanAmount IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanAmount)) END AS LoanAmount, CASE WHEN a.TotalInterest IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.TotalInterest)) END AS TotalInterest, CASE WHEN a.EMIAmount IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.EMIAmount)) END AS EMIAmount, isnull(a.LoanPurpose, 'N/A')AS LoanPurpose, isnull(a.LoanFunder, 'N/A')AS LoanFunder, CASE WHEN a.DisburseDate IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.DisburseDate, 106)) END AS DisburseDate, CASE WHEN a.ExpiryDate IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.ExpiryDate, 106)) END AS ExpiryDate, (SELECT  SUM(Total) from GroupLoanLedger WHERE LoanId = a.LoanId)AS TotalEMI,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue,'~/','') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+a.MemberId+'/'+a.LoanId+'LoanQR'+a.MemberId+'.png' AS MemberLoanQRCodePhoto, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+a.MemberId + '/' +MemberNomineeJointPhoto AS MemberNomineeJointPhoto, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyURL') + (SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting  WITH(nolock) WHERE ReportName = 'GroupMemberKYCFolder')+'/' + b.MemberNomineeJointPhoto AS MemberNomineeJointPhoto,(SELECT CompanyName FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyName')AS CompanyName, (SELECT ReportValue AS CompanyDetail1 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail1')AS CompanyDetail1, (SELECT ReportValue AS CompanyDetail2 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail2' WITH(nolock) WHERE 1 = 1)AS CompanyDetail2,(SELECT ReportValue AS CompanyDetail3 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail3')AS CompanyDetail3,(SELECT ReportValue AS CompanyImageURL FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyImageURL')AS CompanyImageURL, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' WHERE 1 = 1)AS CompanyURL,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' WHERE 1 = 1)AS GroupMemberKYCFolder, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyBannerURL') AS CompanyBannerURL FROM GroupLoanAccount a WITH(nolock)LEFT JOIN GroupLoanMemberDetail b WITH(nolock) ON a.MemberId = b.MemberId INNER JOIN GroupCenterMaster c WITH(nolock) ON a.CenterId = c.CenterId   WHERE a.LoanId='GL00001476' ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Incorrect syntax near the keyword 'WITH'.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'WHERE'.
Incorrect syntax near the keyword 'WHERE'.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 29/10/2025 11:14:53 AM
PageName: GroupLoan_PrintGroupLoanCardFrontPotraitHTML
String str:  SELECT isnull(a.BranchName,'N/A')+' ('+isnull(a.BranchId,'')+')'AS BranchName, isnull(a.LoanOfficerName,'N/A')+' ('+isnull(a.LoanOfficerId,'')+')'AS LoanOfficerName,isnull(a.CenterName, 'N/A') + ' (' + isnull(a.CenterId, '') + ')'AS CenterName, isnull(a.GroupName, 'N/A')AS GroupName, isnull(c.MeetingType, 'N/A')AS MeetingType,CASE WHEN c.MeetingType = 'Monthly' THEN convert(CHAR, c.MeetingDate) WHEN c.MeetingType IN('Weekly', 'BiWeekly') THEN c.MeetingDay ELSE '' END AS MeetingDay,isnull(c.MeetingTime, 'N/A')AS MeetingTime, isnull(c.MeetingDetail, 'N/A')AS MeetingDetail, isnull(a.MemberId, 'N/A')AS MemberId, isnull(a.MemberName, 'N/A')AS MemberName,isnull(b.MemberGender, 'N/A')AS MemberGender, CASE WHEN b.MemberDOB IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, b.MemberDOB, 106)) END + ' (' + CASE WHEN b.MemberAge IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, b.MemberAge)) END + ' Year)' AS MemberDOBAge, isnull(b.GuardianSalutation, '') + ' ' + isnull(b.MemberGuardianName, 'N/A')AS MemberGuardianName, isnull(b.MemberMobileNo, 'N/A')AS MemberMobileNo, isnull(b.NomineeMobileNo, 'N/A')AS NomineeMobileNo, isnull(b.MemberAddress, 'N/A')AS MemberAddress,isnull(b.MemberOccupation, 'N/A')AS MemberOccupation, isnull(Convert(CHAR, b.MemberAnnualIncome), 'N/A')AS MemberAnnualIncome, isnull(a.NomineeName, 'N/A')AS NomineeName, CASE WHEN a.NomineeDOB IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.NomineeDOB, 106)) END + ' (' + CASE WHEN a.NomineeAge IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.NomineeAge)) END + ')' AS NomineeDOBAge, isnull(a.NomineeRelation, 'N/A')AS NomineeRelation, isnull(a.NomineeAddress, 'N/A')AS NomineeAddress,isnull(a.LoanId, 'N/A')AS LoanId, CASE WHEN a.LoanCycle IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanCycle)) END AS LoanCycle, isnull(a.GLoanTypeName, 'N/A')AS GLoanTypeName, isnull(a.GLoanTypeNo, 'N/A')AS GLoanTypeNo, CASE WHEN a.LoanTerm IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanTerm)) END + '-' + isnull (a.LoanTermMode, 'N/A')AS LoanTerm, CASE WHEN a.LoanAmount IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanAmount)) END AS LoanAmount, CASE WHEN a.TotalInterest IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.TotalInterest)) END AS TotalInterest, CASE WHEN a.EMIAmount IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.EMIAmount)) END AS EMIAmount, isnull(a.LoanPurpose, 'N/A')AS LoanPurpose, isnull(a.LoanFunder, 'N/A')AS LoanFunder, CASE WHEN a.DisburseDate IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.DisburseDate, 106)) END AS DisburseDate, CASE WHEN a.ExpiryDate IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.ExpiryDate, 106)) END AS ExpiryDate, (SELECT  SUM(Total) from GroupLoanLedger WHERE LoanId = a.LoanId)AS TotalEMI,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue,'~/','') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+a.MemberId+'/'+a.LoanId+'LoanQR'+a.MemberId+'.png' AS MemberLoanQRCodePhoto, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+a.MemberId + '/' +MemberNomineeJointPhoto AS MemberNomineeJointPhoto, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyURL') + (SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting  WITH(nolock) WHERE ReportName = 'GroupMemberKYCFolder')+'/' + b.MemberNomineeJointPhoto AS MemberNomineeJointPhoto,(SELECT CompanyName FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyName')AS CompanyName, (SELECT ReportValue AS CompanyDetail1 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail1')AS CompanyDetail1, (SELECT ReportValue AS CompanyDetail2 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail2' WITH(nolock) WHERE 1 = 1)AS CompanyDetail2,(SELECT ReportValue AS CompanyDetail3 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail3')AS CompanyDetail3,(SELECT ReportValue AS CompanyImageURL FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyImageURL')AS CompanyImageURL, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' WHERE 1 = 1)AS CompanyURL,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' WHERE 1 = 1)AS GroupMemberKYCFolder, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyBannerURL') AS CompanyBannerURL FROM GroupLoanAccount a WITH(nolock)LEFT JOIN GroupLoanMemberDetail b WITH(nolock) ON a.MemberId = b.MemberId INNER JOIN GroupCenterMaster c WITH(nolock) ON a.CenterId = c.CenterId   WHERE a.LoanId='GL00001476' ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_k3iwrmm5
StackTrace:    at GroupLoan_PrintGroupLoanCardFrontPotraitHTML.GroupLoanCardFront()
TargetSite: Void GroupLoanCardFront()

Time: 29/10/2025 11:15:39 AM
PageName: DataTableResult
String str:  SELECT isnull(a.BranchName,'N/A')+' ('+isnull(a.BranchId,'')+')'AS BranchName, isnull(a.LoanOfficerName,'N/A')+' ('+isnull(a.LoanOfficerId,'')+')'AS LoanOfficerName,isnull(a.CenterName, 'N/A') + ' (' + isnull(a.CenterId, '') + ')'AS CenterName, isnull(a.GroupName, 'N/A')AS GroupName, isnull(c.MeetingType, 'N/A')AS MeetingType,CASE WHEN c.MeetingType = 'Monthly' THEN convert(CHAR, c.MeetingDate) WHEN c.MeetingType IN('Weekly', 'BiWeekly') THEN c.MeetingDay ELSE '' END AS MeetingDay,isnull(c.MeetingTime, 'N/A')AS MeetingTime, isnull(c.MeetingDetail, 'N/A')AS MeetingDetail, isnull(a.MemberId, 'N/A')AS MemberId, isnull(a.MemberName, 'N/A')AS MemberName,isnull(b.MemberGender, 'N/A')AS MemberGender, CASE WHEN b.MemberDOB IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, b.MemberDOB, 106)) END + ' (' + CASE WHEN b.MemberAge IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, b.MemberAge)) END + ' Year)' AS MemberDOBAge, isnull(b.GuardianSalutation, '') + ' ' + isnull(b.MemberGuardianName, 'N/A')AS MemberGuardianName, isnull(b.MemberMobileNo, 'N/A')AS MemberMobileNo, isnull(b.NomineeMobileNo, 'N/A')AS NomineeMobileNo, isnull(b.MemberAddress, 'N/A')AS MemberAddress,isnull(b.MemberOccupation, 'N/A')AS MemberOccupation, isnull(Convert(CHAR, b.MemberAnnualIncome), 'N/A')AS MemberAnnualIncome, isnull(a.NomineeName, 'N/A')AS NomineeName, CASE WHEN a.NomineeDOB IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.NomineeDOB, 106)) END + ' (' + CASE WHEN a.NomineeAge IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.NomineeAge)) END + ')' AS NomineeDOBAge, isnull(a.NomineeRelation, 'N/A')AS NomineeRelation, isnull(a.NomineeAddress, 'N/A')AS NomineeAddress,isnull(a.LoanId, 'N/A')AS LoanId, CASE WHEN a.LoanCycle IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanCycle)) END AS LoanCycle, isnull(a.GLoanTypeName, 'N/A')AS GLoanTypeName, isnull(a.GLoanTypeNo, 'N/A')AS GLoanTypeNo, CASE WHEN a.LoanTerm IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanTerm)) END + '-' + isnull (a.LoanTermMode, 'N/A')AS LoanTerm, CASE WHEN a.LoanAmount IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanAmount)) END AS LoanAmount, CASE WHEN a.TotalInterest IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.TotalInterest)) END AS TotalInterest, CASE WHEN a.EMIAmount IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.EMIAmount)) END AS EMIAmount, isnull(a.LoanPurpose, 'N/A')AS LoanPurpose, isnull(a.LoanFunder, 'N/A')AS LoanFunder, CASE WHEN a.DisburseDate IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.DisburseDate, 106)) END AS DisburseDate, CASE WHEN a.ExpiryDate IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.ExpiryDate, 106)) END AS ExpiryDate, (SELECT  SUM(Total) from GroupLoanLedger WHERE LoanId = a.LoanId)AS TotalEMI,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue,'~/','') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+a.MemberId+'/'+a.LoanId+'LoanQR'+a.MemberId+'.png' AS MemberLoanQRCodePhoto, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+a.MemberId + '/' +MemberNomineeJointPhoto AS MemberNomineeJointPhoto, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyURL') + (SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting  WITH(nolock) WHERE ReportName = 'GroupMemberKYCFolder')+'/' + b.MemberNomineeJointPhoto AS MemberNomineeJointPhoto,(SELECT CompanyName FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyName')AS CompanyName, (SELECT ReportValue AS CompanyDetail1 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail1')AS CompanyDetail1, (SELECT ReportValue AS CompanyDetail2 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail2' WITH(nolock) WHERE 1 = 1)AS CompanyDetail2,(SELECT ReportValue AS CompanyDetail3 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail3')AS CompanyDetail3,(SELECT ReportValue AS CompanyImageURL FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyImageURL')AS CompanyImageURL, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' WHERE 1 = 1)AS CompanyURL,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' WHERE 1 = 1)AS GroupMemberKYCFolder, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyBannerURL') AS CompanyBannerURL FROM GroupLoanAccount a WITH(nolock)LEFT JOIN GroupLoanMemberDetail b WITH(nolock) ON a.MemberId = b.MemberId INNER JOIN GroupCenterMaster c WITH(nolock) ON a.CenterId = c.CenterId   WHERE a.LoanId='GL00001476' ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Incorrect syntax near the keyword 'WITH'.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'WHERE'.
Incorrect syntax near the keyword 'WHERE'.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 29/10/2025 11:15:39 AM
PageName: GroupLoan_PrintGroupLoanCardFrontPotraitHTML
String str:  SELECT isnull(a.BranchName,'N/A')+' ('+isnull(a.BranchId,'')+')'AS BranchName, isnull(a.LoanOfficerName,'N/A')+' ('+isnull(a.LoanOfficerId,'')+')'AS LoanOfficerName,isnull(a.CenterName, 'N/A') + ' (' + isnull(a.CenterId, '') + ')'AS CenterName, isnull(a.GroupName, 'N/A')AS GroupName, isnull(c.MeetingType, 'N/A')AS MeetingType,CASE WHEN c.MeetingType = 'Monthly' THEN convert(CHAR, c.MeetingDate) WHEN c.MeetingType IN('Weekly', 'BiWeekly') THEN c.MeetingDay ELSE '' END AS MeetingDay,isnull(c.MeetingTime, 'N/A')AS MeetingTime, isnull(c.MeetingDetail, 'N/A')AS MeetingDetail, isnull(a.MemberId, 'N/A')AS MemberId, isnull(a.MemberName, 'N/A')AS MemberName,isnull(b.MemberGender, 'N/A')AS MemberGender, CASE WHEN b.MemberDOB IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, b.MemberDOB, 106)) END + ' (' + CASE WHEN b.MemberAge IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, b.MemberAge)) END + ' Year)' AS MemberDOBAge, isnull(b.GuardianSalutation, '') + ' ' + isnull(b.MemberGuardianName, 'N/A')AS MemberGuardianName, isnull(b.MemberMobileNo, 'N/A')AS MemberMobileNo, isnull(b.NomineeMobileNo, 'N/A')AS NomineeMobileNo, isnull(b.MemberAddress, 'N/A')AS MemberAddress,isnull(b.MemberOccupation, 'N/A')AS MemberOccupation, isnull(Convert(CHAR, b.MemberAnnualIncome), 'N/A')AS MemberAnnualIncome, isnull(a.NomineeName, 'N/A')AS NomineeName, CASE WHEN a.NomineeDOB IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.NomineeDOB, 106)) END + ' (' + CASE WHEN a.NomineeAge IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.NomineeAge)) END + ')' AS NomineeDOBAge, isnull(a.NomineeRelation, 'N/A')AS NomineeRelation, isnull(a.NomineeAddress, 'N/A')AS NomineeAddress,isnull(a.LoanId, 'N/A')AS LoanId, CASE WHEN a.LoanCycle IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanCycle)) END AS LoanCycle, isnull(a.GLoanTypeName, 'N/A')AS GLoanTypeName, isnull(a.GLoanTypeNo, 'N/A')AS GLoanTypeNo, CASE WHEN a.LoanTerm IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanTerm)) END + '-' + isnull (a.LoanTermMode, 'N/A')AS LoanTerm, CASE WHEN a.LoanAmount IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanAmount)) END AS LoanAmount, CASE WHEN a.TotalInterest IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.TotalInterest)) END AS TotalInterest, CASE WHEN a.EMIAmount IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.EMIAmount)) END AS EMIAmount, isnull(a.LoanPurpose, 'N/A')AS LoanPurpose, isnull(a.LoanFunder, 'N/A')AS LoanFunder, CASE WHEN a.DisburseDate IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.DisburseDate, 106)) END AS DisburseDate, CASE WHEN a.ExpiryDate IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.ExpiryDate, 106)) END AS ExpiryDate, (SELECT  SUM(Total) from GroupLoanLedger WHERE LoanId = a.LoanId)AS TotalEMI,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue,'~/','') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+a.MemberId+'/'+a.LoanId+'LoanQR'+a.MemberId+'.png' AS MemberLoanQRCodePhoto, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+a.MemberId + '/' +MemberNomineeJointPhoto AS MemberNomineeJointPhoto, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyURL') + (SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting  WITH(nolock) WHERE ReportName = 'GroupMemberKYCFolder')+'/' + b.MemberNomineeJointPhoto AS MemberNomineeJointPhoto,(SELECT CompanyName FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyName')AS CompanyName, (SELECT ReportValue AS CompanyDetail1 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail1')AS CompanyDetail1, (SELECT ReportValue AS CompanyDetail2 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail2' WITH(nolock) WHERE 1 = 1)AS CompanyDetail2,(SELECT ReportValue AS CompanyDetail3 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail3')AS CompanyDetail3,(SELECT ReportValue AS CompanyImageURL FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyImageURL')AS CompanyImageURL, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' WHERE 1 = 1)AS CompanyURL,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' WHERE 1 = 1)AS GroupMemberKYCFolder, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyBannerURL') AS CompanyBannerURL FROM GroupLoanAccount a WITH(nolock)LEFT JOIN GroupLoanMemberDetail b WITH(nolock) ON a.MemberId = b.MemberId INNER JOIN GroupCenterMaster c WITH(nolock) ON a.CenterId = c.CenterId   WHERE a.LoanId='GL00001476' ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_k3iwrmm5
StackTrace:    at GroupLoan_PrintGroupLoanCardFrontPotraitHTML.GroupLoanCardFront()
TargetSite: Void GroupLoanCardFront()

Time: 29/10/2025 11:15:43 AM
PageName: DataTableResult
String str:  SELECT isnull(a.BranchName,'N/A')+' ('+isnull(a.BranchId,'')+')'AS BranchName, isnull(a.LoanOfficerName,'N/A')+' ('+isnull(a.LoanOfficerId,'')+')'AS LoanOfficerName,isnull(a.CenterName, 'N/A') + ' (' + isnull(a.CenterId, '') + ')'AS CenterName, isnull(a.GroupName, 'N/A')AS GroupName, isnull(c.MeetingType, 'N/A')AS MeetingType,CASE WHEN c.MeetingType = 'Monthly' THEN convert(CHAR, c.MeetingDate) WHEN c.MeetingType IN('Weekly', 'BiWeekly') THEN c.MeetingDay ELSE '' END AS MeetingDay,isnull(c.MeetingTime, 'N/A')AS MeetingTime, isnull(c.MeetingDetail, 'N/A')AS MeetingDetail, isnull(a.MemberId, 'N/A')AS MemberId, isnull(a.MemberName, 'N/A')AS MemberName,isnull(b.MemberGender, 'N/A')AS MemberGender, CASE WHEN b.MemberDOB IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, b.MemberDOB, 106)) END + ' (' + CASE WHEN b.MemberAge IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, b.MemberAge)) END + ' Year)' AS MemberDOBAge, isnull(b.GuardianSalutation, '') + ' ' + isnull(b.MemberGuardianName, 'N/A')AS MemberGuardianName, isnull(b.MemberMobileNo, 'N/A')AS MemberMobileNo, isnull(b.NomineeMobileNo, 'N/A')AS NomineeMobileNo, isnull(b.MemberAddress, 'N/A')AS MemberAddress,isnull(b.MemberOccupation, 'N/A')AS MemberOccupation, isnull(Convert(CHAR, b.MemberAnnualIncome), 'N/A')AS MemberAnnualIncome, isnull(a.NomineeName, 'N/A')AS NomineeName, CASE WHEN a.NomineeDOB IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.NomineeDOB, 106)) END + ' (' + CASE WHEN a.NomineeAge IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.NomineeAge)) END + ')' AS NomineeDOBAge, isnull(a.NomineeRelation, 'N/A')AS NomineeRelation, isnull(a.NomineeAddress, 'N/A')AS NomineeAddress,isnull(a.LoanId, 'N/A')AS LoanId, CASE WHEN a.LoanCycle IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanCycle)) END AS LoanCycle, isnull(a.GLoanTypeName, 'N/A')AS GLoanTypeName, isnull(a.GLoanTypeNo, 'N/A')AS GLoanTypeNo, CASE WHEN a.LoanTerm IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanTerm)) END + '-' + isnull (a.LoanTermMode, 'N/A')AS LoanTerm, CASE WHEN a.LoanAmount IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanAmount)) END AS LoanAmount, CASE WHEN a.TotalInterest IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.TotalInterest)) END AS TotalInterest, CASE WHEN a.EMIAmount IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.EMIAmount)) END AS EMIAmount, isnull(a.LoanPurpose, 'N/A')AS LoanPurpose, isnull(a.LoanFunder, 'N/A')AS LoanFunder, CASE WHEN a.DisburseDate IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.DisburseDate, 106)) END AS DisburseDate, CASE WHEN a.ExpiryDate IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.ExpiryDate, 106)) END AS ExpiryDate, (SELECT  SUM(Total) from GroupLoanLedger WHERE LoanId = a.LoanId)AS TotalEMI,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue,'~/','') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+a.MemberId+'/'+a.LoanId+'LoanQR'+a.MemberId+'.png' AS MemberLoanQRCodePhoto, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+a.MemberId + '/' +MemberNomineeJointPhoto AS MemberNomineeJointPhoto, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyURL') + (SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting  WITH(nolock) WHERE ReportName = 'GroupMemberKYCFolder')+'/' + b.MemberNomineeJointPhoto AS MemberNomineeJointPhoto,(SELECT CompanyName FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyName')AS CompanyName, (SELECT ReportValue AS CompanyDetail1 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail1')AS CompanyDetail1, (SELECT ReportValue AS CompanyDetail2 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail2' WITH(nolock) WHERE 1 = 1)AS CompanyDetail2,(SELECT ReportValue AS CompanyDetail3 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail3')AS CompanyDetail3,(SELECT ReportValue AS CompanyImageURL FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyImageURL')AS CompanyImageURL, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' WHERE 1 = 1)AS CompanyURL,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' WHERE 1 = 1)AS GroupMemberKYCFolder, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyBannerURL') AS CompanyBannerURL FROM GroupLoanAccount a WITH(nolock)LEFT JOIN GroupLoanMemberDetail b WITH(nolock) ON a.MemberId = b.MemberId INNER JOIN GroupCenterMaster c WITH(nolock) ON a.CenterId = c.CenterId   WHERE a.LoanId='GL00001476' ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Incorrect syntax near the keyword 'WITH'.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'WHERE'.
Incorrect syntax near the keyword 'WHERE'.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 29/10/2025 11:15:43 AM
PageName: GroupLoan_PrintGroupLoanCardFrontPotraitHTML
String str:  SELECT isnull(a.BranchName,'N/A')+' ('+isnull(a.BranchId,'')+')'AS BranchName, isnull(a.LoanOfficerName,'N/A')+' ('+isnull(a.LoanOfficerId,'')+')'AS LoanOfficerName,isnull(a.CenterName, 'N/A') + ' (' + isnull(a.CenterId, '') + ')'AS CenterName, isnull(a.GroupName, 'N/A')AS GroupName, isnull(c.MeetingType, 'N/A')AS MeetingType,CASE WHEN c.MeetingType = 'Monthly' THEN convert(CHAR, c.MeetingDate) WHEN c.MeetingType IN('Weekly', 'BiWeekly') THEN c.MeetingDay ELSE '' END AS MeetingDay,isnull(c.MeetingTime, 'N/A')AS MeetingTime, isnull(c.MeetingDetail, 'N/A')AS MeetingDetail, isnull(a.MemberId, 'N/A')AS MemberId, isnull(a.MemberName, 'N/A')AS MemberName,isnull(b.MemberGender, 'N/A')AS MemberGender, CASE WHEN b.MemberDOB IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, b.MemberDOB, 106)) END + ' (' + CASE WHEN b.MemberAge IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, b.MemberAge)) END + ' Year)' AS MemberDOBAge, isnull(b.GuardianSalutation, '') + ' ' + isnull(b.MemberGuardianName, 'N/A')AS MemberGuardianName, isnull(b.MemberMobileNo, 'N/A')AS MemberMobileNo, isnull(b.NomineeMobileNo, 'N/A')AS NomineeMobileNo, isnull(b.MemberAddress, 'N/A')AS MemberAddress,isnull(b.MemberOccupation, 'N/A')AS MemberOccupation, isnull(Convert(CHAR, b.MemberAnnualIncome), 'N/A')AS MemberAnnualIncome, isnull(a.NomineeName, 'N/A')AS NomineeName, CASE WHEN a.NomineeDOB IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.NomineeDOB, 106)) END + ' (' + CASE WHEN a.NomineeAge IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.NomineeAge)) END + ')' AS NomineeDOBAge, isnull(a.NomineeRelation, 'N/A')AS NomineeRelation, isnull(a.NomineeAddress, 'N/A')AS NomineeAddress,isnull(a.LoanId, 'N/A')AS LoanId, CASE WHEN a.LoanCycle IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanCycle)) END AS LoanCycle, isnull(a.GLoanTypeName, 'N/A')AS GLoanTypeName, isnull(a.GLoanTypeNo, 'N/A')AS GLoanTypeNo, CASE WHEN a.LoanTerm IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanTerm)) END + '-' + isnull (a.LoanTermMode, 'N/A')AS LoanTerm, CASE WHEN a.LoanAmount IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.LoanAmount)) END AS LoanAmount, CASE WHEN a.TotalInterest IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.TotalInterest)) END AS TotalInterest, CASE WHEN a.EMIAmount IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.EMIAmount)) END AS EMIAmount, isnull(a.LoanPurpose, 'N/A')AS LoanPurpose, isnull(a.LoanFunder, 'N/A')AS LoanFunder, CASE WHEN a.DisburseDate IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.DisburseDate, 106)) END AS DisburseDate, CASE WHEN a.ExpiryDate IS NULL THEN 'N/A' ELSE rtrim(Convert(CHAR, a.ExpiryDate, 106)) END AS ExpiryDate, (SELECT  SUM(Total) from GroupLoanLedger WHERE LoanId = a.LoanId)AS TotalEMI,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue,'~/','') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+a.MemberId+'/'+a.LoanId+'LoanQR'+a.MemberId+'.png' AS MemberLoanQRCodePhoto, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+a.MemberId + '/' +MemberNomineeJointPhoto AS MemberNomineeJointPhoto, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyURL') + (SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting  WITH(nolock) WHERE ReportName = 'GroupMemberKYCFolder')+'/' + b.MemberNomineeJointPhoto AS MemberNomineeJointPhoto,(SELECT CompanyName FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyName')AS CompanyName, (SELECT ReportValue AS CompanyDetail1 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail1')AS CompanyDetail1, (SELECT ReportValue AS CompanyDetail2 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail2' WITH(nolock) WHERE 1 = 1)AS CompanyDetail2,(SELECT ReportValue AS CompanyDetail3 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail3')AS CompanyDetail3,(SELECT ReportValue AS CompanyImageURL FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyImageURL')AS CompanyImageURL, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' WHERE 1 = 1)AS CompanyURL,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' WHERE 1 = 1)AS GroupMemberKYCFolder, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyBannerURL') AS CompanyBannerURL FROM GroupLoanAccount a WITH(nolock)LEFT JOIN GroupLoanMemberDetail b WITH(nolock) ON a.MemberId = b.MemberId INNER JOIN GroupCenterMaster c WITH(nolock) ON a.CenterId = c.CenterId   WHERE a.LoanId='GL00001476' ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_k3iwrmm5
StackTrace:    at GroupLoan_PrintGroupLoanCardFrontPotraitHTML.GroupLoanCardFront()
TargetSite: Void GroupLoanCardFront()

Time: 29/10/2025 05:29:50 PM
PageName: ODLoan_GroupLoanRecoveryReportNew
String str:  SELECT a.BranchId, a.BranchName,  a.MemberId,a.MemberName, a.LoanId, (SELECT(sum(Credit) - sum(Debit)) FROM GroupLoanODLedger WHERE LoanId = a.LoanId) AS BalanceAmount,(SELECT convert(char, MAX(TransDate), 103) FROM GroupLoanODLedger WITH(nolock) WHERE LoanId = a.LoanId)AS LastPaidDate,(SELECT convert(char, (TransDate), 103) FROM GroupLoanODLedger WHERE EntryType = 'LoanAmount' AND LoanId = a.LoanId) AS DisburseDate,(SELECT credit FROM  GroupLoanODLedger WHERE EntryType = 'LoanAmount' AND LoanId = a.LoanId) AS LoanAmount,(SELECT sum(Debit) FROM GroupLoanODLedger WHERE EntryType = 'EMIAmount' AND LoanId = a.LoanId) AS PaidTotal FROM GroupLoanODLedger a with(nolock) where 1=1 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: String was not recognized as a valid DateTime.
Source: mscorlib
StackTrace:    at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at System.Convert.ToDateTime(String value)
   at DateConversion.DateHelper.ConvertDate(String s)
   at ODLoan_GroupLoanRecoveryReportNew.btnSearch_Click(Object sender, EventArgs e)
TargetSite: System.DateTime Parse(System.String, System.Globalization.DateTimeFormatInfo, System.Globalization.DateTimeStyles)

Time: 30/10/2025 04:05:40 PM
PageName: DataTableResult
String str: SELECT SrNo, a.BranchId, a.BranchName, a.DepartmentId, a.DepartmentName, a.DesignationId, a.DesignationName, a.EmployeeId, a.EmployeeName, a.EmployeeMobileNo, Convert(CHAR,a.PermotionDate,106)AS PermotionDate, a.PermotionDetails, a.PermotionSalary, Convert(CHAR,a.EntryTime,106)AS EntryTime, a.EntryUser,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyBannerURL')AS CompanyBannerURL, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='ProjectName')AS ProjectName FROM EmployeePromotionLetterDetail a WITH(nolock) where a.EmployeeId = 'EMP00135'
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid column name 'DepartmentId'.
Invalid column name 'DesignationId'.
Invalid column name 'PermotionDetails'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 30/10/2025 04:05:40 PM
PageName: Employee_PrintEmployeePromotionLetterHTML
String str: SELECT SrNo, a.BranchId, a.BranchName, a.DepartmentId, a.DepartmentName, a.DesignationId, a.DesignationName, a.EmployeeId, a.EmployeeName, a.EmployeeMobileNo, Convert(CHAR,a.PermotionDate,106)AS PermotionDate, a.PermotionDetails, a.PermotionSalary, Convert(CHAR,a.EntryTime,106)AS EntryTime, a.EntryUser,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyBannerURL')AS CompanyBannerURL, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='ProjectName')AS ProjectName FROM EmployeePromotionLetterDetail a WITH(nolock) where a.EmployeeId = 'EMP00135'
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_mn0fxcnh
StackTrace:    at Employee_PrintEmployeePromotionLetterHTML.GroupLoanCardFront()
TargetSite: Void GroupLoanCardFront()

Time: 02/11/2025 03:55:20 PM
PageName: IndividualLoan_IndvMemberRegistrationVerification
String str:  SELECT RelationId, RelationName FROM RelationNameMaster WITH(nolock) WHERE RelationStatus='Active' ORDER BY RelationName ; SELECT BankId, BankName FROM BankNameMaster WITH(nolock) WHERE BankStatus='Active' ORDER BY BankName ; SELECT StateId, StateName FROM StateNameMaster WITH(nolock) WHERE StateStatus='Active' ORDER BY StateName ; SELECT ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserName')AS APIUserName, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserStatus')AS APIUserStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='AadharNoVerificationAPI')AS AadharNoVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='PANNoVerificationAPI')AS PANNoVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='VoterIdVerificationAPI')AS VoterIdVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='BankAccountAdvanceVerificationAPI')AS BankAccountAdvanceVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='MemberProfileStatus')AS MemberProfileStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberCGT')AS GroupMemberCGT, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='IndividualMemberCGT')AS IndividualMemberCGT, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberAadharNo')AS GroupMemberAadharNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberAadharVerify')AS GroupMemberAadharVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberPANNo')AS GroupMemberPANNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberPANVerify')AS GroupMemberPANVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberVoterId')AS GroupMemberVoterId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberVoterVerify')AS GroupMemberVoterVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberMobileNo')AS GroupMemberMobileNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberMobileVerify')AS GroupMemberMobileVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberSelfEdit')AS GroupMemberSelfEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberGuardianEdit')AS GroupMemberGuardianEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberLowerAge')AS GroupMemberLowerAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberUpperAge')AS GroupMemberUpperAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeAadharNo')AS GroupNomineeAadharNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeAadharVerify')AS GroupNomineeAadharVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineePANNo')AS GroupNomineePANNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineePANVerify')AS GroupNomineePANVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeVoterId')AS GroupNomineeVoterId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeVoterVerify')AS GroupNomineeVoterVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeMobileNo')AS GroupNomineeMobileNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeMobileVerify')AS GroupNomineeMobileVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeSelfEdit')AS GroupNomineeSelfEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeGuardianEdit')AS GroupNomineeGuardianEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeLowerAge')AS GroupNomineeLowerAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeUpperAge')AS GroupNomineeUpperAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberId')AS GroupMemberId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberRegSMS')AS GroupMemberRegSMS, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanStatus')AS GroupLoanStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='IndividualLoanStatus')AS IndividualLoanStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanBankAccount')AS GroupLoanBankAccount, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')AS GroupMemberKYCFolder ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Column 'BankAccountVerificationAPI' does not belong to table DSResult3.
Source: System.Data
StackTrace:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at IndividualLoan_IndvMemberRegistrationVerification.FillDDLData()
TargetSite: System.Data.DataColumn GetDataColumn(System.String)

Time: 02/11/2025 03:55:21 PM
PageName: IndividualLoan_IndvMemberRegistrationVerification
String str:  SELECT RelationId, RelationName FROM RelationNameMaster WITH(nolock) WHERE RelationStatus='Active' ORDER BY RelationName ; SELECT BankId, BankName FROM BankNameMaster WITH(nolock) WHERE BankStatus='Active' ORDER BY BankName ; SELECT StateId, StateName FROM StateNameMaster WITH(nolock) WHERE StateStatus='Active' ORDER BY StateName ; SELECT ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserName')AS APIUserName, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserStatus')AS APIUserStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='AadharNoVerificationAPI')AS AadharNoVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='PANNoVerificationAPI')AS PANNoVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='VoterIdVerificationAPI')AS VoterIdVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='BankAccountAdvanceVerificationAPI')AS BankAccountAdvanceVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='MemberProfileStatus')AS MemberProfileStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberCGT')AS GroupMemberCGT, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='IndividualMemberCGT')AS IndividualMemberCGT, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberAadharNo')AS GroupMemberAadharNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberAadharVerify')AS GroupMemberAadharVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberPANNo')AS GroupMemberPANNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberPANVerify')AS GroupMemberPANVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberVoterId')AS GroupMemberVoterId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberVoterVerify')AS GroupMemberVoterVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberMobileNo')AS GroupMemberMobileNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberMobileVerify')AS GroupMemberMobileVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberSelfEdit')AS GroupMemberSelfEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberGuardianEdit')AS GroupMemberGuardianEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberLowerAge')AS GroupMemberLowerAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberUpperAge')AS GroupMemberUpperAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeAadharNo')AS GroupNomineeAadharNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeAadharVerify')AS GroupNomineeAadharVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineePANNo')AS GroupNomineePANNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineePANVerify')AS GroupNomineePANVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeVoterId')AS GroupNomineeVoterId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeVoterVerify')AS GroupNomineeVoterVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeMobileNo')AS GroupNomineeMobileNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeMobileVerify')AS GroupNomineeMobileVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeSelfEdit')AS GroupNomineeSelfEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeGuardianEdit')AS GroupNomineeGuardianEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeLowerAge')AS GroupNomineeLowerAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeUpperAge')AS GroupNomineeUpperAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberId')AS GroupMemberId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberRegSMS')AS GroupMemberRegSMS, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanStatus')AS GroupLoanStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='IndividualLoanStatus')AS IndividualLoanStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanBankAccount')AS GroupLoanBankAccount, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')AS GroupMemberKYCFolder ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Column 'BankAccountVerificationAPI' does not belong to table DSResult3.
Source: System.Data
StackTrace:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at IndividualLoan_IndvMemberRegistrationVerification.FillDDLData()
TargetSite: System.Data.DataColumn GetDataColumn(System.String)

Time: 02/11/2025 03:55:22 PM
PageName: IndividualLoan_IndvMemberRegistrationVerification
String str:  SELECT RelationId, RelationName FROM RelationNameMaster WITH(nolock) WHERE RelationStatus='Active' ORDER BY RelationName ; SELECT BankId, BankName FROM BankNameMaster WITH(nolock) WHERE BankStatus='Active' ORDER BY BankName ; SELECT StateId, StateName FROM StateNameMaster WITH(nolock) WHERE StateStatus='Active' ORDER BY StateName ; SELECT ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserName')AS APIUserName, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserStatus')AS APIUserStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='AadharNoVerificationAPI')AS AadharNoVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='PANNoVerificationAPI')AS PANNoVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='VoterIdVerificationAPI')AS VoterIdVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='BankAccountAdvanceVerificationAPI')AS BankAccountAdvanceVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='MemberProfileStatus')AS MemberProfileStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberCGT')AS GroupMemberCGT, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='IndividualMemberCGT')AS IndividualMemberCGT, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberAadharNo')AS GroupMemberAadharNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberAadharVerify')AS GroupMemberAadharVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberPANNo')AS GroupMemberPANNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberPANVerify')AS GroupMemberPANVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberVoterId')AS GroupMemberVoterId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberVoterVerify')AS GroupMemberVoterVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberMobileNo')AS GroupMemberMobileNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberMobileVerify')AS GroupMemberMobileVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberSelfEdit')AS GroupMemberSelfEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberGuardianEdit')AS GroupMemberGuardianEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberLowerAge')AS GroupMemberLowerAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberUpperAge')AS GroupMemberUpperAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeAadharNo')AS GroupNomineeAadharNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeAadharVerify')AS GroupNomineeAadharVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineePANNo')AS GroupNomineePANNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineePANVerify')AS GroupNomineePANVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeVoterId')AS GroupNomineeVoterId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeVoterVerify')AS GroupNomineeVoterVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeMobileNo')AS GroupNomineeMobileNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeMobileVerify')AS GroupNomineeMobileVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeSelfEdit')AS GroupNomineeSelfEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeGuardianEdit')AS GroupNomineeGuardianEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeLowerAge')AS GroupNomineeLowerAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeUpperAge')AS GroupNomineeUpperAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberId')AS GroupMemberId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberRegSMS')AS GroupMemberRegSMS, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanStatus')AS GroupLoanStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='IndividualLoanStatus')AS IndividualLoanStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanBankAccount')AS GroupLoanBankAccount, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')AS GroupMemberKYCFolder ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Column 'BankAccountVerificationAPI' does not belong to table DSResult3.
Source: System.Data
StackTrace:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at IndividualLoan_IndvMemberRegistrationVerification.FillDDLData()
TargetSite: System.Data.DataColumn GetDataColumn(System.String)

Time: 02/11/2025 03:55:44 PM
PageName: IndividualLoan_IndvMemberRegistrationVerification
String str:  SELECT RelationId, RelationName FROM RelationNameMaster WITH(nolock) WHERE RelationStatus='Active' ORDER BY RelationName ; SELECT BankId, BankName FROM BankNameMaster WITH(nolock) WHERE BankStatus='Active' ORDER BY BankName ; SELECT StateId, StateName FROM StateNameMaster WITH(nolock) WHERE StateStatus='Active' ORDER BY StateName ; SELECT ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserName')AS APIUserName, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserStatus')AS APIUserStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='AadharNoVerificationAPI')AS AadharNoVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='PANNoVerificationAPI')AS PANNoVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='VoterIdVerificationAPI')AS VoterIdVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='BankAccountAdvanceVerificationAPI')AS BankAccountAdvanceVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='MemberProfileStatus')AS MemberProfileStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberCGT')AS GroupMemberCGT, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='IndividualMemberCGT')AS IndividualMemberCGT, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberAadharNo')AS GroupMemberAadharNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberAadharVerify')AS GroupMemberAadharVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberPANNo')AS GroupMemberPANNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberPANVerify')AS GroupMemberPANVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberVoterId')AS GroupMemberVoterId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberVoterVerify')AS GroupMemberVoterVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberMobileNo')AS GroupMemberMobileNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberMobileVerify')AS GroupMemberMobileVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberSelfEdit')AS GroupMemberSelfEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberGuardianEdit')AS GroupMemberGuardianEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberLowerAge')AS GroupMemberLowerAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberUpperAge')AS GroupMemberUpperAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeAadharNo')AS GroupNomineeAadharNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeAadharVerify')AS GroupNomineeAadharVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineePANNo')AS GroupNomineePANNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineePANVerify')AS GroupNomineePANVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeVoterId')AS GroupNomineeVoterId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeVoterVerify')AS GroupNomineeVoterVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeMobileNo')AS GroupNomineeMobileNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeMobileVerify')AS GroupNomineeMobileVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeSelfEdit')AS GroupNomineeSelfEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeGuardianEdit')AS GroupNomineeGuardianEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeLowerAge')AS GroupNomineeLowerAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeUpperAge')AS GroupNomineeUpperAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberId')AS GroupMemberId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberRegSMS')AS GroupMemberRegSMS, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanStatus')AS GroupLoanStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='IndividualLoanStatus')AS IndividualLoanStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanBankAccount')AS GroupLoanBankAccount, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')AS GroupMemberKYCFolder ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Column 'BankAccountVerificationAPI' does not belong to table DSResult3.
Source: System.Data
StackTrace:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at IndividualLoan_IndvMemberRegistrationVerification.FillDDLData()
TargetSite: System.Data.DataColumn GetDataColumn(System.String)

Time: 02/11/2025 03:56:06 PM
PageName: IndividualLoan_IndvMemberRegistrationVerification
String str:  SELECT RelationId, RelationName FROM RelationNameMaster WITH(nolock) WHERE RelationStatus='Active' ORDER BY RelationName ; SELECT BankId, BankName FROM BankNameMaster WITH(nolock) WHERE BankStatus='Active' ORDER BY BankName ; SELECT StateId, StateName FROM StateNameMaster WITH(nolock) WHERE StateStatus='Active' ORDER BY StateName ; SELECT ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserName')AS APIUserName, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserStatus')AS APIUserStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='AadharNoVerificationAPI')AS AadharNoVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='PANNoVerificationAPI')AS PANNoVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='VoterIdVerificationAPI')AS VoterIdVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='BankAccountAdvanceVerificationAPI')AS BankAccountAdvanceVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='MemberProfileStatus')AS MemberProfileStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberCGT')AS GroupMemberCGT, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='IndividualMemberCGT')AS IndividualMemberCGT, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberAadharNo')AS GroupMemberAadharNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberAadharVerify')AS GroupMemberAadharVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberPANNo')AS GroupMemberPANNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberPANVerify')AS GroupMemberPANVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberVoterId')AS GroupMemberVoterId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberVoterVerify')AS GroupMemberVoterVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberMobileNo')AS GroupMemberMobileNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberMobileVerify')AS GroupMemberMobileVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberSelfEdit')AS GroupMemberSelfEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberGuardianEdit')AS GroupMemberGuardianEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberLowerAge')AS GroupMemberLowerAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberUpperAge')AS GroupMemberUpperAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeAadharNo')AS GroupNomineeAadharNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeAadharVerify')AS GroupNomineeAadharVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineePANNo')AS GroupNomineePANNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineePANVerify')AS GroupNomineePANVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeVoterId')AS GroupNomineeVoterId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeVoterVerify')AS GroupNomineeVoterVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeMobileNo')AS GroupNomineeMobileNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeMobileVerify')AS GroupNomineeMobileVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeSelfEdit')AS GroupNomineeSelfEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeGuardianEdit')AS GroupNomineeGuardianEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeLowerAge')AS GroupNomineeLowerAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeUpperAge')AS GroupNomineeUpperAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberId')AS GroupMemberId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberRegSMS')AS GroupMemberRegSMS, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanStatus')AS GroupLoanStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='IndividualLoanStatus')AS IndividualLoanStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanBankAccount')AS GroupLoanBankAccount, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')AS GroupMemberKYCFolder ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Column 'BankAccountVerificationAPI' does not belong to table DSResult3.
Source: System.Data
StackTrace:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at IndividualLoan_IndvMemberRegistrationVerification.FillDDLData()
TargetSite: System.Data.DataColumn GetDataColumn(System.String)

Time: 02/11/2025 04:35:15 PM
PageName: IndividualLoan_IndvMemberRegistrationVerification
String str:  SELECT RelationId, RelationName FROM RelationNameMaster WITH(nolock) WHERE RelationStatus='Active' ORDER BY RelationName ; SELECT BankId, BankName FROM BankNameMaster WITH(nolock) WHERE BankStatus='Active' ORDER BY BankName ; SELECT StateId, StateName FROM StateNameMaster WITH(nolock) WHERE StateStatus='Active' ORDER BY StateName ; SELECT ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserName')AS APIUserName, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserStatus')AS APIUserStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='AadharNoVerificationAPI')AS AadharNoVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='PANNoVerificationAPI')AS PANNoVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='VoterIdVerificationAPI')AS VoterIdVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='BankAccountAdvanceVerificationAPI')AS BankAccountAdvanceVerificationAPI, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='MemberProfileStatus')AS MemberProfileStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberCGT')AS GroupMemberCGT, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='IndividualMemberCGT')AS IndividualMemberCGT, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberAadharNo')AS GroupMemberAadharNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberAadharVerify')AS GroupMemberAadharVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberPANNo')AS GroupMemberPANNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberPANVerify')AS GroupMemberPANVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberVoterId')AS GroupMemberVoterId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberVoterVerify')AS GroupMemberVoterVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberMobileNo')AS GroupMemberMobileNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberMobileVerify')AS GroupMemberMobileVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberSelfEdit')AS GroupMemberSelfEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberGuardianEdit')AS GroupMemberGuardianEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberLowerAge')AS GroupMemberLowerAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberUpperAge')AS GroupMemberUpperAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeAadharNo')AS GroupNomineeAadharNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeAadharVerify')AS GroupNomineeAadharVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineePANNo')AS GroupNomineePANNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineePANVerify')AS GroupNomineePANVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeVoterId')AS GroupNomineeVoterId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeVoterVerify')AS GroupNomineeVoterVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeMobileNo')AS GroupNomineeMobileNo, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeMobileVerify')AS GroupNomineeMobileVerify, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeSelfEdit')AS GroupNomineeSelfEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeGuardianEdit')AS GroupNomineeGuardianEdit, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeLowerAge')AS GroupNomineeLowerAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupNomineeUpperAge')AS GroupNomineeUpperAge, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberId')AS GroupMemberId, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupMemberRegSMS')AS GroupMemberRegSMS, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanStatus')AS GroupLoanStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='IndividualLoanStatus')AS IndividualLoanStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanBankAccount')AS GroupLoanBankAccount, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')AS GroupMemberKYCFolder ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Column 'BankAccountVerificationAPI' does not belong to table DSResult3.
Source: System.Data
StackTrace:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at IndividualLoan_IndvMemberRegistrationVerification.FillDDLData()
TargetSite: System.Data.DataColumn GetDataColumn(System.String)

Time: 02/11/2025 05:43:13 PM
PageName: GroupLoan_GroupDueDisbursementSheet
String str:  SELECT tt.BranchName, tt.LoanOfficerId, tt.LoanOfficerName, tt.MeetingDay, tt.MeetingTime, tt.CenterId, tt.CenterName, tt.MemberId, tt.MemberName, tt.NomineeName, tt.MobileNo, tt.SanctionId, tt.LoanCycle, tt.LoanPurpose, tt.BankIFSCCode, tt.BankAccountNo, tt.BankAccountName AS BankVerifiedName, tt.GLoanTypeNo, tt.SettlementAmount, tt.ApprovalAmount, tt.TotalFee, isnull(tt.ApprovalAmount,0)-isnull(tt.SettlementAmount,0)-isnull(tt.TotalFee,0)AS TransferAmount, dbo.FunNumberOfCharacterFromNumber((isnull(tt.ApprovalAmount,0)-isnull(tt.SettlementAmount,0)-isnull(tt.TotalFee,0))/2000)AS TransferAmountStr, convert(char,tt.ApplicationDate,106)AS ApplicationDate, convert(char,tt.ApprovalDate,106)AS ApprovalDate, convert(char,tt.ExpectedDisburseDate,106)AS ExpectedDisburseDate, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupDueDisbursementSheetHTML')AS HTMLReportPageName FROM ( SELECT a.BranchName, a.LoanOfficerId, a.LoanOfficerName, b.MeetingDay, b.MeetingTime, a.CenterId, a.CenterName, a.MemberId, a.MemberName, a.NomineeName, a.MobileNo, a.SanctionId, a.LoanCycle, a.LoanPurpose, a.BankIFSCCode, a.BankAccountNo, a.BankAccountName, a.GLoanTypeNo, (SELECT SUM(isnull(x.Total,0)) FROM GroupLoanLedger x WITH(nolock) INNER JOIN GroupLoanAccount y WITH(nolock) ON x.LoanId=y.LoanId WHERE y.DisburseDate<a.ApprovalDate AND y.MemberId=a.MemberId AND x.PStatus='Due')AS SettlementAmount, a.ApprovalAmount, a.TotalFee, a.ApplicationDate, a.ApprovalDate, a.ExpectedDisburseDate FROM GroupLoanAccount a WITH(nolock) INNER JOIN GroupCenterMaster b WITH(nolock) ON a.CenterId=b.CenterId WHERE  a.LoanStatus='LoanApproved'  AND a.BranchId IN ('100','102','101','104','103')  AND isnull(a.GroupName,'GroupLoan')!='Individual'  )tt WHERE 1=1  ORDER BY tt.BranchName, tt.LoanOfficerName, tt.CenterName, tt.MemberName 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDecimal(String value)
   at GroupLoan_GroupDueDisbursementSheet.grdData_RowDataBound(Object sender, GridViewRowEventArgs e)
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 02/11/2025 06:09:09 PM
PageName: GroupLoan_PrintRDLCPage
String str:  SELECT tt.BranchName AS C0, tt.LoanOfficerId AS C1, tt.LoanOfficerName AS C2, tt.MeetingDay AS C3, tt.MeetingTime AS C4, tt.CenterId AS C5, tt.CenterName AS C6, tt.MemberId AS C7, tt.MemberName AS C8, tt.NomineeName AS C9, tt.LoanCycle AS C10, tt.LoanPurpose AS C11, tt.BankIFSCCode AS C12, tt.BankAccountNo AS C13, tt.GLoanTypeNo AS C14, tt.SettlementAMount AS C15, tt.ApprovalAmount AS C16, tt.TotalFee AS C17, isnull(tt.ApprovalAmount,0)-isnull(tt.SettlementAmount,0)-isnull(tt.TotalFee,0)AS C18, (SELECT ReportValue AS CompanyName FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyName')AS C99, (SELECT ReportValue AS CompanyDetail1 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail1')AS C98, (SELECT ReportValue AS CompanyDetail2 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail2')AS C97, (SELECT ReportValue AS CompanyDetail3 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail3')AS C96, (SELECT  ReportValue AS GroupDueDisbursementSheetRDLC FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupDueDisbursementSheetRDLC')AS C95 FROM (  SELECT a.BranchName, a.LoanOfficerId, a.LoanOfficerName, b.MeetingDay, b.MeetingTime, a.CenterId, a.CenterName, a.MemberId, a.MemberName, a.NomineeName, a.LoanCycle, a.LoanPurpose, a.BankIFSCCode, a.BankAccountNo, a.GLoanTypeNo, (SELECT SUM(Total) FROM GroupLoanLedger WITH(nolock) WHERE MemberId=a.MemberId AND PStatus='Due')AS SettlementAmount, a.ApprovalAmount, a.TotalFee FROM GroupLoanAccount a WITH(nolock) INNER JOIN GroupCenterMaster b WITH(nolock) ON a.CenterId=b.CenterId WHERE a.LoanStatus='LoanApproved'  )tt WHERE 1=1  ORDER BY tt.BranchName, tt.LoanOfficerName, tt.CenterName, tt.MemberName 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: System.ApplicationException: The report definition for report 'C:\Inetpub\vhosts\valourinfotech.in\grouploan.valourinfotech.in\GroupLoan_PrintDueDisbursementSheetRDLC.rdlc' has not been specified ---> System.IO.FileNotFoundException: Could not find file 'C:\Inetpub\vhosts\valourinfotech.in\grouploan.valourinfotech.in\GroupLoan_PrintDueDisbursementSheetRDLC.rdlc'.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
   at Microsoft.Reporting.StandalonePreviewStore.GetReportDefinition(String path, Boolean isFile)
   at Microsoft.Reporting.StandalonePreviewStore.GetCompiledReport(CatalogItemContext context, Boolean rebuild, ReportSnapshotBase& snapshot)
   --- End of inner exception stack trace ---
   at Microsoft.Reporting.StandalonePreviewStore.GetCompiledReport(CatalogItemContext context, Boolean rebuild, ReportSnapshotBase& snapshot)
   at Microsoft.Reporting.LocalService.GetCompiledReport(CatalogItemContext itemContext, Boolean rebuild, ReportSnapshotBase& snapshot)
   at Microsoft.Reporting.WebForms.LocalReport.CompileReport()
Message: An error occurred during local report processing.
Source: Microsoft.ReportViewer.WebForms
StackTrace:    at Microsoft.Reporting.WebForms.LocalReport.CompileReport()
   at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, CreateAndRegisterStream createStreamCallback, Warning[]& warnings)
   at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings)
   at GroupLoan_PrintRDLCPage.GroupDueDisbursementSheet()
TargetSite: Void CompileReport()

Time: 02/11/2025 06:09:13 PM
PageName: GroupLoan_PrintGroupDueDisbursementSheetHTML
String str:  SELECT tt.BranchName, tt.LoanOfficerId, tt.LoanOfficerName, tt.MeetingDay, tt.MeetingTime, tt.CenterId, tt.CenterName, tt.MemberId, tt.MemberName, tt.NomineeName, tt.MobileNo, tt.LoanCycle, tt.LoanPurpose, tt.BankIFSCCode, tt.BankAccountNo, tt.BankAccountName AS BankVerifiedName, tt.GLoanTypeNo, tt.SettlementAmount, tt.ApprovalAmount, tt.TotalFee, isnull(tt.ApprovalAmount,0)-isnull(tt.SettlementAmount,0)-isnull(tt.TotalFee,0)AS NetPayable, (SELECT ReportValue AS CompanyName FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyName')AS CompanyName, (SELECT ReportValue AS CompanyDetail1 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail1')AS CompanyDetail1, (SELECT ReportValue AS CompanyDetail2 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail2')AS CompanyDetail2, (SELECT ReportValue AS CompanyDetail3 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail3')AS CompanyDetail3 FROM (  SELECT a.BranchName, a.LoanOfficerId, a.LoanOfficerName, b.MeetingDay, b.MeetingTime, a.CenterId, a.CenterName, a.MemberId, a.MemberName, a.NomineeName, a.MobileNo, a.LoanCycle, a.LoanPurpose, a.BankIFSCCode, a.BankAccountNo, a.BankAccountName, a.GLoanTypeNo, (SELECT SUM(isnull(x.Total,0)) FROM GroupLoanLedger x WITH(nolock) INNER JOIN GroupLoanAccount y WITH(nolock) ON x.LoanId=y.LoanId WHERE y.DisburseDate<a.ApprovalDate AND y.MemberId=a.MemberId AND x.PStatus='Due')AS SettlementAmount, a.ApprovalAmount, a.TotalFee FROM GroupLoanAccount a WITH(nolock) INNER JOIN GroupCenterMaster b WITH(nolock) ON a.CenterId=b.CenterId WHERE a.LoanStatus='LoanApproved'  )tt WHERE 1=1  ORDER BY tt.BranchName, tt.LoanOfficerName, tt.CenterName, tt.MemberName 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDecimal(String value)
   at GroupLoan_PrintGroupDueDisbursementSheetHTML.GroupDueDisbursementSheet()
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 02/11/2025 06:09:41 PM
PageName: GroupLoan_PrintRDLCPage
String str:  SELECT tt.BranchName AS C0, tt.LoanOfficerId AS C1, tt.LoanOfficerName AS C2, tt.MeetingDay AS C3, tt.MeetingTime AS C4, tt.CenterId AS C5, tt.CenterName AS C6, tt.MemberId AS C7, tt.MemberName AS C8, tt.NomineeName AS C9, tt.LoanCycle AS C10, tt.LoanPurpose AS C11, tt.BankIFSCCode AS C12, tt.BankAccountNo AS C13, tt.GLoanTypeNo AS C14, tt.SettlementAMount AS C15, tt.ApprovalAmount AS C16, tt.TotalFee AS C17, isnull(tt.ApprovalAmount,0)-isnull(tt.SettlementAmount,0)-isnull(tt.TotalFee,0)AS C18, (SELECT ReportValue AS CompanyName FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyName')AS C99, (SELECT ReportValue AS CompanyDetail1 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail1')AS C98, (SELECT ReportValue AS CompanyDetail2 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail2')AS C97, (SELECT ReportValue AS CompanyDetail3 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail3')AS C96, (SELECT  ReportValue AS GroupDueDisbursementSheetRDLC FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupDueDisbursementSheetRDLC')AS C95 FROM (  SELECT a.BranchName, a.LoanOfficerId, a.LoanOfficerName, b.MeetingDay, b.MeetingTime, a.CenterId, a.CenterName, a.MemberId, a.MemberName, a.NomineeName, a.LoanCycle, a.LoanPurpose, a.BankIFSCCode, a.BankAccountNo, a.GLoanTypeNo, (SELECT SUM(Total) FROM GroupLoanLedger WITH(nolock) WHERE MemberId=a.MemberId AND PStatus='Due')AS SettlementAmount, a.ApprovalAmount, a.TotalFee FROM GroupLoanAccount a WITH(nolock) INNER JOIN GroupCenterMaster b WITH(nolock) ON a.CenterId=b.CenterId WHERE a.LoanStatus='LoanApproved'  AND a.ApplicationDate<'11/3/2025 12:00:00 AM'  )tt WHERE 1=1  ORDER BY tt.BranchName, tt.LoanOfficerName, tt.CenterName, tt.MemberName 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: System.ApplicationException: The report definition for report 'C:\Inetpub\vhosts\valourinfotech.in\grouploan.valourinfotech.in\GroupLoan_PrintDueDisbursementSheetRDLC.rdlc' has not been specified ---> System.IO.FileNotFoundException: Could not find file 'C:\Inetpub\vhosts\valourinfotech.in\grouploan.valourinfotech.in\GroupLoan_PrintDueDisbursementSheetRDLC.rdlc'.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
   at Microsoft.Reporting.StandalonePreviewStore.GetReportDefinition(String path, Boolean isFile)
   at Microsoft.Reporting.StandalonePreviewStore.GetCompiledReport(CatalogItemContext context, Boolean rebuild, ReportSnapshotBase& snapshot)
   --- End of inner exception stack trace ---
   at Microsoft.Reporting.StandalonePreviewStore.GetCompiledReport(CatalogItemContext context, Boolean rebuild, ReportSnapshotBase& snapshot)
   at Microsoft.Reporting.LocalService.GetCompiledReport(CatalogItemContext itemContext, Boolean rebuild, ReportSnapshotBase& snapshot)
   at Microsoft.Reporting.WebForms.LocalReport.CompileReport()
Message: An error occurred during local report processing.
Source: Microsoft.ReportViewer.WebForms
StackTrace:    at Microsoft.Reporting.WebForms.LocalReport.CompileReport()
   at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, CreateAndRegisterStream createStreamCallback, Warning[]& warnings)
   at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings)
   at GroupLoan_PrintRDLCPage.GroupDueDisbursementSheet()
TargetSite: Void CompileReport()

Time: 02/11/2025 06:09:44 PM
PageName: GroupLoan_PrintGroupDueDisbursementSheetHTML
String str:  SELECT tt.BranchName, tt.LoanOfficerId, tt.LoanOfficerName, tt.MeetingDay, tt.MeetingTime, tt.CenterId, tt.CenterName, tt.MemberId, tt.MemberName, tt.NomineeName, tt.MobileNo, tt.LoanCycle, tt.LoanPurpose, tt.BankIFSCCode, tt.BankAccountNo, tt.BankAccountName AS BankVerifiedName, tt.GLoanTypeNo, tt.SettlementAmount, tt.ApprovalAmount, tt.TotalFee, isnull(tt.ApprovalAmount,0)-isnull(tt.SettlementAmount,0)-isnull(tt.TotalFee,0)AS NetPayable, (SELECT ReportValue AS CompanyName FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyName')AS CompanyName, (SELECT ReportValue AS CompanyDetail1 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail1')AS CompanyDetail1, (SELECT ReportValue AS CompanyDetail2 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail2')AS CompanyDetail2, (SELECT ReportValue AS CompanyDetail3 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail3')AS CompanyDetail3 FROM (  SELECT a.BranchName, a.LoanOfficerId, a.LoanOfficerName, b.MeetingDay, b.MeetingTime, a.CenterId, a.CenterName, a.MemberId, a.MemberName, a.NomineeName, a.MobileNo, a.LoanCycle, a.LoanPurpose, a.BankIFSCCode, a.BankAccountNo, a.BankAccountName, a.GLoanTypeNo, (SELECT SUM(isnull(x.Total,0)) FROM GroupLoanLedger x WITH(nolock) INNER JOIN GroupLoanAccount y WITH(nolock) ON x.LoanId=y.LoanId WHERE y.DisburseDate<a.ApprovalDate AND y.MemberId=a.MemberId AND x.PStatus='Due')AS SettlementAmount, a.ApprovalAmount, a.TotalFee FROM GroupLoanAccount a WITH(nolock) INNER JOIN GroupCenterMaster b WITH(nolock) ON a.CenterId=b.CenterId WHERE a.LoanStatus='LoanApproved'  AND a.ApplicationDate<'11/3/2025 12:00:00 AM'  )tt WHERE 1=1  ORDER BY tt.BranchName, tt.LoanOfficerName, tt.CenterName, tt.MemberName 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDecimal(String value)
   at GroupLoan_PrintGroupDueDisbursementSheetHTML.GroupDueDisbursementSheet()
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 02/11/2025 06:18:42 PM
PageName: GroupLoan_PrintGroupDueDisbursementSheetHTML
String str:  SELECT tt.BranchName, tt.LoanOfficerId, tt.LoanOfficerName, tt.MeetingDay, tt.MeetingTime, tt.CenterId, tt.CenterName, tt.MemberId, tt.MemberName, tt.NomineeName, tt.MobileNo, tt.LoanCycle, tt.LoanPurpose, tt.BankIFSCCode, tt.BankAccountNo, tt.BankAccountName AS BankVerifiedName, tt.GLoanTypeNo, tt.SettlementAmount, tt.ApprovalAmount, tt.TotalFee, isnull(tt.ApprovalAmount,0)-isnull(tt.SettlementAmount,0)-isnull(tt.TotalFee,0)AS NetPayable, (SELECT ReportValue AS CompanyName FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyName')AS CompanyName, (SELECT ReportValue AS CompanyDetail1 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail1')AS CompanyDetail1, (SELECT ReportValue AS CompanyDetail2 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail2')AS CompanyDetail2, (SELECT ReportValue AS CompanyDetail3 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail3')AS CompanyDetail3 FROM (  SELECT a.BranchName, a.LoanOfficerId, a.LoanOfficerName, b.MeetingDay, b.MeetingTime, a.CenterId, a.CenterName, a.MemberId, a.MemberName, a.NomineeName, a.MobileNo, a.LoanCycle, a.LoanPurpose, a.BankIFSCCode, a.BankAccountNo, a.BankAccountName, a.GLoanTypeNo, (SELECT SUM(isnull(x.Total,0)) FROM GroupLoanLedger x WITH(nolock) INNER JOIN GroupLoanAccount y WITH(nolock) ON x.LoanId=y.LoanId WHERE y.DisburseDate<a.ApprovalDate AND y.MemberId=a.MemberId AND x.PStatus='Due')AS SettlementAmount, a.ApprovalAmount, a.TotalFee FROM GroupLoanAccount a WITH(nolock) INNER JOIN GroupCenterMaster b WITH(nolock) ON a.CenterId=b.CenterId WHERE a.LoanStatus='LoanApproved'  AND a.ApplicationDate<'11/3/2025 12:00:00 AM'  )tt WHERE 1=1  ORDER BY tt.BranchName, tt.LoanOfficerName, tt.CenterName, tt.MemberName 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDecimal(String value)
   at GroupLoan_PrintGroupDueDisbursementSheetHTML.GroupDueDisbursementSheet()
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 02/11/2025 06:26:08 PM
PageName: GroupLoan_PrintGroupDueDisbursementSheetHTML
String str:  SELECT tt.BranchName, tt.LoanOfficerId, tt.LoanOfficerName, tt.MeetingDay, tt.MeetingTime, tt.CenterId, tt.CenterName, tt.MemberId, tt.MemberName, tt.NomineeName, tt.MobileNo, tt.LoanCycle, tt.LoanPurpose, tt.BankIFSCCode, tt.BankAccountNo, tt.BankAccountName AS BankVerifiedName, tt.GLoanTypeNo, tt.SettlementAmount, tt.ApprovalAmount, tt.TotalFee, isnull(tt.ApprovalAmount,0)-isnull(tt.SettlementAmount,0)-isnull(tt.TotalFee,0)AS NetPayable, (SELECT ReportValue AS CompanyName FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyName')AS CompanyName, (SELECT ReportValue AS CompanyDetail1 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail1')AS CompanyDetail1, (SELECT ReportValue AS CompanyDetail2 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail2')AS CompanyDetail2, (SELECT ReportValue AS CompanyDetail3 FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyDetail3')AS CompanyDetail3 FROM (  SELECT a.BranchName, a.LoanOfficerId, a.LoanOfficerName, b.MeetingDay, b.MeetingTime, a.CenterId, a.CenterName, a.MemberId, a.MemberName, a.NomineeName, a.MobileNo, a.LoanCycle, a.LoanPurpose, a.BankIFSCCode, a.BankAccountNo, a.BankAccountName, a.GLoanTypeNo, (SELECT SUM(isnull(x.Total,0)) FROM GroupLoanLedger x WITH(nolock) INNER JOIN GroupLoanAccount y WITH(nolock) ON x.LoanId=y.LoanId WHERE y.DisburseDate<a.ApprovalDate AND y.MemberId=a.MemberId AND x.PStatus='Due')AS SettlementAmount, a.ApprovalAmount, a.TotalFee FROM GroupLoanAccount a WITH(nolock) INNER JOIN GroupCenterMaster b WITH(nolock) ON a.CenterId=b.CenterId WHERE a.LoanStatus='LoanApproved'  AND a.ApplicationDate<'11/3/2025 12:00:00 AM'  )tt WHERE 1=1  ORDER BY tt.BranchName, tt.LoanOfficerName, tt.CenterName, tt.MemberName 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDecimal(String value)
   at GroupLoan_PrintGroupDueDisbursementSheetHTML.GroupDueDisbursementSheet()
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 07/11/2025 01:50:47 PM
PageName: DataTableResult
String str:  SELECT isnull(a.BranchId,'N/A')AS BranchId, isnull(a.BranchName,'N/A')AS BranchName, isnull(a.GroupOfficerId,'N/A')AS GroupOfficerId, isnull(a.GroupOfficerName, 'N/A')AS GroupOfficerName, isnull(a.CenterId, 'N/A')AS CenterId, isnull(a.CenterName, 'N/A')AS CenterName,  isnull(a.GroupName, 'N/A')AS GroupName, isnull(a.MemberFormNo, 'N/A')AS MemberFormNo, isnull(a.OtherMemberId, 'N/A')AS OtherMemberId, isnull(a.IdType, 'N/A')AS IdType, isnull(a.MemberId, 'N/A')AS MemberId, isnull(convert(CHAR, a.MemberJoinDate, 106), 'N/A')AS MemberJoinDate, isnull(a.MemberSalutation, 'N/A')AS MemberSalutation, isnull(a.MemberName, 'N/A')AS MemberName, isnull(a.GuardianSalutation, 'N/A')AS GuardianSalutation, isnull(a.MemberGuardianName, 'N/A')AS MemberGuardianName, isnull(a.MemberGender, 'N/A')AS MemberGender, isnull(convert(CHAR, a.MemberDOB, 106), 'N/A')AS MemberDOB, isnull(convert(CHAR, a.MemberAge), 'N/A')AS MemberAge, isnull(a.MemberMobileNo, 'N/A')AS MemberMobileNo, isnull(a.MemberOccupation, 'N/A')AS MemberOccupation, isnull(convert(CHAR, a.MemberAnnualIncome), 'N/A')AS MemberAnnualIncome, isnull(convert(CHAR, a.FamilyAnnualExpence), 'N/A')AS FamilyAnnualExpence, isnull(a.NomineeSalutation, 'N/A')AS NomineeSalutation, isnull(a.NomineeName, 'N/A')AS NomineeName, isnull(a.NomineeGuardianSalutation, 'N/A')AS  NomineeGuardianSalutation, isnull(a.NomineeGuardianName, 'N/A')AS NomineeGuardianName, isnull(a.NomineeGender, 'N/A')AS NomineeGender, isnull(convert(CHAR, a.NomineeDOB, 106), 'N/A')AS NomineeDOB, isnull(convert(CHAR, a.NomineeAge), 'N/A')AS NomineeAge, isnull(convert(CHAR, a.NomineeAnnualIncome), 'N/A') AS NomineeAnnualIncome, isnull(a.NomineeRelation, 'N/A')AS NomineeRelation, isnull(a.NomineeMobileNo, 'N/A')AS NomineeMobileNo, isnull(a.NomineeOccupation, 'N/A')AS NomineeOccupation, isnull(a.NomineeAadharNo, 'N/A')AS NomineeAadharNo,isnull(a.NomineeVoterIdNo, 'N/A')AS NomineeVoterIdNo, isnull(a.NomineePANNo, 'N/A')AS NomineePANNo, isnull(a.NomineeDLNo, 'N/A')AS NomineeDLNo,isnull(a.MemberAadharNo, 'N/A')AS MemberAadharNo, isnull(a.MemberPanNo, 'N/A')AS MemberPanNo, isnull(a.MemberVoterIdNo, 'N/A')AS MemberVoterIdNo,isnull(a.MemberDLNo, 'N/A')AS MemberDLNo, isnull(a.RationCard, 'N/A')AS RationCard, isnull(a.ElectricityBill, 'N/A')AS ElectricityBill,isnull(a.MemberProfileStatus, 'N/A')AS MemberProfileStatus, isnull(a.MemberAddress, 'N/A')AS MemberAddress, isnull(a.MemberLatitude, 'N/A')AS MemberLatitude,isnull(a.MemberLongitude, 'N/A')AS MemberLongitude, isnull(a.EntryUser, 'N/A')AS EntryUser,rtrim(isnull(convert(CHAR, a.EntryTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.EntryTime, 108), 'N/A'))AS EntryTime, isnull(convert(CHAR, b.GroupJoinDate, 106), 'N/A')AS GroupJoinDate, isnull(b.GroupUser, 'N/A')AS GroupUser, rtrim(isnull(convert(CHAR, b.GroupTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, b.GroupTime, 108), 'N/A'))AS GroupTime, isnull(b.GroupStatus, 'N/A') AS GroupStatus, isnull(b.CGTOfficerId, 'N/A')AS CGTOfficerId, isnull(b.CGTOfficerName, 'N/A')AS CGTOfficerName, isnull(convert(CHAR, b.CGTDate, 106), 'N/A')AS CGTDate, isnull(b.CGTUser, 'N/A')AS CGTUser, isnull(convert(CHAR, b.CGTTime), 'N/A')AS CGTTime, isnull(b.GRTOfficerId, 'N/A')AS GRTOfficerId,isnull(b.GRTOfficerName, 'N/A')AS GRTOfficerName, isnull(convert(CHAR, b.GRTDate), 'N/A')AS GRTDate, isnull(b.GRTUser, 'N/A')AS GRTUser, isnull(convert(CHAR, b.GRTTime), 'N/A')AS GRTTime, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')AS CompanyURL,  (SELECT replace(ReportValue, '~/', '')AS ImageFolderLocation FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberAadharImageFolder')AS ImageFolderLocation, (SELECT replace(ReportValue, '~/', '')AS KYCFolderLocation FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')AS KYCFolderLocation, isnull(a.MemberPOIType, 'N/A')AS MemberPOIType,isnull(a.MemberPOINo, 'N/A')AS MemberPOINo, isnull(a.MemberPOAType, 'N/A')AS MemberPOAType, isnull(a.MemberPOANo, 'N/A')AS MemberPOANo,isnull(a.MemberAadharPhoto, 'N/A')AS MemberAadharPhoto, isnull(a.MemberPhoto, 'N/A')AS MemberPhoto, isnull(a.MemberSignature, 'N/A') AS MemberSignature, isnull(a.MemberPOIFront, 'N/A')AS MemberPOIFront, isnull(a.MemberPOIBack, 'N/A')AS MemberPOIBack, isnull(a.MemberPOAFront, 'N/A') AS  MemberPOAFront, isnull(a.MemberPOABack, 'N/A')AS MemberPOABack, isnull(a.MemberBankPassBook, 'N/A')AS MemberBankPassBook, isnull(a.NomineePOIType, 'N/A') AS NomineePOIType, isnull(a.NomineePOINo, 'N/A')AS NomineePOINo, isnull(a.NomineePOAType, 'N/A')AS NomineePOAType, isnull(a.NomineePOANo, 'N/A')AS NomineePOANo,isnull(a.NomineeAadharPhoto, 'N/A')AS NomineeAadharPhoto, isnull(a.NomineePhoto, 'N/A')AS NomineePhoto, isnull(a.NomineeSignature, 'N/A')AS NomineeSignature,isnull(a.NomineePOIFront, 'N/A')AS NomineePOIFront, isnull(a.NomineePOIBack, 'N/A')AS NomineePOIBack, isnull(a.NomineePOAFront, 'N/A')AS NomineePOAFront,isnull(a.NomineePOABack, 'N/A')AS NomineePOABack, isnull(a.MemberNomineeJointPhoto, 'N/A')AS MemberNomineeJointPhoto, isnull(a.KYCStatus, 'N/A')AS KYCStatus,isnull(a.KYCRemark, 'N/A')AS KYCRemark, rtrim(isnull(convert(CHAR, a.KYCTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.KYCTime, 108), 'N/A'))AS KYCTime,isnull(a.KYCUser, 'N/A')AS KYCUser, isnull(convert(CHAR, a.DropOutDate, 106), 'N/A')AS DropOutDate, isnull(a.DropOutRemark, 'N/A')AS DropOutRemark,isnull(a.DropOutUser, 'N/A')AS DropOutUser, rtrim(isnull(convert(CHAR, a.DropOutTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.DropOutTime, 108), 'N/A'))AS DropOutTime,isnull(b.MemberId, 'N/A')AS MemberId, isnull(b.MemberName, 'N/A')AS MemberName, isnull(b.MemberLoanStatus, 'N/A')AS MemberLoanStatus,isnull(b.MemberLoginStatus, 'N/A')AS MemberLoginStatus, isnull(b.MemberWebLogin, 'N/A')AS MemberWebLogin, isnull(b.MemberAppLogin, 'N/A')AS MemberAppLogin, isnull(b.MemberPassword, 'N/A')AS MemberPassword, isnull(b.LoanPurpose, 'N/A')AS LoanPurpose, isnull(convert(CHAR, b.LoanAmount), 'N/A')AS LoanAmount, isnull(convert(CHAR, b.MemberDOM, 106), 'N/A')AS MemberDOM,isnull(b.SpouseName, 'N/A')AS SpouseName, isnull(b.MemberEducation, 'N/A')AS MemberEducation,isnull(b.MemberReligion, 'N/A')AS MemberReligion, isnull(b.MemberCategory, 'N/A')AS MemberCategory, isnull(b.MemberMaritalStatus, 'N/A')AS MemberMaritalStatus, isnull(b.NomineeIsMinor, 'N/A')AS NomineeIsMinor, isnull(b.NomineeEducation, 'N/A')AS NomineeEducation,isnull(b.NomineeMinorGuardian, 'N/A')AS NomineeMinorGuardian, isnull(b.NomineeAddress, 'N/A')AS NomineeAddress,isnull(convert(CHAR, b.NomineeDistrictId), 'N/A')AS NomineeDistrictId, isnull(b.NomineeDistrictName, 'N/A')AS NomineeDistrictName,isnull(convert(CHAR, b.NomineeStateId), 'N/A')AS NomineeStateId, isnull(b.NomineeStateName, 'N/A')AS NomineeStateName,isnull(b.NomineePinCode, 'N/A')AS NomineePinCode, isnull(b.MaikaPersonName, 'N/A')AS MaikaPersonName, isnull(b.MaikaPersonContact, 'N/A')AS MaikaPersonContact, isnull(b.MaikaAddress, 'N/A')AS MaikaAddress, isnull(b.BankAccountType, 'N/A')AS BankAccountType,isnull(convert(CHAR, b.MemberBankId), 'N/A')AS MemberBankId, isnull(b.MemberBankName, 'N/A')AS MemberBankName,isnull(b.BankAccountNo, 'N/A')AS BankAccountNo, isnull(b.BankIFSCCode, 'N/A')AS BankIFSCCode, isnull(b.BankBranchName, 'N/A')AS BankBranchName, isnull(b.BankBranchAddress, 'N/A')AS BankBranchAddress, isnull(b.LocationType, 'N/A')AS LocationType, isnull(b.PostalAddress, 'N/A')AS PostalAddress, isnull(b.PostalHouseNo, 'N/A')AS PostalHouseNo, isnull(b.PostalVillageName, 'N/A')AS PostalVillageName, isnull(b.PostalPostOffice, 'N/A')AS PostalPostOffice, isnull(b.PostalAreaName, 'N/A')AS PostalAreaName, isnull(b.PostalLandMark, 'N/A')AS PostalLandMark, isnull(b.PostalCityName, 'N/A')AS PostalCityName, isnull(convert(CHAR, b.PostalDistrictId), 'N/A')AS PostalDistrictId, isnull(b.PostalDistrictName, 'N/A')AS PostalDistrictName,isnull(convert(CHAR, b.PostalStateId), 'N/A')AS PostalStateId, isnull(b.PostalStateName, 'N/A')AS PostalStateName,isnull(b.PostalPinCode, 'N/A')AS PostalPinCode, isnull(b.PermanentSameAsPostal, 'N/A')AS PermanentSameAsPostal,isnull(b.PermanentAddress, 'N/A')AS PermanentAddress, isnull(b.PermanentHouseNo, 'N/A')AS PermanentHouseNo,isnull(b.PermanentVillageName, 'N/A')AS PermanentVillageName, isnull(b.PermanentPostOffice, 'N/A')AS PermanentPostOffice,isnull(b.PermanentAreaName, 'N/A')AS PermanentAreaName, isnull(b.PermanentLandMark, 'N/A')AS PermanentLandMark,isnull(b.PermanentCityName, 'N/A')AS PermanentCityName, isnull(convert(CHAR, b.PermanentDistrictId), 'N/A')AS PermanentDistrictId,isnull(b.PermanentDistrictName, 'N/A')AS PermanentDistrictName, isnull(convert(CHAR, b.PermanentStateId), 'N/A')AS PermanentStateId, isnull(b.PermanentStateName, 'N/A')AS PermanentStateName, isnull(b.PermanentPinCode, 'N/A')AS PermanentPinCode,isnull(c.ToiletFacility, 'N/A')AS ToiletFacility, isnull(c.WaterFacility, 'N/A')AS WaterFacility, isnull(c.WaterPurification, 'N/A')AS WaterPurification, isnull(c.ElectricityConnection, 'N/A')AS ElectricityConnection, isnull(c.SolarPanel, 'N/A')AS SolarPanel,isnull(c.FoodPreparation, 'N/A')AS FoodPreparation, isnull(c.EligibleChildren, 'N/A')AS EligibleChildren, isnull(c.EligibleGirlChild, 'N/A')AS EligibleGirlChild, isnull(c.LivingType, 'N/A')AS LivingType, isnull(c.HouseType, 'N/A')AS HouseType,isnull(c.NumberOfRoom, 'N/A')AS NumberOfRoom, isnull(c.LiveStock, 'N/A')AS LiveStock, isnull(c.NoOfVehicles, 'N/A')AS NoOfVehicles,isnull(c.LandInAcres, 'N/A')AS LandInAcres, isnull(c.NoOfChildren, 'N/A')AS NoOfChildren, isnull(c.Siblings, 'N/A')AS Siblings,isnull(c.MembersInFamily, 'N/A')AS MembersInFamily, isnull(c.WorkingMember, 'N/A')AS WorkingMember, isnull(c.MemberReputation, 'N/A')AS MemberReputation, isnull(c.WorkingStatus, 'N/A')AS WorkingStatus, isnull(c.BusinessSalaried, 'N/A')AS BusinessSalaried,isnull(c.WorkingProfile, 'N/A')AS WorkingProfile, isnull(c.WorkingSince, 'N/A')AS WorkingSince,isnull(c.ParentalBusiness, 'N/A')AS ParentalBusiness, isnull(c.PresentResidence, 'N/A')AS PresentResidence, isnull(c.MonthlySavings, 'N/A')AS MonthlySavings, isnull(c.ActiveLoanBank, 'N/A')AS ActiveLoanBank, isnull(c.BorrowFrequently, 'N/A')AS BorrowFrequently, isnull(c.InformalLenders, 'N/A')AS InformalLenders, isnull(convert(CHAR, c.FamilyBusinessIncome), 'N/A')AS FamilyBusinessIncome, isnull(convert(CHAR, c.SalaryPensionIncome), 'N/A')AS SalaryPensionIncome, isnull(convert(CHAR, c.WagesIncome), 'N/A')AS WagesIncome, isnull(convert(CHAR, c.OtherIncome), 'N/A')AS OtherIncome, isnull(convert(CHAR, c.Salary), 'N/A')AS Salary, isnull(convert(CHAR, c.Rent), 'N/A')AS Rent,isnull(convert(CHAR, c.Scholarship), 'N/A')AS Scholarship, isnull(convert(CHAR, c.GovernmentScheme), 'N/A')AS GovernmentScheme, isnull(convert(CHAR, c.Agriculture), 'N/A')AS Agriculture, isnull(convert(CHAR, c.Other), 'N/A')AS Other, isnull(convert(CHAR, c.TotalIncome), 'N/A')AS TotalIncome, isnull(convert(CHAR, c.Food), 'N/A')AS Food,isnull(convert(CHAR, c.Education), 'N/A')AS Education, isnull(convert(CHAR, c.Health), 'N/A')AS Health,isnull(convert(CHAR, c.EMIOfLoan), 'N/A')AS EMIOfLoan, isnull(convert(CHAR, c.HouseRent), 'N/A')AS HouseRent,isnull(convert(CHAR, c.ElectricityTax), 'N/A')AS ElectricityTax, isnull(convert(CHAR, c.WaterTax), 'N/A')AS WaterTax,isnull(convert(CHAR, c.PartyFucntion), 'N/A')AS PartyFucntion, isnull(convert(CHAR, c.FareCloth), 'N/A')AS FareCloth,isnull(convert(CHAR, c.OtherExpenses), 'N/A')AS OtherExpenses, isnull(convert(CHAR, c.TotalExpenses), 'N/A')AS TotalExpenses,a.MemberNo, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberFullDetailHTML')AS HTMLReportPageName FROM GroupLoanMemberDetail a WITH(nolock)LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanMemberFinance c WITH(nolock) ON a.MemberId = c.MemberId WHERE a.MemberId='M101000119' 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid column name 'NomineeDistrictId'.
Invalid column name 'NomineeStateId'.
Invalid column name 'PostalDistrictId'.
Invalid column name 'PostalStateId'.
Invalid column name 'PermanentDistrictId'.
Invalid column name 'PermanentStateId'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 07/11/2025 01:50:47 PM
PageName: GroupLoan_GroupMemberRegistrationDetail
String str:  SELECT isnull(a.BranchId,'N/A')AS BranchId, isnull(a.BranchName,'N/A')AS BranchName, isnull(a.GroupOfficerId,'N/A')AS GroupOfficerId, isnull(a.GroupOfficerName, 'N/A')AS GroupOfficerName, isnull(a.CenterId, 'N/A')AS CenterId, isnull(a.CenterName, 'N/A')AS CenterName,  isnull(a.GroupName, 'N/A')AS GroupName, isnull(a.MemberFormNo, 'N/A')AS MemberFormNo, isnull(a.OtherMemberId, 'N/A')AS OtherMemberId, isnull(a.IdType, 'N/A')AS IdType, isnull(a.MemberId, 'N/A')AS MemberId, isnull(convert(CHAR, a.MemberJoinDate, 106), 'N/A')AS MemberJoinDate, isnull(a.MemberSalutation, 'N/A')AS MemberSalutation, isnull(a.MemberName, 'N/A')AS MemberName, isnull(a.GuardianSalutation, 'N/A')AS GuardianSalutation, isnull(a.MemberGuardianName, 'N/A')AS MemberGuardianName, isnull(a.MemberGender, 'N/A')AS MemberGender, isnull(convert(CHAR, a.MemberDOB, 106), 'N/A')AS MemberDOB, isnull(convert(CHAR, a.MemberAge), 'N/A')AS MemberAge, isnull(a.MemberMobileNo, 'N/A')AS MemberMobileNo, isnull(a.MemberOccupation, 'N/A')AS MemberOccupation, isnull(convert(CHAR, a.MemberAnnualIncome), 'N/A')AS MemberAnnualIncome, isnull(convert(CHAR, a.FamilyAnnualExpence), 'N/A')AS FamilyAnnualExpence, isnull(a.NomineeSalutation, 'N/A')AS NomineeSalutation, isnull(a.NomineeName, 'N/A')AS NomineeName, isnull(a.NomineeGuardianSalutation, 'N/A')AS  NomineeGuardianSalutation, isnull(a.NomineeGuardianName, 'N/A')AS NomineeGuardianName, isnull(a.NomineeGender, 'N/A')AS NomineeGender, isnull(convert(CHAR, a.NomineeDOB, 106), 'N/A')AS NomineeDOB, isnull(convert(CHAR, a.NomineeAge), 'N/A')AS NomineeAge, isnull(convert(CHAR, a.NomineeAnnualIncome), 'N/A') AS NomineeAnnualIncome, isnull(a.NomineeRelation, 'N/A')AS NomineeRelation, isnull(a.NomineeMobileNo, 'N/A')AS NomineeMobileNo, isnull(a.NomineeOccupation, 'N/A')AS NomineeOccupation, isnull(a.NomineeAadharNo, 'N/A')AS NomineeAadharNo,isnull(a.NomineeVoterIdNo, 'N/A')AS NomineeVoterIdNo, isnull(a.NomineePANNo, 'N/A')AS NomineePANNo, isnull(a.NomineeDLNo, 'N/A')AS NomineeDLNo,isnull(a.MemberAadharNo, 'N/A')AS MemberAadharNo, isnull(a.MemberPanNo, 'N/A')AS MemberPanNo, isnull(a.MemberVoterIdNo, 'N/A')AS MemberVoterIdNo,isnull(a.MemberDLNo, 'N/A')AS MemberDLNo, isnull(a.RationCard, 'N/A')AS RationCard, isnull(a.ElectricityBill, 'N/A')AS ElectricityBill,isnull(a.MemberProfileStatus, 'N/A')AS MemberProfileStatus, isnull(a.MemberAddress, 'N/A')AS MemberAddress, isnull(a.MemberLatitude, 'N/A')AS MemberLatitude,isnull(a.MemberLongitude, 'N/A')AS MemberLongitude, isnull(a.EntryUser, 'N/A')AS EntryUser,rtrim(isnull(convert(CHAR, a.EntryTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.EntryTime, 108), 'N/A'))AS EntryTime, isnull(convert(CHAR, b.GroupJoinDate, 106), 'N/A')AS GroupJoinDate, isnull(b.GroupUser, 'N/A')AS GroupUser, rtrim(isnull(convert(CHAR, b.GroupTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, b.GroupTime, 108), 'N/A'))AS GroupTime, isnull(b.GroupStatus, 'N/A') AS GroupStatus, isnull(b.CGTOfficerId, 'N/A')AS CGTOfficerId, isnull(b.CGTOfficerName, 'N/A')AS CGTOfficerName, isnull(convert(CHAR, b.CGTDate, 106), 'N/A')AS CGTDate, isnull(b.CGTUser, 'N/A')AS CGTUser, isnull(convert(CHAR, b.CGTTime), 'N/A')AS CGTTime, isnull(b.GRTOfficerId, 'N/A')AS GRTOfficerId,isnull(b.GRTOfficerName, 'N/A')AS GRTOfficerName, isnull(convert(CHAR, b.GRTDate), 'N/A')AS GRTDate, isnull(b.GRTUser, 'N/A')AS GRTUser, isnull(convert(CHAR, b.GRTTime), 'N/A')AS GRTTime, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')AS CompanyURL,  (SELECT replace(ReportValue, '~/', '')AS ImageFolderLocation FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberAadharImageFolder')AS ImageFolderLocation, (SELECT replace(ReportValue, '~/', '')AS KYCFolderLocation FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')AS KYCFolderLocation, isnull(a.MemberPOIType, 'N/A')AS MemberPOIType,isnull(a.MemberPOINo, 'N/A')AS MemberPOINo, isnull(a.MemberPOAType, 'N/A')AS MemberPOAType, isnull(a.MemberPOANo, 'N/A')AS MemberPOANo,isnull(a.MemberAadharPhoto, 'N/A')AS MemberAadharPhoto, isnull(a.MemberPhoto, 'N/A')AS MemberPhoto, isnull(a.MemberSignature, 'N/A') AS MemberSignature, isnull(a.MemberPOIFront, 'N/A')AS MemberPOIFront, isnull(a.MemberPOIBack, 'N/A')AS MemberPOIBack, isnull(a.MemberPOAFront, 'N/A') AS  MemberPOAFront, isnull(a.MemberPOABack, 'N/A')AS MemberPOABack, isnull(a.MemberBankPassBook, 'N/A')AS MemberBankPassBook, isnull(a.NomineePOIType, 'N/A') AS NomineePOIType, isnull(a.NomineePOINo, 'N/A')AS NomineePOINo, isnull(a.NomineePOAType, 'N/A')AS NomineePOAType, isnull(a.NomineePOANo, 'N/A')AS NomineePOANo,isnull(a.NomineeAadharPhoto, 'N/A')AS NomineeAadharPhoto, isnull(a.NomineePhoto, 'N/A')AS NomineePhoto, isnull(a.NomineeSignature, 'N/A')AS NomineeSignature,isnull(a.NomineePOIFront, 'N/A')AS NomineePOIFront, isnull(a.NomineePOIBack, 'N/A')AS NomineePOIBack, isnull(a.NomineePOAFront, 'N/A')AS NomineePOAFront,isnull(a.NomineePOABack, 'N/A')AS NomineePOABack, isnull(a.MemberNomineeJointPhoto, 'N/A')AS MemberNomineeJointPhoto, isnull(a.KYCStatus, 'N/A')AS KYCStatus,isnull(a.KYCRemark, 'N/A')AS KYCRemark, rtrim(isnull(convert(CHAR, a.KYCTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.KYCTime, 108), 'N/A'))AS KYCTime,isnull(a.KYCUser, 'N/A')AS KYCUser, isnull(convert(CHAR, a.DropOutDate, 106), 'N/A')AS DropOutDate, isnull(a.DropOutRemark, 'N/A')AS DropOutRemark,isnull(a.DropOutUser, 'N/A')AS DropOutUser, rtrim(isnull(convert(CHAR, a.DropOutTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.DropOutTime, 108), 'N/A'))AS DropOutTime,isnull(b.MemberId, 'N/A')AS MemberId, isnull(b.MemberName, 'N/A')AS MemberName, isnull(b.MemberLoanStatus, 'N/A')AS MemberLoanStatus,isnull(b.MemberLoginStatus, 'N/A')AS MemberLoginStatus, isnull(b.MemberWebLogin, 'N/A')AS MemberWebLogin, isnull(b.MemberAppLogin, 'N/A')AS MemberAppLogin, isnull(b.MemberPassword, 'N/A')AS MemberPassword, isnull(b.LoanPurpose, 'N/A')AS LoanPurpose, isnull(convert(CHAR, b.LoanAmount), 'N/A')AS LoanAmount, isnull(convert(CHAR, b.MemberDOM, 106), 'N/A')AS MemberDOM,isnull(b.SpouseName, 'N/A')AS SpouseName, isnull(b.MemberEducation, 'N/A')AS MemberEducation,isnull(b.MemberReligion, 'N/A')AS MemberReligion, isnull(b.MemberCategory, 'N/A')AS MemberCategory, isnull(b.MemberMaritalStatus, 'N/A')AS MemberMaritalStatus, isnull(b.NomineeIsMinor, 'N/A')AS NomineeIsMinor, isnull(b.NomineeEducation, 'N/A')AS NomineeEducation,isnull(b.NomineeMinorGuardian, 'N/A')AS NomineeMinorGuardian, isnull(b.NomineeAddress, 'N/A')AS NomineeAddress,isnull(convert(CHAR, b.NomineeDistrictId), 'N/A')AS NomineeDistrictId, isnull(b.NomineeDistrictName, 'N/A')AS NomineeDistrictName,isnull(convert(CHAR, b.NomineeStateId), 'N/A')AS NomineeStateId, isnull(b.NomineeStateName, 'N/A')AS NomineeStateName,isnull(b.NomineePinCode, 'N/A')AS NomineePinCode, isnull(b.MaikaPersonName, 'N/A')AS MaikaPersonName, isnull(b.MaikaPersonContact, 'N/A')AS MaikaPersonContact, isnull(b.MaikaAddress, 'N/A')AS MaikaAddress, isnull(b.BankAccountType, 'N/A')AS BankAccountType,isnull(convert(CHAR, b.MemberBankId), 'N/A')AS MemberBankId, isnull(b.MemberBankName, 'N/A')AS MemberBankName,isnull(b.BankAccountNo, 'N/A')AS BankAccountNo, isnull(b.BankIFSCCode, 'N/A')AS BankIFSCCode, isnull(b.BankBranchName, 'N/A')AS BankBranchName, isnull(b.BankBranchAddress, 'N/A')AS BankBranchAddress, isnull(b.LocationType, 'N/A')AS LocationType, isnull(b.PostalAddress, 'N/A')AS PostalAddress, isnull(b.PostalHouseNo, 'N/A')AS PostalHouseNo, isnull(b.PostalVillageName, 'N/A')AS PostalVillageName, isnull(b.PostalPostOffice, 'N/A')AS PostalPostOffice, isnull(b.PostalAreaName, 'N/A')AS PostalAreaName, isnull(b.PostalLandMark, 'N/A')AS PostalLandMark, isnull(b.PostalCityName, 'N/A')AS PostalCityName, isnull(convert(CHAR, b.PostalDistrictId), 'N/A')AS PostalDistrictId, isnull(b.PostalDistrictName, 'N/A')AS PostalDistrictName,isnull(convert(CHAR, b.PostalStateId), 'N/A')AS PostalStateId, isnull(b.PostalStateName, 'N/A')AS PostalStateName,isnull(b.PostalPinCode, 'N/A')AS PostalPinCode, isnull(b.PermanentSameAsPostal, 'N/A')AS PermanentSameAsPostal,isnull(b.PermanentAddress, 'N/A')AS PermanentAddress, isnull(b.PermanentHouseNo, 'N/A')AS PermanentHouseNo,isnull(b.PermanentVillageName, 'N/A')AS PermanentVillageName, isnull(b.PermanentPostOffice, 'N/A')AS PermanentPostOffice,isnull(b.PermanentAreaName, 'N/A')AS PermanentAreaName, isnull(b.PermanentLandMark, 'N/A')AS PermanentLandMark,isnull(b.PermanentCityName, 'N/A')AS PermanentCityName, isnull(convert(CHAR, b.PermanentDistrictId), 'N/A')AS PermanentDistrictId,isnull(b.PermanentDistrictName, 'N/A')AS PermanentDistrictName, isnull(convert(CHAR, b.PermanentStateId), 'N/A')AS PermanentStateId, isnull(b.PermanentStateName, 'N/A')AS PermanentStateName, isnull(b.PermanentPinCode, 'N/A')AS PermanentPinCode,isnull(c.ToiletFacility, 'N/A')AS ToiletFacility, isnull(c.WaterFacility, 'N/A')AS WaterFacility, isnull(c.WaterPurification, 'N/A')AS WaterPurification, isnull(c.ElectricityConnection, 'N/A')AS ElectricityConnection, isnull(c.SolarPanel, 'N/A')AS SolarPanel,isnull(c.FoodPreparation, 'N/A')AS FoodPreparation, isnull(c.EligibleChildren, 'N/A')AS EligibleChildren, isnull(c.EligibleGirlChild, 'N/A')AS EligibleGirlChild, isnull(c.LivingType, 'N/A')AS LivingType, isnull(c.HouseType, 'N/A')AS HouseType,isnull(c.NumberOfRoom, 'N/A')AS NumberOfRoom, isnull(c.LiveStock, 'N/A')AS LiveStock, isnull(c.NoOfVehicles, 'N/A')AS NoOfVehicles,isnull(c.LandInAcres, 'N/A')AS LandInAcres, isnull(c.NoOfChildren, 'N/A')AS NoOfChildren, isnull(c.Siblings, 'N/A')AS Siblings,isnull(c.MembersInFamily, 'N/A')AS MembersInFamily, isnull(c.WorkingMember, 'N/A')AS WorkingMember, isnull(c.MemberReputation, 'N/A')AS MemberReputation, isnull(c.WorkingStatus, 'N/A')AS WorkingStatus, isnull(c.BusinessSalaried, 'N/A')AS BusinessSalaried,isnull(c.WorkingProfile, 'N/A')AS WorkingProfile, isnull(c.WorkingSince, 'N/A')AS WorkingSince,isnull(c.ParentalBusiness, 'N/A')AS ParentalBusiness, isnull(c.PresentResidence, 'N/A')AS PresentResidence, isnull(c.MonthlySavings, 'N/A')AS MonthlySavings, isnull(c.ActiveLoanBank, 'N/A')AS ActiveLoanBank, isnull(c.BorrowFrequently, 'N/A')AS BorrowFrequently, isnull(c.InformalLenders, 'N/A')AS InformalLenders, isnull(convert(CHAR, c.FamilyBusinessIncome), 'N/A')AS FamilyBusinessIncome, isnull(convert(CHAR, c.SalaryPensionIncome), 'N/A')AS SalaryPensionIncome, isnull(convert(CHAR, c.WagesIncome), 'N/A')AS WagesIncome, isnull(convert(CHAR, c.OtherIncome), 'N/A')AS OtherIncome, isnull(convert(CHAR, c.Salary), 'N/A')AS Salary, isnull(convert(CHAR, c.Rent), 'N/A')AS Rent,isnull(convert(CHAR, c.Scholarship), 'N/A')AS Scholarship, isnull(convert(CHAR, c.GovernmentScheme), 'N/A')AS GovernmentScheme, isnull(convert(CHAR, c.Agriculture), 'N/A')AS Agriculture, isnull(convert(CHAR, c.Other), 'N/A')AS Other, isnull(convert(CHAR, c.TotalIncome), 'N/A')AS TotalIncome, isnull(convert(CHAR, c.Food), 'N/A')AS Food,isnull(convert(CHAR, c.Education), 'N/A')AS Education, isnull(convert(CHAR, c.Health), 'N/A')AS Health,isnull(convert(CHAR, c.EMIOfLoan), 'N/A')AS EMIOfLoan, isnull(convert(CHAR, c.HouseRent), 'N/A')AS HouseRent,isnull(convert(CHAR, c.ElectricityTax), 'N/A')AS ElectricityTax, isnull(convert(CHAR, c.WaterTax), 'N/A')AS WaterTax,isnull(convert(CHAR, c.PartyFucntion), 'N/A')AS PartyFucntion, isnull(convert(CHAR, c.FareCloth), 'N/A')AS FareCloth,isnull(convert(CHAR, c.OtherExpenses), 'N/A')AS OtherExpenses, isnull(convert(CHAR, c.TotalExpenses), 'N/A')AS TotalExpenses,a.MemberNo, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberFullDetailHTML')AS HTMLReportPageName FROM GroupLoanMemberDetail a WITH(nolock)LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanMemberFinance c WITH(nolock) ON a.MemberId = c.MemberId WHERE a.MemberId='M101000119' 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_ghkbelql
StackTrace:    at GroupLoan_GroupMemberRegistrationDetail.FillMemberDetail()
TargetSite: Void FillMemberDetail()

Time: 07/11/2025 01:50:49 PM
PageName: DataTableResult
String str:  SELECT isnull(a.BranchId,'N/A')AS BranchId, isnull(a.BranchName,'N/A')AS BranchName, isnull(a.GroupOfficerId,'N/A')AS GroupOfficerId, isnull(a.GroupOfficerName, 'N/A')AS GroupOfficerName, isnull(a.CenterId, 'N/A')AS CenterId, isnull(a.CenterName, 'N/A')AS CenterName,  isnull(a.GroupName, 'N/A')AS GroupName, isnull(a.MemberFormNo, 'N/A')AS MemberFormNo, isnull(a.OtherMemberId, 'N/A')AS OtherMemberId, isnull(a.IdType, 'N/A')AS IdType, isnull(a.MemberId, 'N/A')AS MemberId, isnull(convert(CHAR, a.MemberJoinDate, 106), 'N/A')AS MemberJoinDate, isnull(a.MemberSalutation, 'N/A')AS MemberSalutation, isnull(a.MemberName, 'N/A')AS MemberName, isnull(a.GuardianSalutation, 'N/A')AS GuardianSalutation, isnull(a.MemberGuardianName, 'N/A')AS MemberGuardianName, isnull(a.MemberGender, 'N/A')AS MemberGender, isnull(convert(CHAR, a.MemberDOB, 106), 'N/A')AS MemberDOB, isnull(convert(CHAR, a.MemberAge), 'N/A')AS MemberAge, isnull(a.MemberMobileNo, 'N/A')AS MemberMobileNo, isnull(a.MemberOccupation, 'N/A')AS MemberOccupation, isnull(convert(CHAR, a.MemberAnnualIncome), 'N/A')AS MemberAnnualIncome, isnull(convert(CHAR, a.FamilyAnnualExpence), 'N/A')AS FamilyAnnualExpence, isnull(a.NomineeSalutation, 'N/A')AS NomineeSalutation, isnull(a.NomineeName, 'N/A')AS NomineeName, isnull(a.NomineeGuardianSalutation, 'N/A')AS  NomineeGuardianSalutation, isnull(a.NomineeGuardianName, 'N/A')AS NomineeGuardianName, isnull(a.NomineeGender, 'N/A')AS NomineeGender, isnull(convert(CHAR, a.NomineeDOB, 106), 'N/A')AS NomineeDOB, isnull(convert(CHAR, a.NomineeAge), 'N/A')AS NomineeAge, isnull(convert(CHAR, a.NomineeAnnualIncome), 'N/A') AS NomineeAnnualIncome, isnull(a.NomineeRelation, 'N/A')AS NomineeRelation, isnull(a.NomineeMobileNo, 'N/A')AS NomineeMobileNo, isnull(a.NomineeOccupation, 'N/A')AS NomineeOccupation, isnull(a.NomineeAadharNo, 'N/A')AS NomineeAadharNo,isnull(a.NomineeVoterIdNo, 'N/A')AS NomineeVoterIdNo, isnull(a.NomineePANNo, 'N/A')AS NomineePANNo, isnull(a.NomineeDLNo, 'N/A')AS NomineeDLNo,isnull(a.MemberAadharNo, 'N/A')AS MemberAadharNo, isnull(a.MemberPanNo, 'N/A')AS MemberPanNo, isnull(a.MemberVoterIdNo, 'N/A')AS MemberVoterIdNo,isnull(a.MemberDLNo, 'N/A')AS MemberDLNo, isnull(a.RationCard, 'N/A')AS RationCard, isnull(a.ElectricityBill, 'N/A')AS ElectricityBill,isnull(a.MemberProfileStatus, 'N/A')AS MemberProfileStatus, isnull(a.MemberAddress, 'N/A')AS MemberAddress, isnull(a.MemberLatitude, 'N/A')AS MemberLatitude,isnull(a.MemberLongitude, 'N/A')AS MemberLongitude, isnull(a.EntryUser, 'N/A')AS EntryUser,rtrim(isnull(convert(CHAR, a.EntryTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.EntryTime, 108), 'N/A'))AS EntryTime, isnull(convert(CHAR, b.GroupJoinDate, 106), 'N/A')AS GroupJoinDate, isnull(b.GroupUser, 'N/A')AS GroupUser, rtrim(isnull(convert(CHAR, b.GroupTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, b.GroupTime, 108), 'N/A'))AS GroupTime, isnull(b.GroupStatus, 'N/A') AS GroupStatus, isnull(b.CGTOfficerId, 'N/A')AS CGTOfficerId, isnull(b.CGTOfficerName, 'N/A')AS CGTOfficerName, isnull(convert(CHAR, b.CGTDate, 106), 'N/A')AS CGTDate, isnull(b.CGTUser, 'N/A')AS CGTUser, isnull(convert(CHAR, b.CGTTime), 'N/A')AS CGTTime, isnull(b.GRTOfficerId, 'N/A')AS GRTOfficerId,isnull(b.GRTOfficerName, 'N/A')AS GRTOfficerName, isnull(convert(CHAR, b.GRTDate), 'N/A')AS GRTDate, isnull(b.GRTUser, 'N/A')AS GRTUser, isnull(convert(CHAR, b.GRTTime), 'N/A')AS GRTTime, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')AS CompanyURL,  (SELECT replace(ReportValue, '~/', '')AS ImageFolderLocation FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberAadharImageFolder')AS ImageFolderLocation, (SELECT replace(ReportValue, '~/', '')AS KYCFolderLocation FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')AS KYCFolderLocation, isnull(a.MemberPOIType, 'N/A')AS MemberPOIType,isnull(a.MemberPOINo, 'N/A')AS MemberPOINo, isnull(a.MemberPOAType, 'N/A')AS MemberPOAType, isnull(a.MemberPOANo, 'N/A')AS MemberPOANo,isnull(a.MemberAadharPhoto, 'N/A')AS MemberAadharPhoto, isnull(a.MemberPhoto, 'N/A')AS MemberPhoto, isnull(a.MemberSignature, 'N/A') AS MemberSignature, isnull(a.MemberPOIFront, 'N/A')AS MemberPOIFront, isnull(a.MemberPOIBack, 'N/A')AS MemberPOIBack, isnull(a.MemberPOAFront, 'N/A') AS  MemberPOAFront, isnull(a.MemberPOABack, 'N/A')AS MemberPOABack, isnull(a.MemberBankPassBook, 'N/A')AS MemberBankPassBook, isnull(a.NomineePOIType, 'N/A') AS NomineePOIType, isnull(a.NomineePOINo, 'N/A')AS NomineePOINo, isnull(a.NomineePOAType, 'N/A')AS NomineePOAType, isnull(a.NomineePOANo, 'N/A')AS NomineePOANo,isnull(a.NomineeAadharPhoto, 'N/A')AS NomineeAadharPhoto, isnull(a.NomineePhoto, 'N/A')AS NomineePhoto, isnull(a.NomineeSignature, 'N/A')AS NomineeSignature,isnull(a.NomineePOIFront, 'N/A')AS NomineePOIFront, isnull(a.NomineePOIBack, 'N/A')AS NomineePOIBack, isnull(a.NomineePOAFront, 'N/A')AS NomineePOAFront,isnull(a.NomineePOABack, 'N/A')AS NomineePOABack, isnull(a.MemberNomineeJointPhoto, 'N/A')AS MemberNomineeJointPhoto, isnull(a.KYCStatus, 'N/A')AS KYCStatus,isnull(a.KYCRemark, 'N/A')AS KYCRemark, rtrim(isnull(convert(CHAR, a.KYCTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.KYCTime, 108), 'N/A'))AS KYCTime,isnull(a.KYCUser, 'N/A')AS KYCUser, isnull(convert(CHAR, a.DropOutDate, 106), 'N/A')AS DropOutDate, isnull(a.DropOutRemark, 'N/A')AS DropOutRemark,isnull(a.DropOutUser, 'N/A')AS DropOutUser, rtrim(isnull(convert(CHAR, a.DropOutTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.DropOutTime, 108), 'N/A'))AS DropOutTime,isnull(b.MemberId, 'N/A')AS MemberId, isnull(b.MemberName, 'N/A')AS MemberName, isnull(b.MemberLoanStatus, 'N/A')AS MemberLoanStatus,isnull(b.MemberLoginStatus, 'N/A')AS MemberLoginStatus, isnull(b.MemberWebLogin, 'N/A')AS MemberWebLogin, isnull(b.MemberAppLogin, 'N/A')AS MemberAppLogin, isnull(b.MemberPassword, 'N/A')AS MemberPassword, isnull(b.LoanPurpose, 'N/A')AS LoanPurpose, isnull(convert(CHAR, b.LoanAmount), 'N/A')AS LoanAmount, isnull(convert(CHAR, b.MemberDOM, 106), 'N/A')AS MemberDOM,isnull(b.SpouseName, 'N/A')AS SpouseName, isnull(b.MemberEducation, 'N/A')AS MemberEducation,isnull(b.MemberReligion, 'N/A')AS MemberReligion, isnull(b.MemberCategory, 'N/A')AS MemberCategory, isnull(b.MemberMaritalStatus, 'N/A')AS MemberMaritalStatus, isnull(b.NomineeIsMinor, 'N/A')AS NomineeIsMinor, isnull(b.NomineeEducation, 'N/A')AS NomineeEducation,isnull(b.NomineeMinorGuardian, 'N/A')AS NomineeMinorGuardian, isnull(b.NomineeAddress, 'N/A')AS NomineeAddress,isnull(convert(CHAR, b.NomineeDistrictId), 'N/A')AS NomineeDistrictId, isnull(b.NomineeDistrictName, 'N/A')AS NomineeDistrictName,isnull(convert(CHAR, b.NomineeStateId), 'N/A')AS NomineeStateId, isnull(b.NomineeStateName, 'N/A')AS NomineeStateName,isnull(b.NomineePinCode, 'N/A')AS NomineePinCode, isnull(b.MaikaPersonName, 'N/A')AS MaikaPersonName, isnull(b.MaikaPersonContact, 'N/A')AS MaikaPersonContact, isnull(b.MaikaAddress, 'N/A')AS MaikaAddress, isnull(b.BankAccountType, 'N/A')AS BankAccountType,isnull(convert(CHAR, b.MemberBankId), 'N/A')AS MemberBankId, isnull(b.MemberBankName, 'N/A')AS MemberBankName,isnull(b.BankAccountNo, 'N/A')AS BankAccountNo, isnull(b.BankIFSCCode, 'N/A')AS BankIFSCCode, isnull(b.BankBranchName, 'N/A')AS BankBranchName, isnull(b.BankBranchAddress, 'N/A')AS BankBranchAddress, isnull(b.LocationType, 'N/A')AS LocationType, isnull(b.PostalAddress, 'N/A')AS PostalAddress, isnull(b.PostalHouseNo, 'N/A')AS PostalHouseNo, isnull(b.PostalVillageName, 'N/A')AS PostalVillageName, isnull(b.PostalPostOffice, 'N/A')AS PostalPostOffice, isnull(b.PostalAreaName, 'N/A')AS PostalAreaName, isnull(b.PostalLandMark, 'N/A')AS PostalLandMark, isnull(b.PostalCityName, 'N/A')AS PostalCityName, isnull(convert(CHAR, b.PostalDistrictId), 'N/A')AS PostalDistrictId, isnull(b.PostalDistrictName, 'N/A')AS PostalDistrictName,isnull(convert(CHAR, b.PostalStateId), 'N/A')AS PostalStateId, isnull(b.PostalStateName, 'N/A')AS PostalStateName,isnull(b.PostalPinCode, 'N/A')AS PostalPinCode, isnull(b.PermanentSameAsPostal, 'N/A')AS PermanentSameAsPostal,isnull(b.PermanentAddress, 'N/A')AS PermanentAddress, isnull(b.PermanentHouseNo, 'N/A')AS PermanentHouseNo,isnull(b.PermanentVillageName, 'N/A')AS PermanentVillageName, isnull(b.PermanentPostOffice, 'N/A')AS PermanentPostOffice,isnull(b.PermanentAreaName, 'N/A')AS PermanentAreaName, isnull(b.PermanentLandMark, 'N/A')AS PermanentLandMark,isnull(b.PermanentCityName, 'N/A')AS PermanentCityName, isnull(convert(CHAR, b.PermanentDistrictId), 'N/A')AS PermanentDistrictId,isnull(b.PermanentDistrictName, 'N/A')AS PermanentDistrictName, isnull(convert(CHAR, b.PermanentStateId), 'N/A')AS PermanentStateId, isnull(b.PermanentStateName, 'N/A')AS PermanentStateName, isnull(b.PermanentPinCode, 'N/A')AS PermanentPinCode,isnull(c.ToiletFacility, 'N/A')AS ToiletFacility, isnull(c.WaterFacility, 'N/A')AS WaterFacility, isnull(c.WaterPurification, 'N/A')AS WaterPurification, isnull(c.ElectricityConnection, 'N/A')AS ElectricityConnection, isnull(c.SolarPanel, 'N/A')AS SolarPanel,isnull(c.FoodPreparation, 'N/A')AS FoodPreparation, isnull(c.EligibleChildren, 'N/A')AS EligibleChildren, isnull(c.EligibleGirlChild, 'N/A')AS EligibleGirlChild, isnull(c.LivingType, 'N/A')AS LivingType, isnull(c.HouseType, 'N/A')AS HouseType,isnull(c.NumberOfRoom, 'N/A')AS NumberOfRoom, isnull(c.LiveStock, 'N/A')AS LiveStock, isnull(c.NoOfVehicles, 'N/A')AS NoOfVehicles,isnull(c.LandInAcres, 'N/A')AS LandInAcres, isnull(c.NoOfChildren, 'N/A')AS NoOfChildren, isnull(c.Siblings, 'N/A')AS Siblings,isnull(c.MembersInFamily, 'N/A')AS MembersInFamily, isnull(c.WorkingMember, 'N/A')AS WorkingMember, isnull(c.MemberReputation, 'N/A')AS MemberReputation, isnull(c.WorkingStatus, 'N/A')AS WorkingStatus, isnull(c.BusinessSalaried, 'N/A')AS BusinessSalaried,isnull(c.WorkingProfile, 'N/A')AS WorkingProfile, isnull(c.WorkingSince, 'N/A')AS WorkingSince,isnull(c.ParentalBusiness, 'N/A')AS ParentalBusiness, isnull(c.PresentResidence, 'N/A')AS PresentResidence, isnull(c.MonthlySavings, 'N/A')AS MonthlySavings, isnull(c.ActiveLoanBank, 'N/A')AS ActiveLoanBank, isnull(c.BorrowFrequently, 'N/A')AS BorrowFrequently, isnull(c.InformalLenders, 'N/A')AS InformalLenders, isnull(convert(CHAR, c.FamilyBusinessIncome), 'N/A')AS FamilyBusinessIncome, isnull(convert(CHAR, c.SalaryPensionIncome), 'N/A')AS SalaryPensionIncome, isnull(convert(CHAR, c.WagesIncome), 'N/A')AS WagesIncome, isnull(convert(CHAR, c.OtherIncome), 'N/A')AS OtherIncome, isnull(convert(CHAR, c.Salary), 'N/A')AS Salary, isnull(convert(CHAR, c.Rent), 'N/A')AS Rent,isnull(convert(CHAR, c.Scholarship), 'N/A')AS Scholarship, isnull(convert(CHAR, c.GovernmentScheme), 'N/A')AS GovernmentScheme, isnull(convert(CHAR, c.Agriculture), 'N/A')AS Agriculture, isnull(convert(CHAR, c.Other), 'N/A')AS Other, isnull(convert(CHAR, c.TotalIncome), 'N/A')AS TotalIncome, isnull(convert(CHAR, c.Food), 'N/A')AS Food,isnull(convert(CHAR, c.Education), 'N/A')AS Education, isnull(convert(CHAR, c.Health), 'N/A')AS Health,isnull(convert(CHAR, c.EMIOfLoan), 'N/A')AS EMIOfLoan, isnull(convert(CHAR, c.HouseRent), 'N/A')AS HouseRent,isnull(convert(CHAR, c.ElectricityTax), 'N/A')AS ElectricityTax, isnull(convert(CHAR, c.WaterTax), 'N/A')AS WaterTax,isnull(convert(CHAR, c.PartyFucntion), 'N/A')AS PartyFucntion, isnull(convert(CHAR, c.FareCloth), 'N/A')AS FareCloth,isnull(convert(CHAR, c.OtherExpenses), 'N/A')AS OtherExpenses, isnull(convert(CHAR, c.TotalExpenses), 'N/A')AS TotalExpenses,a.MemberNo, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberFullDetailHTML')AS HTMLReportPageName FROM GroupLoanMemberDetail a WITH(nolock)LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanMemberFinance c WITH(nolock) ON a.MemberId = c.MemberId WHERE a.MemberId='M101000119' 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid column name 'NomineeDistrictId'.
Invalid column name 'NomineeStateId'.
Invalid column name 'PostalDistrictId'.
Invalid column name 'PostalStateId'.
Invalid column name 'PermanentDistrictId'.
Invalid column name 'PermanentStateId'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 07/11/2025 01:50:49 PM
PageName: GroupLoan_GroupMemberRegistrationDetail
String str:  SELECT isnull(a.BranchId,'N/A')AS BranchId, isnull(a.BranchName,'N/A')AS BranchName, isnull(a.GroupOfficerId,'N/A')AS GroupOfficerId, isnull(a.GroupOfficerName, 'N/A')AS GroupOfficerName, isnull(a.CenterId, 'N/A')AS CenterId, isnull(a.CenterName, 'N/A')AS CenterName,  isnull(a.GroupName, 'N/A')AS GroupName, isnull(a.MemberFormNo, 'N/A')AS MemberFormNo, isnull(a.OtherMemberId, 'N/A')AS OtherMemberId, isnull(a.IdType, 'N/A')AS IdType, isnull(a.MemberId, 'N/A')AS MemberId, isnull(convert(CHAR, a.MemberJoinDate, 106), 'N/A')AS MemberJoinDate, isnull(a.MemberSalutation, 'N/A')AS MemberSalutation, isnull(a.MemberName, 'N/A')AS MemberName, isnull(a.GuardianSalutation, 'N/A')AS GuardianSalutation, isnull(a.MemberGuardianName, 'N/A')AS MemberGuardianName, isnull(a.MemberGender, 'N/A')AS MemberGender, isnull(convert(CHAR, a.MemberDOB, 106), 'N/A')AS MemberDOB, isnull(convert(CHAR, a.MemberAge), 'N/A')AS MemberAge, isnull(a.MemberMobileNo, 'N/A')AS MemberMobileNo, isnull(a.MemberOccupation, 'N/A')AS MemberOccupation, isnull(convert(CHAR, a.MemberAnnualIncome), 'N/A')AS MemberAnnualIncome, isnull(convert(CHAR, a.FamilyAnnualExpence), 'N/A')AS FamilyAnnualExpence, isnull(a.NomineeSalutation, 'N/A')AS NomineeSalutation, isnull(a.NomineeName, 'N/A')AS NomineeName, isnull(a.NomineeGuardianSalutation, 'N/A')AS  NomineeGuardianSalutation, isnull(a.NomineeGuardianName, 'N/A')AS NomineeGuardianName, isnull(a.NomineeGender, 'N/A')AS NomineeGender, isnull(convert(CHAR, a.NomineeDOB, 106), 'N/A')AS NomineeDOB, isnull(convert(CHAR, a.NomineeAge), 'N/A')AS NomineeAge, isnull(convert(CHAR, a.NomineeAnnualIncome), 'N/A') AS NomineeAnnualIncome, isnull(a.NomineeRelation, 'N/A')AS NomineeRelation, isnull(a.NomineeMobileNo, 'N/A')AS NomineeMobileNo, isnull(a.NomineeOccupation, 'N/A')AS NomineeOccupation, isnull(a.NomineeAadharNo, 'N/A')AS NomineeAadharNo,isnull(a.NomineeVoterIdNo, 'N/A')AS NomineeVoterIdNo, isnull(a.NomineePANNo, 'N/A')AS NomineePANNo, isnull(a.NomineeDLNo, 'N/A')AS NomineeDLNo,isnull(a.MemberAadharNo, 'N/A')AS MemberAadharNo, isnull(a.MemberPanNo, 'N/A')AS MemberPanNo, isnull(a.MemberVoterIdNo, 'N/A')AS MemberVoterIdNo,isnull(a.MemberDLNo, 'N/A')AS MemberDLNo, isnull(a.RationCard, 'N/A')AS RationCard, isnull(a.ElectricityBill, 'N/A')AS ElectricityBill,isnull(a.MemberProfileStatus, 'N/A')AS MemberProfileStatus, isnull(a.MemberAddress, 'N/A')AS MemberAddress, isnull(a.MemberLatitude, 'N/A')AS MemberLatitude,isnull(a.MemberLongitude, 'N/A')AS MemberLongitude, isnull(a.EntryUser, 'N/A')AS EntryUser,rtrim(isnull(convert(CHAR, a.EntryTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.EntryTime, 108), 'N/A'))AS EntryTime, isnull(convert(CHAR, b.GroupJoinDate, 106), 'N/A')AS GroupJoinDate, isnull(b.GroupUser, 'N/A')AS GroupUser, rtrim(isnull(convert(CHAR, b.GroupTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, b.GroupTime, 108), 'N/A'))AS GroupTime, isnull(b.GroupStatus, 'N/A') AS GroupStatus, isnull(b.CGTOfficerId, 'N/A')AS CGTOfficerId, isnull(b.CGTOfficerName, 'N/A')AS CGTOfficerName, isnull(convert(CHAR, b.CGTDate, 106), 'N/A')AS CGTDate, isnull(b.CGTUser, 'N/A')AS CGTUser, isnull(convert(CHAR, b.CGTTime), 'N/A')AS CGTTime, isnull(b.GRTOfficerId, 'N/A')AS GRTOfficerId,isnull(b.GRTOfficerName, 'N/A')AS GRTOfficerName, isnull(convert(CHAR, b.GRTDate), 'N/A')AS GRTDate, isnull(b.GRTUser, 'N/A')AS GRTUser, isnull(convert(CHAR, b.GRTTime), 'N/A')AS GRTTime, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')AS CompanyURL,  (SELECT replace(ReportValue, '~/', '')AS ImageFolderLocation FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberAadharImageFolder')AS ImageFolderLocation, (SELECT replace(ReportValue, '~/', '')AS KYCFolderLocation FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')AS KYCFolderLocation, isnull(a.MemberPOIType, 'N/A')AS MemberPOIType,isnull(a.MemberPOINo, 'N/A')AS MemberPOINo, isnull(a.MemberPOAType, 'N/A')AS MemberPOAType, isnull(a.MemberPOANo, 'N/A')AS MemberPOANo,isnull(a.MemberAadharPhoto, 'N/A')AS MemberAadharPhoto, isnull(a.MemberPhoto, 'N/A')AS MemberPhoto, isnull(a.MemberSignature, 'N/A') AS MemberSignature, isnull(a.MemberPOIFront, 'N/A')AS MemberPOIFront, isnull(a.MemberPOIBack, 'N/A')AS MemberPOIBack, isnull(a.MemberPOAFront, 'N/A') AS  MemberPOAFront, isnull(a.MemberPOABack, 'N/A')AS MemberPOABack, isnull(a.MemberBankPassBook, 'N/A')AS MemberBankPassBook, isnull(a.NomineePOIType, 'N/A') AS NomineePOIType, isnull(a.NomineePOINo, 'N/A')AS NomineePOINo, isnull(a.NomineePOAType, 'N/A')AS NomineePOAType, isnull(a.NomineePOANo, 'N/A')AS NomineePOANo,isnull(a.NomineeAadharPhoto, 'N/A')AS NomineeAadharPhoto, isnull(a.NomineePhoto, 'N/A')AS NomineePhoto, isnull(a.NomineeSignature, 'N/A')AS NomineeSignature,isnull(a.NomineePOIFront, 'N/A')AS NomineePOIFront, isnull(a.NomineePOIBack, 'N/A')AS NomineePOIBack, isnull(a.NomineePOAFront, 'N/A')AS NomineePOAFront,isnull(a.NomineePOABack, 'N/A')AS NomineePOABack, isnull(a.MemberNomineeJointPhoto, 'N/A')AS MemberNomineeJointPhoto, isnull(a.KYCStatus, 'N/A')AS KYCStatus,isnull(a.KYCRemark, 'N/A')AS KYCRemark, rtrim(isnull(convert(CHAR, a.KYCTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.KYCTime, 108), 'N/A'))AS KYCTime,isnull(a.KYCUser, 'N/A')AS KYCUser, isnull(convert(CHAR, a.DropOutDate, 106), 'N/A')AS DropOutDate, isnull(a.DropOutRemark, 'N/A')AS DropOutRemark,isnull(a.DropOutUser, 'N/A')AS DropOutUser, rtrim(isnull(convert(CHAR, a.DropOutTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.DropOutTime, 108), 'N/A'))AS DropOutTime,isnull(b.MemberId, 'N/A')AS MemberId, isnull(b.MemberName, 'N/A')AS MemberName, isnull(b.MemberLoanStatus, 'N/A')AS MemberLoanStatus,isnull(b.MemberLoginStatus, 'N/A')AS MemberLoginStatus, isnull(b.MemberWebLogin, 'N/A')AS MemberWebLogin, isnull(b.MemberAppLogin, 'N/A')AS MemberAppLogin, isnull(b.MemberPassword, 'N/A')AS MemberPassword, isnull(b.LoanPurpose, 'N/A')AS LoanPurpose, isnull(convert(CHAR, b.LoanAmount), 'N/A')AS LoanAmount, isnull(convert(CHAR, b.MemberDOM, 106), 'N/A')AS MemberDOM,isnull(b.SpouseName, 'N/A')AS SpouseName, isnull(b.MemberEducation, 'N/A')AS MemberEducation,isnull(b.MemberReligion, 'N/A')AS MemberReligion, isnull(b.MemberCategory, 'N/A')AS MemberCategory, isnull(b.MemberMaritalStatus, 'N/A')AS MemberMaritalStatus, isnull(b.NomineeIsMinor, 'N/A')AS NomineeIsMinor, isnull(b.NomineeEducation, 'N/A')AS NomineeEducation,isnull(b.NomineeMinorGuardian, 'N/A')AS NomineeMinorGuardian, isnull(b.NomineeAddress, 'N/A')AS NomineeAddress,isnull(convert(CHAR, b.NomineeDistrictId), 'N/A')AS NomineeDistrictId, isnull(b.NomineeDistrictName, 'N/A')AS NomineeDistrictName,isnull(convert(CHAR, b.NomineeStateId), 'N/A')AS NomineeStateId, isnull(b.NomineeStateName, 'N/A')AS NomineeStateName,isnull(b.NomineePinCode, 'N/A')AS NomineePinCode, isnull(b.MaikaPersonName, 'N/A')AS MaikaPersonName, isnull(b.MaikaPersonContact, 'N/A')AS MaikaPersonContact, isnull(b.MaikaAddress, 'N/A')AS MaikaAddress, isnull(b.BankAccountType, 'N/A')AS BankAccountType,isnull(convert(CHAR, b.MemberBankId), 'N/A')AS MemberBankId, isnull(b.MemberBankName, 'N/A')AS MemberBankName,isnull(b.BankAccountNo, 'N/A')AS BankAccountNo, isnull(b.BankIFSCCode, 'N/A')AS BankIFSCCode, isnull(b.BankBranchName, 'N/A')AS BankBranchName, isnull(b.BankBranchAddress, 'N/A')AS BankBranchAddress, isnull(b.LocationType, 'N/A')AS LocationType, isnull(b.PostalAddress, 'N/A')AS PostalAddress, isnull(b.PostalHouseNo, 'N/A')AS PostalHouseNo, isnull(b.PostalVillageName, 'N/A')AS PostalVillageName, isnull(b.PostalPostOffice, 'N/A')AS PostalPostOffice, isnull(b.PostalAreaName, 'N/A')AS PostalAreaName, isnull(b.PostalLandMark, 'N/A')AS PostalLandMark, isnull(b.PostalCityName, 'N/A')AS PostalCityName, isnull(convert(CHAR, b.PostalDistrictId), 'N/A')AS PostalDistrictId, isnull(b.PostalDistrictName, 'N/A')AS PostalDistrictName,isnull(convert(CHAR, b.PostalStateId), 'N/A')AS PostalStateId, isnull(b.PostalStateName, 'N/A')AS PostalStateName,isnull(b.PostalPinCode, 'N/A')AS PostalPinCode, isnull(b.PermanentSameAsPostal, 'N/A')AS PermanentSameAsPostal,isnull(b.PermanentAddress, 'N/A')AS PermanentAddress, isnull(b.PermanentHouseNo, 'N/A')AS PermanentHouseNo,isnull(b.PermanentVillageName, 'N/A')AS PermanentVillageName, isnull(b.PermanentPostOffice, 'N/A')AS PermanentPostOffice,isnull(b.PermanentAreaName, 'N/A')AS PermanentAreaName, isnull(b.PermanentLandMark, 'N/A')AS PermanentLandMark,isnull(b.PermanentCityName, 'N/A')AS PermanentCityName, isnull(convert(CHAR, b.PermanentDistrictId), 'N/A')AS PermanentDistrictId,isnull(b.PermanentDistrictName, 'N/A')AS PermanentDistrictName, isnull(convert(CHAR, b.PermanentStateId), 'N/A')AS PermanentStateId, isnull(b.PermanentStateName, 'N/A')AS PermanentStateName, isnull(b.PermanentPinCode, 'N/A')AS PermanentPinCode,isnull(c.ToiletFacility, 'N/A')AS ToiletFacility, isnull(c.WaterFacility, 'N/A')AS WaterFacility, isnull(c.WaterPurification, 'N/A')AS WaterPurification, isnull(c.ElectricityConnection, 'N/A')AS ElectricityConnection, isnull(c.SolarPanel, 'N/A')AS SolarPanel,isnull(c.FoodPreparation, 'N/A')AS FoodPreparation, isnull(c.EligibleChildren, 'N/A')AS EligibleChildren, isnull(c.EligibleGirlChild, 'N/A')AS EligibleGirlChild, isnull(c.LivingType, 'N/A')AS LivingType, isnull(c.HouseType, 'N/A')AS HouseType,isnull(c.NumberOfRoom, 'N/A')AS NumberOfRoom, isnull(c.LiveStock, 'N/A')AS LiveStock, isnull(c.NoOfVehicles, 'N/A')AS NoOfVehicles,isnull(c.LandInAcres, 'N/A')AS LandInAcres, isnull(c.NoOfChildren, 'N/A')AS NoOfChildren, isnull(c.Siblings, 'N/A')AS Siblings,isnull(c.MembersInFamily, 'N/A')AS MembersInFamily, isnull(c.WorkingMember, 'N/A')AS WorkingMember, isnull(c.MemberReputation, 'N/A')AS MemberReputation, isnull(c.WorkingStatus, 'N/A')AS WorkingStatus, isnull(c.BusinessSalaried, 'N/A')AS BusinessSalaried,isnull(c.WorkingProfile, 'N/A')AS WorkingProfile, isnull(c.WorkingSince, 'N/A')AS WorkingSince,isnull(c.ParentalBusiness, 'N/A')AS ParentalBusiness, isnull(c.PresentResidence, 'N/A')AS PresentResidence, isnull(c.MonthlySavings, 'N/A')AS MonthlySavings, isnull(c.ActiveLoanBank, 'N/A')AS ActiveLoanBank, isnull(c.BorrowFrequently, 'N/A')AS BorrowFrequently, isnull(c.InformalLenders, 'N/A')AS InformalLenders, isnull(convert(CHAR, c.FamilyBusinessIncome), 'N/A')AS FamilyBusinessIncome, isnull(convert(CHAR, c.SalaryPensionIncome), 'N/A')AS SalaryPensionIncome, isnull(convert(CHAR, c.WagesIncome), 'N/A')AS WagesIncome, isnull(convert(CHAR, c.OtherIncome), 'N/A')AS OtherIncome, isnull(convert(CHAR, c.Salary), 'N/A')AS Salary, isnull(convert(CHAR, c.Rent), 'N/A')AS Rent,isnull(convert(CHAR, c.Scholarship), 'N/A')AS Scholarship, isnull(convert(CHAR, c.GovernmentScheme), 'N/A')AS GovernmentScheme, isnull(convert(CHAR, c.Agriculture), 'N/A')AS Agriculture, isnull(convert(CHAR, c.Other), 'N/A')AS Other, isnull(convert(CHAR, c.TotalIncome), 'N/A')AS TotalIncome, isnull(convert(CHAR, c.Food), 'N/A')AS Food,isnull(convert(CHAR, c.Education), 'N/A')AS Education, isnull(convert(CHAR, c.Health), 'N/A')AS Health,isnull(convert(CHAR, c.EMIOfLoan), 'N/A')AS EMIOfLoan, isnull(convert(CHAR, c.HouseRent), 'N/A')AS HouseRent,isnull(convert(CHAR, c.ElectricityTax), 'N/A')AS ElectricityTax, isnull(convert(CHAR, c.WaterTax), 'N/A')AS WaterTax,isnull(convert(CHAR, c.PartyFucntion), 'N/A')AS PartyFucntion, isnull(convert(CHAR, c.FareCloth), 'N/A')AS FareCloth,isnull(convert(CHAR, c.OtherExpenses), 'N/A')AS OtherExpenses, isnull(convert(CHAR, c.TotalExpenses), 'N/A')AS TotalExpenses,a.MemberNo, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberFullDetailHTML')AS HTMLReportPageName FROM GroupLoanMemberDetail a WITH(nolock)LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanMemberFinance c WITH(nolock) ON a.MemberId = c.MemberId WHERE a.MemberId='M101000119' 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_ghkbelql
StackTrace:    at GroupLoan_GroupMemberRegistrationDetail.FillMemberDetail()
TargetSite: Void FillMemberDetail()

Time: 07/11/2025 01:51:00 PM
PageName: DataTableResult
String str:  SELECT isnull(a.BranchId,'N/A')AS BranchId, isnull(a.BranchName,'N/A')AS BranchName, isnull(a.GroupOfficerId,'N/A')AS GroupOfficerId, isnull(a.GroupOfficerName, 'N/A')AS GroupOfficerName, isnull(a.CenterId, 'N/A')AS CenterId, isnull(a.CenterName, 'N/A')AS CenterName,  isnull(a.GroupName, 'N/A')AS GroupName, isnull(a.MemberFormNo, 'N/A')AS MemberFormNo, isnull(a.OtherMemberId, 'N/A')AS OtherMemberId, isnull(a.IdType, 'N/A')AS IdType, isnull(a.MemberId, 'N/A')AS MemberId, isnull(convert(CHAR, a.MemberJoinDate, 106), 'N/A')AS MemberJoinDate, isnull(a.MemberSalutation, 'N/A')AS MemberSalutation, isnull(a.MemberName, 'N/A')AS MemberName, isnull(a.GuardianSalutation, 'N/A')AS GuardianSalutation, isnull(a.MemberGuardianName, 'N/A')AS MemberGuardianName, isnull(a.MemberGender, 'N/A')AS MemberGender, isnull(convert(CHAR, a.MemberDOB, 106), 'N/A')AS MemberDOB, isnull(convert(CHAR, a.MemberAge), 'N/A')AS MemberAge, isnull(a.MemberMobileNo, 'N/A')AS MemberMobileNo, isnull(a.MemberOccupation, 'N/A')AS MemberOccupation, isnull(convert(CHAR, a.MemberAnnualIncome), 'N/A')AS MemberAnnualIncome, isnull(convert(CHAR, a.FamilyAnnualExpence), 'N/A')AS FamilyAnnualExpence, isnull(a.NomineeSalutation, 'N/A')AS NomineeSalutation, isnull(a.NomineeName, 'N/A')AS NomineeName, isnull(a.NomineeGuardianSalutation, 'N/A')AS  NomineeGuardianSalutation, isnull(a.NomineeGuardianName, 'N/A')AS NomineeGuardianName, isnull(a.NomineeGender, 'N/A')AS NomineeGender, isnull(convert(CHAR, a.NomineeDOB, 106), 'N/A')AS NomineeDOB, isnull(convert(CHAR, a.NomineeAge), 'N/A')AS NomineeAge, isnull(convert(CHAR, a.NomineeAnnualIncome), 'N/A') AS NomineeAnnualIncome, isnull(a.NomineeRelation, 'N/A')AS NomineeRelation, isnull(a.NomineeMobileNo, 'N/A')AS NomineeMobileNo, isnull(a.NomineeOccupation, 'N/A')AS NomineeOccupation, isnull(a.NomineeAadharNo, 'N/A')AS NomineeAadharNo,isnull(a.NomineeVoterIdNo, 'N/A')AS NomineeVoterIdNo, isnull(a.NomineePANNo, 'N/A')AS NomineePANNo, isnull(a.NomineeDLNo, 'N/A')AS NomineeDLNo,isnull(a.MemberAadharNo, 'N/A')AS MemberAadharNo, isnull(a.MemberPanNo, 'N/A')AS MemberPanNo, isnull(a.MemberVoterIdNo, 'N/A')AS MemberVoterIdNo,isnull(a.MemberDLNo, 'N/A')AS MemberDLNo, isnull(a.RationCard, 'N/A')AS RationCard, isnull(a.ElectricityBill, 'N/A')AS ElectricityBill,isnull(a.MemberProfileStatus, 'N/A')AS MemberProfileStatus, isnull(a.MemberAddress, 'N/A')AS MemberAddress, isnull(a.MemberLatitude, 'N/A')AS MemberLatitude,isnull(a.MemberLongitude, 'N/A')AS MemberLongitude, isnull(a.EntryUser, 'N/A')AS EntryUser,rtrim(isnull(convert(CHAR, a.EntryTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.EntryTime, 108), 'N/A'))AS EntryTime, isnull(convert(CHAR, b.GroupJoinDate, 106), 'N/A')AS GroupJoinDate, isnull(b.GroupUser, 'N/A')AS GroupUser, rtrim(isnull(convert(CHAR, b.GroupTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, b.GroupTime, 108), 'N/A'))AS GroupTime, isnull(b.GroupStatus, 'N/A') AS GroupStatus, isnull(b.CGTOfficerId, 'N/A')AS CGTOfficerId, isnull(b.CGTOfficerName, 'N/A')AS CGTOfficerName, isnull(convert(CHAR, b.CGTDate, 106), 'N/A')AS CGTDate, isnull(b.CGTUser, 'N/A')AS CGTUser, isnull(convert(CHAR, b.CGTTime), 'N/A')AS CGTTime, isnull(b.GRTOfficerId, 'N/A')AS GRTOfficerId,isnull(b.GRTOfficerName, 'N/A')AS GRTOfficerName, isnull(convert(CHAR, b.GRTDate), 'N/A')AS GRTDate, isnull(b.GRTUser, 'N/A')AS GRTUser, isnull(convert(CHAR, b.GRTTime), 'N/A')AS GRTTime, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')AS CompanyURL,  (SELECT replace(ReportValue, '~/', '')AS ImageFolderLocation FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberAadharImageFolder')AS ImageFolderLocation, (SELECT replace(ReportValue, '~/', '')AS KYCFolderLocation FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')AS KYCFolderLocation, isnull(a.MemberPOIType, 'N/A')AS MemberPOIType,isnull(a.MemberPOINo, 'N/A')AS MemberPOINo, isnull(a.MemberPOAType, 'N/A')AS MemberPOAType, isnull(a.MemberPOANo, 'N/A')AS MemberPOANo,isnull(a.MemberAadharPhoto, 'N/A')AS MemberAadharPhoto, isnull(a.MemberPhoto, 'N/A')AS MemberPhoto, isnull(a.MemberSignature, 'N/A') AS MemberSignature, isnull(a.MemberPOIFront, 'N/A')AS MemberPOIFront, isnull(a.MemberPOIBack, 'N/A')AS MemberPOIBack, isnull(a.MemberPOAFront, 'N/A') AS  MemberPOAFront, isnull(a.MemberPOABack, 'N/A')AS MemberPOABack, isnull(a.MemberBankPassBook, 'N/A')AS MemberBankPassBook, isnull(a.NomineePOIType, 'N/A') AS NomineePOIType, isnull(a.NomineePOINo, 'N/A')AS NomineePOINo, isnull(a.NomineePOAType, 'N/A')AS NomineePOAType, isnull(a.NomineePOANo, 'N/A')AS NomineePOANo,isnull(a.NomineeAadharPhoto, 'N/A')AS NomineeAadharPhoto, isnull(a.NomineePhoto, 'N/A')AS NomineePhoto, isnull(a.NomineeSignature, 'N/A')AS NomineeSignature,isnull(a.NomineePOIFront, 'N/A')AS NomineePOIFront, isnull(a.NomineePOIBack, 'N/A')AS NomineePOIBack, isnull(a.NomineePOAFront, 'N/A')AS NomineePOAFront,isnull(a.NomineePOABack, 'N/A')AS NomineePOABack, isnull(a.MemberNomineeJointPhoto, 'N/A')AS MemberNomineeJointPhoto, isnull(a.KYCStatus, 'N/A')AS KYCStatus,isnull(a.KYCRemark, 'N/A')AS KYCRemark, rtrim(isnull(convert(CHAR, a.KYCTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.KYCTime, 108), 'N/A'))AS KYCTime,isnull(a.KYCUser, 'N/A')AS KYCUser, isnull(convert(CHAR, a.DropOutDate, 106), 'N/A')AS DropOutDate, isnull(a.DropOutRemark, 'N/A')AS DropOutRemark,isnull(a.DropOutUser, 'N/A')AS DropOutUser, rtrim(isnull(convert(CHAR, a.DropOutTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.DropOutTime, 108), 'N/A'))AS DropOutTime,isnull(b.MemberId, 'N/A')AS MemberId, isnull(b.MemberName, 'N/A')AS MemberName, isnull(b.MemberLoanStatus, 'N/A')AS MemberLoanStatus,isnull(b.MemberLoginStatus, 'N/A')AS MemberLoginStatus, isnull(b.MemberWebLogin, 'N/A')AS MemberWebLogin, isnull(b.MemberAppLogin, 'N/A')AS MemberAppLogin, isnull(b.MemberPassword, 'N/A')AS MemberPassword, isnull(b.LoanPurpose, 'N/A')AS LoanPurpose, isnull(convert(CHAR, b.LoanAmount), 'N/A')AS LoanAmount, isnull(convert(CHAR, b.MemberDOM, 106), 'N/A')AS MemberDOM,isnull(b.SpouseName, 'N/A')AS SpouseName, isnull(b.MemberEducation, 'N/A')AS MemberEducation,isnull(b.MemberReligion, 'N/A')AS MemberReligion, isnull(b.MemberCategory, 'N/A')AS MemberCategory, isnull(b.MemberMaritalStatus, 'N/A')AS MemberMaritalStatus, isnull(b.NomineeIsMinor, 'N/A')AS NomineeIsMinor, isnull(b.NomineeEducation, 'N/A')AS NomineeEducation,isnull(b.NomineeMinorGuardian, 'N/A')AS NomineeMinorGuardian, isnull(b.NomineeAddress, 'N/A')AS NomineeAddress,isnull(convert(CHAR, b.NomineeDistrictId), 'N/A')AS NomineeDistrictId, isnull(b.NomineeDistrictName, 'N/A')AS NomineeDistrictName,isnull(convert(CHAR, b.NomineeStateId), 'N/A')AS NomineeStateId, isnull(b.NomineeStateName, 'N/A')AS NomineeStateName,isnull(b.NomineePinCode, 'N/A')AS NomineePinCode, isnull(b.MaikaPersonName, 'N/A')AS MaikaPersonName, isnull(b.MaikaPersonContact, 'N/A')AS MaikaPersonContact, isnull(b.MaikaAddress, 'N/A')AS MaikaAddress, isnull(b.BankAccountType, 'N/A')AS BankAccountType,isnull(convert(CHAR, b.MemberBankId), 'N/A')AS MemberBankId, isnull(b.MemberBankName, 'N/A')AS MemberBankName,isnull(b.BankAccountNo, 'N/A')AS BankAccountNo, isnull(b.BankIFSCCode, 'N/A')AS BankIFSCCode, isnull(b.BankBranchName, 'N/A')AS BankBranchName, isnull(b.BankBranchAddress, 'N/A')AS BankBranchAddress, isnull(b.LocationType, 'N/A')AS LocationType, isnull(b.PostalAddress, 'N/A')AS PostalAddress, isnull(b.PostalHouseNo, 'N/A')AS PostalHouseNo, isnull(b.PostalVillageName, 'N/A')AS PostalVillageName, isnull(b.PostalPostOffice, 'N/A')AS PostalPostOffice, isnull(b.PostalAreaName, 'N/A')AS PostalAreaName, isnull(b.PostalLandMark, 'N/A')AS PostalLandMark, isnull(b.PostalCityName, 'N/A')AS PostalCityName, isnull(convert(CHAR, b.PostalDistrictId), 'N/A')AS PostalDistrictId, isnull(b.PostalDistrictName, 'N/A')AS PostalDistrictName,isnull(convert(CHAR, b.PostalStateId), 'N/A')AS PostalStateId, isnull(b.PostalStateName, 'N/A')AS PostalStateName,isnull(b.PostalPinCode, 'N/A')AS PostalPinCode, isnull(b.PermanentSameAsPostal, 'N/A')AS PermanentSameAsPostal,isnull(b.PermanentAddress, 'N/A')AS PermanentAddress, isnull(b.PermanentHouseNo, 'N/A')AS PermanentHouseNo,isnull(b.PermanentVillageName, 'N/A')AS PermanentVillageName, isnull(b.PermanentPostOffice, 'N/A')AS PermanentPostOffice,isnull(b.PermanentAreaName, 'N/A')AS PermanentAreaName, isnull(b.PermanentLandMark, 'N/A')AS PermanentLandMark,isnull(b.PermanentCityName, 'N/A')AS PermanentCityName, isnull(convert(CHAR, b.PermanentDistrictId), 'N/A')AS PermanentDistrictId,isnull(b.PermanentDistrictName, 'N/A')AS PermanentDistrictName, isnull(convert(CHAR, b.PermanentStateId), 'N/A')AS PermanentStateId, isnull(b.PermanentStateName, 'N/A')AS PermanentStateName, isnull(b.PermanentPinCode, 'N/A')AS PermanentPinCode,isnull(c.ToiletFacility, 'N/A')AS ToiletFacility, isnull(c.WaterFacility, 'N/A')AS WaterFacility, isnull(c.WaterPurification, 'N/A')AS WaterPurification, isnull(c.ElectricityConnection, 'N/A')AS ElectricityConnection, isnull(c.SolarPanel, 'N/A')AS SolarPanel,isnull(c.FoodPreparation, 'N/A')AS FoodPreparation, isnull(c.EligibleChildren, 'N/A')AS EligibleChildren, isnull(c.EligibleGirlChild, 'N/A')AS EligibleGirlChild, isnull(c.LivingType, 'N/A')AS LivingType, isnull(c.HouseType, 'N/A')AS HouseType,isnull(c.NumberOfRoom, 'N/A')AS NumberOfRoom, isnull(c.LiveStock, 'N/A')AS LiveStock, isnull(c.NoOfVehicles, 'N/A')AS NoOfVehicles,isnull(c.LandInAcres, 'N/A')AS LandInAcres, isnull(c.NoOfChildren, 'N/A')AS NoOfChildren, isnull(c.Siblings, 'N/A')AS Siblings,isnull(c.MembersInFamily, 'N/A')AS MembersInFamily, isnull(c.WorkingMember, 'N/A')AS WorkingMember, isnull(c.MemberReputation, 'N/A')AS MemberReputation, isnull(c.WorkingStatus, 'N/A')AS WorkingStatus, isnull(c.BusinessSalaried, 'N/A')AS BusinessSalaried,isnull(c.WorkingProfile, 'N/A')AS WorkingProfile, isnull(c.WorkingSince, 'N/A')AS WorkingSince,isnull(c.ParentalBusiness, 'N/A')AS ParentalBusiness, isnull(c.PresentResidence, 'N/A')AS PresentResidence, isnull(c.MonthlySavings, 'N/A')AS MonthlySavings, isnull(c.ActiveLoanBank, 'N/A')AS ActiveLoanBank, isnull(c.BorrowFrequently, 'N/A')AS BorrowFrequently, isnull(c.InformalLenders, 'N/A')AS InformalLenders, isnull(convert(CHAR, c.FamilyBusinessIncome), 'N/A')AS FamilyBusinessIncome, isnull(convert(CHAR, c.SalaryPensionIncome), 'N/A')AS SalaryPensionIncome, isnull(convert(CHAR, c.WagesIncome), 'N/A')AS WagesIncome, isnull(convert(CHAR, c.OtherIncome), 'N/A')AS OtherIncome, isnull(convert(CHAR, c.Salary), 'N/A')AS Salary, isnull(convert(CHAR, c.Rent), 'N/A')AS Rent,isnull(convert(CHAR, c.Scholarship), 'N/A')AS Scholarship, isnull(convert(CHAR, c.GovernmentScheme), 'N/A')AS GovernmentScheme, isnull(convert(CHAR, c.Agriculture), 'N/A')AS Agriculture, isnull(convert(CHAR, c.Other), 'N/A')AS Other, isnull(convert(CHAR, c.TotalIncome), 'N/A')AS TotalIncome, isnull(convert(CHAR, c.Food), 'N/A')AS Food,isnull(convert(CHAR, c.Education), 'N/A')AS Education, isnull(convert(CHAR, c.Health), 'N/A')AS Health,isnull(convert(CHAR, c.EMIOfLoan), 'N/A')AS EMIOfLoan, isnull(convert(CHAR, c.HouseRent), 'N/A')AS HouseRent,isnull(convert(CHAR, c.ElectricityTax), 'N/A')AS ElectricityTax, isnull(convert(CHAR, c.WaterTax), 'N/A')AS WaterTax,isnull(convert(CHAR, c.PartyFucntion), 'N/A')AS PartyFucntion, isnull(convert(CHAR, c.FareCloth), 'N/A')AS FareCloth,isnull(convert(CHAR, c.OtherExpenses), 'N/A')AS OtherExpenses, isnull(convert(CHAR, c.TotalExpenses), 'N/A')AS TotalExpenses,a.MemberNo, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberFullDetailHTML')AS HTMLReportPageName FROM GroupLoanMemberDetail a WITH(nolock)LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanMemberFinance c WITH(nolock) ON a.MemberId = c.MemberId WHERE a.MemberId='M101000119' 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid column name 'NomineeDistrictId'.
Invalid column name 'NomineeStateId'.
Invalid column name 'PostalDistrictId'.
Invalid column name 'PostalStateId'.
Invalid column name 'PermanentDistrictId'.
Invalid column name 'PermanentStateId'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 07/11/2025 01:51:00 PM
PageName: GroupLoan_GroupMemberRegistrationDetail
String str:  SELECT isnull(a.BranchId,'N/A')AS BranchId, isnull(a.BranchName,'N/A')AS BranchName, isnull(a.GroupOfficerId,'N/A')AS GroupOfficerId, isnull(a.GroupOfficerName, 'N/A')AS GroupOfficerName, isnull(a.CenterId, 'N/A')AS CenterId, isnull(a.CenterName, 'N/A')AS CenterName,  isnull(a.GroupName, 'N/A')AS GroupName, isnull(a.MemberFormNo, 'N/A')AS MemberFormNo, isnull(a.OtherMemberId, 'N/A')AS OtherMemberId, isnull(a.IdType, 'N/A')AS IdType, isnull(a.MemberId, 'N/A')AS MemberId, isnull(convert(CHAR, a.MemberJoinDate, 106), 'N/A')AS MemberJoinDate, isnull(a.MemberSalutation, 'N/A')AS MemberSalutation, isnull(a.MemberName, 'N/A')AS MemberName, isnull(a.GuardianSalutation, 'N/A')AS GuardianSalutation, isnull(a.MemberGuardianName, 'N/A')AS MemberGuardianName, isnull(a.MemberGender, 'N/A')AS MemberGender, isnull(convert(CHAR, a.MemberDOB, 106), 'N/A')AS MemberDOB, isnull(convert(CHAR, a.MemberAge), 'N/A')AS MemberAge, isnull(a.MemberMobileNo, 'N/A')AS MemberMobileNo, isnull(a.MemberOccupation, 'N/A')AS MemberOccupation, isnull(convert(CHAR, a.MemberAnnualIncome), 'N/A')AS MemberAnnualIncome, isnull(convert(CHAR, a.FamilyAnnualExpence), 'N/A')AS FamilyAnnualExpence, isnull(a.NomineeSalutation, 'N/A')AS NomineeSalutation, isnull(a.NomineeName, 'N/A')AS NomineeName, isnull(a.NomineeGuardianSalutation, 'N/A')AS  NomineeGuardianSalutation, isnull(a.NomineeGuardianName, 'N/A')AS NomineeGuardianName, isnull(a.NomineeGender, 'N/A')AS NomineeGender, isnull(convert(CHAR, a.NomineeDOB, 106), 'N/A')AS NomineeDOB, isnull(convert(CHAR, a.NomineeAge), 'N/A')AS NomineeAge, isnull(convert(CHAR, a.NomineeAnnualIncome), 'N/A') AS NomineeAnnualIncome, isnull(a.NomineeRelation, 'N/A')AS NomineeRelation, isnull(a.NomineeMobileNo, 'N/A')AS NomineeMobileNo, isnull(a.NomineeOccupation, 'N/A')AS NomineeOccupation, isnull(a.NomineeAadharNo, 'N/A')AS NomineeAadharNo,isnull(a.NomineeVoterIdNo, 'N/A')AS NomineeVoterIdNo, isnull(a.NomineePANNo, 'N/A')AS NomineePANNo, isnull(a.NomineeDLNo, 'N/A')AS NomineeDLNo,isnull(a.MemberAadharNo, 'N/A')AS MemberAadharNo, isnull(a.MemberPanNo, 'N/A')AS MemberPanNo, isnull(a.MemberVoterIdNo, 'N/A')AS MemberVoterIdNo,isnull(a.MemberDLNo, 'N/A')AS MemberDLNo, isnull(a.RationCard, 'N/A')AS RationCard, isnull(a.ElectricityBill, 'N/A')AS ElectricityBill,isnull(a.MemberProfileStatus, 'N/A')AS MemberProfileStatus, isnull(a.MemberAddress, 'N/A')AS MemberAddress, isnull(a.MemberLatitude, 'N/A')AS MemberLatitude,isnull(a.MemberLongitude, 'N/A')AS MemberLongitude, isnull(a.EntryUser, 'N/A')AS EntryUser,rtrim(isnull(convert(CHAR, a.EntryTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.EntryTime, 108), 'N/A'))AS EntryTime, isnull(convert(CHAR, b.GroupJoinDate, 106), 'N/A')AS GroupJoinDate, isnull(b.GroupUser, 'N/A')AS GroupUser, rtrim(isnull(convert(CHAR, b.GroupTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, b.GroupTime, 108), 'N/A'))AS GroupTime, isnull(b.GroupStatus, 'N/A') AS GroupStatus, isnull(b.CGTOfficerId, 'N/A')AS CGTOfficerId, isnull(b.CGTOfficerName, 'N/A')AS CGTOfficerName, isnull(convert(CHAR, b.CGTDate, 106), 'N/A')AS CGTDate, isnull(b.CGTUser, 'N/A')AS CGTUser, isnull(convert(CHAR, b.CGTTime), 'N/A')AS CGTTime, isnull(b.GRTOfficerId, 'N/A')AS GRTOfficerId,isnull(b.GRTOfficerName, 'N/A')AS GRTOfficerName, isnull(convert(CHAR, b.GRTDate), 'N/A')AS GRTDate, isnull(b.GRTUser, 'N/A')AS GRTUser, isnull(convert(CHAR, b.GRTTime), 'N/A')AS GRTTime, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')AS CompanyURL,  (SELECT replace(ReportValue, '~/', '')AS ImageFolderLocation FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberAadharImageFolder')AS ImageFolderLocation, (SELECT replace(ReportValue, '~/', '')AS KYCFolderLocation FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')AS KYCFolderLocation, isnull(a.MemberPOIType, 'N/A')AS MemberPOIType,isnull(a.MemberPOINo, 'N/A')AS MemberPOINo, isnull(a.MemberPOAType, 'N/A')AS MemberPOAType, isnull(a.MemberPOANo, 'N/A')AS MemberPOANo,isnull(a.MemberAadharPhoto, 'N/A')AS MemberAadharPhoto, isnull(a.MemberPhoto, 'N/A')AS MemberPhoto, isnull(a.MemberSignature, 'N/A') AS MemberSignature, isnull(a.MemberPOIFront, 'N/A')AS MemberPOIFront, isnull(a.MemberPOIBack, 'N/A')AS MemberPOIBack, isnull(a.MemberPOAFront, 'N/A') AS  MemberPOAFront, isnull(a.MemberPOABack, 'N/A')AS MemberPOABack, isnull(a.MemberBankPassBook, 'N/A')AS MemberBankPassBook, isnull(a.NomineePOIType, 'N/A') AS NomineePOIType, isnull(a.NomineePOINo, 'N/A')AS NomineePOINo, isnull(a.NomineePOAType, 'N/A')AS NomineePOAType, isnull(a.NomineePOANo, 'N/A')AS NomineePOANo,isnull(a.NomineeAadharPhoto, 'N/A')AS NomineeAadharPhoto, isnull(a.NomineePhoto, 'N/A')AS NomineePhoto, isnull(a.NomineeSignature, 'N/A')AS NomineeSignature,isnull(a.NomineePOIFront, 'N/A')AS NomineePOIFront, isnull(a.NomineePOIBack, 'N/A')AS NomineePOIBack, isnull(a.NomineePOAFront, 'N/A')AS NomineePOAFront,isnull(a.NomineePOABack, 'N/A')AS NomineePOABack, isnull(a.MemberNomineeJointPhoto, 'N/A')AS MemberNomineeJointPhoto, isnull(a.KYCStatus, 'N/A')AS KYCStatus,isnull(a.KYCRemark, 'N/A')AS KYCRemark, rtrim(isnull(convert(CHAR, a.KYCTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.KYCTime, 108), 'N/A'))AS KYCTime,isnull(a.KYCUser, 'N/A')AS KYCUser, isnull(convert(CHAR, a.DropOutDate, 106), 'N/A')AS DropOutDate, isnull(a.DropOutRemark, 'N/A')AS DropOutRemark,isnull(a.DropOutUser, 'N/A')AS DropOutUser, rtrim(isnull(convert(CHAR, a.DropOutTime, 106), 'N/A')) + ' ' + rtrim(isnull(convert(CHAR, a.DropOutTime, 108), 'N/A'))AS DropOutTime,isnull(b.MemberId, 'N/A')AS MemberId, isnull(b.MemberName, 'N/A')AS MemberName, isnull(b.MemberLoanStatus, 'N/A')AS MemberLoanStatus,isnull(b.MemberLoginStatus, 'N/A')AS MemberLoginStatus, isnull(b.MemberWebLogin, 'N/A')AS MemberWebLogin, isnull(b.MemberAppLogin, 'N/A')AS MemberAppLogin, isnull(b.MemberPassword, 'N/A')AS MemberPassword, isnull(b.LoanPurpose, 'N/A')AS LoanPurpose, isnull(convert(CHAR, b.LoanAmount), 'N/A')AS LoanAmount, isnull(convert(CHAR, b.MemberDOM, 106), 'N/A')AS MemberDOM,isnull(b.SpouseName, 'N/A')AS SpouseName, isnull(b.MemberEducation, 'N/A')AS MemberEducation,isnull(b.MemberReligion, 'N/A')AS MemberReligion, isnull(b.MemberCategory, 'N/A')AS MemberCategory, isnull(b.MemberMaritalStatus, 'N/A')AS MemberMaritalStatus, isnull(b.NomineeIsMinor, 'N/A')AS NomineeIsMinor, isnull(b.NomineeEducation, 'N/A')AS NomineeEducation,isnull(b.NomineeMinorGuardian, 'N/A')AS NomineeMinorGuardian, isnull(b.NomineeAddress, 'N/A')AS NomineeAddress,isnull(convert(CHAR, b.NomineeDistrictId), 'N/A')AS NomineeDistrictId, isnull(b.NomineeDistrictName, 'N/A')AS NomineeDistrictName,isnull(convert(CHAR, b.NomineeStateId), 'N/A')AS NomineeStateId, isnull(b.NomineeStateName, 'N/A')AS NomineeStateName,isnull(b.NomineePinCode, 'N/A')AS NomineePinCode, isnull(b.MaikaPersonName, 'N/A')AS MaikaPersonName, isnull(b.MaikaPersonContact, 'N/A')AS MaikaPersonContact, isnull(b.MaikaAddress, 'N/A')AS MaikaAddress, isnull(b.BankAccountType, 'N/A')AS BankAccountType,isnull(convert(CHAR, b.MemberBankId), 'N/A')AS MemberBankId, isnull(b.MemberBankName, 'N/A')AS MemberBankName,isnull(b.BankAccountNo, 'N/A')AS BankAccountNo, isnull(b.BankIFSCCode, 'N/A')AS BankIFSCCode, isnull(b.BankBranchName, 'N/A')AS BankBranchName, isnull(b.BankBranchAddress, 'N/A')AS BankBranchAddress, isnull(b.LocationType, 'N/A')AS LocationType, isnull(b.PostalAddress, 'N/A')AS PostalAddress, isnull(b.PostalHouseNo, 'N/A')AS PostalHouseNo, isnull(b.PostalVillageName, 'N/A')AS PostalVillageName, isnull(b.PostalPostOffice, 'N/A')AS PostalPostOffice, isnull(b.PostalAreaName, 'N/A')AS PostalAreaName, isnull(b.PostalLandMark, 'N/A')AS PostalLandMark, isnull(b.PostalCityName, 'N/A')AS PostalCityName, isnull(convert(CHAR, b.PostalDistrictId), 'N/A')AS PostalDistrictId, isnull(b.PostalDistrictName, 'N/A')AS PostalDistrictName,isnull(convert(CHAR, b.PostalStateId), 'N/A')AS PostalStateId, isnull(b.PostalStateName, 'N/A')AS PostalStateName,isnull(b.PostalPinCode, 'N/A')AS PostalPinCode, isnull(b.PermanentSameAsPostal, 'N/A')AS PermanentSameAsPostal,isnull(b.PermanentAddress, 'N/A')AS PermanentAddress, isnull(b.PermanentHouseNo, 'N/A')AS PermanentHouseNo,isnull(b.PermanentVillageName, 'N/A')AS PermanentVillageName, isnull(b.PermanentPostOffice, 'N/A')AS PermanentPostOffice,isnull(b.PermanentAreaName, 'N/A')AS PermanentAreaName, isnull(b.PermanentLandMark, 'N/A')AS PermanentLandMark,isnull(b.PermanentCityName, 'N/A')AS PermanentCityName, isnull(convert(CHAR, b.PermanentDistrictId), 'N/A')AS PermanentDistrictId,isnull(b.PermanentDistrictName, 'N/A')AS PermanentDistrictName, isnull(convert(CHAR, b.PermanentStateId), 'N/A')AS PermanentStateId, isnull(b.PermanentStateName, 'N/A')AS PermanentStateName, isnull(b.PermanentPinCode, 'N/A')AS PermanentPinCode,isnull(c.ToiletFacility, 'N/A')AS ToiletFacility, isnull(c.WaterFacility, 'N/A')AS WaterFacility, isnull(c.WaterPurification, 'N/A')AS WaterPurification, isnull(c.ElectricityConnection, 'N/A')AS ElectricityConnection, isnull(c.SolarPanel, 'N/A')AS SolarPanel,isnull(c.FoodPreparation, 'N/A')AS FoodPreparation, isnull(c.EligibleChildren, 'N/A')AS EligibleChildren, isnull(c.EligibleGirlChild, 'N/A')AS EligibleGirlChild, isnull(c.LivingType, 'N/A')AS LivingType, isnull(c.HouseType, 'N/A')AS HouseType,isnull(c.NumberOfRoom, 'N/A')AS NumberOfRoom, isnull(c.LiveStock, 'N/A')AS LiveStock, isnull(c.NoOfVehicles, 'N/A')AS NoOfVehicles,isnull(c.LandInAcres, 'N/A')AS LandInAcres, isnull(c.NoOfChildren, 'N/A')AS NoOfChildren, isnull(c.Siblings, 'N/A')AS Siblings,isnull(c.MembersInFamily, 'N/A')AS MembersInFamily, isnull(c.WorkingMember, 'N/A')AS WorkingMember, isnull(c.MemberReputation, 'N/A')AS MemberReputation, isnull(c.WorkingStatus, 'N/A')AS WorkingStatus, isnull(c.BusinessSalaried, 'N/A')AS BusinessSalaried,isnull(c.WorkingProfile, 'N/A')AS WorkingProfile, isnull(c.WorkingSince, 'N/A')AS WorkingSince,isnull(c.ParentalBusiness, 'N/A')AS ParentalBusiness, isnull(c.PresentResidence, 'N/A')AS PresentResidence, isnull(c.MonthlySavings, 'N/A')AS MonthlySavings, isnull(c.ActiveLoanBank, 'N/A')AS ActiveLoanBank, isnull(c.BorrowFrequently, 'N/A')AS BorrowFrequently, isnull(c.InformalLenders, 'N/A')AS InformalLenders, isnull(convert(CHAR, c.FamilyBusinessIncome), 'N/A')AS FamilyBusinessIncome, isnull(convert(CHAR, c.SalaryPensionIncome), 'N/A')AS SalaryPensionIncome, isnull(convert(CHAR, c.WagesIncome), 'N/A')AS WagesIncome, isnull(convert(CHAR, c.OtherIncome), 'N/A')AS OtherIncome, isnull(convert(CHAR, c.Salary), 'N/A')AS Salary, isnull(convert(CHAR, c.Rent), 'N/A')AS Rent,isnull(convert(CHAR, c.Scholarship), 'N/A')AS Scholarship, isnull(convert(CHAR, c.GovernmentScheme), 'N/A')AS GovernmentScheme, isnull(convert(CHAR, c.Agriculture), 'N/A')AS Agriculture, isnull(convert(CHAR, c.Other), 'N/A')AS Other, isnull(convert(CHAR, c.TotalIncome), 'N/A')AS TotalIncome, isnull(convert(CHAR, c.Food), 'N/A')AS Food,isnull(convert(CHAR, c.Education), 'N/A')AS Education, isnull(convert(CHAR, c.Health), 'N/A')AS Health,isnull(convert(CHAR, c.EMIOfLoan), 'N/A')AS EMIOfLoan, isnull(convert(CHAR, c.HouseRent), 'N/A')AS HouseRent,isnull(convert(CHAR, c.ElectricityTax), 'N/A')AS ElectricityTax, isnull(convert(CHAR, c.WaterTax), 'N/A')AS WaterTax,isnull(convert(CHAR, c.PartyFucntion), 'N/A')AS PartyFucntion, isnull(convert(CHAR, c.FareCloth), 'N/A')AS FareCloth,isnull(convert(CHAR, c.OtherExpenses), 'N/A')AS OtherExpenses, isnull(convert(CHAR, c.TotalExpenses), 'N/A')AS TotalExpenses,a.MemberNo, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberFullDetailHTML')AS HTMLReportPageName FROM GroupLoanMemberDetail a WITH(nolock)LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanMemberFinance c WITH(nolock) ON a.MemberId = c.MemberId WHERE a.MemberId='M101000119' 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_ghkbelql
StackTrace:    at GroupLoan_GroupMemberRegistrationDetail.FillMemberDetail()
TargetSite: Void FillMemberDetail()

Time: 07/11/2025 05:59:35 PM
PageName: Account_BranchFundTransferRequest
String str:  SELECT Count(1)AS Nos FROM BranchFundTransferDetail WHERE TransferStatus='Pending' AND FromHeadId='111002' AND TransferAmount='1500' AND ToHeadId='111001' ; SELECT SUM(Debit-Credit)AS BalanceAmount FROM F2526VoucherDetail WHERE HeadId='111002' AND TransDate<'11/2/2025 12:00:00 AM' ; SELECT AccountHeadId, AccountHeadName FROM AccountHeadIdMaster WHERE AccountHeadType='BranchFundTransfer' ; SELECT a.VoucherInitial+right(('00000000'+rtrim(convert(CHAR,isnull(a.VoucherCounter,0)+1))),8)AS VoucherId FROM FinancialYearMaster a WHERE a.TableName='2526' ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDecimal(String value)
   at Account_BranchFundTransferRequest.btnSubmit_Click(Object sender, EventArgs e)
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 07/11/2025 06:09:06 PM
PageName: Account_BranchFundTransferRequest
String str:  SELECT Count(1)AS Nos FROM BranchFundTransferDetail WHERE TransferStatus='Pending' AND FromHeadId='111002' AND TransferAmount='1500' AND ToHeadId='111001' ; SELECT SUM(Debit-Credit)AS BalanceAmount FROM F2526VoucherDetail WHERE HeadId='111002' AND TransDate<'11/2/2025 12:00:00 AM' ; SELECT AccountHeadId, AccountHeadName FROM AccountHeadIdMaster WHERE AccountHeadType='BranchFundTransfer' ; SELECT a.VoucherInitial+right(('00000000'+rtrim(convert(CHAR,isnull(a.VoucherCounter,0)+1))),8)AS VoucherId FROM FinancialYearMaster a WHERE a.TableName='2526' ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDecimal(String value)
   at Account_BranchFundTransferRequest.btnSubmit_Click(Object sender, EventArgs e)
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 10/11/2025 11:39:06 AM
PageName: AdminLogOut
String str: 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Thread was being aborted.
Source: mscorlib
StackTrace:    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.AbortCurrentThread()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at AdminLogOut.btnLogout_Click(Object sender, EventArgs e)
TargetSite: Void AbortInternal()

Time: 13/11/2025 01:23:03 PM
PageName: AdminLogOut
String str: 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Thread was being aborted.
Source: mscorlib
StackTrace:    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.AbortCurrentThread()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at AdminLogOut.btnLogout_Click(Object sender, EventArgs e)
TargetSite: Void AbortInternal()