public virtual int FillBySiteIdVariableIDBetweenDates(ValuesDataSet.DataValuesDataTable dataTable, int SiteID, int VariableID, System.DateTime BeingDate, System.DateTime EndDate) {
this.Adapter.SelectCommand = this.CommandCollection[3];
this.Adapter.SelectCommand.Parameters[0].Value = ((int)(SiteID));
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(VariableID));
this.Adapter.SelectCommand.Parameters[2].Value = ((System.DateTime)(BeingDate));
this.Adapter.SelectCommand.Parameters[3].Value = ((System.DateTime)(EndDate));
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Fill(ValuesDataSet.QualityControlLevelsDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int FillBySiteIDVariableID(ValuesDataSet.DataValuesDataTable dataTable, int SiteID, int VariableID) {
this.Adapter.SelectCommand = this.CommandCollection[2];
this.Adapter.SelectCommand.Parameters[0].Value = ((int)(SiteID));
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(VariableID));
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}