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();
}
}
}
/// <summary>
/// Load screen description
/// </summary>
/// <param name="screenCD">Screen CD</param>
/// <param name="langCD">LanguageCD that want to load.</param>
/// <param name="defaultLangCD">If not found data on the given langCD arg, it will use defaultLangCD to default.</param>
/// <returns>Screen Description.</returns>
public string LoadScreenDescriptionDependOnLanguage(string screenCD, string langCD, string defaultLangCD)
{
ILangDAO daoLang = DAOFactory.CreateLangDAO(CommonLib.Common.CurrentDatabase);
string strScreenDescription = string.Empty;
// Load screen language by given langCD argument.
strScreenDescription = daoLang.LoadScreenDescriptionByLangCD(null, screenCD, langCD);
if (String.IsNullOrEmpty(strScreenDescription))
{
// check defaultLangCD argument is empty.
if (String.IsNullOrEmpty(defaultLangCD))
{
string systemDefaultLang = daoLang.LoadSystemDefautLanguage(null);
strScreenDescription = daoLang.LoadScreenDescriptionByLangCD(null, screenCD, systemDefaultLang);
}
else
{
strScreenDescription = daoLang.LoadScreenDescriptionByLangCD(null, screenCD, defaultLangCD);
}
}
return(strScreenDescription);
}
/// <summary>
/// Load system default language from database.
/// </summary>
/// <returns>language code.</returns>
public string LoadSystemDefaultLanguage()
{
ILangDAO dao = DAOFactory.CreateLangDAO(CommonLib.Common.CurrentDatabase);
return(dao.LoadSystemDefautLanguage(null));
}
public List <LangDTO> LoadAll()
{
ILangDAO dao = DAOFactory.CreateLangDAO(CommonLib.Common.CurrentDatabase);
return(dao.LoadAll(null));
}
