public LookupData LoadLookup(bool orderByKey)
{
ILangDAO dao = DAOFactory.CreateLangDAO(CommonLib.Common.CurrentDatabase);
List <LangDTO> dtos = dao.LoadAll(null, orderByKey);
return(new LookupData(DTOUtility.ConvertListToDataTable(dtos),
LangDTO.eColumns.LANG_NAME.ToString(),
LangDTO.eColumns.LANG_CD.ToString()));
}
/// <summary>
/// Save new menu sub.
/// </summary>
/// <param name="menuSubCD"></param>
/// <param name="menuSubName"></param>
/// <exception cref="EVOFramework.ValidateException"><c>ValidateException</c>.</exception>
/// <exception cref="EVOFramework.BusinessException"><c>BusinessException</c>.</exception>
public void SaveNewMenuSubDescription(NZString menuSubCD, NZString menuSubName)
{
MenuSubValidator validator = new MenuSubValidator();
validator.ValidateBeforeSaveAdd(menuSubCD, menuSubName);
Database database = CommonLib.Common.CurrentDatabase;
try {
database.KeepConnection = true;
database.BeginTransaction();
ILangDAO daoLang = DAOFactory.CreateLangDAO(database);
IMenuSubDAO daoMenuSub = DAOFactory.CreateMenuSubDAO(database);
IMenuSubLangDAO daoMenuSubLang = DAOFactory.CreateMenuSubLangDAO(database);
//== Add menu sub master.
MenuSubDTO dtoMenuSub = new MenuSubDTO();
dtoMenuSub.MENU_SUB_CD = menuSubCD;
dtoMenuSub.MENU_SUB_NAME = menuSubName;
dtoMenuSub.IMAGE_CD.Value = null;
dtoMenuSub.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoMenuSub.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoMenuSub.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoMenuSub.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
daoMenuSub.AddNew(null, dtoMenuSub);
//== Add menu sub on each language.
List <LangDTO> langs = daoLang.LoadAll(null);
for (int i = 0; i < langs.Count; i++)
{
MenuSubLangDTO dtoMenuSubLang = new MenuSubLangDTO();
dtoMenuSubLang.MENU_SUB_CD = menuSubCD;
dtoMenuSubLang.LANG_CD = langs[i].LANG_CD;
dtoMenuSubLang.MENU_SUB_DESC = menuSubName;
dtoMenuSubLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoMenuSubLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoMenuSubLang.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoMenuSubLang.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
daoMenuSubLang.AddNewOrUpdate(null, dtoMenuSubLang);
}
database.Commit();
} catch {
database.Rollback();
throw;
} finally {
if (database.DBConnectionState == ConnectionState.Open)
{
database.Close();
}
}
}
public List <LangDTO> LoadAll()
{
ILangDAO dao = DAOFactory.CreateLangDAO(CommonLib.Common.CurrentDatabase);
return(dao.LoadAll(null));
}
