public IList <MDDesignationEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <MDDesignationEntity> mDDesignationEntityList = new List <MDDesignationEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = MDDesignationEntity.FLD_NAME_DesignationID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; mDDesignationEntityList = FCCMDDesignation.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (mDDesignationEntityList != null && mDDesignationEntityList.Count > 0) { totalRowCount = mDDesignationEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(mDDesignationEntityList ?? new List <MDDesignationEntity>()); }
private void LoadSubCategories(TreeNode parentCategory) { Int64 departmentID = Int64.Parse(parentCategory.Value); String fe = SqlExpressionBuilder.PrepareFilterExpression(MDDesignationEntity.FLD_NAME_DepartmentID, departmentID.ToString(), SQLMatchType.Equal); IList <MDDesignationEntity> childItemCategoryList = FCCMDDesignation.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (childItemCategoryList != null && childItemCategoryList.Count > 0) { foreach (MDDesignationEntity ent in childItemCategoryList) { TreeNode childItemCategory = new TreeNode(); childItemCategory.Text = ent.Name; childItemCategory.Value = ent.DesignationID.ToString(); childItemCategory.SelectAction = TreeNodeSelectAction.Select; if (ShowCheckBoxesInAllNodes == true) { childItemCategory.ShowCheckBox = true; } LoadEmployee(childItemCategory); parentCategory.ChildNodes.Add(childItemCategory); } } }
private void BuildTree() { this.Nodes.Clear(); departmentList = FCCMDDepartment.GetFacadeCreate().GetILFC(); designationList = FCCMDDesignation.GetFacadeCreate().GetILFC(); BayTreeNodeValue rootNodeValue = new BayTreeNodeValue(); rootNodeValue.Value = "0"; rootNodeValue.Attributes["NodeType"] = CustomControlConstants.HRNodeType.RootNode; TreeNode rootNode = new TreeNode(); rootNode.Text = "Designation Tree"; rootNode.Value = rootNodeValue.GetValueString(); rootNode.SelectAction = TreeNodeSelectAction.None; rootNode.Expanded = true; LoadDepartments(rootNode); this.Nodes.Add(rootNode); }
private void SaveMDDesignationEntity() { if (IsValid) { try { MDDesignationEntity mDDesignationEntity = BuildMDDesignationEntity(); Int64 result = -1; if (mDDesignationEntity.IsNew) { result = FCCMDDesignation.GetFacadeCreate().Add(mDDesignationEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(MDDesignationEntity.FLD_NAME_DesignationID, mDDesignationEntity.DesignationID.ToString(), SQLMatchType.Equal); result = FCCMDDesignation.GetFacadeCreate().Update(mDDesignationEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _DesignationID = 0; _MDDesignationEntity = new MDDesignationEntity(); PrepareInitialView(); if (mDDesignationEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Designation Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Designation Information has been updated successfully.", false); } } else { if (mDDesignationEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Designation Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Designation Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvMDDesignation_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 DesignationID; Int64.TryParse(e.CommandArgument.ToString(), out DesignationID); if (DesignationID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _DesignationID = DesignationID; PrepareEditView(); } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(MDDesignationEntity.FLD_NAME_DesignationID, DesignationID.ToString(), SQLMatchType.Equal); MDDesignationEntity mDDesignationEntity = new MDDesignationEntity(); result = FCCMDDesignation.GetFacadeCreate().Delete(mDDesignationEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _DesignationID = 0; _MDDesignationEntity = new MDDesignationEntity(); PrepareInitialView(); MiscUtil.ShowMessage(lblMessage, "Designation has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Designation.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private void DeleteDesignation() { Int64 DesignationID; Int64.TryParse(treeDesignation.SelectedValue, out DesignationID); if (DesignationID > 0) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(MDDesignationEntity.FLD_NAME_DesignationID, DesignationID.ToString(), SQLMatchType.Equal); MDDesignationEntity mDDesignationEntity = new MDDesignationEntity(); result = FCCMDDesignation.GetFacadeCreate().Delete(mDDesignationEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _DesignationID = 0; _MDDesignationEntity = new MDDesignationEntity(); // clearing cache FCCMDDesignation.GetFacadeCreate().RemoveCache(); PrepareInitialView(); LoadTreeView(); MiscUtil.ShowMessage(lblMessage, "Designation has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Designation.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
public IList <MDDesignationEntity> GetData() { IList <MDDesignationEntity> mDDesignationEntityList = new List <MDDesignationEntity>(); try { mDDesignationEntityList = FCCMDDesignation.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (mDDesignationEntityList != null && mDDesignationEntityList.Count > 0) { totalRowCount = mDDesignationEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(mDDesignationEntityList ?? new List <MDDesignationEntity>()); }
private void BuildTree() { this.Nodes.Clear(); departmentList = FCCMDDepartment.GetFacadeCreate().GetILFC(); designationList = FCCMDDesignation.GetFacadeCreate().GetILFC(); employeeList = FCCResourceEmployee_Custom.GetFacadeCreate().GetIL(1000000, 1, String.Empty, String.Empty); TreeNode rootNode = new TreeNode(); rootNode.Text = "Employee Tree"; rootNode.Value = "0"; rootNode.SelectAction = TreeNodeSelectAction.Select; rootNode.Expanded = true; LoadDepartments(rootNode); this.Nodes.Add(rootNode); }