public virtual FileManagement.FileManagementMasterDataTable GetApplicantDetails(string FilePrefix, global::System.Nullable<int> FileNo, string FileYear, string ApplicantName, global::System.Nullable<global::System.Guid> OfficeId) {
this.Adapter.SelectCommand = this.CommandCollection[3];
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.FileManagementMasterDataTable dataTable = new FileManagement.FileManagementMasterDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual FileManagement.FileManagementMasterDataTable GetFileDetails(global::System.Nullable<global::System.Guid> FileId) {
this.Adapter.SelectCommand = this.CommandCollection[4];
if ((FileId.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(FileId.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
FileManagement.FileManagementMasterDataTable dataTable = new FileManagement.FileManagementMasterDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual FileManagement.FileManagementMasterDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
FileManagement.FileManagementMasterDataTable dataTable = new FileManagement.FileManagementMasterDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
