public virtual OfficesMaster.OfficesCommunication_LKPDataTable GetOfficeCommunicationProcessDetails() { this.Adapter.SelectCommand = this.CommandCollection[6]; OfficesMaster.OfficesCommunication_LKPDataTable dataTable = new OfficesMaster.OfficesCommunication_LKPDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual OfficesMaster.OfficesCommunication_LKPDataTable GetCommunicationOfficeByKey(global::System.Nullable<global::System.Guid> OfficeId, string CommunicationKey) { this.Adapter.SelectCommand = this.CommandCollection[4]; 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 ((CommunicationKey == null)) { this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = ((string)(CommunicationKey)); } OfficesMaster.OfficesCommunication_LKPDataTable dataTable = new OfficesMaster.OfficesCommunication_LKPDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual OfficesMaster.OfficesCommunication_LKPDataTable GetOfficeCommunicationByOfficeId(global::System.Nullable<global::System.Guid> OfficeId) { this.Adapter.SelectCommand = this.CommandCollection[5]; 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; } OfficesMaster.OfficesCommunication_LKPDataTable dataTable = new OfficesMaster.OfficesCommunication_LKPDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual OfficesMaster.OfficesCommunication_LKPDataTable AddNewOfficeCommunication(global::System.Nullable<global::System.Guid> OfficeId, string CommunicationKey, global::System.Nullable<global::System.Guid> CommunicatingOffice, string Description, global::System.Nullable<bool> IsActive, string CreatedBy, global::System.Nullable<global::System.DateTime> CreatedAt) { this.Adapter.SelectCommand = this.CommandCollection[1]; 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 ((CommunicationKey == null)) { this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = ((string)(CommunicationKey)); } if ((CommunicatingOffice.HasValue == true)) { this.Adapter.SelectCommand.Parameters[3].Value = ((System.Guid)(CommunicatingOffice.Value)); } else { this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value; } if ((Description == null)) { this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[4].Value = ((string)(Description)); } if ((IsActive.HasValue == true)) { this.Adapter.SelectCommand.Parameters[5].Value = ((bool)(IsActive.Value)); } else { this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value; } if ((CreatedBy == null)) { this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[6].Value = ((string)(CreatedBy)); } if ((CreatedAt.HasValue == true)) { this.Adapter.SelectCommand.Parameters[7].Value = ((System.DateTime)(CreatedAt.Value)); } else { this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value; } OfficesMaster.OfficesCommunication_LKPDataTable dataTable = new OfficesMaster.OfficesCommunication_LKPDataTable(); this.Adapter.Fill(dataTable); return dataTable; }