public IList <HREmployeeSalaryInfoEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <HREmployeeSalaryInfoEntity> hREmployeeSalaryInfoEntityList = new List <HREmployeeSalaryInfoEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = HREmployeeSalaryInfoEntity.FLD_NAME_EmployeeSalaryInfoID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; hREmployeeSalaryInfoEntityList = FCCHREmployeeSalaryInfo.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (hREmployeeSalaryInfoEntityList != null && hREmployeeSalaryInfoEntityList.Count > 0) { totalRowCount = hREmployeeSalaryInfoEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(hREmployeeSalaryInfoEntityList ?? new List <HREmployeeSalaryInfoEntity>()); }
private void SaveHREmployeeSalaryInfoEntity() { if (IsValid) { try { HREmployeeSalaryInfoEntity hREmployeeSalaryInfoEntity = BuildHREmployeeSalaryInfoEntity(); Int64 result = -1; if (hREmployeeSalaryInfoEntity.IsNew) { result = FCCHREmployeeSalaryInfo.GetFacadeCreate().Add(hREmployeeSalaryInfoEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeSalaryInfoEntity.FLD_NAME_EmployeeSalaryInfoID, hREmployeeSalaryInfoEntity.EmployeeSalaryInfoID.ToString(), SQLMatchType.Equal); result = FCCHREmployeeSalaryInfo.GetFacadeCreate().Update(hREmployeeSalaryInfoEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _EmployeeSalaryInfoID = 0; _HREmployeeSalaryInfoEntity = new HREmployeeSalaryInfoEntity(); PrepareInitialView(); BindHREmployeeSalaryInfoList(); if (hREmployeeSalaryInfoEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Employee Salary Info Information has been added successfully.", false); //String NavigationUrl = UrlHelper.BuildSecureUrl("~/HR/HREmployeeSalaryBreakDown.aspx", string.Empty, UrlConstants.OVERVIEW_HR_EMPLOYEE_SALARY_INFO_ID, result.ToString()).ToString(); //Response.Redirect(NavigationUrl); } else { MiscUtil.ShowMessage(lblMessage, "Employee Salary Info Information has been updated successfully.", false); //String NavigationUrl = UrlHelper.BuildSecureUrl("~/HR/HREmployeeSalaryBreakDown.aspx", string.Empty, UrlConstants.OVERVIEW_HR_EMPLOYEE_SALARY_INFO_ID, result.ToString()).ToString(); //Response.Redirect(NavigationUrl); } } else { if (hREmployeeSalaryInfoEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Employee Salary Info Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Employee Salary Info Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvHREmployeeSalaryInfo_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 EmployeeSalaryInfoID; Int64.TryParse(e.CommandArgument.ToString(), out EmployeeSalaryInfoID); if (EmployeeSalaryInfoID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _EmployeeSalaryInfoID = EmployeeSalaryInfoID; PrepareEditView(); } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeSalaryInfoEntity.FLD_NAME_EmployeeSalaryInfoID, EmployeeSalaryInfoID.ToString(), SQLMatchType.Equal); HREmployeeSalaryInfoEntity hREmployeeSalaryInfoEntity = new HREmployeeSalaryInfoEntity(); result = FCCHREmployeeSalaryInfo.GetFacadeCreate().Delete(hREmployeeSalaryInfoEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _EmployeeSalaryInfoID = 0; _HREmployeeSalaryInfoEntity = new HREmployeeSalaryInfoEntity(); PrepareInitialView(); BindHREmployeeSalaryInfoList(); MiscUtil.ShowMessage(lblMessage, "Employee Salary Info has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Employee Salary Info.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
public IList <HREmployeeSalaryInfoEntity> GetData() { IList <HREmployeeSalaryInfoEntity> hREmployeeSalaryInfoEntityList = new List <HREmployeeSalaryInfoEntity>(); try { hREmployeeSalaryInfoEntityList = FCCHREmployeeSalaryInfo.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (hREmployeeSalaryInfoEntityList != null && hREmployeeSalaryInfoEntityList.Count > 0) { totalRowCount = hREmployeeSalaryInfoEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(hREmployeeSalaryInfoEntityList ?? new List <HREmployeeSalaryInfoEntity>()); }