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; }