public IList <MDEmployeeCompetencyLevelEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <MDEmployeeCompetencyLevelEntity> mDEmployeeCompetencyLevelEntityList = new List <MDEmployeeCompetencyLevelEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = MDEmployeeCompetencyLevelEntity.FLD_NAME_EmployeeCompetencyLevelID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; mDEmployeeCompetencyLevelEntityList = FCCMDEmployeeCompetencyLevel.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (mDEmployeeCompetencyLevelEntityList != null && mDEmployeeCompetencyLevelEntityList.Count > 0) { totalRowCount = mDEmployeeCompetencyLevelEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(mDEmployeeCompetencyLevelEntityList ?? new List <MDEmployeeCompetencyLevelEntity>()); }
private void SaveMDEmployeeCompetencyLevelEntity() { if (IsValid) { try { MDEmployeeCompetencyLevelEntity mDEmployeeCompetencyLevelEntity = BuildMDEmployeeCompetencyLevelEntity(); Int64 result = -1; if (mDEmployeeCompetencyLevelEntity.IsNew) { result = FCCMDEmployeeCompetencyLevel.GetFacadeCreate().Add(mDEmployeeCompetencyLevelEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(MDEmployeeCompetencyLevelEntity.FLD_NAME_EmployeeCompetencyLevelID, mDEmployeeCompetencyLevelEntity.EmployeeCompetencyLevelID.ToString(), SQLMatchType.Equal); result = FCCMDEmployeeCompetencyLevel.GetFacadeCreate().Update(mDEmployeeCompetencyLevelEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _EmployeeCompetencyLevelID = 0; _MDEmployeeCompetencyLevelEntity = new MDEmployeeCompetencyLevelEntity(); PrepareInitialView(); BindMDEmployeeCompetencyLevelList(); if (mDEmployeeCompetencyLevelEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Employee Competency Level Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Employee Competency Level Information has been updated successfully.", false); } } else { if (mDEmployeeCompetencyLevelEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Employee Competency Level Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Employee Competency Level Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvMDEmployeeCompetencyLevel_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 EmployeeCompetencyLevelID; Int64.TryParse(e.CommandArgument.ToString(), out EmployeeCompetencyLevelID); if (EmployeeCompetencyLevelID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _EmployeeCompetencyLevelID = EmployeeCompetencyLevelID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(MDEmployeeCompetencyLevelEntity.FLD_NAME_EmployeeCompetencyLevelID, EmployeeCompetencyLevelID.ToString(), SQLMatchType.Equal); MDEmployeeCompetencyLevelEntity mDEmployeeCompetencyLevelEntity = new MDEmployeeCompetencyLevelEntity(); result = FCCMDEmployeeCompetencyLevel.GetFacadeCreate().Delete(mDEmployeeCompetencyLevelEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _EmployeeCompetencyLevelID = 0; _MDEmployeeCompetencyLevelEntity = new MDEmployeeCompetencyLevelEntity(); PrepareInitialView(); BindMDEmployeeCompetencyLevelList(); MiscUtil.ShowMessage(lblMessage, "Employee Competency Level has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Employee Competency Level.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
public IList <MDEmployeeCompetencyLevelEntity> GetData() { IList <MDEmployeeCompetencyLevelEntity> mDEmployeeCompetencyLevelEntityList = new List <MDEmployeeCompetencyLevelEntity>(); try { mDEmployeeCompetencyLevelEntityList = FCCMDEmployeeCompetencyLevel.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (mDEmployeeCompetencyLevelEntityList != null && mDEmployeeCompetencyLevelEntityList.Count > 0) { totalRowCount = mDEmployeeCompetencyLevelEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(mDEmployeeCompetencyLevelEntityList ?? new List <MDEmployeeCompetencyLevelEntity>()); }