public virtual InspectionDetails.InspectionDetailsDataTable GetInspectionDetailsById(global::System.Nullable<global::System.Guid> InspectionId) { this.Adapter.SelectCommand = this.CommandCollection[4]; if ((InspectionId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(InspectionId.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } InspectionDetails.InspectionDetailsDataTable dataTable = new InspectionDetails.InspectionDetailsDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual InspectionDetails.InspectionDetailsDataTable SearchInspectionDetailsByName(string InspectorOfficeName) { this.Adapter.SelectCommand = this.CommandCollection[5]; if ((InspectorOfficeName == null)) { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ((string)(InspectorOfficeName)); } InspectionDetails.InspectionDetailsDataTable dataTable = new InspectionDetails.InspectionDetailsDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual InspectionDetails.InspectionDetailsDataTable GetAllInspectionDetails() { this.Adapter.SelectCommand = this.CommandCollection[2]; InspectionDetails.InspectionDetailsDataTable dataTable = new InspectionDetails.InspectionDetailsDataTable(); this.Adapter.Fill(dataTable); return dataTable; }