public virtual Complain.ComplainDetailsDataTable GetComplainReport(global::System.Nullable<global::System.DateTime> FromDate, global::System.Nullable<global::System.DateTime> ToDate, global::System.Nullable<global::System.Guid> OfficeId) { this.Adapter.SelectCommand = this.CommandCollection[5]; if ((FromDate.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(FromDate.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } if ((ToDate.HasValue == true)) { this.Adapter.SelectCommand.Parameters[2].Value = ((System.DateTime)(ToDate.Value)); } else { this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value; } if ((OfficeId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[3].Value = ((System.Guid)(OfficeId.Value)); } else { this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value; } Complain.ComplainDetailsDataTable dataTable = new Complain.ComplainDetailsDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Complain.ComplainDetailsDataTable GetComplainDetail(string ComplaintNo) { this.Adapter.SelectCommand = this.CommandCollection[3]; if ((ComplaintNo == null)) { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ((string)(ComplaintNo)); } Complain.ComplainDetailsDataTable dataTable = new Complain.ComplainDetailsDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Complain.ComplainDetailsDataTable GetComplainDetailByComplainId(global::System.Nullable<global::System.Guid> ComplainId) { this.Adapter.SelectCommand = this.CommandCollection[4]; if ((ComplainId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(ComplainId.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } Complain.ComplainDetailsDataTable dataTable = new Complain.ComplainDetailsDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Complain.ComplainDetailsDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; Complain.ComplainDetailsDataTable dataTable = new Complain.ComplainDetailsDataTable(); this.Adapter.Fill(dataTable); return dataTable; }