public async Task <IActionResult> Edit(int id, [Bind("TaskId,TextTask,DateTask,CompleteTask,UserId")] TaskTable taskTable) { if (id != taskTable.TaskId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(taskTable); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TaskTableExists(taskTable.TaskId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["UserId"] = new SelectList(_context.User, "Id", "Id", taskTable.UserId); return(View(taskTable)); }
public IHttpActionResult PutTaskTable(int id, TaskTable taskTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != taskTable.TaskID) { return(BadRequest()); } db.Entry(taskTable).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!TaskTableExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
private void deleteButton_Click(object sender, RoutedEventArgs e) { TaskTable selectedTask = (TaskTable)todogrid.SelectedItem; if (selectedTask != null) { using (var context = new ScheduleUpDBEntities()) { context.Entry(selectedTask).State = EntityState.Deleted; context.SaveChanges(); } todoTaskTable.Remove(selectedTask); todogrid.ItemsSource = null; todogrid.ItemsSource = todoTaskTable; } else { var message = "You didn't pick any task"; if ((TaskTable)donegrid.SelectedItem != null) { message = "Can not delete task in \"DONE\" status. Please change task status as \"ToDo\" or \"InProgress\" and try deleting again."; } MessageBox.Show(message, "Alert", MessageBoxButton.OK, MessageBoxImage.Information); } }
private void done_button_Click(object sender, RoutedEventArgs e) { TaskTable selectedTask = (TaskTable)todogrid.SelectedItem; todoTaskTable.Remove(selectedTask); if (selectedTask != null) { using (var context = new ScheduleUpDBEntities()) { var updateTask = context.TaskTable.Where(x => x.TaskID == selectedTask.TaskID).FirstOrDefault(); updateTask.TaskStatu = "Done"; context.SaveChanges(); doneTaskTable.Add(updateTask); } todogrid.ItemsSource = null; todogrid.ItemsSource = todoTaskTable; donegrid.ItemsSource = null; donegrid.ItemsSource = doneTaskTable; } else { var message = "Nothing Selected From Active Tasks Table"; MessageBox.Show(message, "Alert", MessageBoxButton.OK, MessageBoxImage.Information); } }
public IHttpActionResult InsertGetTaskTable(string jsonModel) { TaskTable oData = Newtonsoft.Json.JsonConvert.DeserializeObject <TaskTable>(jsonModel); var index = _taskTableService.Add(oData); return(Ok(index > 0 ? "ok" : "no")); }
protected override void OnCreate(Bundle savedInstanceState) { try { base.OnCreate(savedInstanceState); _task = Rep.DatabaseHelper.Tasks.Enumerator.Current; var category = Rep.DatabaseHelper.Tasks.GetCategory(_task.CategoryId); SetContentView(Resource.Layout.ImageCard); _image = FindViewById <ImageView>(Resource.Id.imageCardView); var imageIdentifier = this.Resources.GetIdentifier(category.Image, "drawable", this.PackageName); _image.SetImageResource(imageIdentifier); var text = FindViewById <TextView>(Resource.Id.textCard); text.SetTypeface(Rep.FontManager.Get(Font.BankirRetro), TypefaceStyle.Normal); text.Text = _task.TaskName; _contentFrameLayout = FindViewById(Resource.Id.contentFrameLayout); _contentFrameLayout.Click += ContentFrameLayoutOnClick; } catch (Exception exception) { GaService.TrackAppException(this.Class, "OnCreate", exception, false); base.OnBackPressed(); } }
public IHttpActionResult PostTaskTable(TaskTable taskTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.TaskTables.Add(taskTable); try { db.SaveChanges(); } catch (DbUpdateException) { if (TaskTableExists(taskTable.TaskID)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = taskTable.TaskID }, taskTable)); }
private void DoneButton_Click(object sender, EventArgs e) { if (MetroFramework.MetroMessageBox.Show(this, "Are you sure task is done? This action is irrevocable and it will remove the task from the list..", "Proceed?", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { Bunifu.Framework.UI.BunifuImageButton selecteddonebutton = (Bunifu.Framework.UI.BunifuImageButton)sender; int getRowDone = TaskTable.GetRow(selecteddonebutton); var getPlayPauseButton = (Bunifu.Framework.UI.BunifuImageButton)TaskTable.GetControlFromPosition(2, getRowDone); if (getPlayPauseButton.Tag.ToString() == "Played") { PlayPauseButton_Click(getPlayPauseButton, e); } using (var conn = new MySqlConnection(ConnectionString)) { conn.Open(); using (MySqlCommand cmd = conn.CreateCommand()) { var getTaskLabelText = (Label)TaskTable.GetControlFromPosition(0, getRowDone); cmd.CommandText = "UPDATE `tbl_tasks` SET `isDone` = '1', `timestampUpdated` = NOW() WHERE `taskName` = @taskname AND `userID` = @userid AND `isDone` = '0' LIMIT 1;"; cmd.Parameters.AddWithValue("@userid", SetUser.Text); cmd.Parameters.AddWithValue("@taskname", getTaskLabelText.Text); if (cmd.ExecuteNonQuery() != 0) { getPlayPauseButton.Tag = "Stopped"; getPlayPauseButton.Image = new Bitmap(Properties.Resources.CircledPlay_34px); TaskTable.RowStyles[getRowDone].Height = 0F; } else { MetroFramework.MetroMessageBox.Show(this, "Cannot set the task to done! Please check db connection and try again!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } }
public ActionResult RetrivingTaks(TaskTable Taskies) { TaskListEntities ORM = new TaskListEntities(); ViewBag.Tasks = ORM.TaskTables.ToList(); return(View()); }
public bool Update(int taskId, TaskTable tasks) { try { var query = (from update in db.Tasks.Where(x => x.TaskId == taskId) select update).SingleOrDefault(); if (query != null) { query.TaskId = taskId; query.ParentTask = !string.IsNullOrEmpty(tasks.ParentTask) ? tasks.ParentTask : string.Empty; query.StartDate = tasks.StartDate; query.EndDate = tasks.EndDate; query.Priority = tasks.Priority; query.TaskName = !string.IsNullOrEmpty(tasks.TaskName) ? tasks.TaskName : string.Empty; query.ProjectId = tasks.ProjectId; query.UserId = tasks.UserId; db.Entry(query).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception) { return(false); } return(true); }
public HomeController(ILogger <HomeController> logger, Helper helper, UserTable ut, TenantTable tt, UserManager <User> userManager, SignInManager <User> signInManager, UserManager <GlobalUser> sharedUserManager, SignInManager <GlobalUser> sharedSignInManager, NewTenantProcedure newTenant, IAuthorizationService auth, ServiceOrderTable serviceOrderTable, NotificationTable notificationTable, TaskTable taskTable) { _logger = logger; _helper = helper; _ut = ut; _tt = tt; _serviceOrderTable = serviceOrderTable; _newTenant = newTenant; UserMgr = userManager; SignInMgr = signInManager; SharedUserMgr = sharedUserManager; SharedSignInMgr = sharedSignInManager; _authorization = auth; _notificationTable = notificationTable; _taskTable = taskTable; }
void ReleaseDesignerOutlets() { if (TaskTable != null) { TaskTable.Dispose(); TaskTable = null; } if (TaskTitle != null) { TaskTitle.Dispose(); TaskTitle = null; } if (SaveButton != null) { SaveButton.Dispose(); SaveButton = null; } if (DeleteButton != null) { DeleteButton.Dispose(); DeleteButton = null; } }
private void ElapsedTimer_Tick(object sender, EventArgs e) { if (DateTime.Compare(DateTime.Today, currentDate) > 0 && notified == true) { notified = false; NotifiedLabel.Text = "False"; currentDate = DateTime.Now.Date; } if (TaskTable.RowCount > 0) { bool isthereRunning = false; for (int i = 0; i < TaskTable.RowCount - 2; i++) { var onPlayedIncrement = (Bunifu.Framework.UI.BunifuImageButton)TaskTable.GetControlFromPosition(2, i); if (onPlayedIncrement != null) { if (onPlayedIncrement.Tag.ToString() == "Played") { isthereRunning = true; var incrementTimer = (Label)TaskTable.GetControlFromPosition(1, i); incrementTimer.Text = TimeSpan.Parse(incrementTimer.Text).Add(TimeSpan.FromSeconds(1)).ToString(); } } } if (DateTime.Compare(DateTime.Now, Convert.ToDateTime("17:30:00")) >= 0 && DateTime.Compare(DateTime.Now, Convert.ToDateTime("17:30:02")) <= 0 && notified == false && isthereRunning == true) { notified = true; NotifiedLabel.Text = "True"; RunAutoSave(); MetroFramework.MetroMessageBox.Show(this, "Time is already 5:30, Auto pause task executed.", "Attention!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
public ActionResult AddTask(TaskAttachment taskAttachment) { try { TaskTable task = taskAttachment.Task; db.AddTask.Add(task); List <int> attachmentIDs = new List <int>(); bool result = db.SaveChanges() > 0 ? true : false; if (result) { foreach (var item in taskAttachment.Attachment) { db.Attachments.Add(new AttachmentModel { FK_TypeID = item.FK_TypeID, FK_ItemID = task.ID, Title = item.Title, Content = item.Content, CreationDate = item.CreationDate, FK_CreatedBy = item.FK_TypeID, }); bool result2 = db.SaveChanges() > 0 ? true : false; } } return(Ok(new { id = task.ID /*, AttachmentIDs = taskAttachment.Attachment*/ })); } catch { return(BadRequest()); } }
private void unselectAll_() { previewTranCon_.Reset(); TaskTable.Clear(); taskElemsToRows_.Clear(); rowsToTasks_.Clear(); }
public ActionResult DeleteConfirmed(int id) { TaskTable taskTable = db.TaskTables.Find(id); db.TaskTables.Remove(taskTable); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult UpdateTask(string UpdateTaskies) { TaskListEntities ORM = new TaskListEntities(); TaskTable item = ORM.TaskTables.Find(UpdateTaskies); return(View(item)); }
internal void PopulateTasks(string tableName) { var table = new TaskTable(tableName, this.Db); foreach (var task in this.Tasks) { table.Add(task); } }
public async Task <TaskModel> AddTask(TaskModel task) { var taskRow = new TaskTable() { Id = task.Id, Name = task.Name, Status = task.Status }; await _taskRepository.Create(taskRow); return(task); }
public ActionResult DeleteTask(string TaskNu) { TaskListEntities ORM = new TaskListEntities(); TaskTable founded = ORM.TaskTables.Find(TaskNu); ORM.TaskTables.Remove(founded); ORM.SaveChanges(); return(RedirectToAction("RetrivingTaks")); }
public ActionResult Edit([Bind(Include = "Id,title,details,assingname,date")] TaskTable taskTable) { if (ModelState.IsValid) { db.Entry(taskTable).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(taskTable)); }
public async Task <bool> UpdateTask(string id, TaskModel task) { var taskRow = new TaskTable() { Id = task.Id, Name = task.Name, Status = task.Status }; await _taskRepository.Update(taskRow, id); return(true); }
public ProjectController(TaskTable taskTable, ProjectTable projectTable, UserTable userTable, TenantTable tenantTable, ServiceOrderTable serviceOrderTable, NotificationTable notificationTable) { _taskTable = taskTable; _projectTable = projectTable; _userTable = userTable; _tenantTable = tenantTable; _serviceOrderTable = serviceOrderTable; _notificationTable = notificationTable; }
public void clearContext() { addin_.SelectionChangedEvent -= Addin_SelectionChangedEvent; previewTranCon_?.Reset(); selectionTranCon_?.Reset(); taskElemsToRows_.Clear(); TaskTable.Clear(); OnPropertyChanged(NP.TaskSelection); }
public IHttpActionResult GetTaskTable(int id) { TaskTable taskTable = db.TaskTables.Find(id); if (taskTable == null) { return(NotFound()); } return(Ok(taskTable)); }
public ActionResult Create([Bind(Include = "Id,title,details,assingname,date")] TaskTable taskTable) { if (ModelState.IsValid) { db.TaskTables.Add(taskTable); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(taskTable)); }
public ActionResult Edit([Bind(Include = "task_id,title,project_id")] TaskTable taskTable) { if (ModelState.IsValid) { db.Entry(taskTable).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.project_id = new SelectList(db.ProjectTables, "project_id", "title", taskTable.project_id); return(View(taskTable)); }
public ActionResult Create([Bind(Include = "task_id,title,project_id")] TaskTable taskTable) { if (ModelState.IsValid) { db.TaskTables.Add(taskTable); db.SaveChanges(); return(RedirectToAction("Index", "Projects")); } ViewBag.project_id = new SelectList(db.ProjectTables, "project_id", "title", taskTable.project_id); return(View(taskTable)); }
public async Task <IActionResult> Create([Bind("TaskId,TextTask,DateTask,CompleteTask,UserId")] TaskTable taskTable) { if (ModelState.IsValid) { _context.Add(taskTable); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["UserId"] = new SelectList(_context.User, "Id", "Id", taskTable.UserId); return(View(taskTable)); }
public void SaveTasks() { var tasks = new TaskTable { ProjectName = "NUNIT", ProjectId = 100, TaskName = "NUNIT", Priority = 10, ParentTask = "TEST", IsParent = true, StartDate = Convert.ToDateTime("2018-10-18"), EndDate = Convert.ToDateTime("2018-10-18"), UserId = 1, UserName = "******", Deleted = false, Status = "Completed" }; bool added = task.Add(tasks); Assert.AreEqual(true, added); }