public virtual Appeal.AppealHearingDataTable GetHighCourtJudgementDetails(global::System.Nullable<global::System.Guid> AppealApplicationId) { this.Adapter.SelectCommand = this.CommandCollection[8]; if ((AppealApplicationId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(AppealApplicationId.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } Appeal.AppealHearingDataTable dataTable = new Appeal.AppealHearingDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Appeal.AppealHearingDataTable AddAppealHearing(global::System.Nullable<global::System.Guid> HearingID, global::System.Nullable<global::System.Guid> AppealApplicationId, global::System.Nullable<global::System.DateTime> HearingDate, string Remarks, global::System.Nullable<bool> IsJudgement, string CreatedBy, global::System.Nullable<global::System.DateTime> CreatedAt, global::System.Nullable<global::System.Guid> AppealDecisionType) { this.Adapter.SelectCommand = this.CommandCollection[1]; if ((HearingID.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(HearingID.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } if ((AppealApplicationId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[2].Value = ((System.Guid)(AppealApplicationId.Value)); } else { this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value; } if ((HearingDate.HasValue == true)) { this.Adapter.SelectCommand.Parameters[3].Value = ((System.DateTime)(HearingDate.Value)); } else { this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value; } if ((Remarks == null)) { this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[4].Value = ((string)(Remarks)); } if ((IsJudgement.HasValue == true)) { this.Adapter.SelectCommand.Parameters[5].Value = ((bool)(IsJudgement.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; } if ((AppealDecisionType.HasValue == true)) { this.Adapter.SelectCommand.Parameters[8].Value = ((System.Guid)(AppealDecisionType.Value)); } else { this.Adapter.SelectCommand.Parameters[8].Value = global::System.DBNull.Value; } Appeal.AppealHearingDataTable dataTable = new Appeal.AppealHearingDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Appeal.AppealHearingDataTable AddHighCourtJudgementDetails(global::System.Nullable<global::System.Guid> HearingID, global::System.Nullable<global::System.Guid> AppealApplicationId, global::System.Nullable<global::System.DateTime> HearingDate, string Remarks, global::System.Nullable<bool> IsJudgement) { this.Adapter.SelectCommand = this.CommandCollection[3]; if ((HearingID.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(HearingID.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } if ((AppealApplicationId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[2].Value = ((System.Guid)(AppealApplicationId.Value)); } else { this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value; } if ((HearingDate.HasValue == true)) { this.Adapter.SelectCommand.Parameters[3].Value = ((System.DateTime)(HearingDate.Value)); } else { this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value; } if ((Remarks == null)) { this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[4].Value = ((string)(Remarks)); } if ((IsJudgement.HasValue == true)) { this.Adapter.SelectCommand.Parameters[5].Value = ((bool)(IsJudgement.Value)); } else { this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value; } Appeal.AppealHearingDataTable dataTable = new Appeal.AppealHearingDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Appeal.AppealHearingDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; Appeal.AppealHearingDataTable dataTable = new Appeal.AppealHearingDataTable(); this.Adapter.Fill(dataTable); return dataTable; }