private void butGetTableList_Click(object sender, RoutedEventArgs e)
{
WPFCommonControl.SqlServerLoginControl.X_CollectionData controlResult = sqlServerLoginControl1.X_Result;
string server = controlResult.Server;
string database = controlResult.DbName;
string username = controlResult.UID;
string pwd = controlResult.PWD;
if (string.IsNullOrEmpty(server) || string.IsNullOrEmpty(database) ||
string.IsNullOrEmpty(username))
{
MessageBox.Show("ImportEachElement".GetFromResourece());
return;
}
//This core will be used later , do not dispose it
core = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler;
LoginInfo_SqlServer info = new LoginInfo_SqlServer()
{
X_Server = controlResult.Server,
X_UserName = controlResult.UID,
X_Pwd = controlResult.PWD,
X_Port = sqlServerLoginControl1.X_Result.Port.ToString(),
IsTrustedConn = sqlServerLoginControl1.X_Result.IsTrust,
X_CurDbConnectionMode = sqlServerLoginControl1.X_Result.CurType.CurConnMode,
};
try
{
core.Open(info);
if (core.IsOpened)
{
this.tableList.Items.Clear();
foreach (string item in core.GetTableListInDatabase(database))
{
tableList.Items.Add(item);
}
}
}
catch (Exception ee)
{
ee.HandleMyException();
}
finally
{
}
}
private void butCreateDb_Click(object sender, RoutedEventArgs e)
{
WPFCommonControl.SqlServerLoginControl.X_CollectionData controlResult =
this.sqlServerLoginControl1.X_Result;
if (string.IsNullOrEmpty(controlResult.Server) || string.IsNullOrEmpty(controlResult.DbName) ||
string.IsNullOrEmpty(controlResult.UID))
{
"ImportEachElement".GetFromResourece().Notify();
return;
}
CreateDatabase createDbWin = new CreateDatabase();
createDbWin.Args = controlResult;
createDbWin.Show();
}
private void DoConnectCmd_Executed(object sender, ExecutedRoutedEventArgs e)
{
WPFCommonControl.SqlServerLoginControl.X_CollectionData controlResult =
this.sqlServerLoginControl1.X_Result;
if (controlResult.IsUseFileDirectly)
{
}
else
{
if (string.IsNullOrEmpty(controlResult.Server) || string.IsNullOrEmpty(controlResult.DbName) ||
string.IsNullOrEmpty(controlResult.UID))
{
"ImportEachElement".GetFromResourece().Notify();
return;
}
}
LoginInSqlServer(controlResult);
}
public void TestSchmea()
{
testContextInstance.RecordTestMethod();
WPFCommonControl.SqlServerLoginControl.X_CollectionData data = new WPFCommonControl.SqlServerLoginControl.X_CollectionData()
{
DbName = "Master",
CurType = new WPFCommonControl.SqlServerLoginControl.X_LoginDbParas()
{
CurConnMode = CoreEA.Args.CurDbServerConnMode.SqlServer2005Express,
Name = "SqlServer2008",
},
PWD = "1",
Server = "Leond-xp\\sql2008",
UID = "sa",
};
SqlServerEntry_Accessor main = new SqlServerEntry_Accessor();
main.LoginInSqlServer(data);
TestGlobalExtension.RecordTestMethod();
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void butBackupDb_Click(object sender, RoutedEventArgs e)
{
WPFCommonControl.SqlServerLoginControl.X_CollectionData controlResult =
this.sqlServerLoginControl1.X_Result;
if (string.IsNullOrEmpty(controlResult.Server) || string.IsNullOrEmpty(controlResult.DbName) ||
string.IsNullOrEmpty(controlResult.UID))
{
"ImportEachElement".GetFromResourece().Notify();
return;
}
App.MainEngineer = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler;
LoginInfo_SqlServer info = new LoginInfo_SqlServer()
{
X_Server = controlResult.Server,
X_Database = controlResult.DbName,
X_Pwd = controlResult.PWD,
X_UserName = controlResult.UID,
X_Port = controlResult.Port.ToString(),
X_CurDbConnectionMode = controlResult.CurType.CurConnMode,
IsTrustedConn = controlResult.IsTrust,
};
PageSwitchProgressBar dp = null;
try
{
App.MainEngineer.Open(info);
if (App.MainEngineer.IsOpened)
{
if (!"InfoBackupDb".GetFromResourece().Confirm())
{
return;
}
SaveFileDialog sf = new SaveFileDialog();
sf.Filter = MyGlobal.BackupDatabase_FILE_FILTER;
if ((bool)sf.ShowDialog())
{
string cmdStr = string.Format("BACKUP DATABASE {0} TO DISK = N'{1}' WITH NOFORMAT, NOINIT,NAME = N'{2}', SKIP, NOREWIND, NOUNLOAD, STATS = 10",
App.MainEngineer.CurDatabase, sf.FileName, "BackupDataFile");
IDbCommand cmd = App.MainEngineer.GetNewStringCommand(cmdStr);
cmd.CommandTimeout = int.MaxValue / 2;
dp = PageSwitchProgressBar.X_BeginLoadingDialog();
cmd.ExecuteNonQuery();
dp.X_EndLoadingDialog();
dp = null;
"InfoBackupSuccesful".GetFromResourece().Show();
}
}
}
catch (Exception ee)
{
ee.HandleMyException();
}
finally
{
if (null != dp)
{
dp.X_EndLoadingDialog();
}
App.ResetMainEngineer();
}
}
private void LoginInSqlServer(WPFCommonControl.SqlServerLoginControl.X_CollectionData controlResult)
{
try
{
App.MainEngineer = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler;
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
return;
}
LoginInfo_SqlServer info = new LoginInfo_SqlServer()
{
X_Server = controlResult.Server,
X_Database = controlResult.DbName,
X_Pwd = controlResult.PWD,
X_UserName = controlResult.UID,
X_Port = controlResult.Port.ToString(),
X_CurDbConnectionMode = controlResult.CurType.CurConnMode,
IsTrustedConn = controlResult.IsTrust,
AttchFile = controlResult.DbFileLocation,
};
try
{
App.MainEngineer.Open(info);
if (App.MainEngineer.IsOpened)
{
#region Save to Opened History Info
SqlServerObjects sqlserverItem = new SqlServerObjects();
sqlserverItem.ServerAddress = info.X_Server;
if (info.X_Port.IsNotEmpty())
{
sqlserverItem.Port = int.Parse(info.X_Port);
}
sqlserverItem.Username = info.X_UserName;
if (!SerializeClass.DatabaseHistoryInfo.SqlServerHistory.IsContainSubValue(sqlserverItem.ServerAddress))
{
HistoryObject oldObject = SerializeClass.DatabaseHistoryInfo;
oldObject.SqlServerHistory.Add(sqlserverItem);
SerializeClass.DatabaseHistoryInfo = oldObject;
}
#endregion
App.MainEngineer.CurDatabase = controlResult.DbName;
RibbionIDE ide = new RibbionIDE();
//this.Visibility = Visibility.Hidden;
//ide.Closed += (a, b) => { this.Visibility = Visibility.Visible; };
ide.Title = info.X_Server;
ide.ShowDialog();
}
}
catch (Exception ee)
{
App.ResetMainEngineer();
ee.HandleMyException();
}
}
