// Service Start
protected override void OnStart(string[] args)
{
try
{
timer.Start();
DownloadThread = new Thread(RunService);
Thread.Sleep(2000);
DownloadThread.Start();
isServiceRunning = true;
_myHelperClass.WriteToLogFile("******************WMS Service Started*************** ");
}
catch (Exception ex)
{
}
}
public void CreateAttendance(DateTime dateTime)
{
using (var ctx = new TAS2013Entities())
{
List <Emp> _emp = new List <Emp>();
_emp = ctx.Emps.Where(aa => aa.Status == true).ToList();
List <Roster> _Roster = new List <Roster>();
_Roster = context.Rosters.Where(aa => aa.RosterDate == dateTime).ToList();
List <RosterDetail> _NewRoster = new List <RosterDetail>();
_NewRoster = context.RosterDetails.Where(aa => aa.RosterDate == dateTime).ToList();
List <LvData> _LvData = new List <LvData>();
_LvData = context.LvDatas.Where(aa => aa.AttDate == dateTime).ToList();
List <LvShort> _lvShort = new List <LvShort>();
_lvShort = context.LvShorts.Where(aa => aa.DutyDate == dateTime).ToList();
List <AttData> _AttData = context.AttDatas.Where(aa => aa.AttDate == dateTime).ToList();
_myHelperClass.WriteToLogFile("**********************Attendance Creating Started: Total Employees are:" + _emp.Count + "*********************");
List <Remark> remarks = new List <Remark>();
remarks = ctx.Remarks.ToList();
foreach (var emp in _emp)
{
string empDate = emp.EmpID + dateTime.ToString("yyMMdd");
if (_AttData.Where(aa => aa.EmpDate == empDate).Count() == 0)
{
try
{
/////////////////////////////////////////////////////
// Mark Everyone Absent while creating Attendance //
/////////////////////////////////////////////////////
//Set DUTYCODE = D, StatusAB = true, and Remarks = [Absent]
AttData att = new AttData();
att.AttDate = dateTime.Date;
att.DutyCode = "D";
att.StatusAB = true;
att.Remarks = "[Absent]";
if (emp.Shift != null)
{
att.DutyTime = emp.Shift.StartTime;
}
else
{
att.DutyTime = new TimeSpan(07, 45, 00);
}
att.EmpID = emp.EmpID;
att.EmpNo = emp.EmpNo;
att.EmpDate = emp.EmpID + dateTime.ToString("yyMMdd");
att.ShifMin = ProcessSupportFunc.CalculateShiftMinutes(emp.Shift, dateTime.DayOfWeek);
//////////////////////////
// Check for Rest Day //
////////////////////////
//Set DutyCode = R, StatusAB=false, StatusDO = true, and Remarks=[DO]
//Check for 1st Day Off of Shift
if (emp.Shift.DaysName.Name == ProcessSupportFunc.ReturnDayOfWeek(dateTime.DayOfWeek))
{
att.DutyCode = "R";
att.StatusAB = false;
att.StatusDO = true;
att.Remarks = "[DO]";
}
//Check for 2nd Day Off of shift
if (emp.Shift.DaysName1.Name == ProcessSupportFunc.ReturnDayOfWeek(dateTime.DayOfWeek))
{
att.DutyCode = "R";
att.StatusAB = false;
att.StatusDO = true;
att.Remarks = "[DO]";
}
//////////////////////////
// Check for Roster //
////////////////////////
//If Roster DutyCode is Rest then change the StatusAB and StatusDO
foreach (var roster in _Roster.Where(aa => aa.EmpDate == att.EmpDate))
{
att.DutyCode = roster.DutyCode.Trim();
if (att.DutyCode == "R")
{
att.StatusAB = false;
att.StatusDO = true;
att.DutyCode = "R";
att.Remarks = "[DO]";
}
att.ShifMin = roster.WorkMin;
att.DutyTime = roster.DutyTime;
}
////New Roster
string empCdate = "Emp" + emp.EmpID.ToString() + dateTime.ToString("yyMMdd");
string sectionCdate = "Section" + emp.SecID.ToString() + dateTime.ToString("yyMMdd");
string crewCdate = "Crew" + emp.CrewID.ToString() + dateTime.ToString("yyMMdd");
string shiftCdate = "Shift" + emp.ShiftID.ToString() + dateTime.ToString("yyMMdd");
if (_NewRoster.Where(aa => aa.CriteriaValueDate == empCdate).Count() > 0)
{
var roster = _NewRoster.FirstOrDefault(aa => aa.CriteriaValueDate == empCdate);
if (roster.WorkMin == 0)
{
att.StatusAB = false;
att.StatusDO = true;
att.Remarks = "[DO]";
att.DutyCode = "R";
att.ShifMin = 0;
}
else
{
att.ShifMin = roster.WorkMin;
att.DutyCode = "D";
att.DutyTime = roster.DutyTime;
}
}
else if (_NewRoster.Where(aa => aa.CriteriaValueDate == sectionCdate).Count() > 0)
{
var roster = _NewRoster.FirstOrDefault(aa => aa.CriteriaValueDate == sectionCdate);
if (roster.WorkMin == 0)
{
att.StatusAB = false;
att.StatusDO = true;
att.Remarks = "[DO]";
att.DutyCode = "R";
att.ShifMin = 0;
}
else
{
att.ShifMin = roster.WorkMin;
att.DutyCode = "D";
att.DutyTime = roster.DutyTime;
}
}
else if (_NewRoster.Where(aa => aa.CriteriaValueDate == crewCdate).Count() > 0)
{
var roster = _NewRoster.FirstOrDefault(aa => aa.CriteriaValueDate == crewCdate);
if (roster.WorkMin == 0)
{
att.StatusAB = false;
att.StatusDO = true;
att.Remarks = "[DO]";
att.DutyCode = "R";
att.ShifMin = 0;
}
else
{
att.ShifMin = roster.WorkMin;
att.DutyCode = "D";
att.DutyTime = roster.DutyTime;
}
}
else if (_NewRoster.Where(aa => aa.CriteriaValueDate == shiftCdate).Count() > 0)
{
var roster = _NewRoster.FirstOrDefault(aa => aa.CriteriaValueDate == shiftCdate);
if (roster.WorkMin == 0)
{
att.StatusAB = false;
att.StatusDO = true;
att.Remarks = "[DO]";
att.DutyCode = "R";
att.ShifMin = 0;
}
else
{
att.ShifMin = roster.WorkMin;
att.DutyCode = "D";
att.DutyTime = roster.DutyTime;
}
}
//////////////////////////
// Check for GZ Day //
////////////////////////
//Set DutyCode = R, StatusAB=false, StatusGZ = true, and Remarks=[GZ]
if (emp.Shift.GZDays == true)
{
foreach (var holiday in context.Holidays)
{
if (context.Holidays.Where(hol => hol.HolDate.Month == att.AttDate.Value.Month && hol.HolDate.Day == att.AttDate.Value.Day).Count() > 0)
{
att.DutyCode = "G";
att.StatusAB = false;
att.StatusGZ = true;
att.Remarks = "[GZ]";
att.ShifMin = 0;
}
}
}
////////////////////////////
// Check for Short Leave//
//////////////////////////
foreach (var sLeave in _lvShort.Where(aa => aa.EmpDate == att.EmpDate))
{
if (_lvShort.Where(lv => lv.EmpDate == att.EmpDate).Count() > 0)
{
att.StatusSL = true;
att.StatusAB = null;
att.DutyCode = "L";
att.Remarks = "[Short Leave]";
}
}
//////////////////////////
// Check for Leave //
////////////////////////
//Set DutyCode = R, StatusAB=false, StatusGZ = true, and Remarks=[GZ]
foreach (var Leave in _LvData)
{
var _Leave = _LvData.Where(lv => lv.EmpDate == att.EmpDate && lv.HalfLeave != true);
if (_Leave.Count() > 0)
{
att.StatusLeave = true;
att.StatusAB = false;
att.DutyCode = "L";
att.StatusDO = false;
if (Leave.LvCode == "A")
{
att.Remarks = "[CL]";
}
else if (Leave.LvCode == "B")
{
att.Remarks = "[AL]";
}
else if (Leave.LvCode == "C")
{
att.Remarks = "[SL]";
}
else
{
att.Remarks = "[" + _Leave.FirstOrDefault().LvType.LvDesc + "]";
}
}
}
/////////////////////////
//Check for Half Leave///
////////////////////////
var _HalfLeave = _LvData.Where(lv => lv.EmpDate == att.EmpDate && lv.HalfLeave == true);
if (_HalfLeave.Count() > 0)
{
att.StatusLeave = true;
att.StatusAB = false;
att.DutyCode = "L";
att.StatusHL = true;
att.StatusDO = false;
if (_HalfLeave.FirstOrDefault().LvCode == "A")
{
att.Remarks = "[H-CL]";
}
else if (_HalfLeave.FirstOrDefault().LvCode == "B")
{
att.Remarks = "[S-AL]";
}
else if (_HalfLeave.FirstOrDefault().LvCode == "C")
{
att.Remarks = "[H-SL]";
}
else
{
att.Remarks = "[Half Leave]";
}
}
ctx.AttDatas.AddObject(att);
ctx.SaveChanges();
}
catch (Exception ex)
{
_myHelperClass.WriteToLogFile("-------Error In Creating Attendance of Employee: " + emp.EmpNo + " ------" + ex.InnerException.Message);
}
}
}
_myHelperClass.WriteToLogFile("****************Creating Attendance Completed*****************");
AttProcess attp = new AttProcess();
attp.ProcessDate = dateTime;
ctx.AttProcesses.AddObject(attp);
ctx.SaveChanges();
////////////////////////////
//Check for Job Card//
//////////////////////////
try
{
ProcessJobCard jc = new ProcessJobCard();
jc.ProcessJobCards(dateTime);
}
catch (Exception ex)
{
_myHelperClass.WriteToLogFile("Error at Create Function Process Job Card " + dateTime.ToString());
}
ctx.Dispose();
}
// reprocess attendance from last 5 days
CreateMissingAttendance ca = new CreateMissingAttendance();
ca.CreatemissingAttendance(dateTime.AddDays(-7), dateTime);
_myHelperClass.WriteToLogFile("Creating Attendance of Date: " + dateTime.ToString());
}
public void BootstrapAttendance(DateTime dateTime, List <Emp> emps)
{
using (var ctx = new TAS2013Entities())
{
List <Roster> _Roster = new List <Roster>();
_Roster = context.Rosters.Where(aa => aa.RosterDate == dateTime).ToList();
List <RosterDetail> _NewRoster = new List <RosterDetail>();
_NewRoster = context.RosterDetails.Where(aa => aa.RosterDate == dateTime).ToList();
List <LvData> _LvData = new List <LvData>();
_LvData = context.LvDatas.Where(aa => aa.AttDate == dateTime).ToList();
List <LvShort> _lvShort = new List <LvShort>();
_lvShort = context.LvShorts.Where(aa => aa.DutyDate == dateTime).ToList();
//List<AttData> _AttData = context.AttDatas.Where(aa => aa.AttDate == dateTime).ToList();
List <AttData> _attData = new List <AttData>();
_attData = ctx.AttDatas.Where(aa => aa.AttDate == dateTime).ToList();
foreach (var emp in emps)
{
string empDate = emp.EmpID + dateTime.ToString("yyMMdd");
if (_attData.Where(aa => aa.EmpDate == empDate).Count() > 0)
{
try
{
/////////////////////////////////////////////////////
// Mark Everyone Absent while creating Attendance //
/////////////////////////////////////////////////////
//Set DUTYCODE = D, StatusAB = true, and Remarks = [Absent]
AttData att = _attData.First(aa => aa.EmpDate == empDate);
//Reset Flags
att.TimeIn = null;
att.TimeOut = null;
att.Tin0 = null;
att.Tout0 = null;
att.Tin1 = null;
att.Tout1 = null;
att.Tin2 = null;
att.Tout2 = null;
att.Tin3 = null;
att.Tout3 = null;
att.Tin4 = null;
att.Tout4 = null;
att.Tin5 = null;
att.Tout5 = null;
att.Tin6 = null;
att.Tout6 = null;
att.Tin7 = null;
att.Tout7 = null;
att.Tin8 = null;
att.Tout8 = null;
att.StatusP = null;
att.StatusDO = null;
att.StatusEO = null;
att.StatusGZ = null;
att.StatusGZOT = null;
att.StatusHD = null;
att.StatusHL = null;
att.StatusIN = null;
att.StatusLeave = null;
att.StatusLI = null;
att.StatusLO = null;
att.StatusMN = null;
att.StatusOD = null;
att.StatusOT = null;
att.StatusSL = null;
att.WorkMin = null;
att.LateIn = null;
att.LateOut = null;
att.OTMin = null;
att.EarlyIn = null;
att.EarlyOut = null;
att.Remarks = null;
att.ShifMin = null;
att.SLMin = null;
att.AttDate = dateTime.Date;
att.DutyCode = "D";
att.StatusAB = true;
att.Remarks = "[Absent]";
if (emp.Shift != null)
{
att.DutyTime = emp.Shift.StartTime;
}
else
{
att.DutyTime = new TimeSpan(07, 45, 00);
}
att.EmpID = emp.EmpID;
att.EmpNo = emp.EmpNo;
att.EmpDate = emp.EmpID + dateTime.ToString("yyMMdd");
att.ShifMin = ProcessSupportFunc.CalculateShiftMinutes(emp.Shift, dateTime.DayOfWeek);
//////////////////////////
// Check for Rest Day //
////////////////////////
//Set DutyCode = R, StatusAB=false, StatusDO = true, and Remarks=[DO]
//Check for 1st Day Off of Shift
if (emp.Shift.DaysName.Name == ProcessSupportFunc.ReturnDayOfWeek(dateTime.DayOfWeek))
{
att.DutyCode = "R";
att.StatusAB = false;
att.StatusDO = true;
att.Remarks = "[DO]";
}
//Check for 2nd Day Off of shift
if (emp.Shift.DaysName1.Name == ProcessSupportFunc.ReturnDayOfWeek(dateTime.DayOfWeek))
{
att.DutyCode = "R";
att.StatusAB = false;
att.StatusDO = true;
att.Remarks = "[DO]";
}
//////////////////////////
// Check for Roster //
////////////////////////
//If Roster DutyCode is Rest then change the StatusAB and StatusDO
foreach (var roster in _Roster.Where(aa => aa.EmpDate == att.EmpDate))
{
att.DutyCode = roster.DutyCode.Trim();
if (att.DutyCode == "R")
{
att.StatusAB = false;
att.StatusDO = true;
att.DutyCode = "R";
att.Remarks = "[DO]";
}
att.ShifMin = roster.WorkMin;
att.DutyTime = roster.DutyTime;
}
////New Roster
string empCdate = "Emp" + emp.EmpID.ToString() + dateTime.ToString("yyMMdd");
string sectionCdate = "Section" + emp.SecID.ToString() + dateTime.ToString("yyMMdd");
string crewCdate = "Crew" + emp.CrewID.ToString() + dateTime.ToString("yyMMdd");
string shiftCdate = "Shift" + emp.ShiftID.ToString() + dateTime.ToString("yyMMdd");
if (_NewRoster.Where(aa => aa.CriteriaValueDate == empCdate).Count() > 0)
{
var roster = _NewRoster.FirstOrDefault(aa => aa.CriteriaValueDate == empCdate);
if (roster.WorkMin == 0)
{
att.StatusAB = false;
att.StatusDO = true;
att.Remarks = "[DO]";
att.DutyCode = "R";
att.ShifMin = 0;
}
else
{
att.ShifMin = roster.WorkMin;
att.DutyCode = "D";
att.DutyTime = roster.DutyTime;
}
}
else if (_NewRoster.Where(aa => aa.CriteriaValueDate == sectionCdate).Count() > 0)
{
var roster = _NewRoster.FirstOrDefault(aa => aa.CriteriaValueDate == sectionCdate);
if (roster.WorkMin == 0)
{
att.StatusAB = false;
att.StatusDO = true;
att.Remarks = "[DO]";
att.DutyCode = "R";
att.ShifMin = 0;
}
else
{
att.ShifMin = roster.WorkMin;
att.DutyCode = "D";
att.DutyTime = roster.DutyTime;
}
}
else if (_NewRoster.Where(aa => aa.CriteriaValueDate == crewCdate).Count() > 0)
{
var roster = _NewRoster.FirstOrDefault(aa => aa.CriteriaValueDate == crewCdate);
if (roster.WorkMin == 0)
{
att.StatusAB = false;
att.StatusDO = true;
att.Remarks = "[DO]";
att.DutyCode = "R";
att.ShifMin = 0;
}
else
{
att.ShifMin = roster.WorkMin;
att.DutyCode = "D";
att.DutyTime = roster.DutyTime;
}
}
else if (_NewRoster.Where(aa => aa.CriteriaValueDate == shiftCdate).Count() > 0)
{
var roster = _NewRoster.FirstOrDefault(aa => aa.CriteriaValueDate == shiftCdate);
if (roster.WorkMin == 0)
{
att.StatusAB = false;
att.StatusDO = true;
att.Remarks = "[DO]";
att.DutyCode = "R";
att.ShifMin = 0;
}
else
{
att.ShifMin = roster.WorkMin;
att.DutyCode = "D";
att.DutyTime = roster.DutyTime;
}
}
//////////////////////////
// Check for GZ Day //
////////////////////////
//Set DutyCode = R, StatusAB=false, StatusGZ = true, and Remarks=[GZ]
if (emp.Shift.GZDays == true)
{
if (context.Holidays.Where(hol => hol.HolDate == dateTime).Count() > 0)
{
att.DutyCode = "G";
att.StatusAB = false;
att.StatusGZ = true;
att.Remarks = "[GZ]";
att.ShifMin = 0;
}
}
////////////////////////////
//TODO Check for Job Card//
//////////////////////////
////////////////////////////
// Check for Short Leave//
//////////////////////////
foreach (var sLeave in _lvShort.Where(aa => aa.EmpDate == att.EmpDate))
{
if (_lvShort.Where(lv => lv.EmpDate == att.EmpDate).Count() > 0)
{
att.StatusSL = true;
att.StatusAB = null;
att.DutyCode = "L";
att.Remarks = "[Short Leave]";
}
}
//////////////////////////
// Check for Leave //
////////////////////////
//Set DutyCode = R, StatusAB=false, StatusGZ = true, and Remarks=[GZ]
foreach (var Leave in _LvData)
{
var _Leave = _LvData.Where(lv => lv.EmpDate == att.EmpDate && lv.HalfLeave != true);
if (_Leave.Count() > 0)
{
att.StatusLeave = true;
att.StatusAB = false;
att.DutyCode = "L";
att.StatusDO = false;
if (Leave.LvCode == "A")
{
att.Remarks = "[CL]";
}
else if (Leave.LvCode == "B")
{
att.Remarks = "[AL]";
}
else if (Leave.LvCode == "C")
{
att.Remarks = "[SL]";
}
else
{
att.Remarks = "[" + _Leave.FirstOrDefault().LvType.LvDesc + "]";
}
}
else
{
att.StatusLeave = false;
}
}
//////////////////////////
//Check for Half Leave///
/////////////////////////
var _HalfLeave = _LvData.Where(lv => lv.EmpDate == att.EmpDate && lv.HalfLeave == true);
if (_HalfLeave.Count() > 0)
{
att.StatusLeave = true;
att.StatusAB = false;
att.DutyCode = "L";
att.StatusHL = true;
att.StatusDO = false;
if (_HalfLeave.FirstOrDefault().LvCode == "A")
{
att.Remarks = "[H-CL]";
}
else if (_HalfLeave.FirstOrDefault().LvCode == "B")
{
att.Remarks = "[S-AL]";
}
else if (_HalfLeave.FirstOrDefault().LvCode == "C")
{
att.Remarks = "[H-SL]";
}
else
{
att.Remarks = "[Half Leave]";
}
}
else
{
att.StatusLeave = false;
}
ctx.SaveChanges();
}
catch (Exception ex)
{
_myHelperClass.WriteToLogFile("-------Error In Creating Attendance of Employee: " + emp.EmpNo + " ------" + ex.InnerException.Message);
}
}
}
ctx.Dispose();
}
}
