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;
}
