public void SetEmployeeTimeSheetValue(HREmployeeTimeSheetsInfo objEmployeeTimeSheetsInfo) { HRTimeSheetsInfo timeSheet = (HRTimeSheetsInfo)MainObject; List <string> employeeTimeSheetValueList = new List <string> { string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty }; foreach (HRTimeSheetEntrysInfo timeSheetEntry in objEmployeeTimeSheetsInfo.HRTimeSheetEntrysList) { if (timeSheetEntry.HRTimeSheetEntryDate.Date >= timeSheet.HRTimeSheetFromDate.Date && timeSheetEntry.HRTimeSheetEntryDate.Date <= timeSheet.HRTimeSheetToDate.Date) { int index = (int)(timeSheetEntry.HRTimeSheetEntryDate.Date - timeSheet.HRTimeSheetFromDate.Date).TotalDays + 1; string timeSheetParamNo = string.Empty; HRTimeSheetParamsInfo objTimeSheetParamsInfo = TimeSheetParams.Where(t => t.HRTimeSheetParamID == timeSheetEntry.FK_HRTimeSheetParamID).FirstOrDefault(); if (objTimeSheetParamsInfo != null) { timeSheetParamNo = objTimeSheetParamsInfo.HRTimeSheetParamNo; } if (!string.IsNullOrEmpty(timeSheetParamNo)) { if (string.IsNullOrEmpty(employeeTimeSheetValueList[index - 1].Trim())) { employeeTimeSheetValueList[index - 1] = timeSheetParamNo; } else { employeeTimeSheetValueList[index - 1] += String.Format(", {0}", timeSheetParamNo); } } } } VinaDbUtil dbUtil = new VinaDbUtil(); int numDays = ((TimeSheetModule)Module).NumOfDayInMonth(); if (numDays > 31) { numDays = 31; } for (int i = 1; i <= numDays; i++) { String propertyName = String.Format("{0}{1}", "HREmployeeTimeSheetDate", i.ToString()); dbUtil.SetPropertyValue(objEmployeeTimeSheetsInfo, propertyName, employeeTimeSheetValueList[i - 1]); } }
public void SaveLeaveDays(DateTime dateFrom, DateTime dateTo) { VinaDbUtil dbUtil = new VinaDbUtil(); LeaveDayEntities entity = (LeaveDayEntities)CurrentModuleEntity; HRTimeSheetParamsController objTimeSheetParamsController = new HRTimeSheetParamsController(); commonParams = objTimeSheetParamsController.GetTimeSheetParamsByTimeSheetType(TimeSheetParamType.Common.ToString()); HRLeaveDaysController objLeaveDaysController = new HRLeaveDaysController(); foreach (HRLeaveDaysInfo employeeLeaveDay in entity.LeaveDaysList) { //objLeaveDaysController.DeleteByEmployeeIDAndDate(employeeLeaveDay.FK_HREmployeeID, employeeLeaveDay.HRLeaveDayDate); for (int i = 1; i <= 31; i++) { string[] paramNumbers = dbUtil.GetPropertyStringValue(employeeLeaveDay, string.Format("HRLeaveDayDate{0}", i)).Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); if (dateFrom.Date.AddDays(i - 1) <= dateTo.Date) { objLeaveDaysController.DeleteByEmployeeIDAndDate(employeeLeaveDay.FK_HREmployeeID, dateFrom.Date.AddDays(i - 1)); } for (int j = 0; j < paramNumbers.Length; j++) { string paramNo = paramNumbers[j].Trim(); //string paramNo = dbUtil.GetPropertyStringValue(employeeLeaveDay, string.Format("HRLeaveDayDate{0}", i)); if (!string.IsNullOrEmpty(paramNo)) { HRTimeSheetParamsInfo param = commonParams.Where(p => p.HRTimeSheetParamNo == paramNo).FirstOrDefault(); if (param != null) { HRLeaveDaysInfo leaveDay = new HRLeaveDaysInfo(); leaveDay.FK_HREmployeeID = employeeLeaveDay.FK_HREmployeeID; leaveDay.FK_HRTimeSheetParamID = param.HRTimeSheetParamID; //leaveDay.HRLeaveDayDate = new DateTime(employeeLeaveDay.HRLeaveDayDate.Year, employeeLeaveDay.HRLeaveDayDate.Month, i); leaveDay.HRLeaveDayDate = dateFrom.Date.AddDays(i - 1); //objLeaveDaysController.DeleteByEmployeeIDAndDate(employeeLeaveDay.FK_HREmployeeID, leaveDay.HRLeaveDayDate); objLeaveDaysController.CreateObject(leaveDay); } } //else //{ // objLeaveDaysController.DeleteByEmployeeIDAndDate(employeeLeaveDay.FK_HREmployeeID, dteFrom.DateTime.Date.AddDays(i - 1)); //} } } } MessageBox.Show("Lưu thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); }
protected override void GridView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { base.GridView_CellValueChanged(sender, e); GridView gridView = (GridView)MainView; HRTimeSheetParamsInfo objTimeSheetParamsInfo = (HRTimeSheetParamsInfo)gridView.GetRow(gridView.FocusedRowHandle); if (objTimeSheetParamsInfo == null) { return; } if (objTimeSheetParamsInfo.HRTimeSheetParamID == 0 && String.IsNullOrEmpty(objTimeSheetParamsInfo.HRTimeSheetParamType)) { objTimeSheetParamsInfo.HRTimeSheetParamType = TimeSheetParamType.Hour.ToString(); } }
private void gridView_CustomColumnDisplayText(object sender, CustomColumnDisplayTextEventArgs e) { if (e.Column.FieldName == "FK_HRTimeSheetParamID") { if (e.Value != null) { HRTimeSheetParamsController objTimeSheetParamsController = new HRTimeSheetParamsController(); HRTimeSheetParamsInfo objTimeSheetParamsInfo = new HRTimeSheetParamsInfo(); objTimeSheetParamsInfo = (HRTimeSheetParamsInfo)objTimeSheetParamsController.GetObjectByID(Int32.Parse(e.Value.ToString())); if (objTimeSheetParamsInfo != null) { e.DisplayText = objTimeSheetParamsInfo.HRTimeSheetParamNo; } } } }
public void InvalidateData() { ADConfigValuesController objConfigValuesController = new ADConfigValuesController(); DataSet ds = objConfigValuesController.GetADConfigValuesByGroup(ConfigValueGroup.RewardType.ToString()); RewardTypesList.Invalidate(ds); ds = objConfigValuesController.GetADConfigValuesByGroup(ConfigValueGroup.DisciplineType.ToString()); DisciplineTypesList.Invalidate(ds); ADWorkingShiftGroupsController objWorkingShiftGroupsController = new ADWorkingShiftGroupsController(); List <ADWorkingShiftGroupsInfo> wsgList = objWorkingShiftGroupsController.GetAllWorkingShiftGroup(); WorkingShiftGroupsList.Invalidate(wsgList); HRFormAllowancesController objFormAllowancesController = new HRFormAllowancesController(); List <HRFormAllowancesInfo> faList = objFormAllowancesController.GetAllFormAllowances(); FormAllowancesList.Invalidate(faList); ADOTFactorsController objOTFactorsController = new ADOTFactorsController(); List <ADOTFactorsInfo> otfList = objOTFactorsController.GetAllOTFactors(); OTFactorsList.Invalidate(otfList); HRTimesheetEmployeeLateConfigsController objTimesheetEmployeeLateConfigsController = new HRTimesheetEmployeeLateConfigsController(); List <HRTimesheetEmployeeLateConfigsInfo> telcList = objTimesheetEmployeeLateConfigsController.GetAllTimesheetEmployeeLateConfigs(); TimesheetEmployeeLateConfigsList.Invalidate(telcList); ADTimesheetConfigsController objTimesheetConfigsController = new ADTimesheetConfigsController(); ds = objTimesheetConfigsController.GetAllObjects(); TimesheetConfigsList.Invalidate(ds); ADWorkingShiftsController objWorkingShiftsController = new ADWorkingShiftsController(); ds = objWorkingShiftsController.GetAllObjects(); WorkingShiftsList.Invalidate(ds); HRTimeSheetParamsController objTimeSheetParamsController = new HRTimeSheetParamsController(); ds = objTimeSheetParamsController.GetAllObjects(); List <HRTimeSheetParamsInfo> list = new List <HRTimeSheetParamsInfo>(); foreach (DataRow row in ds.Tables[0].Rows) { HRTimeSheetParamsInfo objTimeSheetParamsInfo = new HRTimeSheetParamsInfo(); objTimeSheetParamsInfo = (HRTimeSheetParamsInfo)objTimeSheetParamsController.GetObjectFromDataRow(row); objTimeSheetParamsInfo.HRTimeSheetParamValue2 = objTimeSheetParamsInfo.HRTimeSheetParamValue2 * 100; if (!objTimeSheetParamsInfo.IsOTCalculated) { list.Add(objTimeSheetParamsInfo); } } TimeSheetParamsList.Invalidate(list); List <HRTimeSheetParamsInfo> list2 = new List <HRTimeSheetParamsInfo>(); List <HRTimeSheetParamsInfo> lst = objTimeSheetParamsController.GetOTTimeSheetParamsList(); foreach (HRTimeSheetParamsInfo info in lst) { info.HRTimeSheetParamValue2 = info.HRTimeSheetParamValue2 * 100; list2.Add(info); } TimeSheetParam2sList.Invalidate(list2); }
public void ViewLeaveDays(int branchID, int departmentID, int departmentRoomID, int departmentRoomGroupItemID, int employeeID, DateTime dateFrom, DateTime dateTo, string status) { VinaDbUtil dbUtil = new VinaDbUtil(); HRLeaveDaysController objLeaveDaysController = new HRLeaveDaysController(); HRTimeSheetParamsController objTimeSheetParamsController = new HRTimeSheetParamsController(); List <HRLeaveDaysInfo> leaveDays = objLeaveDaysController.GetLeaveDaysList(branchID, departmentID, departmentRoomID, departmentRoomGroupItemID, employeeID, dateFrom, dateTo); commonParams = objTimeSheetParamsController.GetTimeSheetParamsByTimeSheetType(TimeSheetParamType.Common.ToString()); LeaveDayEntities entity = (LeaveDayEntities)CurrentModuleEntity; entity.LeaveDaysList.Clear(); HREmployeesController objEmployeesController = new HREmployeesController(); List <HREmployeesInfo> employees = new List <HREmployeesInfo>(); if (employeeID == 0) { employees = objEmployeesController.GetEmployeeList(branchID, departmentID, departmentRoomID, departmentRoomGroupItemID, status); } else { HREmployeesInfo employee = (HREmployeesInfo)objEmployeesController.GetObjectByID(employeeID); employees.Add(employee); } int numDays = (int)(dateTo.Date - dateFrom.Date).TotalDays + 1; foreach (HRLeaveDaysInfo leaveDay in leaveDays) { if (!employees.Exists(p => p.HREmployeeID == leaveDay.FK_HREmployeeID)) { continue; } HRLeaveDaysInfo employeeLeaveDay = entity.LeaveDaysList.Where(ld => ld.FK_HREmployeeID == leaveDay.FK_HREmployeeID).FirstOrDefault(); if (employeeLeaveDay == null) { employeeLeaveDay = new HRLeaveDaysInfo(); entity.LeaveDaysList.Add(employeeLeaveDay); } if (employeeLeaveDay != null) { employeeLeaveDay.FK_HREmployeeID = leaveDay.FK_HREmployeeID; employeeLeaveDay.HREmployeeNo = leaveDay.HREmployeeNo; employeeLeaveDay.HREmployeeName = leaveDay.HREmployeeName; employeeLeaveDay.HRLeaveDayDate = dateFrom; employeeLeaveDay.HREmployeeCardNumber = leaveDay.HREmployeeCardNumber; HRTimeSheetParamsInfo param = commonParams.Where(p => p.HRTimeSheetParamID == leaveDay.FK_HRTimeSheetParamID).FirstOrDefault(); for (int i = 1; i <= numDays; i++) { if (param != null) { //dbUtil.SetPropertyValue(employeeLeaveDay, string.Format("HRLeaveDayDate{0}", leaveDay.HRLeaveDayDate.Date.Day), param.HRTimeSheetParamNo); if (dateFrom.Date.AddDays(i - 1) == leaveDay.HRLeaveDayDate.Date) { string paramTemp = dbUtil.GetPropertyStringValue(employeeLeaveDay, string.Format("HRLeaveDayDate{0}", leaveDay.HRLeaveDayDate.Date.Day)); if (string.IsNullOrEmpty(paramTemp)) { dbUtil.SetPropertyValue(employeeLeaveDay, string.Format("HRLeaveDayDate{0}", i), param.HRTimeSheetParamNo); } else { dbUtil.SetPropertyValue(employeeLeaveDay, string.Format("HRLeaveDayDate{0}", i), paramTemp + ", " + param.HRTimeSheetParamNo); } } } } } } foreach (HREmployeesInfo employee in employees) { if (!entity.LeaveDaysList.Exists(ld => ld.FK_HREmployeeID == employee.HREmployeeID)) { HRLeaveDaysInfo leaveDay = new HRLeaveDaysInfo(); leaveDay.FK_HREmployeeID = employee.HREmployeeID; leaveDay.HREmployeeNo = employee.HREmployeeNo; leaveDay.HREmployeeName = employee.HREmployeeName; leaveDay.HRLeaveDayDate = dateFrom; leaveDay.HREmployeeCardNumber = employee.HREmployeeCardNumber; entity.LeaveDaysList.Add(leaveDay); } } foreach (HRLeaveDaysInfo leaveDay in entity.LeaveDaysList) { UpdateTotalLeaveDays(leaveDay); leaveDay.BackupObject = (HRLeaveDaysInfo)leaveDay.Clone(); } HRLeaveDaysGridControl gridControl = entity.LeaveDaysList.GridControl as HRLeaveDaysGridControl; gridControl.ViewDate = dateFrom; gridControl.FromDate = dateFrom; gridControl.ToDate = dateTo; //gridControl.InitializeControl(); foreach (var item in entity.LeaveDaysList) { HREmployeesInfo objEmployeesInfo = (HREmployeesInfo)objEmployeesController.GetObjectByID(item.FK_HREmployeeID); if (objEmployeesInfo != null) { item.HREmployeeCardNumber = objEmployeesInfo.HREmployeeCardNumber; } } gridControl.RefreshDataSource(); }