public static bool GetEntityConnection(string Username, string Password, string Host, string Database, string Name, bool IntegratedSecurity)
        {
            string connectionString;
            if (IntegratedSecurity)
            {
                connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder
                {
                    Metadata = "res://*",
                    Provider = "System.Data.SqlClient",
                    ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
                    {
                        InitialCatalog = Database,
                        DataSource = Host,
                        IntegratedSecurity = true,
                        MultipleActiveResultSets = true
                    }.ConnectionString
                }.ConnectionString;
            }

            else
            {
                connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder
                {
                    Metadata = "res://*",
                    Provider = "System.Data.SqlClient",
                    ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
                    {
                        InitialCatalog = Database,
                        DataSource = Host,
                        IntegratedSecurity = false,
                        UserID = Username,
                        Password = Password,
                        MultipleActiveResultSets = true
                    }.ConnectionString
                }.ConnectionString;
            }

            try
            {
                using (var Context = new finalDBEContext(connectionString))
                {
                    Context.Database.Connection.Open();
                    Context.Database.Connection.Close();
                }

            }
            catch(Exception e)
            {
                Debug.WriteLine("Connection Failed. Message: " + e.Message);
                return false;
            }
            string BaseConnStr = connectionString;
            ConnDictionary.Add(Name, BaseConnStr.Replace(Password, "{0}"));

            ConnectionString = connectionString;
            return true;
        }
        private void MenuItemNewEmp_Click(object sender, RoutedEventArgs e)
        {
            using (var Context = new finalDBEContext())
            {

            }
        }