public void ClientNewTaskRequest()
{
Console.WriteLine("\nReceived request to: New Task");
User mUser = FindUser(Context.ConnectionId);
NewTaskCommand mNewTask = new NewTaskCommand(mUser);
mNewTask.Execute();
int id = mNewTask.GetId();
int sortorder = mNewTask.GetSortOrder();
Clients.Clients(mUser.ConnectionIDs).UpdateTask(id, "||false||true|" + sortorder, 6);
}
private void NewTaskCommand_Executed(object sender, RoutedEventArgs e)
{
System.Threading.Tasks.Task.Factory.StartNew(() =>
{
try
{
NewTaskCommand CreateClick = new NewTaskCommand(this);
CreateClick.Execute();
}
catch (AggregateException error)
{
MessageBox.Show(error.Message);
}
});
}
public static int CreateTask(string Title, string Description, string EndDate)
{
NewTaskCommand command = new NewTaskCommand();
command.EMail = EMAIL;
command.Hash = HASH;
command.Title = Title;
command.Description = Description;
command.EndDate = EndDate;
command.CreateDate = DateTime.Now.Date.ToString("de - DE");
ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command)));
return(result.statusCode);
}
private void newTaskTextBox_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Return)
{
TreeViewItem group = new TreeViewItem();
group.Header = "Today";
UserTask task = new UserTask();
task.Subject = newTaskTextBox.Text;
AddTask(task, group, true);
TaskDatabase.Add(task);
if (TasksView.ApplicationTasksView != null)
{
NewTaskCommand.Execute(task, TasksView.ApplicationTasksView);
}
NewTaskCommand.MassExecute(task, LoadedTasksPeekContents, this);
newTaskTextBox.Clear();
}
}
private static string AddTask(string CommandPara)
{
SQLManager.Connection.Close();
NewTaskCommand Command = new NewTaskCommand();
ResultWithNoData Result = new ResultWithNoData();
Aufgaben auf = new Aufgaben();
AufgabenListViewItem list = new AufgabenListViewItem();
int cid = 0;
Command = JsonConvert.DeserializeObject <NewTaskCommand>(CommandPara);
if (CheckUserData(Command.EMail, Command.Hash) == false)
{
return(JsonConvert.SerializeObject(Result));
}
using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand())
{
SQLManager.Connection.Open();
mysqlCommand.CommandText = "SELECT CID FROM users WHERE EMail='" + Command.EMail + "'";
MySqlDataReader mysqlreader;
mysqlreader = mysqlCommand.ExecuteReader();
if (mysqlreader.HasRows)
{
mysqlreader.Read();
cid = mysqlreader.GetInt32("CID");
}
else
{
return(JsonConvert.SerializeObject(Result));
}
mysqlreader.Close();
SQLManager.Connection.Close();
}
using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand())
{
SQLManager.Connection.Open();
mysqlCommand.CommandText = "SELECT Aufgaben FROM classes WHERE CID='" + cid + "'";
MySqlDataReader mysqlreader;
mysqlreader = mysqlCommand.ExecuteReader();
if (mysqlreader.HasRows)
{
mysqlreader.Read();
string aufm = mysqlreader.GetString("Aufgaben");
if (aufm != "")
{
auf = JsonConvert.DeserializeObject <Aufgaben>(aufm);
}
}
mysqlreader.Close();
SQLManager.Connection.Close();
}
list.Title = Command.Title;
list.Description = Command.Description;
list.EndDate = Command.EndDate;
list.StartDate = DateTime.Now.ToShortDateString();
auf.Tasks.Add(list);
using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand())
{
SQLManager.Connection.Open();
mysqlCommand.CommandText = "UPDATE classes SET Aufgaben = ?aufgaben WHERE CID = ?CID";
mysqlCommand.Parameters.AddWithValue("?CID", cid);
mysqlCommand.Parameters.AddWithValue("?aufgaben", JsonConvert.SerializeObject(auf));
mysqlCommand.ExecuteNonQuery();
SQLManager.Connection.Close();
}
Result.statusCode = 201;
return(JsonConvert.SerializeObject(Result));
}
