public NewTaskWin() { NewTask = new Task(); InitializeComponent(); init(); }
public NewTaskWin(Task task) { OldTask = task; NewTask = new Task(task); IsUpdateble = true; taskComments = Comment.UncheckIsNew(NewTask.GetCommentsInCollection()); InitializeComponent(); init(); if(task.TimePlan > 0) { TimePlan.IsEnabled = false; } }
public Task(Task task) { GUID = task.GUID; OrderDate = task.OrderDate; EndDate = task.EndDate; Performer = new User(task.Performer); Customer = new User(task.Customer); Topic = task.Topic; Description = task.Description; Priority = task.Priority; Project = new Project(task.Project); TimePlan = task.TimePlan; TimeAdjustment = task.TimeAdjustment; TimeFact = task.TimeFact; Percents = task.Percents; IsImportant = task.IsImportant; IsNew = task.IsNew; IsDelete = task.IsDelete; }
public static string UpdateTask(Task task) { return ExecuteNonQuery(string.Format( "update TASKS set OrderDate='{0}',EndDate='{1}',Performer='{2}', Topic='{3}',Description='{4}',Priority={5},Project='{6}',TimePlan={7},TimeAdjustment={8},TimeFact={9},Percents={10},IsNew='{11}'\r\nwhere GUID='{12}'", DateTimeToSQLiteFormat(task.OrderDate.Date, false), DateTimeToSQLiteFormat(task.EndDate.Date, false), task.Performer.GUID, task.Topic, task.Description, task.Priority, task.Project.GUID, doubleToString(task.TimePlan), doubleToString(task.TimeAdjustment), doubleToString(task.TimeFact), doubleToString(task.Percents), task.IsNew, task.GUID), null, true); }
public static ObservableCollection<Task> GetTasksInCollection(QueryData query, bool all = false) { SQLiteConnection connection = new SQLiteConnection(ConnectionString); if(!all) { query.Where += query.Where == null ? " (TASKS.IsDelete='False' or TASKS.IsDelete='0')" : " and (TASKS.IsDelete='False' or TASKS.IsDelete='0')"; } string command = string.Concat( "select distinct * \r\nfrom TASKS ", string.IsNullOrEmpty(query.Join) ? "" : "\r\njoin " + query.Join, string.IsNullOrEmpty(query.Where) ? "" : "\r\nwhere " + query.Where); ObservableCollection<Task> tasks = new ObservableCollection<Task>(); try { connection.Open(); SQLiteCommand cmd = new SQLiteCommand(command, connection); if (query.Parameters != null) { foreach (SQLiteParameter p in query.Parameters) { cmd.Parameters.Add(p); } } SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string guid = reader.GetString(reader.GetOrdinal("GUID")); object isNew = reader["IsNew"]; object isDelete = reader["IsDelete"]; Task task = new Task(false) { GUID = guid, OrderDate = Convert.ToDateTime(reader.GetString(reader.GetOrdinal("OrderDate"))), EndDate = Convert.ToDateTime(reader.GetString(reader.GetOrdinal("EndDate"))), Performer = GetUserFromGUID(reader.GetString(reader.GetOrdinal("Performer"))), Customer = GetUserFromGUID(reader.GetString(reader.GetOrdinal("Customer"))), Topic = reader.GetString(reader.GetOrdinal("Topic")), Description = reader.GetString(reader.GetOrdinal("Description")), Priority = reader.GetByte(reader.GetOrdinal("Priority")), Project = new Project(false) { GUID = reader.GetString(reader.GetOrdinal("Project")) }, TimePlan = reader.GetDouble(reader.GetOrdinal("TimePlan")), TimeAdjustment = reader.GetDouble(reader.GetOrdinal("TimeAdjustment")), TimeFact = reader.GetDouble(reader.GetOrdinal("TimeFact")), Percents = reader.GetDouble(reader.GetOrdinal("Percents")), IsImportant = GetImportantFlagForTask(guid), IsNew = Convert.ToBoolean(isNew), IsDelete = Convert.ToBoolean(isDelete) }; tasks.Add(task); } } catch (Exception exc) { MessageWindows.Show("GetTasksInCollection:Exception", exc.Message); return tasks; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } foreach (Task task in tasks) { task.Project = GetParentProjectFromGUID(task.Project.GUID, all); } return tasks; }
public static string AddTask(Task task) { return ExecuteNonQuery(string.Format( "insert into TASKS values('{0}','{1}','{2}','{3}','{4}','{5}','{6}',{7},'{8}',{9},{10},{11},{12},'{13}','{14}','{15}')", task.GUID, DateTimeToSQLiteFormat(task.OrderDate.Date, false), DateTimeToSQLiteFormat(task.EndDate.Date, false), task.Performer.GUID, Settings.CurrentUser.GUID, task.Topic, task.Description, task.Priority, task.Project.GUID, doubleToString(task.TimePlan), doubleToString(task.TimeAdjustment), doubleToString(task.TimeFact), doubleToString(task.Percents), task.IsNew ? 1:0, 0, null), null, true); }
public static void SetBeginFlagForTask(Task task, bool add) { SQLiteWorker.SetBeginFlagForTask(task.GUID, add); }
public static bool Equal(Task task1, Task task2) { if (task2 == null) return false; return task1.OrderDate == task2.OrderDate && task1.EndDate == task2.EndDate && task1.Performer.GUID == task2.Performer.GUID && task1.Topic == task2.Topic && task1.Description == task2.Description && task1.Priority == task2.Priority && task1.TimePlan == task2.TimePlan && task1.TimeAdjustment == task2.TimeAdjustment && task1.TimeFact == task2.TimeFact && task1.Percents == task2.Percents && task1.IsImportant == task2.IsImportant ; }
public static bool ContainsTask(ObservableCollection<Task> tasks, Task task) { return tasks.Any(t => t.GUID == task.GUID); }