public TimeSheetEntities()
: base()
{
EmployeeTimeSheetsList = new VinaList <HREmployeeTimeSheetsInfo>();
EmployeesList = new List <HREmployeesInfo>();
HRTimeSheetParamsController objTimeSheetParamsController = new HRTimeSheetParamsController();
TimeSheetParams = objTimeSheetParamsController.GetTimeSheetParamsList(string.Empty);
HROTFactorsController otFactorController = new HROTFactorsController();
OTFactors = otFactorController.GetAllEmployeeFactors();
}
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);
}
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);
}
/// <summary>
/// Initialize BandedGridView
/// </summary>
/// <param name="gridView"></param>
/// <returns></returns>
private BandedGridView InitializeBandedGridView(GridView gridView)
{
//Creat a banded grid view
BandedGridView bandedView = new BandedGridView();
GridBand gridBand1 = new GridBand();
GridBand gridBand2 = new GridBand();
GridBand gridBand3 = new GridBand();
bandedView.Bands.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.GridBand[] {
gridBand1,
gridBand2,
gridBand3
});
for (int i = 0; i < gridView.Columns.Count; i++)
{
bandedView.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] {
ConvertToBandedColumn(gridView.Columns[i], false)
});
}
bandedView.GridControl = this;
bandedView.Name = "bandedGridView1";
bandedView.OptionsCustomization.AllowFilter = false;
bandedView.OptionsView.ColumnAutoWidth = false;
bandedView.OptionsView.ShowGroupPanel = false;
//GridBand1
gridBand1.Caption = "Thông tin nhân viên";
gridBand1.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
gridBand1.Name = "gridBand1";
//GridBand2
gridBand2.Caption = "Ngày trong tháng";
gridBand2.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.None;
gridBand2.Name = "gridBand2";
//GridBand3
gridBand3.Caption = "Tổng cộng";
gridBand3.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Right;
gridBand3.Name = "gridBand3";
// Assigning columns to bands
GridColumn column = gridView.Columns["HREmployeeCardNumber"];
if (column != null)
{
BandedGridColumn bandedColumn = ConvertToBandedColumn(column, false);
bandedColumn.OwnerBand = gridBand1;
bandedColumn.Width = 80;
}
column = gridView.Columns["HREmployeeNo"];
if (column != null)
{
ConvertToBandedColumn(column, false).OwnerBand = gridBand1;
}
column = gridView.Columns["HREmployeeName"];
if (column != null)
{
BandedGridColumn bandedColumn = ConvertToBandedColumn(column, false);
bandedColumn.OwnerBand = gridBand1;
bandedColumn.Width = 150;
}
HRTimeSheetParamsController objTimeSheetParamsController = new HRTimeSheetParamsController();
List <HRTimeSheetParamsInfo> commonParams = objTimeSheetParamsController.GetTimeSheetParamsByTimeSheetType(TimeSheetParamType.Common.ToString());
//commonParams.Insert(0, new HRTimeSheetParamsInfo());
for (int i = 1; i <= 31; i++)
{
column = gridView.Columns[String.Format("{0}{1}", "HRLeaveDayDate", i.ToString())];
if (column != null)
{
BandedGridColumn bandedColumn = ConvertToBandedColumn(column, true);
InitColumnRepository(bandedColumn, commonParams);
bandedColumn.OwnerBand = gridBand2;
bandedColumn.Width = 30;
}
}
column = gridView.Columns["TotalLeaveDays"];
if (column != null)
{
ConvertToBandedColumn(column, false).OwnerBand = gridBand3;
}
bandedView.CustomDrawCell += new RowCellCustomDrawEventHandler(BandedView_CustomDrawCell);
bandedView.CellValueChanged += new CellValueChangedEventHandler(BandedView_CellValueChanged);
bandedView.RowClick += new RowClickEventHandler(BandedView_RowClick);
bandedView.OptionsView.ShowAutoFilterRow = true;
return(bandedView);
}
/// <summary>
/// Initialize BandedGridView
/// </summary>
/// <param name="gridView"></param>
/// <returns></returns>
private BandedGridView InitializeBandedGridView(GridView gridView)
{
TimeSheetEntities entity = (TimeSheetEntities)((BaseModuleERP)Screen.Module).CurrentModuleEntity;
HRTimeSheetsInfo objTimeSheetsInfo = (HRTimeSheetsInfo)entity.MainObject;
//Creat a banded grid view
BandedGridView bandedView = new BandedGridView();
GridBand gridBand1 = new GridBand();
GridBand gridBand2 = new GridBand();
GridBand gridBand3 = new GridBand();
bandedView.Bands.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.GridBand[] {
gridBand1,
gridBand2,
gridBand3
});
for (int i = 0; i < gridView.Columns.Count; i++)
{
bandedView.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] {
ConvertToBandedGridColumn(gridView.Columns[i], false)
});
}
bandedView.GridControl = this;
bandedView.Name = "bandedGridView1";
bandedView.OptionsCustomization.AllowFilter = false;
bandedView.OptionsView.ShowAutoFilterRow = true;
bandedView.OptionsView.ColumnAutoWidth = false;
bandedView.OptionsView.ShowGroupPanel = false;
bandedView.OptionsCustomization.AllowSort = true;
bandedView.OptionsView.ShowChildrenInGroupPanel = false;
bandedView.OptionsView.ShowDetailButtons = false;
//GridBand1
gridBand1.Caption = "Thông tin nhân viên";
gridBand1.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
gridBand1.Name = "gridBand1";
//GridBand2
gridBand2.Caption = "Danh sách ngày";
gridBand2.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.None;
gridBand2.Name = "gridBand2";
//GridBand3
gridBand3.Caption = "Quy ra công";
gridBand3.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.None;
gridBand3.Name = "gridBand3";
// Assigning columns to bands
GridColumn column = gridView.Columns["HREmployeeCardNumber"];
if (column != null)
{
CreateNewColumn(column, gridBand1, false);
}
column = gridView.Columns["HREmployeeName"];
if (column != null)
{
CreateNewColumn(column, gridBand1, false);
}
column = gridView.Columns["HRDepartmentRoomName"];
if (column != null)
{
CreateNewColumn(column, gridBand1, false);
}
//int dateStart = objTimeSheetsInfo.HRTimeSheetFromDate.Day;
for (int i = 1; i <= 31; i++)
{
column = gridView.Columns[String.Format("{0}{1}", "HREmployeeTimeSheetDate", i.ToString())];
if (column != null)
{
CreateNewColumn(column, gridBand2, false);
}
}
column = gridView.Columns["HREmployeeTimeSheetWorkingQty"];
if (column != null)
{
CreateNumericColumn(column, gridBand3, false, "n1");
}
if (WorkingShiftList != null)
{
WorkingShiftList.ForEach(o =>
{
column = gridView.Columns["CONG" + o.ADWorkingShiftID.ToString()];
if (column != null)
{
column.Caption = "Công " + o.ADWorkingShiftName;
CreateNumericColumn(column, gridBand3, false, "n5");
}
});
}
HRTimeSheetParamsController objTimeSheetParamsController = new HRTimeSheetParamsController();
List <HRTimeSheetParamsInfo> OTFactorlist = objTimeSheetParamsController.GetDistinctOTTimeSheetParamsList();
foreach (var item in OTFactorlist)
{
column = gridView.Columns[item.HRTimeSheetParamValue2.ToString()];
if (column != null)
{
column.Caption = "TC HS " + item.HRTimeSheetParamValue2.ToString();
CreateNumericColumn(column, gridBand3, false, "n3");
}
}
column = gridView.Columns["HREmployeeTimeSheetOTQty"];
if (column != null)
{
CreateNumericColumn(column, gridBand3, false, "n3");
}
column = gridView.Columns["HREmployeeTimeSheetLeaveQty"];
if (column != null)
{
CreateNumericColumn(column, gridBand3, false, "n1");
}
column = gridView.Columns["HREmployeeTimeSheetNghiLe"];
if (column != null)
{
CreateNumericColumn(column, gridBand3, false, "n1");
}
bandedView.CustomDrawCell += new RowCellCustomDrawEventHandler(BandedView_CustomDrawCell);
bandedView.CellValueChanged += new CellValueChangedEventHandler(BandedView_CellValueChanged);
bandedView.RowClick += new RowClickEventHandler(BandedView_RowClick);
bandedView.KeyUp += new KeyEventHandler(BandedView_KeyUp);
return(bandedView);
}
protected override void AddColumnsToGridView(string strTableName, DevExpress.XtraGrid.Views.Grid.GridView gridView)
{
base.AddColumnsToGridView(strTableName, gridView);
GridColumn column = new GridColumn();
column.Caption = "Mã nhân viên";
column.FieldName = "HREmployeeNo";
gridView.Columns.Add(column);
column = new GridColumn();
column.Caption = "Mã ID";
column.FieldName = "HREmployeeCardNumber";
gridView.Columns.Add(column);
column = new GridColumn();
column.Caption = "Chi nhánh";
column.FieldName = "BRBranchName";
gridView.Columns.Add(column);
column = new GridColumn();
column.Caption = "Bộ phận";
column.FieldName = "HRDepartmentRoomName";
gridView.Columns.Add(column);
column = new GridColumn();
column.Caption = "Phòng ban";
column.FieldName = "HRDepartmentName";
gridView.Columns.Add(column);
column = new GridColumn();
column.Caption = "Tên nhân viên";
column.FieldName = "HREmployeeName";
gridView.Columns.Add(column);
column = new GridColumn();
column.Caption = "Tổ";
column.FieldName = "HRDepartmentRoomGroupItemName";
gridView.Columns.Add(column);
int numDays = ((TimeSheetModule)Screen.Module).NumOfDayInMonth();
TimeSheetEntities entity = (TimeSheetEntities)((BaseModuleERP)Screen.Module).CurrentModuleEntity;
HRTimeSheetsInfo objTimeSheetsInfo = (HRTimeSheetsInfo)entity.MainObject;
for (int i = 1; i <= numDays; i++)
{
GridColumn columnDays = new GridColumn();
DateTime dt = objTimeSheetsInfo.HRTimeSheetFromDate.Date.AddDays(i - 1);
columnDays.Caption = dt.ToString("dd/MM");
bool isDayOfWeek = (VinaApp.IsEndOfWeek(dt.DayOfWeek));
if (isDayOfWeek)
{
columnDays.Caption = "CN (" + dt.ToString("dd/MM") + ")";
}
columnDays.FieldName = String.Format("{0}{1}", "HREmployeeTimeSheetDate", i.ToString());
gridView.Columns.Add(columnDays);
}
HRTimeSheetParamsController objTimeSheetParamsController = new HRTimeSheetParamsController();
List <HRTimeSheetParamsInfo> OTFactorlist = objTimeSheetParamsController.GetDistinctOTTimeSheetParamsList();
foreach (var item in OTFactorlist)
{
column = new GridColumn();
column.Caption = "TC HS " + item.HRTimeSheetParamValue2.ToString();
column.FieldName = item.HRTimeSheetParamValue2.ToString();
column.Tag = item.HRTimeSheetParamValue2;
gridView.Columns.Add(column);
}
if (WorkingShiftList != null)
{
WorkingShiftList.ForEach(o =>
{
column = new GridColumn();
column.Caption = "Công " + o.ADWorkingShiftName;
column.FieldName = "CONG" + o.ADWorkingShiftID.ToString();
column.Tag = "CONG" + o.ADWorkingShiftID.ToString();
gridView.Columns.Add(column);
});
}
}
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();
}
