public virtual FileManagement.Applicant_DetailsDataTable GetApplicantDetails(string FilePrefix, global::System.Nullable<int> FileNo, string FileYear, string ApplicantName, global::System.Nullable<global::System.Guid> OfficeId) {
this.Adapter.SelectCommand = this.CommandCollection[1];
if ((FilePrefix == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(FilePrefix));
}
if ((FileNo.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[2].Value = ((int)(FileNo.Value));
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
if ((FileYear == null)) {
this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[3].Value = ((string)(FileYear));
}
if ((ApplicantName == null)) {
this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[4].Value = ((string)(ApplicantName));
}
if ((OfficeId.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[5].Value = ((System.Guid)(OfficeId.Value));
}
else {
this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
}
FileManagement.Applicant_DetailsDataTable dataTable = new FileManagement.Applicant_DetailsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual FileManagement.Applicant_DetailsDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
FileManagement.Applicant_DetailsDataTable dataTable = new FileManagement.Applicant_DetailsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}