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;
}
