protected void trlDepartment_NodeInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { e.NewValues["RowCreationTimeStamp"] = DateTime.Now; e.NewValues["RowStatus"] = Constant.ROWSTATUS_ACTIVE; NAS.DAL.Nomenclature.Organization.DepartmentType departmenttype = Util.getXPCollection <NAS.DAL.Nomenclature.Organization.DepartmentType>(session, "Name", NAS.DAL.Nomenclature.Organization.DepartmentTypeConstant.NAAN_DEFAULT.Value).FirstOrDefault(); e.NewValues["DepartmentTypeId"] = departmenttype; e.NewValues["OrganizationId!Key"] = Utility.CurrentSession.Instance.AccessingOrganizationId.ToString(); string parentKey = trlDepartment.NewNodeParentKey; if (parentKey.Equals(String.Empty)) { e.NewValues["ParentDepartmentId!Key"] = trlDepartment.RootValue; } }
public static void Populate() { Session session = null; try { session = XpoHelper.GetNewSession(); //insert default data into Organization table if (!Util.isExistXpoObject <Department>("Code", Utility.Constant.NAAN_DEFAULT_CODE)) { XPQuery <Organization> organizationQuery = session.Query <Organization>(); XPQuery <DepartmentType> departmentTypeQuery = session.Query <DepartmentType>(); DepartmentType.Populate(); Organization.Populate(); Organization organization = organizationQuery.Where(r => r.Code == Utility.Constant.NAAN_DEFAULT_CODE).FirstOrDefault(); DepartmentType departmentType = departmentTypeQuery.Where(r => r.Code == Utility.Constant.NAAN_DEFAULT_CODE).FirstOrDefault(); Department department = new Department(session) { Code = Utility.Constant.NAAN_DEFAULT_CODE, Name = Utility.Constant.NAAN_DEFAULT_NAME, DepartmentTypeId = departmentType, OrganizationId = organization, Description = "", RowStatus = -1, RowCreationTimeStamp = DateTime.Now }; department.Save(); } } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
public static void Populate() { Session session = null; try { session = XpoHelper.GetNewSession(); //insert default data into DepartmentType table if (!Util.isExistXpoObject <DepartmentType>("Code", Utility.Constant.NAAN_DEFAULT_CODE)) { DepartmentType departmentType = new DepartmentType(session) { Code = Utility.Constant.NAAN_DEFAULT_CODE, Name = Utility.Constant.NAAN_DEFAULT_NAME, Description = "", RowStatus = -1, RowCreationTimeStamp = DateTime.Now }; departmentType.Save(); } //insert SUPPER_USER department type if (!Util.isExistXpoObject <DepartmentType>("Code", "SUPPER_USER")) { DepartmentType departmentType = new DepartmentType(session) { Code = "SUPPER_USER", Name = "SUPPER_USER", Description = "Quản trị viên tổ chức", RowStatus = 1, RowCreationTimeStamp = DateTime.Now }; departmentType.Save(); } //insert ORPHAN department type if (!Util.isExistXpoObject <DepartmentType>("Code", "ORPHAN")) { DepartmentType departmentType = new DepartmentType(session) { Code = "ORPHAN", Name = "ORPHAN", Description = "Chưa được phân bổ vào tổ chức", RowStatus = 1, RowCreationTimeStamp = DateTime.Now }; departmentType.Save(); } } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }