internal static rptVisit ViewAllVisitScheduleRegNo(string reg)
{
try
{
rptvisit1 = new rptVisit();
daVist = new VisitScheduleTableAdapter();
dtVisit = new DsLiveReport.VisitScheduleDataTable();
daVist.FillByRegNo(dtVisit, reg);
rptvisit1.SetDataSource((DataTable)dtVisit);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Error occured when retriving data");
}
return(rptvisit1);
}
internal static rptVisit ViewAllVisitSchedule(string strsearch)
{
try
{
rptvisit1 = new rptVisit();
daVist = new VisitScheduleTableAdapter();
dtVisit = new DsLiveReport.VisitScheduleDataTable();
daVist.Fill(dtVisit);
//rptvisit.DataDefinition.FormulaFields[2].Text = "\"" + paramValue + "\"";
//strsearch = "{VisitSchedule.RegNo} <> ''AND Datediff('d',{VisitSchedule.Appointment},Cdate({@PeriodEnding}))>2 AND IsNull({VisitSchedule.ReturnDate})";
rptvisit1.SetDataSource((DataTable)dtVisit);
rptvisit1.RecordSelectionFormula = strsearch;
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Error occured when retriving data");
}
return(rptvisit1);
}