------------------------------------------- 10/9/2020 10:48:40 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 10/9/2020 10:48:40 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 10/9/2020 11:14:44 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 10/9/2020 11:14:44 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 10/9/2020 12:46:39 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 10/9/2020 12:46:39 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 10/9/2020 12:50:03 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 10/9/2020 12:50:35 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 10/9/2020 12:50:35 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 10/9/2020 12:52:27 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 10/9/2020 1:02:37 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### ERROR [22007] [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. ------------------------------------------- 10/9/2020 1:02:37 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### Insert into DISTRIBUTORFILETYPESETTINGS (DistributorId,ModuleType,FileType,FileExtension,DateFormat,Period,Voucher,VoucherDate,Party,Item,SaleQuantity,FreeQuantity,CHALAN,ChalanDate,CustomerCode,ItemCode,Price,BRAND,QtyType,NamingConvension,NoOfFiles,FileSequence,DiffCutOffDate,DatePeriodKey,IsDifferentialImport) Values('000000000000002','3','13','14','dd/MMM/yyyy','4','1','1','1','1','1','1','1','1','1','1','1','0','11','2','5','PRODUCT,RETAILER,SALE,ADJUSTMENT,PURCHASE','Null','TODAY','1') ------------------------------------------- 10/9/2020 1:38:08 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 10/9/2020 1:38:08 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 10/9/2020 1:38:51 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### ERROR [22007] [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. ------------------------------------------- 10/9/2020 1:38:51 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### Insert into DISTRIBUTORFILETYPESETTINGS (DistributorId,ModuleType,FileType,FileExtension,DateFormat,Period,Voucher,VoucherDate,Party,Item,SaleQuantity,FreeQuantity,CHALAN,ChalanDate,CustomerCode,ItemCode,Price,BRAND,QtyType,NamingConvension,NoOfFiles,FileSequence,DiffCutOffDate,DatePeriodKey,IsDifferentialImport) Values('000000000000002','3','13','14','dd/MMM/yyyy','4','1','1','1','1','1','1','1','1','1','1','1','0','11','2','5','PRODUCT,RETAILER,SALE,ADJUSTMENT,PURCHASE','Null','TODAY','1') ------------------------------------------- 10/9/2020 1:50:22 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 10/9/2020 1:50:22 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 10/9/2020 1:53:10 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### ERROR [22007] [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. ------------------------------------------- 10/9/2020 1:53:10 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### Insert into DISTRIBUTORFILETYPESETTINGS (DistributorId,ModuleType,FileType,FileExtension,DateFormat,Period,Voucher,VoucherDate,Party,Item,SaleQuantity,FreeQuantity,CHALAN,ChalanDate,CustomerCode,ItemCode,Price,BRAND,QtyType,NamingConvension,NoOfFiles,FileSequence,DiffCutOffDate,DatePeriodKey,IsDifferentialImport) Values('000000000000002','3','13','14','dd/MMM/yyyy','4','1','1','1','1','1','1','1','1','1','1','1','0','11','2','5','PRODUCT,RETAILER,SALE,ADJUSTMENT,PURCHASE','Null','TODAY','1') ------------------------------------------- 10/9/2020 2:03:55 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### ERROR [22007] [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. ------------------------------------------- 10/9/2020 2:03:55 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### Insert into DISTRIBUTORFILETYPESETTINGS (DistributorId,ModuleType,FileType,FileExtension,DateFormat,Period,Voucher,VoucherDate,Party,Item,SaleQuantity,FreeQuantity,CHALAN,ChalanDate,CustomerCode,ItemCode,Price,BRAND,QtyType,NamingConvension,NoOfFiles,FileSequence,DiffCutOffDate,DatePeriodKey,IsDifferentialImport) Values('000000000000002','3','13','14','dd/MMM/yyyy','4','1','1','1','1','1','1','1','1','1','1','1','0','11','2','5','PRODUCT,RETAILER,SALE,ADJUSTMENT,PURCHASE','Null','TODAY','1') ------------------------------------------- 10/9/2020 2:13:55 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 10/9/2020 2:13:55 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 10/9/2020 2:28:24 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### ERROR [22007] [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. ------------------------------------------- 10/9/2020 2:28:24 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### Insert into DISTRIBUTORFILETYPESETTINGS (DistributorId,ModuleType,FileType,FileExtension,DateFormat,Period,Voucher,VoucherDate,Party,Item,SaleQuantity,FreeQuantity,CHALAN,ChalanDate,CustomerCode,ItemCode,Price,BRAND,QtyType,NamingConvension,NoOfFiles,FileSequence,DiffCutOffDate,DatePeriodKey,IsDifferentialImport) Values('000000000000009','3','13','14','dd/MMM/yyyy','4','1','1','1','1','1','1','1','1','1','1','1','0','11','2','5','PRODUCT,RETAILER,SALE,ADJUSTMENT,PURCHASE','Null','TODAY','1') ------------------------------------------- 10/9/2020 2:30:50 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### ERROR [22007] [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. ------------------------------------------- 10/9/2020 2:30:50 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### Insert into DISTRIBUTORFILETYPESETTINGS (DistributorId,ModuleType,FileType,FileExtension,DateFormat,Period,Voucher,VoucherDate,Party,Item,SaleQuantity,FreeQuantity,CHALAN,ChalanDate,CustomerCode,ItemCode,Price,BRAND,QtyType,NamingConvension,NoOfFiles,FileSequence,DiffCutOffDate,DatePeriodKey,IsDifferentialImport) Values('000000000000009','3','13','14','dd/MMM/yyyy','4','1','1','1','1','1','1','1','1','1','1','1','0','11','2','5','PRODUCT,RETAILER,SALE,ADJUSTMENT,PURCHASE','Null','TODAY','1') ------------------------------------------- 10/9/2020 2:37:53 PM Error in ImportOneDistributor.aspx.cs:In Page_Load() ### Before binding of the ddlDistributor dropdownlist ### ImportOneDistributor.aspx.cs:In Page_Load Function ### System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at ImportOneDistributorIFIAndDiff.Page_Load(Object sender, EventArgs e) ------------------------------------------- 10/9/2020 2:38:37 PM Error in ImportOneDistributor.aspx.cs:In Page_Load() ### Before binding of the ddlDistributor dropdownlist ### ImportOneDistributor.aspx.cs:In Page_Load Function ### System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at ImportOneDistributorIFIAndDiff.Page_Load(Object sender, EventArgs e) ------------------------------------------- 10/9/2020 2:57:31 PM Error in FolderExplorer.aspx.cs:In Page_Load() ### Before binding of the ddlFolderPath dropdownlist ### FolderExplorer.aspx.cs :ImgBtnDownload_Click() ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at FolderExplorer.ImgBtnDownload_Click(Object sender, ImageClickEventArgs e) ------------------------------------------- 10/9/2020 2:58:32 PM Error in ImportOneDistributor.aspx.cs:In Page_Load() ### Before binding of the ddlDistributor dropdownlist ### ImportOneDistributor.aspx.cs:In Page_Load Function ### System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at ImportOneDistributorIFIAndDiff.Page_Load(Object sender, EventArgs e)