public IList <CMProjectScheduleTemplateItemMapEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <CMProjectScheduleTemplateItemMapEntity> cMProjectScheduleTemplateItemMapEntityList = new List <CMProjectScheduleTemplateItemMapEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = CMProjectScheduleTemplateItemMapEntity.FLD_NAME_ProjectScheduleTemplateItemMapID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; cMProjectScheduleTemplateItemMapEntityList = FCCCMProjectScheduleTemplateItemMap.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (cMProjectScheduleTemplateItemMapEntityList != null && cMProjectScheduleTemplateItemMapEntityList.Count > 0) { totalRowCount = cMProjectScheduleTemplateItemMapEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(cMProjectScheduleTemplateItemMapEntityList ?? new List <CMProjectScheduleTemplateItemMapEntity>()); }
private void SaveCMProjectScheduleTemplateItemMapEntity() { if (IsValid) { try { CMProjectScheduleTemplateItemMapEntity cMProjectScheduleTemplateItemMapEntity = BuildCMProjectScheduleTemplateItemMapEntity(); Int64 result = -1; if (cMProjectScheduleTemplateItemMapEntity.IsNew) { result = FCCCMProjectScheduleTemplateItemMap.GetFacadeCreate().Add(cMProjectScheduleTemplateItemMapEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CMProjectScheduleTemplateItemMapEntity.FLD_NAME_ProjectScheduleTemplateItemMapID, cMProjectScheduleTemplateItemMapEntity.ProjectScheduleTemplateItemMapID.ToString(), SQLMatchType.Equal); result = FCCCMProjectScheduleTemplateItemMap.GetFacadeCreate().Update(cMProjectScheduleTemplateItemMapEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { //_ProjectScheduleTemplateItemMapID = 0; //_CMProjectScheduleTemplateItemMapEntity = new List<CMProjectScheduleTemplateItemMapEntity>(); //PrepareInitialViewForm(); //BindCMProjectScheduleTemplateItemMapList(); if (cMProjectScheduleTemplateItemMapEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "C MProject Schedule Template Item Map Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "C MProject Schedule Template Item Map Information has been updated successfully.", false); } } else { if (cMProjectScheduleTemplateItemMapEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add C MProject Schedule Template Item Map Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update C MProject Schedule Template Item Map Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private void UpdateCMProjectScheduleTemplateItemMapEntity() { try { foreach (TreeNode tn in treeProjectSchedule.CheckedNodes) { CMProjectScheduleTemplateItemMapEntity ent = new CMProjectScheduleTemplateItemMapEntity(); ent.ProjectScheduleItemID = Int64.Parse(tn.Value); ent.ProjectScheduleTemplateID = CMProjectScheduleTemplateID; ent.IssuePriorityID = Int32.Parse("1"); newMappedScheduleItems.Add(ent); } IList <CMProjectScheduleTemplateItemMapEntity> deleteList = currentMappedScheduleItem.Except(newMappedScheduleItems, new CustomerComparer()).ToList(); IList <CMProjectScheduleTemplateItemMapEntity> addNewList = newMappedScheduleItems.Except(currentMappedScheduleItem, new CustomerComparer()).ToList(); if (deleteList != null && deleteList.Count > 0) { foreach (CMProjectScheduleTemplateItemMapEntity ent in deleteList) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(CMProjectScheduleTemplateItemMapEntity.FLD_NAME_ProjectScheduleTemplateID, ent.ProjectScheduleTemplateID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(CMProjectScheduleTemplateItemMapEntity.FLD_NAME_ProjectScheduleItemID, ent.ProjectScheduleItemID.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); FCCCMProjectScheduleTemplateItemMap.GetFacadeCreate().Delete(ent, fe, DatabaseOperationType.Delete, TransactionRequired.No); } } if (addNewList != null && addNewList.Count > 0) { foreach (CMProjectScheduleTemplateItemMapEntity ent in addNewList) { if (ent.ProjectScheduleItemID != 0) { FCCCMProjectScheduleTemplateItemMap.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No); } } } MiscUtil.ShowMessage(lblMessage, "Project Schedule Template Item Map Information has been added successfully.", false); } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, "An Error Occoured.", true); } }
public IList <CMProjectScheduleTemplateItemMapEntity> GetData() { IList <CMProjectScheduleTemplateItemMapEntity> cMProjectScheduleTemplateItemMapEntityList = new List <CMProjectScheduleTemplateItemMapEntity>(); try { cMProjectScheduleTemplateItemMapEntityList = FCCCMProjectScheduleTemplateItemMap.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (cMProjectScheduleTemplateItemMapEntityList != null && cMProjectScheduleTemplateItemMapEntityList.Count > 0) { totalRowCount = cMProjectScheduleTemplateItemMapEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(cMProjectScheduleTemplateItemMapEntityList ?? new List <CMProjectScheduleTemplateItemMapEntity>()); }
private void PrepareEditViewForm() { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(CMProjectScheduleTemplateItemMapEntity.FLD_NAME_ProjectScheduleTemplateID, CMProjectScheduleTemplateID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(CMProjectScheduleTemplateItemMapEntity.FLD_NAME_ProjectScheduleItemID, treeProjectSchedule.SelectedValue.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); _CMProjectScheduleTemplateItemMapEntity = FCCCMProjectScheduleTemplateItemMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); #region Setting check to the Schedule Item if (_CMProjectScheduleTemplateItemMapEntity != null && _CMProjectScheduleTemplateItemMapEntity.Count > 0) { CurrentCMProjectScheduleTemplateItemMapEntity = _CMProjectScheduleTemplateItemMapEntity[0]; } else { CurrentCMProjectScheduleTemplateItemMapEntity = new CMProjectScheduleTemplateItemMapEntity(); } #endregion }
private void PrepareEditView() { String fe = SqlExpressionBuilder.PrepareFilterExpression(CMProjectScheduleTemplateItemMapEntity.FLD_NAME_ProjectScheduleTemplateID, CMProjectScheduleTemplateID.ToString(), SQLMatchType.Equal); currentMappedScheduleItem = FCCCMProjectScheduleTemplateItemMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); #region Setting check to the Schedule Item if (currentMappedScheduleItem != null && currentMappedScheduleItem.Count > 0) { foreach (TreeNode tn in treeProjectSchedule.Nodes) { IsDocumentNode(tn); } } else { currentMappedScheduleItem = new List <CMProjectScheduleTemplateItemMapEntity>(); } #endregion }