private void PrepareEditView() { MDItemEntity mDItemEntity = CurrentMDItemEntity; if (!mDItemEntity.IsNew) { #region Item txtItemName.Text = mDItemEntity.ItemName.ToString(); if (ddlUnitID.Items.Count > 0 && mDItemEntity.UnitID != null) { ddlUnitID.SelectedValue = mDItemEntity.UnitID.ToString(); } txtDescription.Text = mDItemEntity.Description.ToString(); chkIsRemoved.Checked = mDItemEntity.IsRemoved; btnSubmit.Text = "Update"; btnAddNew.Visible = true; #endregion #region Item Default MDItemDefaultEntity mDItemDefaultEntity = CurrentMDItemDefaultEntity; if (!mDItemDefaultEntity.IsNew) { if (ddlBrandID.Items.Count > 0 && mDItemDefaultEntity.BrandID != null) { ddlBrandID.SelectedValue = mDItemDefaultEntity.BrandID.ToString(); } BuildSupplierByBrand(); if (ddlSupplierID.Items.Count > 0 && mDItemDefaultEntity.SupplierID != null) { ddlSupplierID.SelectedValue = mDItemDefaultEntity.SupplierID.ToString(); } if (ddlRegionID.Items.Count > 0 && mDItemDefaultEntity.RegionID != null) { ddlRegionID.SelectedValue = mDItemDefaultEntity.RegionID.ToString(); } BuildCountryDropdownByRegion(); if (ddlCountryID.Items.Count > 0 && mDItemDefaultEntity.CountryID != null) { ddlCountryID.SelectedValue = mDItemDefaultEntity.CountryID.ToString(); } } else { PrepareInitialViewItemDefault(); } #endregion #region Item Brand Map if (treeItem.SelectedNode.Depth == 2) { String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMItemBrandMapEntity.FLD_NAME_ItemID, treeItem.SelectedValue.ToString(), SQLMatchType.Equal); IList <PRMItemBrandMapEntity> ItemBrandList = FCCPRMItemBrandMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); _CurrentItemBrandMapList = ItemBrandList; if (ItemBrandList != null && ItemBrandList.Count > 0) { foreach (PRMItemBrandMapEntity ent in ItemBrandList) { foreach (ListItem chbxItem in chbxItemBrand.Items) { if (ent.BrandID.ToString() == chbxItem.Value.ToString()) { chbxItem.Selected = true; break; } } } IList <PRMItemBrandMapEntity> TempitemBrandList = new List <PRMItemBrandMapEntity>(); if (_CurrentItemBrandMapList != null && _CurrentItemBrandMapList.Count > 0) { foreach (MDBrandEntity ent in _CurrentItemBrandList) { PRMItemBrandMapEntity mDItemBrandEntity = new PRMItemBrandMapEntity(); mDItemBrandEntity.BrandID = ent.BrandID; TempitemBrandList.Add(mDItemBrandEntity); } IList <PRMItemBrandMapEntity> uncheckedList = TempitemBrandList.Except(_CurrentItemBrandMapList, new CustomerComparerAnother()).ToList(); if (uncheckedList != null && uncheckedList.Count > 0) { foreach (PRMItemBrandMapEntity ent in uncheckedList) { foreach (ListItem chbxItem in chbxItemBrand.Items) { if (ent.BrandID.ToString() == chbxItem.Value.ToString()) { chbxItem.Selected = false; } } } } } } else { foreach (ListItem chbxItem in chbxItemBrand.Items) { chbxItem.Selected = false; } } } #endregion #region Item Thumb Rule MDItemThumbRuleEntity mDItemThumbRuleEntity = CurrentMDItemThumbRuleEntity; if (!mDItemThumbRuleEntity.IsNew) { txtFloorRuleVariable.Text = mDItemThumbRuleEntity.FloorRuleVariable.ToString(); txtFloorQuantity.Text = mDItemThumbRuleEntity.FloorQuantity.ToString(); txtBasementRuleVariable.Text = mDItemThumbRuleEntity.BasementRuleVariable.ToString(); txtBasementQuantity.Text = mDItemThumbRuleEntity.BasementQuantity.ToString(); txtOverallRuleVariable.Text = mDItemThumbRuleEntity.OverallRuleVariable.ToString(); txtOverallQuantity.Text = mDItemThumbRuleEntity.OverallQuantity.ToString(); } else { PrepareInitialViewItemThumbRule(); } #endregion } }
CRMMDAgreementApprovalStatusEntity ICRMMDAgreementApprovalStatusFacade.GetByID(Int64 iD) { String fe = SqlExpressionBuilder.PrepareFilterExpression(CRMMDAgreementApprovalStatusEntity.FLD_NAME_AgreementApprovalStatusID, iD.ToString(), SQLMatchType.Equal); return(DataAccessFactory.CreateCRMMDAgreementApprovalStatusDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]); }
protected void odsREQRequisition_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = SqlExpressionBuilder.PrepareFilterExpression("REQRequisition." + REQRequisitionEntity.FLD_NAME_ProjectID, MasterDataConstants.Project.DEFAULT_PROJECT.ToString(), SQLMatchType.Equal); e.InputParameters["filterExpression"] = fe; }
protected void odsCMProjectMilestone_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = SqlExpressionBuilder.PrepareFilterExpression("CMProjectMilestone." + CMProjectMilestoneEntity.FLD_NAME_ProjectID, this.OverviewProjectID.ToString(), SQLMatchType.Equal); e.InputParameters["filterExpression"] = fe; }
private void BuildLabel() { DateTime asAt = MiscUtil.ParseToDateTime(txtAsAt.Text.ToString()); String fe = SqlExpressionBuilder.PrepareFilterExpression(ACJournalEntity.FLD_NAME_ClassTypeID, MasterDataConstants.ACClassType.ASSETS.ToString(), SQLMatchType.Equal); String fe_date = ACJournalEntity.FLD_NAME_TransactionDateTime + " <= '" + asAt.ToString() + "'"; String fe_fiscalYear = SqlExpressionBuilder.PrepareFilterExpression(ACJournalEntity.FLD_NAME_FiscalYearID, ddlFiscalYearID.SelectedValue.ToString(), SQLMatchType.Equal); String fe_common = SqlExpressionBuilder.PrepareFilterExpression(fe_fiscalYear, SQLJoinType.AND, fe_date); fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe_date); IList <ACJournalEntity> lstAsset = FCCACJournal.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); Decimal totalAsset = 0, totalLiabilities; if (lstAsset != null && lstAsset.Count > 0) { Decimal tempDebit, tempCredit; var resultDebit = (from s in lstAsset where s.MDDebitCreditID == MasterDataConstants.MDDebitCredit.DEBIT select s.Amount).Sum(val => val); var resultCredit = (from s in lstAsset where s.MDDebitCreditID == MasterDataConstants.MDDebitCredit.CREDIT select s.Amount).Sum(val => val); tempDebit = resultDebit; tempCredit = resultCredit; totalAsset = tempDebit - tempCredit; lblTotalAsset.Text = Math.Round(totalAsset, 2).ToString(); } else { totalAsset = 0; lblTotalAsset.Text = Math.Round(totalAsset, 2).ToString(); } String fe_liabilities = SqlExpressionBuilder.PrepareFilterExpression(ACJournalEntity.FLD_NAME_ClassTypeID, MasterDataConstants.ACClassType.LIABILITIES.ToString(), SQLMatchType.Equal); fe_liabilities = SqlExpressionBuilder.PrepareFilterExpression(fe_liabilities, SQLJoinType.AND, fe_common); IList <ACJournalEntity> lstliabilities = FCCACJournal.GetFacadeCreate().GetIL(null, null, String.Empty, fe_liabilities, DatabaseOperationType.LoadWithFilterExpression); if (lstliabilities != null && lstliabilities.Count > 0) { Decimal tempDebit, tempCredit; var resultDebit = (from s in lstliabilities where s.MDDebitCreditID == MasterDataConstants.MDDebitCredit.DEBIT select s.Amount).Sum(val => val); var resultCredit = (from s in lstliabilities where s.MDDebitCreditID == MasterDataConstants.MDDebitCredit.CREDIT select s.Amount).Sum(val => val); tempDebit = resultDebit; tempCredit = resultCredit; totalLiabilities = tempDebit - tempCredit; lblTotalLiabilities.Text = Math.Round(totalLiabilities, 2).ToString(); lblTotalReturn.Text = Math.Round((totalAsset - totalLiabilities), 2).ToString(); } else { totalLiabilities = 0; lblTotalLiabilities.Text = Math.Round(totalLiabilities, 2).ToString(); } }
CMContractorEntity ICMContractorFacade.GetByID(Int64 iD) { String fe = SqlExpressionBuilder.PrepareFilterExpression(CMContractorEntity.FLD_NAME_ContractorID, iD.ToString(), SQLMatchType.Equal); return(DataAccessFactory.CreateCMContractorDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]); }
protected void lvCMConsultant_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 ConsultantID; Int64.TryParse(e.CommandArgument.ToString(), out ConsultantID); if (ConsultantID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _ConsultantID = ConsultantID; _MemberID = CurrentCMConsultantEntity.MemberID.Value; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { CMConsultantEntity tempConsultant = FCCCMConsultant.GetFacadeCreate().GetByID(ConsultantID); #region Resource Delete Int64 resultOne = -1; String fe1_re = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ReferenceID, ConsultantID.ToString(), SQLMatchType.Equal); String fe2_re = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ResourceCategoryID, MasterDataConstants.ResourceCategory.CONSULTANT.ToString(), SQLMatchType.Equal); String fe_re = SqlExpressionBuilder.PrepareFilterExpression(fe1_re, SQLJoinType.AND, fe2_re); IList <ResourceEntity> resourceList = FCCResource.GetFacadeCreate().GetIL(null, null, String.Empty, fe_re, DatabaseOperationType.LoadWithFilterExpression); foreach (ResourceEntity ent in resourceList) { String fe_re_delete = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ResourceID, ent.ResourceID.ToString(), SQLMatchType.Equal); resultOne = FCCResource.GetFacadeCreate().Delete(ent, fe_re_delete, DatabaseOperationType.Delete, TransactionRequired.No); } #endregion #region Consultant Delete Int64 resultTwo = -1; if (resultOne == 0) { String fe_con_delete = SqlExpressionBuilder.PrepareFilterExpression(CMConsultantEntity.FLD_NAME_ConsultantID, ConsultantID.ToString(), SQLMatchType.Equal); CMConsultantEntity cMConsultantEntity = new CMConsultantEntity(); resultTwo = FCCCMConsultant.GetFacadeCreate().Delete(cMConsultantEntity, fe_con_delete, DatabaseOperationType.Delete, TransactionRequired.No); } #endregion #region Member Delete Int64 resultThree = -1; if (resultTwo == 0) { String fe_mem_delete = SqlExpressionBuilder.PrepareFilterExpression(HRMemberEntity.FLD_NAME_MemberID, tempConsultant.MemberID.ToString(), SQLMatchType.Equal); HRMemberEntity hRMemberEntity = new HRMemberEntity(); resultThree = FCCHRMember.GetFacadeCreate().Delete(hRMemberEntity, fe_mem_delete, DatabaseOperationType.Delete, TransactionRequired.No); } #endregion if (resultOne == 0 && resultTwo == 0 && resultThree == 0) { _ConsultantID = 0; _CMConsultantEntity = new CMConsultantEntity(); _MemberID = 0; _HRMemberEntity = new HRMemberEntity(); PrepareInitialView(); BindCMConsultantList(); MiscUtil.ShowMessage(lblMessage, "Consultant has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Consultant.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
MDAccountPaybleStatementDetailCategoryEntity IMDAccountPaybleStatementDetailCategoryFacade.GetByID(Int64 iD) { String fe = SqlExpressionBuilder.PrepareFilterExpression(MDAccountPaybleStatementDetailCategoryEntity.FLD_NAME_AccountPaybleStatementDetailCategoryID, iD.ToString(), SQLMatchType.Equal); return(DataAccessFactory.CreateMDAccountPaybleStatementDetailCategoryDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]); }
protected void odsACCPostPayableStatementDetail_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = SqlExpressionBuilder.PrepareFilterExpression("ACCPostPayableStatementDetail." + ACCPostPayableStatementDetailEntity.FLD_NAME_AccountPaybleStatementDetailCategoryID, MasterDataConstants.MDAccountPaybleStatementDetailCategory.SECURED.ToString(), SQLMatchType.Equal); e.InputParameters["filterExpression"] = fe; }
private void PrepareInitialView() { BuildDropDownList(); txtExpectedStartDate.Text = System.DateTime.Now.AddDays(-30).ToString(UIConstants.SHORT_DATE_FORMAT); txtExpectedEndDate.Text = System.DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT); if (this.Page.User.Identity.IsAuthenticated == true) { if (this.Page.User.Identity.Name.Equals("17.466") == true || this.Page.User.Identity.Name.Equals("17.042") == true || this.Page.User.Identity.Name.Equals("17.1127") == true || this.Page.User.Identity.Name.Equals("17.605") == true || this.Page.User.Identity.Name.Equals("17.599") == true || this.Page.User.Identity.Name.Equals("17.1000") == true || this.Page.User.Identity.Name.Equals("17.979") == true || this.Page.User.Identity.Name.Equals("17.687") == true || this.Page.User.Identity.Name.Equals("17.788") == true || this.Page.User.Identity.Name.Equals("17.1116") == true || this.Page.User.Identity.Name.Equals("17.799") == true || this.Page.User.Identity.Name.Equals("17.780") == true) { //String fe1 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeSupervisorMapEntity.FLD_NAME_SupervisorEmployeeID, MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString(), SQLMatchType.Equal); //String fe2 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeSupervisorMapEntity.FLD_NAME_SessionCategoryID, "1", SQLMatchType.Equal); //String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); //IList<HREmployeeSupervisorMapEntity> lst = FCCHREmployeeSupervisorMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); //IList<HREmployeeSupervisorMap_DetailedEntity> lst = FCCHREmployeeSupervisorMap_Detailed.GetFacadeCreate().GetIL(null, null, String.Empty, fe)lblMessage //if (lst != null && lst.Count > 0) //{ // ddlEmployeeID.Items.Clear(); // foreach (HREmployeeSupervisorMapEntity ent in lst) // { // ListItem lstItem = new ListItem(); // lstItem.Text = ent.EmployeeCode + " - " + ent.EmployeeCode; // lstItem.Value = ent.EmployeeID.ToString(); // ddlEmployeeID.Items.Add(lstItem); // } //} String fe_session = SqlExpressionBuilder.PrepareFilterExpression(HRSessionEntity.FLD_NAME_EvaluationSessionStatusID, MasterDataConstants.MDEvaluationSessionStatus.OPEN.ToString(), SQLMatchType.Equal); IList <HRSessionEntity> lstHRSessionEntity = FCCHRSession.GetFacadeCreate().GetIL(null, null, String.Empty, fe_session, DatabaseOperationType.LoadWithFilterExpression); if (lstHRSessionEntity != null && lstHRSessionEntity.Count > 0) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeSupervisorMap_DetailedEntity.FLD_NAME_SupervisorEmployeeID, MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeSupervisorMap." + HREmployeeSupervisorMap_DetailedEntity.FLD_NAME_SessionCategoryID, lstHRSessionEntity[0].SessionID.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); IList <HREmployeeSupervisorMap_DetailedEntity> lst = FCCHREmployeeSupervisorMap_Detailed.GetFacadeCreate().GetIL(100000, 1, String.Empty, fe); if (lst != null && lst.Count > 0) { ddlEmployeeID.Items.Clear(); foreach (HREmployeeSupervisorMap_DetailedEntity ent in lst) { ListItem lstItem = new ListItem(); lstItem.Text = ent.EmployeeCode + " - " + ent.EmployeeFullName + "(" + ent.SessionCategoryName.ToString() + ")"; lstItem.Value = ent.EmployeeID.ToString(); ddlEmployeeID.Items.Add(lstItem); } } ddlEmployeeID.Enabled = true; } } else { ddlEmployeeID.SelectedValue = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString(); ddlEmployeeID.Enabled = false; } } }
HRMemberLeaveOpeningBalanceEntity IHRMemberLeaveOpeningBalanceFacade.GetByID(Int64 iD) { String fe = SqlExpressionBuilder.PrepareFilterExpression(HRMemberLeaveOpeningBalanceEntity.FLD_NAME_MemberLeaveOpeningBalanceID, iD.ToString(), SQLMatchType.Equal); return(DataAccessFactory.CreateHRMemberLeaveOpeningBalanceDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]); }
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); } }
private void DeleteItem() { Int64 ItemID; Int64.TryParse(treeItem.SelectedValue, out ItemID); if (ItemID > 0) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(MDItemEntity.FLD_NAME_ItemID, ItemID.ToString(), SQLMatchType.Equal); MDItemEntity mDItemEntity = new MDItemEntity(); #region Item Brand Map String fe1 = SqlExpressionBuilder.PrepareFilterExpression(PRMItemBrandMapEntity.FLD_NAME_ItemID, ItemID.ToString(), SQLMatchType.Equal); PRMItemBrandMapEntity prmItemBrandMap = new PRMItemBrandMapEntity(); FCCPRMItemBrandMap.GetFacadeCreate().Delete(prmItemBrandMap, fe, DatabaseOperationType.Delete, TransactionRequired.No); #endregion #region Item Default String fe2 = SqlExpressionBuilder.PrepareFilterExpression(MDItemDefaultEntity.FLD_NAME_ItemID, ItemID.ToString(), SQLMatchType.Equal); MDItemDefaultEntity mDItemDefaultEntity = new MDItemDefaultEntity(); FCCMDItemDefault.GetFacadeCreate().Delete(mDItemDefaultEntity, fe2, DatabaseOperationType.Delete, TransactionRequired.No); #endregion #region Item Thumb Rule String fe3 = SqlExpressionBuilder.PrepareFilterExpression(MDItemThumbRuleEntity.FLD_NAME_ItemID, ItemID.ToString(), SQLMatchType.Equal); MDItemThumbRuleEntity mDItemThumbRuleEntity = new MDItemThumbRuleEntity(); result = FCCMDItemThumbRule.GetFacadeCreate().Delete(mDItemThumbRuleEntity, fe3, DatabaseOperationType.Delete, TransactionRequired.No); #endregion result = FCCMDItem.GetFacadeCreate().Delete(mDItemEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _ItemID = 0; _MDItemEntity = new MDItemEntity(); // clearing cache FCCMDItem.GetFacadeCreate().RemoveCache(); PrepareInitialView(); LoadTreeView(); MiscUtil.ShowMessage(lblMessage, "Item has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Item.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private void SaveMDItemEntity() { if (IsValid) { try { Boolean addInputValidation = true; MDItemEntity mDItemEntity = BuildMDItemEntity(); Int64 result = -1; if (mDItemEntity.IsNew) { if (ValidateInput()) { if (treeItem.SelectedNode != null) { mDItemEntity.ItemCategoryID = Int64.Parse(treeItem.SelectedValue); } result = FCCMDItem.GetFacadeCreate().Add(mDItemEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { addInputValidation = false; } } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(MDItemEntity.FLD_NAME_ItemID, mDItemEntity.ItemID.ToString(), SQLMatchType.Equal); result = FCCMDItem.GetFacadeCreate().Update(mDItemEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (addInputValidation == true) { if (result > 0) { #region Item Brand Map ViewState["LastUpdatedItemID"] = result; try { IList <PRMItemBrandMapEntity> newMappedItems = new List <PRMItemBrandMapEntity>(); foreach (ListItem chbxItem in chbxItemBrand.Items) { if (chbxItem.Selected) { PRMItemBrandMapEntity mDItemBrandMapEntity = new PRMItemBrandMapEntity(); mDItemBrandMapEntity.ItemID = result; mDItemBrandMapEntity.BrandID = Int64.Parse(chbxItem.Value.ToString()); newMappedItems.Add(mDItemBrandMapEntity); } } IList <PRMItemBrandMapEntity> deleteList = _CurrentItemBrandMapList.Except(newMappedItems, new CustomerComparer()).ToList(); IList <PRMItemBrandMapEntity> addNewList = newMappedItems.Except(_CurrentItemBrandMapList, new CustomerComparer()).ToList(); if (deleteList != null && deleteList.Count > 0) { foreach (PRMItemBrandMapEntity ent in deleteList) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(PRMItemBrandMapEntity.FLD_NAME_ItemID, ent.ItemID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(PRMItemBrandMapEntity.FLD_NAME_BrandID, ent.BrandID.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); FCCPRMItemBrandMap.GetFacadeCreate().Delete(ent, fe, DatabaseOperationType.Delete, TransactionRequired.No); } } if (addNewList != null && addNewList.Count > 0) { foreach (PRMItemBrandMapEntity ent in addNewList) { FCCPRMItemBrandMap.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No); } } String feCurrent = SqlExpressionBuilder.PrepareFilterExpression(PRMItemBrandMapEntity.FLD_NAME_ItemID, result.ToString(), SQLMatchType.Equal); IList <PRMItemBrandMapEntity> ItemBrandList = FCCPRMItemBrandMap.GetFacadeCreate().GetIL(null, null, String.Empty, feCurrent, DatabaseOperationType.LoadWithFilterExpression); _CurrentItemBrandMapList = ItemBrandList; if (ddlBrandID.Items.Count > 0 && ddlBrandID.SelectedValue != MasterDataConstants.ItemDefaults.DEFAULT_BRAD.ToString()) { Boolean isNeedToInsert = false; if (ItemBrandList != null && ItemBrandList.Count > 0) { PRMItemBrandMapEntity itemBrandInfo = (from s in ItemBrandList where s.BrandID.ToString() == ddlBrandID.SelectedValue select s).FirstOrDefault(); if (itemBrandInfo == null) { isNeedToInsert = true; } } else { isNeedToInsert = true; } if (isNeedToInsert) { PRMItemBrandMapEntity pRMItemBrandMapEntity = new PRMItemBrandMapEntity(); pRMItemBrandMapEntity.BrandID = Int64.Parse(ddlBrandID.SelectedValue); pRMItemBrandMapEntity.ItemID = result; FCCPRMItemBrandMap.GetFacadeCreate().Add(pRMItemBrandMapEntity, DatabaseOperationType.Add, TransactionRequired.No); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } #endregion #region Item Defaults MDItemDefaultEntity mDItemDefaultEntity = BuildMDItemDefaultEntity(); mDItemDefaultEntity.ItemID = result; if (mDItemDefaultEntity.IsNew) { FCCMDItemDefault.GetFacadeCreate().Add(mDItemDefaultEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(MDItemDefaultEntity.FLD_NAME_ItemDefaultID, mDItemDefaultEntity.ItemDefaultID.ToString(), SQLMatchType.Equal); FCCMDItemDefault.GetFacadeCreate().Update(mDItemDefaultEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } #endregion //#region Item Thumb Rule //MDItemThumbRuleEntity mDItemThumbRuleEntity = BuildMDItemThumbRuleEntity(); //mDItemThumbRuleEntity.ItemID = result; //if (mDItemThumbRuleEntity.IsNew) //{ // result = FCCMDItemThumbRule.GetFacadeCreate().Add(mDItemThumbRuleEntity, DatabaseOperationType.Add, TransactionRequired.No); //} //else //{ // String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(MDItemThumbRuleEntity.FLD_NAME_MDItemThumbRuleID, mDItemThumbRuleEntity.MDItemThumbRuleID.ToString(), SQLMatchType.Equal); // result = FCCMDItemThumbRule.GetFacadeCreate().Update(mDItemThumbRuleEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); //} //#endregion //if (mDItemEntity.IsNew) //{ // if (Roles.IsUserInRole(this.Page.User.Identity.Name, "Admin") == true || Roles.IsUserInRole(this.Page.User.Identity.Name, "Engineer") || Roles.IsUserInRole(this.Page.User.Identity.Name, "MIS") == true) // { // lblItemName.Text = mDItemEntity.ItemName.ToString(); // this.Panel2_ModalPopupExtender.Show(); // } //} _ItemID = 0; _MDItemEntity = new MDItemEntity(); // clearing cache FCCMDItem.GetFacadeCreate().RemoveCache(); PrepareInitialView(); LoadTreeView(); if (mDItemEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Item Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Item Information has been updated successfully.", false); } } else { if (mDItemEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Item Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Item Information.", false); } } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void odsCMContractorAddressInfo_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = SqlExpressionBuilder.PrepareFilterExpression("CMContractorAddressInfo." + CMContractorAddressInfoEntity.FLD_NAME_ContractorID, this.OverviewContractorID.ToString(), SQLMatchType.Equal); e.InputParameters["filterExpression"] = fe; }
ACDebitCreditRuleElementEntity IACDebitCreditRuleElementFacade.GetByID(Int64 iD) { String fe = SqlExpressionBuilder.PrepareFilterExpression(ACDebitCreditRuleElementEntity.FLD_NAME_DebitCreditRuleElementID, iD.ToString(), SQLMatchType.Equal); return(DataAccessFactory.CreateACDebitCreditRuleElementDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]); }
protected void odsHREmployeeSalaryInfo_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeSalaryInfoEntity.FLD_NAME_EmployeeID, OverviewEmployeeID.ToString(), SQLMatchType.LikeWithBothMath); e.InputParameters["filterExpression"] = fe; }
protected void lvOTIssue_Detailed_ItemDataBound(object sender, ListViewItemEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; OTIssue_DetailedEntity ent = (OTIssue_DetailedEntity)dataItem.DataItem; Label lblIssuePriorityNameLV = (Label)e.Item.FindControl("lblIssuePriorityNameLV"); Label lblExpectedEndDateLV = (Label)e.Item.FindControl("lblExpectedEndDateLV"); Label lblSupervisorAgreedLV = (Label)e.Item.FindControl("lblSupervisorAgreedLV"); if (ent.IssuePriorityID == MasterDataConstants.MDIssuePriority.CRITICAL && ent.IssueStatusID != MasterDataConstants.MDIssueStatus.COMPLETED) { lblIssuePriorityNameLV.ForeColor = System.Drawing.Color.Red; } if (ent.IssueStatusID != MasterDataConstants.MDIssueStatus.COMPLETED && ent.ExpectedEndDate < System.DateTime.Now) { lblExpectedEndDateLV.ForeColor = System.Drawing.Color.Red; } if (ent.SupervisorAgreed == false) { lblSupervisorAgreedLV.ForeColor = System.Drawing.Color.Red; } HyperLink hypEdit = (HyperLink)e.Item.FindControl("hypEdit"); HyperLink hypEditDetails = (HyperLink)e.Item.FindControl("hypEditDetails"); HyperLink hypAddSubIssue = (HyperLink)e.Item.FindControl("hypAddSubIssue"); HyperLink hypAddReferenceIssue = (HyperLink)e.Item.FindControl("hypAddReferenceIssue"); HyperLink hypAssignedResource = (HyperLink)e.Item.FindControl("hypAssignedResource"); HyperLink hypIssueReport = (HyperLink)e.Item.FindControl("hypIssueReport"); Button btnCompletedLV = (Button)e.Item.FindControl("btnCompletedLV"); LinkButton lnkBtnDelete = (LinkButton)e.Item.FindControl("lnkBtnDelete"); //Stopped By Rayan vaiya //hypIssueReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.ISSUE_REPORT, UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); hypAssignedResource.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTIssueAssignedResource.aspx", string.Empty, UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); #region Bind Edit Hyperlink switch (PageAPType) { case MasterDataConstants.IssuePageType.ADHOC_ISSUE: hypEdit.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTAdhocIssue.aspx", string.Empty, "do", "Edit", UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); break; case MasterDataConstants.IssuePageType.PROJECT_ADHOC_ISSUE: hypEdit.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTProjectAdhocIssue.aspx", string.Empty, "do", "Edit", UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); break; case MasterDataConstants.IssuePageType.MY_ISSUE_LIST: if (ent.ReferenceID != null) { hypEdit.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTProjectAdhocIssue.aspx", string.Empty, "do", "Edit", UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); hypEditDetails.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTProjectAdhocIssue.aspx", string.Empty, "do", "EditDetails", UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); } else { hypEdit.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTAdhocIssue.aspx", string.Empty, "do", "Edit", UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); hypEditDetails.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTProjectAdhocIssue.aspx", string.Empty, "do", "EditDetails", UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); } break; } if (ent.ReferenceID != null) { hypEdit.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTProjectAdhocIssue.aspx", string.Empty, "do", "Edit", UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); hypEditDetails.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTProjectAdhocIssue.aspx", string.Empty, "do", "EditDetails", UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); hypIssueReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTProjectAdhocIssue.aspx", string.Empty, "do", "ViewIssue", UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); } else { hypEdit.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTAdhocIssue.aspx", string.Empty, "do", "Edit", UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); hypEditDetails.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTAdhocIssue.aspx", string.Empty, "do", "EditDetails", UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); hypIssueReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTAdhocIssue.aspx", string.Empty, "do", "ViewIssue", UrlConstants.OVERVIEW_ISSUE_ID, ent.IssueID.ToString()).ToString(); } #endregion #region Link Build Logic if (CurrentemployeeID > 0) { String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEntity.FLD_NAME_MemberID, ent.CreatedByMemberID.ToString(), SQLMatchType.Equal); IList <HREmployeeEntity> lstEmployeeEntity = FCCHREmployee.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (CurrentemployeeID == ent.SupervisorEmployeeID || lstEmployeeEntity[0].EmployeeID == CurrentemployeeID) { hypEdit.Visible = true; hypEditDetails.Visible = true; hypAssignedResource.Visible = true; btnCompletedLV.Enabled = true; } else if (CurrentemployeeID == ent.AssignedToEmployeeID && CurrentemployeeID != ent.SupervisorEmployeeID && lstEmployeeEntity[0].EmployeeID != CurrentemployeeID) { hypEdit.Visible = true; hypEditDetails.Visible = false; hypAssignedResource.Visible = true; btnCompletedLV.Enabled = true; } else { hypEdit.Visible = false; hypEditDetails.Visible = false; hypAssignedResource.Visible = false; btnCompletedLV.Enabled = false; } if (CurrentemployeeID == ent.SupervisorEmployeeID || CurrentemployeeID == lstEmployeeEntity[0].EmployeeID) { lnkBtnDelete.Visible = true; } else { lnkBtnDelete.Visible = false; } } if (ent.IssueStatusID == MasterDataConstants.MDIssueStatus.COMPLETED) { hypEdit.Visible = false; hypEditDetails.Visible = false; hypAssignedResource.Visible = false; btnCompletedLV.Enabled = false; } #endregion //hypAddSubIssue.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTIssueEditor.aspx", string.Empty, "do", "AddSubIssue", "ParentIssueID", ent.IssueID.ToString()).ToString(); //hypAddReferenceIssue.NavigateUrl = UrlHelper.BuildSecureUrl("~/OT/OTIssueEditor.aspx", string.Empty, "do", "AddReferenceIssue", "ReferenceIssueID", ent.IssueID.ToString()).ToString(); hypEdit.Target = "_blank"; hypIssueReport.Target = "_blank"; } }
private void SaveCMConsultantEntity() { if (IsValid) { try { #region Member HRMemberEntity hRMemberEntity = BuildHRMemberEntity(); Int64 result = -1; if (hRMemberEntity.IsNew) { result = FCCHRMember.GetFacadeCreate().Add(hRMemberEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HRMemberEntity.FLD_NAME_MemberID, hRMemberEntity.MemberID.ToString(), SQLMatchType.Equal); result = FCCHRMember.GetFacadeCreate().Update(hRMemberEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } #endregion if (result > 0) { _MemberID = 0; _HRMemberEntity = new HRMemberEntity(); } if (result > 0) { CMConsultantEntity cMConsultantEntity = BuildCMConsultantEntity(); Int64 resultC = -1; if (cMConsultantEntity.IsNew) { cMConsultantEntity.MemberID = result; resultC = FCCCMConsultant.GetFacadeCreate().Add(cMConsultantEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CMConsultantEntity.FLD_NAME_ConsultantID, cMConsultantEntity.ConsultantID.ToString(), SQLMatchType.Equal); resultC = FCCCMConsultant.GetFacadeCreate().Update(cMConsultantEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (resultC > 0) { _ConsultantID = 0; _CMConsultantEntity = new CMConsultantEntity(); PrepareInitialView(); BindCMConsultantList(); if (cMConsultantEntity.IsNew) { ResourceEntity resourceEntity = new ResourceEntity(); resourceEntity.ReferenceID = resultC; // means new contractor id resourceEntity.ResourceCategoryID = MasterDataConstants.ResourceCategory.CONSULTANT; FCCResource.GetFacadeCreate().Add(resourceEntity, DatabaseOperationType.Add, TransactionRequired.No); } if (cMConsultantEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Consultant Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Consultant Information has been updated successfully.", false); } } else { if (cMConsultantEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Consultant Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Consultant Information.", false); } } } else { if (hRMemberEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Member Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Member Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvOTIssue_Detailed_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 IssueID; Int64.TryParse(e.CommandArgument.ToString(), out IssueID); if (IssueID > 0) { if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(OTIssueEntity.FLD_NAME_IssueID, IssueID.ToString(), SQLMatchType.Equal); OTIssueEntity oTIssueEntity = new OTIssueEntity(); result = FCCOTIssue.GetFacadeCreate().Delete(oTIssueEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _IssueID = 0; _OTIssueEntity = new OTIssueEntity(); PrepareInitialView(); BindOTIssueList(); MiscUtil.ShowMessage(lblMessage, "Issue has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Issue.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } else if (string.Equals(e.CommandName, "UpdateItem")) { try { _IssueID = IssueID; OTIssueEntity oTIssueEntity = CurrentOTIssueEntity; if (CurrentOTIssueEntity.IssueStatusID == MasterDataConstants.MDIssueStatus.COMPLETED) { MiscUtil.ShowMessage(lblMessage, "Issue Already Completed.", false); return; } Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(OTIssueEntity.FLD_NAME_IssueID, IssueID.ToString(), SQLMatchType.Equal); oTIssueEntity.IssueStatusID = MasterDataConstants.MDIssueStatus.COMPLETED; oTIssueEntity.CompletionPercentage = 100; result = FCCOTIssue.GetFacadeCreate().Update(oTIssueEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); if (result > 0) { _IssueID = 0; _OTIssueEntity = new OTIssueEntity(); PrepareInitialView(); BindOTIssueList(); MiscUtil.ShowMessage(lblMessage, "Issue has been successfully Updated.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to Update Issue.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } else if (string.Equals(e.CommandName, "AddToSchedule")) { try { OTIssueEntity oTIssueEntity = FCCOTIssue.GetFacadeCreate().GetByID(IssueID); OTScheduleEntity oTScheduleEntity = new OTScheduleEntity(); } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
MDPayableClassificationEntity IMDPayableClassificationFacade.GetByID(Int64 iD) { String fe = SqlExpressionBuilder.PrepareFilterExpression(MDPayableClassificationEntity.FLD_NAME_PayableClassificationID, iD.ToString(), SQLMatchType.Equal); return(DataAccessFactory.CreateMDPayableClassificationDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]); }
protected void odsOTIssue_Detailed_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = String.Empty; switch (PageAPType) { case MasterDataConstants.IssuePageType.ADHOC_ISSUE: fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueIdentityCategoryID, MasterDataConstants.IssueIdentityCategory.ADHOC_ISSUE.ToString(), SQLMatchType.Equal); lblIssueList.Text = "Adhoc Issue List"; break; case MasterDataConstants.IssuePageType.PROJECT_ADHOC_ISSUE: fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueIdentityCategoryID, MasterDataConstants.IssueIdentityCategory.PROJECT_ADHOC_ISSUE.ToString(), SQLMatchType.Equal); lblIssueList.Text = "Project Issue List"; break; case MasterDataConstants.IssuePageType.MY_ISSUE_LIST: fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_CreatedByMemberID, CurrentMember.MemberID.ToString(), SQLMatchType.Equal); Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); if (employeeID > 0) { String fe_assignToEmployee = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_AssignedToEmployeeID, employeeID.ToString(), SQLMatchType.Equal); fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.OR, fe_assignToEmployee); String fe_resource1 = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ResourceCategoryID, MasterDataConstants.ResourceCategory.EMPLOYEE.ToString(), SQLMatchType.Equal); String fe_resource2 = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ReferenceID, employeeID.ToString(), SQLMatchType.Equal); String fe_resource = SqlExpressionBuilder.PrepareFilterExpression(fe_resource1, SQLJoinType.AND, fe_resource2); IList <ResourceEntity> lstResource = FCCResource.GetFacadeCreate().GetIL(null, null, String.Empty, fe_resource, DatabaseOperationType.LoadWithFilterExpression); if (lstResource != null && lstResource.Count > 0) { String fe_Assigned_Issue = SqlExpressionBuilder.PrepareFilterExpression(OTIssueAssignedResourceEntity.FLD_NAME_ResourceID, lstResource[0].ResourceID.ToString(), SQLMatchType.Equal); IList <OTIssueAssignedResourceEntity> lstIssueAssignedResource = FCCOTIssueAssignedResource.GetFacadeCreate().GetIL(null, null, String.Empty, fe_Assigned_Issue, DatabaseOperationType.LoadWithFilterExpression); if (lstIssueAssignedResource != null && lstIssueAssignedResource.Count > 0) { String compositeIssueID = String.Empty; foreach (OTIssueAssignedResourceEntity ent in lstIssueAssignedResource) { compositeIssueID += ent.IssueID + ","; } if (compositeIssueID.IsNotNullOrEmpty()) { compositeIssueID = compositeIssueID.Substring(0, compositeIssueID.Length - 1); String fe_issue = "OTIssue.IssueID in(" + compositeIssueID + ")"; fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.OR, fe_issue); } } } } lblIssueList.Text = "My Issue List"; break; default: fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueIdentityCategoryID, MasterDataConstants.IssueIdentityCategory.PROJECT_ADHOC_ISSUE.ToString(), SQLMatchType.Equal); break; } if (chbxFilter.Checked) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression("OTIssue.Title", txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath); String fe2 = SqlExpressionBuilder.PrepareFilterExpression("MDIssuePriority.Name", txtSearchText.Text.ToString(), SQLMatchType.LikeWithSuffixMath); String fe3 = SqlExpressionBuilder.PrepareFilterExpression("MDIssueStatus.Name", txtSearchText.Text.ToString(), SQLMatchType.LikeWithSuffixMath); Int64 issueID; Int64.TryParse(txtSearchText.Text.Trim().ToString(), out issueID); String fe6 = SqlExpressionBuilder.PrepareFilterExpression("OTIssue.IssueID", issueID.ToString(), SQLMatchType.Equal); String fe4 = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.OR, fe2); String fe5 = SqlExpressionBuilder.PrepareFilterExpression(fe3, SQLJoinType.OR, fe4); String fe7 = SqlExpressionBuilder.PrepareFilterExpression(fe5, SQLJoinType.OR, fe6); fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe7); } e.InputParameters["filterExpression"] = fe; }
protected void odsCMBillUploadInfo_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = SqlExpressionBuilder.PrepareFilterExpression(CMBillUploadInfoEntity.FLD_NAME_BillID, CMBillID.ToString(), SQLMatchType.Equal); e.InputParameters["filterExpression"] = fe; }
protected void odsREQRequisitionItem_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = SqlExpressionBuilder.PrepareFilterExpression("REQRequisitionItem." + REQRequisitionItemEntity.FLD_NAME_RequisitionID, REQRequisitionID.ToString(), SQLMatchType.Equal); e.InputParameters["filterExpression"] = fe; }
protected void odsHRAdditonalInformation_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = SqlExpressionBuilder.PrepareFilterExpression(HRAdditonalInformationEntity.FLD_NAME_EmployeeID, OverviewEmployeeID.ToString(), SQLMatchType.Equal); e.InputParameters["filterExpression"] = fe; }
protected void odsPRMWorkOrderPaymentTerm_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderPaymentTermEntity.FLD_NAME_WorkOrderID, PRMWorkOrderID.ToString(), SQLMatchType.Equal); e.InputParameters["filterExpression"] = fe; }
APPanelItemCategoryMapEntity IAPPanelItemCategoryMapFacade.GetByID(Int64 iD) { String fe = SqlExpressionBuilder.PrepareFilterExpression(APPanelItemCategoryMapEntity.FLD_NAME_APPanelItemCategoryMapID, iD.ToString(), SQLMatchType.Equal); return(DataAccessFactory.CreateAPPanelItemCategoryMapDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]); }
PRMPreBOQDetailHistoryEntity IPRMPreBOQDetailHistoryFacade.GetByID(Int64 iD) { String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQDetailHistoryEntity.FLD_NAME_PRMPreBOQDetailHistoryID, iD.ToString(), SQLMatchType.Equal); return(DataAccessFactory.CreatePRMPreBOQDetailHistoryDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]); }
MDHRNoticeTemplateTypeEntity IMDHRNoticeTemplateTypeFacade.GetByID(Int64 iD) { String fe = SqlExpressionBuilder.PrepareFilterExpression(MDHRNoticeTemplateTypeEntity.FLD_NAME_NoticeTemplateTypeID, iD.ToString(), SQLMatchType.Equal); return(DataAccessFactory.CreateMDHRNoticeTemplateTypeDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]); }
protected void btnAddToProject_Click(object sender, EventArgs e) { if (ddlProjectID.Items.Count > 0 && ddlProjectID.SelectedValue != "0") { Int64 itemID = 0; if (ViewState["LastUpdatedItemID"] != null) { itemID = (Int64)ViewState["LastUpdatedItemID"]; } if (itemID > 0) { String fe_itemDefault = SqlExpressionBuilder.PrepareFilterExpression(MDItemDefaultEntity.FLD_NAME_ItemID, itemID.ToString(), SQLMatchType.Equal); IList <MDItemDefaultEntity> lstmDItemDefaultEntity = FCCMDItemDefault.GetFacadeCreate().GetIL(null, null, String.Empty, fe_itemDefault, DatabaseOperationType.LoadWithFilterExpression); String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_ProjectID, ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal); IList <PRMPreBOQEntity> preBOQList = FCCPRMPreBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (preBOQList != null && preBOQList.Count > 0) { Int64 preBOQID = preBOQList[0].PreBOQID; Decimal totalQty = 0; Decimal.TryParse(txtQty.Text.Trim().ToString(), out totalQty); Decimal currentPrice = MiscUtil.GetCurrentPrice(itemID, lstmDItemDefaultEntity[0].BrandID, lstmDItemDefaultEntity[0].SupplierID, lstmDItemDefaultEntity[0].RegionID, lstmDItemDefaultEntity[0].CountryID); switch (preBOQList[0].IsLocked) { case true: #region Add Item to BOQ try { String fe_boq = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQEntity.FLD_NAME_ProjectID, ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal); IList <PRMBOQEntity> lstPRMBOQ = FCCPRMBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe_boq, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMBOQ != null && lstPRMBOQ.Count > 0) { PRMBOQDetailEntity pRMBOQDeatEntity = new PRMBOQDetailEntity(); pRMBOQDeatEntity.BOQID = lstPRMBOQ[0].BOQID; pRMBOQDeatEntity.ItemID = itemID; pRMBOQDeatEntity.BrandID = lstmDItemDefaultEntity[0].BrandID; pRMBOQDeatEntity.RegionID = lstmDItemDefaultEntity[0].RegionID; pRMBOQDeatEntity.CountryID = lstmDItemDefaultEntity[0].CountryID; pRMBOQDeatEntity.SupplierID = lstmDItemDefaultEntity[0].SupplierID; pRMBOQDeatEntity.Remarks = "Directly Added From Item"; pRMBOQDeatEntity.IsRemoved = false; pRMBOQDeatEntity.Rate = currentPrice; pRMBOQDeatEntity.EntryDate = System.DateTime.Now; pRMBOQDeatEntity.TotalQty = totalQty; Int64 result_boq = -1; result_boq = FCCPRMBOQDetail.GetFacadeCreate().Add(pRMBOQDeatEntity, DatabaseOperationType.Add, TransactionRequired.No); if (result_boq > 0) { PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity = new PRMAvailableBOQQtyForRequisitionEntity(); pRMAvailableBOQQtyForRequisitionEntity.IsBOQ = true; pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID = result_boq; pRMAvailableBOQQtyForRequisitionEntity.ItemID = itemID; pRMAvailableBOQQtyForRequisitionEntity.Qty = totalQty; pRMAvailableBOQQtyForRequisitionEntity.CreateDate = DateTime.Now; pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); pRMAvailableBOQQtyForRequisitionEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); Int64 result_available = -1; result_available = FCCPRMAvailableBOQQtyForRequisition.GetFacadeCreate().Add(pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); MiscUtil.ShowMessage(lblMessage, "Qty Added Successfully to Project Cost.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, "Some Error Occured.", true); } #endregion break; case false: #region Add Item to Pre-BOQ try { String fe_preBOQ = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_ProjectID, ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal); IList <PRMPreBOQEntity> lstPRMPreBOQ = FCCPRMPreBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe_preBOQ, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMPreBOQ != null && lstPRMPreBOQ.Count > 0) { PRMPreBOQDetailEntity pRMPreBOQDeatEntity = new PRMPreBOQDetailEntity(); pRMPreBOQDeatEntity.PreBOQID = lstPRMPreBOQ[0].PreBOQID; pRMPreBOQDeatEntity.ItemID = itemID; pRMPreBOQDeatEntity.BrandID = lstmDItemDefaultEntity[0].BrandID; pRMPreBOQDeatEntity.RegionID = lstmDItemDefaultEntity[0].RegionID; pRMPreBOQDeatEntity.CountryID = lstmDItemDefaultEntity[0].CountryID; pRMPreBOQDeatEntity.SupplierID = lstmDItemDefaultEntity[0].SupplierID; pRMPreBOQDeatEntity.TotalQty = totalQty; pRMPreBOQDeatEntity.Remarks = "Directly Added From Item"; pRMPreBOQDeatEntity.IsRemoved = false; pRMPreBOQDeatEntity.Rate = currentPrice; pRMPreBOQDeatEntity.EntryDate = System.DateTime.Now; Int64 result_preboq = -1; result_preboq = FCCPRMPreBOQDetail.GetFacadeCreate().Add(pRMPreBOQDeatEntity, DatabaseOperationType.Add, TransactionRequired.No); if (result_preboq > 0) { PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity = new PRMAvailableBOQQtyForRequisitionEntity(); pRMAvailableBOQQtyForRequisitionEntity.IsBOQ = false; pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID = result_preboq; pRMAvailableBOQQtyForRequisitionEntity.ItemID = itemID; pRMAvailableBOQQtyForRequisitionEntity.Qty = totalQty; pRMAvailableBOQQtyForRequisitionEntity.CreateDate = DateTime.Now; pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); pRMAvailableBOQQtyForRequisitionEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); Int64 result_available = -1; result_available = FCCPRMAvailableBOQQtyForRequisition.GetFacadeCreate().Add(pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); MiscUtil.ShowMessage(lblMessage, "Qty Added Successfully to BOQ.", false); } } } catch (Exception) { MiscUtil.ShowMessage(lblMessage, "Some Error Occured.", true); } #endregion break; default: break; } } } } }