//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();
}
}
}