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

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

                if (String.IsNullOrEmpty(sortExpression))
                {
                    sortExpression = HREmployeePhoneBillAdjustmentEntity.FLD_NAME_PhoneBillAdjustmentID + " " + SQLConstants.SORT_ORDER_DESCENDING;
                }

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

                hREmployeePhoneBillAdjustmentEntityList = FCCHREmployeePhoneBillAdjustment.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);

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

            return(hREmployeePhoneBillAdjustmentEntityList ?? new List <HREmployeePhoneBillAdjustmentEntity>());
        }
コード例 #2
0
        private void DeleteAllCurrentData()
        {
            try
            {
                Int64 result = -1;

                String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.FLD_NAME_SalarySessionID, (Int64.Parse(ddlSalarySessionID.SelectedValue)).ToString(), SQLMatchType.Equal);

                HREmployeePhoneBillAdjustmentEntity hREmployeePhoneBillAdjustmentEntity = new HREmployeePhoneBillAdjustmentEntity();


                result = FCCHREmployeePhoneBillAdjustment.GetFacadeCreate().Delete(hREmployeePhoneBillAdjustmentEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);

                if (result == 0)
                {
                    _PhoneBillAdjustmentID = 0;
                    _HREmployeePhoneBillAdjustmentEntity = new HREmployeePhoneBillAdjustmentEntity();
                    PrepareInitialView();

                    MiscUtil.ShowMessage(lblMessage, "Phone Bill Adjustment has been successfully deleted.", true);
                }
                else
                {
                    MiscUtil.ShowMessage(lblMessage, "Failed to delete Phone Bill Adjustment.", true);
                }
            }
            catch (Exception ex)
            {
                MiscUtil.ShowMessage(lblMessage, ex.Message, true);
            }
        }
コード例 #3
0
        public IList <HREmployeePhoneBillAdjustmentEntity> GetData()
        {
            IList <HREmployeePhoneBillAdjustmentEntity> hREmployeePhoneBillAdjustmentEntityList = new List <HREmployeePhoneBillAdjustmentEntity>();

            try
            {
                hREmployeePhoneBillAdjustmentEntityList = FCCHREmployeePhoneBillAdjustment.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);

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

            return(hREmployeePhoneBillAdjustmentEntityList ?? new List <HREmployeePhoneBillAdjustmentEntity>());
        }
コード例 #4
0
        protected void lvHREmployeeAllowanceCustom_Detailed_ItemDataBound(object sender, ListViewItemEventArgs e)
        {
            if (e.Item.ItemType == ListViewItemType.DataItem)
            {
                ListViewDataItem dataItem = (ListViewDataItem)e.Item;

                HREmployee_DetailedEntity ent = new HREmployee_DetailedEntity();

                TextBox txtEmployeeName      = (TextBox)e.Item.FindControl("txtEmployeeName");
                TextBox txtDesignation       = (TextBox)e.Item.FindControl("txtDesignation");
                TextBox txtEmployeeJobTypeID = (TextBox)e.Item.FindControl("txtEmployeeJobTypeID");
                TextBox txtSalaryLevel       = (TextBox)e.Item.FindControl("txtSalaryLevel");
                TextBox txtPhoneBillAmount   = (TextBox)e.Item.FindControl("txtPhoneBillAmount");
                TextBox txtPhoneBillNote     = (TextBox)e.Item.FindControl("txtPhoneBillNote");
                Label   employeeIDlv         = (Label)e.Item.FindControl("employeeIDlv");
                String  remarks    = String.Empty;
                Int64   employeeID = (Int64.Parse(employeeIDlv.Text));



                btnSubmit.Text = "Save";

                #region CurrentEmployeeMonthlyTimeSheetSummaryInfo
                String fe4 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeePhoneBillAdjustmentEntity.FLD_NAME_EmployeeID, employeeID.ToString(), SQLMatchType.Equal);
                String fe5 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeePhoneBillAdjustmentEntity.FLD_NAME_SalarySessionID, (Int64.Parse(ddlSalarySessionID.SelectedValue)).ToString(), SQLMatchType.Equal);
                String fe6 = SqlExpressionBuilder.PrepareFilterExpression(fe4, SQLJoinType.AND, fe5);
                IList <HREmployeePhoneBillAdjustmentEntity> hREmployeePhoneBillAdjustmentEntitylist = FCCHREmployeePhoneBillAdjustment.GetFacadeCreate().GetIL(null, null, String.Empty, fe6, DatabaseOperationType.LoadWithFilterExpression);
                if (hREmployeePhoneBillAdjustmentEntitylist != null && hREmployeePhoneBillAdjustmentEntitylist.Count > 0)
                {
                    txtPhoneBillAmount.Text = hREmployeePhoneBillAdjustmentEntitylist[0].PhoneBillAmount.ToString().Trim();
                    txtPhoneBillNote.Text   = hREmployeePhoneBillAdjustmentEntitylist[0].PhoneBillNote.ToString().Trim();

                    btnSubmit.Text = "Update";
                }

                #endregion
            }
        }
コード例 #5
0
        private void UpdateHREmployeePhoneBillAdjustment()
        {
            try
            {
                IList <ListViewDataItem> list = lvHREmployeeAllowanceCustom_Detailed.Items;

                if (list != null && list.Count > 0)
                {
                    Int32 tempDataItemIndex = 0;

                    foreach (ListViewDataItem lvdi in list)
                    {
                        DataKey currentDataKey = lvHREmployeeAllowanceCustom_Detailed.DataKeys[tempDataItemIndex++];
                        Int64   _employeeID    = (Int64)currentDataKey["EmployeeID"];

                        Boolean isSaveFlag = true;

                        String fe1 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeePhoneBillAdjustmentEntity.FLD_NAME_EmployeeID, _employeeID.ToString(), SQLMatchType.Equal);
                        String fe2 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeePhoneBillAdjustmentEntity.FLD_NAME_SalarySessionID, ddlSalarySessionID.SelectedValue.ToString(), SQLMatchType.Equal);
                        String fe  = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);

                        IList <HREmployeePhoneBillAdjustmentEntity> lstHREmployeePhoneBillAdjustment = FCCHREmployeePhoneBillAdjustment.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);

                        if (lstHREmployeePhoneBillAdjustment != null && lstHREmployeePhoneBillAdjustment.Count > 0)
                        {
                            isSaveFlag = false;
                        }


                        //String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.em)
                        HREmployee_DetailedEntity employeeEntity = GetHREmployeeInfo(_employeeID);

                        TextBox txtEmployeeName      = (TextBox)lvdi.FindControl("txtEmployeeName");
                        TextBox txtDesignation       = (TextBox)lvdi.FindControl("txtDesignation");
                        TextBox txtEmployeeJobTypeID = (TextBox)lvdi.FindControl("txtEmployeeJobTypeID");
                        TextBox txtSalaryLevel       = (TextBox)lvdi.FindControl("txtSalaryLevel");
                        TextBox txtPhoneBillAmount   = (TextBox)lvdi.FindControl("txtPhoneBillAmount");
                        TextBox txtPhoneBillNote     = (TextBox)lvdi.FindControl("txtPhoneBillNote");
                        TextBox txtPhoneAllowance    = (TextBox)lvdi.FindControl("txtPhoneAllowance");
                        String  remarks = String.Empty;

                        Decimal a = 0;
                        a = Decimal.Parse(txtPhoneBillAmount.Text) - Decimal.Parse(txtPhoneAllowance.Text);
                        if (a <= 0)
                        {
                            a = 0;
                        }

                        txtPhoneBillNote.Text = "Actual Bill - Phone Ceiling: " + txtPhoneBillAmount.Text + "-" + txtPhoneAllowance.Text + " = " + a + " TK Deducted.";


                        HREmployeePhoneBillAdjustmentEntity hREmployeePhoneBillAdjustmentEntity = new HREmployeePhoneBillAdjustmentEntity();

                        hREmployeePhoneBillAdjustmentEntity.EmployeeID      = employeeEntity.EmployeeID;
                        hREmployeePhoneBillAdjustmentEntity.SalarySessionID = Int64.Parse(ddlSalarySessionID.SelectedValue);
                        hREmployeePhoneBillAdjustmentEntity.PhoneBillAmount = Decimal.Parse(txtPhoneBillAmount.Text);
                        hREmployeePhoneBillAdjustmentEntity.PhoneBillNote   = txtPhoneBillNote.Text;
                        hREmployeePhoneBillAdjustmentEntity.IsRemoved       = false;


                        if (isSaveFlag)
                        {
                            FCCHREmployeePhoneBillAdjustment.GetFacadeCreate().Add(hREmployeePhoneBillAdjustmentEntity, DatabaseOperationType.Add, TransactionRequired.No);
                            MiscUtil.ShowMessage(lblMessage, "Employee phone adjustment Information has been saved successfully.", false);
                        }
                        else
                        {
                            String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HREmployeePhoneBillAdjustmentEntity.FLD_NAME_PhoneBillAdjustmentID, lstHREmployeePhoneBillAdjustment[0].PhoneBillAdjustmentID.ToString(), SQLMatchType.Equal);
                            FCCHREmployeePhoneBillAdjustment.GetFacadeCreate().Update(hREmployeePhoneBillAdjustmentEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
                            MiscUtil.ShowMessage(lblMessage, "Employee phone adjustment Information has been updated successfully.", false);
                        }


                        BindList();
                        //PrepareInitialView();
                    }
                }
            }
            catch (Exception ex)
            {
                MiscUtil.ShowMessage(lblMessage, "Failed to Employee Monthly Time Sheet Summary Information.", true);
            }
        }
コード例 #6
0
        private void BuildHREmployeePhoneBillAdjustment()
        {
            try
            {
                IList <ListViewDataItem> list = lvHREmployeeAllowanceCustom_Detailed.Items;

                if (list != null && list.Count > 0)
                {
                    foreach (ListViewDataItem lvdi in list)
                    {
                        TextBox txtEmployeeName      = (TextBox)lvdi.FindControl("txtEmployeeName");
                        TextBox txtDesignation       = (TextBox)lvdi.FindControl("txtDesignation");
                        TextBox txtEmployeeJobTypeID = (TextBox)lvdi.FindControl("txtEmployeeJobTypeID");
                        TextBox txtSalaryLevel       = (TextBox)lvdi.FindControl("txtSalaryLevel");
                        TextBox txtPhoneBillAmount   = (TextBox)lvdi.FindControl("txtPhoneBillAmount");
                        TextBox txtPhoneBillNote     = (TextBox)lvdi.FindControl("txtPhoneBillNote");
                        Label   employeeIDlv         = (Label)lvdi.FindControl("employeeIDlv");
                        String  remarks    = String.Empty;
                        Int64   employeeID = (Int64.Parse(employeeIDlv.Text));

                        txtPhoneBillNote.Text   = String.Empty;
                        txtPhoneBillAmount.Text = String.Empty;

                        btnSubmit.Text = "Save";

                        #region CurrentEmployeeMonthlyTimeSheetSummaryInfo
                        String fe4 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeePhoneBillAdjustmentEntity.FLD_NAME_EmployeeID, employeeID.ToString(), SQLMatchType.Equal);
                        String fe5 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeePhoneBillAdjustmentEntity.FLD_NAME_SalarySessionID, (Int64.Parse(ddlSalarySessionID.SelectedValue)).ToString(), SQLMatchType.Equal);
                        String fe6 = SqlExpressionBuilder.PrepareFilterExpression(fe4, SQLJoinType.AND, fe5);
                        IList <HREmployeePhoneBillAdjustmentEntity> hREmployeePhoneBillAdjustmentEntitylist = FCCHREmployeePhoneBillAdjustment.GetFacadeCreate().GetIL(null, null, String.Empty, fe6, DatabaseOperationType.LoadWithFilterExpression);
                        if (hREmployeePhoneBillAdjustmentEntitylist != null && hREmployeePhoneBillAdjustmentEntitylist.Count > 0)
                        {
                            txtPhoneBillAmount.Text = hREmployeePhoneBillAdjustmentEntitylist[0].PhoneBillAmount.ToString().Trim();
                            txtPhoneBillNote.Text   = hREmployeePhoneBillAdjustmentEntitylist[0].PhoneBillNote.ToString().Trim();

                            btnSubmit.Text = "Update";
                        }

                        #endregion
                    }
                }
            }
            catch (Exception ex)
            {
                MiscUtil.ShowMessage(lblMessage, "Failed to Employee Monthly Time Sheet Summary Information.", true);
            }
        }