public static void Populate() { Session session = null; try { session = XpoHelper.GetNewSession(); //insert default data into Organization table if (!Util.isExistXpoObject <Organization>("Code", Utility.Constant.NAAN_DEFAULT_CODE)) { XPQuery <OrganizationType> organizationTypeQuery = session.Query <OrganizationType>(); OrganizationType.Populate(); OrganizationType organizationType = organizationTypeQuery.Where(r => r.Code == Utility.Constant.NAAN_DEFAULT_CODE).FirstOrDefault(); Organization organization = new Organization(session) { Code = Utility.Constant.NAAN_DEFAULT_CODE, Name = Utility.Constant.NAAN_DEFAULT_NAME, OrganizationTypeId = organizationType, Description = "", RowStatus = -1, RowCreationTimeStamp = DateTime.Now, TaxNumber = "", Address = "" }; organization.Save(); } //Insert QUASAPHARCO organization if (!Util.isExistXpoObject <Organization>("OrganizationId", Guid.Parse("D52962C2-A75D-4F6E-BE0A-FF0C07D2B80B"))) { Organization quasaparcoOrg = new Organization(session) { OrganizationId = Guid.Parse("D52962C2-A75D-4F6E-BE0A-FF0C07D2B80B"), Name = "Công ty CP TM Dược Sâm Ngọc Linh Quảng Nam", Description = "Công ty CP TM Dược Sâm Ngọc Linh Quảng Nam", Code = "QUASAPHARCO", RowCreationTimeStamp = DateTime.Now, RowStatus = Utility.Constant.ROWSTATUS_ACTIVE, OrganizationTypeId = NAS.DAL.Util.getXPCollection <OrganizationType>(session, "Name", OrganizationTypeConstant.OWNER.Value).FirstOrDefault() }; quasaparcoOrg.Save(); } } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
new public static void Populate() { Session session = null; try { session = XpoHelper.GetNewSession(); //insert default data into Organization table if (!Util.isExistXpoObject <CustomerOrg>("Code", "MACDINH")) { XPQuery <OrganizationType> organizationTypeQuery = session.Query <OrganizationType>(); OrganizationType.Populate(); OrganizationType organizationType = organizationTypeQuery.Where(r => r.Code == Utility.Constant.NAAN_DEFAULT_CODE).FirstOrDefault(); CustomerOrg customerOrg = new CustomerOrg(session) { Code = "MACDINH", Name = "Khách hàng Mặc định", OrganizationTypeId = organizationType, Description = "", RowStatus = 1, RowCreationTimeStamp = DateTime.Now }; customerOrg.Save(); } } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
new public static void Populate() { Session session = null; try { session = XpoHelper.GetNewSession(); //insert default data into Organization table session.BeginTransaction(); //if (!Util.isExistXpoObject<ManufacturerOrg>("Code", Utility.Constant.NAAN_DEFAULT_CODE)) //{ // XPQuery<OrganizationType> organizationTypeQuery = session.Query<OrganizationType>(); // OrganizationType.Populate(); // OrganizationType organizationType = // organizationTypeQuery.Where(r => r.Code == Utility.Constant.NAAN_DEFAULT_CODE).FirstOrDefault(); // ManufacturerOrg manufacturerOrg = new ManufacturerOrg(session) // { // Code = Utility.Constant.NAAN_DEFAULT_CODE, // Name = Utility.Constant.NAAN_DEFAULT_NAME, // OrganizationTypeId = organizationType, // Description = "", // RowStatus = -1, // RowCreationTimeStamp = DateTime.Now // }; // manufacturerOrg.Save(); //} if (!Util.isExistXpoObject <ManufacturerOrg>("Code", Utility.Constant.NAAN_DEFAULT_CODE_SELECTEDALL)) { XPQuery <OrganizationType> organizationTypeQuery = session.Query <OrganizationType>(); OrganizationType.Populate(); OrganizationType organizationType = organizationTypeQuery.Where(r => r.Code == Utility.Constant.NAAN_DEFAULT_CODE).FirstOrDefault(); ManufacturerOrg manufacturerOrg = new ManufacturerOrg(session) { Code = Utility.Constant.NAAN_DEFAULT_CODE_SELECTEDALL, Name = Utility.Constant.NAAN_DEFAULT_CODE_SELECTEDALL, OrganizationTypeId = organizationType, Description = "", RowStatus = Utility.Constant.ROWSTATUS_DEFAULT_SELECTEDALL, RowCreationTimeStamp = DateTime.Now }; manufacturerOrg.Save(); } session.CommitTransaction(); } catch (Exception) { session.RollbackTransaction(); throw; } finally { if (session != null) { session.Dispose(); } } }