/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.oleDbdaDE_SiteInfo = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.objdsDE_SiteInfo = new NBADWDataEntryApplication.dsDE_SiteInfo(); this.oleDbdacdAgency = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); this.objdscdAgency = new NBADWDataEntryApplication.dscdAgency(); this.oleDbdacdFishSpecies = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand3 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand2 = new System.Data.OleDb.OleDbCommand(); this.objdscdFishSpecies = new NBADWDataEntryApplication.dscdFishSpecies(); this.oleDbdacdFishAgeClass = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand3 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand3 = new System.Data.OleDb.OleDbCommand(); this.objdscdFishAgeClass = new NBADWDataEntryApplication.dscdFishAgeClass(); this.oleDbdaDE_ELECTSweepData = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand5 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand5 = new System.Data.OleDb.OleDbCommand(); this.objdsDE_ELECTSweepData = new NBADWDataEntryApplication.dsDE_ELECTSweepData(); this.dvDE_ELECTSweepData = new System.Data.DataView(); this.oleDbdaDE_ELECTPopEstimates = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand6 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand6 = new System.Data.OleDb.OleDbCommand(); this.objdsDE_ELECTPopEstimates = new NBADWDataEntryApplication.dsDE_ELECTPopEstimates(); this.dvDE_ELECTPopEstimates = new System.Data.DataView(); this.oleDbdacdAquaticActivityMethod = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand7 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand7 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand4 = new System.Data.OleDb.OleDbCommand(); this.objdscdAquaticActivityMethod = new NBADWDataEntryApplication.dscdAquaticActivityMethod(); this.dvcdAquaticActivityMethod = new System.Data.DataView(); this.oleDbdatblAquaticActivity = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand9 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand9 = new System.Data.OleDb.OleDbCommand(); this.objdstblAquaticActivity = new NBADWDataEntryApplication.dstblAquaticActivity(); this.oleDbdatblElectrofishingMethodDetail = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand10 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand10 = new System.Data.OleDb.OleDbCommand(); this.objdstblElectrofishingMethodDetail = new NBADWDataEntryApplication.dstblElectrofishingMethodDetail(); this.dvtblElectrofishingMethodDetail = new System.Data.DataView(); this.oleDbdaDE_ELECTSiteMeasurement = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand11 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand11 = new System.Data.OleDb.OleDbCommand(); this.objdsDE_ELECTSiteMeasurement = new NBADWDataEntryApplication.dsDE_ELECTSiteMeasurement(); this.dvDE_ELECTSiteMeasurement = new System.Data.DataView(); this.oleDbdacdOandM = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand6 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand12 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand12 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand6 = new System.Data.OleDb.OleDbCommand(); this.objdscdOandM = new NBADWDataEntryApplication.dscdOandM(); this.dvcdOandM = new System.Data.DataView(); this.oleDbdaDE_OandM_UnitofMeasure = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand13 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand13 = new System.Data.OleDb.OleDbCommand(); this.oleDbdatblPhotos = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand8 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand14 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand14 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand8 = new System.Data.OleDb.OleDbCommand(); this.objdstblPhotos = new NBADWDataEntryApplication.dstblPhotos(); this.dvtblPhotos = new System.Data.DataView(); this.oleDbdaDE_ELECTWaterMeasurement = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand15 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand15 = new System.Data.OleDb.OleDbCommand(); this.objdsDE_ELECTWaterMeasurement = new NBADWDataEntryApplication.dsDE_ELECTWaterMeasurement(); this.dvDE_ELECTWaterMeasurement = new System.Data.DataView(); this.oleDbdacdOandMValues = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand5 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand16 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand16 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand5 = new System.Data.OleDb.OleDbCommand(); this.objdscdOandMValues = new NBADWDataEntryApplication.dscdOandMValues(); this.dvcdOandMValues = new System.Data.DataView(); this.oleDbdaDE_ELECTObservations = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand17 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand17 = new System.Data.OleDb.OleDbCommand(); this.objdsDE_ELECTObservations = new NBADWDataEntryApplication.dsDE_ELECTObservations(); this.dvDE_ELECTObservations = new System.Data.DataView(); this.oleDbdaDE_OandM_Category = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand19 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand19 = new System.Data.OleDb.OleDbCommand(); this.objdsDE_OandM_Category = new NBADWDataEntryApplication.dsDE_OandM_Category(); this.dvDE_OandM_Category = new System.Data.DataView(); this.dvcdFishSpecies = new System.Data.DataView(); this.oleDbdacdFishPopulationParameter = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand18 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand18 = new System.Data.OleDb.OleDbCommand(); this.objdscdFishPopulationParameter = new NBADWDataEntryApplication.dscdFishPopulationParameter(); this.objdsDE_OandM_UnitofMeasure = new NBADWDataEntryApplication.dsDE_OandM_UnitofMeasure(); this.oleDbdaDE_OandM_Instrument = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand8 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand8 = new System.Data.OleDb.OleDbCommand(); this.dvDE_OandM_Instrument = new System.Data.DataView(); this.objdsDE_OandM_Instrument = new NBADWDataEntryApplication.dsDE_OandM_Instrument(); this.dvDE_OandM_UnitofMeasure = new System.Data.DataView(); this.dvcdFishAgeClass = new System.Data.DataView(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_SiteInfo)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdAgency)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdFishSpecies)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdFishAgeClass)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_ELECTSweepData)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_ELECTSweepData)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_ELECTPopEstimates)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_ELECTPopEstimates)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdAquaticActivityMethod)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvcdAquaticActivityMethod)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdstblAquaticActivity)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdstblElectrofishingMethodDetail)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvtblElectrofishingMethodDetail)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_ELECTSiteMeasurement)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_ELECTSiteMeasurement)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdOandM)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvcdOandM)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdstblPhotos)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvtblPhotos)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_ELECTWaterMeasurement)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_ELECTWaterMeasurement)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdOandMValues)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvcdOandMValues)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_ELECTObservations)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_ELECTObservations)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_OandM_Category)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_OandM_Category)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvcdFishSpecies)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdFishPopulationParameter)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_OandM_UnitofMeasure)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_OandM_Instrument)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_OandM_Instrument)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_OandM_UnitofMeasure)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvcdFishAgeClass)).BeginInit(); this.dgSiteDetails2.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgSiteDetails2_DeleteCommand); this.dgWaterMeasurements2.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgWaterMeasurements2_DeleteCommand); this.dgPhotos2.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgPhotos2_DeleteCommand); this.dgSweepData2.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgSweepData2_DeleteCommand); // // oleDbdaDE_SiteInfo // this.oleDbdaDE_SiteInfo.InsertCommand = this.oleDbInsertCommand1; this.oleDbdaDE_SiteInfo.SelectCommand = this.oleDbSelectCommand1; this.oleDbdaDE_SiteInfo.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-SiteInfo", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"), new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"), new System.Data.Common.DataColumnMapping("AquaticSiteDesc", "AquaticSiteDesc"), new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"), new System.Data.Common.DataColumnMapping("AquaticSiteName", "AquaticSiteName"), new System.Data.Common.DataColumnMapping("AquaticSiteUseID", "AquaticSiteUseID"), new System.Data.Common.DataColumnMapping("CoordinateSource", "CoordinateSource"), new System.Data.Common.DataColumnMapping("CoordinateSystem", "CoordinateSystem"), new System.Data.Common.DataColumnMapping("CoordinateUnits", "CoordinateUnits"), new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"), new System.Data.Common.DataColumnMapping("DrainName", "DrainName"), new System.Data.Common.DataColumnMapping("tblAquaticSite.IncorporatedInd", "tblAquaticSite.IncorporatedInd"), new System.Data.Common.DataColumnMapping("tblAquaticSiteAgencyUse.IncorporatedInd", "tblAquaticSiteAgencyUse.IncorporatedInd"), new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"), new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName"), new System.Data.Common.DataColumnMapping("XCoordinate", "XCoordinate"), new System.Data.Common.DataColumnMapping("YCoordinate", "YCoordinate")})}); // // oleDbInsertCommand1 // this.oleDbInsertCommand1.CommandText = @"INSERT INTO [DE-SiteInfo] (AgencyCd, AgencySiteID, AquaticSiteDesc, AquaticSiteID, AquaticSiteName, CoordinateSource, CoordinateSystem, CoordinateUnits, DrainageCd, DrainName, [tblAquaticSite.IncorporatedInd], [tblAquaticSiteAgencyUse.IncorporatedInd], WaterBodyID, WaterBodyName, XCoordinate, YCoordinate) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand1.Connection = this.oleDbConnection1; this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteName", System.Data.OleDb.OleDbType.VarWChar, 100, "AquaticSiteName")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSource", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSource")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSystem", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSystem")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateUnits", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateUnits")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainName", System.Data.OleDb.OleDbType.VarWChar, 255, "DrainName")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("tblAquaticSite_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "tblAquaticSite.IncorporatedInd")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("tblAquaticSiteAgencyUse_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "tblAquaticSiteAgencyUse.IncorporatedInd")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 55, "WaterBodyName")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("XCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "XCoordinate")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("YCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "YCoordinate")); // // oleDbConnection1 // try { //this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Registry Path=;Data Source=""C:\Data_Warehouse\Tabular_Data\NBAquaticDataWarehouse_DW.mdb"";Jet OLEDB:System database=;Jet OLEDB:Global Bulk Transactions=1;User ID=Admin;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:SFP=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Engine Type=5;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:Global Partial Bulk Ops=2;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Create System Database=False;Jet OLEDB:Database Locking Mode=1"; this.oleDbConnection1.ConnectionString = Session["ConnectionString"].ToString(); } catch(System.NullReferenceException) { Server.Transfer("Login.aspx"); } // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT AgencyCd, AgencySiteID, AquaticSiteDesc, AquaticSiteID, AquaticSiteName, AquaticSiteUseID, CoordinateSource, CoordinateSystem, CoordinateUnits, DrainageCd, DrainName, [tblAquaticSite.IncorporatedInd], [tblAquaticSiteAgencyUse.IncorporatedInd], WaterBodyID, WaterBodyName, XCoordinate, YCoordinate FROM [DE-SiteInfo]"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // objdsDE_SiteInfo // this.objdsDE_SiteInfo.DataSetName = "dsDE_SiteInfo"; this.objdsDE_SiteInfo.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdacdAgency // this.oleDbdacdAgency.DeleteCommand = this.oleDbDeleteCommand1; this.oleDbdacdAgency.InsertCommand = this.oleDbInsertCommand2; this.oleDbdacdAgency.SelectCommand = this.oleDbSelectCommand2; this.oleDbdacdAgency.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "cdAgency", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Agency", "Agency"), new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"), new System.Data.Common.DataColumnMapping("DataRulesInd", "DataRulesInd")})}); this.oleDbdacdAgency.UpdateCommand = this.oleDbUpdateCommand1; // // oleDbDeleteCommand1 // this.oleDbDeleteCommand1.CommandText = "DELETE FROM cdAgency WHERE (AgencyCd = ?) AND (Agency = ? OR ? IS NULL AND Agency" + " IS NULL) AND (DataRulesInd = ? OR ? IS NULL AND DataRulesInd IS NULL)"; this.oleDbDeleteCommand1.Connection = this.oleDbConnection1; this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency", System.Data.OleDb.OleDbType.VarWChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency1", System.Data.OleDb.OleDbType.VarWChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DataRulesInd", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DataRulesInd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DataRulesInd1", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DataRulesInd", System.Data.DataRowVersion.Original, null)); // // oleDbInsertCommand2 // this.oleDbInsertCommand2.CommandText = "INSERT INTO cdAgency(Agency, AgencyCd, DataRulesInd) VALUES (?, ?, ?)"; this.oleDbInsertCommand2.Connection = this.oleDbConnection1; this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency", System.Data.OleDb.OleDbType.VarWChar, 60, "Agency")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, "AgencyCd")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataRulesInd", System.Data.OleDb.OleDbType.VarWChar, 1, "DataRulesInd")); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT Agency, AgencyCd, DataRulesInd FROM cdAgency"; this.oleDbSelectCommand2.Connection = this.oleDbConnection1; // // oleDbUpdateCommand1 // this.oleDbUpdateCommand1.CommandText = "UPDATE cdAgency SET Agency = ?, AgencyCd = ?, DataRulesInd = ? WHERE (AgencyCd = " + "?) AND (Agency = ? OR ? IS NULL AND Agency IS NULL) AND (DataRulesInd = ? OR ? I" + "S NULL AND DataRulesInd IS NULL)"; this.oleDbUpdateCommand1.Connection = this.oleDbConnection1; this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency", System.Data.OleDb.OleDbType.VarWChar, 60, "Agency")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, "AgencyCd")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataRulesInd", System.Data.OleDb.OleDbType.VarWChar, 1, "DataRulesInd")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency", System.Data.OleDb.OleDbType.VarWChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency1", System.Data.OleDb.OleDbType.VarWChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DataRulesInd", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DataRulesInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DataRulesInd1", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DataRulesInd", System.Data.DataRowVersion.Original, null)); // // objdscdAgency // this.objdscdAgency.DataSetName = "dscdAgency"; this.objdscdAgency.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdacdFishSpecies // this.oleDbdacdFishSpecies.DeleteCommand = this.oleDbDeleteCommand2; this.oleDbdacdFishSpecies.InsertCommand = this.oleDbInsertCommand3; this.oleDbdacdFishSpecies.SelectCommand = this.oleDbSelectCommand3; this.oleDbdacdFishSpecies.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "cdFishSpecies", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("FishSpecies", "FishSpecies"), new System.Data.Common.DataColumnMapping("FishSpeciesCd", "FishSpeciesCd"), new System.Data.Common.DataColumnMapping("StockedInd", "StockedInd"), new System.Data.Common.DataColumnMapping("ElectrofishInd", "ElectrofishInd")})}); this.oleDbdacdFishSpecies.UpdateCommand = this.oleDbUpdateCommand2; // // oleDbDeleteCommand2 // this.oleDbDeleteCommand2.CommandText = "DELETE FROM cdFishSpecies WHERE (FishSpeciesCd = ?) AND (ElectrofishInd = ?) AND " + "(FishSpecies = ? OR ? IS NULL AND FishSpecies IS NULL) AND (StockedInd = ?)"; this.oleDbDeleteCommand2.Connection = this.oleDbConnection1; this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishSpeciesCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ElectrofishInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ElectrofishInd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishSpecies", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishSpecies", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishSpecies1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishSpecies", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StockedInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StockedInd", System.Data.DataRowVersion.Original, null)); // // oleDbInsertCommand3 // this.oleDbInsertCommand3.CommandText = "INSERT INTO cdFishSpecies(FishSpecies, FishSpeciesCd, StockedInd, ElectrofishInd)" + " VALUES (?, ?, ?, ?)"; this.oleDbInsertCommand3.Connection = this.oleDbConnection1; this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpecies", System.Data.OleDb.OleDbType.VarWChar, 30, "FishSpecies")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, "FishSpeciesCd")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("StockedInd", System.Data.OleDb.OleDbType.Boolean, 2, "StockedInd")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("ElectrofishInd", System.Data.OleDb.OleDbType.Boolean, 2, "ElectrofishInd")); // // oleDbSelectCommand3 // this.oleDbSelectCommand3.CommandText = "SELECT FishSpecies, FishSpeciesCd, StockedInd, ElectrofishInd FROM cdFishSpecies"; this.oleDbSelectCommand3.Connection = this.oleDbConnection1; // // oleDbUpdateCommand2 // this.oleDbUpdateCommand2.CommandText = "UPDATE cdFishSpecies SET FishSpecies = ?, FishSpeciesCd = ?, StockedInd = ?, Elec" + "trofishInd = ? WHERE (FishSpeciesCd = ?) AND (ElectrofishInd = ?) AND (FishSpeci" + "es = ? OR ? IS NULL AND FishSpecies IS NULL) AND (StockedInd = ?)"; this.oleDbUpdateCommand2.Connection = this.oleDbConnection1; this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpecies", System.Data.OleDb.OleDbType.VarWChar, 30, "FishSpecies")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, "FishSpeciesCd")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("StockedInd", System.Data.OleDb.OleDbType.Boolean, 2, "StockedInd")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("ElectrofishInd", System.Data.OleDb.OleDbType.Boolean, 2, "ElectrofishInd")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishSpeciesCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ElectrofishInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ElectrofishInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishSpecies", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishSpecies", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishSpecies1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishSpecies", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StockedInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StockedInd", System.Data.DataRowVersion.Original, null)); // // objdscdFishSpecies // this.objdscdFishSpecies.DataSetName = "dscdFishSpecies"; this.objdscdFishSpecies.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdacdFishAgeClass // this.oleDbdacdFishAgeClass.DeleteCommand = this.oleDbDeleteCommand3; this.oleDbdacdFishAgeClass.InsertCommand = this.oleDbInsertCommand4; this.oleDbdacdFishAgeClass.SelectCommand = this.oleDbSelectCommand4; this.oleDbdacdFishAgeClass.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "cdFishAgeClass", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("FishAgeClass", "FishAgeClass"), new System.Data.Common.DataColumnMapping("FishAgeClassCategory", "FishAgeClassCategory"), new System.Data.Common.DataColumnMapping("ElectrofishInd", "ElectrofishInd"), new System.Data.Common.DataColumnMapping("FishCountInd", "FishCountInd"), new System.Data.Common.DataColumnMapping("StockingInd", "StockingInd")})}); this.oleDbdacdFishAgeClass.UpdateCommand = this.oleDbUpdateCommand3; // // oleDbDeleteCommand3 // this.oleDbDeleteCommand3.CommandText = "DELETE FROM cdFishAgeClass WHERE (FishAgeClass = ?) AND (ElectrofishInd = ?) AND " + "(FishAgeClassCategory = ? OR ? IS NULL AND FishAgeClassCategory IS NULL) AND (Fi" + "shCountInd = ?) AND (StockingInd = ?)"; this.oleDbDeleteCommand3.Connection = this.oleDbConnection1; this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAgeClass", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ElectrofishInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ElectrofishInd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAgeClassCategory", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAgeClassCategory", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAgeClassCategory1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAgeClassCategory", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishCountInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishCountInd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StockingInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StockingInd", System.Data.DataRowVersion.Original, null)); // // oleDbInsertCommand4 // this.oleDbInsertCommand4.CommandText = "INSERT INTO cdFishAgeClass(FishAgeClass, FishAgeClassCategory, ElectrofishInd, Fi" + "shCountInd, StockingInd) VALUES (?, ?, ?, ?, ?)"; this.oleDbInsertCommand4.Connection = this.oleDbConnection1; this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 25, "FishAgeClass")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClassCategory", System.Data.OleDb.OleDbType.VarWChar, 20, "FishAgeClassCategory")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("ElectrofishInd", System.Data.OleDb.OleDbType.Boolean, 2, "ElectrofishInd")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishCountInd", System.Data.OleDb.OleDbType.Boolean, 2, "FishCountInd")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("StockingInd", System.Data.OleDb.OleDbType.Boolean, 2, "StockingInd")); // // oleDbSelectCommand4 // this.oleDbSelectCommand4.CommandText = "SELECT FishAgeClass, FishAgeClassCategory, ElectrofishInd, FishCountInd, Stocking" + "Ind FROM cdFishAgeClass"; this.oleDbSelectCommand4.Connection = this.oleDbConnection1; // // oleDbUpdateCommand3 // this.oleDbUpdateCommand3.CommandText = @"UPDATE cdFishAgeClass SET FishAgeClass = ?, FishAgeClassCategory = ?, ElectrofishInd = ?, FishCountInd = ?, StockingInd = ? WHERE (FishAgeClass = ?) AND (ElectrofishInd = ?) AND (FishAgeClassCategory = ? OR ? IS NULL AND FishAgeClassCategory IS NULL) AND (FishCountInd = ?) AND (StockingInd = ?)"; this.oleDbUpdateCommand3.Connection = this.oleDbConnection1; this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 25, "FishAgeClass")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClassCategory", System.Data.OleDb.OleDbType.VarWChar, 20, "FishAgeClassCategory")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("ElectrofishInd", System.Data.OleDb.OleDbType.Boolean, 2, "ElectrofishInd")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishCountInd", System.Data.OleDb.OleDbType.Boolean, 2, "FishCountInd")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("StockingInd", System.Data.OleDb.OleDbType.Boolean, 2, "StockingInd")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAgeClass", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ElectrofishInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ElectrofishInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAgeClassCategory", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAgeClassCategory", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAgeClassCategory1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAgeClassCategory", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishCountInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishCountInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StockingInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StockingInd", System.Data.DataRowVersion.Original, null)); // // objdscdFishAgeClass // this.objdscdFishAgeClass.DataSetName = "dscdFishAgeClass"; this.objdscdFishAgeClass.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdaDE_ELECTSweepData // this.oleDbdaDE_ELECTSweepData.InsertCommand = this.oleDbInsertCommand5; this.oleDbdaDE_ELECTSweepData.SelectCommand = this.oleDbSelectCommand5; this.oleDbdaDE_ELECTSweepData.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-ELECTSweepData", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"), new System.Data.Common.DataColumnMapping("AveForkLength_cm", "AveForkLength_cm"), new System.Data.Common.DataColumnMapping("AveTotalLength_cm", "AveTotalLength_cm"), new System.Data.Common.DataColumnMapping("AveWeight_gm", "AveWeight_gm"), new System.Data.Common.DataColumnMapping("EFDataID", "EFDataID"), new System.Data.Common.DataColumnMapping("FishAgeClass", "FishAgeClass"), new System.Data.Common.DataColumnMapping("FishSpecies", "FishSpecies"), new System.Data.Common.DataColumnMapping("PercentClipped", "PercentClipped"), new System.Data.Common.DataColumnMapping("Sweep1NoFish", "Sweep1NoFish"), new System.Data.Common.DataColumnMapping("Sweep1Time_s", "Sweep1Time_s"), new System.Data.Common.DataColumnMapping("Sweep2NoFish", "Sweep2NoFish"), new System.Data.Common.DataColumnMapping("Sweep2Time_s", "Sweep2Time_s"), new System.Data.Common.DataColumnMapping("Sweep3NoFish", "Sweep3NoFish"), new System.Data.Common.DataColumnMapping("Sweep3Time_s", "Sweep3Time_s"), new System.Data.Common.DataColumnMapping("Sweep4NoFish", "Sweep4NoFish"), new System.Data.Common.DataColumnMapping("Sweep4Time_s", "Sweep4Time_s"), new System.Data.Common.DataColumnMapping("Sweep5NoFish", "Sweep5NoFish"), new System.Data.Common.DataColumnMapping("Sweep5Time_s", "Sweep5Time_s"), new System.Data.Common.DataColumnMapping("Sweep6NoFish", "Sweep6NoFish"), new System.Data.Common.DataColumnMapping("Sweep6Time_s", "Sweep6Time_s"), new System.Data.Common.DataColumnMapping("TotalNoFish", "TotalNoFish"), new System.Data.Common.DataColumnMapping("Biomass", "Biomass"), new System.Data.Common.DataColumnMapping("Density", "Density"), new System.Data.Common.DataColumnMapping("PHS", "PHS"), new System.Data.Common.DataColumnMapping("AutoCalculatedInd", "AutoCalculatedInd"), new System.Data.Common.DataColumnMapping("FishSpeciesCd", "FishSpeciesCd"), new System.Data.Common.DataColumnMapping("Formula", "Formula")})}); // // oleDbInsertCommand5 // this.oleDbInsertCommand5.CommandText = @"INSERT INTO [DE-ELECTSweepData] (AquaticActivityID, AveForkLength_cm, AveTotalLength_cm, AveWeight_gm, FishAgeClass, FishSpecies, PercentClipped, Sweep1NoFish, Sweep1Time_s, Sweep2NoFish, Sweep2Time_s, Sweep3NoFish, Sweep3Time_s, Sweep4NoFish, Sweep4Time_s, Sweep5NoFish, Sweep5Time_s, Sweep6NoFish, Sweep6Time_s, TotalNoFish, Biomass, Density, PHS, AutoCalculatedInd, FishSpeciesCd, Formula) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand5.Connection = this.oleDbConnection1; this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveForkLength_cm", System.Data.OleDb.OleDbType.Double, 0, "AveForkLength_cm")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveTotalLength_cm", System.Data.OleDb.OleDbType.Double, 0, "AveTotalLength_cm")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveWeight_gm", System.Data.OleDb.OleDbType.Double, 0, "AveWeight_gm")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 20, "FishAgeClass")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpecies", System.Data.OleDb.OleDbType.VarWChar, 30, "FishSpecies")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("PercentClipped", System.Data.OleDb.OleDbType.Double, 0, "PercentClipped")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep1NoFish", System.Data.OleDb.OleDbType.Double, 0, "Sweep1NoFish")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep1Time_s", System.Data.OleDb.OleDbType.Double, 0, "Sweep1Time_s")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep2NoFish", System.Data.OleDb.OleDbType.Double, 0, "Sweep2NoFish")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep2Time_s", System.Data.OleDb.OleDbType.Double, 0, "Sweep2Time_s")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep3NoFish", System.Data.OleDb.OleDbType.Double, 0, "Sweep3NoFish")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep3Time_s", System.Data.OleDb.OleDbType.Double, 0, "Sweep3Time_s")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep4NoFish", System.Data.OleDb.OleDbType.Double, 0, "Sweep4NoFish")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep4Time_s", System.Data.OleDb.OleDbType.Double, 0, "Sweep4Time_s")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep5NoFish", System.Data.OleDb.OleDbType.Double, 0, "Sweep5NoFish")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep5Time_s", System.Data.OleDb.OleDbType.Double, 0, "Sweep5Time_s")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep6NoFish", System.Data.OleDb.OleDbType.Double, 0, "Sweep6NoFish")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep6Time_s", System.Data.OleDb.OleDbType.Double, 0, "Sweep6Time_s")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("TotalNoFish", System.Data.OleDb.OleDbType.Double, 0, "TotalNoFish")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Biomass", System.Data.OleDb.OleDbType.Double, 0, "Biomass")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Density", System.Data.OleDb.OleDbType.Double, 0, "Density")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("PHS", System.Data.OleDb.OleDbType.Double, 0, "PHS")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AutoCalculatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "AutoCalculatedInd")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, "FishSpeciesCd")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Formula", System.Data.OleDb.OleDbType.VarWChar, 10, "Formula")); // // oleDbSelectCommand5 // this.oleDbSelectCommand5.CommandText = @"SELECT AquaticActivityID, AveForkLength_cm, AveTotalLength_cm, AveWeight_gm, EFDataID, FishAgeClass, FishSpecies, PercentClipped, Sweep1NoFish, Sweep1Time_s, Sweep2NoFish, Sweep2Time_s, Sweep3NoFish, Sweep3Time_s, Sweep4NoFish, Sweep4Time_s, Sweep5NoFish, Sweep5Time_s, Sweep6NoFish, Sweep6Time_s, TotalNoFish, Biomass, Density, PHS, AutoCalculatedInd, FishSpeciesCd, Formula FROM [DE-ELECTSweepData]"; this.oleDbSelectCommand5.Connection = this.oleDbConnection1; // // objdsDE_ELECTSweepData // this.objdsDE_ELECTSweepData.DataSetName = "dsDE_ELECTSweepData"; this.objdsDE_ELECTSweepData.Locale = new System.Globalization.CultureInfo("en-US"); // // dvDE_ELECTSweepData // this.dvDE_ELECTSweepData.Table = this.objdsDE_ELECTSweepData._DE_ELECTSweepData; // // oleDbdaDE_ELECTPopEstimates // this.oleDbdaDE_ELECTPopEstimates.InsertCommand = this.oleDbInsertCommand6; this.oleDbdaDE_ELECTPopEstimates.SelectCommand = this.oleDbSelectCommand6; this.oleDbdaDE_ELECTPopEstimates.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-ELECTPopEstimates", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"), new System.Data.Common.DataColumnMapping("AveForkLength_cm", "AveForkLength_cm"), new System.Data.Common.DataColumnMapping("AveWeight_gm", "AveWeight_gm"), new System.Data.Common.DataColumnMapping("FishAgeClass", "FishAgeClass"), new System.Data.Common.DataColumnMapping("FishSpecies", "FishSpecies"), new System.Data.Common.DataColumnMapping("PopulationEstimate", "PopulationEstimate"), new System.Data.Common.DataColumnMapping("PopulationParameter", "PopulationParameter"), new System.Data.Common.DataColumnMapping("RelativeSizeClass", "RelativeSizeClass"), new System.Data.Common.DataColumnMapping("EFDataID", "EFDataID"), new System.Data.Common.DataColumnMapping("EFPopulationEstimateID", "EFPopulationEstimateID")})}); // // oleDbInsertCommand6 // this.oleDbInsertCommand6.CommandText = "INSERT INTO [DE-ELECTPopEstimates] (AquaticActivityID, AveForkLength_cm, AveWeigh" + "t_gm, FishAgeClass, FishSpecies, PopulationEstimate, PopulationParameter, Relati" + "veSizeClass, EFDataID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand6.Connection = this.oleDbConnection1; this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveForkLength_cm", System.Data.OleDb.OleDbType.Double, 0, "AveForkLength_cm")); this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveWeight_gm", System.Data.OleDb.OleDbType.Double, 0, "AveWeight_gm")); this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 10, "FishAgeClass")); this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpecies", System.Data.OleDb.OleDbType.VarWChar, 30, "FishSpecies")); this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("PopulationEstimate", System.Data.OleDb.OleDbType.Double, 0, "PopulationEstimate")); this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("PopulationParameter", System.Data.OleDb.OleDbType.VarWChar, 20, "PopulationParameter")); this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("RelativeSizeClass", System.Data.OleDb.OleDbType.VarWChar, 10, "RelativeSizeClass")); this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("EFDataID", System.Data.OleDb.OleDbType.Double, 0, "EFDataID")); // // oleDbSelectCommand6 // this.oleDbSelectCommand6.CommandText = "SELECT AquaticActivityID, AveForkLength_cm, AveWeight_gm, FishAgeClass, FishSpeci" + "es, PopulationEstimate, PopulationParameter, RelativeSizeClass, EFDataID, EFPopu" + "lationEstimateID FROM [DE-ELECTPopEstimates]"; this.oleDbSelectCommand6.Connection = this.oleDbConnection1; // // objdsDE_ELECTPopEstimates // this.objdsDE_ELECTPopEstimates.DataSetName = "dsDE_ELECTPopEstimates"; this.objdsDE_ELECTPopEstimates.Locale = new System.Globalization.CultureInfo("en-US"); // // dvDE_ELECTPopEstimates // this.dvDE_ELECTPopEstimates.Table = this.objdsDE_ELECTPopEstimates._DE_ELECTPopEstimates; // // oleDbdacdAquaticActivityMethod // this.oleDbdacdAquaticActivityMethod.DeleteCommand = this.oleDbDeleteCommand4; this.oleDbdacdAquaticActivityMethod.InsertCommand = this.oleDbInsertCommand7; this.oleDbdacdAquaticActivityMethod.SelectCommand = this.oleDbSelectCommand7; this.oleDbdacdAquaticActivityMethod.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "cdAquaticActivityMethod", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AquaticActivityCd", "AquaticActivityCd"), new System.Data.Common.DataColumnMapping("AquaticMethod", "AquaticMethod"), new System.Data.Common.DataColumnMapping("AquaticMethodCd", "AquaticMethodCd")})}); this.oleDbdacdAquaticActivityMethod.UpdateCommand = this.oleDbUpdateCommand4; // // oleDbDeleteCommand4 // this.oleDbDeleteCommand4.CommandText = "DELETE FROM cdAquaticActivityMethod WHERE (AquaticMethodCd = ?) AND (AquaticActiv" + "ityCd = ? OR ? IS NULL AND AquaticActivityCd IS NULL) AND (AquaticMethod = ? OR " + "? IS NULL AND AquaticMethod IS NULL)"; this.oleDbDeleteCommand4.Connection = this.oleDbConnection1; this.oleDbDeleteCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticMethodCd", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticMethodCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityCd1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticMethod", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticMethod", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticMethod1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticMethod", System.Data.DataRowVersion.Original, null)); // // oleDbInsertCommand7 // this.oleDbInsertCommand7.CommandText = "INSERT INTO cdAquaticActivityMethod(AquaticActivityCd, AquaticMethod, AquaticMeth" + "odCd) VALUES (?, ?, ?)"; this.oleDbInsertCommand7.Connection = this.oleDbConnection1; this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethod", System.Data.OleDb.OleDbType.VarWChar, 30, "AquaticMethod")); this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethodCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticMethodCd")); // // oleDbSelectCommand7 // this.oleDbSelectCommand7.CommandText = "SELECT AquaticActivityCd, AquaticMethod, AquaticMethodCd FROM cdAquaticActivityMe" + "thod"; this.oleDbSelectCommand7.Connection = this.oleDbConnection1; // // oleDbUpdateCommand4 // this.oleDbUpdateCommand4.CommandText = @"UPDATE cdAquaticActivityMethod SET AquaticActivityCd = ?, AquaticMethod = ?, AquaticMethodCd = ? WHERE (AquaticMethodCd = ?) AND (AquaticActivityCd = ? OR ? IS NULL AND AquaticActivityCd IS NULL) AND (AquaticMethod = ? OR ? IS NULL AND AquaticMethod IS NULL)"; this.oleDbUpdateCommand4.Connection = this.oleDbConnection1; this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethod", System.Data.OleDb.OleDbType.VarWChar, 30, "AquaticMethod")); this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethodCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticMethodCd")); this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticMethodCd", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticMethodCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityCd1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticMethod", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticMethod", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticMethod1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticMethod", System.Data.DataRowVersion.Original, null)); // // objdscdAquaticActivityMethod // this.objdscdAquaticActivityMethod.DataSetName = "dscdAquaticActivityMethod"; this.objdscdAquaticActivityMethod.Locale = new System.Globalization.CultureInfo("en-US"); // // dvcdAquaticActivityMethod // this.dvcdAquaticActivityMethod.RowFilter = "AquaticActivityCd=2"; this.dvcdAquaticActivityMethod.Table = this.objdscdAquaticActivityMethod.cdAquaticActivityMethod; // // oleDbdatblAquaticActivity // this.oleDbdatblAquaticActivity.InsertCommand = this.oleDbInsertCommand9; this.oleDbdatblAquaticActivity.SelectCommand = this.oleDbSelectCommand9; this.oleDbdatblAquaticActivity.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "tblAquaticActivity", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Agency2Cd", "Agency2Cd"), new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"), new System.Data.Common.DataColumnMapping("AirTemp_C", "AirTemp_C"), new System.Data.Common.DataColumnMapping("AquaticActivityCd", "AquaticActivityCd"), new System.Data.Common.DataColumnMapping("AquaticActivityEndDate", "AquaticActivityEndDate"), new System.Data.Common.DataColumnMapping("AquaticActivityEndTime", "AquaticActivityEndTime"), new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"), new System.Data.Common.DataColumnMapping("AquaticActivityLeader", "AquaticActivityLeader"), new System.Data.Common.DataColumnMapping("AquaticActivityStartDate", "AquaticActivityStartDate"), new System.Data.Common.DataColumnMapping("AquaticActivityStartTime", "AquaticActivityStartTime"), new System.Data.Common.DataColumnMapping("AquaticMethodCd", "AquaticMethodCd"), new System.Data.Common.DataColumnMapping("AquaticProgramID", "AquaticProgramID"), new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"), new System.Data.Common.DataColumnMapping("Comments", "Comments"), new System.Data.Common.DataColumnMapping("Crew", "Crew"), new System.Data.Common.DataColumnMapping("DateEntered", "DateEntered"), new System.Data.Common.DataColumnMapping("IncorporatedInd", "IncorporatedInd"), new System.Data.Common.DataColumnMapping("OldAquaticActivityID", "OldAquaticActivityID"), new System.Data.Common.DataColumnMapping("oldAquaticSiteID", "oldAquaticSiteID"), new System.Data.Common.DataColumnMapping("PrimaryActivityInd", "PrimaryActivityInd"), new System.Data.Common.DataColumnMapping("Project", "Project"), new System.Data.Common.DataColumnMapping("Siltation", "Siltation"), new System.Data.Common.DataColumnMapping("WaterLevel", "WaterLevel"), new System.Data.Common.DataColumnMapping("WaterLevel_AM_cm", "WaterLevel_AM_cm"), new System.Data.Common.DataColumnMapping("WaterLevel_cm", "WaterLevel_cm"), new System.Data.Common.DataColumnMapping("WaterLevel_PM_cm", "WaterLevel_PM_cm"), new System.Data.Common.DataColumnMapping("WaterTemp_C", "WaterTemp_C"), new System.Data.Common.DataColumnMapping("WeatherConditions", "WeatherConditions"), new System.Data.Common.DataColumnMapping("Year", "Year"), new System.Data.Common.DataColumnMapping("PermitNo", "PermitNo"), new System.Data.Common.DataColumnMapping("Agency2Contact", "Agency2Contact")})}); // // oleDbInsertCommand9 // this.oleDbInsertCommand9.CommandText = @"INSERT INTO tblAquaticActivity(Agency2Cd, AgencyCd, AirTemp_C, AquaticActivityCd, AquaticActivityEndDate, AquaticActivityEndTime, AquaticActivityID, AquaticActivityLeader, AquaticActivityStartDate, AquaticActivityStartTime, AquaticMethodCd, AquaticProgramID, AquaticSiteID, Comments, Crew, DateEntered, IncorporatedInd, OldAquaticActivityID, oldAquaticSiteID, PrimaryActivityInd, Project, Siltation, WaterLevel, WaterLevel_AM_cm, WaterLevel_cm, WaterLevel_PM_cm, WaterTemp_C, WeatherConditions, Year, PermitNo, Agency2Contact) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand9.Connection = this.oleDbConnection1; this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, "Agency2Cd")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "AirTemp_C")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityEndDate", System.Data.OleDb.OleDbType.VarWChar, 10, "AquaticActivityEndDate")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityEndTime", System.Data.OleDb.OleDbType.VarWChar, 6, "AquaticActivityEndTime")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityLeader", System.Data.OleDb.OleDbType.VarWChar, 50, "AquaticActivityLeader")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityStartDate", System.Data.OleDb.OleDbType.VarWChar, 10, "AquaticActivityStartDate")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityStartTime", System.Data.OleDb.OleDbType.VarWChar, 6, "AquaticActivityStartTime")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethodCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticMethodCd")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticProgramID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticProgramID")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Comments", System.Data.OleDb.OleDbType.VarWChar, 250, "Comments")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Crew", System.Data.OleDb.OleDbType.VarWChar, 50, "Crew")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, "DateEntered")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "IncorporatedInd")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("OldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "OldAquaticActivityID")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("oldAquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "oldAquaticSiteID")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("PrimaryActivityInd", System.Data.OleDb.OleDbType.Boolean, 2, "PrimaryActivityInd")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Project", System.Data.OleDb.OleDbType.VarWChar, 100, "Project")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Siltation", System.Data.OleDb.OleDbType.VarWChar, 50, "Siltation")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel", System.Data.OleDb.OleDbType.VarWChar, 6, "WaterLevel")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_AM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_AM_cm")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_cm")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_PM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_PM_cm")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "WaterTemp_C")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("WeatherConditions", System.Data.OleDb.OleDbType.VarWChar, 50, "WeatherConditions")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Year", System.Data.OleDb.OleDbType.VarWChar, 4, "Year")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("PermitNo", System.Data.OleDb.OleDbType.VarChar, 20, "PermitNo")); this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Contact", System.Data.OleDb.OleDbType.VarChar, 50, "Agency2Contact")); // // oleDbSelectCommand9 // this.oleDbSelectCommand9.CommandText = @"SELECT Agency2Cd, AgencyCd, AirTemp_C, AquaticActivityCd, AquaticActivityEndDate, AquaticActivityEndTime, AquaticActivityID, AquaticActivityLeader, AquaticActivityStartDate, AquaticActivityStartTime, AquaticMethodCd, AquaticProgramID, AquaticSiteID, Comments, Crew, DateEntered, IncorporatedInd, OldAquaticActivityID, oldAquaticSiteID, PrimaryActivityInd, Project, Siltation, WaterLevel, WaterLevel_AM_cm, WaterLevel_cm, WaterLevel_PM_cm, WaterTemp_C, WeatherConditions, Year, PermitNo, Agency2Contact FROM tblAquaticActivity"; this.oleDbSelectCommand9.Connection = this.oleDbConnection1; // // objdstblAquaticActivity // this.objdstblAquaticActivity.DataSetName = "dstblAquaticActivity"; this.objdstblAquaticActivity.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdatblElectrofishingMethodDetail // this.oleDbdatblElectrofishingMethodDetail.InsertCommand = this.oleDbInsertCommand10; this.oleDbdatblElectrofishingMethodDetail.SelectCommand = this.oleDbSelectCommand10; this.oleDbdatblElectrofishingMethodDetail.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "tblElectrofishingMethodDetail", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AquaticActivityDetailID", "AquaticActivityDetailID"), new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"), new System.Data.Common.DataColumnMapping("Area_m2", "Area_m2"), new System.Data.Common.DataColumnMapping("Device", "Device"), new System.Data.Common.DataColumnMapping("NoSweeps", "NoSweeps"), new System.Data.Common.DataColumnMapping("oldAquaticActivityID", "oldAquaticActivityID"), new System.Data.Common.DataColumnMapping("SiteSetup", "SiteSetup"), new System.Data.Common.DataColumnMapping("StreamLength_m", "StreamLength_m"), new System.Data.Common.DataColumnMapping("DutyCycle", "DutyCycle"), new System.Data.Common.DataColumnMapping("Frequency_Hz", "Frequency_Hz"), new System.Data.Common.DataColumnMapping("POWSetting", "POWSetting"), new System.Data.Common.DataColumnMapping("Voltage", "Voltage")})}); // // oleDbInsertCommand10 // this.oleDbInsertCommand10.CommandText = "INSERT INTO tblElectrofishingMethodDetail(AquaticActivityID, Area_m2, Device, NoS" + "weeps, oldAquaticActivityID, SiteSetup, StreamLength_m, DutyCycle, Frequency_Hz," + " POWSetting, Voltage) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand10.Connection = this.oleDbConnection1; this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Area_m2", System.Data.OleDb.OleDbType.Single, 0, "Area_m2")); this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Device", System.Data.OleDb.OleDbType.VarWChar, 10, "Device")); this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("NoSweeps", System.Data.OleDb.OleDbType.SmallInt, 0, "NoSweeps")); this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("oldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "oldAquaticActivityID")); this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("SiteSetup", System.Data.OleDb.OleDbType.VarWChar, 6, "SiteSetup")); this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("StreamLength_m", System.Data.OleDb.OleDbType.Single, 0, "StreamLength_m")); this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("DutyCycle", System.Data.OleDb.OleDbType.Double, 0, "DutyCycle")); this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Frequency_Hz", System.Data.OleDb.OleDbType.Double, 0, "Frequency_Hz")); this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("POWSetting", System.Data.OleDb.OleDbType.Double, 0, "POWSetting")); this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Voltage", System.Data.OleDb.OleDbType.Double, 0, "Voltage")); // // oleDbSelectCommand10 // this.oleDbSelectCommand10.CommandText = "SELECT AquaticActivityDetailID, AquaticActivityID, Area_m2, Device, NoSweeps, old" + "AquaticActivityID, SiteSetup, StreamLength_m, DutyCycle, Frequency_Hz, POWSettin" + "g, Voltage FROM tblElectrofishingMethodDetail"; this.oleDbSelectCommand10.Connection = this.oleDbConnection1; // // objdstblElectrofishingMethodDetail // this.objdstblElectrofishingMethodDetail.DataSetName = "dstblElectrofishingMethodDetail"; this.objdstblElectrofishingMethodDetail.Locale = new System.Globalization.CultureInfo("en-US"); // // dvtblElectrofishingMethodDetail // this.dvtblElectrofishingMethodDetail.Sort = "AquaticActivityID"; this.dvtblElectrofishingMethodDetail.Table = this.objdstblElectrofishingMethodDetail.tblElectrofishingMethodDetail; // // oleDbdaDE_ELECTSiteMeasurement // this.oleDbdaDE_ELECTSiteMeasurement.InsertCommand = this.oleDbInsertCommand11; this.oleDbdaDE_ELECTSiteMeasurement.SelectCommand = this.oleDbSelectCommand11; this.oleDbdaDE_ELECTSiteMeasurement.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-ELECTSiteMeasurement", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"), new System.Data.Common.DataColumnMapping("Instrument", "Instrument"), new System.Data.Common.DataColumnMapping("Measurement", "Measurement"), new System.Data.Common.DataColumnMapping("OandM_Parameter", "OandM_Parameter"), new System.Data.Common.DataColumnMapping("SiteMeasurementID", "SiteMeasurementID"), new System.Data.Common.DataColumnMapping("UnitofMeasure", "UnitofMeasure"), new System.Data.Common.DataColumnMapping("Bank", "Bank"), new System.Data.Common.DataColumnMapping("OandM_Group", "OandM_Group"), new System.Data.Common.DataColumnMapping("UnitofMeasureAbv", "UnitofMeasureAbv"), new System.Data.Common.DataColumnMapping("OandMCd", "OandMCd")})}); // // oleDbInsertCommand11 // this.oleDbInsertCommand11.CommandText = "INSERT INTO [DE-ELECTSiteMeasurement] (AquaticActivityID, Instrument, Measurement" + ", OandM_Parameter, UnitofMeasure, Bank, OandM_Group, UnitofMeasureAbv, OandMCd) " + "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand11.Connection = this.oleDbConnection1; this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "AquaticActivityID", System.Data.DataRowVersion.Current, null)); this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("Instrument", System.Data.OleDb.OleDbType.VarChar, 50, "Instrument")); this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("Measurement", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "Measurement", System.Data.DataRowVersion.Current, null)); this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Parameter", System.Data.OleDb.OleDbType.VarChar, 50, "OandM_Parameter")); this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("UnitofMeasure", System.Data.OleDb.OleDbType.VarChar, 50, "UnitofMeasure")); this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("Bank", System.Data.OleDb.OleDbType.VarChar, 10, "Bank")); this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Group", System.Data.OleDb.OleDbType.VarChar, 50, "OandM_Group")); this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("UnitofMeasureAbv", System.Data.OleDb.OleDbType.VarChar, 10, "UnitofMeasureAbv")); this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandMCd", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "OandMCd", System.Data.DataRowVersion.Current, null)); // // oleDbSelectCommand11 // this.oleDbSelectCommand11.CommandText = "SELECT AquaticActivityID, Instrument, Measurement, OandM_Parameter, SiteMeasureme" + "ntID, UnitofMeasure, Bank, OandM_Group, UnitofMeasureAbv, OandMCd FROM [DE-ELECT" + "SiteMeasurement]"; this.oleDbSelectCommand11.Connection = this.oleDbConnection1; // // objdsDE_ELECTSiteMeasurement // this.objdsDE_ELECTSiteMeasurement.DataSetName = "dsDE_ELECTSiteMeasurement"; this.objdsDE_ELECTSiteMeasurement.Locale = new System.Globalization.CultureInfo("en-US"); // // dvDE_ELECTSiteMeasurement // this.dvDE_ELECTSiteMeasurement.Sort = "AquaticActivityID"; this.dvDE_ELECTSiteMeasurement.Table = this.objdsDE_ELECTSiteMeasurement._DE_ELECTSiteMeasurement; // // oleDbdacdOandM // this.oleDbdacdOandM.DeleteCommand = this.oleDbDeleteCommand6; this.oleDbdacdOandM.InsertCommand = this.oleDbInsertCommand12; this.oleDbdacdOandM.SelectCommand = this.oleDbSelectCommand12; this.oleDbdacdOandM.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "cdOandM", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("OandM_Category", "OandM_Category"), new System.Data.Common.DataColumnMapping("OandM_Group", "OandM_Group"), new System.Data.Common.DataColumnMapping("OandM_Parameter", "OandM_Parameter"), new System.Data.Common.DataColumnMapping("OandM_Type", "OandM_Type"), new System.Data.Common.DataColumnMapping("OandM_ValuesInd", "OandM_ValuesInd"), new System.Data.Common.DataColumnMapping("OandMCd", "OandMCd")})}); this.oleDbdacdOandM.UpdateCommand = this.oleDbUpdateCommand6; // // oleDbDeleteCommand6 // this.oleDbDeleteCommand6.CommandText = @"DELETE FROM cdOandM WHERE (OandMCd = ?) AND (OandM_Category = ? OR ? IS NULL AND OandM_Category IS NULL) AND (OandM_Group = ? OR ? IS NULL AND OandM_Group IS NULL) AND (OandM_Parameter = ? OR ? IS NULL AND OandM_Parameter IS NULL) AND (OandM_Type = ? OR ? IS NULL AND OandM_Type IS NULL) AND (OandM_ValuesInd = ?)"; this.oleDbDeleteCommand6.Connection = this.oleDbConnection1; this.oleDbDeleteCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandMCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandMCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Category", System.Data.OleDb.OleDbType.VarWChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Category", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Category1", System.Data.OleDb.OleDbType.VarWChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Category", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Group", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Group", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Group1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Group", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Parameter", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Parameter", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Parameter1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Parameter", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Type", System.Data.OleDb.OleDbType.VarWChar, 16, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Type", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Type1", System.Data.OleDb.OleDbType.VarWChar, 16, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Type", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_ValuesInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_ValuesInd", System.Data.DataRowVersion.Original, null)); // // oleDbInsertCommand12 // this.oleDbInsertCommand12.CommandText = "INSERT INTO cdOandM(OandM_Category, OandM_Group, OandM_Parameter, OandM_Type, Oan" + "dM_ValuesInd) VALUES (?, ?, ?, ?, ?)"; this.oleDbInsertCommand12.Connection = this.oleDbConnection1; this.oleDbInsertCommand12.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Category", System.Data.OleDb.OleDbType.VarWChar, 40, "OandM_Category")); this.oleDbInsertCommand12.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Group", System.Data.OleDb.OleDbType.VarWChar, 50, "OandM_Group")); this.oleDbInsertCommand12.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Parameter", System.Data.OleDb.OleDbType.VarWChar, 50, "OandM_Parameter")); this.oleDbInsertCommand12.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Type", System.Data.OleDb.OleDbType.VarWChar, 16, "OandM_Type")); this.oleDbInsertCommand12.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_ValuesInd", System.Data.OleDb.OleDbType.Boolean, 2, "OandM_ValuesInd")); // // oleDbSelectCommand12 // this.oleDbSelectCommand12.CommandText = "SELECT OandM_Category, OandM_Group, OandM_Parameter, OandM_Type, OandM_ValuesInd," + " OandMCd FROM cdOandM"; this.oleDbSelectCommand12.Connection = this.oleDbConnection1; // // oleDbUpdateCommand6 // this.oleDbUpdateCommand6.CommandText = @"UPDATE cdOandM SET OandM_Category = ?, OandM_Group = ?, OandM_Parameter = ?, OandM_Type = ?, OandM_ValuesInd = ? WHERE (OandMCd = ?) AND (OandM_Category = ? OR ? IS NULL AND OandM_Category IS NULL) AND (OandM_Group = ? OR ? IS NULL AND OandM_Group IS NULL) AND (OandM_Parameter = ? OR ? IS NULL AND OandM_Parameter IS NULL) AND (OandM_Type = ? OR ? IS NULL AND OandM_Type IS NULL) AND (OandM_ValuesInd = ?)"; this.oleDbUpdateCommand6.Connection = this.oleDbConnection1; this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Category", System.Data.OleDb.OleDbType.VarWChar, 40, "OandM_Category")); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Group", System.Data.OleDb.OleDbType.VarWChar, 50, "OandM_Group")); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Parameter", System.Data.OleDb.OleDbType.VarWChar, 50, "OandM_Parameter")); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Type", System.Data.OleDb.OleDbType.VarWChar, 16, "OandM_Type")); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_ValuesInd", System.Data.OleDb.OleDbType.Boolean, 2, "OandM_ValuesInd")); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandMCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandMCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Category", System.Data.OleDb.OleDbType.VarWChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Category", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Category1", System.Data.OleDb.OleDbType.VarWChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Category", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Group", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Group", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Group1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Group", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Parameter", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Parameter", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Parameter1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Parameter", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Type", System.Data.OleDb.OleDbType.VarWChar, 16, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Type", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_Type1", System.Data.OleDb.OleDbType.VarWChar, 16, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_Type", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandM_ValuesInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandM_ValuesInd", System.Data.DataRowVersion.Original, null)); // // objdscdOandM // this.objdscdOandM.DataSetName = "dscdOandM"; this.objdscdOandM.Locale = new System.Globalization.CultureInfo("en-US"); // // dvcdOandM // this.dvcdOandM.Table = this.objdscdOandM.cdOandM; // // oleDbdaDE_OandM_UnitofMeasure // this.oleDbdaDE_OandM_UnitofMeasure.InsertCommand = this.oleDbInsertCommand13; this.oleDbdaDE_OandM_UnitofMeasure.SelectCommand = this.oleDbSelectCommand13; this.oleDbdaDE_OandM_UnitofMeasure.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-OandM_UnitofMeasure", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("OandMCd", "OandMCd"), new System.Data.Common.DataColumnMapping("UnitofMeasure", "UnitofMeasure"), new System.Data.Common.DataColumnMapping("UnitofMeasureCd", "UnitofMeasureCd")})}); // // oleDbInsertCommand13 // this.oleDbInsertCommand13.CommandText = "INSERT INTO [DE-OandM_UnitofMeasure] (UnitofMeasure, UnitofMeasureCd) VALUES (?, " + "?)"; this.oleDbInsertCommand13.Connection = this.oleDbConnection1; this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("UnitofMeasure", System.Data.OleDb.OleDbType.VarWChar, 50, "UnitofMeasure")); this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("UnitofMeasureCd", System.Data.OleDb.OleDbType.Integer, 0, "UnitofMeasureCd")); // // oleDbSelectCommand13 // this.oleDbSelectCommand13.CommandText = "SELECT OandMCd, UnitofMeasure, UnitofMeasureCd FROM [DE-OandM_UnitofMeasure]"; this.oleDbSelectCommand13.Connection = this.oleDbConnection1; // // oleDbdatblPhotos // this.oleDbdatblPhotos.DeleteCommand = this.oleDbDeleteCommand8; this.oleDbdatblPhotos.InsertCommand = this.oleDbInsertCommand14; this.oleDbdatblPhotos.SelectCommand = this.oleDbSelectCommand14; this.oleDbdatblPhotos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "tblPhotos", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"), new System.Data.Common.DataColumnMapping("FileName", "FileName"), new System.Data.Common.DataColumnMapping("Path", "Path"), new System.Data.Common.DataColumnMapping("PhotoID", "PhotoID")})}); this.oleDbdatblPhotos.UpdateCommand = this.oleDbUpdateCommand8; // // oleDbDeleteCommand8 // this.oleDbDeleteCommand8.CommandText = "DELETE FROM tblPhotos WHERE (PhotoID = ?) AND (AquaticActivityID = ? OR ? IS NULL" + " AND AquaticActivityID IS NULL) AND (FileName = ? OR ? IS NULL AND FileName IS N" + "ULL) AND (Path = ? OR ? IS NULL AND Path IS NULL)"; this.oleDbDeleteCommand8.Connection = this.oleDbConnection1; this.oleDbDeleteCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_PhotoID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PhotoID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FileName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FileName", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FileName1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FileName", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Path", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Path", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Path1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Path", System.Data.DataRowVersion.Original, null)); // // oleDbInsertCommand14 // this.oleDbInsertCommand14.CommandText = "INSERT INTO tblPhotos(AquaticActivityID, FileName, Path) VALUES (?, ?, ?)"; this.oleDbInsertCommand14.Connection = this.oleDbConnection1; this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("FileName", System.Data.OleDb.OleDbType.VarWChar, 50, "FileName")); this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("Path", System.Data.OleDb.OleDbType.VarWChar, 50, "Path")); // // oleDbSelectCommand14 // this.oleDbSelectCommand14.CommandText = "SELECT AquaticActivityID, FileName, Path, PhotoID FROM tblPhotos"; this.oleDbSelectCommand14.Connection = this.oleDbConnection1; // // oleDbUpdateCommand8 // this.oleDbUpdateCommand8.CommandText = "UPDATE tblPhotos SET AquaticActivityID = ?, FileName = ?, Path = ? WHERE (PhotoID" + " = ?) AND (AquaticActivityID = ? OR ? IS NULL AND AquaticActivityID IS NULL) AND" + " (FileName = ? OR ? IS NULL AND FileName IS NULL) AND (Path = ? OR ? IS NULL AND" + " Path IS NULL)"; this.oleDbUpdateCommand8.Connection = this.oleDbConnection1; this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("FileName", System.Data.OleDb.OleDbType.VarWChar, 50, "FileName")); this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Path", System.Data.OleDb.OleDbType.VarWChar, 50, "Path")); this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_PhotoID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PhotoID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FileName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FileName", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FileName1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FileName", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Path", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Path", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Path1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Path", System.Data.DataRowVersion.Original, null)); // // objdstblPhotos // this.objdstblPhotos.DataSetName = "dstblPhotos"; this.objdstblPhotos.Locale = new System.Globalization.CultureInfo("en-US"); // // dvtblPhotos // this.dvtblPhotos.Table = this.objdstblPhotos.tblPhotos; // // oleDbdaDE_ELECTWaterMeasurement // this.oleDbdaDE_ELECTWaterMeasurement.InsertCommand = this.oleDbInsertCommand15; this.oleDbdaDE_ELECTWaterMeasurement.SelectCommand = this.oleDbSelectCommand15; this.oleDbdaDE_ELECTWaterMeasurement.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-ELECTWaterMeasurement", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Instrument", "Instrument"), new System.Data.Common.DataColumnMapping("Measurement", "Measurement"), new System.Data.Common.DataColumnMapping("OandM_Parameter", "OandM_Parameter"), new System.Data.Common.DataColumnMapping("TimeofDay", "TimeofDay"), new System.Data.Common.DataColumnMapping("UnitofMeasure", "UnitofMeasure"), new System.Data.Common.DataColumnMapping("WaterDepth_m", "WaterDepth_m"), new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"), new System.Data.Common.DataColumnMapping("WaterMeasurementID", "WaterMeasurementID"), new System.Data.Common.DataColumnMapping("UnitofMeasureAbv", "UnitofMeasureAbv")})}); // // oleDbInsertCommand15 // this.oleDbInsertCommand15.CommandText = "INSERT INTO [DE-ELECTWaterMeasurement] (Instrument, Measurement, OandM_Parameter," + " TimeofDay, UnitofMeasure, WaterDepth_m, AquaticActivityID, UnitofMeasureAbv) VA" + "LUES (?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand15.Connection = this.oleDbConnection1; this.oleDbInsertCommand15.Parameters.Add(new System.Data.OleDb.OleDbParameter("Instrument", System.Data.OleDb.OleDbType.VarWChar, 50, "Instrument")); this.oleDbInsertCommand15.Parameters.Add(new System.Data.OleDb.OleDbParameter("Measurement", System.Data.OleDb.OleDbType.Single, 0, "Measurement")); this.oleDbInsertCommand15.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Parameter", System.Data.OleDb.OleDbType.VarWChar, 50, "OandM_Parameter")); this.oleDbInsertCommand15.Parameters.Add(new System.Data.OleDb.OleDbParameter("TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 5, "TimeofDay")); this.oleDbInsertCommand15.Parameters.Add(new System.Data.OleDb.OleDbParameter("UnitofMeasure", System.Data.OleDb.OleDbType.VarWChar, 50, "UnitofMeasure")); this.oleDbInsertCommand15.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterDepth_m", System.Data.OleDb.OleDbType.Single, 0, "WaterDepth_m")); this.oleDbInsertCommand15.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbInsertCommand15.Parameters.Add(new System.Data.OleDb.OleDbParameter("UnitofMeasureAbv", System.Data.OleDb.OleDbType.VarWChar, 10, "UnitofMeasureAbv")); // // oleDbSelectCommand15 // this.oleDbSelectCommand15.CommandText = "SELECT Instrument, Measurement, OandM_Parameter, TimeofDay, UnitofMeasure, WaterD" + "epth_m, AquaticActivityID, WaterMeasurementID, UnitofMeasureAbv FROM [DE-ELECTWa" + "terMeasurement]"; this.oleDbSelectCommand15.Connection = this.oleDbConnection1; // // objdsDE_ELECTWaterMeasurement // this.objdsDE_ELECTWaterMeasurement.DataSetName = "dsDE_ELECTWaterMeasurement"; this.objdsDE_ELECTWaterMeasurement.Locale = new System.Globalization.CultureInfo("en-US"); // // dvDE_ELECTWaterMeasurement // this.dvDE_ELECTWaterMeasurement.Table = this.objdsDE_ELECTWaterMeasurement._DE_ELECTWaterMeasurement; // // oleDbdacdOandMValues // this.oleDbdacdOandMValues.DeleteCommand = this.oleDbDeleteCommand5; this.oleDbdacdOandMValues.InsertCommand = this.oleDbInsertCommand16; this.oleDbdacdOandMValues.SelectCommand = this.oleDbSelectCommand16; this.oleDbdacdOandMValues.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "cdOandMValues", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("OandMCd", "OandMCd"), new System.Data.Common.DataColumnMapping("OandMValuesCd", "OandMValuesCd"), new System.Data.Common.DataColumnMapping("Value", "Value")})}); this.oleDbdacdOandMValues.UpdateCommand = this.oleDbUpdateCommand5; // // oleDbDeleteCommand5 // this.oleDbDeleteCommand5.CommandText = "DELETE FROM cdOandMValues WHERE (OandMValuesCd = ?) AND (OandMCd = ? OR ? IS NULL" + " AND OandMCd IS NULL) AND (Value = ? OR ? IS NULL AND Value IS NULL)"; this.oleDbDeleteCommand5.Connection = this.oleDbConnection1; this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandMValuesCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandMValuesCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandMCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandMCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandMCd1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandMCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Value", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Value", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Value1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Value", System.Data.DataRowVersion.Original, null)); // // oleDbInsertCommand16 // this.oleDbInsertCommand16.CommandText = "INSERT INTO cdOandMValues(OandMCd, Value) VALUES (?, ?)"; this.oleDbInsertCommand16.Connection = this.oleDbConnection1; this.oleDbInsertCommand16.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandMCd", System.Data.OleDb.OleDbType.Integer, 0, "OandMCd")); this.oleDbInsertCommand16.Parameters.Add(new System.Data.OleDb.OleDbParameter("Value", System.Data.OleDb.OleDbType.VarWChar, 20, "Value")); // // oleDbSelectCommand16 // this.oleDbSelectCommand16.CommandText = "SELECT OandMCd, OandMValuesCd, Value FROM cdOandMValues"; this.oleDbSelectCommand16.Connection = this.oleDbConnection1; // // oleDbUpdateCommand5 // this.oleDbUpdateCommand5.CommandText = "UPDATE cdOandMValues SET OandMCd = ?, Value = ? WHERE (OandMValuesCd = ?) AND (Oa" + "ndMCd = ? OR ? IS NULL AND OandMCd IS NULL) AND (Value = ? OR ? IS NULL AND Valu" + "e IS NULL)"; this.oleDbUpdateCommand5.Connection = this.oleDbConnection1; this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandMCd", System.Data.OleDb.OleDbType.Integer, 0, "OandMCd")); this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Value", System.Data.OleDb.OleDbType.VarWChar, 20, "Value")); this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandMValuesCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandMValuesCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandMCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandMCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OandMCd1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OandMCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Value", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Value", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Value1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Value", System.Data.DataRowVersion.Original, null)); // // objdscdOandMValues // this.objdscdOandMValues.DataSetName = "dscdOandMValues"; this.objdscdOandMValues.Locale = new System.Globalization.CultureInfo("en-US"); // // dvcdOandMValues // this.dvcdOandMValues.Table = this.objdscdOandMValues.cdOandMValues; // // oleDbdaDE_ELECTObservations // this.oleDbdaDE_ELECTObservations.InsertCommand = this.oleDbInsertCommand17; this.oleDbdaDE_ELECTObservations.SelectCommand = this.oleDbSelectCommand17; this.oleDbdaDE_ELECTObservations.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-ELECTObservations", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"), new System.Data.Common.DataColumnMapping("FishPassageObstructionInd", "FishPassageObstructionInd"), new System.Data.Common.DataColumnMapping("OandM_Other", "OandM_Other"), new System.Data.Common.DataColumnMapping("OandM_Parameter", "OandM_Parameter"), new System.Data.Common.DataColumnMapping("OandMCd", "OandMCd"), new System.Data.Common.DataColumnMapping("OandMValuesCd", "OandMValuesCd"), new System.Data.Common.DataColumnMapping("ObservationID", "ObservationID"), new System.Data.Common.DataColumnMapping("PipeSize_cm", "PipeSize_cm"), new System.Data.Common.DataColumnMapping("Value", "Value")})}); // // oleDbInsertCommand17 // this.oleDbInsertCommand17.CommandText = "INSERT INTO [DE-ELECTObservations] (AquaticActivityID, FishPassageObstructionInd," + " OandM_Other, OandM_Parameter, OandMCd, OandMValuesCd, PipeSize_cm, Value) VALUE" + "S (?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand17.Connection = this.oleDbConnection1; this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishPassageObstructionInd", System.Data.OleDb.OleDbType.Boolean, 2, "FishPassageObstructionInd")); this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Other", System.Data.OleDb.OleDbType.VarWChar, 50, "OandM_Other")); this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Parameter", System.Data.OleDb.OleDbType.VarWChar, 50, "OandM_Parameter")); this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandMCd", System.Data.OleDb.OleDbType.Integer, 0, "OandMCd")); this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandMValuesCd", System.Data.OleDb.OleDbType.Integer, 0, "OandMValuesCd")); this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("PipeSize_cm", System.Data.OleDb.OleDbType.Integer, 0, "PipeSize_cm")); this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("Value", System.Data.OleDb.OleDbType.VarWChar, 20, "Value")); // // oleDbSelectCommand17 // this.oleDbSelectCommand17.CommandText = "SELECT AquaticActivityID, FishPassageObstructionInd, OandM_Other, OandM_Parameter" + ", OandMCd, OandMValuesCd, ObservationID, PipeSize_cm, Value FROM [DE-ELECTObserv" + "ations]"; this.oleDbSelectCommand17.Connection = this.oleDbConnection1; // // objdsDE_ELECTObservations // this.objdsDE_ELECTObservations.DataSetName = "dsDE_ELECTObservations"; this.objdsDE_ELECTObservations.Locale = new System.Globalization.CultureInfo("en-US"); // // dvDE_ELECTObservations // this.dvDE_ELECTObservations.Table = this.objdsDE_ELECTObservations._DE_ELECTObservations; // // oleDbdaDE_OandM_Category // this.oleDbdaDE_OandM_Category.InsertCommand = this.oleDbInsertCommand19; this.oleDbdaDE_OandM_Category.SelectCommand = this.oleDbSelectCommand19; this.oleDbdaDE_OandM_Category.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-OandM_Category", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("OandM_Category", "OandM_Category"), new System.Data.Common.DataColumnMapping("OandM_Group", "OandM_Group")})}); // // oleDbInsertCommand19 // this.oleDbInsertCommand19.CommandText = "INSERT INTO [DE-OandM_Category] (OandM_Category, OandM_Group) VALUES (?, ?)"; this.oleDbInsertCommand19.Connection = this.oleDbConnection1; this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Category", System.Data.OleDb.OleDbType.VarWChar, 40, "OandM_Category")); this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("OandM_Group", System.Data.OleDb.OleDbType.VarWChar, 50, "OandM_Group")); // // oleDbSelectCommand19 // this.oleDbSelectCommand19.CommandText = "SELECT OandM_Category, OandM_Group FROM [DE-OandM_Category]"; this.oleDbSelectCommand19.Connection = this.oleDbConnection1; // // objdsDE_OandM_Category // this.objdsDE_OandM_Category.DataSetName = "dsDE_OandM_Category"; this.objdsDE_OandM_Category.Locale = new System.Globalization.CultureInfo("en-US"); // // dvDE_OandM_Category // this.dvDE_OandM_Category.Table = this.objdsDE_OandM_Category._DE_OandM_Category; // // dvcdFishSpecies // this.dvcdFishSpecies.RowFilter = "ElectrofishInd"; this.dvcdFishSpecies.Table = this.objdscdFishSpecies.cdFishSpecies; // // oleDbdacdFishPopulationParameter // this.oleDbdacdFishPopulationParameter.InsertCommand = this.oleDbInsertCommand18; this.oleDbdacdFishPopulationParameter.SelectCommand = this.oleDbSelectCommand18; this.oleDbdacdFishPopulationParameter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "cdFishPopulationParameter", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("PopulationParameter", "PopulationParameter")})}); // // oleDbInsertCommand18 // this.oleDbInsertCommand18.CommandText = "INSERT INTO cdFishPopulationParameter(PopulationParameter) VALUES (?)"; this.oleDbInsertCommand18.Connection = this.oleDbConnection1; this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("PopulationParameter", System.Data.OleDb.OleDbType.VarWChar, 20, "PopulationParameter")); // // oleDbSelectCommand18 // this.oleDbSelectCommand18.CommandText = "SELECT PopulationParameter FROM cdFishPopulationParameter"; this.oleDbSelectCommand18.Connection = this.oleDbConnection1; // // objdscdFishPopulationParameter // this.objdscdFishPopulationParameter.DataSetName = "dscdFishPopulationParameter"; this.objdscdFishPopulationParameter.Locale = new System.Globalization.CultureInfo("en-US"); // // objdsDE_OandM_UnitofMeasure // this.objdsDE_OandM_UnitofMeasure.DataSetName = "dsDE_OandM_UnitofMeasure"; this.objdsDE_OandM_UnitofMeasure.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdaDE_OandM_Instrument // this.oleDbdaDE_OandM_Instrument.InsertCommand = this.oleDbInsertCommand8; this.oleDbdaDE_OandM_Instrument.SelectCommand = this.oleDbSelectCommand8; this.oleDbdaDE_OandM_Instrument.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-OandM_Instrument", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Instrument", "Instrument"), new System.Data.Common.DataColumnMapping("InstrumentCd", "InstrumentCd"), new System.Data.Common.DataColumnMapping("OandMCd", "OandMCd")})}); // // oleDbInsertCommand8 // this.oleDbInsertCommand8.CommandText = "INSERT INTO [DE-OandM_Instrument] (Instrument) VALUES (?)"; this.oleDbInsertCommand8.Connection = this.oleDbConnection1; this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Instrument", System.Data.OleDb.OleDbType.VarWChar, 50, "Instrument")); // // oleDbSelectCommand8 // this.oleDbSelectCommand8.CommandText = "SELECT Instrument, InstrumentCd, OandMCd FROM [DE-OandM_Instrument]"; this.oleDbSelectCommand8.Connection = this.oleDbConnection1; // // dvDE_OandM_Instrument // this.dvDE_OandM_Instrument.Table = this.objdsDE_OandM_Instrument._DE_OandM_Instrument; // // objdsDE_OandM_Instrument // this.objdsDE_OandM_Instrument.DataSetName = "dsDE_OandM_Instrument"; this.objdsDE_OandM_Instrument.Locale = new System.Globalization.CultureInfo("en-US"); // // dvDE_OandM_UnitofMeasure // this.dvDE_OandM_UnitofMeasure.Table = this.objdsDE_OandM_UnitofMeasure._DE_OandM_UnitofMeasure; // // dvcdFishAgeClass // this.dvcdFishAgeClass.RowFilter = "ElectrofishInd"; this.dvcdFishAgeClass.Table = this.objdscdFishAgeClass.cdFishAgeClass; ((System.ComponentModel.ISupportInitialize)(this.objdsDE_SiteInfo)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdAgency)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdFishSpecies)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdFishAgeClass)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_ELECTSweepData)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_ELECTSweepData)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_ELECTPopEstimates)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_ELECTPopEstimates)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdAquaticActivityMethod)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvcdAquaticActivityMethod)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdstblAquaticActivity)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdstblElectrofishingMethodDetail)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvtblElectrofishingMethodDetail)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_ELECTSiteMeasurement)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_ELECTSiteMeasurement)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdOandM)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvcdOandM)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdstblPhotos)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvtblPhotos)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_ELECTWaterMeasurement)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_ELECTWaterMeasurement)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdOandMValues)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvcdOandMValues)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_ELECTObservations)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_ELECTObservations)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_OandM_Category)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_OandM_Category)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvcdFishSpecies)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdFishPopulationParameter)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_OandM_UnitofMeasure)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_OandM_Instrument)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_OandM_Instrument)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_OandM_UnitofMeasure)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvcdFishAgeClass)).EndInit(); }
public void LoadSweepData() { // Create a new dataset to hold the records returned from the call to FillDataSet. // A temporary dataset is used because filling the existing dataset would // require the databindings to be rebound. NBADWDataEntryApplication.dsDE_ELECTSweepData objDataSetTemp1; objDataSetTemp1 = new NBADWDataEntryApplication.dsDE_ELECTSweepData(); try { // Attempt to fill the temporary dataset. this.FillSweepData(objDataSetTemp1); } catch (System.Exception eFillDataSet) { // Add your error handling code here. throw eFillDataSet; } try { // Empty the old records from the dataset. objdsDE_ELECTSweepData.Clear(); // Merge the records into the main dataset. objdsDE_ELECTSweepData.Merge(objDataSetTemp1); } catch (System.Exception eLoadMerge) { // Add your error handling code here. throw eLoadMerge; } }