Time: 08/05/2025 05:32:59 PM
PageName: DataTableResult
String str:  SELECT a.MemberId, a.MemberName, a.NomineeName, a.ApplicationId, a.LoanId, a.LoanCycle, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.InterestMethod, a.LoanPurpose, a.LoanFunder, a.ApplicationAmount, dbo.FunNumberOfCharacterFromNumber(a.ApplicationAmount/2000)AS ApplicationAmountStr, convert(CHAR,a.ApplicationDate,106)AS ApplicationDate, a.ApplicationRemark, CASE WHEN a.ApplicationDoc1!='' THEN 'View' ELSE '' END AS Doc1, (SELECT CompanyURL+replace(GroupMemberKYCFolder,'~/','') FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1 )+a.MemberId+'/'+a.ApplicationDoc1 AS ApplicationDoc1, CASE WHEN a.ApplicationDoc2!='' THEN 'View' ELSE '' END AS Doc2, (SELECT CompanyURL+replace(GroupMemberKYCFolder,'~/','') FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1 )+a.MemberId+'/'+a.ApplicationDoc2 AS ApplicationDoc2, a.ApplicationEntryUser, rtrim(convert(CHAR,a.ApplicationEntryTime,106))+'-'+rtrim(convert(CHAR,a.ApplicationEntryTime,108))AS ApplicationEntryTime, a.LoanStatus, a.SanctionId, a.GroupName, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')' AS BranchName FROM GroupLoanAccount a WITH(nolock) WHERE a.GroupStatus='Group1' AND a.LoanStatus IN ('LoanApplied','LoanApproved','LoanFeePaid','LoanDisbursed','LoanClosed')  AND a.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY a.BranchName, a.LoanOfficerName, a.CenterName, a.GroupName, a.MemberName, a.LoanId 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid column name 'GroupStatus'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   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) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 174
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 08/05/2025 05:32:59 PM
PageName: GroupLoan_GroupLoanApplicationReport
String str:  SELECT a.MemberId, a.MemberName, a.NomineeName, a.ApplicationId, a.LoanId, a.LoanCycle, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.InterestMethod, a.LoanPurpose, a.LoanFunder, a.ApplicationAmount, dbo.FunNumberOfCharacterFromNumber(a.ApplicationAmount/2000)AS ApplicationAmountStr, convert(CHAR,a.ApplicationDate,106)AS ApplicationDate, a.ApplicationRemark, CASE WHEN a.ApplicationDoc1!='' THEN 'View' ELSE '' END AS Doc1, (SELECT CompanyURL+replace(GroupMemberKYCFolder,'~/','') FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1 )+a.MemberId+'/'+a.ApplicationDoc1 AS ApplicationDoc1, CASE WHEN a.ApplicationDoc2!='' THEN 'View' ELSE '' END AS Doc2, (SELECT CompanyURL+replace(GroupMemberKYCFolder,'~/','') FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1 )+a.MemberId+'/'+a.ApplicationDoc2 AS ApplicationDoc2, a.ApplicationEntryUser, rtrim(convert(CHAR,a.ApplicationEntryTime,106))+'-'+rtrim(convert(CHAR,a.ApplicationEntryTime,108))AS ApplicationEntryTime, a.LoanStatus, a.SanctionId, a.GroupName, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')' AS BranchName FROM GroupLoanAccount a WITH(nolock) WHERE a.GroupStatus='Group1' AND a.LoanStatus IN ('LoanApplied','LoanApproved','LoanFeePaid','LoanDisbursed','LoanClosed')  AND a.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY a.BranchName, a.LoanOfficerName, a.CenterName, a.GroupName, a.MemberName, a.LoanId 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_prxe5mpj
StackTrace:    at GroupLoan_GroupLoanApplicationReport.btnSearch_Click(Object sender, EventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanApplicationReport.aspx.cs:line 138
TargetSite: Void btnSearch_Click(System.Object, System.EventArgs)

Time: 08/05/2025 05:33:03 PM
PageName: DataTableResult
String str:  SELECT a.MemberId, a.MemberName, a.NomineeName, a.ApplicationId, a.LoanId, a.LoanCycle, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.InterestMethod, a.LoanPurpose, a.LoanFunder, a.ApplicationAmount, dbo.FunNumberOfCharacterFromNumber(a.ApplicationAmount/2000)AS ApplicationAmountStr, convert(CHAR,a.ApplicationDate,106)AS ApplicationDate, a.ApplicationRemark, CASE WHEN a.ApplicationDoc1!='' THEN 'View' ELSE '' END AS Doc1, (SELECT CompanyURL+replace(GroupMemberKYCFolder,'~/','') FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1 )+a.MemberId+'/'+a.ApplicationDoc1 AS ApplicationDoc1, CASE WHEN a.ApplicationDoc2!='' THEN 'View' ELSE '' END AS Doc2, (SELECT CompanyURL+replace(GroupMemberKYCFolder,'~/','') FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1 )+a.MemberId+'/'+a.ApplicationDoc2 AS ApplicationDoc2, a.ApplicationEntryUser, rtrim(convert(CHAR,a.ApplicationEntryTime,106))+'-'+rtrim(convert(CHAR,a.ApplicationEntryTime,108))AS ApplicationEntryTime, a.LoanStatus, a.SanctionId, a.GroupName, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')' AS BranchName FROM GroupLoanAccount a WITH(nolock) WHERE a.GroupStatus='Group1' AND a.LoanStatus IN ('LoanApplied','LoanApproved','LoanFeePaid','LoanDisbursed','LoanClosed')  AND a.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY a.BranchName, a.LoanOfficerName, a.CenterName, a.GroupName, a.MemberName, a.LoanId 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid column name 'GroupStatus'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   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) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 174
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 08/05/2025 05:33:03 PM
PageName: GroupLoan_GroupLoanApplicationReport
String str:  SELECT a.MemberId, a.MemberName, a.NomineeName, a.ApplicationId, a.LoanId, a.LoanCycle, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.InterestMethod, a.LoanPurpose, a.LoanFunder, a.ApplicationAmount, dbo.FunNumberOfCharacterFromNumber(a.ApplicationAmount/2000)AS ApplicationAmountStr, convert(CHAR,a.ApplicationDate,106)AS ApplicationDate, a.ApplicationRemark, CASE WHEN a.ApplicationDoc1!='' THEN 'View' ELSE '' END AS Doc1, (SELECT CompanyURL+replace(GroupMemberKYCFolder,'~/','') FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1 )+a.MemberId+'/'+a.ApplicationDoc1 AS ApplicationDoc1, CASE WHEN a.ApplicationDoc2!='' THEN 'View' ELSE '' END AS Doc2, (SELECT CompanyURL+replace(GroupMemberKYCFolder,'~/','') FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1 )+a.MemberId+'/'+a.ApplicationDoc2 AS ApplicationDoc2, a.ApplicationEntryUser, rtrim(convert(CHAR,a.ApplicationEntryTime,106))+'-'+rtrim(convert(CHAR,a.ApplicationEntryTime,108))AS ApplicationEntryTime, a.LoanStatus, a.SanctionId, a.GroupName, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')' AS BranchName FROM GroupLoanAccount a WITH(nolock) WHERE a.GroupStatus='Group1' AND a.LoanStatus IN ('LoanApplied','LoanApproved','LoanFeePaid','LoanDisbursed','LoanClosed')  AND a.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY a.BranchName, a.LoanOfficerName, a.CenterName, a.GroupName, a.MemberName, a.LoanId 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_prxe5mpj
StackTrace:    at GroupLoan_GroupLoanApplicationReport.btnSearch_Click(Object sender, EventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanApplicationReport.aspx.cs:line 138
TargetSite: Void btnSearch_Click(System.Object, System.EventArgs)

Time: 08/05/2025 06:26:46 PM
PageName: DataTableResult
String str:  SELECT a.MemberId, a.MemberName, a.LoanId, a.EMIAmount, b.NoOfEMI, b.PaidPrincipal, b.PaidInterest, b.PaidTotal, b.PenaltyDue, b.PenaltyPaid, a.LoanCycle, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.LoanPurpose, a.LoanFunder, convert(CHAR,a.DisburseDate,106)AS DisburseDate, a.LoanAmount, a.TotalInterest, a.LoanAmount+a.TotalInterest AS TotalPayable, a.GroupName, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')' AS BranchName FROM GroupLoanAccount a WITH(nolock) INNER JOIN ( SELECT LoanId, COUNT(DISTINCT DNo)AS NoOfEMI, SUM(Prin)AS PaidPrincipal, SUM(Intt)AS PaidInterest, SUM(Total)AS PaidTotal, SUM(ISNULL(PDue,0))AS PenaltyDue, SUM(ISNULL(PPaid,0))AS PenaltyPaid FROM GroupLoanLedger WITH(nolock) WHERE PStatus='Paid' AND a.GroupName='Group1'   AND PDate>='4/1/2025 12:00:00 AM'  AND PDate<'5/9/2025 12:00:00 AM'  GROUP BY LoanId HAVING SUM(Total)>0 )b ON a.LoanId=b.LoanId WHERE a.LoanStatus IN ('LoanDisbursed','LoanCLosed')  AND a.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY a.BranchName+' ('+a.BranchId+')', a.LoanOfficerName, a.CenterName, a.GroupName, a.MemberName, a.LoanId 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: The multi-part identifier "a.GroupName" could not be bound.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   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) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 174
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 08/05/2025 06:26:46 PM
PageName: GroupLoan_GroupLoanEMIPaidReport
String str:  SELECT a.MemberId, a.MemberName, a.LoanId, a.EMIAmount, b.NoOfEMI, b.PaidPrincipal, b.PaidInterest, b.PaidTotal, b.PenaltyDue, b.PenaltyPaid, a.LoanCycle, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.LoanPurpose, a.LoanFunder, convert(CHAR,a.DisburseDate,106)AS DisburseDate, a.LoanAmount, a.TotalInterest, a.LoanAmount+a.TotalInterest AS TotalPayable, a.GroupName, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')' AS BranchName FROM GroupLoanAccount a WITH(nolock) INNER JOIN ( SELECT LoanId, COUNT(DISTINCT DNo)AS NoOfEMI, SUM(Prin)AS PaidPrincipal, SUM(Intt)AS PaidInterest, SUM(Total)AS PaidTotal, SUM(ISNULL(PDue,0))AS PenaltyDue, SUM(ISNULL(PPaid,0))AS PenaltyPaid FROM GroupLoanLedger WITH(nolock) WHERE PStatus='Paid' AND a.GroupName='Group1'   AND PDate>='4/1/2025 12:00:00 AM'  AND PDate<'5/9/2025 12:00:00 AM'  GROUP BY LoanId HAVING SUM(Total)>0 )b ON a.LoanId=b.LoanId WHERE a.LoanStatus IN ('LoanDisbursed','LoanCLosed')  AND a.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY a.BranchName+' ('+a.BranchId+')', a.LoanOfficerName, a.CenterName, a.GroupName, a.MemberName, a.LoanId 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_ojm2eomd
StackTrace:    at GroupLoan_GroupLoanEMIPaidReport.btnSearch_Click(Object sender, EventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanEMIPaidReport.aspx.cs:line 202
TargetSite: Void btnSearch_Click(System.Object, System.EventArgs)

Time: 09/05/2025 11:28:34 AM
PageName: GroupLoan_GroupDemandCollectionReport
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='4/1/2025 12:00:00 AM'; SET @TDate='5/9/2025 12:00:00 AM'; SELECT ad.BranchName+' ('+ad.BranchId+')' AS BranchName, ad.LoanOfficerId, ad.LoanOfficerName, ad.CenterId, ad.CenterName, ad.GroupName, ad.MemberId, ad.MemberName, ad.LoanId, convert(CHAR,isnull(odd.ODDate,cdd.CDDate),106)AS DueDate, isnull(odd.ODD,0)AS OverDue, isnull(cdd.CDD,0)AS CurrentDue, isnull(odd.ODD,0)+isnull(cdd.CDD,0)AS TotalDue, isnull(odp.ODP,0)AS ODCollection, isnull(cdp.CDP,0)AS CurrentCollection, isnull(ppp.PP,0)AS PrePayment, isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)AS TotalCollection, CASE WHEN isnull(odd.ODDate,cdd.CDDate)=@TDate OR isnull(cdd.CDD,0)>0 THEN isnull(cdd.CDD,0)-isnull(odp.ODP,0)-isnull(cdp.CDP,0) ELSE 0 END AS TodayNotReceived, ad.LoanAmount, ad.TotalInterest, ad.EMIAmount, convert(CHAR,ad.DisburseDate,106)AS DisburseDate, convert(CHAR,ad.ExpiryDate,106)AS ExpiryDate, ad.GLoanTypeNo, rtrim(convert(CHAR,ad.LoanTerm))+'-'+ad.LoanTermMode AS LoanTerm, ad.LoanCycle, ad.LoanPurpose, ad.LoanFunder FROM GroupLoanAccount ad WITH(nolock) LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODD, MIN(DDate)AS ODDate FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND isnull(PDate,dateadd(day,1,@FDate))>dateadd(day,0,@FDate) GROUP BY LoanId )odd ON ad.LoanId=odd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDD, MIN(DDate)AS CDDate FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<dateadd(day,1,@TDate) AND isnull(PDate,dateadd(day,0,@FDate))>dateadd(day,-1,@FDate) GROUP BY LoanId )cdd ON ad.LoanId=cdd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODP FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )odp ON ad.LoanId=odp.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDP FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<=@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )cdp ON ad.LoanId=cdp.LoanId LEFT JOIN (   SELECT LoanId, SUM(Total)AS PP FROM GroupLoanLedger WITH(nolock) WHERE DDate>@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )ppp ON ad.LoanId=ppp.LoanId  WHERE ad.LoanStatus IN ('LoanDisbursed','LoanCLosed') AND isnull(odd.ODD,0)+isnull(cdd.CDD,0)+isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)>0  AND ad.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY isnull(odd.ODDate,cdd.CDDate) DESC, ad.BranchName, ad.LoanOfficerName, ad.CenterName, ad.MemberName, ad.LoanId 
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_GroupDemandCollectionReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupDemandCollectionReport.aspx.cs:line 295
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 09/05/2025 11:28:34 AM
PageName: GroupLoan_GroupDemandCollectionReport
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='4/1/2025 12:00:00 AM'; SET @TDate='5/9/2025 12:00:00 AM'; SELECT ad.BranchName+' ('+ad.BranchId+')' AS BranchName, ad.LoanOfficerId, ad.LoanOfficerName, ad.CenterId, ad.CenterName, ad.GroupName, ad.MemberId, ad.MemberName, ad.LoanId, convert(CHAR,isnull(odd.ODDate,cdd.CDDate),106)AS DueDate, isnull(odd.ODD,0)AS OverDue, isnull(cdd.CDD,0)AS CurrentDue, isnull(odd.ODD,0)+isnull(cdd.CDD,0)AS TotalDue, isnull(odp.ODP,0)AS ODCollection, isnull(cdp.CDP,0)AS CurrentCollection, isnull(ppp.PP,0)AS PrePayment, isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)AS TotalCollection, CASE WHEN isnull(odd.ODDate,cdd.CDDate)=@TDate OR isnull(cdd.CDD,0)>0 THEN isnull(cdd.CDD,0)-isnull(odp.ODP,0)-isnull(cdp.CDP,0) ELSE 0 END AS TodayNotReceived, ad.LoanAmount, ad.TotalInterest, ad.EMIAmount, convert(CHAR,ad.DisburseDate,106)AS DisburseDate, convert(CHAR,ad.ExpiryDate,106)AS ExpiryDate, ad.GLoanTypeNo, rtrim(convert(CHAR,ad.LoanTerm))+'-'+ad.LoanTermMode AS LoanTerm, ad.LoanCycle, ad.LoanPurpose, ad.LoanFunder FROM GroupLoanAccount ad WITH(nolock) LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODD, MIN(DDate)AS ODDate FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND isnull(PDate,dateadd(day,1,@FDate))>dateadd(day,0,@FDate) GROUP BY LoanId )odd ON ad.LoanId=odd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDD, MIN(DDate)AS CDDate FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<dateadd(day,1,@TDate) AND isnull(PDate,dateadd(day,0,@FDate))>dateadd(day,-1,@FDate) GROUP BY LoanId )cdd ON ad.LoanId=cdd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODP FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )odp ON ad.LoanId=odp.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDP FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<=@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )cdp ON ad.LoanId=cdp.LoanId LEFT JOIN (   SELECT LoanId, SUM(Total)AS PP FROM GroupLoanLedger WITH(nolock) WHERE DDate>@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )ppp ON ad.LoanId=ppp.LoanId  WHERE ad.LoanStatus IN ('LoanDisbursed','LoanCLosed') AND isnull(odd.ODD,0)+isnull(cdd.CDD,0)+isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)>0  AND ad.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY isnull(odd.ODDate,cdd.CDDate) DESC, ad.BranchName, ad.LoanOfficerName, ad.CenterName, ad.MemberName, ad.LoanId 
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_GroupDemandCollectionReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupDemandCollectionReport.aspx.cs:line 295
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 09/05/2025 11:28:34 AM
PageName: GroupLoan_GroupDemandCollectionReport
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='4/1/2025 12:00:00 AM'; SET @TDate='5/9/2025 12:00:00 AM'; SELECT ad.BranchName+' ('+ad.BranchId+')' AS BranchName, ad.LoanOfficerId, ad.LoanOfficerName, ad.CenterId, ad.CenterName, ad.GroupName, ad.MemberId, ad.MemberName, ad.LoanId, convert(CHAR,isnull(odd.ODDate,cdd.CDDate),106)AS DueDate, isnull(odd.ODD,0)AS OverDue, isnull(cdd.CDD,0)AS CurrentDue, isnull(odd.ODD,0)+isnull(cdd.CDD,0)AS TotalDue, isnull(odp.ODP,0)AS ODCollection, isnull(cdp.CDP,0)AS CurrentCollection, isnull(ppp.PP,0)AS PrePayment, isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)AS TotalCollection, CASE WHEN isnull(odd.ODDate,cdd.CDDate)=@TDate OR isnull(cdd.CDD,0)>0 THEN isnull(cdd.CDD,0)-isnull(odp.ODP,0)-isnull(cdp.CDP,0) ELSE 0 END AS TodayNotReceived, ad.LoanAmount, ad.TotalInterest, ad.EMIAmount, convert(CHAR,ad.DisburseDate,106)AS DisburseDate, convert(CHAR,ad.ExpiryDate,106)AS ExpiryDate, ad.GLoanTypeNo, rtrim(convert(CHAR,ad.LoanTerm))+'-'+ad.LoanTermMode AS LoanTerm, ad.LoanCycle, ad.LoanPurpose, ad.LoanFunder FROM GroupLoanAccount ad WITH(nolock) LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODD, MIN(DDate)AS ODDate FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND isnull(PDate,dateadd(day,1,@FDate))>dateadd(day,0,@FDate) GROUP BY LoanId )odd ON ad.LoanId=odd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDD, MIN(DDate)AS CDDate FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<dateadd(day,1,@TDate) AND isnull(PDate,dateadd(day,0,@FDate))>dateadd(day,-1,@FDate) GROUP BY LoanId )cdd ON ad.LoanId=cdd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODP FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )odp ON ad.LoanId=odp.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDP FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<=@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )cdp ON ad.LoanId=cdp.LoanId LEFT JOIN (   SELECT LoanId, SUM(Total)AS PP FROM GroupLoanLedger WITH(nolock) WHERE DDate>@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )ppp ON ad.LoanId=ppp.LoanId  WHERE ad.LoanStatus IN ('LoanDisbursed','LoanCLosed') AND isnull(odd.ODD,0)+isnull(cdd.CDD,0)+isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)>0  AND ad.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY isnull(odd.ODDate,cdd.CDDate) DESC, ad.BranchName, ad.LoanOfficerName, ad.CenterName, ad.MemberName, ad.LoanId 
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_GroupDemandCollectionReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupDemandCollectionReport.aspx.cs:line 295
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 09/05/2025 11:28:57 AM
PageName: GroupLoan_GroupDemandCollectionReport
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='4/1/2025 12:00:00 AM'; SET @TDate='5/9/2025 12:00:00 AM'; SELECT ad.BranchName+' ('+ad.BranchId+')' AS BranchName, ad.LoanOfficerId, ad.LoanOfficerName, ad.CenterId, ad.CenterName, ad.GroupName, ad.MemberId, ad.MemberName, ad.LoanId, convert(CHAR,isnull(odd.ODDate,cdd.CDDate),106)AS DueDate, isnull(odd.ODD,0)AS OverDue, isnull(cdd.CDD,0)AS CurrentDue, isnull(odd.ODD,0)+isnull(cdd.CDD,0)AS TotalDue, isnull(odp.ODP,0)AS ODCollection, isnull(cdp.CDP,0)AS CurrentCollection, isnull(ppp.PP,0)AS PrePayment, isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)AS TotalCollection, CASE WHEN isnull(odd.ODDate,cdd.CDDate)=@TDate OR isnull(cdd.CDD,0)>0 THEN isnull(cdd.CDD,0)-isnull(odp.ODP,0)-isnull(cdp.CDP,0) ELSE 0 END AS TodayNotReceived, ad.LoanAmount, ad.TotalInterest, ad.EMIAmount, convert(CHAR,ad.DisburseDate,106)AS DisburseDate, convert(CHAR,ad.ExpiryDate,106)AS ExpiryDate, ad.GLoanTypeNo, rtrim(convert(CHAR,ad.LoanTerm))+'-'+ad.LoanTermMode AS LoanTerm, ad.LoanCycle, ad.LoanPurpose, ad.LoanFunder FROM GroupLoanAccount ad WITH(nolock) LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODD, MIN(DDate)AS ODDate FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND isnull(PDate,dateadd(day,1,@FDate))>dateadd(day,0,@FDate) GROUP BY LoanId )odd ON ad.LoanId=odd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDD, MIN(DDate)AS CDDate FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<dateadd(day,1,@TDate) AND isnull(PDate,dateadd(day,0,@FDate))>dateadd(day,-1,@FDate) GROUP BY LoanId )cdd ON ad.LoanId=cdd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODP FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )odp ON ad.LoanId=odp.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDP FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<=@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )cdp ON ad.LoanId=cdp.LoanId LEFT JOIN (   SELECT LoanId, SUM(Total)AS PP FROM GroupLoanLedger WITH(nolock) WHERE DDate>@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )ppp ON ad.LoanId=ppp.LoanId  WHERE ad.LoanStatus IN ('LoanDisbursed','LoanCLosed') AND isnull(odd.ODD,0)+isnull(cdd.CDD,0)+isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)>0  AND ad.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY isnull(odd.ODDate,cdd.CDDate) DESC, ad.BranchName, ad.LoanOfficerName, ad.CenterName, ad.MemberName, ad.LoanId 
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_GroupDemandCollectionReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupDemandCollectionReport.aspx.cs:line 295
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 09/05/2025 11:28:57 AM
PageName: GroupLoan_GroupDemandCollectionReport
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='4/1/2025 12:00:00 AM'; SET @TDate='5/9/2025 12:00:00 AM'; SELECT ad.BranchName+' ('+ad.BranchId+')' AS BranchName, ad.LoanOfficerId, ad.LoanOfficerName, ad.CenterId, ad.CenterName, ad.GroupName, ad.MemberId, ad.MemberName, ad.LoanId, convert(CHAR,isnull(odd.ODDate,cdd.CDDate),106)AS DueDate, isnull(odd.ODD,0)AS OverDue, isnull(cdd.CDD,0)AS CurrentDue, isnull(odd.ODD,0)+isnull(cdd.CDD,0)AS TotalDue, isnull(odp.ODP,0)AS ODCollection, isnull(cdp.CDP,0)AS CurrentCollection, isnull(ppp.PP,0)AS PrePayment, isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)AS TotalCollection, CASE WHEN isnull(odd.ODDate,cdd.CDDate)=@TDate OR isnull(cdd.CDD,0)>0 THEN isnull(cdd.CDD,0)-isnull(odp.ODP,0)-isnull(cdp.CDP,0) ELSE 0 END AS TodayNotReceived, ad.LoanAmount, ad.TotalInterest, ad.EMIAmount, convert(CHAR,ad.DisburseDate,106)AS DisburseDate, convert(CHAR,ad.ExpiryDate,106)AS ExpiryDate, ad.GLoanTypeNo, rtrim(convert(CHAR,ad.LoanTerm))+'-'+ad.LoanTermMode AS LoanTerm, ad.LoanCycle, ad.LoanPurpose, ad.LoanFunder FROM GroupLoanAccount ad WITH(nolock) LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODD, MIN(DDate)AS ODDate FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND isnull(PDate,dateadd(day,1,@FDate))>dateadd(day,0,@FDate) GROUP BY LoanId )odd ON ad.LoanId=odd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDD, MIN(DDate)AS CDDate FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<dateadd(day,1,@TDate) AND isnull(PDate,dateadd(day,0,@FDate))>dateadd(day,-1,@FDate) GROUP BY LoanId )cdd ON ad.LoanId=cdd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODP FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )odp ON ad.LoanId=odp.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDP FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<=@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )cdp ON ad.LoanId=cdp.LoanId LEFT JOIN (   SELECT LoanId, SUM(Total)AS PP FROM GroupLoanLedger WITH(nolock) WHERE DDate>@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )ppp ON ad.LoanId=ppp.LoanId  WHERE ad.LoanStatus IN ('LoanDisbursed','LoanCLosed') AND isnull(odd.ODD,0)+isnull(cdd.CDD,0)+isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)>0  AND ad.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY isnull(odd.ODDate,cdd.CDDate) DESC, ad.BranchName, ad.LoanOfficerName, ad.CenterName, ad.MemberName, ad.LoanId 
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_GroupDemandCollectionReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupDemandCollectionReport.aspx.cs:line 295
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 09/05/2025 11:28:57 AM
PageName: GroupLoan_GroupDemandCollectionReport
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='4/1/2025 12:00:00 AM'; SET @TDate='5/9/2025 12:00:00 AM'; SELECT ad.BranchName+' ('+ad.BranchId+')' AS BranchName, ad.LoanOfficerId, ad.LoanOfficerName, ad.CenterId, ad.CenterName, ad.GroupName, ad.MemberId, ad.MemberName, ad.LoanId, convert(CHAR,isnull(odd.ODDate,cdd.CDDate),106)AS DueDate, isnull(odd.ODD,0)AS OverDue, isnull(cdd.CDD,0)AS CurrentDue, isnull(odd.ODD,0)+isnull(cdd.CDD,0)AS TotalDue, isnull(odp.ODP,0)AS ODCollection, isnull(cdp.CDP,0)AS CurrentCollection, isnull(ppp.PP,0)AS PrePayment, isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)AS TotalCollection, CASE WHEN isnull(odd.ODDate,cdd.CDDate)=@TDate OR isnull(cdd.CDD,0)>0 THEN isnull(cdd.CDD,0)-isnull(odp.ODP,0)-isnull(cdp.CDP,0) ELSE 0 END AS TodayNotReceived, ad.LoanAmount, ad.TotalInterest, ad.EMIAmount, convert(CHAR,ad.DisburseDate,106)AS DisburseDate, convert(CHAR,ad.ExpiryDate,106)AS ExpiryDate, ad.GLoanTypeNo, rtrim(convert(CHAR,ad.LoanTerm))+'-'+ad.LoanTermMode AS LoanTerm, ad.LoanCycle, ad.LoanPurpose, ad.LoanFunder FROM GroupLoanAccount ad WITH(nolock) LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODD, MIN(DDate)AS ODDate FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND isnull(PDate,dateadd(day,1,@FDate))>dateadd(day,0,@FDate) GROUP BY LoanId )odd ON ad.LoanId=odd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDD, MIN(DDate)AS CDDate FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<dateadd(day,1,@TDate) AND isnull(PDate,dateadd(day,0,@FDate))>dateadd(day,-1,@FDate) GROUP BY LoanId )cdd ON ad.LoanId=cdd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODP FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )odp ON ad.LoanId=odp.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDP FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<=@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )cdp ON ad.LoanId=cdp.LoanId LEFT JOIN (   SELECT LoanId, SUM(Total)AS PP FROM GroupLoanLedger WITH(nolock) WHERE DDate>@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )ppp ON ad.LoanId=ppp.LoanId  WHERE ad.LoanStatus IN ('LoanDisbursed','LoanCLosed') AND isnull(odd.ODD,0)+isnull(cdd.CDD,0)+isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)>0  AND ad.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY isnull(odd.ODDate,cdd.CDDate) DESC, ad.BranchName, ad.LoanOfficerName, ad.CenterName, ad.MemberName, ad.LoanId 
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_GroupDemandCollectionReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupDemandCollectionReport.aspx.cs:line 295
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 09/05/2025 11:30:54 AM
PageName: GroupLoan_GroupDemandCollectionReport
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='4/1/2025 12:00:00 AM'; SET @TDate='5/9/2025 12:00:00 AM'; SELECT ad.BranchName+' ('+ad.BranchId+')' AS BranchName, ad.LoanOfficerId, ad.LoanOfficerName, ad.CenterId, ad.CenterName, ad.GroupName, ad.MemberId, ad.MemberName, ad.LoanId, convert(CHAR,isnull(odd.ODDate,cdd.CDDate),106)AS DueDate, isnull(odd.ODD,0)AS OverDue, isnull(cdd.CDD,0)AS CurrentDue, isnull(odd.ODD,0)+isnull(cdd.CDD,0)AS TotalDue, isnull(odp.ODP,0)AS ODCollection, isnull(cdp.CDP,0)AS CurrentCollection, isnull(ppp.PP,0)AS PrePayment, isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)AS TotalCollection, CASE WHEN isnull(odd.ODDate,cdd.CDDate)=@TDate OR isnull(cdd.CDD,0)>0 THEN isnull(cdd.CDD,0)-isnull(odp.ODP,0)-isnull(cdp.CDP,0) ELSE 0 END AS TodayNotReceived, ad.LoanAmount, ad.TotalInterest, ad.EMIAmount, convert(CHAR,ad.DisburseDate,106)AS DisburseDate, convert(CHAR,ad.ExpiryDate,106)AS ExpiryDate, ad.GLoanTypeNo, rtrim(convert(CHAR,ad.LoanTerm))+'-'+ad.LoanTermMode AS LoanTerm, ad.LoanCycle, ad.LoanPurpose, ad.LoanFunder FROM GroupLoanAccount ad WITH(nolock) LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODD, MIN(DDate)AS ODDate FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND isnull(PDate,dateadd(day,1,@FDate))>dateadd(day,0,@FDate) GROUP BY LoanId )odd ON ad.LoanId=odd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDD, MIN(DDate)AS CDDate FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<dateadd(day,1,@TDate) AND isnull(PDate,dateadd(day,0,@FDate))>dateadd(day,-1,@FDate) GROUP BY LoanId )cdd ON ad.LoanId=cdd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODP FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )odp ON ad.LoanId=odp.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDP FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<=@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )cdp ON ad.LoanId=cdp.LoanId LEFT JOIN (   SELECT LoanId, SUM(Total)AS PP FROM GroupLoanLedger WITH(nolock) WHERE DDate>@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )ppp ON ad.LoanId=ppp.LoanId  WHERE  ad.GroupName='Group1' AND ad.LoanStatus IN ('LoanDisbursed','LoanCLosed') AND isnull(odd.ODD,0)+isnull(cdd.CDD,0)+isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)>0  AND ad.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY isnull(odd.ODDate,cdd.CDDate) DESC, ad.BranchName, ad.LoanOfficerName, ad.CenterName, ad.MemberName, ad.LoanId 
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_GroupDemandCollectionReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupDemandCollectionReport.aspx.cs:line 295
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 09/05/2025 11:30:54 AM
PageName: GroupLoan_GroupDemandCollectionReport
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='4/1/2025 12:00:00 AM'; SET @TDate='5/9/2025 12:00:00 AM'; SELECT ad.BranchName+' ('+ad.BranchId+')' AS BranchName, ad.LoanOfficerId, ad.LoanOfficerName, ad.CenterId, ad.CenterName, ad.GroupName, ad.MemberId, ad.MemberName, ad.LoanId, convert(CHAR,isnull(odd.ODDate,cdd.CDDate),106)AS DueDate, isnull(odd.ODD,0)AS OverDue, isnull(cdd.CDD,0)AS CurrentDue, isnull(odd.ODD,0)+isnull(cdd.CDD,0)AS TotalDue, isnull(odp.ODP,0)AS ODCollection, isnull(cdp.CDP,0)AS CurrentCollection, isnull(ppp.PP,0)AS PrePayment, isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)AS TotalCollection, CASE WHEN isnull(odd.ODDate,cdd.CDDate)=@TDate OR isnull(cdd.CDD,0)>0 THEN isnull(cdd.CDD,0)-isnull(odp.ODP,0)-isnull(cdp.CDP,0) ELSE 0 END AS TodayNotReceived, ad.LoanAmount, ad.TotalInterest, ad.EMIAmount, convert(CHAR,ad.DisburseDate,106)AS DisburseDate, convert(CHAR,ad.ExpiryDate,106)AS ExpiryDate, ad.GLoanTypeNo, rtrim(convert(CHAR,ad.LoanTerm))+'-'+ad.LoanTermMode AS LoanTerm, ad.LoanCycle, ad.LoanPurpose, ad.LoanFunder FROM GroupLoanAccount ad WITH(nolock) LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODD, MIN(DDate)AS ODDate FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND isnull(PDate,dateadd(day,1,@FDate))>dateadd(day,0,@FDate) GROUP BY LoanId )odd ON ad.LoanId=odd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDD, MIN(DDate)AS CDDate FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<dateadd(day,1,@TDate) AND isnull(PDate,dateadd(day,0,@FDate))>dateadd(day,-1,@FDate) GROUP BY LoanId )cdd ON ad.LoanId=cdd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODP FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )odp ON ad.LoanId=odp.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDP FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<=@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )cdp ON ad.LoanId=cdp.LoanId LEFT JOIN (   SELECT LoanId, SUM(Total)AS PP FROM GroupLoanLedger WITH(nolock) WHERE DDate>@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )ppp ON ad.LoanId=ppp.LoanId  WHERE  ad.GroupName='Group1' AND ad.LoanStatus IN ('LoanDisbursed','LoanCLosed') AND isnull(odd.ODD,0)+isnull(cdd.CDD,0)+isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)>0  AND ad.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY isnull(odd.ODDate,cdd.CDDate) DESC, ad.BranchName, ad.LoanOfficerName, ad.CenterName, ad.MemberName, ad.LoanId 
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_GroupDemandCollectionReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupDemandCollectionReport.aspx.cs:line 295
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 09/05/2025 11:30:54 AM
PageName: GroupLoan_GroupDemandCollectionReport
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='4/1/2025 12:00:00 AM'; SET @TDate='5/9/2025 12:00:00 AM'; SELECT ad.BranchName+' ('+ad.BranchId+')' AS BranchName, ad.LoanOfficerId, ad.LoanOfficerName, ad.CenterId, ad.CenterName, ad.GroupName, ad.MemberId, ad.MemberName, ad.LoanId, convert(CHAR,isnull(odd.ODDate,cdd.CDDate),106)AS DueDate, isnull(odd.ODD,0)AS OverDue, isnull(cdd.CDD,0)AS CurrentDue, isnull(odd.ODD,0)+isnull(cdd.CDD,0)AS TotalDue, isnull(odp.ODP,0)AS ODCollection, isnull(cdp.CDP,0)AS CurrentCollection, isnull(ppp.PP,0)AS PrePayment, isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)AS TotalCollection, CASE WHEN isnull(odd.ODDate,cdd.CDDate)=@TDate OR isnull(cdd.CDD,0)>0 THEN isnull(cdd.CDD,0)-isnull(odp.ODP,0)-isnull(cdp.CDP,0) ELSE 0 END AS TodayNotReceived, ad.LoanAmount, ad.TotalInterest, ad.EMIAmount, convert(CHAR,ad.DisburseDate,106)AS DisburseDate, convert(CHAR,ad.ExpiryDate,106)AS ExpiryDate, ad.GLoanTypeNo, rtrim(convert(CHAR,ad.LoanTerm))+'-'+ad.LoanTermMode AS LoanTerm, ad.LoanCycle, ad.LoanPurpose, ad.LoanFunder FROM GroupLoanAccount ad WITH(nolock) LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODD, MIN(DDate)AS ODDate FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND isnull(PDate,dateadd(day,1,@FDate))>dateadd(day,0,@FDate) GROUP BY LoanId )odd ON ad.LoanId=odd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDD, MIN(DDate)AS CDDate FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<dateadd(day,1,@TDate) AND isnull(PDate,dateadd(day,0,@FDate))>dateadd(day,-1,@FDate) GROUP BY LoanId )cdd ON ad.LoanId=cdd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODP FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )odp ON ad.LoanId=odp.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDP FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<=@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )cdp ON ad.LoanId=cdp.LoanId LEFT JOIN (   SELECT LoanId, SUM(Total)AS PP FROM GroupLoanLedger WITH(nolock) WHERE DDate>@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )ppp ON ad.LoanId=ppp.LoanId  WHERE  ad.GroupName='Group1' AND ad.LoanStatus IN ('LoanDisbursed','LoanCLosed') AND isnull(odd.ODD,0)+isnull(cdd.CDD,0)+isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)>0  AND ad.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY isnull(odd.ODDate,cdd.CDDate) DESC, ad.BranchName, ad.LoanOfficerName, ad.CenterName, ad.MemberName, ad.LoanId 
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_GroupDemandCollectionReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupDemandCollectionReport.aspx.cs:line 295
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 09/05/2025 11:32:16 AM
PageName: GroupLoan_GroupDemandCollectionReport
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='4/1/2025 12:00:00 AM'; SET @TDate='5/9/2025 12:00:00 AM'; SELECT ad.BranchName+' ('+ad.BranchId+')' AS BranchName, ad.LoanOfficerId, ad.LoanOfficerName, ad.CenterId, ad.CenterName, ad.GroupName, ad.MemberId, ad.MemberName, ad.LoanId, convert(CHAR,isnull(odd.ODDate,cdd.CDDate),106)AS DueDate, isnull(odd.ODD,0)AS OverDue, isnull(cdd.CDD,0)AS CurrentDue, isnull(odd.ODD,0)+isnull(cdd.CDD,0)AS TotalDue, isnull(odp.ODP,0)AS ODCollection, isnull(cdp.CDP,0)AS CurrentCollection, isnull(ppp.PP,0)AS PrePayment, isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)AS TotalCollection, CASE WHEN isnull(odd.ODDate,cdd.CDDate)=@TDate OR isnull(cdd.CDD,0)>0 THEN isnull(cdd.CDD,0)-isnull(odp.ODP,0)-isnull(cdp.CDP,0) ELSE 0 END AS TodayNotReceived, ad.LoanAmount, ad.TotalInterest, ad.EMIAmount, convert(CHAR,ad.DisburseDate,106)AS DisburseDate, convert(CHAR,ad.ExpiryDate,106)AS ExpiryDate, ad.GLoanTypeNo, rtrim(convert(CHAR,ad.LoanTerm))+'-'+ad.LoanTermMode AS LoanTerm, ad.LoanCycle, ad.LoanPurpose, ad.LoanFunder FROM GroupLoanAccount ad WITH(nolock) LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODD, MIN(DDate)AS ODDate FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND isnull(PDate,dateadd(day,1,@FDate))>dateadd(day,0,@FDate) GROUP BY LoanId )odd ON ad.LoanId=odd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDD, MIN(DDate)AS CDDate FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<dateadd(day,1,@TDate) AND isnull(PDate,dateadd(day,0,@FDate))>dateadd(day,-1,@FDate) GROUP BY LoanId )cdd ON ad.LoanId=cdd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODP FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )odp ON ad.LoanId=odp.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDP FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<=@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )cdp ON ad.LoanId=cdp.LoanId LEFT JOIN (   SELECT LoanId, SUM(Total)AS PP FROM GroupLoanLedger WITH(nolock) WHERE DDate>@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )ppp ON ad.LoanId=ppp.LoanId  WHERE  ad.GroupName='Group1' AND ad.LoanStatus IN ('LoanDisbursed','LoanCLosed') AND isnull(odd.ODD,0)+isnull(cdd.CDD,0)+isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)>0  AND ad.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY isnull(odd.ODDate,cdd.CDDate) DESC, ad.BranchName, ad.LoanOfficerName, ad.CenterName, ad.MemberName, ad.LoanId 
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_GroupDemandCollectionReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupDemandCollectionReport.aspx.cs:line 295
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 09/05/2025 11:32:16 AM
PageName: GroupLoan_GroupDemandCollectionReport
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='4/1/2025 12:00:00 AM'; SET @TDate='5/9/2025 12:00:00 AM'; SELECT ad.BranchName+' ('+ad.BranchId+')' AS BranchName, ad.LoanOfficerId, ad.LoanOfficerName, ad.CenterId, ad.CenterName, ad.GroupName, ad.MemberId, ad.MemberName, ad.LoanId, convert(CHAR,isnull(odd.ODDate,cdd.CDDate),106)AS DueDate, isnull(odd.ODD,0)AS OverDue, isnull(cdd.CDD,0)AS CurrentDue, isnull(odd.ODD,0)+isnull(cdd.CDD,0)AS TotalDue, isnull(odp.ODP,0)AS ODCollection, isnull(cdp.CDP,0)AS CurrentCollection, isnull(ppp.PP,0)AS PrePayment, isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)AS TotalCollection, CASE WHEN isnull(odd.ODDate,cdd.CDDate)=@TDate OR isnull(cdd.CDD,0)>0 THEN isnull(cdd.CDD,0)-isnull(odp.ODP,0)-isnull(cdp.CDP,0) ELSE 0 END AS TodayNotReceived, ad.LoanAmount, ad.TotalInterest, ad.EMIAmount, convert(CHAR,ad.DisburseDate,106)AS DisburseDate, convert(CHAR,ad.ExpiryDate,106)AS ExpiryDate, ad.GLoanTypeNo, rtrim(convert(CHAR,ad.LoanTerm))+'-'+ad.LoanTermMode AS LoanTerm, ad.LoanCycle, ad.LoanPurpose, ad.LoanFunder FROM GroupLoanAccount ad WITH(nolock) LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODD, MIN(DDate)AS ODDate FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND isnull(PDate,dateadd(day,1,@FDate))>dateadd(day,0,@FDate) GROUP BY LoanId )odd ON ad.LoanId=odd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDD, MIN(DDate)AS CDDate FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<dateadd(day,1,@TDate) AND isnull(PDate,dateadd(day,0,@FDate))>dateadd(day,-1,@FDate) GROUP BY LoanId )cdd ON ad.LoanId=cdd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODP FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )odp ON ad.LoanId=odp.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDP FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<=@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )cdp ON ad.LoanId=cdp.LoanId LEFT JOIN (   SELECT LoanId, SUM(Total)AS PP FROM GroupLoanLedger WITH(nolock) WHERE DDate>@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )ppp ON ad.LoanId=ppp.LoanId  WHERE  ad.GroupName='Group1' AND ad.LoanStatus IN ('LoanDisbursed','LoanCLosed') AND isnull(odd.ODD,0)+isnull(cdd.CDD,0)+isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)>0  AND ad.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY isnull(odd.ODDate,cdd.CDDate) DESC, ad.BranchName, ad.LoanOfficerName, ad.CenterName, ad.MemberName, ad.LoanId 
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_GroupDemandCollectionReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupDemandCollectionReport.aspx.cs:line 295
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 09/05/2025 11:32:16 AM
PageName: GroupLoan_GroupDemandCollectionReport
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='4/1/2025 12:00:00 AM'; SET @TDate='5/9/2025 12:00:00 AM'; SELECT ad.BranchName+' ('+ad.BranchId+')' AS BranchName, ad.LoanOfficerId, ad.LoanOfficerName, ad.CenterId, ad.CenterName, ad.GroupName, ad.MemberId, ad.MemberName, ad.LoanId, convert(CHAR,isnull(odd.ODDate,cdd.CDDate),106)AS DueDate, isnull(odd.ODD,0)AS OverDue, isnull(cdd.CDD,0)AS CurrentDue, isnull(odd.ODD,0)+isnull(cdd.CDD,0)AS TotalDue, isnull(odp.ODP,0)AS ODCollection, isnull(cdp.CDP,0)AS CurrentCollection, isnull(ppp.PP,0)AS PrePayment, isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)AS TotalCollection, CASE WHEN isnull(odd.ODDate,cdd.CDDate)=@TDate OR isnull(cdd.CDD,0)>0 THEN isnull(cdd.CDD,0)-isnull(odp.ODP,0)-isnull(cdp.CDP,0) ELSE 0 END AS TodayNotReceived, ad.LoanAmount, ad.TotalInterest, ad.EMIAmount, convert(CHAR,ad.DisburseDate,106)AS DisburseDate, convert(CHAR,ad.ExpiryDate,106)AS ExpiryDate, ad.GLoanTypeNo, rtrim(convert(CHAR,ad.LoanTerm))+'-'+ad.LoanTermMode AS LoanTerm, ad.LoanCycle, ad.LoanPurpose, ad.LoanFunder FROM GroupLoanAccount ad WITH(nolock) LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODD, MIN(DDate)AS ODDate FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND isnull(PDate,dateadd(day,1,@FDate))>dateadd(day,0,@FDate) GROUP BY LoanId )odd ON ad.LoanId=odd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDD, MIN(DDate)AS CDDate FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<dateadd(day,1,@TDate) AND isnull(PDate,dateadd(day,0,@FDate))>dateadd(day,-1,@FDate) GROUP BY LoanId )cdd ON ad.LoanId=cdd.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS ODP FROM GroupLoanLedger WITH(nolock) WHERE DDate<@FDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )odp ON ad.LoanId=odp.LoanId LEFT JOIN (  SELECT LoanId, SUM(Total)AS CDP FROM GroupLoanLedger WITH(nolock) WHERE DDate>=@FDate AND DDate<=@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )cdp ON ad.LoanId=cdp.LoanId LEFT JOIN (   SELECT LoanId, SUM(Total)AS PP FROM GroupLoanLedger WITH(nolock) WHERE DDate>@TDate AND PDate>=@FDate AND PDate<=@TDate GROUP BY LoanId )ppp ON ad.LoanId=ppp.LoanId  WHERE  ad.GroupName='Group1' AND ad.LoanStatus IN ('LoanDisbursed','LoanCLosed') AND isnull(odd.ODD,0)+isnull(cdd.CDD,0)+isnull(odp.ODP,0)+isnull(cdp.CDP,0)+isnull(ppp.PP,0)>0  AND ad.BranchId IN ('1003','1000','1002','1005','1001','1004')  ORDER BY isnull(odd.ODDate,cdd.CDDate) DESC, ad.BranchName, ad.LoanOfficerName, ad.CenterName, ad.MemberName, ad.LoanId 
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_GroupDemandCollectionReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupDemandCollectionReport.aspx.cs:line 295
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 09/05/2025 11:34:47 AM
PageName: DataTableResult
String str:  SELECT a.MemberId, a.MemberName, b.NoOfLoans, a.LoanId, convert(CHAR,a.DisburseDate,106)AS DisburseDate, a.LoanAmount, a.EMIAmount, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.LoanPurpose, a.LoanFunder, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')'AS BranchName FROM GroupLoanAccount a WITH(nolock) INNER JOIN ( SELECT MemberId, count(DISTINCT LoanId)AS NoOfLoans FROM GroupLoanAccount WITH(nolock) WHERE  a.GroupName='Group1' AND LoanStatus='LoanDisbursed'  AND BranchId IN ('1003','1000','1002','1005','1001','1004')  GROUP BY MemberId HAVING count(DISTINCT LoanId)>1 )b ON a.MemberId=b.MemberId WHERE 1=1  ORDER BY a.MemberId, a.LoanId 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: The multi-part identifier "a.GroupName" could not be bound.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   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) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 174
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 09/05/2025 11:34:47 AM
PageName: GroupLoan_GroupLoanMultipleLoanList
String str:  SELECT a.MemberId, a.MemberName, b.NoOfLoans, a.LoanId, convert(CHAR,a.DisburseDate,106)AS DisburseDate, a.LoanAmount, a.EMIAmount, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.LoanPurpose, a.LoanFunder, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')'AS BranchName FROM GroupLoanAccount a WITH(nolock) INNER JOIN ( SELECT MemberId, count(DISTINCT LoanId)AS NoOfLoans FROM GroupLoanAccount WITH(nolock) WHERE  a.GroupName='Group1' AND LoanStatus='LoanDisbursed'  AND BranchId IN ('1003','1000','1002','1005','1001','1004')  GROUP BY MemberId HAVING count(DISTINCT LoanId)>1 )b ON a.MemberId=b.MemberId WHERE 1=1  ORDER BY a.MemberId, a.LoanId 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_y2qo3dz3
StackTrace:    at GroupLoan_GroupLoanMultipleLoanList.btnSearch_Click(Object sender, EventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanMultipleLoanList.aspx.cs:line 80
TargetSite: Void btnSearch_Click(System.Object, System.EventArgs)

Time: 09/05/2025 03:30:39 PM
PageName: Employee_EmployeeJoiningLetter
String str:  SELECT Count(1)AS Nos1 FROM EmployeeJoiningLetterDetail WHERE EmployeeName='Mr.Tanzeem Ahmad' AND EmployeeId='CHK0001' 
String sql:  INSERT INTO EmployeeJoiningLetterDetail (BranchId, BranchName, DepartmentId, DepartmentName, DesignationId, DesignationName, EmployeeId,EmployeeName, AppointDate, JoiningDate, JoiningDetail, EntryTime, EntryUser) VALUES (  '100', 'Head Office (100)','23', 'Account', '13', 'Asst. Branch Manager', 'CHK0001', 'Mr.Tanzeem Ahmad',  '5/9/2025 12:00:00 AM', '5/9/2025 12:00:00 AM',  'Join By Anshu', 'root', GETDATE()  );
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Conversion failed when converting character string to smalldatetime data type.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at ClassMaster.VoidInsUpDelTransaction(String sql, SqlTransaction trans) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 42
   at Employee_EmployeeJoiningLetter.btnSubmit_Click(Object sender, EventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\Employee_EmployeeJoiningLetter.aspx.cs:line 140
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 09/05/2025 03:33:50 PM
PageName: Employee_EmployeeJoiningLetter
String str:  SELECT Count(1)AS Nos1 FROM EmployeeJoiningLetterDetail WHERE EmployeeName='Mr.Tanzeem Ahmad' AND EmployeeId='CHK0001' 
String sql:  INSERT INTO EmployeeJoiningLetterDetail (BranchId, BranchName, DepartmentId, DepartmentName, DesignationId, DesignationName, EmployeeId,EmployeeName, AppointDate, JoiningDate, JoiningDetail, EntryTime, EntryUser) VALUES (  '100', 'Head Office (100)','23', 'Account', '13', 'Asst. Branch Manager', 'CHK0001', 'Mr.Tanzeem Ahmad',  '5/9/2025 12:00:00 AM', '5/9/2025 12:00:00 AM',  'Join By Anshu', 'root', GETDATE()  );
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Conversion failed when converting character string to smalldatetime data type.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at ClassMaster.VoidInsUpDelTransaction(String sql, SqlTransaction trans) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 42
   at Employee_EmployeeJoiningLetter.btnSubmit_Click(Object sender, EventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\Employee_EmployeeJoiningLetter.aspx.cs:line 140
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 09/05/2025 05:18:50 PM
PageName: DataTableResult
String str:  SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, LoanTypeStatus, InterestMethod, InterestRateAnnual, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid column name 'FirstEMIPayment'.
Invalid column name 'ProcessingGSTPercent'.
Invalid column name 'InsuranceGSTPercent'.
Invalid column name 'OtherChargeGSTPercent'.
Invalid column name 'FDAmountPercent'.
Invalid column name 'FDAmountAmount'.
Invalid column name 'AccountHeadFDAmountId'.
Invalid column name 'AccountHeadFDAmountName'.
Invalid column name 'RDAmountPercent'.
Invalid column name 'RDAmountAmount'.
Invalid column name 'AccountHeadRDAmountId'.
Invalid column name 'AccountHeadRDAmountName'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   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) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 174
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 09/05/2025 05:18:50 PM
PageName: GroupLoan_GroupLoanNoMasterList
String str:  SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, LoanTypeStatus, InterestMethod, InterestRateAnnual, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_m5v5043x
StackTrace:    at GroupLoan_GroupLoanNoMasterList.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoMasterList.aspx.cs:line 80
TargetSite: Void FillData()

Time: 09/05/2025 05:18:58 PM
PageName: DataTableResult
String str:  SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, LoanTypeStatus, InterestMethod, InterestRateAnnual, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND GroupLoanType='Group Loan'  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid column name 'FirstEMIPayment'.
Invalid column name 'ProcessingGSTPercent'.
Invalid column name 'InsuranceGSTPercent'.
Invalid column name 'OtherChargeGSTPercent'.
Invalid column name 'FDAmountPercent'.
Invalid column name 'FDAmountAmount'.
Invalid column name 'AccountHeadFDAmountId'.
Invalid column name 'AccountHeadFDAmountName'.
Invalid column name 'RDAmountPercent'.
Invalid column name 'RDAmountAmount'.
Invalid column name 'AccountHeadRDAmountId'.
Invalid column name 'AccountHeadRDAmountName'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   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) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 174
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 09/05/2025 05:18:58 PM
PageName: GroupLoan_GroupLoanNoMasterList
String str:  SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, LoanTypeStatus, InterestMethod, InterestRateAnnual, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND GroupLoanType='Group Loan'  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_m5v5043x
StackTrace:    at GroupLoan_GroupLoanNoMasterList.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoMasterList.aspx.cs:line 80
TargetSite: Void FillData()

Time: 09/05/2025 05:19:03 PM
PageName: DataTableResult
String str:  SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, LoanTypeStatus, InterestMethod, InterestRateAnnual, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND GroupLoanType='Group Loan'  AND InterestMethod='FlatInterest'  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid column name 'FirstEMIPayment'.
Invalid column name 'ProcessingGSTPercent'.
Invalid column name 'InsuranceGSTPercent'.
Invalid column name 'OtherChargeGSTPercent'.
Invalid column name 'FDAmountPercent'.
Invalid column name 'FDAmountAmount'.
Invalid column name 'AccountHeadFDAmountId'.
Invalid column name 'AccountHeadFDAmountName'.
Invalid column name 'RDAmountPercent'.
Invalid column name 'RDAmountAmount'.
Invalid column name 'AccountHeadRDAmountId'.
Invalid column name 'AccountHeadRDAmountName'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   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) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 174
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 09/05/2025 05:19:03 PM
PageName: GroupLoan_GroupLoanNoMasterList
String str:  SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, LoanTypeStatus, InterestMethod, InterestRateAnnual, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND GroupLoanType='Group Loan'  AND InterestMethod='FlatInterest'  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_m5v5043x
StackTrace:    at GroupLoan_GroupLoanNoMasterList.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoMasterList.aspx.cs:line 80
TargetSite: Void FillData()

Time: 09/05/2025 05:28:28 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.End()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at System.Web.HttpResponse.Redirect(String url)
   at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\AdminLogOut.aspx.cs:line 45
TargetSite: Void AbortInternal()

Time: 09/05/2025 05:28:36 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.End()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at System.Web.HttpResponse.Redirect(String url)
   at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\AdminLogOut.aspx.cs:line 45
TargetSite: Void AbortInternal()

Time: 09/05/2025 05:32:11 PM
PageName: DataTableResult
String str:  SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, LoanTypeStatus, InterestMethod, InterestRateAnnual, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid column name 'FirstEMIPayment'.
Invalid column name 'ProcessingGSTPercent'.
Invalid column name 'InsuranceGSTPercent'.
Invalid column name 'OtherChargeGSTPercent'.
Invalid column name 'FDAmountPercent'.
Invalid column name 'FDAmountAmount'.
Invalid column name 'AccountHeadFDAmountId'.
Invalid column name 'AccountHeadFDAmountName'.
Invalid column name 'RDAmountPercent'.
Invalid column name 'RDAmountAmount'.
Invalid column name 'AccountHeadRDAmountId'.
Invalid column name 'AccountHeadRDAmountName'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   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) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 174
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 09/05/2025 05:32:11 PM
PageName: GroupLoan_GroupLoanNoPermission
String str:  SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, LoanTypeStatus, InterestMethod, InterestRateAnnual, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_get35lkz
StackTrace:    at GroupLoan_GroupLoanNoPermission.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoPermission.aspx.cs:line 80
TargetSite: Void FillData()

Time: 09/05/2025 05:32:30 PM
PageName: DataTableResult
String str:  SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, LoanTypeStatus, InterestMethod, InterestRateAnnual, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid column name 'FirstEMIPayment'.
Invalid column name 'ProcessingGSTPercent'.
Invalid column name 'InsuranceGSTPercent'.
Invalid column name 'OtherChargeGSTPercent'.
Invalid column name 'FDAmountPercent'.
Invalid column name 'FDAmountAmount'.
Invalid column name 'AccountHeadFDAmountId'.
Invalid column name 'AccountHeadFDAmountName'.
Invalid column name 'RDAmountPercent'.
Invalid column name 'RDAmountAmount'.
Invalid column name 'AccountHeadRDAmountId'.
Invalid column name 'AccountHeadRDAmountName'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   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) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 174
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 09/05/2025 05:36:37 PM
PageName: GroupLoan_GroupLoanNoPermission
String str:  SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, LoanTypeStatus, InterestMethod, InterestRateAnnual, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_get35lkz
StackTrace:    at GroupLoan_GroupLoanNoPermission.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoPermission.aspx.cs:line 80
TargetSite: Void FillData()

Time: 09/05/2025 05:37:15 PM
PageName: GroupLoan_GroupLoanNoPermission
String str: SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, PlanPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestRateAnnual,  GracePeriod, PenaltyRateAnnual, PenaltyAmountAnnual, AccountHeadLoanId, AccountHeadLoanName,  AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, GSTPercent,   AccountHeadGSTId, AccountHeadGSTName,ProcessingFeePercent, ProcessingFeeAmount, ProcessingFeeGSTPercent,    AccountHeadProcessingId, AccountHeadProcessingName, SecurityFeePercent, SecurityFeeAmount,     SecuirityFeeGSTPercent, AccountHeadSecurityId, AccountHeadSecurityName, InsuranceFeePercent,    InsuranceFeeAmount, InsuranceFeeGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName,     OtherChargePercent, OtherChargeAmount, OtherChargeFeeGSTPercent, AccountHeadOtherChargeId,    AccountHeadOtherChargeName, ServiceTaxPercent, ServiceTaxAmount, ServiceTaxFeeGSTPercent, AccountHeadServiceTaxId, AccountHeadServiceTaxName, DownPaymentPercent, DownPaymentAmount, DownPaymentFeeGSTPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser,  rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: A field or property with the name 'FirstEMIPayment' was not found on the selected data source.
Source: System.Web
StackTrace:    at System.Web.UI.WebControls.BoundField.TryGetSimplePropertyValue(Object dataItem, Object& data)
   at System.Web.UI.WebControls.BoundField.GetValue(Control controlContainer)
   at System.Web.UI.WebControls.BoundField.OnDataBindField(Object sender, EventArgs e)
   at System.Web.UI.Control.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.Control.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource)
   at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding)
   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   at System.Web.UI.WebControls.GridView.DataBind()
   at GroupLoan_GroupLoanNoPermission.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoPermission.aspx.cs:line 86
TargetSite: Boolean TryGetSimplePropertyValue(System.Object, System.Object ByRef)

Time: 09/05/2025 05:37:49 PM
PageName: GroupLoan_GroupLoanNoPermission
String str: SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, PlanPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestRateAnnual,  GracePeriod, PenaltyRateAnnual, PenaltyAmountAnnual, AccountHeadLoanId, AccountHeadLoanName,  AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, GSTPercent,   AccountHeadGSTId, AccountHeadGSTName,ProcessingFeePercent, ProcessingFeeAmount, ProcessingFeeGSTPercent,    AccountHeadProcessingId, AccountHeadProcessingName, SecurityFeePercent, SecurityFeeAmount,     SecuirityFeeGSTPercent, AccountHeadSecurityId, AccountHeadSecurityName, InsuranceFeePercent,    InsuranceFeeAmount, InsuranceFeeGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName,     OtherChargePercent, OtherChargeAmount, OtherChargeFeeGSTPercent, AccountHeadOtherChargeId,    AccountHeadOtherChargeName, ServiceTaxPercent, ServiceTaxAmount, ServiceTaxFeeGSTPercent, AccountHeadServiceTaxId, AccountHeadServiceTaxName, DownPaymentPercent, DownPaymentAmount, DownPaymentFeeGSTPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser,  rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: A field or property with the name 'ProcessingGSTPercent' was not found on the selected data source.
Source: System.Web
StackTrace:    at System.Web.UI.WebControls.BoundField.TryGetSimplePropertyValue(Object dataItem, Object& data)
   at System.Web.UI.WebControls.BoundField.GetValue(Control controlContainer)
   at System.Web.UI.WebControls.BoundField.OnDataBindField(Object sender, EventArgs e)
   at System.Web.UI.Control.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.Control.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource)
   at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding)
   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   at System.Web.UI.WebControls.GridView.DataBind()
   at GroupLoan_GroupLoanNoPermission.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoPermission.aspx.cs:line 86
TargetSite: Boolean TryGetSimplePropertyValue(System.Object, System.Object ByRef)

Time: 09/05/2025 05:38:08 PM
PageName: GroupLoan_GroupLoanNoPermission
String str: SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, PlanPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestRateAnnual,  GracePeriod, PenaltyRateAnnual, PenaltyAmountAnnual, AccountHeadLoanId, AccountHeadLoanName,  AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, GSTPercent,   AccountHeadGSTId, AccountHeadGSTName,ProcessingFeePercent, ProcessingFeeAmount, ProcessingFeeGSTPercent,    AccountHeadProcessingId, AccountHeadProcessingName, SecurityFeePercent, SecurityFeeAmount,     SecuirityFeeGSTPercent, AccountHeadSecurityId, AccountHeadSecurityName, InsuranceFeePercent,    InsuranceFeeAmount, InsuranceFeeGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName,     OtherChargePercent, OtherChargeAmount, OtherChargeFeeGSTPercent, AccountHeadOtherChargeId,    AccountHeadOtherChargeName, ServiceTaxPercent, ServiceTaxAmount, ServiceTaxFeeGSTPercent, AccountHeadServiceTaxId, AccountHeadServiceTaxName, DownPaymentPercent, DownPaymentAmount, DownPaymentFeeGSTPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser,  rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: A field or property with the name 'ProcessingGSTPercent' was not found on the selected data source.
Source: System.Web
StackTrace:    at System.Web.UI.WebControls.BoundField.TryGetSimplePropertyValue(Object dataItem, Object& data)
   at System.Web.UI.WebControls.BoundField.GetValue(Control controlContainer)
   at System.Web.UI.WebControls.BoundField.OnDataBindField(Object sender, EventArgs e)
   at System.Web.UI.Control.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.Control.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource)
   at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding)
   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   at System.Web.UI.WebControls.GridView.DataBind()
   at GroupLoan_GroupLoanNoPermission.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoPermission.aspx.cs:line 86
TargetSite: Boolean TryGetSimplePropertyValue(System.Object, System.Object ByRef)

Time: 09/05/2025 05:38:38 PM
PageName: GroupLoan_GroupLoanNoPermission
String str: SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, PlanPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestRateAnnual,  GracePeriod, PenaltyRateAnnual, PenaltyAmountAnnual, AccountHeadLoanId, AccountHeadLoanName,  AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, GSTPercent,   AccountHeadGSTId, AccountHeadGSTName,ProcessingFeePercent, ProcessingFeeAmount, ProcessingFeeGSTPercent,    AccountHeadProcessingId, AccountHeadProcessingName, SecurityFeePercent, SecurityFeeAmount,     SecuirityFeeGSTPercent, AccountHeadSecurityId, AccountHeadSecurityName, InsuranceFeePercent,    InsuranceFeeAmount, InsuranceFeeGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName,     OtherChargePercent, OtherChargeAmount, OtherChargeFeeGSTPercent, AccountHeadOtherChargeId,    AccountHeadOtherChargeName, ServiceTaxPercent, ServiceTaxAmount, ServiceTaxFeeGSTPercent, AccountHeadServiceTaxId, AccountHeadServiceTaxName, DownPaymentPercent, DownPaymentAmount, DownPaymentFeeGSTPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser,  rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: A field or property with the name 'InsuranceGSTPercent' was not found on the selected data source.
Source: System.Web
StackTrace:    at System.Web.UI.WebControls.BoundField.TryGetSimplePropertyValue(Object dataItem, Object& data)
   at System.Web.UI.WebControls.BoundField.GetValue(Control controlContainer)
   at System.Web.UI.WebControls.BoundField.OnDataBindField(Object sender, EventArgs e)
   at System.Web.UI.Control.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.Control.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource)
   at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding)
   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   at System.Web.UI.WebControls.GridView.DataBind()
   at GroupLoan_GroupLoanNoPermission.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoPermission.aspx.cs:line 86
TargetSite: Boolean TryGetSimplePropertyValue(System.Object, System.Object ByRef)

Time: 09/05/2025 05:39:02 PM
PageName: GroupLoan_GroupLoanNoPermission
String str: SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, PlanPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestRateAnnual,  GracePeriod, PenaltyRateAnnual, PenaltyAmountAnnual, AccountHeadLoanId, AccountHeadLoanName,  AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, GSTPercent,   AccountHeadGSTId, AccountHeadGSTName,ProcessingFeePercent, ProcessingFeeAmount, ProcessingFeeGSTPercent,    AccountHeadProcessingId, AccountHeadProcessingName, SecurityFeePercent, SecurityFeeAmount,     SecuirityFeeGSTPercent, AccountHeadSecurityId, AccountHeadSecurityName, InsuranceFeePercent,    InsuranceFeeAmount, InsuranceFeeGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName,     OtherChargePercent, OtherChargeAmount, OtherChargeFeeGSTPercent, AccountHeadOtherChargeId,    AccountHeadOtherChargeName, ServiceTaxPercent, ServiceTaxAmount, ServiceTaxFeeGSTPercent, AccountHeadServiceTaxId, AccountHeadServiceTaxName, DownPaymentPercent, DownPaymentAmount, DownPaymentFeeGSTPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser,  rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: A field or property with the name 'FDAmountPercent' was not found on the selected data source.
Source: System.Web
StackTrace:    at System.Web.UI.WebControls.BoundField.TryGetSimplePropertyValue(Object dataItem, Object& data)
   at System.Web.UI.WebControls.BoundField.GetValue(Control controlContainer)
   at System.Web.UI.WebControls.BoundField.OnDataBindField(Object sender, EventArgs e)
   at System.Web.UI.Control.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.Control.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource)
   at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding)
   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   at System.Web.UI.WebControls.GridView.DataBind()
   at GroupLoan_GroupLoanNoPermission.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoPermission.aspx.cs:line 86
TargetSite: Boolean TryGetSimplePropertyValue(System.Object, System.Object ByRef)

Time: 09/05/2025 05:39:38 PM
PageName: GroupLoan_GroupLoanNoPermission
String str: SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, PlanPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestRateAnnual,  GracePeriod, PenaltyRateAnnual, PenaltyAmountAnnual, AccountHeadLoanId, AccountHeadLoanName,  AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, GSTPercent,   AccountHeadGSTId, AccountHeadGSTName,ProcessingFeePercent, ProcessingFeeAmount, ProcessingFeeGSTPercent,    AccountHeadProcessingId, AccountHeadProcessingName, SecurityFeePercent, SecurityFeeAmount,     SecuirityFeeGSTPercent, AccountHeadSecurityId, AccountHeadSecurityName, InsuranceFeePercent,    InsuranceFeeAmount, InsuranceFeeGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName,     OtherChargePercent, OtherChargeAmount, OtherChargeFeeGSTPercent, AccountHeadOtherChargeId,    AccountHeadOtherChargeName, ServiceTaxPercent, ServiceTaxAmount, ServiceTaxFeeGSTPercent, AccountHeadServiceTaxId, AccountHeadServiceTaxName, DownPaymentPercent, DownPaymentAmount, DownPaymentFeeGSTPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser,  rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: A field or property with the name 'FDAmountAmount' was not found on the selected data source.
Source: System.Web
StackTrace:    at System.Web.UI.WebControls.BoundField.TryGetSimplePropertyValue(Object dataItem, Object& data)
   at System.Web.UI.WebControls.BoundField.GetValue(Control controlContainer)
   at System.Web.UI.WebControls.BoundField.OnDataBindField(Object sender, EventArgs e)
   at System.Web.UI.Control.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.Control.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource)
   at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding)
   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   at System.Web.UI.WebControls.GridView.DataBind()
   at GroupLoan_GroupLoanNoPermission.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoPermission.aspx.cs:line 86
TargetSite: Boolean TryGetSimplePropertyValue(System.Object, System.Object ByRef)

Time: 09/05/2025 05:40:31 PM
PageName: GroupLoan_GroupLoanNoPermission
String str: SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, PlanPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestRateAnnual,  GracePeriod, PenaltyRateAnnual, PenaltyAmountAnnual, AccountHeadLoanId, AccountHeadLoanName,  AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, GSTPercent,   AccountHeadGSTId, AccountHeadGSTName,ProcessingFeePercent, ProcessingFeeAmount, ProcessingFeeGSTPercent,    AccountHeadProcessingId, AccountHeadProcessingName, SecurityFeePercent, SecurityFeeAmount,     SecuirityFeeGSTPercent, AccountHeadSecurityId, AccountHeadSecurityName, InsuranceFeePercent,    InsuranceFeeAmount, InsuranceFeeGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName,     OtherChargePercent, OtherChargeAmount, OtherChargeFeeGSTPercent, AccountHeadOtherChargeId,    AccountHeadOtherChargeName, ServiceTaxPercent, ServiceTaxAmount, ServiceTaxFeeGSTPercent, AccountHeadServiceTaxId, AccountHeadServiceTaxName, DownPaymentPercent, DownPaymentAmount, DownPaymentFeeGSTPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser,  rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: A field or property with the name 'AccountHeadFDAmountId' was not found on the selected data source.
Source: System.Web
StackTrace:    at System.Web.UI.WebControls.BoundField.TryGetSimplePropertyValue(Object dataItem, Object& data)
   at System.Web.UI.WebControls.BoundField.GetValue(Control controlContainer)
   at System.Web.UI.WebControls.BoundField.OnDataBindField(Object sender, EventArgs e)
   at System.Web.UI.Control.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.Control.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource)
   at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding)
   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   at System.Web.UI.WebControls.GridView.DataBind()
   at GroupLoan_GroupLoanNoPermission.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoPermission.aspx.cs:line 86
TargetSite: Boolean TryGetSimplePropertyValue(System.Object, System.Object ByRef)

Time: 09/05/2025 05:41:09 PM
PageName: GroupLoan_GroupLoanNoPermission
String str: SELECT GLoanTypeId, GroupLoanType, GLoanTypeNo, GLoanTypeName, PlanPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestRateAnnual,  GracePeriod, PenaltyRateAnnual, PenaltyAmountAnnual, AccountHeadLoanId, AccountHeadLoanName,  AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, GSTPercent,   AccountHeadGSTId, AccountHeadGSTName,ProcessingFeePercent, ProcessingFeeAmount, ProcessingFeeGSTPercent,    AccountHeadProcessingId, AccountHeadProcessingName, SecurityFeePercent, SecurityFeeAmount,     SecuirityFeeGSTPercent, AccountHeadSecurityId, AccountHeadSecurityName, InsuranceFeePercent,    InsuranceFeeAmount, InsuranceFeeGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName,     OtherChargePercent, OtherChargeAmount, OtherChargeFeeGSTPercent, AccountHeadOtherChargeId,    AccountHeadOtherChargeName, ServiceTaxPercent, ServiceTaxAmount, ServiceTaxFeeGSTPercent, AccountHeadServiceTaxId, AccountHeadServiceTaxName, DownPaymentPercent, DownPaymentAmount, DownPaymentFeeGSTPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser,  rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1  AND LoanTypeStatus='Active'  ORDER BY LoanTypeStatus, GroupLoanType, GLoanTypeNo ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: A field or property with the name 'AccountHeadRDAmountId' was not found on the selected data source.
Source: System.Web
StackTrace:    at System.Web.UI.WebControls.BoundField.TryGetSimplePropertyValue(Object dataItem, Object& data)
   at System.Web.UI.WebControls.BoundField.GetValue(Control controlContainer)
   at System.Web.UI.WebControls.BoundField.OnDataBindField(Object sender, EventArgs e)
   at System.Web.UI.Control.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.Control.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource)
   at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding)
   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   at System.Web.UI.WebControls.GridView.DataBind()
   at GroupLoan_GroupLoanNoPermission.FillData() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoPermission.aspx.cs:line 86
TargetSite: Boolean TryGetSimplePropertyValue(System.Object, System.Object ByRef)

Time: 09/05/2025 07:01:45 PM
PageName: GroupLoan_GroupLoanNoPermission
String str:  SELECT Count(1)AS Nos1 FROM GroupLoanNoPermission WHERE BranchId='1000' AND BranchName='Head Office (1000)'  AND GLoanTypeNo='VEDASHINI OJASWI-7'  AND GLoanTypeName='VEDASHINI OJASWI' 
String sql:  INSERT INTO EmployeeJoiningLetterDetail (BranchId, BranchName, GLoanTypeNo, GLoanTypeName, EntryUser, EntryTime) VALUES (  '1000', 'Head Office (1000)','VEDASHINI OJASWI-7', 'VEDASHINI OJASWI', 'root', GETDATE()  );
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid column name 'GLoanTypeNo'.
Invalid column name 'GLoanTypeName'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at ClassMaster.VoidInsUpDelTransaction(String sql, SqlTransaction trans) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 42
   at GroupLoan_GroupLoanNoPermission.btnSubmit_Click(Object sender, EventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\GroupLoan_GroupLoanNoPermission.aspx.cs:line 124
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 11/05/2025 12:28:09 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.End()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at System.Web.HttpResponse.Redirect(String url)
   at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\AdminLogOut.aspx.cs:line 45
TargetSite: Void AbortInternal()

Time: 11/05/2025 12:30:44 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.End()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at System.Web.HttpResponse.Redirect(String url)
   at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\AdminLogOut.aspx.cs:line 45
TargetSite: Void AbortInternal()

Time: 11/05/2025 02:57:24 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.End()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at System.Web.HttpResponse.Redirect(String url)
   at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\AdminLogOut.aspx.cs:line 45
TargetSite: Void AbortInternal()

Time: 11/05/2025 05:56:00 PM
PageName: RealEs_FlatDetailFull
String str: SELECT FlatId, FlatName, FlatDetail, FlatBookDetail, FlatStatus, BookingStatus FROM FlatMaster Where  FlatStatus='Active' 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: System.ComponentModel.Win32Exception (0x80004005): The network path was not found
Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at ClassMaster.DataTableResult(String query) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 164
   at RealEs_FlatDetailFull.FillFlat() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\RealEs_FlatDetailFull.aspx.cs:line 53
TargetSite: Void .ctor(System.Data.ProviderBase.DbConnectionPoolIdentity, System.Data.SqlClient.SqlConnectionString, System.Data.SqlClient.SqlCredential, System.Object, System.String, System.Security.SecureString, Boolean, System.Data.SqlClient.SqlConnectionString, System.Data.SqlClient.SessionData, System.Data.ProviderBase.DbConnectionPool, System.String, Boolean, System.Data.SqlClient.SqlAuthenticationProviderManager)

Time: 11/05/2025 05:57:16 PM
PageName: RealEs_FlatDetailFull
String str: SELECT FlatId, FlatName, FlatDetail, FlatBookDetail, FlatStatus, BookingStatus FROM FlatMaster Where  FlatStatus='Active' 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: System.ComponentModel.Win32Exception (0x80004005): The I/O operation has been aborted because of either a thread exit or an application request
Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at ClassMaster.DataTableResult(String query) in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\App_Code\ClassMaster.cs:line 164
   at RealEs_FlatDetailFull.FillFlat() in e:\ERPManagement\ERPManagement060525 (2)\ERPManagement060525\RealEs_FlatDetailFull.aspx.cs:line 53
TargetSite: Void .ctor(System.Data.ProviderBase.DbConnectionPoolIdentity, System.Data.SqlClient.SqlConnectionString, System.Data.SqlClient.SqlCredential, System.Object, System.String, System.Security.SecureString, Boolean, System.Data.SqlClient.SqlConnectionString, System.Data.SqlClient.SessionData, System.Data.ProviderBase.DbConnectionPool, System.String, Boolean, System.Data.SqlClient.SqlAuthenticationProviderManager)