예제 #1
0
 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;
 }
예제 #2
0
 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;
 }
예제 #3
0
 public virtual WorkflowSupprot.UsersInOfficeRolesDataTable GetUserDetailsInOfficeRoles() {
     this.Adapter.SelectCommand = this.CommandCollection[4];
     WorkflowSupprot.UsersInOfficeRolesDataTable dataTable = new WorkflowSupprot.UsersInOfficeRolesDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }