public void SetWarningVals(int empID, int weekID, CBScheduleHour.HourTypeEnum hte)
{
miEmployeeID = empID;
miWeekID = weekID;
//miWarnLvl = 0;
switch (hte)
{
case CBScheduleHour.HourTypeEnum.enForecast:
moHrsType = COScheduleHour.ScheduleHourType.enForecast;
break;
default:
moHrsType = COScheduleHour.ScheduleHourType.enPlanned;
break;
}
}
public static COScheduleHour.GridHoursLevel GetEmployeeTimeLevel(int empID, int wkID, COScheduleHour.ScheduleHourType type)
{
CDbScheduleHour dbDt = new CDbScheduleHour();
return(dbDt.GetEmployeeTimeLevel(empID, wkID, type));
}
public COScheduleHour.GridHoursLevel GetEmployeeTimeLevel(int empID, int wkID, COScheduleHour.ScheduleHourType typeH)
{
SqlDataReader dr;
RSLib.CDbConnection cnn;
SqlCommand cmd;
SqlParameter prm;
COScheduleHour.GridHoursLevel ghl;
decimal minHrs, maxReg, maxAll;
decimal pHrs, fHrs;
decimal compHr;
int flagVal;
cnn = new RSLib.CDbConnection();
cmd = new SqlCommand("spScheduleHour_EmployeeWeekTime", cnn.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
prm = cmd.Parameters.Add("@EmployeeID", SqlDbType.Int);
prm.Value = empID;
prm = cmd.Parameters.Add("@WeekID", SqlDbType.Int);
prm.Value = wkID;
dr = cmd.ExecuteReader();
minHrs = 35;
maxReg = 40;
maxAll = 50;
pHrs = 0;
fHrs = 0;
while (dr.Read())
{
minHrs = Convert.ToDecimal(dr["MinHrs"]);
maxReg = Convert.ToDecimal(dr["MaxRegHrs"]);
maxAll = Convert.ToDecimal(dr["MaxAllHrs"]);
pHrs = Convert.ToDecimal(dr["totP"]);
fHrs = Convert.ToDecimal(dr["totF"]);
}
dr.Close();
switch (typeH)
{
case COScheduleHour.ScheduleHourType.enForecast:
compHr = fHrs;
break;
default:
compHr = pHrs;
break;
}
if (compHr < minHrs)
{
flagVal = -1;
}
else if (compHr > maxAll)
{
flagVal = 2;
}
else if (compHr > maxReg)
{
flagVal = 1;
}
else
{
flagVal = 0;
}
ghl = new COScheduleHour.GridHoursLevel();
ghl.EmployeeID = empID;
ghl.WeekID = wkID;
ghl.HrsType = typeH;
ghl.WarnLvl = flagVal;
switch (typeH)
{
case COScheduleHour.ScheduleHourType.enForecast:
ghl.HrsType = COScheduleHour.ScheduleHourType.enForecast;
break;
default:
ghl.HrsType = COScheduleHour.ScheduleHourType.enPlanned;
break;
}
cmd = null;
cnn.CloseConnection();
return(ghl);
}
