public static FromDateTime ( System.DateTime time ) : long | ||
time | System.DateTime | |
Результат | long |
void TaskListTaskCollectionRepo.AddNew(ITaskListCore container, ITaskCore item) { var command = "INSERT INTO Tasks" + "(Name, DueDate, CompletionDate, Priority, State, " + "Category, ExternalID) " + "VALUES (@name, @dueDate, @completionDate, " + "@priority, @state, @catId, ''); " + "SELECT last_insert_rowid();"; using (var cmd = new SqliteCommand(database.Connection)) { cmd.CommandText = command; cmd.Parameters.AddWithValue("@name", item.Text); cmd.Parameters.AddWithValue("@dueDate", Database.FromDateTime(item.DueDate)); cmd.Parameters.AddWithValue("@completionDate", Database.FromDateTime(DateTime.MinValue)); cmd.Parameters.AddWithValue("@priority", (int)item.Priority); cmd.Parameters.AddWithValue("@state", (int)item.State); cmd.Parameters.AddWithValue("@catId", int.Parse(container.Id)); var id = cmd.ExecuteScalar().ToString(); item.SetId(id); } }
DateTime ITaskRepository.UpdateDueDate(ITaskCore task, DateTime date) { var command = "UPDATE Tasks SET DueDate=@dueDate WHERE ID=@id;"; using (var cmd = new SqliteCommand(database.Connection)) { cmd.CommandText = command; cmd.Parameters.AddWithValue("@dueDate", Database.FromDateTime(date)); cmd.Parameters.AddIdParameter(task); cmd.ExecuteNonQuery(); } return(date); }
void ITaskRepository.Activate(ITaskCore task) { var command = "UPDATE Tasks SET State=@state, " + "CompletionDate=@completionDate WHERE ID=@id;"; using (var cmd = new SqliteCommand(database.Connection)) { cmd.CommandText = command; cmd.Parameters.AddWithValue("@state", (int)TaskState.Active); cmd.Parameters.AddWithValue("@completionDate", Database.FromDateTime(DateTime.MinValue)); cmd.Parameters.AddIdParameter(task); cmd.ExecuteNonQuery(); } }
IEnumerable <ITaskListCore> IBackend.GetAll() { yield return(allList); ITaskListCore taskList; var hasValues = false; var command = "SELECT id, name FROM Categories"; using (var cmd = new SqliteCommand( command, database.Connection)) { using (var dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { var id = dataReader.GetInt32(0).ToString(); var name = dataReader.GetString(1); hasValues = true; taskList = Factory.CreateTaskList(id, name); yield return(taskList); } } } if (!hasValues) { var workCategory = CreateInitialTaskList("Work"); yield return(workCategory); yield return(CreateInitialTaskList("Personal")); yield return(CreateInitialTaskList("Family")); yield return(CreateInitialTaskList("Project")); var taskName = "Create some tasks"; var insertCommand = string.Format( "INSERT INTO Tasks" + "(Name, DueDate, CompletionDate, Priority, State, " + "Category, ExternalID) " + "VALUES ('{0}', '{1}', '{2}', " + "'{3}', '{4}', '{5}', '{6}');", taskName, Database.FromDateTime(DateTime.MinValue), Database.FromDateTime(DateTime.MinValue), 0, (int)TaskState.Active, workCategory.Id, string.Empty); using (var cmd = new SqliteCommand(database.Connection)) { cmd.CommandText = insertCommand; cmd.ExecuteNonQuery(); } } }