コード例 #1
0
        public IList <ACFiscalYearEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression)
        {
            IList <ACFiscalYearEntity> aCFiscalYearEntityList = new List <ACFiscalYearEntity>();

            try
            {
                if (pageSize == -1)
                {
                    pageSize = 1000000000;
                }

                if (String.IsNullOrEmpty(sortExpression))
                {
                    sortExpression = ACFiscalYearEntity.FLD_NAME_FiscalYearID + " " + SQLConstants.SORT_ORDER_DESCENDING;
                }

                startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1;

                aCFiscalYearEntityList = FCCACFiscalYear.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);

                if (aCFiscalYearEntityList != null && aCFiscalYearEntityList.Count > 0)
                {
                    totalRowCount = aCFiscalYearEntityList[0].TotalRowCount;
                }
            }
            catch (Exception ex)
            {
            }

            return(aCFiscalYearEntityList ?? new List <ACFiscalYearEntity>());
        }
コード例 #2
0
        private Int64 GetFiscalYear()
        {
            Int64 fiscalyearID             = 0;
            IList <ACFiscalYearEntity> lst = FCCACFiscalYear.GetFacadeCreate().GetIL(null, null, String.Empty, String.Empty, DatabaseOperationType.Load);
            ACFiscalYearEntity         ent = lst.Where(x => x.IsClosed == false).Single();

            return(fiscalyearID = ent.FiscalYearID);
        }
コード例 #3
0
        private void CalculateLeave()
        {
            if (chbxFilter.Checked)
            {
                HREmployeeEntity            hREmployeeEntity      = FCCHREmployee.GetFacadeCreate().GetByID(Int64.Parse(ddlEmployeeID.SelectedValue));
                ACFiscalYearEntity          aCFiscalYearEntity    = FCCACFiscalYear.GetFacadeCreate().GetByID(Int64.Parse(ddlFiscalYearID.SelectedValue));
                MDLeaveCategoryEntity       mDLeaveCategoryEntity = FCCMDLeaveCategory.GetFacadeCreate().GetByID(Int64.Parse(ddlLeaveCategoryID.SelectedValue));
                IList <MDLeavePolicyEntity> mDLeavePolicyList     = FCCMDLeavePolicy.GetFacadeCreate().GetIL(1000, 1, String.Empty, String.Empty, DatabaseOperationType.Load);
                Decimal leaveInDays = 0;
                if (mDLeavePolicyList.Count > 0 && mDLeavePolicyList != null)
                {
                    mDLeavePolicyList[0] = mDLeavePolicyList.Single(x => (x.LeaveCategoryID == mDLeaveCategoryEntity.LeaveCategoryID && x.FiscalYearID == aCFiscalYearEntity.FiscalYearID && x.EmployeeJobTypeID == hREmployeeEntity.EmployeeJobTypeID));

                    if (mDLeavePolicyList[0].LeaveCategoryID == mDLeaveCategoryEntity.LeaveCategoryID && mDLeavePolicyList[0].FiscalYearID == aCFiscalYearEntity.FiscalYearID)
                    {
                        leaveInDays = mDLeavePolicyList[0].LeaveInDays;
                    }

                    if (hREmployeeEntity.EmployeeJobTypeID == MasterDataConstants.MDEmployeeJobType.FULLTIME && hREmployeeEntity.ConfirmDate <= aCFiscalYearEntity.BeginDate)
                    {
                        txtEarnedDays.Text = leaveInDays.ToString().Trim();;
                    }
                    else if (hREmployeeEntity.EmployeeJobTypeID == MasterDataConstants.MDEmployeeJobType.PARTTIMENOTLESS75PERCENT)
                    {
                        txtEarnedDays.Text = leaveInDays.ToString().Trim();
                    }
                    else if (hREmployeeEntity.EmployeeJobTypeID == MasterDataConstants.MDEmployeeJobType.FULLTIME && hREmployeeEntity.ConfirmDate == null)
                    {
                        txtEarnedDays.Text = "0.0";
                    }
                    else if (hREmployeeEntity.EmployeeJobTypeID == MasterDataConstants.MDEmployeeJobType.PARTTIMENOTLESS50PERCENT)
                    {
                        txtEarnedDays.Text = leaveInDays.ToString().Trim();
                    }
                    else if (hREmployeeEntity.EmployeeJobTypeID == MasterDataConstants.MDEmployeeJobType.FULLTIME && (hREmployeeEntity.ConfirmDate <= aCFiscalYearEntity.BeginDate && hREmployeeEntity.ConfirmDate >= aCFiscalYearEntity.EndDate))
                    {
                        DateTime s = aCFiscalYearEntity.EndDate;
                        DateTime e = (DateTime)hREmployeeEntity.ConfirmDate;

                        Decimal Month = s.Subtract(e).Days / (365 / 12);
                        Month = (leaveInDays / 12) * Month;
                        txtEarnedDays.Text = Month.ToString().Trim();;
                    }
                    else
                    {
                        txtEarnedDays.Text = "0";
                    }
                }
                else
                {
                    MiscUtil.ShowMessage(lblMessage, "There is no policy in this fiscal year and may be not active please insert data in Leave Policy.", false);
                }
            }
            else
            {
                txtEarnedDays.Text = String.Empty;
            }
        }
コード例 #4
0
        private void SaveACFiscalYearEntity()
        {
            if (IsValid)
            {
                try
                {
                    ACFiscalYearEntity aCFiscalYearEntity = BuildACFiscalYearEntity();

                    Int64 result = -1;

                    if (aCFiscalYearEntity.IsNew)
                    {
                        result = FCCACFiscalYear.GetFacadeCreate().Add(aCFiscalYearEntity, DatabaseOperationType.Add, TransactionRequired.No);
                    }
                    else
                    {
                        String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(ACFiscalYearEntity.FLD_NAME_FiscalYearID, aCFiscalYearEntity.FiscalYearID.ToString(), SQLMatchType.Equal);
                        result = FCCACFiscalYear.GetFacadeCreate().Update(aCFiscalYearEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
                    }

                    if (result > 0)
                    {
                        _FiscalYearID       = 0;
                        _ACFiscalYearEntity = new ACFiscalYearEntity();
                        PrepareInitialView();
                        BindACFiscalYearList();

                        if (aCFiscalYearEntity.IsNew)
                        {
                            MiscUtil.ShowMessage(lblMessage, "A CFiscal Year Information has been added successfully.", false);
                        }
                        else
                        {
                            MiscUtil.ShowMessage(lblMessage, "A CFiscal Year Information has been updated successfully.", false);
                        }
                    }
                    else
                    {
                        if (aCFiscalYearEntity.IsNew)
                        {
                            MiscUtil.ShowMessage(lblMessage, "Failed to add A CFiscal Year Information.", false);
                        }
                        else
                        {
                            MiscUtil.ShowMessage(lblMessage, "Failed to update A CFiscal Year Information.", false);
                        }
                    }
                }
                catch (Exception ex)
                {
                    MiscUtil.ShowMessage(lblMessage, ex.Message, true);
                }
            }
        }
コード例 #5
0
        private void BuildBudgetWizard()
        {
            if (ddlFiscalYearID != null && ddlFiscalYearID.Items.Count > 0)
            {
                if (ddlAccountID != null && ddlAccountID.Items.Count > 0 && ddlAccountID.SelectedValue != "$$OPTGROUP$$OPTGROUP$$")
                {
                    String fe1 = SqlExpressionBuilder.PrepareFilterExpression(ACBudgetEntity.FLD_NAME_FiscalYearID, ddlFiscalYearID.SelectedValue.ToString(), SQLMatchType.Equal);
                    String fe2 = SqlExpressionBuilder.PrepareFilterExpression(ACBudgetEntity.FLD_NAME_AccountID, ddlAccountID.SelectedValue.ToString(), SQLMatchType.Equal);

                    String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);

                    IList <ACBudgetEntity> lst = FCCACBudget.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);

                    if (lst != null && lst.Count > 0)
                    {
                        BindList();
                    }
                    else
                    {
                        ACFiscalYearEntity aCFisalYearEntitiy = FCCACFiscalYear.GetFacadeCreate().GetByID(Int64.Parse(ddlFiscalYearID.SelectedValue));

                        if (aCFisalYearEntitiy != null && aCFisalYearEntitiy.FiscalYearID > 0)
                        {
                            DateTime beginDate = aCFisalYearEntitiy.BeginDate;

                            while (beginDate <= aCFisalYearEntitiy.EndDate)
                            {
                                try
                                {
                                    ACBudgetEntity aCBudgetEntity = new ACBudgetEntity();
                                    aCBudgetEntity.FiscalYearID = Int64.Parse(ddlFiscalYearID.SelectedValue);
                                    aCBudgetEntity.AccountID    = Int64.Parse(ddlAccountID.SelectedValue);
                                    aCBudgetEntity.Period       = beginDate;
                                    aCBudgetEntity.Amount       = 0;

                                    FCCACBudget.GetFacadeCreate().Add(aCBudgetEntity, DatabaseOperationType.Add, TransactionRequired.No);

                                    beginDate = beginDate.AddMonths(1);
                                }

                                catch (Exception)
                                {
                                    throw;
                                }
                            }

                            BindList();
                        }
                    }
                    BuildBudgetLabel();
                }
            }
        }
コード例 #6
0
        protected void lvACFiscalYear_ItemCommand(object sender, ListViewCommandEventArgs e)
        {
            Int64 FiscalYearID;

            Int64.TryParse(e.CommandArgument.ToString(), out FiscalYearID);

            if (FiscalYearID > 0)
            {
                if (string.Equals(e.CommandName, "EditItem"))
                {
                    _FiscalYearID = FiscalYearID;

                    PrepareEditView();

                    cpeEditor.Collapsed   = false;
                    cpeEditor.ClientState = "false";
                }
                else if (string.Equals(e.CommandName, "DeleteItem"))
                {
                    try
                    {
                        Int64 result = -1;

                        String fe = SqlExpressionBuilder.PrepareFilterExpression(ACFiscalYearEntity.FLD_NAME_FiscalYearID, FiscalYearID.ToString(), SQLMatchType.Equal);

                        ACFiscalYearEntity aCFiscalYearEntity = new ACFiscalYearEntity();


                        result = FCCACFiscalYear.GetFacadeCreate().Delete(aCFiscalYearEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);

                        if (result == 0)
                        {
                            _FiscalYearID       = 0;
                            _ACFiscalYearEntity = new ACFiscalYearEntity();
                            PrepareInitialView();
                            BindACFiscalYearList();

                            MiscUtil.ShowMessage(lblMessage, "A CFiscal Year has been successfully deleted.", true);
                        }
                        else
                        {
                            MiscUtil.ShowMessage(lblMessage, "Failed to delete A CFiscal Year.", true);
                        }
                    }
                    catch (Exception ex)
                    {
                        MiscUtil.ShowMessage(lblMessage, ex.Message, true);
                    }
                }
            }
        }
コード例 #7
0
        public IList <ACFiscalYearEntity> GetData()
        {
            IList <ACFiscalYearEntity> aCFiscalYearEntityList = new List <ACFiscalYearEntity>();

            try
            {
                aCFiscalYearEntityList = FCCACFiscalYear.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);

                if (aCFiscalYearEntityList != null && aCFiscalYearEntityList.Count > 0)
                {
                    totalRowCount = aCFiscalYearEntityList[0].TotalRowCount;
                }
            }
            catch (Exception ex)
            {
            }

            return(aCFiscalYearEntityList ?? new List <ACFiscalYearEntity>());
        }
コード例 #8
0
        private HREmployeeLeaveApplicationEntity BuildHREmployeeLeaveApplicationEntity()
        {
            HREmployeeLeaveApplicationEntity hREmployeeLeaveApplicationEntity = CurrentHREmployeeLeaveApplicationEntity;


            hREmployeeLeaveApplicationEntity.EmployeeID = OverviewEmployeeID;

            if (txtApplicationDate.Text.Trim().IsNotNullOrEmpty())
            {
                hREmployeeLeaveApplicationEntity.ApplicationDate = DateTime.Parse(txtApplicationDate.Text);
            }

            if (txtRequestStartDate.Text.Trim().IsNotNullOrEmpty())
            {
                hREmployeeLeaveApplicationEntity.RequestStartDate = MiscUtil.ParseToDateTime(txtRequestStartDate.Text);
            }

            if (txtRequestEndDate.Text.Trim().IsNotNullOrEmpty())
            {
                hREmployeeLeaveApplicationEntity.RequestEndDate = MiscUtil.ParseToDateTime(txtRequestEndDate.Text);
            }

            if (!txtTotalLeaveDays.Text.Trim().IsNullOrEmpty())
            {
                hREmployeeLeaveApplicationEntity.TotalLeaveDays = Decimal.Parse(txtTotalLeaveDays.Text.Trim());
            }

            //hREmployeeLeaveApplicationEntity.Description = txtDescription.Text.Trim();
            if (ddlLeavePurpose.Items.Count > 0)
            {
                if (ddlLeavePurpose.SelectedValue == "0")
                {
                    hREmployeeLeaveApplicationEntity.Description = null;
                }
                else
                {
                    hREmployeeLeaveApplicationEntity.Description = ddlLeavePurpose.SelectedValue;
                }
            }

            //hREmployeeLeaveApplicationEntity.LeaveLocation = txtLeaveLocation.Text.Trim();

            if (ddlLeaveLocation.Items.Count > 0)
            {
                if (ddlLeaveLocation.SelectedValue == "0")
                {
                    hREmployeeLeaveApplicationEntity.LeaveLocation = null;
                }
                else
                {
                    hREmployeeLeaveApplicationEntity.LeaveLocation = ddlLeaveLocation.SelectedValue;
                }
            }

            if (ddlBackupEmployeeID.Items.Count > 0)
            {
                if (ddlBackupEmployeeID.SelectedValue == "0")
                {
                    hREmployeeLeaveApplicationEntity.BackupEmployeeID = null;
                }
                else
                {
                    hREmployeeLeaveApplicationEntity.BackupEmployeeID = Int64.Parse(ddlBackupEmployeeID.SelectedValue);
                }
            }

            if (ddlLeaveApplicationApplicationStatusID.Items.Count > 0)
            {
                if (ddlLeaveApplicationApplicationStatusID.SelectedValue == "0")
                {
                }
                else
                {
                    hREmployeeLeaveApplicationEntity.LeaveApplicationApplicationStatusID = Int64.Parse(ddlLeaveApplicationApplicationStatusID.SelectedValue);
                }
            }

            #region Active FiscalYearID

            IList <ACFiscalYearEntity> listACFiscalYear = FCCACFiscalYear.GetFacadeCreate().GetIL(10000, 1, String.Empty, String.Empty, DatabaseOperationType.Load);

            ACFiscalYearEntity aCFiscalYearEntity = listACFiscalYear.Where(x => x.IsClosed == false).Single();
            //if (listACFiscalYear.Count > 0 && listACFiscalYear[0].IsClosed == false)
            if (listACFiscalYear.Count > 0)
            {
                hREmployeeLeaveApplicationEntity.FiscalYearID = aCFiscalYearEntity.FiscalYearID;
            }

            #endregion


            return(hREmployeeLeaveApplicationEntity);
        }