Example #1
0
 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);
 }
Example #2
0
 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);
 }