public Task SaveOrUpdateTask(Task task) { if (task.Id == 0) return AddTask(task); else return UpdateTask(task); }
private Task UpdateTask(Task task) { lock (tasks) { var taskToUpdate = (from t in GetAll() where t.Id == task.Id select t).First<Task>(); tasks.Remove(taskToUpdate); tasks.Add(task); } return task; }
private Task AddTask(Task task) { lock (tasks) { var maxTask = from t in GetAll() where t.Id == GetAll().Max(i => i.Id) select t; task.Id = maxTask.First<Task>().Id++; tasks.Add(task); } return task; }
public Task SaveOrUpdate(Task task) { if (task.Id == 0) { return AddTask(task); } else { return UpdateTask(task); } }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Task = await _context.Task.SingleOrDefaultAsync(m => m.ID == id); if (Task == null) { return(NotFound()); } return(Page()); }
private void RegistrationButton_Click(object sender, System.EventArgs e) { Models.DatabaseContext oDatabaseContext = null; try { oDatabaseContext = new Models.DatabaseContext(); Models.Task oTask = new Models.Task(); oTask.TaskTitle = TitleTextBox.Text; oTask.TaskDescription = DescriptionTextBox.Text; oTask.ImportanceLevel = ImportanceComboBox.Text; oTask.Date = dateTimePicker1.Text; oDatabaseContext.Tasks.Add(oTask); oDatabaseContext.SaveChanges(); System.Windows.Forms.MessageBox.Show("کار جدید مورد نظر شما اضافه گردید."); TitleTextBox.Text = string.Empty; DescriptionTextBox.Text = string.Empty; } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show("Error: " + ex.Message); } finally { if (oDatabaseContext != null) { oDatabaseContext.Dispose(); oDatabaseContext = null; Main oMian = new Main(); oMian.Show(); } } }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } Task = await _context.Task.FindAsync(id); if (Task != null) { _context.Task.Remove(Task); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
/// <summary> /// Выполняет запрос на показ всех задач пользователя /// </summary> /// <param name="user">Логин пользовотеля для которого выполняется запрос</param> /// <returns></returns> public IEnumerable<Task> ShowAllTasks(string user) { // user = HttpUtility.HtmlEncode(user); var listTasks = new List<Task>(); using (var connection = new SqlConnection(ConnectionString)) { using (var cmd = connection.CreateCommand()) { connection.Open(); cmd.CommandText = @" select id_task ,name_task ,time_when_task_completed from Tasks where ( user_login =@login and deleted = 0 and time_when_task_completed is null ) or ( Tasks.id_task in ( select id_task from Tasks where user_login = @login and deleted = 0 and time_when_task_completed is not null order by time_when_task_completed desc offset 0 rows fetch next 5 rows only ) ) "; cmd.Parameters.AddWithValue("@login", user); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var task = new Task(); task.Id = reader.GetInt32(reader.GetOrdinal("id_task")); task.Name = reader.GetString(reader.GetOrdinal("name_task")); // task.Name = HttpUtility.HtmlDecode(task.Name); if (reader["time_when_task_completed"] == DBNull.Value) task.TimeWhenTaskCompleted = null; else task.TimeWhenTaskCompleted = reader.GetDateTime(reader.GetOrdinal("time_when_task_completed")); listTasks.Add(task); }; } } } IEnumerable<Task> result = listTasks.OrderBy(x => x.Name); return result; }
/// <summary> /// Ищет задачу в базе по id /// </summary> /// <param name="id">id задачи</param> /// <returns></returns> public Task FindTask(int id) { var task = new Task(); using (var connection = new SqlConnection(ConnectionString)) { using (var cmd = connection.CreateCommand()) { connection.Open(); cmd.Parameters.AddWithValue("@id", id); cmd.CommandText = @" select name_task ,deadline from Tasks where id_task=@id"; using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { task.Name = reader.GetString(reader.GetOrdinal("name_task")); // task.Name = HttpUtility.HtmlDecode(task.Name); if (reader["deadline"] == DBNull.Value) task.Deadline = null; else task.Deadline = reader.GetDateTime(reader.GetOrdinal("deadline")); } } var marksList = new List<string>(); cmd.CommandText = @" select name_mark from Tasks_Marks where id_task=@id"; using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { marksList.Add(reader.GetString(reader.GetOrdinal("name_mark"))); } } string marks = string.Empty; foreach (var mark in marksList) { marks += mark + ","; } // marks = HttpUtility.HtmlDecode(marks); task.Id = id; task.Marks = marks; } } return task; }
private Task UpdateTask(Task task) { db.Entry(task).State = System.Data.EntityState.Modified; db.SaveChanges(); return task; }
private Task AddTask(Task task) { db.Tasks.Add(task); db.SaveChanges(); return task; }
private Task AddTask(Task task) { Task t = context.Tasks.Add(task); context.SaveChanges(); return t; }