private void InitializeDatabaseParameters(DatabaseWorker worker)
{
parametersGridView.Rows.Clear();
if (worker != null && worker.Parameters.Any())
{
string[] allParameterNames = worker.Parameters.Select(o => o.Name).ToArray();
this.Connection.Attributes.RemoveAll(o => !allParameterNames.Contains(o.Key));
foreach (DatabaseParameter parameter in worker.Parameters)
{
DataGridViewRow row = new DataGridViewRow();
string value = this.Connection.Attributes.SingleOrDefault(o => o.Key.Equals(parameter.Name)).ValueOrDefault(o => o.Value);
row.CreateCells(parametersGridView, parameter.Name, value);
row.Cells[databaseParametersNameColumn.Index].ToolTipText = parameter.Description;
row.Cells[databaseParametersValueColumn.Index].ToolTipText = parameter.Description;
parametersGridView.Rows.Add(row);
}
tabs.TabPages.Add(parametersTab);
}
else
{
this.Connection.Attributes.Clear();
tabs.TabPages.Remove(parametersTab);
}
}
public void GetUsers()
{
using (var context = new UserDbContextFactory().CreateDBContext(DATA_SOURCE, Guid.NewGuid().ToString()))
{
var databaseWorker = new DatabaseWorker(context);
const string username = "******";
var user = new User
{
Name = username
};
databaseWorker.AddUser(user);
var users = new List <User>();
for (var i = 0; i < 5; i++)
{
users.Add(new User {
Name = $"{username}{i}"
});
}
databaseWorker.AddUsers(users);
Assert.AreEqual(user.Name, databaseWorker.GetUsers(username).First().Name);
context.Database.EnsureDeleted();
}
}
private void InitFields()
{
_cloudPoints = new Point[] { };
_databaseWorker = new DatabaseWorker();
_databaseWorker.CreateDatabase(out _message);
_databaseWorker.Connect(out _message);
}
public void AddUsers()
{
using (var context = new UserDbContextFactory().CreateDBContext(DATA_SOURCE, Guid.NewGuid().ToString()))
{
var databaseWorker = new DatabaseWorker(context);
const int usersCount = 100;
var users = new List <User>();
for (var i = 0; i < usersCount; i++)
{
users.Add(new User
{
Name = Guid.NewGuid().ToString()
});
}
databaseWorker.AddUsers(users);
Assert.AreEqual(context.Users.Count(), usersCount);
context.Database.EnsureDeleted();
}
}
private void OnDatabaseTypeChanged(DatabaseWorker worker)
{
if (DatabaseTypeChanged != null)
{
DatabaseTypeChanged(this, worker);
}
}
public void GetUsersUnite()
{
var databaseWorker = new DatabaseWorker(UserContext);
const string username = "******";
var user = new User
{
Name = username
};
databaseWorker.AddUser(user);
var users = new List <User>();
for (var i = 0; i < 5; i++)
{
users.Add(new User {
Name = $"{username}{i}"
});
}
databaseWorker.AddUsers(users);
Assert.AreEqual(user.Name, databaseWorker.GetUsers(username).First().Name);
}
private void InitializeResetToDefaultDataTypes()
{
Connection connection = this.Project.UserSettings.Connections.FirstOrDefault();
if (connection != null)
{
DatabaseWorker worker = connection.GetDatabaseWorker();
resetToDefaultDataTypesButton.DropDownItems.Clear();
if (worker != null)
{
IEnumerable <DataTypeMappingConfiguration> mappings = worker.GetDataTypeMappingConfigurations();
if (!mappings.IsNullOrEmpty())
{
foreach (DataTypeMappingConfiguration config in mappings)
{
ToolStripMenuItem button = new ToolStripMenuItem(config.Language, null, resetToDefaultDataTypesButton_Click)
{
DisplayStyle = ToolStripItemDisplayStyle.Text,
Tag = config.Language
};
resetToDefaultDataTypesButton.DropDownItems.Add(button);
}
}
else
{
resetToDefaultDataTypesButton.Enabled = false;
}
}
}
}
/// <summary>
/// 转角标注
/// </summary>
/// <param name="worker">工作数据库</param>
/// <param name="direction">方向</param>
/// <param name="start">起始点</param>
/// <param name="end">终止点</param>
/// <param name="dimDistance">偏移距离</param>
/// <returns></returns>
public static RotatedDimension RotatedDimension(this DatabaseWorker worker, RotateDirection direction, Point3d start, Point3d end, double dimDistance)
{
var dim = RotatedDimension(worker, direction, start, end, dimDistance, string.Empty);
//dim.DimensionStyle=worker.
return(dim);
}
public void Upgrade(string projectPath, string userSettingsPath, ref XmlDocument projectDocument, ref XmlDocument userSettingsDocument, ref System.Xml.XmlNamespaceManager nsm)
{
//Remove elements from Connection and create connection string as text instead.
if (userSettingsDocument != null)
{
foreach (XmlElement node in userSettingsDocument.SelectNodes("//U:Connection", nsm))
{
XmlElement type = (XmlElement)node.SelectSingleNode("U:DatabaseType", nsm);
XmlElement host = (XmlElement)node.SelectSingleNode("U:Host", nsm);
XmlElement port = (XmlElement)node.SelectSingleNode("U:Port", nsm);
XmlElement database = (XmlElement)node.SelectSingleNode("U:Database", nsm);
XmlElement userID = (XmlElement)node.SelectSingleNode("U:UserId", nsm);
XmlElement password = (XmlElement)node.SelectSingleNode("U:Password", nsm);
XmlAttribute databaseTypeAttribute = userSettingsDocument.CreateAttribute("DatabaseType");
if (string.Equals(type.ValueOrDefault(o => o.InnerText), "SQLServer", StringComparison.InvariantCultureIgnoreCase))
{
string hostAndPort = null;
if (!port.ValueOrDefault(o => o.Value.IsNullOrEmpty()))
{
hostAndPort = "{0}:{1}".FormatString(host.ValueOrDefault(o => o.InnerText), port.ValueOrDefault(o => o.InnerText));
}
else
{
hostAndPort = host.ValueOrDefault(o => o.InnerText);
}
node.InnerText = "Data Source={0}; Initial Catalog={1}; User ID={2}; Password={3};".FormatString(hostAndPort, database.ValueOrDefault(o => o.InnerText), userID.ValueOrDefault(o => o.InnerText), password.ValueOrDefault(o => o.InnerText));
databaseTypeAttribute.Value = (new SqlServerWorker()).Name;
}
else
{
node.InnerText = "Host={0}; Port={1}; Database={2}; User ID={3}; Password={4};".FormatString(host.ValueOrDefault(o => o.InnerText), port.ValueOrDefault(o => o.InnerText), database.ValueOrDefault(o => o.InnerText), userID.ValueOrDefault(o => o.InnerText), password.ValueOrDefault(o => o.InnerText));
//Try to load the proper database worker to get the name.
if (type != null && !type.InnerText.IsNullOrEmpty())
{
DatabaseWorker worker = DatabaseWorkerManager.Instance[type.InnerText];
//Use the name of the worker if one exists.
if (worker != null)
{
databaseTypeAttribute.Value = worker.Name;
}
}
//Otherwise just use the value from the DatabaseType element.
databaseTypeAttribute.Value = type.InnerText;
}
//Setting InnerText (as above) will automatically remove all children from the node.
//Need to add a DatabaseType attribute.
node.Attributes.Append(databaseTypeAttribute);
}
}
}
/// <summary>
/// 转角标注
/// </summary>
/// <param name="worker">工作数据库</param>
/// <param name="direction">方向</param>
/// <param name="start">起始点</param>
/// <param name="end">终止点</param>
/// <param name="dimDistance">偏移距离</param>
/// <param name="textReplace">文字替代</param>
/// <returns></returns>
public static RotatedDimension RotatedDimension(this DatabaseWorker worker, RotateDirection direction, Point3d start, Point3d end, double dimDistance, string textReplace = "")
{
//根据位置计算参照其中一点移动指定距离
var x = Math.Abs(start.X - end.X); //水平差值
var y = Math.Abs(start.Y - end.Y); //竖直差值
var radian = 0.0;
var dimLinePoint = new Point3d();
switch (direction)
{
case RotateDirection.PX:
radian = -GRadian.Radians90;
dimLinePoint = start.X > end.X ? start + new Vector3d(dimDistance, y, 0) : end + new Vector3d(dimDistance, y, 0);
break;
case RotateDirection.NY:
radian = GRadian.Radians270;
dimLinePoint = start.X > end.X ? start + new Vector3d(x, -dimDistance, 0) : end + new Vector3d(x, -dimDistance, 0);
break;
case RotateDirection.NX:
radian = GRadian.Radians180;
dimLinePoint = start.X > end.X ? start + new Vector3d(-dimDistance, y, 0) : end + new Vector3d(-dimDistance, y, 0);
break;
case RotateDirection.PY:
radian = GRadian.Radians90;
dimLinePoint = start.X > end.X ? start + new Vector3d(x, dimDistance, 0) : end + new Vector3d(x, dimDistance, 0);
break;
}
var result = new RotatedDimension();
if (textReplace == string.Empty)
{
textReplace = result.Measurement.ToString();
}
result.Rotation = radian;
result.XLine1Point = start;
result.XLine2Point = end;
result.DimLinePoint = dimLinePoint;
result.DimensionText = textReplace;
//result.DimensionStyle=worker.
return(result);
}
void UpdateRecentFileView()
{
var db = new DatabaseWorker();
_recentOpenedFileList = new List <RecentFile>(db.LoadRecentFilesPath());
recentFileAdapter = new RecentFileAdapter(this);
recentFileAdapter.AddRecentFilesInfo(_recentOpenedFileList);
GridView grid = FindViewById <GridView>(Resource.Id.gridViewRecentFiles);
grid.Adapter = recentFileAdapter;
}
private void type_SelectedIndexChanged(object sender, EventArgs e)
{
if (!this.IsInitialized)
{
return;
}
DatabaseWorker selectedWorker = ((DatabaseWorker)typeComboBox.SelectedItem);
InitializeDatabaseParameters(selectedWorker);
OnDatabaseTypeChanged(selectedWorker);
PropertyChanged(sender, e);
}
public static MText GetMText(this DatabaseWorker worker, Point3d OP, string contents, double hight = 3.5)
{
var text = new MText()
{
Location = OP,
Contents = contents,
TextHeight = hight,
ColorIndex = ColorIndex.Green,
};
return(text);
}
public void AddUserUnite()
{
var databaseWorker = new DatabaseWorker(UserContext);
const string username = "******";
var user = new User
{
Name = username
};
databaseWorker.AddUser(user);
Assert.IsTrue(UserContext.Users.Any(u => u.Name == username));
}
public static DBText GetDBText(this DatabaseWorker worker, Point3d OP, string contents, double hight = 3.5)
{
var text = new DBText
{
Position = OP,
TextString = contents,
Height = hight,
WidthFactor = 0.7,
ColorIndex = ColorIndex.Green,
};
return(text);
}
public void Validate()
{
if (this.DatabaseType.IsNullOrEmpty())
{
throw new EmptyDatabaseWorkerSpecifiedException();
}
else
{
DatabaseWorker worker = GetDatabaseWorker();
if (worker == null)
{
throw new NonExistentDatabaseWorkerSpecifiedException("Could not locate database worker named: {0}.".FormatString(this.DatabaseType));
}
worker.ValidateConnection(this);
}
}
public void AddUser()
{
using (var context = new UserDbContextFactory().CreateDBContext(DATA_SOURCE, Guid.NewGuid().ToString()))
{
var databaseWorker = new DatabaseWorker(context);
const string username = "******";
var user = new User
{
Name = username
};
databaseWorker.AddUser(user);
Assert.IsTrue(context.Users.Any(u => u.Name == username));
context.Database.EnsureDeleted();
}
}
public override void OnListItemClick(ListView l, View v, int position, long id)
{
var fileSystemInfo = _adapter.GetItem(position);
if (fileSystemInfo.IsFile())
{
// Do something with the file. In this case we just pop some toast.
var db = new DatabaseWorker();
db.AddRecentFilePath(fileSystemInfo.FullName);
OnOpenFile(fileSystemInfo.FullName);
}
else
{
// Dig into this directory, and display it's contents
RefreshFilesList(fileSystemInfo.FullName);
}
base.OnListItemClick(l, v, position, id);
}
private void resetToDefaultDataTypesButton_Click(object sender, EventArgs e)
{
Connection connection = this.Project.UserSettings.Connections.First();
DatabaseWorker worker = connection.GetDatabaseWorker();
if (worker != null)
{
string language = (((ToolStripItem)sender).Tag as string);
DataTypeMappingConfiguration config = worker.GetDataTypeMappingConfigurations().SingleOrDefault(o => string.Equals(o.Language, language) && string.Equals(o.DatabaseType, connection.DatabaseType));
if (config == null)
{
MessageBox.Show("No default data type mappings exist for the language and database type you have selected.");
return;
}
this.Project.DataTypeMappings.Clear();
this.Project.DataTypeMappings.AddRange(config.DataTypeMappings.Select(dtm => new DataTypeMapping(dtm.DatabaseDataType, dtm.ApplicationDataType, dtm.Nullable)));
InitializeDataTypesTab();
}
}
public void AddUsersUnite()
{
var databaseWorker = new DatabaseWorker(UserContext);
const int usersCount = 100;
var users = new List <User>();
for (var i = 0; i < usersCount; i++)
{
users.Add(new User
{
Name = Guid.NewGuid().ToString()
});
}
databaseWorker.AddUsers(users);
var databaseUsers = UserContext.Users.ToList();
Assert.IsTrue(users.All(user => databaseUsers.Contains(user)));
}
/// <summary>
/// Создает объект Model.
/// </summary>
public Model()
{
if (!Directory.Exists(ResourceModel.DIR_RUNTIME))
{
Directory.CreateDirectory(ResourceModel.DIR_RUNTIME);
}
if (!Directory.Exists(ResourceModel.DIR_TESTS))
{
Directory.CreateDirectory(ResourceModel.DIR_TESTS);
}
// private.
_testSystem = new TestSystem();
_testSystem.Init();
_testSystem.TestFinished += TestFinishedHandler;
_databaseWorker = new DatabaseWorker();
_settingInterpol = new SettingInterpolKriging();
_regMatrixMaker = new RegMatrixMaker(new StrategyInterpolKriging(new SettingInterpolKriging()));
_settingGen = new SettingGen();
_mgAlgoritm = new CLMGAlgoritm(new SettingGen());
}
public DataController(DatabaseWorker ctx, TelemetryClient client)
{
m_worker = ctx ?? throw new ArgumentNullException(nameof(ctx));
m_telemetry = client ?? throw new ArgumentNullException(nameof(client));
}
