public static void DeleteLogical(Guid manufacturerOrgId) { Session session = null; try { session = XpoHelper.GetNewSession(); //Finds ManufacturerOrg by Id ManufacturerOrg manufacturerOrg = session.GetObjectByKey <ManufacturerOrg>(manufacturerOrgId); //Check foreign key constraint with Item table var itemList = manufacturerOrg.Items.Where(r => r.RowStatus > 0); if (itemList.Count() > 0) { string param0 = manufacturerOrg.Name; string param1 = itemList.First().Name; throw new Exception(String.Format("Nhà sản xuất '{0}' đang được cấu hình trong sản phẩm '{1}'", param0, param1)); } manufacturerOrg.RowStatus = Utility.Constant.ROWSTATUS_DELETED; manufacturerOrg.Save(); } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
public void ItemRequestedByValue(Session session, object source, DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e) { ASPxComboBox combo = source as ASPxComboBox; ManufacturerOrg obj = session.GetObjectByKey <ManufacturerOrg>(e.Value); if (obj != null) { combo.DataSource = new ManufacturerOrg[] { obj }; combo.DataBindItems(); } }
public override List <NASCustomFieldPredefinitionData> GetSelectedPredefinitionDataFromList(object source) { List <NASCustomFieldPredefinitionData> ret = null; Session session = null; try { session = XpoHelper.GetNewSession(); ASPxGridLookup gridlookup = source as ASPxGridLookup; var selectedIds = gridlookup.GridView .GetSelectedFieldValues("OrganizationId") .Select(r => Guid.Parse(r.ToString())); if (selectedIds != null) { ret = new List <NASCustomFieldPredefinitionData>(); foreach (var Id in selectedIds) { ManufacturerOrg manufacturerOrg = session.GetObjectByKey <ManufacturerOrg>(Id); if (manufacturerOrg != null) { NASCustomFieldPredefinitionData retItem = new NASCustomFieldPredefinitionData() { Code = manufacturerOrg.Code, Description = manufacturerOrg.Description, Name = manufacturerOrg.Name, PredefinitionType = Enum.GetName(typeof(MultiSelectionBuiltInTypeEnum), MultiSelectionBuiltInTypeEnum.MULTI_CHOICE_LIST_MANUFACTURER), RefId = manufacturerOrg.OrganizationId }; ret.Add(retItem); } } } return(ret); } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
public override List <NASCustomFieldPredefinitionData> GetPredefinitionDataOfObject(Guid objectCustomFieldId) { List <NASCustomFieldPredefinitionData> ret = null; Session session = null; try { session = XpoHelper.GetNewSession(); ObjectCustomField objectCustomField = session.GetObjectByKey <ObjectCustomField>(objectCustomFieldId); if (objectCustomField.ObjectCustomFieldDatas != null) { ret = new List <NASCustomFieldPredefinitionData>(); foreach (var data in objectCustomField.ObjectCustomFieldDatas) { PredefinitionData predefinitionData = (PredefinitionData)data.CustomFieldDataId; ManufacturerOrg manufacturerOrg = session.GetObjectByKey <ManufacturerOrg>(predefinitionData.RefId); if (manufacturerOrg != null) { NASCustomFieldPredefinitionData retItem = new NASCustomFieldPredefinitionData() { Code = manufacturerOrg.Code, Description = manufacturerOrg.Description, Name = manufacturerOrg.Name, PredefinitionType = Enum.GetName(typeof(MultiSelectionBuiltInTypeEnum), MultiSelectionBuiltInTypeEnum.MULTI_CHOICE_LIST_MANUFACTURER), RefId = manufacturerOrg.OrganizationId }; ret.Add(retItem); } } } return(ret); } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
public CustomFieldDataPreDefinitionData GetData(Guid objectCustomFieldId) { CustomFieldDataPreDefinitionData ret = null; Session session = null; try { session = XpoHelper.GetNewSession(); ObjectCustomField objectCustomField = session.GetObjectByKey <ObjectCustomField>(objectCustomFieldId); if (objectCustomField.ObjectCustomFieldDatas != null) { ret = new CustomFieldDataPreDefinitionData(); foreach (var data in objectCustomField.ObjectCustomFieldDatas) { PredefinitionData predefinitionData = (PredefinitionData)data.CustomFieldDataId; ManufacturerOrg manufacturerOrg = session.GetObjectByKey <ManufacturerOrg>(predefinitionData.RefId); if (manufacturerOrg != null) { CustomFieldDataPreDefinitionDataItem item = new CustomFieldDataPreDefinitionDataItem() { CustomFieldDataId = predefinitionData.CustomFieldDataId, PredefinitionType = predefinitionData.PredefinitionType, RefId = predefinitionData.RefId, DisplayText = manufacturerOrg.Name }; ret.Add(item); } } } return(ret); } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
public override NASCustomFieldPredefinitionData GetSelectedPredefinitionDataFromList(object source) { NASCustomFieldPredefinitionData ret = null; Session session = null; try { ASPxComboBox combo = source as ASPxComboBox; session = XpoHelper.GetNewSession(); if (combo.Value == null) { return(null); } Guid manufacturerOrgId = (Guid)combo.Value; ManufacturerOrg manufacturerOrg = session.GetObjectByKey <ManufacturerOrg>(manufacturerOrgId); if (manufacturerOrg != null) { ret = new NASCustomFieldPredefinitionData() { Code = manufacturerOrg.Code, Description = manufacturerOrg.Description, Name = manufacturerOrg.Name, PredefinitionType = Enum.GetName(typeof(SingleSelectionBuiltInTypeEnum), SingleSelectionBuiltInTypeEnum.SINGLE_CHOICE_LIST_MANUFACTURER), RefId = manufacturerOrg.OrganizationId }; } return(ret); } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
public override NASCustomFieldPredefinitionData GetPredefinitionDataOfObject(Guid objectCustomFieldId) { NASCustomFieldPredefinitionData ret = null; Session session = null; try { session = XpoHelper.GetNewSession(); ObjectCustomFieldData objectCustomFieldData = session.GetObjectByKey <ObjectCustomField>(objectCustomFieldId).ObjectCustomFieldDatas.FirstOrDefault(); if (objectCustomFieldData != null) { PredefinitionData predefinitionData = (PredefinitionData)objectCustomFieldData.CustomFieldDataId; ManufacturerOrg manufacturerOrg = session.GetObjectByKey <ManufacturerOrg>(predefinitionData.RefId); if (manufacturerOrg != null) { ret = new NASCustomFieldPredefinitionData() { Code = manufacturerOrg.Code, Description = manufacturerOrg.Description, Name = manufacturerOrg.Name, PredefinitionType = Enum.GetName(typeof(SingleSelectionBuiltInTypeEnum), SingleSelectionBuiltInTypeEnum.SINGLE_CHOICE_LIST_MANUFACTURER), RefId = manufacturerOrg.OrganizationId }; } } return(ret); } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
public AccountActor GetSelectedItem(object source) { Session session = null; try { session = XpoHelper.GetNewSession(); ASPxComboBox combo = source as ASPxComboBox; //Get selected manufacturer if (combo.Value == null) { return(null); } Guid selectedId = (Guid)combo.Value; ManufacturerOrg manufacturerOrg = session.GetObjectByKey <ManufacturerOrg>(selectedId); if (manufacturerOrg == null) { return(null); } AccountActor ret = new AccountActor() { AccountActorTypeId = session.FindObject <AccountActorType>(new BinaryOperator("Code", Enum.GetName(typeof(AccountActorTypeEnum), AccountActorTypeEnum.MANUFACTURER))).AccountActorTypeId, Code = manufacturerOrg.Code, Description = manufacturerOrg.Description, Name = manufacturerOrg.Name, RefId = manufacturerOrg.OrganizationId }; return(ret); } catch (Exception) { return(null); } finally { if (session != null) { session.Dispose(); } } }
public void collectData() { currentItem = session.GetObjectByKey <Item>(ItemId); if (currentItem != null) { currentItem.Code = txtProductCode.Text; currentItem.Name = txtProductName.Text; currentItem.Description = HtmlEditDescription.Html; currentItem.RowStatus = cboProductRowStatus.SelectedItem != null? short.Parse(cboProductRowStatus.SelectedItem.Value.ToString()) : short.Parse("1"); //if (cboProductManufacturer.SelectedIndex == -1) { // throw new Exception("Vui lòng chọn nhà sản xuất"); //} try { if (cboProductManufacturer.SelectedItem != null) { ManufacturerOrg manufacturer = session.GetObjectByKey <ManufacturerOrg>( Guid.Parse( cboProductManufacturer.SelectedItem.GetValue("OrganizationId").ToString() )); if (manufacturer != null) { currentItem.ManufacturerOrgId = manufacturer; } } } catch (Exception) { } selectedObjectTypeId = new List <Guid>(); foreach (ListEditItem l in lbType.Items) { if (l.Selected) { selectedObjectTypeId.Add(Guid.Parse(l.Value.ToString())); } } } }
public void Populate(string dataFilePath) { string filePath = dataFilePath; string connStr = Utils.GetOleConnectionString(filePath, true); string dataSheetName = "dmnoisanxuat"; OleDbConnection connection = null; try { connection = new OleDbConnection(connStr); connection.Open(); OleDbCommand command = new OleDbCommand("select * from [" + dataSheetName + "$]", connection); List <OrganizationEntity> organizationEntityList = new List <OrganizationEntity>(); using (OleDbDataReader dr = command.ExecuteReader()) { while (dr.Read()) { //Collect data OrganizationEntity organizationEntity = new OrganizationEntity() { Code = (string)Utils.ConvertToNullIfDbNull(dr["Code"]), Name = (string)Utils.ConvertToNullIfDbNull(dr["Name"]) }; organizationEntityList.Add(organizationEntity); } } using (Session session = XpoHelper.GetNewSession()) { //Populate NAAN_DEFAULT data Util.Populate(); foreach (var organizationEntity in organizationEntityList) { try { //Check required if (organizationEntity.Code == null || organizationEntity.Code.Trim().Length == 0) { continue; } //Check dupplicate code bool isExist = NAS.DAL.Util.isExistXpoObject <NAS.DAL.Nomenclature.Organization.ManufacturerOrg> ("Code", organizationEntity.Code, Constant.ROWSTATUS_ACTIVE, Constant.ROWSTATUS_DEFAULT, Constant.ROWSTATUS_INACTIVE); if (isExist) { continue; } //Get default organization type OrganizationType defaultOrganizationType = Util.getXPCollection <OrganizationType>(session, "Code", "NAAN_DEFAULT").FirstOrDefault(); ManufacturerOrg manufacturerOrg = new ManufacturerOrg(session) { Code = organizationEntity.Code, Name = organizationEntity.Name, RowStatus = Constant.ROWSTATUS_ACTIVE, RowCreationTimeStamp = DateTime.Now }; manufacturerOrg.Save(); } catch (Exception ex) { } } } } catch (Exception ex) { } finally { if (connection != null) { connection.Dispose(); } } }
public void InsertItems(List <ItemEntity> itemEntityList, string itemTradingTypeName, string objectTypeName) { using (UnitOfWork uow = XpoHelper.GetNewUnitOfWork()) { foreach (var itemEntity in itemEntityList) { try { if (itemEntity.Code.Equals("EVE006")) { string debug = "Y"; } //Check required if (itemEntity.Code == null || itemEntity.Code.Trim().Length == 0) { continue; } //Check dupplicate code bool isExist = NAS.DAL.Util.isExistXpoObject <NAS.DAL.Nomenclature.Item.Item> ("Code", itemEntity.Code, Constant.ROWSTATUS_ACTIVE, Constant.ROWSTATUS_DEFAULT, Constant.ROWSTATUS_INACTIVE); if (isExist) { continue; } //Get item trading type ItemTradingType itemTradingType = Util.getXPCollection <ItemTradingType>(uow, "Name", itemTradingTypeName).FirstOrDefault(); //Get Manufacturer ManufacturerOrg manufacturerOrg = Util.getXPCollection <ManufacturerOrg>(uow, "Code", itemEntity.ManufacturerCode, Constant.ROWSTATUS_ACTIVE).FirstOrDefault(); if (manufacturerOrg == null) { manufacturerOrg = Util.getDefaultXpoObject <ManufacturerOrg>(uow); } //Insert into Item table NAS.DAL.Nomenclature.Item.Item item = new NAS.DAL.Nomenclature.Item.Item(uow) { Code = itemEntity.Code, Description = itemEntity.Description, ManufacturerOrgId = manufacturerOrg, ItemTradingTypeId = itemTradingType, Name = itemEntity.Name, RowStatus = Constant.ROWSTATUS_ACTIVE, RowCreationTimeStamp = DateTime.Now }; item.Save(); //Get Supplier SupplierOrg supplierOrg = Util.getXPCollection <SupplierOrg>(uow, "Code", itemEntity.SupplierCode, Constant.ROWSTATUS_ACTIVE).FirstOrDefault(); if (supplierOrg != null) { //Insert into ItemSupplier table ItemSupplier itemSupplier = new ItemSupplier(uow) { ItemId = item, SupplierOrgId = supplierOrg }; itemSupplier.Save(); } ObjectType objectType = Util.getXPCollection <ObjectType>(uow, "Name", objectTypeName, Constant.ROWSTATUS_ACTIVE).FirstOrDefault(); if (objectType != null) { //Insert into ItemSupplier table ItemCustomType itemCustomType = new ItemCustomType(uow) { ItemId = item, ObjectTypeId = objectType }; itemCustomType.Save(); } uow.CommitChanges(); //using (Session itemUnitSession = XpoHelper.GetNewSession()) //{ // //Get UNIT relation type // ItemUnitRelationType unitRelationType = // NAS.DAL.Util.getXPCollection<ItemUnitRelationType>(itemUnitSession, "Name", "UNIT").FirstOrDefault(); // itemEntity.ItemUnits = itemEntity.ItemUnits.OrderBy(r => r.Level).ToList(); // ////Insert into ItemUnit // foreach (ItemUnitEntity itemUnitEntity in itemEntity.ItemUnits) // { // NAS.DAL.Nomenclature.Item.Item itemTemp = // NAS.DAL.Util.getXPCollection<NAS.DAL.Nomenclature.Item.Item> // (itemUnitSession, "Code", itemUnitEntity.ItemCode).FirstOrDefault(); // Unit unit = // NAS.DAL.Util.getXPCollection<Unit>(itemUnitSession, "Code", itemUnitEntity.UnitCode).FirstOrDefault(); // if (unit == null) // break; // Unit parentUnit = // NAS.DAL.Util.getXPCollection<Unit>(itemUnitSession, "Code", itemUnitEntity.ParentUnitCode).FirstOrDefault(); // ItemUnit parentItemUnit = itemTemp.ItemUnits.Where(r => r.UnitId == parentUnit).FirstOrDefault(); // ItemUnit itemUnit = new ItemUnit(itemUnitSession) // { // ItemId = itemTemp, // ItemUnitRelationTypeId = unitRelationType, // NumRequired = itemUnitEntity.NumRequired, // RowStatus = Constant.ROWSTATUS_ACTIVE, // UnitId = unit, // ParentItemUnitId = parentItemUnit, // RowCreationTimeStamp = DateTime.Now // }; // itemUnit.Save(); // } //} } catch (Exception ex) { string msg = ex.Message; } } } }
protected void popManufacturerEdit_WindowCallback(object source, DevExpress.Web.ASPxPopupControl.PopupWindowCallbackArgs e) { string[] args = e.Parameter.Split('|'); switch (args[0]) { case "new": ManufacturerOrg tempManufacturerOrg = ManufacturerOrg.InitNewRow(session); PrivateSession.Instance.ManufacturerOrgId = tempManufacturerOrg.OrganizationId; frmManufacturerEdit.DataSourceID = "dsManufacturer"; dsManufacturer.CriteriaParameters["ManufacturerOrgId"].DefaultValue = PrivateSession.Instance.ManufacturerOrgId.ToString(); ClearForm(); //Get object id //Bind data to gridview #region add manufacturer session.BeginTransaction(); try { //ObjectType ObjectType objectType = ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.MANUFACTURER); // object NAS.BO.CMS.ObjectDocument.ObjectBO objectBO = new NAS.BO.CMS.ObjectDocument.ObjectBO(); NAS.DAL.CMS.ObjectDocument.Object cmsobject = objectBO.CreateCMSObject(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.MANUFACTURER); // OrganizationObject OrganizationObject organizatoinObject = new OrganizationObject(session) { ObjectId = cmsobject, OrganizationId = tempManufacturerOrg }; organizatoinObject.Save(); // OrganizationCustomType OrganizationCustomType organizationCustomType = new OrganizationCustomType(session) { ObjectTypeId = objectType, OrganizationId = tempManufacturerOrg }; organizationCustomType.Save(); session.CommitTransaction(); } catch { session.RollbackTransaction(); } OrganizationObject organizationObject = tempManufacturerOrg.OrganizationObjects.FirstOrDefault(); grid_of_Manufacturer.CMSObjectId = organizationObject.ObjectId.ObjectId; grid_of_Manufacturer.DataBind(); #endregion //2013-11-22 Khoa.Truong DEL START //gridviewCustomFields.CMSObjectId = CurrentManufacturerOrg.ObjectId.ObjectId; //gridviewCustomFields.DataBind(); //2013-11-22 Khoa.Truong DEL END break; case "edit": ClearForm(); frmManufacturerEdit.DataSourceID = "dsManufacturer"; if (args.Length > 1) { PrivateSession.Instance.ManufacturerOrgId = Guid.Parse(args[1]); dsManufacturer.CriteriaParameters["ManufacturerOrgId"].DefaultValue = PrivateSession.Instance.ManufacturerOrgId.ToString(); txtCode.Text = CurrentManufacturerOrg.Code; //Get object id //Bind data to gridview #region edit manufacturer if (CurrentManufacturerOrg.OrganizationObjects.FirstOrDefault() == null) { session.BeginTransaction(); try { ObjectType objectType1 = ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.MANUFACTURER); // object NAS.BO.CMS.ObjectDocument.ObjectBO objectBO1 = new NAS.BO.CMS.ObjectDocument.ObjectBO(); NAS.DAL.CMS.ObjectDocument.Object cmsobject1 = objectBO1.CreateCMSObject(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.MANUFACTURER); OrganizationObject organizatoinObject1 = new OrganizationObject(session) { ObjectId = cmsobject1, OrganizationId = CurrentManufacturerOrg }; organizatoinObject1.Save(); // OrganizationCustomType OrganizationCustomType organizationCustomType1 = new OrganizationCustomType(session) { ObjectTypeId = objectType1, OrganizationId = CurrentManufacturerOrg }; organizationCustomType1.Save(); session.CommitTransaction(); } catch (Exception) { session.RollbackTransaction(); throw; } OrganizationObject organizationObject1 = CurrentManufacturerOrg.OrganizationObjects.FirstOrDefault(); grid_of_Manufacturer.CMSObjectId = organizationObject1.ObjectId.ObjectId; grid_of_Manufacturer.DataBind(); } else { OrganizationObject organizationObject1 = CurrentManufacturerOrg.OrganizationObjects.FirstOrDefault(); grid_of_Manufacturer.CMSObjectId = organizationObject1.ObjectId.ObjectId; grid_of_Manufacturer.DataBind(); } #endregion //2013-11-22 Khoa.Truong DEL START //gridviewCustomFields.CMSObjectId = CurrentManufacturerOrg.ObjectId.ObjectId; //gridviewCustomFields.DataBind(); //2013-11-22 Khoa.Truong DEL END } break; case "save": bool isSuccess = true; string recordIdStr = null; try { //Check validation if (!ASPxEdit.AreEditorsValid(pagMunufacturer, true)) { popManufacturerEdit.JSProperties.Add("cpInvalid", true); pagMunufacturer.ActiveTabIndex = 0; return; } //Logic to save data if (args.Length > 1) { //Update mode //Update general information recordIdStr = args[1]; Guid recordId = Guid.Parse(recordIdStr); ManufacturerOrg editManufacturerOrg = session.GetObjectByKey <ManufacturerOrg>(PrivateSession.Instance.ManufacturerOrgId); editManufacturerOrg.Code = txtCode.Text; editManufacturerOrg.Name = txtName.Text; editManufacturerOrg.RowStatus = short.Parse(cbRowStatus.SelectedItem.Value.ToString()); editManufacturerOrg.Save(); } else { //Insert mode ManufacturerOrg newManufacturerOrg = session.GetObjectByKey <ManufacturerOrg>(PrivateSession.Instance.ManufacturerOrgId); newManufacturerOrg.Code = txtCode.Text; newManufacturerOrg.Name = txtName.Text; newManufacturerOrg.RowStatus = short.Parse(cbRowStatus.SelectedItem.Value.ToString()); newManufacturerOrg.Save(); } } catch (Exception ex) { isSuccess = false; throw; } finally { popManufacturerEdit.JSProperties.Add("cpCallbackArgs", String.Format("{{ \"recordId\": \"{0}\", \"isSuccess\": {1} }}", recordIdStr, isSuccess.ToString().ToLower())); } break; default: break; } }
public void updateAllCommonInfoOfItem(Session session, Guid ItemId, string code, string name, Guid manufacturerId, List <Guid> objectTypeId) { ObjectBO bo = new ObjectBO(); try { session.BeginTransaction(); Item item = session.GetObjectByKey <Item>(ItemId); if (item == null) { throw new Exception(String.Format("Không tồn tại ItemId: {0} trong Item table", ItemId)); } ManufacturerOrg manu = session.GetObjectByKey <ManufacturerOrg>(manufacturerId); //Issue dropdownlist ---START //if (manu == null) // throw new Exception(String.Format("Không tồn tại ManufacturerOrgId: {0} trong Item ManufacturerOrg", manufacturerId)); //Issue dropdownlist ---END item.Code = code; item.Name = name; item.ManufacturerOrgId = manu; item.RowStatus = Utility.Constant.ROWSTATUS_ACTIVE; item.Save(); removeItemCustomTypeFromItem(session, ItemId); foreach (Guid g in objectTypeId) { addItemCustomTypeToItem(session, g, ItemId); } foreach (Guid g in objectTypeId) { if (!checkAlreadyHasObjectWithObjectType(session, ItemId, g)) { NAS.DAL.CMS.ObjectDocument.Object o = bo.CreateCMSObject(session, g); ItemObject it = new ItemObject(session); it.ObjectId = o; it.ItemId = item; it.Save(); } } for (int i = item.ItemObjects.Count - 1; i >= 0; i--) { ItemObject tmp = item.ItemObjects[i]; if (!item.ItemCustomTypes.Select(r => r.ObjectTypeId).Contains(tmp.ObjectId.ObjectTypeId)) { bo.DeleteCMSObject(session, tmp.ObjectId.ObjectId); } } //foreach (ItemObject io in item.ItemObjects) //{ // if(!item.ItemCustomTypes.Select(r => r.ObjectTypeId).Contains(io.ObjectId.ObjectTypeId)) { // bo.DeleteCMSObject(session, io.ObjectId.ObjectId); // } //} session.CommitTransaction(); } catch (Exception) { session.RollbackTransaction(); throw; } }
/// <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 { } }