/// <summary> /// Update record by using the table's primary key. /// </summary> /// <param name="database"></param> /// <param name="data">Data which to update.</param> /// <param name="oldMENU_SUB_CD">Old Key #1</param> /// <returns></returns> public int UpdateWithPK(Database database, MenuSubDTO data, NZString oldMENU_SUB_CD) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" UPDATE " + data.TableName); sb.AppendLine(" SET "); sb.AppendLine(" " + MenuSubDTO.eColumns.MENU_SUB_CD + "=:MENU_SUB_CD"); sb.AppendLine(" ," + MenuSubDTO.eColumns.IMAGE_CD + "=:IMAGE_CD"); sb.AppendLine(" ," + MenuSubDTO.eColumns.MENU_SUB_NAME + "=:MENU_SUB_NAME"); sb.AppendLine(" ," + MenuSubDTO.eColumns.UPD_BY + "=:UPD_BY"); sb.AppendLine(" ," + MenuSubDTO.eColumns.UPD_DATE + "=GETDATE()"); sb.AppendLine(" ," + MenuSubDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE"); sb.AppendLine(" WHERE "); sb.AppendLine(" " + MenuSubDTO.eColumns.MENU_SUB_CD + "=:oldMENU_SUB_CD"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("MENU_SUB_CD", DataType.VarChar, data.MENU_SUB_CD.Value); req.Parameters.Add("IMAGE_CD", DataType.VarChar, data.IMAGE_CD.Value); req.Parameters.Add("MENU_SUB_NAME", DataType.VarChar, data.MENU_SUB_NAME.Value); req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value); req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value); req.Parameters.Add("oldMENU_SUB_CD", DataType.VarChar, oldMENU_SUB_CD.Value); #endregion return(db.ExecuteNonQuery(req)); }
/// <summary> /// Check exist before manipulate data. If found record will update data. Otherwise insert new data. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNewOrUpdate(Database database, MenuSubDTO data) { Database db = UseDatabase(database); if (Exist(database, data.MENU_SUB_CD)) { return(UpdateWithoutPK(db, data)); } return(AddNew(db, data)); }
/// <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> /// Insert new record into database. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNew(Database database, MenuSubDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" INSERT INTO " + data.TableName + "("); sb.AppendLine(" " + MenuSubDTO.eColumns.MENU_SUB_CD); sb.AppendLine(" ," + MenuSubDTO.eColumns.IMAGE_CD); sb.AppendLine(" ," + MenuSubDTO.eColumns.MENU_SUB_NAME); sb.AppendLine(" ," + MenuSubDTO.eColumns.CRT_BY); sb.AppendLine(" ," + MenuSubDTO.eColumns.CRT_DATE); sb.AppendLine(" ," + MenuSubDTO.eColumns.CRT_MACHINE); sb.AppendLine(" ," + MenuSubDTO.eColumns.UPD_BY); sb.AppendLine(" ," + MenuSubDTO.eColumns.UPD_DATE); sb.AppendLine(" ," + MenuSubDTO.eColumns.UPD_MACHINE); sb.AppendLine(") VALUES("); sb.AppendLine(" :MENU_SUB_CD"); sb.AppendLine(" ,:IMAGE_CD"); sb.AppendLine(" ,:MENU_SUB_NAME"); sb.AppendLine(" ,:CRT_BY"); sb.AppendLine(" ,GETDATE()"); sb.AppendLine(" ,:CRT_MACHINE"); sb.AppendLine(" ,:UPD_BY"); sb.AppendLine(" ,GETDATE()"); sb.AppendLine(" ,:UPD_MACHINE"); sb.AppendLine(" )"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("MENU_SUB_CD", DataType.VarChar, data.MENU_SUB_CD.Value); req.Parameters.Add("IMAGE_CD", DataType.VarChar, data.IMAGE_CD.Value); req.Parameters.Add("MENU_SUB_NAME", DataType.VarChar, data.MENU_SUB_NAME.Value); req.Parameters.Add("CRT_BY", DataType.NVarChar, data.CRT_BY.Value); req.Parameters.Add("CRT_MACHINE", DataType.NVarChar, data.CRT_MACHINE.Value); req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value); req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value); #endregion return(db.ExecuteNonQuery(req)); }
public void SaveEditMenuSub(NZString menuSubCD, NZString menuSubName) { Database database = CommonLib.Common.CurrentDatabase; try { database.KeepConnection = true; database.BeginTransaction(); IMenuSubDAO daoMenuSub = DAOFactory.CreateMenuSubDAO(database); //== Update 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.UpdateWithoutPK(null, dtoMenuSub); database.Commit(); } catch { database.Rollback(); throw; } finally { if (database.DBConnectionState == ConnectionState.Open) { database.Close(); } } }