//2013-12-13 Khoa.Truong INS START public static AccountCategory GetDefault(Session session, DefaultAccountCategoryEnum code) { AccountCategory ret = null; try { ret = session.FindObject <AccountCategory>( new BinaryOperator("Code", Enum.GetName(typeof(DefaultAccountCategoryEnum), code))); return(ret); } catch (Exception) { throw; } }
//2013-12-13 Khoa.Truong INS END public static void Populate() { Session session = null; try { session = XpoHelper.GetNewSession(); //2013-12-13 Khoa.Truong INS START if (!Util.isExistXpoObject <AccountCategory>("Code", Utility.Constant.NAAN_DEFAULT_CODE)) { AccountCategory accountCategory = new AccountCategory(session) { Code = Utility.Constant.NAAN_DEFAULT_CODE, Description = Utility.Constant.NAAN_DEFAULT_CODE, RowStatus = Utility.Constant.ROWSTATUS_DEFAULT }; accountCategory.Save(); } //2013-12-13 Khoa.Truong INS START //insert default data into Organization table if (!Util.isExistXpoObject <AccountCategory>("Code", "OFFBALANCE")) { AccountCategory accountCategory = new AccountCategory(session) { Code = "OFFBALANCE", Description = "Ngoại bảng", RowStatus = +1 }; accountCategory.Save(); } if (!Util.isExistXpoObject <AccountCategory>("Code", "REVENUE")) { AccountCategory accountCategory = new AccountCategory(session) { Code = "REVENUE", Description = "Doanh thu", RowStatus = +1 }; accountCategory.Save(); } if (!Util.isExistXpoObject <AccountCategory>("Code", "EXPENSE")) { AccountCategory accountCategory = new AccountCategory(session) { Code = "EXPENSE", Description = "Chi phí", RowStatus = +1 }; accountCategory.Save(); } if (!Util.isExistXpoObject <AccountCategory>("Code", "NETINCOME")) { AccountCategory accountCategory = new AccountCategory(session) { Code = "NETINCOME", Description = "Kết quả kinh doanh", RowStatus = +1 }; accountCategory.Save(); } if (!Util.isExistXpoObject <AccountCategory>("Code", "ASSET")) { AccountCategory accountCategory = new AccountCategory(session) { Code = "ASSET", Description = "Tài sản", RowStatus = +1 }; accountCategory.Save(); } if (!Util.isExistXpoObject <AccountCategory>("Code", "LIABILITY")) { AccountCategory accountCategory = new AccountCategory(session) { Code = "LIABILITY", Description = "Nợ phải trả", RowStatus = +1 }; accountCategory.Save(); } if (!Util.isExistXpoObject <AccountCategory>("Code", "EQUITY")) { AccountCategory accountCategory = new AccountCategory(session) { Code = "EQUITY", Description = "Vốn chủ sở hữu", RowStatus = +1 }; accountCategory.Save(); } } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
//2013-12-13 Khoa.Truong INS END public static void Populate() { Session session = null; try { session = XpoHelper.GetNewSession(); //2013-12-13 Khoa.Truong INS START if (!Util.isExistXpoObject <AccountType>("Code", Utility.Constant.NAAN_DEFAULT_CODE)) { AccountCategory.Populate(); AccountCategory accountcategory = AccountCategory.GetDefault(session, DefaultAccountCategoryEnum.NAAN_DEFAULT); AccountType accountType = new AccountType(session) { AccountCategoryId = accountcategory, Code = Utility.Constant.NAAN_DEFAULT_CODE, Name = Utility.Constant.NAAN_DEFAULT_CODE, Description = Utility.Constant.NAAN_DEFAULT_CODE, RowStatus = Utility.Constant.ROWSTATUS_DEFAULT }; accountType.Save(); } //2013-12-13 Khoa.Truong INS END //insert default data into OrganizationTypeBO table if (!Util.isExistXpoObject <AccountType>("Code", "TK0")) { XPQuery <AccountCategory> accountcategoryQuery = session.Query <AccountCategory>(); AccountCategory.Populate(); AccountCategory accountcategory = accountcategoryQuery.Where(r => r.Code == "OFFBALANCE").FirstOrDefault(); AccountType accountType = new AccountType(session) { AccountCategoryId = accountcategory, Code = "TK0", Name = "TÀI KHOẢN NGOẠI BẢNG", Description = "Chi tiết theo yêu cầu quản lý", RowStatus = 1, }; accountType.Save(); } if (!Util.isExistXpoObject <AccountType>("Code", "TK1")) { XPQuery <AccountCategory> accountcategoryQuery = session.Query <AccountCategory>(); AccountCategory.Populate(); AccountCategory accountcategory = accountcategoryQuery.Where(r => r.Code == "ASSET").FirstOrDefault(); AccountType accountType = new AccountType(session) { AccountCategoryId = accountcategory, Code = "TK1", Name = "TÀI SẢN LƯU ĐỘNG", Description = "", RowStatus = 1, }; accountType.Save(); } if (!Util.isExistXpoObject <AccountType>("Code", "TK2")) { XPQuery <AccountCategory> accountcategoryQuery = session.Query <AccountCategory>(); AccountCategory.Populate(); AccountCategory accountcategory = accountcategoryQuery.Where(r => r.Code == "ASSET").FirstOrDefault(); AccountType accountType = new AccountType(session) { AccountCategoryId = accountcategory, Code = "TK2", Name = "TÀI SẢN CỐ ĐỊNH", Description = "", RowStatus = 1, }; accountType.Save(); } if (!Util.isExistXpoObject <AccountType>("Code", "TK3")) { XPQuery <AccountCategory> accountcategoryQuery = session.Query <AccountCategory>(); AccountCategory.Populate(); AccountCategory accountcategory = accountcategoryQuery.Where(r => r.Code == "LIABILITY").FirstOrDefault(); AccountType accountType = new AccountType(session) { AccountCategoryId = accountcategory, Code = "TK3", Name = "NỢ PHẢI TRẢ", Description = "", RowStatus = 1, }; accountType.Save(); } if (!Util.isExistXpoObject <AccountType>("Code", "TK4")) { XPQuery <AccountCategory> accountcategoryQuery = session.Query <AccountCategory>(); AccountCategory.Populate(); AccountCategory accountcategory = accountcategoryQuery.Where(r => r.Code == "EQUITY").FirstOrDefault(); AccountType accountType = new AccountType(session) { AccountCategoryId = accountcategory, Code = "TK4", Name = "NGUỐN VỐN CHỦ SỞ HỮU", Description = "", RowStatus = 1, }; accountType.Save(); } if (!Util.isExistXpoObject <AccountType>("Code", "TK5")) { XPQuery <AccountCategory> accountcategoryQuery = session.Query <AccountCategory>(); AccountCategory.Populate(); AccountCategory accountcategory = accountcategoryQuery.Where(r => r.Code == "REVENUE").FirstOrDefault(); AccountType accountType = new AccountType(session) { AccountCategoryId = accountcategory, Code = "TK5", Name = "DOANH THU", Description = "", RowStatus = 1, }; accountType.Save(); } if (!Util.isExistXpoObject <AccountType>("Code", "TK6")) { XPQuery <AccountCategory> accountcategoryQuery = session.Query <AccountCategory>(); AccountCategory.Populate(); AccountCategory accountcategory = accountcategoryQuery.Where(r => r.Code == "EXPENSE").FirstOrDefault(); AccountType accountType = new AccountType(session) { AccountCategoryId = accountcategory, Code = "TK6", Name = "CHI PHÍ SẢN XUẤT, KINH DOANH", Description = "", RowStatus = 1, }; accountType.Save(); } if (!Util.isExistXpoObject <AccountType>("Code", "TK7")) { XPQuery <AccountCategory> accountcategoryQuery = session.Query <AccountCategory>(); AccountCategory.Populate(); AccountCategory accountcategory = accountcategoryQuery.Where(r => r.Code == "REVENUE").FirstOrDefault(); AccountType accountType = new AccountType(session) { AccountCategoryId = accountcategory, Code = "TK7", Name = "THU NHẬP KHÁC", Description = "", RowStatus = 1, }; accountType.Save(); } if (!Util.isExistXpoObject <AccountType>("Code", "TK8")) { XPQuery <AccountCategory> accountcategoryQuery = session.Query <AccountCategory>(); AccountCategory.Populate(); AccountCategory accountcategory = accountcategoryQuery.Where(r => r.Code == "EXPENSE").FirstOrDefault(); AccountType accountType = new AccountType(session) { AccountCategoryId = accountcategory, Code = "TK8", Name = "CHI PHÍ KHÁC", Description = "", RowStatus = 1, }; accountType.Save(); } if (!Util.isExistXpoObject <AccountType>("Code", "TK9")) { XPQuery <AccountCategory> accountcategoryQuery = session.Query <AccountCategory>(); AccountCategory.Populate(); AccountCategory accountcategory = accountcategoryQuery.Where(r => r.Code == "NETINCOME").FirstOrDefault(); AccountType accountType = new AccountType(session) { AccountCategoryId = accountcategory, Code = "TK9", Name = "XÁC ĐỊNH KẾT QUẢ KINH DOANH", Description = "", RowStatus = 1, }; accountType.Save(); } } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }