static void Main(string[] args)
{
TelegramOperator telegramOperator = new TelegramOperator("797693271:AAF2UPE8UHv9cZiBBNOm2RZa9-gPZoJmgtM");
MessageHandler messageHandler = new MessageHandler();
messageHandler.AddCommandPack(UserStates.FirstLevel, new MainPagePack());
messageHandler.AddCommandPack(UserStates.SecondLevel, new GamePagePack());
DatabaseOperator databaseOperator = new DatabaseOperator();
Mediator mediator = new Mediator(databaseOperator, telegramOperator, messageHandler);
mediator.HandleCommand(new StartReceiving()).Wait();
var musicUpdate = new MusicUpdateService(mediator);
// var exePath = AppDomain.CurrentDomain.BaseDirectory;//path to exe file
var path = @"D:\Files\Learning\__Методы\Final\NameThatTuneBot\NameThatTuneBot\NameThatTuneBot\OggTracks\";
Console.WriteLine("Add new tracks");
while (true)
{
Console.Write("Add \n Artist Name:");
var artist = Console.ReadLine();
Console.WriteLine("Track Name:");
var trackName = Console.ReadLine();
if (artist != "" && trackName != "")
{
musicUpdate.AddNewTracks(artist, path, trackName).Wait();
}
}
//Task.WaitAll();
}
public Mediator(DatabaseOperator databaseOperator, IBotServices telegramOperator, MessageHandler messageHandler)
{
this.databaseOperator = databaseOperator;
this.telegramOperator = telegramOperator;
this.telegramOperator.AddMediator(this);
this.messageHandler = messageHandler;
this.messageHandler.AddMediator(this);
}
//metoda aktualizująca listę zadań
public void UpdateTasksList(object sender, MouseButtonEventArgs e)
{
TaskOperator.ListOfTasks.Clear();
DatabaseOperator databaseOperator = new DatabaseOperator();
databaseOperator.DownloadTasks();
FillTasksList(TaskOperator.ListOfTasks);
}
private void DeleteTask(object sender, RoutedEventArgs e)
{
int id = (int)((Button)sender).Tag;
DatabaseOperator databaseOperator = new DatabaseOperator();
databaseOperator.RemoveTask(id);
UpdateTasksList(null, null);
}
/// <summary>
/// 登录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void ButtonLogin_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(txtUserName.Text) || string.IsNullOrEmpty(txtPwd.Password))
{
App.ShowException(App.GetLanguage("string11", "string11"));
return;
}
OperationReturn optReturn = DatabaseOperator.CheckUser(txtUserName.Text, txtPwd.Password);
if (!optReturn.Result)
{
string strMessageID = string.Empty;
//string strErrorMessage = "Error code :" + optReturn.Code + ". ";
string strErrorMessage = string.Format("ErrorCode:{0};\tErrorMsg:{1}", optReturn.Code, optReturn.Message);
switch (optReturn.Code)
{
case ConstDefines.Get_UserName_Pwd_Exception:
strMessageID = "string15";
strErrorMessage += optReturn.Message;
break;
case ConstDefines.UserName_Or_Pwd_Not_Exists:
strMessageID = "string12";
strErrorMessage += "User " + txtUserName + " login failed.User name does not exist or password error";
break;
case ConstDefines.Check_User_Exception:
strMessageID = "string15";
strErrorMessage += "Abnormal login process. " + optReturn.Message;
break;
case ConstDefines.User_Overdue:
strMessageID = "string14";
strErrorMessage += "The user has expired";
break;
case ConstDefines.Get_User_Role_Failed:
strMessageID = "string15";
App.WriteLog("Get user roles failed. " + optReturn.Message);
break;
case ConstDefines.User_Not_Admin:
strMessageID = "string13";
strErrorMessage += "The user entered is not an administrator role";
break;
}
App.ShowException(App.GetLanguage(strMessageID, strMessageID));
App.WriteLog(strErrorMessage);
return;
}
App.CurrUserID = long.Parse(optReturn.Data.ToString());
App.CurrUserName = txtUserName.Text;
//如果登录成功 进入主界面
MainWindow mainWin = new MainWindow();
this.Hide();
mainWin.ShowDialog();
}
private async void OnReportButtonClick(object sender, RoutedEventArgs e)
{
try
{
Button reportButton = sender as Button;
reportButton.IsEnabled = false;
ReportWindow reportWindow = new ReportWindow(await DatabaseOperator.CreateReport());
reportWindow.Closed += (s, f) => { reportButton.IsEnabled = true; };
reportWindow.Show();
}
catch (Exception ex)
{
Trace.TraceError(ex.Message);
ButtonDialog.ShowProblem();
}
}
private async Task ImportFile(Action <float> ProgressUpdate)
{
Trace.TraceInformation("File import started.");
OpenFileDialog selectFile = new OpenFileDialog
{
DefaultExt = ".txt",
Filter = "txt files (*.txt)|*.txt|All files (*.*)|*.*"
};
if (selectFile.ShowDialog() != true)
{
return;
}
int linesInFile = CountLines(selectFile.OpenFile());;
int recordsParsed = 0;
int recordsImported = 0;
int limitRecordsBatchList = 200;
Stopwatch totalTime = new Stopwatch();
totalTime.Start();
ProgressUpdate(0);
using (StreamReader reader = new StreamReader(selectFile.OpenFile()))
while (true)
{
List <Record> records = ReadRecordsToList(limitRecordsBatchList, reader);
if (records.Count <= 0)
{
break;
}
recordsParsed += records.Count;
recordsImported += await DatabaseOperator.UploadRecords(records);
ProgressUpdate(recordsParsed / (float)linesInFile);
if (records.Count < limitRecordsBatchList)
{
break;
}
}
string txt = $"Of {linesInFile} lines in file, {recordsParsed} was parsed and {recordsImported} imported.";
txt += $" Elapsed {(totalTime.ElapsedMilliseconds / 1000f):0.00}s.";
ButtonDialog.Show(txt, "Ok");
}
public void HandleMessageTest()
{
DummyBot dummyBot = new DummyBot();
MessageHandler messageHandler = new MessageHandler();
messageHandler.AddCommandPack(UserStates.FirstLevel, new MainPagePack());
messageHandler.AddCommandPack(UserStates.SecondLevel, new GamePagePack());
DatabaseOperator databaseOperator = new DatabaseOperator();
Mediator mediator = new Mediator(databaseOperator, dummyBot, messageHandler);
mediator.HandleCommand(new StartReceiving()).Wait();
var message = new NameThatTuneBot.Message.Message("Start Game", 1234567);
mediator.HandleCommand(message).Wait();
var result = new SendMainPageCommand(message);
Assert.AreEqual(result.GetType(), dummyBot.messages.Last().GetType());
}
public FormCardInfo()
{
InitializeComponent();
this.dbop = new DatabaseOperator();
tableInstanceDictionary.Add(cbxRarity.Name, new CardRarity());
tableInstanceDictionary.Add(cbxImageType.Name, new CardImageType());
tableInstanceDictionary.Add(cbxCardType.Name, new CardType());
tableInstanceDictionary.Add(cbxExpansions.Name, new CardExpansions());
tableInstanceDictionary.Add(cbxPainterName.Name, new CardPainter());
ComponentFiller.FillComboBoxItems(cbxRarity, tableInstanceDictionary[cbxRarity.Name], true);
ComponentFiller.FillComboBoxItems(cbxImageType, tableInstanceDictionary[cbxImageType.Name], false);
ComponentFiller.FillComboBoxItems(cbxCardType, tableInstanceDictionary[cbxCardType.Name], true);
ComponentFiller.FillComboBoxItems(cbxExpansions, tableInstanceDictionary[cbxExpansions.Name], true);
ComponentFiller.FillComboBoxItems(cbxPainterName, tableInstanceDictionary[cbxPainterName.Name], true);
ttpCardInfo.SetToolTip(cbxImageType, cbxImageType.Text);
SetComboBoxDropDownWidth(cbxImageType);
}
void UC_Done_Loaded(object sender, RoutedEventArgs e)
{
btnExit.Click += btnExit_Click;
if (bIsSuccess)
{
App.bIsUpgrageSuccess = true;
lblResult.Content = App.GetLanguage("string49", "string49");
//将更新后的版本号写入数据库
OperationReturn optReturn = DatabaseOperator.WriteVersionToDB();
if (!optReturn.Result)
{
App.WriteLog("Error code :" + optReturn.Code + ". WriteVersionToDB failed. " + optReturn.Message);
}
else
{
App.WriteLog("WriteVersionToDB success");
}
bIsloaded = true;
mBackgroundWorker = new BackgroundWorker();
mBackgroundWorker.DoWork += (s, de) =>
{
while (true)
{
if (bIsloaded)
{
//FOLLOW
Follow();
break;
}
}
};
mBackgroundWorker.RunWorkerCompleted += mBackgroundWorker_RunWorkerCompleted;
mBackgroundWorker.RunWorkerAsync();
}
else
{
lblResult.Content = App.GetLanguage("string51", "string51");
}
InitUpdateResultInfo(bIsSuccess);
}
//metoda odpowiedzialna za zapisywanie zmian w obiekcie (zadaniu)
private void SaveChanges(object sender, RoutedEventArgs e)
{
if (Name.Text.Length >= 3 && Description.Text.Length >= 3)
{
TaskCreator toChange = TaskOperator.FindTask((int)((Button)sender).Tag);
toChange.Name = Name.Text;
toChange.Description = Description.Text;
toChange.Priority = Priority.Text;
toChange.Status = Status.Text;
toChange.Date = Date.SelectedDate;
DatabaseOperator databaseOperator = new DatabaseOperator();
databaseOperator.UpdateTask(toChange);
//TODO sprawdzenie czy dane zostały poprawnie zapisane w bazie
Button button = sender as Button;
Popup pop = new Popup();
TextBlock popupText = new TextBlock();
popupText.Text = "Zapisano pomyślnie. Możesz zamknąć okno.";
popupText.Background = Brushes.Green;
popupText.Foreground = Brushes.White;
pop.Child = popupText;
pop.PlacementTarget = button;
pop.IsOpen = true;
mainWindow.FillTasksList(TaskOperator.ListOfTasks);
}
else
{
if (Name.Text.Length < 3)
{
Name.Background = Brushes.LightPink;
}
if (Description.Text.Length < 3)
{
Description.Background = Brushes.LightPink;
}
LengthWarning.Visibility = Visibility.Visible;
}
}
//metoda odpowiedzialna za przekazanie danych do klasy zajmującej się obróbką zadań
#region Operacje na zadaniach (związane z bazą danych)
private void SendTask(object sender, RoutedEventArgs e)
{
if (Name.Text.Length >= 3 && Description.Text.Length >= 3)
{
DatabaseOperator databaseOperator = new DatabaseOperator();
TaskCreator task = new TaskCreator(Name.Text, Description.Text, Priority.Text, Date.SelectedDate, Status.Text);
databaseOperator.SendTask(task);
ClearTaskFields();
}
else
{
if (Name.Text.Length < 3)
{
Name.Background = Brushes.LightPink;
}
if (Description.Text.Length < 3)
{
Description.Background = Brushes.LightPink;
}
LengthWarning.Visibility = Visibility.Visible;
}
}
public async Task <IActionResult> Log(int?id = null)
{
var recordsList = await DatabaseOperator.DownloadRecordsAsList(id);
var firstRecord = recordsList.FirstOrDefault();
int firstId = firstRecord is null ? -1 : (int)firstRecord.RecordId;
int inc = DatabaseOperator.defaultRecordsIncrement;
if (firstId > -1)
{
ViewData["idFirst"] = firstId;
ViewData["idPrev"] = firstId - inc;
ViewData["idNext"] = id is null ? (int?)null : firstId + inc;
}
else
{
ViewData["idFirst"] = null;
ViewData["idPrev"] = 1;
ViewData["idNext"] = null;
}
return(View(recordsList));
}
public AbstractTableInstance()
{
this.dbop = new DatabaseOperator();
}
public Query(string column, object value, DatabaseOperator op)
: base(column, value)
{
Operator = op.DependentOperator;
}
//使用线程 在界面显示后加载数据
private void BeginLoading()
{
mBackgroundWorker = new BackgroundWorker();
mBackgroundWorker.DoWork += (s, de) =>
{
while (true)
{
if (bIsloaded)
{
GetServiceStatus();
GetAppsInstalled();
GetServerType();
if (!App.bIsLoggingServer && !App.bIsUMPServer)
{
Dispatcher.Invoke(new Action(() =>
{
App.ShowMessage(App.GetLanguage("string8", "string8"));
}));
App.WriteLog("No products installed on this server, please install UMP and then upgrade");
break;
}
OperationReturn optReturn = GetDatabaseInfo();
if (!optReturn.Result)
{
switch (optReturn.Code)
{
case ConstDefines.RET_Database_Null:
Dispatcher.Invoke(new Action(() =>
{
App.ShowException(App.GetLanguage("string9", "string9"));
}));
App.WriteLog("Get database infomation failed.");
break;
case ConstDefines.Get_Database_Info_Exception:
Dispatcher.Invoke(new Action(() =>
{
App.ShowException(App.GetLanguage("string10", "string10"));
}));
App.WriteLog("Get database infomation failed." + optReturn.Message);
break;
}
break;
}
DatabaseInfo dbInfo = optReturn.Data as DatabaseInfo;
//OperationReturn optReturn;
//DatabaseInfo dbInfo = new DatabaseInfo();
//dbInfo.TypeID = 2;
//dbInfo.Host = "192.168.4.182";
//dbInfo.Port = 1433;
//dbInfo.DBName = "UMPDataDB0722";
//dbInfo.LoginName = "PFDEV";
//dbInfo.Password = "******";
App.WriteLog(string.Format("DatabaseInfo:{0}", dbInfo));
App.currDBInfo = dbInfo;
optReturn = DatabaseOperator.GetLastVersion();
if (!optReturn.Result)
{
if (optReturn.Code == ConstDefines.Get_T000_Failed || optReturn.Code == ConstDefines.Get_Version_Exception)
{
Dispatcher.Invoke(new Action(() =>
{
App.ShowException(App.GetLanguage("string18", "string18"));
}));
App.WriteLog("Error code :" + optReturn.Code + ". " + optReturn.Message);
break;
}
else if (optReturn.Code == ConstDefines.T000_Is_Null)
{
Dispatcher.Invoke(new Action(() =>
{
App.ShowException(App.GetLanguage("string19", "string19"));
}));
App.WriteLog("Error code :" + optReturn.Code + ". T_00_000 is null");
}
else
{
App.WriteLog("Error code :" + optReturn.Code + ". " + optReturn.Message);
}
}
string str = optReturn.Data.ToString();
App.gStrLastVersion = str;
//App.gStrLastVersion = "8.03.001";
App.WriteLog(string.Format("Version:{0}", App.gStrLastVersion));
bIsLoadDataSuccess = true;
break;
}
}
};
mBackgroundWorker.RunWorkerCompleted += (s, de) =>
{
myWaiter.Visibility = Visibility.Collapsed;
loginWin.IsEnabled = true;
if (!bIsLoadDataSuccess)
{
ButtonLogin.IsEnabled = false;
}
txtUserName.Focus();
};
myWaiter.Visibility = Visibility.Visible;
loginWin.IsEnabled = false;
mBackgroundWorker.RunWorkerAsync();
}
