public virtual Inspection.InspectionYearlySheduleDataTable GetYearlyInspection() {
this.Adapter.SelectCommand = this.CommandCollection[5];
Inspection.InspectionYearlySheduleDataTable dataTable = new Inspection.InspectionYearlySheduleDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual Inspection.InspectionYearlySheduleDataTable GetYearlyInspectionScheduleById(global::System.Nullable<global::System.Guid> ScheduleId) {
this.Adapter.SelectCommand = this.CommandCollection[7];
if ((ScheduleId.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(ScheduleId.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
Inspection.InspectionYearlySheduleDataTable dataTable = new Inspection.InspectionYearlySheduleDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual Inspection.InspectionYearlySheduleDataTable GetInspectionByDate(global::System.Nullable<global::System.DateTime> Year) {
this.Adapter.SelectCommand = this.CommandCollection[2];
if ((Year.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(Year.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
Inspection.InspectionYearlySheduleDataTable dataTable = new Inspection.InspectionYearlySheduleDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
