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";
}
}