//*************************************************************
// TFD Training Paramedic Recertification
// Paramedics Filtered by DateRane, Battalion/Shift
//*************************************************************
private void FormatReport()
{
PTSProject.clsTraining TrainCL = Container.Resolve< clsTraining>();
bool bDisplay = false;
if ( ViewModel.FirstTime)
{
return;
}
ViewModel.sprReport2.Row = 6;
ViewModel.sprReport2.Row2 = ViewModel.sprReport2.MaxRows;
ViewModel.sprReport2.Col = 1;
ViewModel.sprReport2.Col2 = ViewModel.sprReport2.MaxCols;
ViewModel.sprReport2.BlockMode = true;
ViewModel.sprReport2.Text = "";
ViewModel.sprReport2.BlockMode = false;
if (TrainCL.GetTrainingPMRecertificationReport(ViewModel.dtStart.Text, ViewModel.dtEnd.Text, ViewModel.CurrBatt, ViewModel.CurrShift, ViewModel.CurrGroup) != 0)
{
//continue
}
else
{
ViewManager.ShowMessage("There are no Employee/Training Records to report!", "Training Paramedic Recertification", UpgradeHelpers.Helpers.BoxButtons.OK);
return;
}
string sEmployeeName = "";
int iCodeRow = 5;
int iCurrRow = 6;
int iCurrCol = 1;
while(!TrainCL.TrainingRecord.EOF)
{
ViewModel.sprReport2.Row = iCurrRow;
ViewModel.sprReport2.Col = iCurrCol;
bDisplay = false;
if (sEmployeeName == "")
{ //first time
sEmployeeName = modGlobal.Clean(TrainCL.TrainingRecord["name_full"]);
ViewModel.sprReport2.Text = sEmployeeName;
ViewModel.sprReport2.Col = iCurrCol + 1;
if (modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]) == "")
{
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]);
}
else if (modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]) == "*")
{
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]);
}
else
{
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]) + " " +
modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]);
}
ViewModel.sprReport2.Col = iCurrCol + 2;
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["group_number"]);
ViewModel.sprReport2.Col = iCurrCol + 3;
if (modGlobal.Clean(TrainCL.TrainingRecord["recert_date"]) == "")
{
ViewModel.sprReport2.Text = "";
}
else
{
ViewModel.sprReport2.Text = Convert.ToDateTime(TrainCL.TrainingRecord["recert_date"]).ToString("M/d/yyyy");
}
if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) != "")
{
ViewModel.sprReport2.Row = iCodeRow;
int tempForVar = ViewModel.sprReport2.MaxCols;
for (int i = 5; i <= tempForVar; i++)
{
ViewModel.sprReport2.Col = i;
if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) == modGlobal.Clean(ViewModel.sprReport2.Text))
{
ViewModel.sprReport2.Col = i + 1;
//UPGRADE_WARNING: (1068) GetVal(sprReport2.Text) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
if (Convert.ToDouble(modGlobal.GetVal(ViewModel.sprReport2.Text)) == 3)
{
bDisplay = true;
}
ViewModel.sprReport2.Col = i;
ViewModel.sprReport2.Row = iCurrRow;
if (modGlobal.Clean(TrainCL.TrainingRecord["LatestDate"]) != "")
{
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["LatestDate"]);
ViewModel.sprReport2.Col = i + 1;
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["TotalHours"]);
// If bDisplay Then
// sprReport2.Col = i + 2
// sprReport2.Text = Clean(TrainCL.TrainingRecord("FlagComment"])
// End If
}
break;
}
}
}
}
else if (sEmployeeName == modGlobal.Clean(TrainCL.TrainingRecord["name_full"]))
{
if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) != "")
{
ViewModel.sprReport2.Row = iCodeRow;
int tempForVar2 = ViewModel.sprReport2.MaxCols;
for (int i = 5; i <= tempForVar2; i++)
{
ViewModel.sprReport2.Col = i;
if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) == modGlobal.Clean(ViewModel.sprReport2.Text))
{
ViewModel.sprReport2.Col = i + 1;
//UPGRADE_WARNING: (1068) GetVal(sprReport2.Text) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
if (Convert.ToDouble(modGlobal.GetVal(ViewModel.sprReport2.Text)) == 3)
{
bDisplay = true;
}
ViewModel.sprReport2.Col = i;
ViewModel.sprReport2.Row = iCurrRow;
if (modGlobal.Clean(TrainCL.TrainingRecord["LatestDate"]) != "")
{
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["LatestDate"]);
ViewModel.sprReport2.Col = i + 1;
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["TotalHours"]);
// If bDisplay Then
// sprReport2.Col = i + 2
// sprReport2.Text = Clean(TrainCL.TrainingRecord("FlagComment"])
// End If
}
break;
}
}
}
}
else
{
iCurrRow++;
ViewModel.sprReport2.Row = iCurrRow;
sEmployeeName = modGlobal.Clean(TrainCL.TrainingRecord["name_full"]);
ViewModel.sprReport2.Text = sEmployeeName;
ViewModel.sprReport2.Col = iCurrCol + 1;
if (modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]) == "")
{
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]);
}
else if (modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]) == "*")
{
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]);
}
else
{
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]) + " " +
modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]);
}
ViewModel.sprReport2.Col = iCurrCol + 2;
if (modGlobal.Clean(TrainCL.TrainingRecord["group_number"]) == "0")
{
ViewModel.sprReport2.Text = "";
}
else
{
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["group_number"]);
}
ViewModel.sprReport2.Col = iCurrCol + 3;
if (modGlobal.Clean(TrainCL.TrainingRecord["recert_date"]) == "")
{
ViewModel.sprReport2.Text = "";
}
else
{
ViewModel.sprReport2.Text = Convert.ToDateTime(TrainCL.TrainingRecord["recert_date"]).ToString("M/d/yyyy");
}
if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) != "")
{
ViewModel.sprReport2.Row = iCodeRow;
int tempForVar3 = ViewModel.sprReport2.MaxCols;
for (int i = 5; i <= tempForVar3; i++)
{
ViewModel.sprReport2.Col = i;
if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) == modGlobal.Clean(ViewModel.sprReport2.Text))
{
ViewModel.sprReport2.Col = i + 1;
//UPGRADE_WARNING: (1068) GetVal(sprReport2.Text) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
if (Convert.ToDouble(modGlobal.GetVal(ViewModel.sprReport2.Text)) == 3)
{
bDisplay = true;
}
ViewModel.sprReport2.Col = i;
ViewModel.sprReport2.Row = iCurrRow;
if (modGlobal.Clean(TrainCL.TrainingRecord["LatestDate"]) != "")
{
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["LatestDate"]);
ViewModel.sprReport2.Col = i + 1;
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["TotalHours"]);
if (bDisplay)
{
ViewModel.sprReport2.Col = i + 2;
ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["FlagComment"]);
}
}
break;
}
}
}
}
TrainCL.TrainingRecord.MoveNext();
}
;
}