private UpdateManager(string serverName, string dbName, string userName, string password, bool integratedSecurity) { res = Localization.Instance.Resources; if (integratedSecurity) connectionString = string.Format("data source={0};initial catalog={1};persist security info=False;Integrated Security=SSPI;", serverName, dbName); else connectionString = string.Format("data source={0};initial catalog={1};persist security info=False;user id={2};Password={3};", serverName, dbName, userName, password); using (SqlConnection conn = new SqlConnection(connectionString)) { try { conn.Open(); } catch { throw new Exception(res.CantConnect); } parameters = new string[,] { {"%Creating table%",res.CreatingTable}, {"%Creating procedure%",res.CreatingProcedure}, {"%Updating database to version%",res.UpdateDBToVer} }; } versionList = GetVersionList(); versions = versionList.ToArray(); currVersion = GetDBVersion(); versionList.Sort(); if (versionList.Count > 0) maxVersion = versionList[versionList.Count - 1]; else maxVersion = new Version(); }
public void ResourcesLoad(string localeFileName) { using (Stream stream = getResourceStream(localeFileName)) { try { XmlSerializer serializer = new XmlSerializer(typeof(Resources)); res = (Resources)serializer.Deserialize(stream); } catch { } } }
private DBInstallManager(string serverName, string dbName, string userName, string password, bool integratedSecurity) { res = Localization.Instance.Resources; if (integratedSecurity) connectionString = string.Format("data source={0};initial catalog={1};persist security info=False;Integrated Security=SSPI;", serverName, "master"); else connectionString = string.Format("data source={0};initial catalog={1};persist security info=False;user id={2};Password={3};", serverName, "master", userName, password); using (SqlConnection conn = new SqlConnection(connectionString)) { try { conn.Open(); } catch { throw new Exception(res.CantConnect); } } parameters = new string[,] { {"%dbName%", dbName }, {"%Creating type%",res.CreatingType}, {"%Creating types%",res.CreatingTypes}, {"%Creating database%",res.CreatingDB}, {"%Creating table%",res.CreatingTable}, {"%Creating tables%",res.CreatingTables}, {"%Droping database%",res.DropingDB}, {"%Set DB version%",res.SetDBVersion}, {"%Creating relationships%",res.CreatingRel}, {"%Creating procedure%",res.CreatingProcedure}, {"%Creating view%",res.CreatingView}, {"%Creating function%",res.CreatingFunction}, {"%Add db consts%", res.AddDBConsts}, {"%Create user operation%",res.CreateUserOperation}, {"%Create user role%",res.CreateUserRole}, {"%Connect user role and operations%",res.ConnectUrOper}, {"%Create users%",res.CreateUsers}, {"%Creating indexes%",res.CreatingIndexes}, {"%Creating index%",res.CreatingIndex}, {"%Creating triggers%",res.CreatingTriggers}, {"%Creating trigger%",res.CreatingTrigger} }; }
private void saveLog() { using (SaveFileDialog fd = new SaveFileDialog()) { res = Localization.Instance.Resources; fd.Filter = string.Format("{0} (*.log)|*.log|{1} (*.*)|*.*", res.FrmMain_logFiles, res.FrmMain_allFiles); fd.FilterIndex = 0; if (fd.ShowDialog() == DialogResult.OK) { using (StreamWriter sw = new StreamWriter(fd.FileName, false, Encoding.Unicode)) { sw.Write(memoEdit.Text); } } } }
protected virtual void setLocalization() { try { Locale locale = (Locale)cbLanguage.SelectedItem; Localization.Instance.ResourcesLoad(locale); } catch { } res = Localization.Instance.Resources; lLanguage.Text = res.FrmMainl_cLanguage; btnSaveLog.Text = res.FrmMain_sbSaveLog; lPassword.Text = res.FrmMain_Password; lServerName.Text = res.FrmMain_ServerName; lUserName.Text = res.FrmMain_UserName; lDBName.Text = res.FrmMain_DBName; lIntegratedSecurity.Text = res.FrmMain_IntegratedSecurity; }