public FinancialSupplierLiabilitySummary_Fact GetFinnancialSupplierLiabilitySummaryFact( Session session, Guid OwnerOrgId, Guid SupplierOrgId, DateTime IssueDate, string FinancialAccountCode) { FinancialSupplierLiabilitySummary_Fact result = null; try { Util util = new Util(); OwnerOrgDim ownerOrgDim = util.GetXpoObjectByFieldName <OwnerOrgDim, Guid>(session, "RefId", OwnerOrgId, BinaryOperatorType.Equal); SupplierOrgDim supplierOrgDim = util.GetXpoObjectByFieldName <SupplierOrgDim, Guid>(session, "RefId", SupplierOrgId, BinaryOperatorType.Equal); MonthDim monthDim = util.GetXpoObjectByFieldName <MonthDim, string>(session, "Name", IssueDate.Month.ToString(), BinaryOperatorType.Equal); YearDim yearDim = util.GetXpoObjectByFieldName <YearDim, string>(session, "Name", IssueDate.Year.ToString(), BinaryOperatorType.Equal); FinancialAccountDim financialAccountDim = util.GetXpoObjectByFieldName <FinancialAccountDim, string>(session, "Code", FinancialAccountCode, BinaryOperatorType.Equal); if (ownerOrgDim == null || supplierOrgDim == null || monthDim == null || yearDim == null || financialAccountDim == null) { return(null); } else { FinancialSupplierLiabilitySummary_Fact a = null; CriteriaOperator criteria_RowStatus = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.GreaterOrEqual); CriteriaOperator criteria_OwnerOrg = new BinaryOperator("OwnerOrgDimId", ownerOrgDim, BinaryOperatorType.Equal); CriteriaOperator criteria_SupplierOrg = new BinaryOperator("SupplierOrgDimId", supplierOrgDim, BinaryOperatorType.Equal); CriteriaOperator criteria_Month = new BinaryOperator("MonthDimId", monthDim, BinaryOperatorType.Equal); CriteriaOperator criteria_Year = new BinaryOperator("YearDimId", yearDim, BinaryOperatorType.Equal); CriteriaOperator criteria_AccountCode = new BinaryOperator("FinancialAccountDimId", financialAccountDim, BinaryOperatorType.Equal); CriteriaOperator criteria = CriteriaOperator.And(criteria_RowStatus, criteria_OwnerOrg, criteria_SupplierOrg, criteria_Month, criteria_Year, criteria_AccountCode); FinancialSupplierLiabilitySummary_Fact fact = session.FindObject <FinancialSupplierLiabilitySummary_Fact>(criteria); if (fact == null) { return(null); } { result = fact; } } } catch (Exception) { return(result); } return(result); }
public SupplierOrgDim GetSupplierOrgDim(Session session, Guid RefId) { try { CriteriaOperator criteria_RowStaus = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.Equal); CriteriaOperator criteria_RefId = new BinaryOperator("RefId", RefId, BinaryOperatorType.Equal); CriteriaOperator criteria = CriteriaOperator.And(criteria_RefId, criteria_RowStaus); SupplierOrgDim supplierOrgDim = session.FindObject <SupplierOrgDim>(criteria); if (supplierOrgDim == null) { return(CreateSupplierOrgDim(session, RefId)); } return(supplierOrgDim); } catch { return(null); } }
public SupplierOrgDim CreateSupplierOrgDim(Session session, Guid RefId) { try { Organization supplierOrg = session.GetObjectByKey <Organization>(RefId); if (supplierOrg == null) { return(null); } SupplierOrgDim supplierOrgDim = new SupplierOrgDim(session); supplierOrgDim.Code = supplierOrg.Code; supplierOrgDim.Description = supplierOrg.Description; supplierOrgDim.RefId = RefId; supplierOrgDim.Name = supplierOrg.Name; supplierOrgDim.RowStatus = Constant.ROWSTATUS_ACTIVE; supplierOrgDim.Save(); return(supplierOrgDim); } catch (Exception) { return(null); } }