public static string SaveTask (Task item)
{
var request = WebRequest.Create(url);
request.ContentType = "application/json";
request.Method = "POST";
request.Headers.Add ("X-AUTH-TOKEN", auth_token);
MemoryStream stream1 = new MemoryStream();
DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(Task));
ser.WriteObject(stream1, item);
stream1.Position = 0;
var strObject = new StreamReader (stream1).ReadToEnd ();
using (var writer = new StreamWriter(request.GetRequestStream()))
{
writer.Write(strObject);
}
using (HttpWebResponse response = request.GetResponse () as HttpWebResponse) {
var stream = response.GetResponseStream ();
//KCRequest<Task> konaresp = (KCRequest<Task>)ser.ReadObject(stream);
//return konaresp.data.ID;
}
return String.Empty;
}
protected override void OnCreate (Bundle bundle)
{
base.OnCreate (bundle);
int taskID = Intent.GetIntExtra("TaskID", 0);
if(taskID > 0) {
task = TaskManager.GetTask(taskID);
}
// set our layout to be the home screen
SetContentView(Resource.Layout.TaskDetails);
nameTextEdit = FindViewById<EditText>(Resource.Id.NameText);
notesTextEdit = FindViewById<EditText>(Resource.Id.NotesText);
saveButton = FindViewById<Button>(Resource.Id.SaveButton);
// find all our controls
cancelDeleteButton = FindViewById<Button>(Resource.Id.CancelDeleteButton);
// set the cancel delete based on whether or not it's an existing task
cancelDeleteButton.Text = (task.ID == null ? "Cancel" : "Delete");
nameTextEdit.Text = task.Name;
notesTextEdit.Text = task.Notes;
// button clicks
cancelDeleteButton.Click += (sender, e) => { CancelDelete(); };
saveButton.Click += (sender, e) => { Save(); };
}
protected void ShowTaskDetails(Task task)
{
currentTask = task;
taskDialog = new TaskDialog (task);
context = new BindingContext (this, taskDialog, "Task Details");
detailsScreen = new DialogViewController (context.Root, true);
ActivateController(detailsScreen);
}
/// <summary>Convert from DataReader to Task object</summary>
Task FromReader (SqliteDataReader r) {
var t = new Task ();
t.ID = Convert.ToInt32 (r ["_id"]);
t.Name = r ["Name"].ToString ();
t.Notes = r ["Notes"].ToString ();
t.Done = Convert.ToInt32 (r ["Done"]) == 1 ? true : false;
return t;
}
/// <summary>
/// Insert or update a task
/// </summary>
public static int SaveTask (Task item)
{
var max = 0;
if (tasks.Count > 0)
max = tasks.Max(x => x.ID);
if (item.ID == 0) {
item.ID = ++max;
tasks.Add (item);
} else {
var i = tasks.Find (x => x.ID == item.ID);
i = item; // replaces item in collection with updated value
}
WriteXml ();
return max;
}
public Task GetItem(int id)
{
var t = new Task ();
lock (locker) {
connection = new SqliteConnection ("Data Source=" + path);
connection.Open ();
using (var command = connection.CreateCommand ()) {
command.CommandText = "SELECT [_id], [Name], [Category], [Notes], [Done] from [Items] WHERE [_id] = ?";
command.Parameters.Add (new SqliteParameter (DbType.Int32) { Value = id });
var r = command.ExecuteReader ();
while (r.Read ()) {
t = FromReader (r);
break;
}
}
connection.Close ();
}
return t;
}
public static void SaveTask(Task task)
{
var asyncTask = table.InsertAsync(task);
asyncTask.Wait();
}
public static void DeleteTask(Task task)
{
var asyncTask = table.DeleteAsync(task);
asyncTask.Wait();
}
public static int SaveTask(Task item)
{
var max = 0;
tasks.ForEach( t => max = Math.Max (max,t.ID));
item.ID = ++max;
tasks.Add (item);
WriteXml ();
return max;
}
public static int SaveTask (Task item)
{
return me.db.SaveItem(item);
}
public int SaveItem(Task item)
{
int r;
lock (locker) {
if (item.ID != 0) {
connection = new SqliteConnection ("Data Source=" + path);
connection.Open ();
using (var command = connection.CreateCommand ()) {
command.CommandText = "UPDATE [Items] SET [Name] = ?, [Category] = ?, [Notes] = ?, [Done] = ? WHERE [_id] = ?;";
command.Parameters.Add (new SqliteParameter (DbType.String) { Value = item.Name });
command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Category });
command.Parameters.Add (new SqliteParameter (DbType.String) { Value = item.Notes });
command.Parameters.Add (new SqliteParameter (DbType.Int32) { Value = item.Done });
command.Parameters.Add (new SqliteParameter (DbType.Int32) { Value = item.ID });
r = command.ExecuteNonQuery ();
}
connection.Close ();
return r;
} else {
connection = new SqliteConnection ("Data Source=" + path);
connection.Open ();
using (var command = connection.CreateCommand ()) {
command.CommandText = "INSERT INTO [Items] ([Name], [Category], [Notes], [Done]) VALUES (?, ?, ?, ?)";
command.Parameters.Add (new SqliteParameter (DbType.String) { Value = item.Name });
command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Category });
command.Parameters.Add (new SqliteParameter (DbType.String) { Value = item.Notes });
command.Parameters.Add (new SqliteParameter (DbType.Int32) { Value = item.Done });
r = command.ExecuteNonQuery ();
}
connection.Close ();
return r;
}
}
}
public static int SaveTask(Task item)
{
return TaskRepository.SaveTask(item);
}
public static string SaveTask (Task item)
{
return KCTaskRepository.SaveTask(item);
}
public TaskDialog (Task task)
{
Cliente = task.Cliente;
Impianto = task.Impianto;
}
public TaskDialog (Task task)
{
Name = task.Name;
Notes = task.Notes;
}
