public virtual VendorOffence.VendorOffenceDataTable GetVendorInspectionDetailsByFileName(string FileDepartment, global::System.Nullable<decimal> FileNo, string Year) { this.Adapter.SelectCommand = this.CommandCollection[3]; if ((FileDepartment == null)) { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ((string)(FileDepartment)); } if ((FileNo.HasValue == true)) { this.Adapter.SelectCommand.Parameters[2].Value = ((decimal)(FileNo.Value)); } else { this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value; } if ((Year == null)) { this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = ((string)(Year)); } VendorOffence.VendorOffenceDataTable dataTable = new VendorOffence.VendorOffenceDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual VendorOffence.VendorOffenceDataTable GetVendorOffenceDetailsByLicenseDetails(global::System.Nullable<global::System.Guid> VendorLicenseId) { this.Adapter.SelectCommand = this.CommandCollection[5]; if ((VendorLicenseId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(VendorLicenseId.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } VendorOffence.VendorOffenceDataTable dataTable = new VendorOffence.VendorOffenceDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual VendorOffence.VendorOffenceDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; VendorOffence.VendorOffenceDataTable dataTable = new VendorOffence.VendorOffenceDataTable(); this.Adapter.Fill(dataTable); return dataTable; }