private void SetCriteriaForOrganization() { //Get CUSTOMER trading type TradingCategory customerTradingCategory = NAS.DAL.Util.getXPCollection <TradingCategory>(session, "Code", "CUSTOMER").FirstOrDefault(); //Get SUPPLIER trading type TradingCategory supplierTradingCategory = NAS.DAL.Util.getXPCollection <TradingCategory>(session, "Code", "SUPPLIER").FirstOrDefault(); CriteriaOperator criteria = CriteriaOperator.And( CriteriaOperator.Or( new ContainsOperator("OrganizationCategories", CriteriaOperator.And( new BinaryOperator("TradingCategoryId.TradingCategoryId", customerTradingCategory.TradingCategoryId), new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE) ) ), new ContainsOperator("OrganizationCategories", CriteriaOperator.And( new BinaryOperator("TradingCategoryId.TradingCategoryId", supplierTradingCategory.TradingCategoryId), new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE) ) ) ), new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE) ); dsSourceOrg.Criteria = criteria.ToString(); cbSourceOrganization.DataBindItems(); }
public void updateTradingCategoriesForObject <T>(Session session, Guid supplierId, List <Guid> typeList) { try { T s = session.GetObjectByKey <T>(supplierId); if (s == null) { throw new Exception("Key is not Exist in Org"); } CriteriaOperator criteria = new BinaryOperator("OrganizationId!Key", supplierId, BinaryOperatorType.Equal); XPCollection <OrganizationCategory> ocl = new XPCollection <OrganizationCategory>(session, criteria); foreach (OrganizationCategory oc in ocl) { oc.RowStatus = Utility.Constant.ROWSTATUS_DELETED; oc.Save(); } foreach (Guid k in typeList) { TradingCategory tc = session.GetObjectByKey <TradingCategory>(k); if (tc == null) { throw new Exception("Key is not Exist in TradingCategory"); } criteria = CriteriaOperator.And( new BinaryOperator("OrganizationId", s, BinaryOperatorType.Equal), new BinaryOperator("RowStatus", 0, BinaryOperatorType.Greater), new BinaryOperator("TradingCategoryId", tc, BinaryOperatorType.Greater) ); OrganizationCategory oc = session.FindObject <OrganizationCategory>(criteria); if (oc == null) { oc = new OrganizationCategory(session); oc.RowStatus = Utility.Constant.ROWSTATUS_ACTIVE; oc.OrganizationId = s as DAL.Nomenclature.Organization.Organization; oc.TradingCategoryId = tc; oc.Save(); } else { oc.TradingCategoryId = tc; oc.RowStatus = Utility.Constant.ROWSTATUS_ACTIVE; oc.Save(); } } } catch (Exception ex) { throw ex; } }
protected void cboSourceOrganization_ItemsRequestedByFilterCondition(object source, DevExpress.Web.ASPxEditors.ListEditItemsRequestedByFilterConditionEventArgs e) { XPCollection <Organization> collection = new XPCollection <Organization>(session); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; //Get CUSTOMER trading type TradingCategory customerTradingCategory = session.FindObject <TradingCategory>(new BinaryOperator("Code", "CUSTOMER")); //Get SUPPLIER trading type TradingCategory supplierTradingCategory = session.FindObject <TradingCategory>(new BinaryOperator("Code", "SUPPLIER")); CriteriaOperator criteria = CriteriaOperator.And( //row status is active new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE), CriteriaOperator.Or( //find code contains the filter new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like), //find name contains the filter new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like) ), //find customer and supplier CriteriaOperator.Or( new ContainsOperator("OrganizationCategories", CriteriaOperator.And( new BinaryOperator("TradingCategoryId.TradingCategoryId", customerTradingCategory.TradingCategoryId), new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE) ) ), new ContainsOperator("OrganizationCategories", CriteriaOperator.And( new BinaryOperator("TradingCategoryId.TradingCategoryId", supplierTradingCategory.TradingCategoryId), new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE) ) ) ) ); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); cboSourceOrganization.DataSource = collection; cboSourceOrganization.DataBindItems(); }
public override void InitXpoDatasource(XpoDataSource datasource) { Session session = null; try { session = XpoHelper.GetNewSession(); //Set TypeName datasource.TypeName = typeof(NAS.DAL.Nomenclature.Organization.Organization).FullName; //Set Criteria //Get CUSTOMER trading type TradingCategory customerTradingCategory = session.FindObject <TradingCategory>(new BinaryOperator("Code", "CUSTOMER")); CriteriaOperator criteria = CriteriaOperator.And( //row status is active new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE), //find customer and customer new ContainsOperator("OrganizationCategories", CriteriaOperator.And( new BinaryOperator("TradingCategoryId.TradingCategoryId", customerTradingCategory.TradingCategoryId), new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE) ) ) ); datasource.Criteria = criteria.ToString(); datasource.DefaultSorting = "Code"; } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
protected void cboSupplierColumn_OnItemsRequestedByFilterCondition_SQL(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { ASPxComboBox comboBox = (ASPxComboBox)source; //if (comboBox.IsCallback) { //Get SUPPLIER trading type //2013-11-03 ERP-872 Khoa.Truong MOD START TradingCategory supplierTradingCategory = NAS.DAL.Util.getXPCollection <TradingCategory>(session, "Code", "SUPPLIER").FirstOrDefault(); //XPCollection<NAS.DAL.Nomenclature.Organization.SupplierOrg> collection = new XPCollection<NAS.DAL.Nomenclature.Organization.SupplierOrg>(session); XPCollection <NAS.DAL.Nomenclature.Organization.Organization> collection = new XPCollection <NAS.DAL.Nomenclature.Organization.Organization>(session); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; //collection.Criteria = CriteriaOperator.Or( // new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like), // new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like) //); collection.Criteria = CriteriaOperator.And( CriteriaOperator.Or( new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like), new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like) ), new ContainsOperator("OrganizationCategories", CriteriaOperator.And( new BinaryOperator("TradingCategoryId.TradingCategoryId", supplierTradingCategory.TradingCategoryId), new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE) ) ), new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE) ); //2013-11-03 ERP-872 Khoa.Truong MOD END collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); comboBox.DataSource = collection; comboBox.DataBindItems(); //} }
/// <summary> /// Populate default data to database /// </summary> public static void Populate() { try { ////NAS.DAL.Accounting.AccountChart NAS.DAL.BI.Accounting.Account.CorrespondFinancialAccountDim.Populate(); NAS.DAL.BI.Accounting.Account.FinancialAccountDim.Populate(); Account.Populate(); AccountType.Populate(); AccountCategory.Populate(); Currency.Populate(); ////NAS.DAL.Accounting.Configure AllocationType.Populate(); ////NAS.DAL.CMS.ObjectDocument ObjectType.Populate(); CustomFieldType.Populate(); ObjectTypeCustomField.Populate(); ////NAS.DAL.Inventory.Item RecordedType.Populate(); ////NAS.DAL.Inventory.Operation CommanderStockCartStatus.Populate(); CommanderStockCartType.Populate(); ////NAS.DAL.Inventory.StockCart StockCartActorType.Populate(); ////NAS.DAL.Invoice TaxType.Populate(); PromotionType.Populate(); ////NAS.DAL.Nomenclature.Inventory Nomenclature.Inventory.Inventory.Populate(); InventoryUnit.Populate(); ////NAS.DAL.Nomenclature.Item ItemUnitRelationType.Populate(); UnitType.Populate(); Unit.Populate(); ItemUnit.Populate(); ItemTradingType.Populate(); ItemCustomType.Populate(); ////NAS.DAL.Nomenclature.Organization TradingCategory.Populate(); AuthenticationProvider.Populate(); DepartmentType.Populate(); OrganizationType.Populate(); Person.Populate(); Organization.Populate(); OwnerOrg.Populate(); CustomerOrg.Populate(); SupplierOrg.Populate(); ManufacturerOrg.Populate(); Department.Populate(); DepartmentPerson.Populate(); //NAS.DAL.Staging.Accounting.Journal AccountActorType.Populate(); ////NAS.DAL.Vouches VouchesType.Populate(); VouchesActorType.Populate(); ReceiptVouchesType.Populate(); PaymentVouchesType.Populate(); ForeignCurrency.Populate(); ////NAS.DAL.Accounting.Journal AccountingPeriod.Populate(); //SalesInvoicePickingStockCart.Populate(); ////NAS.DAL.System.ArtifactCode ArtifactType.Populate(); CodeRuleDataType.Populate(); CodeRuleDataFormat.Populate(); RuleRepeaterType.Populate(); //NAS.DAL.Sales.Price PricePolicyType.Populate(); //NAS.DAL.Inventory.Lot.Lot NAS.DAL.Inventory.Lot.Lot.Populate(); //NAS.DAL.Inventory.Command.InventoryCommandActorType NAS.DAL.Inventory.Command.InventoryCommandActorType.Populate(); NAS.DAL.BI.Inventory.InventoryCommandDim.Populate(); #region Other populate using (Session session = XpoHelper.GetNewSession()) { //Insert undefined supplier if (!Util.isExistXpoObject <SupplierOrg>("OrganizationId", Guid.Parse("3DEF2B62-2162-46CD-8418-DEE6F8E59E21"))) { SupplierOrg undefinedSupplierOrg = new SupplierOrg(session) { OrganizationId = Guid.Parse("3DEF2B62-2162-46CD-8418-DEE6F8E59E21"), Name = "Mặc định", Description = "Mặc định", Code = "MACDINH", RowCreationTimeStamp = DateTime.Now, RowStatus = Constant.ROWSTATUS_ACTIVE, OrganizationTypeId = NAS.DAL.Util.getDefaultXpoObject <OrganizationType>(session) }; undefinedSupplierOrg.Save(); } } #endregion } catch (Exception) { throw new Exception("Populate failed"); } finally { } }