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(); } } }
public static void DeleteLogical(Guid customerOrgId) { Session session = null; try { session = XpoHelper.GetNewSession(); //Finds ManufacturerOrg by Id NAS.DAL.Nomenclature.Organization.Organization customerOrg = session.GetObjectByKey <NAS.DAL.Nomenclature.Organization.Organization>(customerOrgId); //Check foreign key constraint with Item table //var itemList = customerOrg.; //if (itemList.Count() > 0) //{ // string param0 = supplierOrg.Name; // string param1 = itemList.First().ItemId.Name; // throw new Exception(String.Format("Nhà cung cấp '{0}' đang được cấu hình trong hàng hóa '{1}'", param0, param1)); //} customerOrg.RowStatus = Utility.Constant.ROWSTATUS_DELETED; customerOrg.Save(); } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
protected void tList_Organization_CustomCallback(object sender, TreeListCustomCallbackEventArgs e) { string[] para = e.Argument.Split('|'); if (para[0] == "Delete") { Guid organId = Guid.Parse(para[1]); NAS.DAL.Nomenclature.Organization.Organization organ = session.GetObjectByKey <NAS.DAL.Nomenclature.Organization.Organization>(organId); organ.RowStatus = Constant.ROWSTATUS_DELETED; organ.Save(); tList_Organization.JSProperties.Add("cpRefresh", "Refresh"); } tList_Organization.DataBind(); }