public virtual VendorOffence.VendorInvestigationDataTable GetVendorInspectionDetailsByOffenceID(global::System.Nullable<global::System.Guid> VendorOffenceId) {
     this.Adapter.SelectCommand = this.CommandCollection[3];
     if ((VendorOffenceId.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(VendorOffenceId.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     VendorOffence.VendorInvestigationDataTable dataTable = new VendorOffence.VendorInvestigationDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
 public virtual VendorOffence.VendorInvestigationDataTable GetInspectionData() {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     VendorOffence.VendorInvestigationDataTable dataTable = new VendorOffence.VendorInvestigationDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }