private void sprRequests_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
if (Row == 0)
{
return;
}
ViewModel.sprRequests.Row = Row;
ViewModel.sprRequests.Col = 8;
if (modGlobal.Clean(ViewModel.sprRequests.Text) == "")
{
return;
}
string Empid = modGlobal.Clean(ViewModel.sprRequests.Text);
for (int i = 0; i <= ViewModel.cboReqNameList.Items.Count - 1; i++)
{
if (Empid == ViewModel.cboReqNameList.GetListItem(i).Substring(Math.Max(ViewModel.cboReqNameList.GetListItem(i).Length - 5, 0)))
{
ViewModel.NoRefresh = true;
ViewModel.cboReqNameList.SelectedIndex = i;
break;
}
}
ViewModel.NoRefresh = false;
}
private void sprAvailable_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
ViewModel.cmdDelete.Enabled = false;
ViewModel.CurrRecordID = 0;
if (Row == 0)
{
return;
}
ViewModel.CurrRow = Row;
ViewModel.sprAvailable.Row = ViewModel.CurrRow;
ViewModel.sprAvailable.Col = 4;
if (modGlobal.Clean(ViewModel.sprAvailable.Text) == "")
{
ViewModel.CurrRow = 0;
return;
}
else
{
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
ViewModel.CurrRecordID = Convert.ToInt32(modGlobal.GetVal(ViewModel.sprAvailable.Text));
}
ViewModel.cmdDelete.Enabled = true;
}
private void sprPositions_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
//Need to Edit Position...
//int i = 0;
ViewModel.cmdInactivate.Enabled = false;
if (Row == 0)
{
return;
}
ViewModel.sprPositions.Row = Row;
ViewModel.sprPositions.Col = 6;
if (modGlobal.Clean(ViewModel.sprPositions.Text) == "")
{
return;
}
if (ViewModel.sprPositions.BackColor == UpgradeHelpers.Helpers.ColorTranslator.FromOle(modGlobal.LT_BLUE))
{
return;
}
ViewModel.CurrPosition = Convert.ToInt32(Double.Parse(ViewModel.sprPositions.Text));
ViewModel.cmdInactivate.Enabled = true;
}
private void sprEmployeeList_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
if (Row == 0)
{
return;
}
ViewModel.sprEmployeeList.BlockMode = true;
ViewModel.sprEmployeeList.Col = 1;
ViewModel.sprEmployeeList.Col2 = ViewModel.sprEmployeeList.MaxCols;
ViewModel.sprEmployeeList.Row = ViewModel.CurrRow;
ViewModel.sprEmployeeList.Row2 = ViewModel.CurrRow;
ViewModel.sprEmployeeList.BackColor = modGlobal.Shared.WHITE;
ViewModel.sprEmployeeList.BlockMode = false;
ViewModel.CurrRow = Row;
ViewModel.sprEmployeeList.Row = ViewModel.CurrRow;
ViewModel.sprEmployeeList.Col = 13;
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
ViewModel.CurrEmp = Convert.ToInt32(modGlobal.GetVal(ViewModel.sprEmployeeList.Text));
GetEmployeeDetail();
}
private void sprPPEList_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
//int lColClicked = 0;
//int lRowClicked = 0;
if (Row == 0)
{
return;
} //header clicked
if (Col == 2 || Col == 3)
{
//continue
}
else
{
return;
}
ViewModel.sprPPEList.Row = Row;
ViewModel.sprPPEList.Col = Col;
if (UpgradeHelpers.Helpers.StringsHelper.ToDoubleSafe(Convert.ToString(ViewModel.sprPPEList.Value)) == 1)
{
//UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread property sprPPEList.TypeCheckText was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx
ViewModel.sprPPEList.setTypeCheckText(DateTime.Now.ToString("M/d/yyyy"));
}
else
{
//UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread property sprPPEList.TypeCheckText was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx
ViewModel.sprPPEList.setTypeCheckText("");
}
}
private void sprEmployeeList_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
if (Row == 0)
{
return;
}
}
private void sprMissing_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
if (Row == 0)
{
return;
}
ViewModel.SelectedRow = Row;
ViewModel.sprMissing.Row = ViewModel.SelectedRow;
ViewModel.sprMissing.Col = 2;
ViewModel.Empid = modGlobal.Clean(ViewModel.sprMissing.Text);
ViewModel.sprMissing.Col = 3;
ViewModel.TimeCode = modGlobal.Clean(ViewModel.sprMissing.Text);
if (modGlobal.Shared.gBatt == "2")
{
if (ViewModel.TimeCode == "REG")
{
ViewModel.AssignID = modGlobal.ASGN182ROV;
}
else
{
ViewModel.AssignID = modGlobal.ASGN182DBT;
}
}
else if (modGlobal.Shared.gBatt == "1")
{
if (ViewModel.TimeCode == "REG")
{
ViewModel.AssignID = modGlobal.ASGN181ROV;
}
else
{
ViewModel.AssignID = modGlobal.ASGN181DBT;
}
}
else
{
//gBatt = "3"
if (ViewModel.TimeCode == "REG")
{
ViewModel.AssignID = modGlobal.ASGN183ROV;
}
else
{
ViewModel.AssignID = modGlobal.ASGN183DBT;
}
}
}
private void sprList_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
//Add logic to fill information
if (Row == 0)
{
return;
}
ViewModel.CurrRow = Row;
GetDetail();
}
private void sprPromoList_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
if (Row == 0)
{
return;
}
ViewModel.sprPromoList.Row = Row;
ViewModel.sprPromoList.Col = 1;
if (modGlobal.Clean(ViewModel.sprPromoList.Text) == "")
{
return;
}
ViewModel.iSelectedRow = Row;
LoadForm();
}
private void sprSpecialtyList_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
if (Row == 0)
{
return;
}
ClearScreen();
ViewModel.sprSpecialtyList.Col = 1;
ViewModel.sprSpecialtyList.Row = Row;
if (modGlobal.Clean(ViewModel.sprSpecialtyList.Text) == "")
{
return;
}
ViewModel.lbRemoveName.Text = ViewModel.sprSpecialtyList.Text;
ViewModel.lbUpgradeName.Text = ViewModel.sprSpecialtyList.Text;
ViewModel.sprSpecialtyList.Col = 2;
ViewModel.EmployeeID = modGlobal.Clean(ViewModel.sprSpecialtyList.Text);
ViewModel.sprSpecialtyList.Col = 3;
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
ViewModel.PersonnelID = Convert.ToInt32(modGlobal.GetVal(ViewModel.sprSpecialtyList.Text));
//ViewModel.sprSpecialtyList.SetSelection(1, Row, 2, Row);
ViewModel.sprSpecialtyList.Col = 1;
ViewModel.sprSpecialtyList.Col2 = ViewModel.sprSpecialtyList.MaxCols;
ViewModel.sprSpecialtyList.Row = Row;
ViewModel.sprSpecialtyList.Row2 = Row;
ViewModel.sprSpecialtyList.BlockMode = true;
ViewModel.sprSpecialtyList.BackColor = modGlobal.Shared.YELLOW;
ViewModel.sprSpecialtyList.BlockMode = false;
ViewModel.SpecialtyRow = Row;
if (CheckEmployeeValid() != 0)
{
}
}
private void sprPPEList_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
if (Col == 1)
{
ViewModel.sprPPEList.Row = Row;
ViewModel.sprPPEList.Col = Col;
if (modGlobal.Clean(ViewModel.sprPPEList.Text) != "")
{
ViewModel.sprPPEList.Col = 8;
if (modGlobal.Clean(ViewModel.sprPPEList.Text) != "")
{
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
ViewModel.iUniformID = Convert.ToInt32(modGlobal.GetVal(ViewModel.sprPPEList.Text));
}
else
{
ViewModel.sprPPEList.Col = 1;
ViewModel.iUniformID = 0;
ViewModel.UniformDescription = modGlobal.Clean(ViewModel.sprPPEList.Text);
FindUniformID();
if (ViewModel.iUniformID == 0)
{
return;
}
else
{
ViewModel.sprPPEList.Col = 8;
ViewModel.sprPPEList.Text = ViewModel.iUniformID.ToString();
}
}
ViewModel.OKButton.Enabled = true;
}
}
}
private void sprPastComments_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
if (Row == 0)
{
return;
}
if (Row > ViewModel.sprPastComments.DataRowCnt)
{
return;
}
int CurrRow = Row;
ViewModel.sprPastComments.Col = 2;
ViewModel.sprPastComments.Row = CurrRow;
ViewModel.lbNoteID.Text = ViewModel.sprPastComments.Text;
DbCommand oCmd = UpgradeHelpers.DB.AdoFactoryManager.GetFactory().CreateCommand();
oCmd.Connection = modGlobal.oConn;
oCmd.CommandType = CommandType.Text;
string strSQL = "";
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
strSQL = "spSelect_PersonnelNotesByID " + Convert.ToString(modGlobal.GetVal(ViewModel.lbNoteID.Text)) + " ";
oCmd.CommandText = strSQL;
ADORecordSetHelper oRec = ADORecordSetHelper.Open(oCmd, "");
if (!oRec.EOF)
{
ViewModel.txtNewNote.Text = modGlobal.Clean(oRec["comment"]);
}
}
private void sprAvailable_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
if (Row == 0)
{
return;
}
ViewModel.sprAvailable.Col = 1;
if (modGlobal.Clean(ViewModel.sprAvailable.Text) == "")
{
return;
}
ViewModel.CurrRow = Row;
ViewModel.sprAvailable.Row = ViewModel.CurrRow;
ViewModel.sprAvailable.Col = 6;
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
ViewModel.CurrRecord = Convert.ToInt32(modGlobal.GetVal(ViewModel.sprAvailable.Text));
ViewModel.sprAvailable.Col = 7;
ViewModel.CurrEmpID = modGlobal.Clean(ViewModel.sprAvailable.Text);
GetEmployeeDetail();
}
private void sprEmployeeList_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
ViewModel.CurrPersID = 0;
if (Row == 0)
{
// Exit Sub
Row = 1;
}
ViewModel.SelectedEmpRow = Row;
//UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread method sprEmployeeList.ClearSelection was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx
ViewModel.sprEmployeeList.ClearSelection();
ViewModel.sprEmployeeList.Row = 1;
ViewModel.sprEmployeeList.Row2 = ViewModel.sprEmployeeList.MaxRows;
ViewModel.sprEmployeeList.Col = 1;
ViewModel.sprEmployeeList.Col2 = ViewModel.sprEmployeeList.MaxCols;
ViewModel.sprEmployeeList.BlockMode = true;
ViewModel.sprEmployeeList.BackColor = modGlobal.Shared.WHITE;
ViewModel.sprEmployeeList.BlockMode = false;
//ViewModel.sprEmployeeList.SetSelection(1, Row, ViewModel.sprEmployeeList.MaxCols, Row);
ViewModel.sprEmployeeList.Row = Row;
ViewModel.sprEmployeeList.Row2 = Row;
ViewModel.sprEmployeeList.Col = 1;
ViewModel.sprEmployeeList.Col2 = ViewModel.sprEmployeeList.MaxCols;
ViewModel.sprEmployeeList.BlockMode = true;
ViewModel.sprEmployeeList.BackColor = modGlobal.Shared.YELLOW;
ViewModel.sprEmployeeList.BlockMode = false;
ViewModel.sprEmployeeList.Row = Row;
ViewModel.sprEmployeeList.Col = 8;
ViewModel.CurrPersID = Convert.ToInt32(Double.Parse(modGlobal.Clean(ViewModel.sprEmployeeList.Text)));
GetEmployeeInfo();
}
private void sprRequests_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
PTSProject.clsScheduler cTransfer = Container.Resolve <clsScheduler>();
if (ViewModel.CurrReqRow != 0)
{
ViewModel.sprRequests.Row = ViewModel.CurrReqRow;
int tempForVar = ViewModel.sprRequests.MaxRows;
for (int i = 1; i <= tempForVar; i++)
{
ViewModel.sprRequests.Col = i;
ViewModel.sprRequests.BackColor = modGlobal.Shared.WHITE;
}
}
if (Row == 0)
{
return;
}
ViewModel.lbRequest.Text = "";
ViewModel.CurrRequest = 0;
ViewModel.CurrReqRow = Row;
ViewModel.sprRequests.Row = ViewModel.CurrReqRow;
ViewModel.sprRequests.Col = 4;
if (modGlobal.Clean(ViewModel.sprRequests.Text) == "")
{
ViewModel.CurrRequest = 0;
ViewModel.CurrReqRow = 0;
}
else
{
ViewModel.CurrRequest = Convert.ToInt32(Double.Parse(ViewModel.sprRequests.Text));
}
if (ViewModel.CurrRequest == 0)
{
ViewModel.CurrReqRow = 0;
return;
}
if (~cTransfer.GetTransferRequestByID(ViewModel.CurrRequest) != 0)
{
ViewManager.ShowMessage("Oooops! Can't find Request Record... Try Again!", "Get Request Record", UpgradeHelpers.Helpers.BoxButtons.OK);
ViewModel.CurrRequest = 0;
ViewModel.CurrReqRow = 0;
return;
}
ViewModel.sprRequests.Col = 2;
ViewModel.lbRequest.Text = modGlobal.Clean(ViewModel.sprRequests.Text);
if (ViewModel.CurrReqRow != 0)
{
ViewModel.sprRequests.Row = ViewModel.CurrReqRow;
int tempForVar2 = ViewModel.sprRequests.MaxRows;
for (int i = 1; i <= tempForVar2; i++)
{
ViewModel.sprRequests.Col = i;
ViewModel.sprRequests.BackColor = modGlobal.Shared.YELLOW;
}
}
EnableButtons();
}
private void sprRepairGrid_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>();
if (Row == 0)
{
return;
}
ViewModel.iCurrRow = Row;
ViewModel.sprRepairGrid.Row = ViewModel.iCurrRow;
//ViewModel.sprRepairGrid.SetSelection(1, ViewModel.iCurrRow, ViewModel.sprRepairGrid.MaxCols, ViewModel.iCurrRow);
ViewModel.sprRepairGrid.Col = 6;
if (modGlobal.Clean(ViewModel.sprRepairGrid.Text) == "")
{
return;
}
else
{
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
ViewModel.lbRepairID.Text = Convert.ToString(modGlobal.GetVal(ViewModel.sprRepairGrid.Text));
}
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
if (UniformCL.GetUniformRepairByID(Convert.ToInt32(modGlobal.GetVal(ViewModel.lbRepairID.Text))) != 0)
{
//continue
}
else
{
ViewManager.ShowMessage("Oooops! No Uniform Repair Record was found!", "Get Repair Record", UpgradeHelpers.Helpers.BoxButtons.OK);
return;
}
ViewModel.lbRepairID.Text = UniformCL.UniformRepairID.ToString();
if (UniformCL.UniformRepairDateIn == "")
{
ViewModel.dteDateIn.Visible = false;
ViewModel.chkDateIn.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked;
}
else
{
ViewModel.chkDateIn.CheckState = UpgradeHelpers.Helpers.CheckState.Checked;
ViewModel.dteDateIn.Visible = true;
ViewModel.dteDateIn.Text = UniformCL.UniformRepairDateIn;
}
if (UniformCL.UniformRepairDateOut == "")
{
ViewModel.dteDateOut.Visible = false;
ViewModel.chkDateOut.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked;
}
else
{
ViewModel.chkDateOut.CheckState = UpgradeHelpers.Helpers.CheckState.Checked;
ViewModel.dteDateOut.Visible = true;
ViewModel.dteDateOut.Text = UniformCL.UniformRepairDateOut;
}
for (int i = 0; i <= ViewModel.cboRepairer.Items.Count - 1; i++)
{
if (ViewModel.cboRepairer.GetItemData(i) == UniformCL.UniformRepairerID)
{
ViewModel.cboRepairer.SelectedIndex = i;
break;
}
}
ViewModel.txtComment.Text = UniformCL.UniformRepairComment;
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
if (UniformCL.GetUniformRepairLaunderInfoByID(Convert.ToInt32(modGlobal.GetVal(ViewModel.lbRepairID.Text))) != 0)
{
ViewModel.chkVendor.CheckState = UpgradeHelpers.Helpers.CheckState.Checked;
ViewModel.chkVendor.Enabled = false;
ViewModel.LaundryRecordExists = true;
}
else
{
ViewModel.chkVendor.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked;
ViewModel.chkVendor.Enabled = true;
ViewModel.LaundryRecordExists = false;
}
ViewModel.cmdEdit.Text = "Update";
ViewModel.cmdEdit.Tag = "0";
ViewModel.cmdEdit.Enabled = true;
}
private void sprAnnual_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
//Highlight Selected cell
//Save Selected Date to Module level variable
if (ViewModel.OldCol != 0)
{
ViewModel.sprAnnual.Col = ViewModel.OldCol;
ViewModel.sprAnnual.Row = ViewModel.OldRow;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.sprAnnual.BackColor = modGlobal.Shared.WHITE;
}
else
{
ViewModel.sprAnnual.BackColor = modGlobal.Shared.GRAY;
}
}
ViewModel.sprAnnual.Row = Row;
switch (Col)
{
case 1:
case 2:
case 3:
if (Col != 2)
{
Col = 2;
}
ViewModel.sprAnnual.Col = Col;
ViewModel.sprAnnual.BackColor = modGlobal.Shared.BLUE;
{
}
ViewModel.OldAMPM = ViewModel.sprAnnual.Text.Trim();
ViewModel.sprAnnual.Col = 1;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.SelectedDate = "1/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00AM";
}
else
{
ViewModel.sprAnnual.Row = Row - 1;
ViewModel.SelectedDate = "1/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00PM";
}
ViewModel.OldCol = Col;
ViewModel.OldRow = Row;
break;
case 4:
case 5:
case 6:
if (Col != 5)
{
Col = 5;
}
ViewModel.sprAnnual.Col = Col;
ViewModel.sprAnnual.BackColor = modGlobal.Shared.BLUE;
{
}
ViewModel.OldAMPM = ViewModel.sprAnnual.Text.Trim();
ViewModel.sprAnnual.Col = 4;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.SelectedDate = "2/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00AM";
}
else
{
ViewModel.sprAnnual.Row = Row - 1;
ViewModel.SelectedDate = "2/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00PM";
}
ViewModel.OldCol = Col;
ViewModel.OldRow = Row;
break;
case 7:
case 8:
case 9:
if (Col != 8)
{
Col = 8;
}
ViewModel.sprAnnual.Col = Col;
ViewModel.sprAnnual.BackColor = modGlobal.Shared.BLUE;
{
}
ViewModel.OldAMPM = ViewModel.sprAnnual.Text.Trim();
ViewModel.sprAnnual.Col = 7;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.SelectedDate = "3/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00AM";
}
else
{
ViewModel.sprAnnual.Row = Row - 1;
ViewModel.SelectedDate = "3/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00PM";
}
ViewModel.OldCol = Col;
ViewModel.OldRow = Row;
break;
case 10:
case 11:
case 12:
if (Col != 11)
{
Col = 11;
}
ViewModel.sprAnnual.Col = Col;
ViewModel.sprAnnual.BackColor = modGlobal.Shared.BLUE;
{
}
ViewModel.OldAMPM = ViewModel.sprAnnual.Text.Trim();
ViewModel.sprAnnual.Col = 10;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.SelectedDate = "4/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00AM";
}
else
{
ViewModel.sprAnnual.Row = Row - 1;
ViewModel.SelectedDate = "4/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00PM";
}
ViewModel.OldCol = Col;
ViewModel.OldRow = Row;
break;
case 13:
case 14:
case 15:
if (Col != 14)
{
Col = 14;
}
ViewModel.sprAnnual.Col = Col;
ViewModel.sprAnnual.BackColor = modGlobal.Shared.BLUE;
{
}
ViewModel.OldAMPM = ViewModel.sprAnnual.Text.Trim();
ViewModel.sprAnnual.Col = 13;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.SelectedDate = "5/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00AM";
}
else
{
ViewModel.sprAnnual.Row = Row - 1;
ViewModel.SelectedDate = "5/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00PM";
}
ViewModel.OldCol = Col;
ViewModel.OldRow = Row;
break;
case 16:
case 17:
case 18:
if (Col != 17)
{
Col = 17;
}
ViewModel.sprAnnual.Col = Col;
ViewModel.sprAnnual.BackColor = modGlobal.Shared.BLUE;
{
}
ViewModel.OldAMPM = ViewModel.sprAnnual.Text.Trim();
ViewModel.sprAnnual.Col = 16;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.SelectedDate = "6/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00AM";
}
else
{
ViewModel.sprAnnual.Row = Row - 1;
ViewModel.SelectedDate = "6/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00PM";
}
ViewModel.OldCol = Col;
ViewModel.OldRow = Row;
break;
case 19:
case 20:
case 21:
if (Col != 20)
{
Col = 20;
}
ViewModel.sprAnnual.Col = Col;
ViewModel.sprAnnual.BackColor = modGlobal.Shared.BLUE;
{
}
ViewModel.OldAMPM = ViewModel.sprAnnual.Text.Trim();
ViewModel.sprAnnual.Col = 19;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.SelectedDate = "7/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00AM";
}
else
{
ViewModel.sprAnnual.Row = Row - 1;
ViewModel.SelectedDate = "7/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00PM";
}
ViewModel.OldCol = Col;
ViewModel.OldRow = Row;
break;
case 22:
case 23:
case 24:
if (Col != 23)
{
Col = 23;
}
ViewModel.sprAnnual.Col = Col;
ViewModel.sprAnnual.BackColor = modGlobal.Shared.BLUE;
{
}
ViewModel.OldAMPM = ViewModel.sprAnnual.Text.Trim();
ViewModel.sprAnnual.Col = 22;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.SelectedDate = "8/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00AM";
}
else
{
ViewModel.sprAnnual.Row = Row - 1;
ViewModel.SelectedDate = "8/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00PM";
}
ViewModel.OldCol = Col;
ViewModel.OldRow = Row;
break;
case 25:
case 26:
case 27:
if (Col != 26)
{
Col = 26;
}
ViewModel.sprAnnual.Col = Col;
ViewModel.sprAnnual.BackColor = modGlobal.Shared.BLUE;
{
}
ViewModel.OldAMPM = ViewModel.sprAnnual.Text.Trim();
ViewModel.sprAnnual.Col = 25;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.SelectedDate = "9/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00AM";
}
else
{
ViewModel.sprAnnual.Row = Row - 1;
ViewModel.SelectedDate = "9/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00PM";
}
ViewModel.OldCol = Col;
ViewModel.OldRow = Row;
break;
case 28:
case 29:
case 30:
if (Col != 29)
{
Col = 29;
}
ViewModel.sprAnnual.Col = Col;
ViewModel.sprAnnual.BackColor = modGlobal.Shared.BLUE;
{
}
ViewModel.OldAMPM = ViewModel.sprAnnual.Text.Trim();
ViewModel.sprAnnual.Col = 28;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.SelectedDate = "10/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00AM";
}
else
{
ViewModel.sprAnnual.Row = Row - 1;
ViewModel.SelectedDate = "10/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00PM";
}
ViewModel.OldCol = Col;
ViewModel.OldRow = Row;
break;
case 31:
case 32:
case 33:
if (Col != 32)
{
Col = 32;
}
ViewModel.sprAnnual.Col = Col;
ViewModel.sprAnnual.BackColor = modGlobal.Shared.BLUE;
{
}
ViewModel.OldAMPM = ViewModel.sprAnnual.Text.Trim();
ViewModel.sprAnnual.Col = 31;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.SelectedDate = "11/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00AM";
}
else
{
ViewModel.sprAnnual.Row = Row - 1;
ViewModel.SelectedDate = "11/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00PM";
}
ViewModel.OldCol = Col;
ViewModel.OldRow = Row;
break;
case 34:
case 35:
case 36:
if (Col != 35)
{
Col = 35;
}
ViewModel.sprAnnual.Col = Col;
ViewModel.sprAnnual.BackColor = modGlobal.Shared.BLUE;
{
}
ViewModel.OldAMPM = ViewModel.sprAnnual.Text.Trim();
ViewModel.sprAnnual.Col = 34;
if (ViewModel.OldAMPM == "AM")
{
ViewModel.SelectedDate = "12/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00AM";
}
else
{
ViewModel.sprAnnual.Row = Row - 1;
ViewModel.SelectedDate = "12/" + ViewModel.sprAnnual.Text.Trim() + "/" + ViewModel.ReportYear + " 7:00PM";
}
ViewModel.OldCol = Col;
ViewModel.OldRow = Row;
break;
}
}
private void sprDaysOff_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
string sDate = "";
DbCommand oCmd = UpgradeHelpers.DB.AdoFactoryManager.GetFactory().CreateCommand();
ADORecordSetHelper oRec = null;
int iCol = 0;
int iRow = 0;
// MsgBox "This feature is under construction...", vbOKOnly, "Sick Leave Usage Report"
//clear sprDetail grid
ViewModel.sprDetail.Col = 1;
ViewModel.sprDetail.Col2 = ViewModel.sprDetail.MaxCols;
ViewModel.sprDetail.Row = 1;
ViewModel.sprDetail.Row2 = ViewModel.sprDetail.MaxRows;
ViewModel.sprDetail.BlockMode = true;
ViewModel.sprDetail.Text = "";
ViewModel.sprDetail.BlockMode = false;
//If report headers clicked... then exit
if (Row < 5)
{
return;
}
if (Col == 1 || Col == 2 || Col == 3)
{
return;
}
ViewModel.sprDaysOff.Col = 3;
ViewModel.sprDaysOff.Row = Row;
if (modGlobal.Clean(ViewModel.sprDaysOff.Text) != "A" && modGlobal.Clean(ViewModel.sprDaysOff.Text)
!= "B" && modGlobal.Clean(ViewModel.sprDaysOff.Text) != "C" && modGlobal.Clean(ViewModel.sprDaysOff.Text) != "D")
{
return;
}
ViewModel.sprDaysOff.Col = 1;
if (!Information.IsDate(ViewModel.sprDaysOff.Text))
{
return;
}
else
{
sDate = DateTime.Parse(ViewModel.sprDaysOff.Text).ToString("M/d/yyyy");
}
iCol = Col;
iRow = Row;
ViewModel.sprDaysOff.Col = iCol;
ViewModel.sprDaysOff.Row = iRow;
//If there is no value... then nothing to report
if (modGlobal.Clean(ViewModel.sprDaysOff.Text) == "")
{
return;
}
//UPGRADE_WARNING: (1068) GetVal(sprDaysOff.Text) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
if (Convert.ToDouble(modGlobal.GetVal(ViewModel.sprDaysOff.Text)) == 0)
{
return;
}
oCmd.Connection = modGlobal.oConn;
oCmd.CommandType = CommandType.Text;
switch (iCol)
{
case 4:
case 5: //Sick Leave on recognized Holiday
oCmd.CommandText = "spReport_SickLeaveUseDetailOnHoliday '" + sDate + "' ";
oRec = ADORecordSetHelper.Open(oCmd, "");
break;
case 6:
case 7: //Sick Leave on scheduled Debit
oCmd.CommandText = "spReport_SickLeaveUseDetailOnDebit '" + sDate + "' ";
oRec = ADORecordSetHelper.Open(oCmd, "");
break;
case 8:
case 9: //Sick Leave on scheduled Trade
oCmd.CommandText = "spReport_SickLeaveUseDetailOnTrade '" + sDate + "' ";
oRec = ADORecordSetHelper.Open(oCmd, "");
break;
case 10:
case 11: //Sick Leave on the Weekend (Sat or Sun)
oCmd.CommandText = "spReport_SickLeaveUseDetailOnWeekend '" + sDate + "' ";
oRec = ADORecordSetHelper.Open(oCmd, "");
break;
case 12:
case 13: //Sick Leave After scheduled vacation / holiday
oCmd.CommandText = "spReport_SickLeaveUseDetailAfterVACHOL '" + sDate + "' ";
oRec = ADORecordSetHelper.Open(oCmd, "");
break;
case 14:
case 15: //All Staff off Sick...
oCmd.CommandText = "spReport_SickLeaveUseDetail '" + sDate + "' ";
oRec = ADORecordSetHelper.Open(oCmd, "");
break;
default:
return;
}
int CurrRow = 0;
while (!oRec.EOF)
{
CurrRow++;
ViewModel.sprDetail.Row = CurrRow;
ViewModel.sprDetail.Col = 1;
ViewModel.sprDetail.Text = Convert.ToDateTime(oRec["shift_start"]).ToString("M/d/yyyy HH:mm");
ViewModel.sprDetail.Col = 2;
ViewModel.sprDetail.Text = modGlobal.Clean(oRec["name_full"]);
ViewModel.sprDetail.Col = 3;
ViewModel.sprDetail.Text = modGlobal.Clean(oRec["CreatedBy"]);
ViewModel.sprDetail.Col = 4;
ViewModel.sprDetail.Text = Convert.ToDateTime(oRec["leave_create"]).ToString("M/d/yyyy HH:mm:ss");
ViewModel.sprDetail.Col = 5;
ViewModel.sprDetail.Text = modGlobal.Clean(oRec["KOT"]);
ViewModel.sprDetail.Col = 6;
ViewModel.sprDetail.Text = modGlobal.Clean(oRec["note"]);
oRec.MoveNext();
}
;
}
private void sprPositions_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
PTSProject.clsScheduler cTransfer = Container.Resolve <clsScheduler>();
if (ViewModel.CurrPosRow != 0)
{
ViewModel.sprPositions.Row = ViewModel.CurrPosRow;
int tempForVar = ViewModel.sprPositions.MaxCols;
for (int i = 1; i <= tempForVar; i++)
{
ViewModel.sprPositions.Col = i;
ViewModel.sprPositions.BackColor = modGlobal.Shared.WHITE;
}
}
if (Row == 0)
{
return;
}
ViewModel.lbPosition.Text = "";
ViewModel.CurrPosition = 0;
ViewModel.CurrPosRow = Row;
ViewModel.sprPositions.Row = ViewModel.CurrPosRow;
ViewModel.sprPositions.Col = 6;
if (modGlobal.Clean(ViewModel.sprPositions.Text) == "")
{
ViewModel.CurrPosition = 0;
ViewModel.CurrPosRow = 0;
}
else
{
ViewModel.CurrPosition = Convert.ToInt32(Double.Parse(ViewModel.sprPositions.Text));
}
if (ViewModel.CurrPosition == 0)
{
ViewModel.CurrPosRow = 0;
return;
}
if (~cTransfer.GetTransferPositionByID(ViewModel.CurrPosition) != 0)
{
ViewManager.ShowMessage("Oooops! Can't find Position Record... Try Again!", "Get Position Record", UpgradeHelpers.Helpers.BoxButtons.OK);
ViewModel.CurrPosition = 0;
ViewModel.CurrPosRow = 0;
return;
}
ViewModel.sprPositions.Col = 1;
string sText = modGlobal.Clean(ViewModel.sprPositions.Text);
ViewModel.sprPositions.Col = 2;
sText = sText + modGlobal.Clean(ViewModel.sprPositions.Text);
ViewModel.sprPositions.Col = 3;
sText = sText + " " + modGlobal.Clean(ViewModel.sprPositions.Text);
ViewModel.lbPosition.Text = sText;
if (ViewModel.CurrPosRow != 0)
{
ViewModel.sprPositions.Row = ViewModel.CurrPosRow;
int tempForVar2 = ViewModel.sprPositions.MaxCols;
for (int i = 1; i <= tempForVar2; i++)
{
ViewModel.sprPositions.Col = i;
ViewModel.sprPositions.BackColor = UpgradeHelpers.Helpers.ColorTranslator.FromOle(modGlobal.LT_BLUE);
}
}
EnableButtons();
}
private void sprLaunderGrid_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>();
PTSProject.clsTraining TrainCL = Container.Resolve <clsTraining>();
if (Row == 0)
{
return;
}
ViewModel.iCurrRow = Row;
ViewModel.sprLaunderGrid.Row = ViewModel.iCurrRow;
//ViewModel.sprLaunderGrid.SetSelection(1, ViewModel.iCurrRow, ViewModel.sprLaunderGrid.MaxCols, ViewModel.iCurrRow);
ViewModel.sprLaunderGrid.Col = 4;
if (modGlobal.Clean(ViewModel.sprLaunderGrid.Text) == "")
{
return;
}
else
{
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
ViewModel.lbLaunderID.Text = Convert.ToString(modGlobal.GetVal(ViewModel.sprLaunderGrid.Text));
}
ViewModel.bAllowUpdate = false;
//UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
if (UniformCL.GetUniformLaunderInfoByID(Convert.ToInt32(modGlobal.GetVal(ViewModel.lbLaunderID.Text))) != 0)
{
//continue
}
else
{
ViewManager.ShowMessage("Oooops! No Uniform Laundry/Cleaning ecord was found!", "Get Laundry/Cleaning Record", UpgradeHelpers.Helpers.BoxButtons.OK);
return;
}
ViewModel.lbLaunderID.Text = UniformCL.UniformLaunderID.ToString();
if (UniformCL.UniformLaunderDateFlagged == "")
{
ViewManager.ShowMessage("Ooooops! Something is wrong! Call Debra Lewandowsky x5068.", "Missing Flagged Date!!", UpgradeHelpers.Helpers.BoxButtons.OK);
return;
}
else
{
ViewModel.chkFlagged.CheckState = UpgradeHelpers.Helpers.CheckState.Checked;
ViewModel.dteDateFlagged.Text = UniformCL.UniformLaunderDateFlagged;
ViewModel.dteDateFlagged.Visible = true;
}
if (UniformCL.UniformLaunderDateCleaned == "")
{
ViewModel.chkCleaned.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked;
ViewModel.dteDateCleaned.Visible = false;
ViewModel.chkVendor.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked;
ViewModel.cboFlaggedBy.Visible = true;
ViewModel.bAllowUpdate = true;
}
else
{
ViewModel.chkCleaned.CheckState = UpgradeHelpers.Helpers.CheckState.Checked;
ViewModel.dteDateCleaned.Text = UniformCL.UniformLaunderDateCleaned;
ViewModel.dteDateCleaned.Visible = true;
}
for (int i = 0; i <= ViewModel.cboFlaggedBy.Items.Count - 1; i++)
{
if (ViewModel.cboFlaggedBy.GetListItem(i).Substring(Math.Max(ViewModel.cboFlaggedBy.GetListItem(i).Length - 5, 0)) == UniformCL.UniformLaunderFlaggedBy)
{
ViewModel.cboFlaggedBy.Text = ViewModel.cboFlaggedBy.GetListItem(i);
break;
}
}
if (UniformCL.UniformLaunderVendorCleaned == "N")
{
for (int i = 0; i <= ViewModel.cboCleanedBy.Items.Count - 1; i++)
{
if (ViewModel.cboCleanedBy.GetListItem(i).Substring(Math.Max(ViewModel.cboCleanedBy.GetListItem(i).Length - 5, 0)) == UniformCL.UniformLaunderCleanedBy)
{
ViewModel.cboCleanedBy.Text = ViewModel.cboCleanedBy.GetListItem(i);
break;
}
}
}
else
{
ViewModel.chkVendor.CheckState = UpgradeHelpers.Helpers.CheckState.Checked;
ViewModel.cboCleanedBy.Visible = false;
}
ViewModel.txtComment.Text = UniformCL.UniformLaunderComment;
ViewModel.txtLaundryComment.Text = UniformCL.UniformLaunderCleaningComments;
string sEmployeeName = "";
if (UniformCL.UniformLaunderApprovedBy != "")
{
if (TrainCL.GetEmployee(UniformCL.UniformLaunderApprovedBy) != 0)
{
sEmployeeName = modGlobal.Clean(TrainCL.Employee["name_full"]);
}
}
if (UniformCL.UniformLaunderDateApproved != "")
{
if (sEmployeeName != "")
{
ViewModel.chkApproved.Text = "PPE Item was cleared for use by " + sEmployeeName +
" on " + UniformCL.UniformLaunderDateApproved;
ViewModel.chkApproved.CheckState = UpgradeHelpers.Helpers.CheckState.Checked;
}
else
{
ViewModel.chkApproved.Text = "PPE Item was cleared for use on " + UniformCL.UniformLaunderDateApproved;
ViewModel.chkApproved.CheckState = UpgradeHelpers.Helpers.CheckState.Checked;
}
}
else
{
ViewModel.bAllowUpdate = true;
ViewModel.chkApproved.Text = "PPE Item is ready for Use?";
ViewModel.chkApproved.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked;
}
if (ViewModel.bAllowUpdate)
{
ViewModel.cmdEdit.Enabled = true;
ViewModel.cmdEdit.Text = "Update";
ViewModel.cmdEdit.Tag = "0";
}
else
{
ViewModel.cmdEdit.Enabled = false;
ViewModel.cmdEdit.Text = "Update";
ViewModel.cmdEdit.Tag = "0";
}
}
private void sprDaysOff_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
string sDate = "";
DbCommand oCmd = UpgradeHelpers.DB.AdoFactoryManager.GetFactory().CreateCommand();
ADORecordSetHelper oRec = null;
int iCol = 0;
int iRow = 0;
//clear sprDetail grid
ViewModel.sprDetail.Col = 1;
ViewModel.sprDetail.Col2 = ViewModel.sprDetail.MaxCols;
ViewModel.sprDetail.Row = 1;
ViewModel.sprDetail.Row2 = ViewModel.sprDetail.MaxRows;
ViewModel.sprDetail.BlockMode = true;
ViewModel.sprDetail.Text = "";
ViewModel.sprDetail.BlockMode = false;
//If report headers clicked... then exit
if (Row < 5)
{
return;
}
if (Col == 1 || Col == 2 || Col == 13 || Col == 14)
{
return;
}
ViewModel.sprDaysOff.Col = 2;
ViewModel.sprDaysOff.Row = Row;
if (modGlobal.Clean(ViewModel.sprDaysOff.Text) != "A" && modGlobal.Clean(ViewModel.sprDaysOff.Text)
!= "B" && modGlobal.Clean(ViewModel.sprDaysOff.Text) != "C" && modGlobal.Clean(ViewModel.sprDaysOff.Text) != "D")
{
return;
}
ViewModel.sprDaysOff.Col = 1;
if (!Information.IsDate(ViewModel.sprDaysOff.Text))
{
return;
}
else
{
sDate = DateTime.Parse(ViewModel.sprDaysOff.Text).ToString("M/d/yyyy");
}
iCol = Col;
iRow = Row;
ViewModel.sprDaysOff.Col = iCol;
ViewModel.sprDaysOff.Row = iRow;
if (modGlobal.Clean(ViewModel.sprDaysOff.Text) == "")
{
return;
}
//UPGRADE_WARNING: (1068) GetVal(sprDaysOff.Text) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx
if (Convert.ToDouble(modGlobal.GetVal(ViewModel.sprDaysOff.Text)) == 0)
{
return;
}
oCmd.Connection = modGlobal.oConn;
oCmd.CommandType = CommandType.Text;
switch (iCol)
{
case 3:
case 4: //VAC scheduled same day
oCmd.CommandText = "spSelect_ExtraDaysOffVacationbyDate '" + sDate + "' ";
oRec = ADORecordSetHelper.Open(oCmd, "");
break;
case 5:
case 6: //HOL scheduled same day
oCmd.CommandText = "spSelect_ExtraDaysOffHolidaybyDate '" + sDate + "' ";
oRec = ADORecordSetHelper.Open(oCmd, "");
break;
case 7:
case 8: //Banked VAC scheduled same day
oCmd.CommandText = "spSelect_ExtraDaysOffBankedbyDate '" + sDate + "' ";
oRec = ADORecordSetHelper.Open(oCmd, "");
break;
case 9:
case 10: //Personnel Sched Take Off PTS
oCmd.CommandText = "spSelect_ExtraDaysOffDeleteSchedbyDate '" + sDate + "' ";
oRec = ADORecordSetHelper.Open(oCmd, "");
break;
case 11:
case 12: //Personnel on Spec Assign
oCmd.CommandText = "spSelect_ExtraDaysOffSpecAssignbyDate '" + sDate + "' ";
oRec = ADORecordSetHelper.Open(oCmd, "");
break;
default:
return;
}
int CurrRow = 0;
while (!oRec.EOF)
{
CurrRow++;
ViewModel.sprDetail.Row = CurrRow;
ViewModel.sprDetail.Col = 1;
ViewModel.sprDetail.Text = Convert.ToDateTime(oRec["shift_start"]).ToString("M/d/yyyy HH:mm");
ViewModel.sprDetail.Col = 2;
ViewModel.sprDetail.Text = modGlobal.Clean(oRec["EmployeeName"]);
ViewModel.sprDetail.Col = 3;
ViewModel.sprDetail.Text = modGlobal.Clean(oRec["CreatorName"]);
ViewModel.sprDetail.Col = 4;
if (modGlobal.Clean(oRec["update_date"]) == "")
{
ViewModel.sprDetail.Text = "";
}
else
{
ViewModel.sprDetail.Text = Convert.ToDateTime(oRec["shift_start"]).ToString("M/d/yyyy HH:mm:ss");
}
ViewModel.sprDetail.Col = 5;
ViewModel.sprDetail.Text = modGlobal.Clean(oRec["note"]);
oRec.MoveNext();
}
;
}
