public void GetDetail() { //Select Employee Name and Schedule/Leave records for specificed date DbCommand oCmd = UpgradeHelpers.DB.AdoFactoryManager.GetFactory().CreateCommand(); ADORecordSetHelper oRecStep = null; string SQLScript = ""; ViewModel.cmdTrade.Visible = false; ViewModel.cmdTrade.Enabled = false; ViewModel.txtNote.Text = ""; ViewModel.DisplayNotes = false; ViewModel.Empid = modGlobal.Shared.gDetailEmp; ViewModel.StartDate = modGlobal.Shared.gDetailDate; ViewModel.EndDate = DateTime.Parse(ViewModel.StartDate).AddDays(1).ToString("M/d/yyyy"); oCmd.Connection = modGlobal.oConn; oCmd.CommandType = CommandType.Text; oCmd.CommandText = "spReport_Employee '" + ViewModel.Empid + "'"; ADORecordSetHelper oRec = ADORecordSetHelper.Open(oCmd, ""); if (oRec.EOF) { return; } if (!oRec.EOF) { ViewModel.lbEmpName.Text = Convert.ToString(oRec["name_full"]).Trim(); ViewModel.lbDate.Text = ViewModel.StartDate; } else { ViewManager.ShowMessage("Error retrieving Employee Details ", "Schedule Details Error", UpgradeHelpers.Helpers.BoxButtons.OK); return; } //Clear Display for (int i = 0; i <= 7; i++) { ViewModel.chkSCKFlag[i].CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked; ViewModel.cboKOT[i].SelectedIndex = -1; ViewModel.cboAAType[i].SelectedIndex = -1; ViewModel.cboLeave[i].SelectedIndex = -1; ViewModel.cboLeaveAA[i].SelectedIndex = -1; ViewModel.cboJobCode[i].SelectedIndex = -1; ViewModel.cboStep[i].Items.Clear(); ViewModel.txtHours[i].Text = ""; ViewModel.lbUnit[i].Text = ""; ViewModel.lbPosition[i].Text = ""; } ViewModel.StartDate = ViewModel.StartDate + " 7:00AM"; ViewModel.EndDate = ViewModel.EndDate + " 7:00AM"; oCmd.CommandText = "sp_GetIndSchedule '" + ViewModel.Empid + "','" + ViewModel.StartDate + "','" + ViewModel.EndDate + "'"; oRec = ADORecordSetHelper.Open(oCmd, ""); int CurrRow = 0; string TCLine = ""; string NewTCLine = ""; while (!oRec.EOF) { if (modGlobal.Clean(oRec["sched_time"]) == "TRD") { ViewModel.cmdTrade.Visible = true; ViewModel.cmdTrade.Enabled = true; } if (modGlobal.Clean(oRec["leave_time"]) == "TRD") { ViewModel.cmdTrade.Visible = true; ViewModel.cmdTrade.Enabled = true; } NewTCLine = modGlobal.Clean(oRec["sick_leave_flag"]) + modGlobal.Clean(oRec["sched_time"]) + modGlobal.Clean(oRec["leave_time"]) + Convert.ToString(oRec["pay_upgrade"]) + modGlobal.Clean(oRec["job_code"]) + modGlobal.Clean(oRec["step"]) + modGlobal.Clean(oRec["unit_code"]) + modGlobal.Clean(oRec["position_code"]); if (NewTCLine == TCLine) { ViewModel.txtHours[CurrRow - 1].Text = (Conversion.Val(ViewModel.txtHours[CurrRow - 1].Text) + 12).ToString(); } else { //UPGRADE_WARNING: (1068) GetVal(oRec(sick_leave_flag)) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (Convert.ToDouble(modGlobal.GetVal(oRec["sick_leave_flag"])) == 1) { ViewModel.chkSCKFlag[CurrRow].CheckState = UpgradeHelpers.Helpers.CheckState.Checked; } else { ViewModel.chkSCKFlag[CurrRow].CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked; } ViewModel.cboKOT[CurrRow].Text = modGlobal.Clean(oRec["sched_time"]); for (int x = 0; x <= ViewModel.cboKOT[CurrRow].Items.Count - 1; x++) { //UPGRADE_WARNING: (1068) GetVal(oRec(SchedTimeCodeID)) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (ViewModel.cboKOT[CurrRow].GetItemData(x) == Convert.ToDouble(modGlobal.GetVal(oRec["SchedTimeCodeID"]))) { ViewModel.cboKOT[CurrRow].SelectedIndex = x; break; } } //UPGRADE_WARNING: (1049) Use of Null/IsNull() detected. More Information: http://www.vbtonet.com/ewis/ewi1049.aspx if (!Convert.IsDBNull(oRec["leave_time"])) { ViewModel.cboLeave[CurrRow].Text = modGlobal.Clean(oRec["leave_time"]); for (int x = 0; x <= ViewModel.cboLeave[CurrRow].Items.Count - 1; x++) { //UPGRADE_WARNING: (1068) GetVal(oRec(TimeCodeID)) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (ViewModel.cboLeave[CurrRow].GetItemData(x) == Convert.ToDouble(modGlobal.GetVal(oRec["TimeCodeID"]))) { ViewModel.cboLeave[CurrRow].SelectedIndex = x; break; } } } //UPGRADE_WARNING: (1068) GetVal(oRec(pay_upgrade)) of type Variant is being forced to bool. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (Convert.ToBoolean(modGlobal.GetVal(oRec["pay_upgrade"]))) { //UPGRADE_WARNING: (1049) Use of Null/IsNull() detected. More Information: http://www.vbtonet.com/ewis/ewi1049.aspx if (!Convert.IsDBNull(oRec["job_code"])) { ViewModel.cboJobCode[CurrRow].Text = modGlobal.Clean(oRec["job_code"]); ViewModel.cboStep[CurrRow].Text = modGlobal.Clean(oRec["step"]); oCmd.CommandText = "sp_GetSteps '" + Convert.ToString(oRec["job_code"]) + "'"; oRecStep = ADORecordSetHelper.Open(oCmd, ""); UpgradeHelpers.DB.ADO.ADOFieldHelper tempForVar = oRecStep.GetField("no_steps"); for (int i = 1; i <= Convert.ToDouble(tempForVar.Value); i++) { ViewModel.cboStep[CurrRow].AddItem(i.ToString()); } } } ViewModel.txtHours[CurrRow].Text = "12"; ViewModel.lbUnit[CurrRow].Text = modGlobal.Clean(oRec["unit_code"]).Trim(); ViewModel.lbPosition[CurrRow].Text = modGlobal.Clean(oRec["position_code"]).Trim(); CurrRow++; TCLine = NewTCLine; } oRec.MoveNext(); } ; ViewModel.TotalLines = CurrRow; ViewModel.UpdateFlag = 0; ViewModel.lbWarn.Visible = false; if (ViewModel.cboKOT[0].Text != "") { if (modGlobal.Shared.gSecurity == "RO" || modGlobal.Shared.gSecurity == "CPT") { ViewModel.cmdNotes.Visible = false; ViewModel.cmdDeleteNotes.Visible = false; ViewModel.txtNote.Visible = false; ViewModel.DisplayNotes = false; } else { if (modGlobal.Shared.gSecurity == "ADM" || modGlobal.Shared.gSecurity == "PER" || modGlobal.Shared.gSecurity == "BAT" || modGlobal.Shared.gSecurity == "AID") { ViewModel.cmdNotes.Visible = true; ViewModel.cmdNotes.Enabled = true; ViewModel.txtNote.Visible = true; ViewModel.txtNote.Enabled = true; ViewModel.txtNote.BackColor = modGlobal.Shared.WHITE; ViewModel.DisplayNotes = true; } else { ViewModel.txtNote.Visible = true; ViewModel.txtNote.BackColor = modGlobal.Shared.LT_GRAY; ViewModel.txtNote.Enabled = false; ViewModel.cmdNotes.Enabled = false; ViewModel.DisplayNotes = true; } } } else if (ViewModel.cboLeave[0].Text != "") { if (modGlobal.Shared.gSecurity == "RO" || modGlobal.Shared.gSecurity == "CPT") { ViewModel.cmdNotes.Visible = false; ViewModel.cmdDeleteNotes.Visible = false; ViewModel.txtNote.Visible = false; ViewModel.DisplayNotes = false; } else { if (modGlobal.Shared.gSecurity == "ADM" || modGlobal.Shared.gSecurity == "PER" || modGlobal.Shared.gSecurity == "BAT" || modGlobal.Shared.gSecurity == "AID") { ViewModel.cmdNotes.Visible = true; ViewModel.cmdNotes.Enabled = true; ViewModel.txtNote.Visible = true; ViewModel.txtNote.Enabled = true; ViewModel.txtNote.BackColor = modGlobal.Shared.WHITE; ViewModel.DisplayNotes = true; } else { ViewModel.txtNote.Visible = true; ViewModel.txtNote.BackColor = modGlobal.Shared.LT_GRAY; ViewModel.txtNote.Enabled = false; ViewModel.cmdNotes.Enabled = false; ViewModel.DisplayNotes = true; } } } if (ViewModel.DisplayNotes) { SQLScript = "Select * from PersonnelScheduleNotes Where employee_id = '"; SQLScript = SQLScript + ViewModel.Empid + "' and datediff(day,'"; System.DateTime TempDate = DateTime.FromOADate(0); SQLScript = SQLScript + ((DateTime.TryParse(ViewModel.StartDate, out TempDate)) ? TempDate.ToString("MM/dd/yyyy") : ViewModel.StartDate); SQLScript = SQLScript + "',shift_start) >= 0 and datediff(day,'"; System.DateTime TempDate2 = DateTime.FromOADate(0); SQLScript = SQLScript + ((DateTime.TryParse(ViewModel.EndDate, out TempDate2)) ? TempDate2.ToString("MM/dd/yyyy") : ViewModel.EndDate); SQLScript = SQLScript + "',shift_start) < 0"; oCmd.CommandText = SQLScript; oRec = ADORecordSetHelper.Open(oCmd, ""); if (!oRec.EOF) { ViewModel.txtNote.Text = ""; ViewModel.cmdDeleteNotes.Visible = true; while (!oRec.EOF) { ViewModel.txtNote.Text = modGlobal.Clean(ViewModel.txtNote.Text) + modGlobal.Clean(oRec["note"]).Trim() + "; "; oRec.MoveNext(); } ; } } if (ViewModel.txtNote.Text == "") { ViewModel.cmdNotes.Text = "Add Notes"; ViewModel.cmdNotes.Tag = "1"; } }