protected void RadScheduler1_TimeSlotCreated(object sender, TimeSlotCreatedEventArgs e) { string holidayDescription = string.Empty; if (DateTime.Compare(e.TimeSlot.Start.Date, DateTime.Now.Date) == 0) { e.TimeSlot.CssClass = "RadSchedulerToday"; } else if (e.TimeSlot.Start.Date.DayOfWeek == DayOfWeek.Sunday) { e.TimeSlot.CssClass = "RadSchedulerHoliday"; } else if (EPublicHoliday.IsHoliday(dbConn, e.TimeSlot.Start.Date)) { e.TimeSlot.CssClass = "RadSchedulerHoliday"; //Label holidayLabel = new Label(); //holidayLabel.Text = holidayDescription; //holidayLabel.ForeColor = System.Drawing.Color.Red; ////holidayLabel.CssClass = "FloatRight"; ////e.TimeSlot.Control.Controls.AddAt(1, holidayLabel); //e.TimeSlot.Control.Controls[0].Controls.AddAt(1, holidayLabel); } else if (EStatutoryHoliday.IsHoliday(dbConn, e.TimeSlot.Start.Date)) { e.TimeSlot.CssClass = "RadSchedulerHoliday"; //Label holidayLabel = new Label(); //holidayLabel.Text = holidayDescription; //holidayLabel.ForeColor = System.Drawing.Color.Red; ////holidayLabel.CssClass = "FloatRight"; ////e.TimeSlot.Control.Controls.AddAt(1, holidayLabel); //e.TimeSlot.Control.Controls[0].Controls.AddAt(1, holidayLabel); } }
protected void RadScheduler1_TimeSlotCreated(object sender, TimeSlotCreatedEventArgs e) { if (DateTime.Compare(e.TimeSlot.Start.Date, DateTime.Now.Date) == 0) { e.TimeSlot.CssClass = "RadSchedulerToday"; } else if (e.TimeSlot.Start.Date.DayOfWeek == DayOfWeek.Sunday) { e.TimeSlot.CssClass = "RadSchedulerHoliday"; } else if (EPublicHoliday.IsHoliday(dbConn, e.TimeSlot.Start.Date)) { e.TimeSlot.CssClass = "RadSchedulerHoliday"; } else if (EStatutoryHoliday.IsHoliday(dbConn, e.TimeSlot.Start.Date)) { e.TimeSlot.CssClass = "RadSchedulerHoliday"; } }
public override CrystalDecisions.CrystalReports.Engine.ReportDocument GenerateReport() { if (EmpIDList.Count > 0) { DataSet ds = new DataSet(); ds.ReadXmlSchema(schemaXSDPath); DataTable empInfoTable = ds.Tables["EmpInfo"]; DataTable attendanceRecordTable = ds.Tables["AttendanceRecord"]; DateTime periodFrom = new DateTime(year, month, 1); DateTime periodTo = new DateTime(year, month, DateTime.DaysInMonth(year, month)); foreach (int EmpID in EmpIDList) { EEmpPersonalInfo empInfo = new EEmpPersonalInfo(); empInfo.EmpID = EmpID; if (EEmpPersonalInfo.db.select(dbConn, empInfo)) { DataRow empRow = empInfoTable.NewRow(); empRow["EmpID"] = EmpID; empRow["EmpNo"] = empInfo.EmpNo; empRow["EmpName"] = empInfo.EmpEngFullName; empRow["PeriodFrom"] = periodFrom; empRow["PeriodTo"] = periodTo; EEmpPositionInfo empPos = AppUtils.GetLastPositionInfo(dbConn, periodTo, EmpID); if (empPos != null) { EAuthorizationWorkFlow workFlow = new EAuthorizationWorkFlow(); workFlow.AuthorizationWorkFlowID = empPos.AuthorizationWorkFlowIDLeaveApp; if (EAuthorizationWorkFlow.db.select(dbConn, workFlow)) { empRow["Section"] = workFlow.AuthorizationWorkFlowDescription; } EWorkHourPattern workHourPattern = new EWorkHourPattern(); workHourPattern.WorkHourPatternID = empPos.WorkHourPatternID; if (EWorkHourPattern.db.select(dbConn, workHourPattern)) { empRow["RosterGroup"] = workHourPattern.WorkHourPatternCode + " - " + workHourPattern.WorkHourPatternDesc; } } empInfoTable.Rows.Add(empRow); } DBFilter attendanceRecordFilter = new DBFilter(); attendanceRecordFilter.add(new Match("EmpID", EmpID)); attendanceRecordFilter.add(new Match("AttendanceRecordDate", ">=", periodFrom)); attendanceRecordFilter.add(new Match("AttendanceRecordDate", "<=", periodTo)); attendanceRecordFilter.add("AttendanceRecordDate", true); ArrayList attendanceRecordList = EAttendanceRecord.db.select(dbConn, attendanceRecordFilter); foreach (EAttendanceRecord attendanceRecord in attendanceRecordList) { DataRow attendanceRecordRow = attendanceRecordTable.NewRow(); attendanceRecordRow["AttendanceRecordID"] = attendanceRecord.AttendanceRecordID; attendanceRecordRow["EmpID"] = attendanceRecord.EmpID; attendanceRecordRow["AttendanceRecordDate"] = attendanceRecord.AttendanceRecordDate; if (attendanceRecord.AttendanceRecordWorkStart.Ticks > 0) { attendanceRecordRow["AttendanceRecordWorkStart"] = attendanceRecord.AttendanceRecordWorkStart; } if (attendanceRecord.AttendanceRecordWorkEnd.Ticks > 0) { attendanceRecordRow["AttendanceRecordWorkEnd"] = attendanceRecord.AttendanceRecordWorkEnd; } attendanceRecordRow["AttendanceRecordLateMins"] = attendanceRecord.AttendanceRecordActualLateMins; attendanceRecordRow["AttendanceRecordEarlyLeaveMins"] = attendanceRecord.AttendanceRecordActualEarlyLeaveMins; if (attendanceRecord.AttendanceRecordIsAbsent && string.IsNullOrEmpty(attendanceRecord.AttendanceRecordRemark)) { attendanceRecordRow["AttendanceRecordRemark"] = "Absent"; } else { attendanceRecordRow["AttendanceRecordRemark"] = attendanceRecord.AttendanceRecordRemark; } attendanceRecordRow["IsPublicHoliday"] = EPublicHoliday.IsHoliday(dbConn, attendanceRecord.AttendanceRecordDate) || attendanceRecord.AttendanceRecordDate.DayOfWeek == DayOfWeek.Sunday; // Start 0000058, KuangWei, 2014-07-10 attendanceRecordRow["AttendanceRecordOvertimeMins"] = attendanceRecord.AttendanceRecordActualOvertimeMins; // End 0000058, KuangWei, 2014-07-10 attendanceRecordTable.Rows.Add(attendanceRecordRow); } } //System.Data.DataTable table = null; //foreach (int EmpID in EmpList) //{ // string select = "P.*,EmpPos.*,Pos.*,Comp.* "; // string from = "from EmpPersonalInfo P LEFT JOIN EmpPositionInfo EmpPos ON P.EmpID=EmpPos.EmpID AND EmpPos.EmpPosEffTo IS NULL LEFT JOIN Position Pos ON EmpPos.PositionID=Pos.PositionID LEFT JOIN Company Comp ON EmpPos.CompanyID=Comp.CompanyID"; // DBFilter filter = new DBFilter(); // OR or = new OR(); // filter.add(new Match("P.EmpID", EmpID)); // System.Data.DataTable resulttable = filter.loadData(null, select, from); // if (table == null) // table = resulttable; // else // table.Merge(resulttable); //} //DBAESEncryptStringFieldAttribute.decode(table, "EmpHKID", true); //DBAESEncryptStringFieldAttribute.decode(table, "EmpPassportNo", false); //if (reportDocument == null) //{ // reportDocument = new ReportTemplate.Report_Employee_List(); //} //else //{ //} reportDocument.SetDataSource(ds); return(reportDocument); } else { return(null); } }