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