public override INote CreateNote(string text)
{
Logger.Debug("Creating New Note Object : {0} (id={1})", text, id);
text = backend.SanitizeText(text);
string command = String.Format("INSERT INTO Notes (Task, Text) VALUES ('{0}','{1}'); SELECT last_insert_rowid();", id, text);
int taskId = Convert.ToInt32(backend.Database.ExecuteScalar(command));
return(new SqliteNote(taskId, text));
}
public SqliteTask(SqliteBackend backend, string name)
: base(backend.SanitizeText (name), TaskNoteSupport.Multiple)
{
if (backend == null)
throw new ArgumentNullException ("backend");
name = backend.SanitizeText (name);
this.backend = backend;
Debug.WriteLine ("Creating New Task Object : {0} (id={1})", name, id);
var dueDate = Database.FromDateTime (DueDate);
var completionDate = Database.FromDateTime (CompletionDate);
var priority = (int)Priority;
var state = (int)State;
var command = string.Format ("INSERT INTO Tasks (Name, DueDate, CompletionDate, Priority, State, Category, ExternalID) values ('{0}','{1}', '{2}','{3}', '{4}', '{5}', '{6}'); SELECT last_insert_rowid();",
name, dueDate, completionDate, priority, state, 0, string.Empty);
id = Convert.ToInt32 (backend.Database.ExecuteScalar (command));
}
public SqliteTask(SqliteBackend backend, string name)
{
this.backend = backend;
Logger.Debug("Creating New Task Object : {0} (id={1})", name, id);
name = backend.SanitizeText (name);
this.name = name;
this.dueDate = Database.FromDateTime(DateTime.MinValue);
this.completionDate = Database.FromDateTime(DateTime.MinValue);
this.category = 0;
this.priority = (int)(TaskPriority.None);
this.state = (int)TaskState.Active;
string command = String.Format("INSERT INTO Tasks (Name, DueDate, CompletionDate, Priority, State, Category, ExternalID) values ('{0}','{1}', '{2}','{3}', '{4}', '{5}', '{6}'); SELECT last_insert_rowid();",
name, dueDate, completionDate,
priority, state, category, string.Empty);
this.id = Convert.ToInt32 (backend.Database.ExecuteScalar (command));
}
public SqliteTask(SqliteBackend backend, string name)
{
this.backend = backend;
Logger.Debug("Creating New Task Object : {0} (id={1})", name, id);
name = backend.SanitizeText(name);
this.name = name;
this.dueDate = Database.FromDateTime(DateTime.MinValue);
this.completionDate = Database.FromDateTime(DateTime.MinValue);
this.category = 0;
this.priority = (int)(TaskPriority.None);
this.state = (int)TaskState.Active;
string command = String.Format("INSERT INTO Tasks (Name, DueDate, CompletionDate, Priority, State, Category, ExternalID) values ('{0}','{1}', '{2}','{3}', '{4}', '{5}', '{6}'); SELECT last_insert_rowid();",
name, dueDate, completionDate,
priority, state, category, string.Empty);
this.id = Convert.ToInt32(backend.Database.ExecuteScalar(command));
}