public virtual WorkflowSupprot.UsersInOfficeRolesDataTable GetUserDetailsInOfficeRolesByUserName(string UserName) {
this.Adapter.SelectCommand = this.CommandCollection[5];
if ((UserName == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(UserName));
}
WorkflowSupprot.UsersInOfficeRolesDataTable dataTable = new WorkflowSupprot.UsersInOfficeRolesDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual WorkflowSupprot.UsersInOfficeRolesDataTable GetUsersInOfficeRoles(global::System.Nullable<global::System.Guid> OfficeId, global::System.Nullable<global::System.Guid> DesignationId) {
this.Adapter.SelectCommand = this.CommandCollection[6];
if ((OfficeId.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(OfficeId.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((DesignationId.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[2].Value = ((System.Guid)(DesignationId.Value));
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
WorkflowSupprot.UsersInOfficeRolesDataTable dataTable = new WorkflowSupprot.UsersInOfficeRolesDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual WorkflowSupprot.UsersInOfficeRolesDataTable GetUserDetailsInOfficeRoles() {
this.Adapter.SelectCommand = this.CommandCollection[4];
WorkflowSupprot.UsersInOfficeRolesDataTable dataTable = new WorkflowSupprot.UsersInOfficeRolesDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}