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