public static sp19TourClubEntities Connect(string userName, string password)
{
sp19TourClubEntities dbContext = null;
try
{
if (userName != null)
{
entityString = new EntityConnectionStringBuilder()
{
Provider = "System.Data.SqlClient",
Metadata = "res://*/TouristClubModel.csdl|res://*/TouristClubModel.ssdl|res://*/TouristClubModel.msl",
ProviderConnectionString = @"data source=STAS\SQLEXPRESS;initial catalog=sp19TourClub;persist security info=True;MultipleActiveResultSets=True;App=EntityFramework"
};
entityString.ProviderConnectionString += ";user id=" + userName + ";Password=" + password;
}
dbContext = new sp19TourClubEntities(entityString.ConnectionString);
if (dbContext.Database.Exists())
{
return(dbContext);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
dbContext?.Dispose();
return(null);
}
private void BtnRefresh_Click(object sender, RoutedEventArgs e)
{
try
{
this.context.Dispose();
this.context = LoginWindow.Connect(null, null);
LoadAll();
}
catch (Exception ex)
{
MessageBox.Show(GetRealException(ex).Message, "Exception", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public MainWindow(sp19TourClubEntities context)
{
this.context = context;
InitializeComponent();
}
