public IList <PRMBOQTemplateItemMapEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <PRMBOQTemplateItemMapEntity> pRMBOQTemplateItemMapEntityList = new List <PRMBOQTemplateItemMapEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = PRMBOQTemplateItemMapEntity.FLD_NAME_BOQTemplateItemMapID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; pRMBOQTemplateItemMapEntityList = FCCPRMBOQTemplateItemMap.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (pRMBOQTemplateItemMapEntityList != null && pRMBOQTemplateItemMapEntityList.Count > 0) { totalRowCount = pRMBOQTemplateItemMapEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(pRMBOQTemplateItemMapEntityList ?? new List <PRMBOQTemplateItemMapEntity>()); }
protected void ddlBOQTemplateID_SelectedIndexChanged(object sender, EventArgs e) { Int64 bOQTemplateID = 0; Int64.TryParse(ddlBOQTemplateID.SelectedValue, out bOQTemplateID); // getting selected Item for template if (bOQTemplateID > 0) { populatedItems = new List <PRMBOQDetailEntity>(); populatedCheckedItems = new List <PRMBOQDetailEntity>(); currentlyCheckedItems = new List <PRMBOQDetailEntity>(); IList <PRMBOQTemplateItemMapEntity> templateItemList = new List <PRMBOQTemplateItemMapEntity>(); String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQTemplateItemMapEntity.FLD_NAME_BOQTemplateID, bOQTemplateID.ToString(), SQLMatchType.Equal); templateItemList = FCCPRMBOQTemplateItemMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (templateItemList != null && templateItemList.Count > 0) { foreach (PRMBOQTemplateItemMapEntity ent in templateItemList) { PRMBOQDetailEntity bOQDetail = new PRMBOQDetailEntity(); bOQDetail.ItemID = ent.ItemID; currentlyCheckedItems.Add(bOQDetail); treeItem.ReBuildTree(); } } } }
private void PrepareEditView() { String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQTemplateItemMapEntity.FLD_NAME_BOQTemplateID, BOQTemplateID.ToString(), SQLMatchType.Equal); currentMappedItems = FCCPRMBOQTemplateItemMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (currentMappedItems == null) { currentMappedItems = new List <PRMBOQTemplateItemMapEntity>(); } }
public IList <PRMBOQTemplateItemMapEntity> GetData() { IList <PRMBOQTemplateItemMapEntity> pRMBOQTemplateItemMapEntityList = new List <PRMBOQTemplateItemMapEntity>(); try { pRMBOQTemplateItemMapEntityList = FCCPRMBOQTemplateItemMap.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (pRMBOQTemplateItemMapEntityList != null && pRMBOQTemplateItemMapEntityList.Count > 0) { totalRowCount = pRMBOQTemplateItemMapEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(pRMBOQTemplateItemMapEntityList ?? new List <PRMBOQTemplateItemMapEntity>()); }
private void SavePRMBOQTemplateItemMapEntity() { try { foreach (TreeNode catNode in treeItem.Nodes) { PrepareCurrentlyPopulatedMappedItems(catNode); } foreach (TreeNode tn in treeItem.CheckedNodes) { PRMBOQTemplateItemMapEntity ent = new PRMBOQTemplateItemMapEntity(); ent.ItemID = Int64.Parse(tn.Value.ToString()); ent.BOQTemplateID = BOQTemplateID; newMappedItems.Add(ent); } if (currentMappedItems.Count <= 0) { IList <PRMBOQTemplateItemMapEntity> unCheckedList = currentlyPopulatedMappedItems.Except(newMappedItems, new CustomerComparer()).ToList(); IList <PRMBOQTemplateItemMapEntity> templateItemList = new List <PRMBOQTemplateItemMapEntity>(); foreach (var v in temporaryMappedItems) { PRMBOQTemplateItemMapEntity ent = new PRMBOQTemplateItemMapEntity(); ent.ItemID = v.ItemID; ent.BOQTemplateID = BOQTemplateID; templateItemList.Add(ent); } IList <PRMBOQTemplateItemMapEntity> addCheckedList = templateItemList.Except(unCheckedList, new CustomerComparerAnother()).ToList(); Int64 i = 0; StringBuilder xmlStr = new StringBuilder(); xmlStr.Append("<m>"); String subXmlStr = null; foreach (PRMBOQTemplateItemMapEntity ent in addCheckedList) { i++; subXmlStr = subXmlStr + "<i><a>" + ent.BOQTemplateID + "</a><b>" + ent.ItemID + "</b><c>" + i + "</c></i>"; } xmlStr.Append(subXmlStr.ToString()); xmlStr.Append("</m>"); FCCBulkInsertXML.GetFacadeCreate().GetIL(xmlStr.ToString(), CommonConstants.BOQItemMapTableInfo); } else if (currentMappedItems.Count > 0) { currentlyPopulatedMappedItems = currentlyPopulatedMappedItems.Intersect(currentMappedItems, new CustomerComparer()).ToList(); IList <PRMBOQTemplateItemMapEntity> deleteList = currentlyPopulatedMappedItems.Except(newMappedItems, new CustomerComparer()).ToList(); IList <PRMBOQTemplateItemMapEntity> addNewList = newMappedItems.Except(currentlyPopulatedMappedItems, new CustomerComparer()).ToList(); if (deleteList != null && deleteList.Count > 0) { foreach (PRMBOQTemplateItemMapEntity ent in deleteList) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQTemplateItemMapEntity.FLD_NAME_BOQTemplateID, ent.BOQTemplateID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQTemplateItemMapEntity.FLD_NAME_ItemID, ent.ItemID.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); FCCPRMBOQTemplateItemMap.GetFacadeCreate().Delete(ent, fe, DatabaseOperationType.Delete, TransactionRequired.No); } } if (addNewList != null && addNewList.Count > 0) { foreach (PRMBOQTemplateItemMapEntity ent in addNewList) { FCCPRMBOQTemplateItemMap.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No); } } } MiscUtil.ShowMessage(lblMessage, "Template Project Cost Item Map Updated Successfully.", false); } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, "An Error Occoured.", true); } }