private void Btn_Save_DBSetting_Click(object sender, RoutedEventArgs e)
{
if (!checkNullable())
{
return;
}
else
{
//Create daynamic ConnectionString
var entityConnectionString = registry.BuildEntityConnection("Data Source=" +
txt_ServerName.Text.Trim() +
"; Initial Catalog=" +
txt_DBName.Text.Trim() +
"; user id=" +
txt_UserName.Text.Trim() +
"; Password="******"; Integrated Security=false");// for convert ConnectionString Ado to EntityFramwork
try
{
registry.SaveConnectionStringOnRegistry(entityConnectionString,
txt_ServerName.Text.Trim(),
txt_DBName.Text.Trim(),
txt_UserName.Text.Trim(),
pw_Password.Password);
MessageBox.Show("Connected to server successfully.",
"Set Connection",
MessageBoxButton.OK,
MessageBoxImage.Information);
this.Close();
}
catch (Exception ex)
{
// db.SP_Insert_ErrorLogs(UserInfo.UserId, ex.ToString(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "ConncectToDBWindow Page Btn_setSettingsDB_Click", UserInfo.Name + " " + UserInfo.Family, infoSystems.ComputerName, infoSystems.IpAddress);
MessageBox.Show("Error : \n\n\n" + ex.ToString());
}
finally
{
}
}
}
