public DatabaseEditor(DatabaseModel model)
{
InitializeComponent();
DatabaseModel = model;
databaseModelBindingSource.DataSource = DatabaseModel;
}
public static string GetDbContextConnectionString(DatabaseModel model, string assemblyFullName, string dbContextName)
{
EntityConnectionStringBuilder ecb = new EntityConnectionStringBuilder();
ecb.Metadata = string.Format("res://{0}/{1}.csdl|res://{0}/{1}.ssdl|res://{0}/{1}.msl",
assemblyFullName, dbContextName);
//ecb.Metadata = string.Format("res://*/{0}.csdl|res://*/{0}.ssdl|res://*/{0}.msl", dbContextName);
ecb.Provider = "System.Data.SqlClient";
ecb.ProviderConnectionString = ConnectionStringFactory.GetSqlConnectionString(model);
return ecb.ConnectionString;
}
public static string GetSqlConnectionString(DatabaseModel model)
{
SqlConnectionStringBuilder cnsb = new SqlConnectionStringBuilder();
cnsb.DataSource = model.DATASOURCE;
cnsb.InitialCatalog = model.CATALOG;
cnsb.UserID = model.USERID;
cnsb.Password = model.PASSWORD;
return cnsb.ConnectionString;
}
public void CopyTo(DatabaseModel[] array, int arrayIndex)
{
models.CopyTo(array, arrayIndex);
}
public bool Contains(DatabaseModel item)
{
return models.Contains(item);
}
public void Add(DatabaseModel item)
{
models.Add(item);
}
void MarkAsDefault(DatabaseModel model)
{
model.IsDefault = true;
PropertyChanged(this, new PropertyChangedEventArgs("DefaultDatabase"));
}
public void SetDefaultDatabaseModel(DatabaseModel model)
{
MarkAllAsNotDefault();
MarkAsDefault(model);
}
public bool Remove(DatabaseModel item)
{
return models.Remove(item);
}
public void Insert(int index, DatabaseModel item)
{
models.Insert(index, item);
}
//public IEnumerator<DatabaseModel> GetEnumerator()
//{
// return models.GetEnumerator();
//}
//IEnumerator IEnumerable.GetEnumerator()
//{
// return models.GetEnumerator();
//}
public int IndexOf(DatabaseModel item)
{
return models.IndexOf(item);
}
void UpdateSelectedDatabase(DatabaseModel dbModel)
{
SetDatabaseLabelsText(dbModel);
SetFilterLabelText("~");
string cnString = ConnectionStringFactory.GetDbContextConnectionString(dbModel, typeof(MessageLog.Data.MessageLogContext).Assembly.FullName, "MessageLogContext");
MessageLogEntries.EfConnectionString = cnString;
InitializeSelectionControls(cnString);
messageListViewer1.messageLogEntriesBindingSource.DataSource = null;
}
void SetDatabaseLabelsText(DatabaseModel dbModel)
{
databaseNameStatusLabel.Text = String.Format("Database: {0}", dbModel.DisplayName);
useridStatusLabel.Text = String.Format("UserId: {0}", dbModel.USERID);
passwordStatusLabel.Text = String.Format("Password: {0}", dbModel.PASSWORD);
}
