private void buttonGO_Click(object sender, RoutedEventArgs e)
{
bool flag = false;
for (int i = 0; i < List.Count; i++)
if (List[i].val1 != -1 || List[i].val2 != -1)
{
string names = "GOST_ID,MARKA,VYTYAZHKA";
for (int j = 0; j < List.Count; j++)
names += "," + task.yAll[j].name + "_MIN," + task.yAll[j].name;
string values = "'" + textBoxGost.Text + "','" + textBoxMarka.Text + "','" + textBoxType.Text + "'";
for (int j = 0; j < List.Count; j++)
values += "," + List[j].val1.ToString(System.Globalization.CultureInfo.InvariantCulture) + "," +
List[j].val2.ToString(System.Globalization.CultureInfo.InvariantCulture);
DBWorker dbConnection = new DBWorker();
int res = dbConnection.InsertGOST(names, values);
dbConnection.CloseConnection();
if (res == 1) MessageBox.Show("Запись добавлена!");
else MessageBox.Show("Ошибка добавления!");
this.Close();
flag = true;
break;
}
if (flag == false) MessageBox.Show("Введите границы!");
}
public GostHelper()
{
InitializeComponent();
DBWorker dbConnection = new DBWorker();
task = new DataPlavka(dbConnection.GetPlavka(DbSelect.Columns, null));
for (int i = 0; i < task.yAll.Count; i++)
List.Add(new itemGrid(task.yAll[i].description, -1, -1));
dbConnection.CloseConnection();
gridGOST.ItemsSource = List;
}
//грузим регрессионную модель
private int LoadRegress(int id)
{
DBWorker dbConnection = new DBWorker();
if (dbConnection.isConnected)
{
DataTable modelTable = dbConnection.LoadModel(DbSelect.SelectReg, id);
if (W.task == null) W.task = new DataPlavka(dbConnection.GetPlavka(DbSelect.Columns, null)); //берем список параметров
if (modelTable == null)
{
if (W.modelRegress != null) W.modelRegress.buildInfo = -3;
return -1;
}
if (modelTable.Rows.Count == 0) return 0;
W.modelRegress = new RegressionModel(id);
W.modelRegress.date = Convert.ToDateTime(modelTable.Rows[0]["DATE_REG"]);
W.modelRegress.GOST = modelTable.Rows[0]["GOST_ID"].ToString();
W.modelRegress.mark = modelTable.Rows[0]["MARKA"].ToString() + " " + modelTable.Rows[0]["VYTYAZHKA"].ToString();
//W.task.GOST = W.modelRegress.GOST;
//W.task.mark = W.modelRegress.mark;
//формируем массив факторов Х
for (int i = 0; i < W.task.xAll.Count; i++)
if (modelTable.Rows[0][W.task.xAll[i].name] != System.DBNull.Value)
W.modelRegress.x.Add(i);
for (int i = 0; i < W.modelRegress.x.Count; i++) //проверяем простая или точная модель
if (modelTable.Rows[0][W.task.xAll[W.modelRegress.x[i]].name + "_F"] != System.DBNull.Value) { W.modelRegress.isUpgraded = true; break; }
if (W.modelRegress.isUpgraded)
{
W.modelRegress.typesF = new int[W.modelRegress.x.Count];
for (int i = 0; i < W.modelRegress.x.Count; i++)
W.modelRegress.typesF[i] = Convert.ToInt32(modelTable.Rows[0][W.task.xAll[W.modelRegress.x[i]].name + "_F"]);
}
for (int i = 0; i < modelTable.Rows.Count; i++) //каждая строка - модель
{
W.modelRegress.y.Add(Convert.ToInt32(modelTable.Rows[i]["Y_ID"]));
//W.task.y.Add(Convert.ToInt32(modelTable.Rows[i]["Y_ID"]));
double[] weights = new double[W.modelRegress.x.Count + 1]; //последний - свобоный ЧЛЕН
for (int j = 0; j < W.modelRegress.x.Count; j++)
weights[j] = Convert.ToDouble(modelTable.Rows[i][W.task.xAll[W.modelRegress.x[j]].name]);
weights[W.modelRegress.x.Count] = Convert.ToDouble(modelTable.Rows[i]["A"]);
RegEquation modelOne = new RegEquation(weights, Convert.ToDouble(modelTable.Rows[i]["FISHER"]),
Convert.ToDouble(modelTable.Rows[i]["FISHER_VAL"]), Convert.ToDouble(modelTable.Rows[i]["RMSERROR"]));
modelOne.descr = W.task.yAll[W.modelRegress.y[i]].description;
if (modelOne.F_test == 0) modelOne.F_test = 1.0e-16;
W.modelRegress.equation.Add(modelOne);
}
}
dbConnection.CloseConnection();
return 1;
}
public static void MyClassInitialize(TestContext testContext)
{
string testDbPath = AppDomain.CurrentDomain.BaseDirectory + @"\Files\test.sqlite.db";
// To enable tests in a virtual machine (change the letter accordingly)
if (!Char.IsLetter(testDbPath.First()))
{
testDbPath = "Z:" + testDbPath.Substring(10);
}
ConParams = new ConnectionParameters("SQLite", "SQLite Connection", "", testDbPath);
DBWorker.ConfigureDBConnection(ConParams);
DBWorker.OpenConnection();
DBWorker.BuildMetadataRepository();
Model = Serializer.Deserialize <MatrixSelectionModel>(@"Files\MatrixSelection.mpm");
}
void InitChart_AppRunsByDay(DbConnection conn, DBWorker worker)
{
DbCommand cmd = conn.CreateCommand();
string dateFormatStr = worker.GetConvertDateToStringExpression("StartTime", worker.GetDateFormatString_yyyy_mm_dd());
InitQueryForUsageReportTable("select " + dateFormatStr + " as RunDate, count(s.ID) as NumSessions, avg(" + worker.GetDateDiffExpression("StartTime", "EndTime", "s") + ") as Dur from " + svc.UsageReportTableName + " as s ", cmd, " group by " + dateFormatStr);
DataTable dt = LoadDataTableFromCommand(cmd);
AddDurationColumnFromSeconds(dt, "Duration", 2);
Chart1.DataSource = dt;
Chart1.Series["Series1"].XValueMember = "RunDate";
Chart1.Series["Series1"].YValueMembers = "NumSessions";
Chart1.Series["Series1"].Label = "#VALY\n(#PERCENT)";
Chart1.Series["Series1"].ChartType = SeriesChartType.Line;
SetAxisProperties(Chart1.ChartAreas[0].AxisX, "Number Of Runs");
ChartArea ca = Chart1.ChartAreas.Add("duration");
Series s = Chart1.Series.Add("duration");
s.ChartArea = "duration";
s.XValueMember = "RunDate";
s.YValueMembers = "Duration";
s.YValueType = ChartValueType.DateTime;
s.IsValueShownAsLabel = true;
s.LabelFormat = "HH:mm";
ca.AxisY.Minimum = 0;
ca.AxisY.LabelStyle.Format = "HH:mm";
ca.AxisY.LabelStyle.Enabled = true;
SetAxisProperties(ca.AxisX, "Avg Duration");
AlignChartAreaTo(ca, Chart1.ChartAreas[0].Name);
Chart1.DataBind();
}
public void SQLiteTests()
{
// arrange
string testDbPath = AppDomain.CurrentDomain.BaseDirectory + @"\Files\test.sqlite.db";
// To enable tests in a virtual machine (change the letter accordingly)
if (!Char.IsLetter(testDbPath.First()))
{
testDbPath = "Z:" + testDbPath.Substring(10);
}
ConnectionParameters conParams = new ConnectionParameters("SQLite", "SQLite Connection", "", testDbPath);
Assert.IsTrue(DBWorker.ConfigureDBConnection(conParams), "SQLite connection configured");
Assert.IsTrue(DBWorker.OpenConnection(), "SQLite connection opened");
Assert.IsTrue(DBWorker.IsOpen(), "SQLite connection is currently open");
Assert.IsFalse(string.IsNullOrEmpty(DBWorker.GetConnectionName()), "SQLite connection name correct.");
Assert.IsTrue(DBWorker.CloseConnection(), "SQLite connection closed");
DBWorker.Reset();
}
public BaseBot(string token, string DBConnectionString)
{
try
{
logger.Info("Creating new bot");
this.token = token;
this.DBConnectionString = DBConnectionString;
botClient = new TelegramBotClient(token);
sender_to_tg = new Sender();
dBWorker = new DBWorker(DBConnectionString);
factory = new WrapperFactory(botClient, dBWorker, token);
EventsInit();
}
catch (Exception ex)
{
logger.Error(ex);
throw ex;
}
}
public void GenerateScript(int revisionId)
{
// get the revision
var rev = _db.Revisions.Find(revisionId);
// make sure it's in progress
if (rev.RevisionStatusCode != RevisionStatuses.InProgress)
{
throw new Exception($"{rev.RevisionName} is not in progress");
}
// first update the database
DBWorker dbWorker = new DBWorker();
rev.ScriptFilename = dbWorker.ExecuteRevision(new CommitRevsionArgs()
{
Revision = rev, RevisionId = revisionId, ExcuteMigration = false
});
_db.SaveChanges();
}
static void Main(string[] args)
{
DataGenerator generator = new DataGenerator();
FileWorker fileWorker = new FileWorker(generator);
DBWorker dbWorker = new DBWorker();
//Generating files
fileWorker.GenerateFiles("D:\\Files");
//Merging files into one
Console.WriteLine(fileWorker.MergeFiles("D:\\Files", null, "ПаШа") + " strings were deleted.");
fileWorker.ProcessInfo += FileWorker_ProcessInfo;
//Saving data to DB
fileWorker.SaveData("D:\\Files\\Result.txt", dbWorker);
Console.WriteLine("Sum is: " + dbWorker.GetSumFromIntColumn());
Console.WriteLine("Median is: " + dbWorker.GetMedian());
}
public void MSSQLTests()
{
ConnectionParameters conParams = new ConnectionParameters
{
Type = "MS-SQL",
Name = "MS-SQL Connection",
Host = Settings.Default.mssql_host,
Database = Settings.Default.mssql_database,
Port = Settings.Default.mssql_port,
User = Settings.Default.mssql_user,
Password = Settings.Default.mssql_password
};
Assert.IsTrue(DBWorker.ConfigureDBConnection(conParams), "MS-SQL connection configured");
Assert.IsTrue(DBWorker.OpenConnection(), "MS-SQL connection opened");
Assert.IsTrue(DBWorker.IsOpen(), "MS-SQL connection is currently open");
Assert.IsFalse(string.IsNullOrEmpty(DBWorker.GetConnectionName()), "MS-SQL connection name correct.");
Assert.IsTrue(DBWorker.CloseConnection(), "MS-SQL connection closed");
DBWorker.Reset();
}
public static void MyClassInitialize(TestContext testContext)
{
ConParams = new ConnectionParameters
{
Type = "PostgreSQL",
Name = "PostgreSQL Connection",
Host = Settings.Default.postgresql_host,
Database = Settings.Default.postgresql_database,
Port = Settings.Default.postgresql_port,
User = Settings.Default.postgresql_user,
Password = Settings.Default.postgresql_password
};
DBWorker.ConfigureDBConnection(ConParams);
DBWorker.OpenConnection();
DBWorker.BuildMetadataRepository();
Model = Serializer.Deserialize <MatrixSelectionModel>(@"Files\PostgreResults.mpm");
}
public MapEngine(BlockingCollection<User> usersBlockingCollection
, BlockingCollection<Coordinates<User>> usersMoveCoordinatesBlockingCollection
, BlockingCollection<InfoCurrentStateMap> outInfoBlockingCollection)
{
_usersBlockingCollection = usersBlockingCollection;
_usersMoveCoordinatesBlockingCollection = usersMoveCoordinatesBlockingCollection;
_outInfoCurrentStateMap = outInfoBlockingCollection;
_dbWorker = new DBWorker();
User user1 = new User() { Id = 1, Name = "Vova" };
_users.Add(user1.Id, user1);
_usersCoordinates.Add(user1.Id, new Coordinates<User>() { Model = user1, x = spawnCoordinates.x, y = spawnCoordinates.y});
User user2 = new User() { Id = 2, Name = "Dima" };
_users.Add(user2.Id, user2);
_usersCoordinates.Add(user2.Id, new Coordinates<User>() { Model = user2, x = spawnCoordinates.x, y = spawnCoordinates.y});
TemporaryObjectPokemon monsters1 = new TemporaryObjectPokemon() { Id = Guid.NewGuid(), Name = "Pig" };
_monsters.Add(monsters1.Id, monsters1);
_monstersCoordinates.Add(monsters1.Id, new Coordinates<TemporaryObjectPokemon>() { Model = monsters1, x = spawnCoordinates.x, y = spawnCoordinates.y });
TemporaryObjectPokemon monsters2 = new TemporaryObjectPokemon() { Id = Guid.NewGuid(), Name = "Pig" };
_monsters.Add(monsters2.Id, monsters2);
_monstersCoordinates.Add(monsters2.Id, new Coordinates<TemporaryObjectPokemon>() { Model = monsters2, x = spawnCoordinates.x, y = spawnCoordinates.y });
}
public static void MyClassInitialize(TestContext testContext)
{
//Assert.Inconclusive("Oracle not yet tested");
ConParams = new ConnectionParameters
{
Type = "Oracle",
Name = "Oracle Connection",
Host = Settings.Default.oracle_host,
Database = Settings.Default.oracle_service,
Port = Settings.Default.oracle_port,
User = Settings.Default.oracle_user,
Password = Settings.Default.oracle_password
};
DBWorker.ConfigureDBConnection(ConParams);
DBWorker.OpenConnection();
DBWorker.BuildMetadataRepository();
Model = Serializer.Deserialize <MatrixSelectionModel>(@"Files\OracleResults.mpm");
}
public void UserBansTest()
{
DBWorker dBWorker = DBWorkerInit();
string bot_token_for_ban = "token1";
string bot_token2 = "token2";
string bot_token3 = "token3";
dBWorker.add_user(DateTime.UtcNow, 1, bot_token_for_ban);
dBWorker.add_user(DateTime.UtcNow, 2, bot_token_for_ban);
dBWorker.add_user(DateTime.UtcNow, 1, bot_token2);
dBWorker.add_user(DateTime.UtcNow, 1, bot_token3);
System.Threading.Thread.Sleep(500);
dBWorker.ban_user(1, 1, bot_token_for_ban);
System.Threading.Thread.Sleep(500);
bool res = dBWorker.check_user_ban(1, 1, bot_token_for_ban);
Assert.IsTrue(res);
Assert.IsFalse(dBWorker.check_user_ban(2, 1, bot_token_for_ban));
Assert.IsFalse(dBWorker.check_user_ban(2, 1, bot_token2));
Assert.IsFalse(dBWorker.check_user_ban(1, 1, bot_token3));
}
/*
* private void saveLevel (string path){
*
* FileWorker.writeLevelInFile (path, field, pictures, "Level name", "Level description");
* }*/
public void saveTask(bool asNew)
{
if (taskTitle != null && taskTitle.Length > 0)
{
Task task = new Task(taskTitle, taskDescription, field.BackgroundId, type.value);
task.setGamePictures(picturesBar.getGamePictures());
if (!asNew && DataTransfer.Task != null)
{
task.DBId = DataTransfer.Task.DBId;
}
DataTransfer.Task = task;
DataTransfer.Task.DBId = DBWorker.saveTask(task);
//DataTransfer.Task = DBWorker.loadLastAddedTask ();
showSaveMenu(false);
freez(false);
}
else
{
enterTitleError.active = true;
}
}
public string Search(string query)
{
DBWorker dbworker = new DBWorker();
List <GeneralPost> posts = dbworker.GetAllPostsByHashTag(query);
if (posts.Count != 0)
{
Pagination pag = dbworker.GetPaginations(query);
SearchResult res = new SearchResult();
res.Posts = posts;
res.InstPagination = pag.InstagrammPagination;
res.VKPagination = pag.VKPagination;
res.TwitterPagination = pag.TwitterPagination;
res.Query = query;
return(JsonConvert.SerializeObject(res));
}
AggregatorModel aggregator = new AggregatorModel();
return(JsonConvert.SerializeObject(aggregator.Search(query)));
}
public override void logToDB()
{
long?pairChatId = null;
long?pairMessageId = null;
if (linkedMessage != null)
{
pairChatId = linkedMessage.Chat.Id;
pairMessageId = linkedMessage.MessageId;
}
if (result != null)
{
foreach (Message mess in result)
{
DBWorker.add_message(DateTime.UtcNow, DateTime.UtcNow, mess.MessageId,
mess.Chat.Id, mess.From != null?((long?)mess.From.Id):null, mess.ReplyToMessage == null ? 0 : mess.ReplyToMessage.MessageId,
bot_token, mess.Text, mess.Caption, mess.Photo != null ? mess.Photo.Last().FileId : null,
mess.MediaGroupId, true, pairChatId, pairMessageId, ButtonsData: CommonFunctions.CteateReturningValuesFromKeyboard(mess.ReplyMarkup));
}
}
}
void InitChart_AppRunsWithVersion(DbConnection conn, DBWorker worker)
{
DbCommand cmd = conn.CreateCommand();
string floatToStrExpr = worker.GetConvertFloatToStringExpression("s.AppVersion", -1, 1);
InitQueryForUsageReportTable("select s.AppName+' v'+" + floatToStrExpr + " as App, count(s.ID) as NumSessions, avg(" + worker.GetDateDiffExpression("s.StartTime", "s.EndTime", "s") + ") as Dur from " + svc.UsageReportTableName + " as s ", cmd, "group by s.AppName,s.AppVersion order by count(s.ID) DESC");
DataTable dt = LoadDataTableFromCommand(cmd);
AddDurationColumnFromSeconds(dt, "Duration", 2);
Chart1.DataSource = dt;
Chart1.Series["Series1"].XValueMember = "App";
Chart1.Series["Series1"].YValueMembers = "NumSessions";
Chart1.Series["Series1"].Label = "#VALY\n(#PERCENT)";
SetAxisProperties(Chart1.ChartAreas[0].AxisX, "Number Of Runs");
ChartArea ca = Chart1.ChartAreas.Add("duration");
Series s = Chart1.Series.Add("duration");
s.ChartArea = "duration";
s.XValueMember = "App";
s.YValueMembers = "Duration";
s.YValueType = ChartValueType.DateTime;
s.IsValueShownAsLabel = true;
s.LabelFormat = "HH:mm";
ca.AxisY.Minimum = 0;
ca.AxisY.LabelStyle.Format = "HH:mm";
ca.AxisY.LabelStyle.Enabled = true;
SetAxisProperties(ca.AxisX, "Avg Duration");
AlignChartAreaTo(ca, Chart1.ChartAreas[0].Name);
Chart1.DataBind();
}
private int LoadDescret(int id)
{
DBWorker dbConnection = new DBWorker();
if (dbConnection.isConnected)
{
DataTable modelTable = dbConnection.LoadModel(DbSelect.SelectDes, id);
if (W.task == null) W.task = new DataPlavka(dbConnection.GetPlavka(DbSelect.Columns, null)); //берем список параметров
if (modelTable == null) return -1;
if (modelTable.Rows.Count == 0) return 0;
W.modelDescret = new DescrModel(id);
W.modelDescret.date = Convert.ToDateTime(modelTable.Rows[0]["DATE_DES"]);
W.modelDescret.GOST = modelTable.Rows[0]["GOST_ID"].ToString();
W.modelDescret.mark = modelTable.Rows[0]["MARKA"].ToString() + " " + modelTable.Rows[0]["VYTYAZHKA"].ToString();
//W.task.GOST = W.modelDescret.GOST;
//W.task.mark = W.modelDescret.mark;
W.modelDescret.alpha = Convert.ToDouble(modelTable.Rows[0]["ALPHA"]);
W.modelDescret.beta = Convert.ToDouble(modelTable.Rows[0]["BETA"]);
W.modelDescret.criteria = Convert.ToDouble(modelTable.Rows[0]["U"]);
string ys = modelTable.Rows[0]["YS"].ToString();
string[] ys2 = ys.Split('@');
for (int i = 0; i < ys2.Length; i++) W.modelDescret.y.Add(Convert.ToInt32(ys2[i])); //установили У
//формируем массив факторов Х
for (int i = 0; i < W.task.xAll.Count; i++)
if (modelTable.Rows[0][W.task.xAll[i].name] != System.DBNull.Value)
W.modelDescret.x.Add(i);
for (int i = 0; i < W.modelDescret.x.Count; i++)
{
double lower = Convert.ToDouble(modelTable.Rows[0][W.task.xAll[W.modelDescret.x[i]].name + "_MIN"]);
double upper = Convert.ToDouble(modelTable.Rows[0][W.task.xAll[W.modelDescret.x[i]].name]);
string descr = W.task.xAll[W.modelDescret.x[i]].description;
Conditions c = new Conditions(lower, upper, descr);
W.modelDescret.xBounds.Add(c);
}
}
dbConnection.CloseConnection();
return 1;
}
public void get_pair_message_idTest()
{
string bot_token = "token1";
DBWorker dBWorker = DBWorkerInit();
dBWorker.add_user(DateTime.UtcNow, 1, bot_token);
dBWorker.add_user(DateTime.UtcNow, 2, bot_token);
dBWorker.add_user(DateTime.UtcNow, 3, bot_token);
dBWorker.add_message(DateTime.UtcNow, DateTime.UtcNow, 1, 1, 1, 0, bot_token, text: "some text1");
dBWorker.add_message(DateTime.UtcNow, DateTime.UtcNow, 2, 1, 1, 0, bot_token, text: "some text2");
dBWorker.add_message(DateTime.UtcNow, DateTime.UtcNow, 3, 1, 1, 0, bot_token, text: "some text3");
dBWorker.add_message(DateTime.UtcNow, DateTime.UtcNow, 1, 2, 2, 0, bot_token, text: "some text1");
dBWorker.add_message(DateTime.UtcNow, DateTime.UtcNow, 2, 2, 2, 0, bot_token, text: "some text2", pair_chat_id: 1, pair_message_id: 3);
dBWorker.add_message(DateTime.UtcNow, DateTime.UtcNow, 3, 2, 2, 0, bot_token, text: "some text3");
System.Threading.Thread.Sleep(500);
Assert.AreEqual(3, dBWorker.get_pair_message_id(2, 2, bot_token));
Assert.AreEqual(2, dBWorker.get_pair_message_id(1, 3, bot_token));
Assert.IsNull(dBWorker.get_pair_message_id(1, 1, bot_token));
dBWorker.add_message(DateTime.UtcNow, DateTime.UtcNow, 2, 2, 2, 0, bot_token, text: "some text4");
Assert.AreEqual(1, dBWorker.get_pair_chat_id(2, 2, bot_token));
Assert.AreEqual(2, dBWorker.get_pair_chat_id(1, 3, bot_token));
Assert.IsNull(dBWorker.get_pair_chat_id(1, 1, bot_token));
}
void InitChart_FeatureUsageByFeature(DbConnection conn, DBWorker worker)
{
DbCommand cmd = conn.CreateCommand();
InitQueryForFeatureTable("select f.Name, count(f.Name) as NumSessions, avg(" + worker.GetDateDiffExpression("f.StartTime", "f.EndTime", "s") + ") as Dur from " + svc.UsageReportFeatureTableName + " as f ", cmd, " group by f.Name order by count(f.Name) desc;");
DataTable dt = LoadDataTableFromCommand(cmd);
AddDurationColumnFromSeconds(dt, "Duration", 2);
Chart1.DataSource = dt;
Chart1.Series["Series1"].XValueMember = "Name";
Chart1.Series["Series1"].YValueMembers = "NumSessions";
Chart1.Series["Series1"].Label = "#VALY\n(#PERCENT)";
SetAxisProperties(Chart1.ChartAreas[0].AxisX, "Feature Usage Count");
ChartArea ca = Chart1.ChartAreas.Add("duration");
Series s = Chart1.Series.Add("duration");
s.ChartArea = "duration";
s.XValueMember = "name";
s.YValueMembers = "Duration";
s.YValueType = ChartValueType.DateTime;
s.IsValueShownAsLabel = true;
s.LabelFormat = "HH:mm:ss";
ca.AxisY.Minimum = 0;
ca.AxisY.LabelStyle.Format = "HH:mm:ss";
ca.AxisY.LabelStyle.Enabled = true;
SetAxisProperties(ca.AxisX, "Avg Duration");
AlignChartAreaTo(ca, Chart1.ChartAreas[0].Name);
Chart1.DataBind();
}
public void OracleTests()
{
// arrange
ConnectionParameters conParams = new ConnectionParameters
{
Type = "Oracle",
Name = "Oracle Connection",
Host = Settings.Default.oracle_host,
Database = Settings.Default.oracle_service,
Port = Settings.Default.oracle_port,
User = Settings.Default.oracle_user,
Password = Settings.Default.oracle_password
};
Assert.IsTrue(DBWorker.ConfigureDBConnection(conParams), "Oracle connection configured");
Assert.IsTrue(DBWorker.OpenConnection(), "Oracle connection opened");
Assert.IsTrue(DBWorker.IsOpen(), "Oracle connection is currently open");
Assert.IsFalse(string.IsNullOrEmpty(DBWorker.GetConnectionName()), "Oracle connection name correct.");
Assert.IsTrue(DBWorker.CloseConnection(), "Oracle connection closed");
Assert.IsTrue(DBWorker.TryConnection(), "Try Connection");
Assert.IsTrue(DBWorker.DisposeConnection(), "Connection disposed");
DBWorker.Reset();
}
public MainVM()
{
Players.CollectionChanged += (s, e) =>
PlayersPresentationData.OnPlayersInfoUpdate(Players.OrderByDescending(p => p.PlayerName.Length).First().PlayerName);
DBWorker dataBase = new DBWorker();
Players.AddRange(dataBase.GetAllPlayers().
Select(p => new PlayerDataVM(p)).
ToList());
int playersCount = Players.Count;
for (int i = 0; i < MIN_PLAYERS_COUNT - playersCount; ++i)
{
Players.Add(new PlayerDataVM(new Player(
"Player " + (Players.Count + 1).ToString(),
0,
Players.Count >= _defaultPlayerColours.Length ? Color.FromRgb(125, 125, 125) : _defaultPlayerColours[Players.Count]
)));
}
Players.LinkActionToPlayerDataList(Player_OnPlayerSelected);
ChangePointsVM.OnPlayerPointsChanged += ChangePointsVM_OnPlayerPointsChanged;
}
public static void MyClassInitialize(TestContext testContext)
{
string testDbPath = AppDomain.CurrentDomain.BaseDirectory + @"\Files\test.sqlite.db";
// To enable tests in a virtual machine (change the letter accordingly)
if (!Char.IsLetter(testDbPath.First()))
{
testDbPath = "Z:" + testDbPath.Substring(10);
}
ConParams = new ConnectionParameters("SQLite", "SQLite Connection", "", testDbPath);
String dbDatabaseWithoutPathName = ConParams.Database.Substring(ConParams.Database.LastIndexOf(("\\"), StringComparison.Ordinal) + 1);
Path = AppDomain.CurrentDomain.BaseDirectory + @"\Metadata_" + dbDatabaseWithoutPathName + "@" + ConParams.Host + ".xml";
DBWorker.ConfigureDBConnection(ConParams);
DBWorker.OpenConnection();
DBWorker.BuildMetadataRepository();
XMLHelper.SerializeObjectToXML(Path, DBWorker.MetaData);
XmlMetadata = XMLHelper.DeserializeObjectFromXML <MetaDataRepository>(Path);
}
public DataSelect(TaskConfig w)
{
InitializeComponent();
mainWindow = w;
dbConnection = new DBWorker();
//подключаемся к БД и извлекаем начальную инфу о параметрах и марках стали
if (dbConnection.isConnected)
{
task = new DataPlavka(dbConnection.GetPlavka(DbSelect.Columns, null));
for (int i = 0; i < task.xAll.Count; i++)
xListBox.Items.Add(task.xAll[i].description);
for (int i = 0; i < task.yAll.Count; i++)
yListBox.Items.Add(task.yAll[i].description);
DataTable dt = dbConnection.GetPlavka(DbSelect.Marks, null);
for (int i = 0; i < dt.Rows.Count; i++)
markComboBox.Items.Add(dt.Rows[i].ItemArray[0]);
gostComboBox.IsEnabled = false;
typeComboBox.IsEnabled = false;
dbConnection.CloseConnection();
}
}
/// <summary>
/// Test the Database-Connection.
/// </summary>
/// <param Name="sender"></param>
/// <param Name="e"></param>
/// <author>Bernhard Bruns</author>
private void TestConnectionClick(object sender, RoutedEventArgs e)
{
Cursor = Cursors.Wait;
ConnectionParameters connectionParameters = new ConnectionParameters();
connectionParameters.Type = DBTypeComboBox.SelectedItem.ToString();
connectionParameters.Name = DBConnectionnameTextBox.Text;
connectionParameters.User = DBUsernameTextBox.Text;
connectionParameters.Password = DBPasswordPasswordBox.Password;
connectionParameters.Host = DBHostnameTextBox.Text;
connectionParameters.Database = DBDatabaseTextBox.Text;
connectionParameters.Port = DBPortTextBox.Text;
try
{
if (DBWorker.ConfigureDBConnection(connectionParameters))
{
if (DBWorker.OpenConnection())
{
ModernDialog.ShowMessage("The connection to " + connectionParameters.Host + " is established.", "Connection", MessageBoxButton.OK);
}
else
{
ErrorHandling.ReportErrorToUser("The connection could not be established.");
}
}
else
{
ModernDialog.ShowMessage("The connection could not be established. It's probably not implemented yet.", "Error: Implementation missing", MessageBoxButton.OK);
}
}
catch (NoParamsGivenException ex)
{
ModernDialog.ShowMessage(ex.ExceptionMessage, "Error: Missing parameters", MessageBoxButton.OK);
}
catch (ConnectionTypeNotGivenException ex)
{
ModernDialog.ShowMessage(ex.ExceptionMessage, "Error: No connection Type", MessageBoxButton.OK);
}
catch (NoConnectionException ex)
{
ModernDialog.ShowMessage(ex.ExceptionMessage, "Error: No connection", MessageBoxButton.OK);
}
catch (UnauthorizedAccessException ex)
{
ModernDialog.ShowMessage(ex.Message, "Error: Access denied ", MessageBoxButton.OK);
}
catch (WrongCredentialsException ex)
{
ModernDialog.ShowMessage(ex.ExceptionMessage, "Error: Wrong credentials", MessageBoxButton.OK);
}
catch (DatabaseDoesNotExist ex)
{
ModernDialog.ShowMessage(ex.ExceptionMessage, "Error: Wrong database", MessageBoxButton.OK);
}
catch (TimeoutException ex)
{
ModernDialog.ShowMessage(ex.Message, "Error: Timeout", MessageBoxButton.OK);
}
catch (DBException ex)
{
ModernDialog.ShowMessage(ex.Message, "Error: Unknown", MessageBoxButton.OK);
}
finally
{
Cursor = Cursors.Arrow;
}
}
public static List <Pagination> Cash(string cashquery, int countofpages)
{
if (!Directory.Exists((Path + @"Cash\" + cashquery)))
{
Directory.CreateDirectory(Path + @"Cash\" + cashquery);
}
List <string> files = Directory.EnumerateFiles(Path + @"Cash\" + cashquery).ToList();
files.ForEach(file =>
{
File.Delete(file);
});
AggregatorModel model = new AggregatorModel();
List <GeneralPost> allposts = new List <GeneralPost>();
SearchResult result = new SearchResult();
result = model.Search(cashquery);
allposts.AddRange(result.Posts);
for (int i = 0; i < countofpages - 1; i++)
{
result = model.More(cashquery, result.VKPagination, result.InstPagination, result.TwitterPagination);
if (result.Posts.Count != 0)
{
allposts.AddRange(result.Posts);
}
else
{
countofpages = i + 2;
break;
}
}
result.Posts = allposts;
List <Thread> imageThreads = new List <Thread>();
imageNum = 0;
foreach (var post in result.Posts)
{
Thread imageThread = new Thread(() =>
{
post.Image = DownloadImage(post.Image, cashquery);
});
Thread avatarThread = new Thread(() =>
{
post.AuthorAvatar = DownloadImage(post.AuthorAvatar, cashquery);
});
imageThreads.Add(avatarThread);
imageThreads.Add(imageThread);
avatarThread.Start();
imageThread.Start();
}
foreach (Thread thread in imageThreads)
{
thread.Join();
}
DBWorker dbworker = new DBWorker();
dbworker.DeleteAllPostsByHashTag(null);
dbworker.DeleteAllPostsByHashTag(cashquery);
dbworker.DeletePagination(cashquery);
dbworker.AddAllPosts(result.Posts, cashquery);
dbworker.AddPagination(new Pagination()
{
DateOfAdd = DateTime.Now,
CountOfPages = countofpages,
VKPagination = result.VKPagination,
InstagrammPagination = result.InstPagination,
TwitterPagination = result.TwitterPagination,
HashTag = cashquery
});
return(dbworker.GetAllPagination());
}
public BaseServiceDB()
{
_dbWorker = new DBWorker();
}
private void markComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (markComboBox.SelectedIndex != -1)
{
DBWorker dbConnection = new DBWorker();
if (dbConnection.isConnected)
{
DataTable dt = dbConnection.GetPlavka(DbSelect.GOSTS, markComboBox.SelectedItem.ToString());
gostComboBox.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
gostComboBox.Items.Add(dt.Rows[i].ItemArray[0]);
gostComboBox.IsEnabled = true;
typeComboBox.IsEnabled = false;
typeComboBox.Items.Clear();
}
dbConnection.CloseConnection();
}
}
private void view_Click(object sender, RoutedEventArgs e)
{
DBWorker dbConnection = new DBWorker();
DataTable res = new DataTable();
if (dbConnection.isConnected)
{
if (radioLoadReg.IsChecked == true) res = dbConnection.ViewAvaliableModels(DbSelect.SelectReg);
if (radioLoadDes.IsChecked == true) res = dbConnection.ViewAvaliableModels(DbSelect.SelectDes);
if (radioLoadOpt.IsChecked == true) res = dbConnection.ViewAvaliableModels(DbSelect.SelectTech);
}
Window viewer = new Window();
viewer.MaxHeight = 600;
viewer.MaxWidth = 900;
DataGrid dg = new DataGrid();
dg.ItemsSource = res.AsDataView();
viewer.SizeToContent = System.Windows.SizeToContent.WidthAndHeight;
viewer.Content = dg;
viewer.Show();
}
private void gostComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (gostComboBox.HasItems)
{
DBWorker dbConnection = new DBWorker();
if (dbConnection.isConnected)
{
string[] conds = new string[2];
conds[0] = markComboBox.SelectedItem.ToString();
conds[1] = gostComboBox.SelectedItem.ToString();
DataTable dt = dbConnection.GetPlavka(DbSelect.SteelTypes, conds);
typeComboBox.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
typeComboBox.Items.Add(dt.Rows[i].ItemArray[0]);
typeComboBox.IsEnabled = true;
}
dbConnection.CloseConnection();
}
}
static void Main(string[] args)
{
DBWorker worker = new DBWorker();
worker.DoDatabaseWork();
}
public HomeController(SensorsContext context)
{
_context = context;
dbw = new DBWorker(_context);
dr = new DataReciever(_context);
}
public MainWindow()
{
InitializeComponent();
connection = new DBWorker();
}
private async void button1_Click(object sender, EventArgs e)
{
//валидация ip
bool isIpValid = false;
if (textBox1.Text == "")
{
isIpValid = true;
}
else
{
try
{
IPAddress.Parse(textBox1.Text);
isIpValid = true;
}
catch { }
}
if (isIpValid && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "")
{
DBWorker.SetCredentials(textBox4.Text, textBox1.Text, textBox2.Text, textBox3.Text);
bool connected = false;
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
connected = await DBWorker.Self.ConnectAsync(false);
} catch
{
}
if (!connected)
{
MessageBox.Show($"Невозможно подключится к серверу {textBox4.Text}. Проверьте данные, которые вы ввели.");
}
else
{
serverName = textBox4.Text;
ip = textBox1.Text;
userName = textBox2.Text;
password = textBox3.Text;
if (checkBox1.Checked)
{
ConfigManager.Config.server = textBox4.Text;
ConfigManager.Config.ip = textBox1.Text;
ConfigManager.Config.username = textBox2.Text;
ConfigManager.Config.password = textBox3.Text;
}
this.DialogResult = DialogResult.OK;
Close();
}
}
else
{
if (!isIpValid)
{
MessageBox.Show("IP не валидный!");
}
else
{
MessageBox.Show("Все должны обязательно быть заполннеными. IP может быть оставлен пустым, если сервер в нем не нуждается.");
}
}
}
private async void HandleNoteCommand(string[] parameters, SLRuntimeEventArgs e)
{
if (parameters.Length >= 2)
{
string option = parameters[1];
DBWorker dbWorker = new DBWorker(cDatabaseFolderPath + e.user + ".sqlite");
dbWorker.Open();
if (option.Equals("-l"))
{
List <DBNotesEntry> dbNotesEntriesList = dbWorker.SelectNotes();
if (dbNotesEntriesList.Count > 0)
{
foreach (DBNotesEntry dbNoteEntry in dbNotesEntriesList)
{
StringBuilder message = new StringBuilder("");
message.Append("Id: ");
message.Append(dbNoteEntry.id);
message.Append("\n");
message.Append("Note: ");
//string normalized = SLNormalizer.Normalize(dbNoteEntry.note);
//message.Append(normalized);
message.Append(dbNoteEntry.note);
message.Append("\n");
await slWebApiClient.ChatPostMessageAsync(e.channel, slWebApiClient.WrapWithConsoles(message.ToString()), true, true);
}
}
else
{
string message = "There is 0 notes found in database";
await slWebApiClient.ChatPostMessageAsync(e.channel, slWebApiClient.WrapWithConsoles(message), true);
}
}
else if (option.Equals("-d"))
{
if (parameters.Length >= 3)
{
string id = parameters[2];
if (dbWorker.DeleteNote(id) > 0)
{
string message = "Note " + id + " was deleted";
await slWebApiClient.ChatPostMessageAsync(e.channel, slWebApiClient.WrapWithConsoles(message.ToString()), true);
}
else
{
string message = "Note was not deleted or there is no note to delete";
await slWebApiClient.ChatPostMessageAsync(e.channel, slWebApiClient.WrapWithConsoles(message), true);
}
}
}
else if (option.Equals("-da"))
{
int deletedNotesCount = dbWorker.DeleteAllNotes();
if (deletedNotesCount > 0)
{
string message = deletedNotesCount + " notes was deleted";
await slWebApiClient.ChatPostMessageAsync(e.channel, slWebApiClient.WrapWithConsoles(message.ToString()), true);
}
else
{
string message = "Notes was not deleted or there is no notes to delete";
await slWebApiClient.ChatPostMessageAsync(e.channel, slWebApiClient.WrapWithConsoles(message), true);
}
}
else
{
string note = e.text.Substring((cNoteCommand + " ").Length);
if ((dbWorker.InsertNote(SLNormalizer.Denormalize(note))) > 0)
{
string message = "Note was added";
await slWebApiClient.ChatPostMessageAsync(e.channel, slWebApiClient.WrapWithConsoles(message.ToString()), true);
}
else
{
string message = "For some reason note was not inserted";
await slWebApiClient.ChatPostMessageAsync(e.channel, slWebApiClient.WrapWithConsoles(message), true);
}
}
dbWorker.Close();
}
}
public static void MyClassCleanup()
{
DBWorker.Reset();
}
private void saveRegModel(bool showBox)
{
DBWorker dbConnection = new DBWorker();
if (dbConnection.isConnected)
{
modelRegress.id = dbConnection.GetID(DbSelect.RegID) + 1;
if (dbConnection.InsertModel(task, modelRegress) == -1)
{
MessageBox.Show("Ошибка сохранения регрессионной модели");
modelRegress.id = -1;
}
else
{
if(showBox) MessageBox.Show("Модель успешно сохранена!");
labelRegID.Text = "ID: " + modelRegress.id.ToString();
}
}
}
private int LoadTechnology(int id)
{
DBWorker dbConnection = new DBWorker();
if (dbConnection.isConnected)
{
DataTable modelTable = dbConnection.LoadModel(DbSelect.SelectTech, id);
if (W.task == null) W.task = new DataPlavka(dbConnection.GetPlavka(DbSelect.Columns, null)); //берем список параметров
if (modelTable == null) return -1;
if (modelTable.Rows.Count == 0) return 0;
W.technology = new Technology(id);
W.technology.date = Convert.ToDateTime(modelTable.Rows[0]["DATE_TECH"]);
string[] markInfo = dbConnection.GetMark(Convert.ToInt32(modelTable.Rows[0]["STE_ID"]));
W.technology.GOST = markInfo[0];
W.technology.mark = markInfo[1] + " " + markInfo[2];
W.technology.rmserror = Convert.ToDouble(modelTable.Rows[0]["RMSERROR"]);
if (W.technology.rmserror == 0) W.technology.rmserror = 1.0e-16;
W.technology.descretID = Convert.ToInt32(modelTable.Rows[0]["DES_ID"]);
W.technology.regressID = Convert.ToInt32(modelTable.Rows[0]["REG_ID"]);
W.technology.baseTechnologyID = Convert.ToInt32(modelTable.Rows[0]["BASE_ID"]);
if (W.technology.baseTechnologyID != -1) W.technology.isCorrected = true;
//формируем массив факторов Х
for (int i = 0; i < W.task.xAll.Count; i++)
if (modelTable.Rows[0][W.task.xAll[i].name] != System.DBNull.Value)
W.technology.x.Add(i);
//формируем массив факторов Y
for (int i = 0; i < W.task.yAll.Count; i++)
if (modelTable.Rows[0][W.task.yAll[i].name] != System.DBNull.Value)
W.technology.y.Add(i);
for (int i = 0; i < W.technology.x.Count; i++)
W.technology.xOpt.Add(Convert.ToDouble(modelTable.Rows[0][W.task.xAll[W.technology.x[i]].name]));
for (int i = 0; i < W.technology.y.Count; i++)
W.technology.yOpt.Add(Convert.ToDouble(modelTable.Rows[0][W.task.yAll[W.technology.y[i]].name]));
}
dbConnection.CloseConnection();
return 1;
}
private void SetGOST()
{
string[] temp;
if(modelDescret != null) temp = modelDescret.mark.Split(' ');
else temp = task.mark.Split(' ');
string[] conds = new string[4];
conds[0] = "";
conds[1] = temp[0];
if (modelDescret != null) conds[2] = modelDescret.GOST;
else conds[2] = task.GOST;
conds[3] = temp[1];
if (modelDescret != null)
for (int i = 0; i < modelDescret.y.Count; i++)
conds[0] += task.yAll[modelDescret.y[i]].name + "," + task.yAll[modelDescret.y[i]].name + "_min,";
else
for (int i = 0; i < task.y.Count; i++)
conds[0] += task.yAll[task.y[i]].name + "," + task.yAll[task.y[i]].name + "_min,";
conds[0] = conds[0].Trim(',');
DBWorker dbConnection = new DBWorker();
DataTable res = dbConnection.GetPlavka(DbSelect.DataY, conds); //извлекаем нужные данные полностью
dbConnection.CloseConnection();
yBoundsData.Clear();
if (modelDescret != null)
for (int i = 0; i < res.Rows[0].ItemArray.Length; i = i + 2)
yBoundsData.Add(new itemGrid(task.yAll[modelDescret.y[i / 2]].description,
Convert.ToDouble(res.Rows[0].ItemArray[i + 1]),
Convert.ToDouble(res.Rows[0].ItemArray[i])));
else
for (int i = 0; i < res.Rows[0].ItemArray.Length; i = i + 2)
yBoundsData.Add(new itemGrid(task.yAll[task.y[i / 2]].description,
Convert.ToDouble(res.Rows[0].ItemArray[i + 1]),
Convert.ToDouble(res.Rows[0].ItemArray[i])));
yDescrGrid.ItemsSource = null;
yDescrGrid.ItemsSource = yBoundsData;
expanderDes.Header = conds[1] + " " + conds[2] + " " + conds[3];
labelDesGOST.Text = "Стандарт: " + conds[2];
labelDesMark.Text = "Марка: " + conds[1] + " " + conds[3];
}
private void startBtn_Click(object sender, RoutedEventArgs e)
{
isChanged = true;
if (markComboBox.Text != "" && gostComboBox.Text != "" && typeComboBox.Text != "" && xTaskListBox.HasItems && yTaskListBox.HasItems)
{
string[] columns = new string[2]; //формируем запрос на извлечение данных
task.x.Clear();
task.y.Clear();
//
for (int i = 0; i < yTaskListBox.Items.Count; i++) //записываем в задачу и sql выборку всех у
for (int j = 0; j < task.yAll.Count; j++)
if (task.yAll[j].description == yTaskListBox.Items[i].ToString())
{
columns[0] += "P." + task.yAll[j].name + ",";
task.y.Add(j);
}
for (int i = 0; i < xTaskListBox.Items.Count; i++)//записываем в задачу и sql выборку всех х
for (int j = 0; j < task.xAll.Count; j++)
if (task.xAll[j].description == xTaskListBox.Items[i].ToString())
{
columns[0] += task.xAll[j].name + ",";
task.x.Add(j);
}
task.y.Sort();
task.x.Sort();
columns[0] = columns[0].Trim(','); // удаляем последнюю запятую
columns[1] = "marka='" + markComboBox.SelectionBoxItem + "' AND gost_id='" + gostComboBox.SelectionBoxItem +
"' AND vytyazhka='" + typeComboBox.SelectionBoxItem + "' AND date_plavka > to_date('" + date1picker.Text +
"', 'dd.mm.yyyy') AND date_plavka < to_date('" + date2picker.Text + "', 'dd.mm.yyyy')"; //выбор конкретной марки стали
dbConnection = new DBWorker();
plavka = dbConnection.GetPlavka(DbSelect.Data, columns); //извлекаем нужные данные полностью
task.plavka = plavka.Copy();
for (int i = 0; i < task.plavka.Rows.Count; i++) //удаляем из данных задачи строки с пустыми значениями
for (int j = 0; j < task.plavka.Rows[i].ItemArray.Length; j++)
if (task.plavka.Rows[i].ItemArray[j].ToString() == "")
{
task.plavka.Rows.RemoveAt(i);
i--;
break;
}
labelResult.Content = "Выбрано " + plavka.Rows.Count + " записей";
labelResult2.Content = plavka.Rows.Count - task.plavka.Rows.Count + " с пустыми полями";
viewBtn.IsEnabled = true;
dbConnection.CloseConnection();
task.mark = markComboBox.SelectionBoxItem + " " + typeComboBox.SelectionBoxItem;
task.GOST = gostComboBox.SelectionBoxItem.ToString();
mainWindow.labelDataMark.Text = "Марка: " + markComboBox.SelectionBoxItem + " " + typeComboBox.SelectionBoxItem;
mainWindow.labelDataGOST.Text = "Стандарт: " + gostComboBox.SelectionBoxItem;
mainWindow.labelDataSince.Text = "C: " + date1picker.Text;
mainWindow.labelDataTo.Text = "По: " + date2picker.Text;
task.GOST = gostComboBox.SelectionBoxItem.ToString();
task.mark = markComboBox.SelectionBoxItem + " " + typeComboBox.SelectionBoxItem;
}
else labelResult.Content = "Укажите все параметры";
}
private void saveDesModel(bool showBox)
{
DBWorker dbConnection = new DBWorker();
if (dbConnection.isConnected)
{
modelDescret.id = dbConnection.GetID(DbSelect.DesID) + 1;
if (dbConnection.InsertModel(task, modelDescret) == -1)
{
MessageBox.Show("Ошибка сохранения дискретной модели");
modelDescret.id = -1;
}
else
{
if (showBox) MessageBox.Show("Модель успешно сохранена!");
labelDesID.Text = "ID: " + modelDescret.id.ToString();
}
}
}
private void dataMenuItem_Click(object sender, RoutedEventArgs e)
{
if (dataWindow == null) dataWindow = new DataSelect(this);
dataWindow.ShowDialog();
if (dataWindow.IsInitialized)
if (dataWindow.isChanged)
{
dataWindow.isChanged =false;
task = new DataPlavka(dataWindow.task);
Log.Text = "Загружено " + dataWindow.task.plavka.Rows.Count.ToString() + " записей";
labelDataNotes.Text = "Загружено записей: " + dataWindow.task.plavka.Rows.Count.ToString();
dataDataGrid.ItemsSource = null;
dataDataGrid.ItemsSource = dataWindow.task.plavka.AsDataView();
if (dataDataGrid.Columns.Count < 9)
for (int i = 0; i < dataDataGrid.Columns.Count; i++)
dataDataGrid.Columns[i].Width = new DataGridLength(1, DataGridLengthUnitType.Star);
labelDataX.Content = "Количество исследуемых факторов - " + task.x.Count;
labelDataY.Content = "Количество исследуемых свойств - " + task.y.Count;
xBoundsData.Clear();
for(int i=0; i<task.x.Count; i++)
xBoundsData.Add(new itemGrid(task.xAll[task.x[i]].description, -1, -1));
xDescrGrid.ItemsSource = xBoundsData;
markComboBox.Items.Clear();
gostComboBox.Items.Clear();
typeComboBox.Items.Clear();
typeComboBox.IsEnabled = false;
DBWorker dbConnection = new DBWorker();
DataTable dt = dbConnection.GetPlavka(DbSelect.Marks, null);
for (int i = 0; i < dt.Rows.Count; i++)
markComboBox.Items.Add(dt.Rows[i].ItemArray[0]);
dbConnection.CloseConnection();
string[] temp = task.mark.Split(' ');
SetGOST();
funcGrid.Visibility = System.Windows.Visibility.Collapsed;
statGrid.Visibility = System.Windows.Visibility.Collapsed;
groupBoxBefore.Header = "Начальные границы";
groupBoxAfter.Header = "Дискретная модель";
dataExpander.IsExpanded = true;
}
}
public WrapperFactory(TelegramBotClient client, DBWorker dBWorker, string bot_token)
{
this.client = client;
this.dBWorker = dBWorker;
this.bot_token = bot_token;
}
/// <summary>
/// Configures and opens a database connection
/// Builds the metadata repository and loads the xml-serialized metadata-file.
/// Navigates to page P2Metadata
/// </summary>
/// <param name="conParams"></param>
/// <returns></returns>
/// <author>Bernhard Bruns, Moritz Eversmann, Bernd Nottbeck</author>
public static bool EstablishDatabaseConnection(ConnectionParameters conParams)
{
try
{
if (DBWorker.ConfigureDBConnection(conParams))
{
DBWorker.OpenConnection();
MainWindow.ConnectionName = DBWorker.GetConnectionName();
DBWorker.BuildMetadataRepository();
XMLHelper.SynchronizeFactTableWithXML(conParams);
DefaultEventClassifierIsSelected = false;
if (DBWorker.MetaData.EventClassifier == "")
{
DefaultEventClassifierIsSelected = true;
if (DBWorker.MetaData.ListOfEventsTableColumnNames.Contains("PROC_DESCRIPTION"))
{
DBWorker.MetaData.EventClassifier = "PROC_DESCRIPTION";
}
else if (DBWorker.MetaData.ListOfEventsTableColumnNames.Contains("activity"))
{
DBWorker.MetaData.EventClassifier = "activity";
}
else if (DBWorker.MetaData.ListOfEventsTableColumnNames.Contains("ACTIVITY"))
{
DBWorker.MetaData.EventClassifier = "ACTIVITY";
}
else
{
DefaultEventClassifierIsSelected = false;
}
}
NavigationCommands.GoToPage.Execute("/Pages/P2metadata.xaml", null);
}
return(true);
}
catch (TypeInitializationException ex)
{
ErrorHandling.ReportErrorToUser("Error: Type initialization. " + ex.Message);
}
catch (NoParamsGivenException)
{
ErrorHandling.ReportErrorToUser("Error: No databasefields are filled.");
}
catch (DBException ex)
{
ErrorHandling.ReportErrorToUser("Database error: " + ex.Message);
}
catch (TimeoutException ex)
{
ErrorHandling.ReportErrorToUser("Database Timeout: " + ex.Message);
}
catch (Exception ex)
{
ErrorHandling.ReportErrorToUser("Error: " + ex.Message + " " + ex.StackTrace);
}
return(false);
}
private void saveTechnology(Technology tech)
{
DBWorker dbConnection = new DBWorker();
if (dbConnection.isConnected)
{
tech.id = dbConnection.GetID(DbSelect.TechID) + 1;
if (dbConnection.InsertModel(task, tech) == -1)
{
MessageBox.Show("Ошибка сохранения технологии");
tech.id = -1;
}
else
{
if (tech.isCorrected != true) MessageBox.Show("Cохранено!");
labelOptID.Text = "ID: " + tech.id.ToString();
}
}
}
