public void LoadSweepCodes()
{
// 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.dscdFishSpecies objDataSetTemp1;
NBADWDataEntryApplication.dscdFishAgeClass objDataSetTemp2;
objDataSetTemp1 = new NBADWDataEntryApplication.dscdFishSpecies();
objDataSetTemp2 = new NBADWDataEntryApplication.dscdFishAgeClass();
try
{
// Attempt to fill the temporary dataset.
this.FillSweepCodes(objDataSetTemp1,objDataSetTemp2);
}
catch (System.Exception eFillDataSet)
{
// Add your error handling code here.
throw eFillDataSet;
}
try
{
// Empty the old records from the dataset.
this.objdscdFishSpecies.Clear();
this.objdscdFishAgeClass.Clear();
// Merge the records into the main dataset.
this.objdscdFishSpecies.Merge(objDataSetTemp1);
this.objdscdFishAgeClass.Merge(objDataSetTemp2);
}
catch (System.Exception eLoadMerge)
{
// Add your error handling code here.
throw eLoadMerge;
}
}
/// <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();
}
/// <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.oleDbdatblStockedFish = 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.objdstblStockedFish = new NBADWDataEntryApplication.dstblStockedFish();
this.oleDbdacdFishSpecies = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbDeleteCommand6 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand9 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand9 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand6 = new System.Data.OleDb.OleDbCommand();
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.oleDbdaDE_Hatcheries = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbInsertCommand4 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand();
this.objdsDE_Hatcheries = new NBADWDataEntryApplication.dsDE_Hatcheries();
this.oleDbdacdFishAgeClass = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbDeleteCommand7 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection2 = new System.Data.OleDb.OleDbConnection();
this.oleDbInsertCommand10 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand10 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand7 = new System.Data.OleDb.OleDbCommand();
this.oleDbDeleteCommand3 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand5 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand5 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand3 = new System.Data.OleDb.OleDbCommand();
this.objdscdFishAgeClass = new NBADWDataEntryApplication.dscdFishAgeClass();
this.oleDbdacdFishMark = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbDeleteCommand4 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand6 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand6 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand4 = new System.Data.OleDb.OleDbCommand();
this.objdscdFishMark = new NBADWDataEntryApplication.dscdFishMark();
this.dvcdFishSpecies = new System.Data.DataView();
this.dvDE_Hatcheries = new System.Data.DataView();
this.dvcdFishMark = new System.Data.DataView();
this.dvcdFishAgeClass = new System.Data.DataView();
this.oleDbdaDE_FishStock = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbInsertCommand7 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand7 = new System.Data.OleDb.OleDbCommand();
this.objdsDE_FishStock = new NBADWDataEntryApplication.dsDE_FishStock();
this.dvDE_FishStock = new System.Data.DataView();
this.oleDbdatblAquaticActivity = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbDeleteCommand5 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand8 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand8 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand5 = new System.Data.OleDb.OleDbCommand();
this.objdstblAquaticActivity = new NBADWDataEntryApplication.dstblAquaticActivity();
this.oleDbSelectCommand11 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand11 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand8 = new System.Data.OleDb.OleDbCommand();
this.oleDbDeleteCommand8 = new System.Data.OleDb.OleDbCommand();
((System.ComponentModel.ISupportInitialize)(this.objdsDE_SiteInfo)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.objdstblStockedFish)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.objdscdFishSpecies)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.objdsDE_Hatcheries)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.objdscdFishAgeClass)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.objdscdFishMark)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvcdFishSpecies)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvDE_Hatcheries)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvcdFishMark)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvcdFishAgeClass)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.objdsDE_FishStock)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvDE_FishStock)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.objdstblAquaticActivity)).BeginInit();
//
// 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:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=""C:\Data_Warehouse\Tabular_Data\DE-HRAA.mdb"";Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=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");
//
// oleDbdatblStockedFish
//
this.oleDbdatblStockedFish.DeleteCommand = this.oleDbDeleteCommand1;
this.oleDbdatblStockedFish.InsertCommand = this.oleDbInsertCommand2;
this.oleDbdatblStockedFish.SelectCommand = this.oleDbSelectCommand2;
this.oleDbdatblStockedFish.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "tblStockedFish", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("AgeUnitOfMeasure", "AgeUnitOfMeasure"),
new System.Data.Common.DataColumnMapping("AppliedMarkCd", "AppliedMarkCd"),
new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"),
new System.Data.Common.DataColumnMapping("AveLength_cm", "AveLength_cm"),
new System.Data.Common.DataColumnMapping("AveWeight_gm", "AveWeight_gm"),
new System.Data.Common.DataColumnMapping("FishAge", "FishAge"),
new System.Data.Common.DataColumnMapping("FishAgeClass", "FishAgeClass"),
new System.Data.Common.DataColumnMapping("FishFacilityID", "FishFacilityID"),
new System.Data.Common.DataColumnMapping("FishLengthType", "FishLengthType"),
new System.Data.Common.DataColumnMapping("FishMatingID", "FishMatingID"),
new System.Data.Common.DataColumnMapping("FishSpeciesCd", "FishSpeciesCd"),
new System.Data.Common.DataColumnMapping("FishStockID", "FishStockID"),
new System.Data.Common.DataColumnMapping("FishStockingID", "FishStockingID"),
new System.Data.Common.DataColumnMapping("FishStrainCd", "FishStrainCd"),
new System.Data.Common.DataColumnMapping("FishTankNo", "FishTankNo"),
new System.Data.Common.DataColumnMapping("LengthRange_cm", "LengthRange_cm"),
new System.Data.Common.DataColumnMapping("NoFish", "NoFish"),
new System.Data.Common.DataColumnMapping("NoFishMeasured", "NoFishMeasured"),
new System.Data.Common.DataColumnMapping("oldAquaticActivityID", "oldAquaticActivityID"),
new System.Data.Common.DataColumnMapping("SatelliteRearedInd", "SatelliteRearedInd"),
new System.Data.Common.DataColumnMapping("siteuseid", "siteuseid"),
new System.Data.Common.DataColumnMapping("Source", "Source"),
new System.Data.Common.DataColumnMapping("WeightRange_gm", "WeightRange_gm"),
new System.Data.Common.DataColumnMapping("OtherFishFacility", "OtherFishFacility"),
new System.Data.Common.DataColumnMapping("OtherStock", "OtherStock"),
new System.Data.Common.DataColumnMapping("BroodstockInd", "BroodstockInd")})});
this.oleDbdatblStockedFish.UpdateCommand = this.oleDbUpdateCommand1;
//
// oleDbDeleteCommand1
//
this.oleDbDeleteCommand1.CommandText = "DELETE FROM tblStockedFish WHERE (FishStockingID = ?) AND (AgeUnitOfMeasure = ? O" +
"R ? IS NULL AND AgeUnitOfMeasure IS NULL) AND (AppliedMarkCd = ? OR ? IS NULL AN" +
"D AppliedMarkCd IS NULL) AND (AquaticActivityID = ? OR ? IS NULL AND AquaticActi" +
"vityID IS NULL) AND (AveLength_cm = ? OR ? IS NULL AND AveLength_cm IS NULL) AND" +
" (AveWeight_gm = ? OR ? IS NULL AND AveWeight_gm IS NULL) AND (BroodstockInd = ?" +
") AND (FishAge = ? OR ? IS NULL AND FishAge IS NULL) AND (FishAgeClass = ? OR ? " +
"IS NULL AND FishAgeClass IS NULL) AND (FishFacilityID = ? OR ? IS NULL AND FishF" +
"acilityID IS NULL) AND (FishLengthType = ? OR ? IS NULL AND FishLengthType IS NU" +
"LL) AND (FishMatingID = ? OR ? IS NULL AND FishMatingID IS NULL) AND (FishSpecie" +
"sCd = ? OR ? IS NULL AND FishSpeciesCd IS NULL) AND (FishStockID = ? OR ? IS NUL" +
"L AND FishStockID IS NULL) AND (FishStrainCd = ? OR ? IS NULL AND FishStrainCd I" +
"S NULL) AND (FishTankNo = ? OR ? IS NULL AND FishTankNo IS NULL) AND (LengthRang" +
"e_cm = ? OR ? IS NULL AND LengthRange_cm IS NULL) AND (NoFish = ? OR ? IS NULL A" +
"ND NoFish IS NULL) AND (NoFishMeasured = ? OR ? IS NULL AND NoFishMeasured IS NU" +
"LL) AND (OtherFishFacility = ? OR ? IS NULL AND OtherFishFacility IS NULL) AND (" +
"OtherStock = ? OR ? IS NULL AND OtherStock IS NULL) AND (SatelliteRearedInd = ?)" +
" AND (Source = ? OR ? IS NULL AND Source IS NULL) AND (WeightRange_gm = ? OR ? I" +
"S NULL AND WeightRange_gm IS NULL) AND (oldAquaticActivityID = ? OR ? IS NULL AN" +
"D oldAquaticActivityID IS NULL) AND (siteuseid = ? OR ? IS NULL AND siteuseid IS" +
" NULL)";
this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishStockingID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishStockingID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgeUnitOfMeasure", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgeUnitOfMeasure", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgeUnitOfMeasure1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgeUnitOfMeasure", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AppliedMarkCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AppliedMarkCd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AppliedMarkCd1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AppliedMarkCd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.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.oleDbDeleteCommand1.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.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AveLength_cm", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AveLength_cm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AveLength_cm1", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AveLength_cm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AveWeight_gm", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AveWeight_gm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AveWeight_gm1", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AveWeight_gm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_BroodstockInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "BroodstockInd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAge", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAge", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAge1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAge", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAgeClass", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAgeClass1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAgeClass", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishFacilityID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishFacilityID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishFacilityID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishFacilityID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishLengthType", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishLengthType", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishLengthType1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishLengthType", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMatingID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMatingID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMatingID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMatingID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.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.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishSpeciesCd1", System.Data.OleDb.OleDbType.VarWChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishSpeciesCd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishStockID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishStockID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishStockID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishStockID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishStrainCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishStrainCd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishStrainCd1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishStrainCd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishTankNo", System.Data.OleDb.OleDbType.VarWChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishTankNo", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishTankNo1", System.Data.OleDb.OleDbType.VarWChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishTankNo", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_LengthRange_cm", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "LengthRange_cm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_LengthRange_cm1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "LengthRange_cm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_NoFish", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "NoFish", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_NoFish1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "NoFish", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_NoFishMeasured", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "NoFishMeasured", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_NoFishMeasured1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "NoFishMeasured", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OtherFishFacility", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OtherFishFacility", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OtherFishFacility1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OtherFishFacility", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OtherStock", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OtherStock", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OtherStock1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OtherStock", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SatelliteRearedInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SatelliteRearedInd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Source", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Source", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Source1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Source", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WeightRange_gm", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WeightRange_gm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WeightRange_gm1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WeightRange_gm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticActivityID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticActivityID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticActivityID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_siteuseid", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "siteuseid", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_siteuseid1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "siteuseid", System.Data.DataRowVersion.Original, null));
//
// oleDbInsertCommand2
//
this.oleDbInsertCommand2.CommandText = @"INSERT INTO tblStockedFish(AgeUnitOfMeasure, AppliedMarkCd, AquaticActivityID, AveLength_cm, AveWeight_gm, FishAge, FishAgeClass, FishFacilityID, FishLengthType, FishMatingID, FishSpeciesCd, FishStockID, FishStrainCd, FishTankNo, LengthRange_cm, NoFish, NoFishMeasured, oldAquaticActivityID, SatelliteRearedInd, siteuseid, Source, WeightRange_gm, OtherFishFacility, OtherStock, BroodstockInd) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
this.oleDbInsertCommand2.Connection = this.oleDbConnection1;
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgeUnitOfMeasure", System.Data.OleDb.OleDbType.VarWChar, 10, "AgeUnitOfMeasure"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AppliedMarkCd", System.Data.OleDb.OleDbType.Integer, 0, "AppliedMarkCd"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveLength_cm", System.Data.OleDb.OleDbType.Double, 0, "AveLength_cm"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveWeight_gm", System.Data.OleDb.OleDbType.Double, 0, "AveWeight_gm"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAge", System.Data.OleDb.OleDbType.VarWChar, 10, "FishAge"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 20, "FishAgeClass"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishFacilityID", System.Data.OleDb.OleDbType.Integer, 0, "FishFacilityID"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishLengthType", System.Data.OleDb.OleDbType.VarWChar, 10, "FishLengthType"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishMatingID", System.Data.OleDb.OleDbType.Integer, 0, "FishMatingID"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, "FishSpeciesCd"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishStockID", System.Data.OleDb.OleDbType.Integer, 0, "FishStockID"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishStrainCd", System.Data.OleDb.OleDbType.Integer, 0, "FishStrainCd"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishTankNo", System.Data.OleDb.OleDbType.VarWChar, 2, "FishTankNo"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("LengthRange_cm", System.Data.OleDb.OleDbType.VarWChar, 20, "LengthRange_cm"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("NoFish", System.Data.OleDb.OleDbType.Integer, 0, "NoFish"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("NoFishMeasured", System.Data.OleDb.OleDbType.Integer, 0, "NoFishMeasured"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("oldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "oldAquaticActivityID"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SatelliteRearedInd", System.Data.OleDb.OleDbType.Boolean, 2, "SatelliteRearedInd"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("siteuseid", System.Data.OleDb.OleDbType.Integer, 0, "siteuseid"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Source", System.Data.OleDb.OleDbType.VarWChar, 50, "Source"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("WeightRange_gm", System.Data.OleDb.OleDbType.VarWChar, 20, "WeightRange_gm"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("OtherFishFacility", System.Data.OleDb.OleDbType.VarWChar, 50, "OtherFishFacility"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("OtherStock", System.Data.OleDb.OleDbType.VarWChar, 50, "OtherStock"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("BroodstockInd", System.Data.OleDb.OleDbType.Boolean, 2, "BroodstockInd"));
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = @"SELECT AgeUnitOfMeasure, AppliedMarkCd, AquaticActivityID, AveLength_cm, AveWeight_gm, FishAge, FishAgeClass, FishFacilityID, FishLengthType, FishMatingID, FishSpeciesCd, FishStockID, FishStockingID, FishStrainCd, FishTankNo, LengthRange_cm, NoFish, NoFishMeasured, oldAquaticActivityID, SatelliteRearedInd, siteuseid, Source, WeightRange_gm, OtherFishFacility, OtherStock, BroodstockInd FROM tblStockedFish";
this.oleDbSelectCommand2.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand1
//
this.oleDbUpdateCommand1.CommandText = "UPDATE tblStockedFish SET AgeUnitOfMeasure = ?, AppliedMarkCd = ?, AquaticActivit" +
"yID = ?, AveLength_cm = ?, AveWeight_gm = ?, FishAge = ?, FishAgeClass = ?, Fish" +
"FacilityID = ?, FishLengthType = ?, FishMatingID = ?, FishSpeciesCd = ?, FishSto" +
"ckID = ?, FishStrainCd = ?, FishTankNo = ?, LengthRange_cm = ?, NoFish = ?, NoFi" +
"shMeasured = ?, oldAquaticActivityID = ?, SatelliteRearedInd = ?, siteuseid = ?," +
" Source = ?, WeightRange_gm = ?, OtherFishFacility = ?, OtherStock = ?, Broodsto" +
"ckInd = ? WHERE (FishStockingID = ?) AND (AgeUnitOfMeasure = ? OR ? IS NULL AND " +
"AgeUnitOfMeasure IS NULL) AND (AppliedMarkCd = ? OR ? IS NULL AND AppliedMarkCd " +
"IS NULL) AND (AquaticActivityID = ? OR ? IS NULL AND AquaticActivityID IS NULL) " +
"AND (AveLength_cm = ? OR ? IS NULL AND AveLength_cm IS NULL) AND (AveWeight_gm =" +
" ? OR ? IS NULL AND AveWeight_gm IS NULL) AND (BroodstockInd = ?) AND (FishAge =" +
" ? OR ? IS NULL AND FishAge IS NULL) AND (FishAgeClass = ? OR ? IS NULL AND Fish" +
"AgeClass IS NULL) AND (FishFacilityID = ? OR ? IS NULL AND FishFacilityID IS NUL" +
"L) AND (FishLengthType = ? OR ? IS NULL AND FishLengthType IS NULL) AND (FishMat" +
"ingID = ? OR ? IS NULL AND FishMatingID IS NULL) AND (FishSpeciesCd = ? OR ? IS " +
"NULL AND FishSpeciesCd IS NULL) AND (FishStockID = ? OR ? IS NULL AND FishStockI" +
"D IS NULL) AND (FishStrainCd = ? OR ? IS NULL AND FishStrainCd IS NULL) AND (Fis" +
"hTankNo = ? OR ? IS NULL AND FishTankNo IS NULL) AND (LengthRange_cm = ? OR ? IS" +
" NULL AND LengthRange_cm IS NULL) AND (NoFish = ? OR ? IS NULL AND NoFish IS NUL" +
"L) AND (NoFishMeasured = ? OR ? IS NULL AND NoFishMeasured IS NULL) AND (OtherFi" +
"shFacility = ? OR ? IS NULL AND OtherFishFacility IS NULL) AND (OtherStock = ? O" +
"R ? IS NULL AND OtherStock IS NULL) AND (SatelliteRearedInd = ?) AND (Source = ?" +
" OR ? IS NULL AND Source IS NULL) AND (WeightRange_gm = ? OR ? IS NULL AND Weigh" +
"tRange_gm IS NULL) AND (oldAquaticActivityID = ? OR ? IS NULL AND oldAquaticActi" +
"vityID IS NULL) AND (siteuseid = ? OR ? IS NULL AND siteuseid IS NULL)";
this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgeUnitOfMeasure", System.Data.OleDb.OleDbType.VarWChar, 10, "AgeUnitOfMeasure"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AppliedMarkCd", System.Data.OleDb.OleDbType.Integer, 0, "AppliedMarkCd"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveLength_cm", System.Data.OleDb.OleDbType.Double, 0, "AveLength_cm"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveWeight_gm", System.Data.OleDb.OleDbType.Double, 0, "AveWeight_gm"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAge", System.Data.OleDb.OleDbType.VarWChar, 10, "FishAge"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 20, "FishAgeClass"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishFacilityID", System.Data.OleDb.OleDbType.Integer, 0, "FishFacilityID"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishLengthType", System.Data.OleDb.OleDbType.VarWChar, 10, "FishLengthType"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishMatingID", System.Data.OleDb.OleDbType.Integer, 0, "FishMatingID"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, "FishSpeciesCd"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishStockID", System.Data.OleDb.OleDbType.Integer, 0, "FishStockID"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishStrainCd", System.Data.OleDb.OleDbType.Integer, 0, "FishStrainCd"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishTankNo", System.Data.OleDb.OleDbType.VarWChar, 2, "FishTankNo"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("LengthRange_cm", System.Data.OleDb.OleDbType.VarWChar, 20, "LengthRange_cm"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("NoFish", System.Data.OleDb.OleDbType.Integer, 0, "NoFish"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("NoFishMeasured", System.Data.OleDb.OleDbType.Integer, 0, "NoFishMeasured"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("oldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "oldAquaticActivityID"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("SatelliteRearedInd", System.Data.OleDb.OleDbType.Boolean, 2, "SatelliteRearedInd"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("siteuseid", System.Data.OleDb.OleDbType.Integer, 0, "siteuseid"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Source", System.Data.OleDb.OleDbType.VarWChar, 50, "Source"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("WeightRange_gm", System.Data.OleDb.OleDbType.VarWChar, 20, "WeightRange_gm"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("OtherFishFacility", System.Data.OleDb.OleDbType.VarWChar, 50, "OtherFishFacility"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("OtherStock", System.Data.OleDb.OleDbType.VarWChar, 50, "OtherStock"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("BroodstockInd", System.Data.OleDb.OleDbType.Boolean, 2, "BroodstockInd"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishStockingID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishStockingID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgeUnitOfMeasure", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgeUnitOfMeasure", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgeUnitOfMeasure1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgeUnitOfMeasure", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AppliedMarkCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AppliedMarkCd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AppliedMarkCd1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AppliedMarkCd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AveLength_cm", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AveLength_cm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AveLength_cm1", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AveLength_cm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AveWeight_gm", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AveWeight_gm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AveWeight_gm1", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AveWeight_gm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_BroodstockInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "BroodstockInd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAge", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAge", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAge1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAge", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAgeClass", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishAgeClass1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishAgeClass", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishFacilityID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishFacilityID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishFacilityID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishFacilityID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishLengthType", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishLengthType", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishLengthType1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishLengthType", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMatingID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMatingID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMatingID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMatingID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.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.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishSpeciesCd1", System.Data.OleDb.OleDbType.VarWChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishSpeciesCd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishStockID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishStockID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishStockID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishStockID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishStrainCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishStrainCd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishStrainCd1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishStrainCd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishTankNo", System.Data.OleDb.OleDbType.VarWChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishTankNo", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishTankNo1", System.Data.OleDb.OleDbType.VarWChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishTankNo", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_LengthRange_cm", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "LengthRange_cm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_LengthRange_cm1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "LengthRange_cm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_NoFish", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "NoFish", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_NoFish1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "NoFish", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_NoFishMeasured", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "NoFishMeasured", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_NoFishMeasured1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "NoFishMeasured", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OtherFishFacility", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OtherFishFacility", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OtherFishFacility1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OtherFishFacility", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OtherStock", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OtherStock", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OtherStock1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OtherStock", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SatelliteRearedInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SatelliteRearedInd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Source", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Source", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Source1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Source", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WeightRange_gm", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WeightRange_gm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WeightRange_gm1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WeightRange_gm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticActivityID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticActivityID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticActivityID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_siteuseid", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "siteuseid", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_siteuseid1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "siteuseid", System.Data.DataRowVersion.Original, null));
//
// objdstblStockedFish
//
this.objdstblStockedFish.DataSetName = "dstblStockedFish";
this.objdstblStockedFish.Locale = new System.Globalization.CultureInfo("en-US");
//
// oleDbdacdFishSpecies
//
this.oleDbdacdFishSpecies.DeleteCommand = this.oleDbDeleteCommand6;
this.oleDbdacdFishSpecies.InsertCommand = this.oleDbInsertCommand9;
this.oleDbdacdFishSpecies.SelectCommand = this.oleDbSelectCommand9;
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.oleDbUpdateCommand6;
//
// oleDbDeleteCommand6
//
this.oleDbDeleteCommand6.CommandText = "DELETE FROM cdFishSpecies WHERE (FishSpeciesCd = ?) AND (ElectrofishInd = ?) AND " +
"(FishSpecies = ? OR ? IS NULL AND FishSpecies IS NULL) AND (StockedInd = ?)";
this.oleDbDeleteCommand6.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand6.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.oleDbDeleteCommand6.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.oleDbDeleteCommand6.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.oleDbDeleteCommand6.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.oleDbDeleteCommand6.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));
//
// oleDbInsertCommand9
//
this.oleDbInsertCommand9.CommandText = "INSERT INTO cdFishSpecies(FishSpecies, FishSpeciesCd, StockedInd, ElectrofishInd)" +
" VALUES (?, ?, ?, ?)";
this.oleDbInsertCommand9.Connection = this.oleDbConnection1;
this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpecies", System.Data.OleDb.OleDbType.VarWChar, 30, "FishSpecies"));
this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, "FishSpeciesCd"));
this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("StockedInd", System.Data.OleDb.OleDbType.Boolean, 2, "StockedInd"));
this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("ElectrofishInd", System.Data.OleDb.OleDbType.Boolean, 2, "ElectrofishInd"));
//
// oleDbSelectCommand9
//
this.oleDbSelectCommand9.CommandText = "SELECT FishSpecies, FishSpeciesCd, StockedInd, ElectrofishInd FROM cdFishSpecies";
this.oleDbSelectCommand9.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand6
//
this.oleDbUpdateCommand6.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.oleDbUpdateCommand6.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpecies", System.Data.OleDb.OleDbType.VarWChar, 30, "FishSpecies"));
this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, "FishSpeciesCd"));
this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("StockedInd", System.Data.OleDb.OleDbType.Boolean, 2, "StockedInd"));
this.oleDbUpdateCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("ElectrofishInd", System.Data.OleDb.OleDbType.Boolean, 2, "ElectrofishInd"));
this.oleDbUpdateCommand6.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.oleDbUpdateCommand6.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.oleDbUpdateCommand6.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.oleDbUpdateCommand6.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.oleDbUpdateCommand6.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));
//
// oleDbDeleteCommand2
//
this.oleDbDeleteCommand2.CommandText = "DELETE FROM cdFishSpecies WHERE (FishSpeciesCd = ?) AND (FishSpecies = ? OR ? IS " +
"NULL AND FishSpecies IS NULL)";
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_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));
//
// oleDbInsertCommand3
//
this.oleDbInsertCommand3.CommandText = "INSERT INTO cdFishSpecies(FishSpecies, FishSpeciesCd) 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"));
//
// oleDbSelectCommand3
//
this.oleDbSelectCommand3.CommandText = "SELECT FishSpecies, FishSpeciesCd FROM cdFishSpecies";
this.oleDbSelectCommand3.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand2
//
this.oleDbUpdateCommand2.CommandText = "UPDATE cdFishSpecies SET FishSpecies = ?, FishSpeciesCd = ? WHERE (FishSpeciesCd " +
"= ?) AND (FishSpecies = ? OR ? IS NULL AND FishSpecies IS NULL)";
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("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_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));
//
// objdscdFishSpecies
//
this.objdscdFishSpecies.DataSetName = "dscdFishSpecies";
this.objdscdFishSpecies.Locale = new System.Globalization.CultureInfo("en-US");
//
// oleDbdaDE_Hatcheries
//
this.oleDbdaDE_Hatcheries.InsertCommand = this.oleDbInsertCommand4;
this.oleDbdaDE_Hatcheries.SelectCommand = this.oleDbSelectCommand4;
this.oleDbdaDE_Hatcheries.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "DE-Hatcheries", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ActiveInd", "ActiveInd"),
new System.Data.Common.DataColumnMapping("FishFacilityID", "FishFacilityID"),
new System.Data.Common.DataColumnMapping("FishFacilityName", "FishFacilityName"),
new System.Data.Common.DataColumnMapping("FishFacilityType", "FishFacilityType")})});
//
// oleDbInsertCommand4
//
this.oleDbInsertCommand4.CommandText = "INSERT INTO [DE-Hatcheries] (ActiveInd, FishFacilityID, FishFacilityName, FishFac" +
"ilityType) VALUES (?, ?, ?, ?)";
this.oleDbInsertCommand4.Connection = this.oleDbConnection1;
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("ActiveInd", System.Data.OleDb.OleDbType.VarWChar, 15, "ActiveInd"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishFacilityID", System.Data.OleDb.OleDbType.Integer, 0, "FishFacilityID"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishFacilityName", System.Data.OleDb.OleDbType.VarWChar, 50, "FishFacilityName"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishFacilityType", System.Data.OleDb.OleDbType.VarWChar, 20, "FishFacilityType"));
//
// oleDbSelectCommand4
//
this.oleDbSelectCommand4.CommandText = "SELECT ActiveInd, FishFacilityID, FishFacilityName, FishFacilityType FROM [DE-Hat" +
"cheries]";
this.oleDbSelectCommand4.Connection = this.oleDbConnection1;
//
// objdsDE_Hatcheries
//
this.objdsDE_Hatcheries.DataSetName = "dsDE_Hatcheries";
this.objdsDE_Hatcheries.Locale = new System.Globalization.CultureInfo("en-US");
//
// oleDbdacdFishAgeClass
//
this.oleDbdacdFishAgeClass.DeleteCommand = this.oleDbDeleteCommand7;
this.oleDbdacdFishAgeClass.InsertCommand = this.oleDbInsertCommand10;
this.oleDbdacdFishAgeClass.SelectCommand = this.oleDbSelectCommand10;
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.oleDbUpdateCommand7;
//
// oleDbDeleteCommand7
//
this.oleDbDeleteCommand7.CommandText = "DELETE FROM cdFishAgeClass WHERE (FishAgeClass = ?) AND (ElectrofishInd = ?) AND " +
"(FishAgeClassCategory = ? OR ? IS NULL AND FishAgeClassCategory IS NULL) AND (Fi" +
"shCountInd = ?) AND (StockingInd = ?)";
this.oleDbDeleteCommand7.Connection = this.oleDbConnection2;
this.oleDbDeleteCommand7.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.oleDbDeleteCommand7.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.oleDbDeleteCommand7.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.oleDbDeleteCommand7.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.oleDbDeleteCommand7.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.oleDbDeleteCommand7.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));
//
// oleDbConnection2
//
//this.oleDbConnection2.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=""C:\Data_Warehouse\Tabular_Data\DE-HRAA.mdb"";Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";
this.oleDbConnection2.ConnectionString = Session["ConnectionString"].ToString();
//
// oleDbInsertCommand10
//
this.oleDbInsertCommand10.CommandText = "INSERT INTO cdFishAgeClass(FishAgeClass, FishAgeClassCategory, ElectrofishInd, Fi" +
"shCountInd, StockingInd) VALUES (?, ?, ?, ?, ?)";
this.oleDbInsertCommand10.Connection = this.oleDbConnection2;
this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 25, "FishAgeClass"));
this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClassCategory", System.Data.OleDb.OleDbType.VarWChar, 20, "FishAgeClassCategory"));
this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("ElectrofishInd", System.Data.OleDb.OleDbType.Boolean, 2, "ElectrofishInd"));
this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishCountInd", System.Data.OleDb.OleDbType.Boolean, 2, "FishCountInd"));
this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("StockingInd", System.Data.OleDb.OleDbType.Boolean, 2, "StockingInd"));
//
// oleDbSelectCommand10
//
this.oleDbSelectCommand10.CommandText = "SELECT FishAgeClass, FishAgeClassCategory, ElectrofishInd, FishCountInd, Stocking" +
"Ind FROM cdFishAgeClass";
this.oleDbSelectCommand10.Connection = this.oleDbConnection2;
//
// oleDbUpdateCommand7
//
this.oleDbUpdateCommand7.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.oleDbUpdateCommand7.Connection = this.oleDbConnection2;
this.oleDbUpdateCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 25, "FishAgeClass"));
this.oleDbUpdateCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClassCategory", System.Data.OleDb.OleDbType.VarWChar, 20, "FishAgeClassCategory"));
this.oleDbUpdateCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("ElectrofishInd", System.Data.OleDb.OleDbType.Boolean, 2, "ElectrofishInd"));
this.oleDbUpdateCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishCountInd", System.Data.OleDb.OleDbType.Boolean, 2, "FishCountInd"));
this.oleDbUpdateCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("StockingInd", System.Data.OleDb.OleDbType.Boolean, 2, "StockingInd"));
this.oleDbUpdateCommand7.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.oleDbUpdateCommand7.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.oleDbUpdateCommand7.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.oleDbUpdateCommand7.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.oleDbUpdateCommand7.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.oleDbUpdateCommand7.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));
//
// oleDbDeleteCommand3
//
this.oleDbDeleteCommand3.CommandText = "DELETE FROM cdFishAgeClass WHERE (FishAgeClass = ?) AND (FishAgeClassCategory = ?" +
" OR ? IS NULL AND FishAgeClassCategory IS NULL)";
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_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));
//
// oleDbInsertCommand5
//
this.oleDbInsertCommand5.CommandText = "INSERT INTO cdFishAgeClass(FishAgeClass, FishAgeClassCategory) VALUES (?, ?)";
this.oleDbInsertCommand5.Connection = this.oleDbConnection1;
this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 25, "FishAgeClass"));
this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClassCategory", System.Data.OleDb.OleDbType.VarWChar, 20, "FishAgeClassCategory"));
//
// oleDbSelectCommand5
//
this.oleDbSelectCommand5.CommandText = "SELECT FishAgeClass, FishAgeClassCategory FROM cdFishAgeClass";
this.oleDbSelectCommand5.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand3
//
this.oleDbUpdateCommand3.CommandText = "UPDATE cdFishAgeClass SET FishAgeClass = ?, FishAgeClassCategory = ? WHERE (FishA" +
"geClass = ?) AND (FishAgeClassCategory = ? OR ? IS NULL AND FishAgeClassCategory" +
" IS NULL)";
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("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_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));
//
// objdscdFishAgeClass
//
this.objdscdFishAgeClass.DataSetName = "dscdFishAgeClass";
this.objdscdFishAgeClass.Locale = new System.Globalization.CultureInfo("en-US");
//
// oleDbdacdFishMark
//
this.oleDbdacdFishMark.DeleteCommand = this.oleDbDeleteCommand8;
this.oleDbdacdFishMark.InsertCommand = this.oleDbInsertCommand11;
this.oleDbdacdFishMark.SelectCommand = this.oleDbSelectCommand11;
this.oleDbdacdFishMark.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "cdFishMark", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("FishMark", "FishMark"),
new System.Data.Common.DataColumnMapping("FishMarkCd", "FishMarkCd")})});
this.oleDbdacdFishMark.UpdateCommand = this.oleDbUpdateCommand8;
//
// oleDbDeleteCommand4
//
this.oleDbDeleteCommand4.CommandText = "DELETE FROM cdFishMark WHERE (FishMarkCd = ?) AND (FishMark = ? OR ? IS NULL AND " +
"FishMark IS NULL)";
this.oleDbDeleteCommand4.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMarkCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMarkCd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMark", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMark", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMark1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMark", System.Data.DataRowVersion.Original, null));
//
// oleDbInsertCommand6
//
this.oleDbInsertCommand6.CommandText = "INSERT INTO cdFishMark(FishMark, FishMarkCd) VALUES (?, ?)";
this.oleDbInsertCommand6.Connection = this.oleDbConnection1;
this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishMark", System.Data.OleDb.OleDbType.VarWChar, 50, "FishMark"));
this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishMarkCd", System.Data.OleDb.OleDbType.Integer, 0, "FishMarkCd"));
//
// oleDbSelectCommand6
//
this.oleDbSelectCommand6.CommandText = "SELECT FishMark, FishMarkCd FROM cdFishMark";
this.oleDbSelectCommand6.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand4
//
this.oleDbUpdateCommand4.CommandText = "UPDATE cdFishMark SET FishMark = ?, FishMarkCd = ? WHERE (FishMarkCd = ?) AND (Fi" +
"shMark = ? OR ? IS NULL AND FishMark IS NULL)";
this.oleDbUpdateCommand4.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishMark", System.Data.OleDb.OleDbType.VarWChar, 50, "FishMark"));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishMarkCd", System.Data.OleDb.OleDbType.Integer, 0, "FishMarkCd"));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMarkCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMarkCd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMark", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMark", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMark1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMark", System.Data.DataRowVersion.Original, null));
//
// objdscdFishMark
//
this.objdscdFishMark.DataSetName = "dscdFishMark";
this.objdscdFishMark.Locale = new System.Globalization.CultureInfo("en-US");
//
// dvcdFishSpecies
//
this.dvcdFishSpecies.RowFilter = "StockedInd";
this.dvcdFishSpecies.Sort = "FishSpecies";
this.dvcdFishSpecies.Table = this.objdscdFishSpecies.cdFishSpecies;
//
// dvDE_Hatcheries
//
this.dvDE_Hatcheries.Sort = "FishFacilityName";
this.dvDE_Hatcheries.Table = this.objdsDE_Hatcheries._DE_Hatcheries;
//
// dvcdFishMark
//
this.dvcdFishMark.Sort = "FishMark";
this.dvcdFishMark.Table = this.objdscdFishMark.cdFishMark;
//
// dvcdFishAgeClass
//
this.dvcdFishAgeClass.RowFilter = "StockingInd";
this.dvcdFishAgeClass.Sort = "FishAgeClass";
this.dvcdFishAgeClass.Table = this.objdscdFishAgeClass.cdFishAgeClass;
//
// oleDbdaDE_FishStock
//
this.oleDbdaDE_FishStock.InsertCommand = this.oleDbInsertCommand7;
this.oleDbdaDE_FishStock.SelectCommand = this.oleDbSelectCommand7;
this.oleDbdaDE_FishStock.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "DE-FishStock", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("FishSpeciesCd", "FishSpeciesCd"),
new System.Data.Common.DataColumnMapping("FishStockID", "FishStockID"),
new System.Data.Common.DataColumnMapping("Name", "Name")})});
//
// oleDbInsertCommand7
//
this.oleDbInsertCommand7.CommandText = "INSERT INTO [DE-FishStock] (FishSpeciesCd, FishStockID, Name) VALUES (?, ?, ?)";
this.oleDbInsertCommand7.Connection = this.oleDbConnection1;
this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, "FishSpeciesCd"));
this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishStockID", System.Data.OleDb.OleDbType.Integer, 0, "FishStockID"));
this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.VarWChar, 255, "Name"));
//
// oleDbSelectCommand7
//
this.oleDbSelectCommand7.CommandText = "SELECT FishSpeciesCd, FishStockID, Name FROM [DE-FishStock]";
this.oleDbSelectCommand7.Connection = this.oleDbConnection1;
//
// objdsDE_FishStock
//
this.objdsDE_FishStock.DataSetName = "dsDE_FishStock";
this.objdsDE_FishStock.Locale = new System.Globalization.CultureInfo("en-US");
//
// dvDE_FishStock
//
this.dvDE_FishStock.Sort = "Name";
this.dvDE_FishStock.Table = this.objdsDE_FishStock._DE_FishStock;
//
// oleDbdatblAquaticActivity
//
this.oleDbdatblAquaticActivity.DeleteCommand = this.oleDbDeleteCommand5;
this.oleDbdatblAquaticActivity.InsertCommand = this.oleDbInsertCommand8;
this.oleDbdatblAquaticActivity.SelectCommand = this.oleDbSelectCommand8;
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")})});
this.oleDbdatblAquaticActivity.UpdateCommand = this.oleDbUpdateCommand5;
//
// oleDbDeleteCommand5
//
this.oleDbDeleteCommand5.CommandText = "DELETE FROM tblAquaticActivity WHERE (AquaticActivityID = ?) AND (Agency2Cd = ? O" +
"R ? IS NULL AND Agency2Cd IS NULL) AND (AgencyCd = ? OR ? IS NULL AND AgencyCd I" +
"S NULL) AND (AirTemp_C = ? OR ? IS NULL AND AirTemp_C IS NULL) AND (AquaticActiv" +
"ityCd = ? OR ? IS NULL AND AquaticActivityCd IS NULL) AND (AquaticActivityEndDat" +
"e = ? OR ? IS NULL AND AquaticActivityEndDate IS NULL) AND (AquaticActivityEndTi" +
"me = ? OR ? IS NULL AND AquaticActivityEndTime IS NULL) AND (AquaticActivityLead" +
"er = ? OR ? IS NULL AND AquaticActivityLeader IS NULL) AND (AquaticActivityStart" +
"Date = ? OR ? IS NULL AND AquaticActivityStartDate IS NULL) AND (AquaticActivity" +
"StartTime = ? OR ? IS NULL AND AquaticActivityStartTime IS NULL) AND (AquaticMet" +
"hodCd = ? OR ? IS NULL AND AquaticMethodCd IS NULL) AND (AquaticProgramID = ? OR" +
" ? IS NULL AND AquaticProgramID IS NULL) AND (AquaticSiteID = ? OR ? IS NULL AND" +
" AquaticSiteID IS NULL) AND (Comments = ? OR ? IS NULL AND Comments IS NULL) AND" +
" (Crew = ? OR ? IS NULL AND Crew IS NULL) AND (DateEntered = ? OR ? IS NULL AND " +
"DateEntered IS NULL) AND (IncorporatedInd = ?) AND (OldAquaticActivityID = ? OR " +
"? IS NULL AND OldAquaticActivityID IS NULL) AND (PrimaryActivityInd = ?) AND (Pr" +
"oject = ? OR ? IS NULL AND Project IS NULL) AND (Siltation = ? OR ? IS NULL AND " +
"Siltation IS NULL) AND (WaterLevel = ? OR ? IS NULL AND WaterLevel IS NULL) AND " +
"(WaterLevel_AM_cm = ? OR ? IS NULL AND WaterLevel_AM_cm IS NULL) AND (WaterLevel" +
"_PM_cm = ? OR ? IS NULL AND WaterLevel_PM_cm IS NULL) AND (WaterLevel_cm = ? OR " +
"? IS NULL AND WaterLevel_cm IS NULL) AND (WaterTemp_C = ? OR ? IS NULL AND Water" +
"Temp_C IS NULL) AND (WeatherConditions = ? OR ? IS NULL AND WeatherConditions IS" +
" NULL) AND (Year = ? OR ? IS NULL AND Year IS NULL) AND (oldAquaticSiteID = ? OR" +
" ? IS NULL AND oldAquaticSiteID IS NULL)";
this.oleDbDeleteCommand5.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand5.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.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency2Cd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency2Cd1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency2Cd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AirTemp_C", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AirTemp_C1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AirTemp_C", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.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.oleDbDeleteCommand5.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.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndDate", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndDate", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndDate1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndDate", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndTime", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndTime", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndTime1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndTime", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityLeader", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityLeader", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityLeader1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityLeader", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartDate", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartDate", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartDate1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartDate", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartTime", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartTime", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartTime1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartTime", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.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.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticMethodCd1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticMethodCd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticProgramID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticProgramID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticProgramID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticProgramID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Comments", System.Data.OleDb.OleDbType.VarWChar, 250, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Comments", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Comments1", System.Data.OleDb.OleDbType.VarWChar, 250, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Comments", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Crew", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Crew", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Crew1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Crew", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateEntered", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DateEntered1", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateEntered", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IncorporatedInd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OldAquaticActivityID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OldAquaticActivityID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OldAquaticActivityID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_PrimaryActivityInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PrimaryActivityInd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Project", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Project", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Project1", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Project", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Siltation", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Siltation", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Siltation1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Siltation", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_AM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_AM_cm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_AM_cm1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_AM_cm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_PM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_PM_cm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_PM_cm1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_PM_cm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_cm", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_cm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_cm1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_cm", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterTemp_C", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterTemp_C1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterTemp_C", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WeatherConditions", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WeatherConditions", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WeatherConditions1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WeatherConditions", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Year", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Year", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Year1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Year", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticSiteID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticSiteID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticSiteID", System.Data.DataRowVersion.Original, null));
//
// oleDbInsertCommand8
//
this.oleDbInsertCommand8.CommandText = @"INSERT INTO tblAquaticActivity (AgencyCd, AirTemp_C, AquaticActivityCd, AquaticActivityStartDate, AquaticActivityStartTime, AquaticSiteID, Comments, DateEntered, IncorporatedInd, WaterLevel_cm, WaterTemp_C, AquaticActivityID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
this.oleDbInsertCommand8.Connection = this.oleDbConnection1;
this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "AirTemp_C"));
this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd"));
this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityStartDate", System.Data.OleDb.OleDbType.VarWChar, 10, "AquaticActivityStartDate"));
this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityStartTime", System.Data.OleDb.OleDbType.VarWChar, 6, "AquaticActivityStartTime"));
this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Comments", System.Data.OleDb.OleDbType.VarWChar, 250, "Comments"));
this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, "DateEntered"));
this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "IncorporatedInd"));
this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_cm"));
this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "WaterTemp_C"));
this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
//
// oleDbSelectCommand8
//
this.oleDbSelectCommand8.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 FROM tblAquaticActivity";
this.oleDbSelectCommand8.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand5
//
this.oleDbUpdateCommand5.CommandText = "UPDATE tblAquaticActivity SET Agency2Cd = ?, AgencyCd = ?, AirTemp_C = ?, Aquatic" +
"ActivityCd = ?, AquaticActivityEndDate = ?, AquaticActivityEndTime = ?, AquaticA" +
"ctivityID = ?, AquaticActivityLeader = ?, AquaticActivityStartDate = ?, AquaticA" +
"ctivityStartTime = ?, AquaticMethodCd = ?, AquaticProgramID = ?, AquaticSiteID =" +
" ?, Comments = ?, Crew = ?, DateEntered = ?, IncorporatedInd = ?, OldAquaticActi" +
"vityID = ?, oldAquaticSiteID = ?, PrimaryActivityInd = ?, Project = ?, Siltation" +
" = ?, WaterLevel = ?, WaterLevel_AM_cm = ?, WaterLevel_cm = ?, WaterLevel_PM_cm " +
"= ?, WaterTemp_C = ?, WeatherConditions = ?, Year = ? WHERE (AquaticActivityID =" +
" ?) AND (Agency2Cd = ? OR ? IS NULL AND Agency2Cd IS NULL) AND (AgencyCd = ? OR " +
"? IS NULL AND AgencyCd IS NULL) AND (AirTemp_C = ? OR ? IS NULL AND AirTemp_C IS" +
" NULL) AND (AquaticActivityCd = ? OR ? IS NULL AND AquaticActivityCd IS NULL) AN" +
"D (AquaticActivityEndDate = ? OR ? IS NULL AND AquaticActivityEndDate IS NULL) A" +
"ND (AquaticActivityEndTime = ? OR ? IS NULL AND AquaticActivityEndTime IS NULL) " +
"AND (AquaticActivityLeader = ? OR ? IS NULL AND AquaticActivityLeader IS NULL) A" +
"ND (AquaticActivityStartDate = ? OR ? IS NULL AND AquaticActivityStartDate IS NU" +
"LL) AND (AquaticActivityStartTime = ? OR ? IS NULL AND AquaticActivityStartTime " +
"IS NULL) AND (AquaticMethodCd = ? OR ? IS NULL AND AquaticMethodCd IS NULL) AND " +
"(AquaticProgramID = ? OR ? IS NULL AND AquaticProgramID IS NULL) AND (AquaticSit" +
"eID = ? OR ? IS NULL AND AquaticSiteID IS NULL) AND (Comments = ? OR ? IS NULL A" +
"ND Comments IS NULL) AND (Crew = ? OR ? IS NULL AND Crew IS NULL) AND (DateEnter" +
"ed = ? OR ? IS NULL AND DateEntered IS NULL) AND (IncorporatedInd = ?) AND (OldA" +
"quaticActivityID = ? OR ? IS NULL AND OldAquaticActivityID IS NULL) AND (Primary" +
"ActivityInd = ?) AND (Project = ? OR ? IS NULL AND Project IS NULL) AND (Siltati" +
"on = ? OR ? IS NULL AND Siltation IS NULL) AND (WaterLevel = ? OR ? IS NULL AND " +
"WaterLevel IS NULL) AND (WaterLevel_AM_cm = ? OR ? IS NULL AND WaterLevel_AM_cm " +
"IS NULL) AND (WaterLevel_PM_cm = ? OR ? IS NULL AND WaterLevel_PM_cm IS NULL) AN" +
"D (WaterLevel_cm = ? OR ? IS NULL AND WaterLevel_cm IS NULL) AND (WaterTemp_C = " +
"? OR ? IS NULL AND WaterTemp_C IS NULL) AND (WeatherConditions = ? OR ? IS NULL " +
"AND WeatherConditions IS NULL) AND (Year = ? OR ? IS NULL AND Year IS NULL) AND " +
"(oldAquaticSiteID = ? OR ? IS NULL AND oldAquaticSiteID IS NULL)";
this.oleDbUpdateCommand5.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, "Agency2Cd"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "AirTemp_C"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityEndDate", System.Data.OleDb.OleDbType.VarWChar, 10, "AquaticActivityEndDate"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityEndTime", System.Data.OleDb.OleDbType.VarWChar, 6, "AquaticActivityEndTime"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityLeader", System.Data.OleDb.OleDbType.VarWChar, 50, "AquaticActivityLeader"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityStartDate", System.Data.OleDb.OleDbType.VarWChar, 10, "AquaticActivityStartDate"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityStartTime", System.Data.OleDb.OleDbType.VarWChar, 6, "AquaticActivityStartTime"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethodCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticMethodCd"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticProgramID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticProgramID"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Comments", System.Data.OleDb.OleDbType.VarWChar, 250, "Comments"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Crew", System.Data.OleDb.OleDbType.VarWChar, 50, "Crew"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, "DateEntered"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "IncorporatedInd"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("OldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "OldAquaticActivityID"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("oldAquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "oldAquaticSiteID"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("PrimaryActivityInd", System.Data.OleDb.OleDbType.Boolean, 2, "PrimaryActivityInd"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Project", System.Data.OleDb.OleDbType.VarWChar, 100, "Project"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Siltation", System.Data.OleDb.OleDbType.VarWChar, 50, "Siltation"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel", System.Data.OleDb.OleDbType.VarWChar, 6, "WaterLevel"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_AM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_AM_cm"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_cm"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_PM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_PM_cm"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "WaterTemp_C"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WeatherConditions", System.Data.OleDb.OleDbType.VarWChar, 50, "WeatherConditions"));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Year", System.Data.OleDb.OleDbType.VarWChar, 4, "Year"));
this.oleDbUpdateCommand5.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.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency2Cd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency2Cd1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency2Cd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AirTemp_C", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AirTemp_C1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AirTemp_C", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.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.oleDbUpdateCommand5.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.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndDate", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndDate", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndDate1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndDate", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndTime", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndTime", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndTime1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndTime", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityLeader", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityLeader", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityLeader1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityLeader", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartDate", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartDate", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartDate1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartDate", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartTime", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartTime", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartTime1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartTime", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.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.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticMethodCd1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticMethodCd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticProgramID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticProgramID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticProgramID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticProgramID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Comments", System.Data.OleDb.OleDbType.VarWChar, 250, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Comments", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Comments1", System.Data.OleDb.OleDbType.VarWChar, 250, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Comments", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Crew", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Crew", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Crew1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Crew", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateEntered", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DateEntered1", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateEntered", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IncorporatedInd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OldAquaticActivityID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OldAquaticActivityID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OldAquaticActivityID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_PrimaryActivityInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PrimaryActivityInd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Project", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Project", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Project1", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Project", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Siltation", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Siltation", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Siltation1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Siltation", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_AM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_AM_cm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_AM_cm1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_AM_cm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_PM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_PM_cm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_PM_cm1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_PM_cm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_cm", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_cm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_cm1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_cm", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterTemp_C", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterTemp_C1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterTemp_C", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WeatherConditions", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WeatherConditions", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WeatherConditions1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WeatherConditions", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Year", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Year", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Year1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Year", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticSiteID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticSiteID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticSiteID", System.Data.DataRowVersion.Original, null));
//
// objdstblAquaticActivity
//
this.objdstblAquaticActivity.DataSetName = "dstblAquaticActivity";
this.objdstblAquaticActivity.Locale = new System.Globalization.CultureInfo("en-US");
//
// oleDbSelectCommand11
//
this.oleDbSelectCommand11.CommandText = "SELECT FishMark, FishMarkCd FROM cdFishMark";
this.oleDbSelectCommand11.Connection = this.oleDbConnection1;
//
// oleDbInsertCommand11
//
this.oleDbInsertCommand11.CommandText = "INSERT INTO cdFishMark(FishMark, FishMarkCd) VALUES (?, ?)";
this.oleDbInsertCommand11.Connection = this.oleDbConnection1;
this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishMark", System.Data.OleDb.OleDbType.VarWChar, 50, "FishMark"));
this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishMarkCd", System.Data.OleDb.OleDbType.Integer, 0, "FishMarkCd"));
//
// oleDbUpdateCommand8
//
this.oleDbUpdateCommand8.CommandText = "UPDATE cdFishMark SET FishMark = ?, FishMarkCd = ? WHERE (FishMarkCd = ?) AND (Fi" +
"shMark = ? OR ? IS NULL AND FishMark IS NULL)";
this.oleDbUpdateCommand8.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishMark", System.Data.OleDb.OleDbType.VarWChar, 50, "FishMark"));
this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishMarkCd", System.Data.OleDb.OleDbType.Integer, 0, "FishMarkCd"));
this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMarkCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMarkCd", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMark", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMark", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMark1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMark", System.Data.DataRowVersion.Original, null));
//
// oleDbDeleteCommand8
//
this.oleDbDeleteCommand8.CommandText = "DELETE FROM cdFishMark WHERE (FishMarkCd = ?) AND (FishMark = ? OR ? IS NULL AND " +
"FishMark IS NULL)";
this.oleDbDeleteCommand8.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMarkCd", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMarkCd", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMark", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMark", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishMark1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishMark", System.Data.DataRowVersion.Original, null));
((System.ComponentModel.ISupportInitialize)(this.objdsDE_SiteInfo)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.objdstblStockedFish)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.objdscdFishSpecies)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.objdsDE_Hatcheries)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.objdscdFishAgeClass)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.objdscdFishMark)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvcdFishSpecies)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvDE_Hatcheries)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvcdFishMark)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvcdFishAgeClass)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.objdsDE_FishStock)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvDE_FishStock)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.objdstblAquaticActivity)).EndInit();
}