public void FormatHeadings()
{
PTSProject.clsTraining TrainCL = Container.Resolve <clsTraining>();
if (ViewModel.FirstTime)
{
return;
}
ViewModel.sprReport.Row = 4;
ViewModel.sprReport.Row2 = ViewModel.sprReport.MaxRows;
ViewModel.sprReport.Col = 1;
ViewModel.sprReport.Col2 = ViewModel.sprReport.MaxCols;
ViewModel.sprReport.BlockMode = true;
ViewModel.sprReport.Text = "";
ViewModel.sprReport.BackColor = modGlobal.Shared.WHITE;
ViewModel.sprReport.BlockMode = false;
//Set colors...
//Green
ViewModel.sprReport.Row = 4;
ViewModel.sprReport.Row2 = ViewModel.sprReport.MaxRows;
ViewModel.sprReport.Col = 5;
ViewModel.sprReport.Col2 = 6;
ViewModel.sprReport.BlockMode = true;
ViewModel.sprReport.BackColor = UpgradeHelpers.Helpers.ColorTranslator.FromOle(modGlobal.TrainingGreen);
ViewModel.sprReport.BlockMode = false;
//Blue
ViewModel.sprReport.Row = 4;
ViewModel.sprReport.Row2 = ViewModel.sprReport.MaxRows;
ViewModel.sprReport.Col = 7;
ViewModel.sprReport.Col2 = 9;
ViewModel.sprReport.BlockMode = true;
ViewModel.sprReport.BackColor = UpgradeHelpers.Helpers.ColorTranslator.FromOle(modGlobal.TrainingBlue);
ViewModel.sprReport.BlockMode = false;
//Yellow
ViewModel.sprReport.Row = 4;
ViewModel.sprReport.Row2 = ViewModel.sprReport.MaxRows;
ViewModel.sprReport.Col = 10;
ViewModel.sprReport.Col2 = 12;
ViewModel.sprReport.BlockMode = true;
ViewModel.sprReport.BackColor = UpgradeHelpers.Helpers.ColorTranslator.FromOle(modGlobal.TrainingYellow);
ViewModel.sprReport.BlockMode = false;
//Peach
ViewModel.sprReport.Row = 4;
ViewModel.sprReport.Row2 = ViewModel.sprReport.MaxRows;
ViewModel.sprReport.Col = 13;
ViewModel.sprReport.Col2 = 15;
ViewModel.sprReport.BlockMode = true;
ViewModel.sprReport.BackColor = UpgradeHelpers.Helpers.ColorTranslator.FromOle(modGlobal.TrainingPeach);
ViewModel.sprReport.BlockMode = false;
string sHeading = "";
sHeading = ViewModel.CurrYear.ToString() + " - ";
switch (ViewModel.CurrQuarter)
{
case 4:
sHeading = sHeading + "4th Quarter Report";
break;
case 3:
sHeading = sHeading + "3rd Quarter Report";
break;
case 2:
sHeading = sHeading + "2nd Quarter Report";
break;
default:
sHeading = sHeading + "1st Quarter Report";
break;
}
ViewModel.sprReport.Row = 2;
ViewModel.sprReport.Col = 1;
ViewModel.sprReport.Text = sHeading;
sHeading = "FCC Minimum Standard Drills For ";
if (ViewModel.CurrShift == "")
{
sHeading = sHeading + "All Shifts";
}
else
{
sHeading = sHeading + "Shift " + ViewModel.CurrShift;
}
ViewModel.sprReport.Row = 3;
ViewModel.sprReport.Col = 1;
ViewModel.sprReport.Text = sHeading;
ViewModel.sprReport.Row = 5;
ViewModel.sprReport.Col = 1;
ViewModel.sprReport.Text = "Name";
ViewModel.sprReport.Col = 2;
ViewModel.sprReport.Text = "Unit";
ViewModel.sprReport.Col = 3;
ViewModel.sprReport.Text = "Shift";
ViewModel.sprReport.Col = 4;
ViewModel.sprReport.Text = "Batt";
if (TrainCL.GetTrainingFCCDrillsByYearQuarter(ViewModel.CurrYear, ViewModel.CurrQuarter) != 0)
{
//continue
}
else
{
ViewManager.ShowMessage("Oh No! There are no Training FCC Standard Drills set up for Year/Quarter!", "Training Quarterly Report", UpgradeHelpers.Helpers.BoxButtons.OK);
return;
}
int iCurrRow = 4;
int iCurrCol = 5;
string sSubHeading = "";
int iReportColumn = 1;
while (!TrainCL.TrainingRecord.EOF)
{
ViewModel.sprReport.Row = iCurrRow;
ViewModel.sprReport.Col = iCurrCol;
if (sSubHeading == "")
{ //first time
sSubHeading = modGlobal.Clean(TrainCL.TrainingRecord["standard_description"]);
ViewModel.sprReport.Text = sSubHeading;
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
iReportColumn = Convert.ToInt32(modGlobal.GetVal(TrainCL.TrainingRecord["report_column"]));
ViewModel.sprReport.Row = iCurrRow + 1;
ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["description"]);
ViewModel.sprReport.Row = iCurrRow + 2;
ViewModel.sprReport.Text = iReportColumn.ToString();
iCurrCol++;
}
else if (sSubHeading == modGlobal.Clean(TrainCL.TrainingRecord["standard_description"]))
{
ViewModel.sprReport.Row = iCurrRow + 1;
//UPGRADE_WARNING: (1068) GetVal(TrainCL.TrainingRecord(report_column)) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
if (iReportColumn == Convert.ToDouble(modGlobal.GetVal(TrainCL.TrainingRecord["report_column"])))
{
ViewModel.sprReport.Col = iReportColumn + 4;
ViewModel.sprReport.Text = modGlobal.Clean(ViewModel.sprReport.Text) + " / " + modGlobal.Clean(TrainCL.TrainingRecord["description"]);
}
else
{
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
iReportColumn = Convert.ToInt32(modGlobal.GetVal(TrainCL.TrainingRecord["report_column"]));
ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["description"]);
ViewModel.sprReport.Row = iCurrRow + 2;
ViewModel.sprReport.Text = iReportColumn.ToString();
// sprReport.Text = Clean(TrainCL.TrainingRecord("trn_specific_code"])
iCurrCol++;
}
}
else
{
sSubHeading = modGlobal.Clean(TrainCL.TrainingRecord["standard_description"]);
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
iReportColumn = Convert.ToInt32(modGlobal.GetVal(TrainCL.TrainingRecord["report_column"]));
ViewModel.sprReport.Text = sSubHeading;
ViewModel.sprReport.Row = iCurrRow + 1;
ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["description"]);
ViewModel.sprReport.Row = iCurrRow + 2;
ViewModel.sprReport.Text = iReportColumn.ToString();
iCurrCol++;
}
TrainCL.TrainingRecord.MoveNext();
}
;
}