private void SaveItem_Click(object sender, RoutedEventArgs e) { ToDoListEntities dbEntities = new ToDoListEntities(); var selected = lvToDoListItem.SelectedItems.Cast <Object>().ToArray(); if (selected.Length == 0) { MessageBox.Show("Please select the row you want to update.", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } foreach (var item in selected) { ToDoListItems todo = dbEntities.ToDoListItems.Find(((ToDoList.Business.TodoListItems)item).ItemId); if (((ToDoList.Business.TodoListItems)selected[0]).Status == true) { todo.Status = "1"; } else { todo.Status = "0"; } dbEntities.SaveChanges(); } }
public ActionResult Index() { ToDoListEntities ORM = new ToDoListEntities(); ViewBag.newtask = ORM.Tasks.ToList(); return(View()); }
public Project GetProjectById(int projectId) { ToDoListEntities dbModel = new ToDoListEntities(); Project projectDetails = dbModel.Projects.Find(projectId); return(projectDetails); }
public void CreateUserAccount(string _Namesurname, string _Username, string _Password, string _Email) { string encryptingPassword = Encrypting(_Password).Trim(); try { using (ToDoListEntities dbEntities = new ToDoListEntities()) { var UserNamedb = (from x in dbEntities.Users where (x.Username == _Username) select x).FirstOrDefault <Users>(); if (UserNamedb == null) { Users user = new Users(); user.NameSurname = _Namesurname.Trim(); user.Username = _Username.Trim(); user.Password = encryptingPassword; user.Email = _Email.Trim(); dbEntities.Users.Add(user); dbEntities.SaveChanges(); MessageBox.Show("Adding Success!", "Information", MessageBoxButton.OK, MessageBoxImage.Information); } else { MessageBox.Show("This user name is already exists!", "Information", MessageBoxButton.OK, MessageBoxImage.Information); } } } catch (Exception ex) { MessageBox.Show("Adding Failed!", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }
public HttpResponseMessage UpdateListItemDone(ListItem li) { ToDoListEntities dc = new ToDoListEntities(); ListItem _li = dc.ListItems.Find(li.Id); if (_li == null) { return(new HttpResponseMessage(System.Net.HttpStatusCode.NotFound)); } if (_li.ItemDone == false) { _li.ItemDone = true; } else { _li.ItemDone = false; } try { dc.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex); return(new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest)); } return(new HttpResponseMessage(System.Net.HttpStatusCode.OK)); }
public int SaveTask(Task task) { ToDoListEntities dbModel = new ToDoListEntities(); Task taskadded; if (task.TaskId > 0) { taskadded = dbModel.Tasks.Find(task.TaskId); if (taskadded != null) { taskadded.TaskName = task.TaskName; taskadded.DueDate = task.DueDate; taskadded.Priority = task.Priority; taskadded.IsCompleted = task.IsCompleted; taskadded.ProjectRefId = task.ProjectRefId; taskadded.Changed = DateTime.Now; } } else { task.Changed = DateTime.Now; task.Created = DateTime.Now; taskadded = dbModel.Tasks.Add(task); } dbModel.SaveChanges(); UpdateProjectCount(task.ProjectRefId, dbModel); return(taskadded.TaskId); }
public List <TaskViewModel> GetAllTaskByProjectId(int projectId, string sortOn, string sortBy) { ToDoListEntities dbModel = new ToDoListEntities(); IQueryable <Task> queryable = dbModel.Tasks.Where(t => t.ProjectRefId == projectId).AsQueryable(); if (sortBy == "desc") { queryable = sortOn == "date" ? queryable.OrderByDescending(d => d.DueDate) : queryable.OrderByDescending(d => d.IsCompleted); } else { queryable = sortOn == "date" ? queryable.OrderBy(d => d.DueDate) : queryable.OrderBy(d => d.IsCompleted); } List <TaskViewModel> taskViewModels = queryable.Select( p => new TaskViewModel() { TaskId = p.TaskId, TaskName = p.TaskName, ProjectId = p.ProjectRefId, ProjectName = p.Project.ProjectName, Priority = p.Priority, IsCompleted = p.IsCompleted, DueDate = p.DueDate }).ToList(); return(taskViewModels); }
private static void UpdateProjectCount(int projectId, ToDoListEntities dbModel) { int unFinishedTask = dbModel.Tasks.Count(tCount => tCount.ProjectRefId == projectId && tCount.IsCompleted == false); Project dbProject = dbModel.Projects.Find(projectId); dbProject.Count = unFinishedTask; dbModel.SaveChanges(); }
public ToDoUnitOfWork(ToDoListEntities context, IGenericRepository <ToDo_List> toDoListRepository, IGenericRepository <User> userRepository, IGenericRepository <UserToken> userTokenRepository) { ToDoListRepository = toDoListRepository; UserRepository = userRepository; UserTokenRepository = userTokenRepository; DbContext = context; }
public ActionResult SaveNewTask(Task newtask) { ToDoListEntities ORM = new ToDoListEntities(); ORM.Tasks.Add(newtask); ORM.SaveChanges(); return(RedirectToAction("Index")); }
public void ClearAllTasks() { using (var context = new ToDoListEntities()) { context.Database.ExecuteSqlCommand("TRUNCATE TABLE [ToDoTask]"); context.SaveChanges(); } }
public bool AddTask(Task newTask) { using (var _TaskContext = new ToDoListEntities()) { _TaskContext.Tasks.Add(newTask); _TaskContext.SaveChanges(); } return(true); }
public ActionResult DeleteTask(int taskID) { ToDoListEntities ORM = new ToDoListEntities(); Task TaskToDelete = ORM.Tasks.Find(taskID); ORM.Tasks.Remove(TaskToDelete); ORM.SaveChanges(); return(RedirectToAction("Index")); }
public ToDoTask Get(int taskId) { using (var context = new ToDoListEntities()) { //force return of simple poco object instead of proxy context.Configuration.ProxyCreationEnabled = false; var task = context.ToDoTasks.SingleOrDefault(t => t.ToDoTaskID == taskId); return(task); } }
public List <ProjectViewModel> GetAllProject() { ToDoListEntities dbModel = new ToDoListEntities(); IQueryable <Project> dbset = dbModel.Projects.AsQueryable(); List <ProjectViewModel> list = dbset.Select(p => new ProjectViewModel() { ProjectId = p.ProjectId, ProjectName = p.ProjectName, Count = p.Count }).ToList(); return(list); }
public bool DeleteTask(int taskId) { ToDoListEntities dbModel = new ToDoListEntities(); Task taskFind = dbModel.Tasks.Find(taskId); if (taskFind != null) { dbModel.Tasks.Remove(taskFind); dbModel.SaveChanges(); } return(true); }
public ToDoTask Update(ToDoTask task) { using (var context = new ToDoListEntities()) { context.ToDoTasks.Attach(task); var entry = context.Entry(task); entry.State = EntityState.Modified; entry.Property(e => e.ToDoListID).IsModified = false; context.SaveChanges(); return(task); } }
public bool DeleteProject(int projectId) { ToDoListEntities dbModel = new ToDoListEntities(); Project projectFind = dbModel.Projects.Find(projectId); if (projectFind != null) { dbModel.Projects.Remove(projectFind); dbModel.SaveChanges(); } return(true); }
private void DeleteItem_Click(object sender, RoutedEventArgs e) { ToDoListEntities dbEntities = new ToDoListEntities(); var selected = lvToDoListItem.SelectedItems.Cast <Object>().ToArray(); foreach (var item in selected) { lvToDoListItem.Items.Remove(item); ToDoListItems todo = dbEntities.ToDoListItems.Find(((ToDoList.Business.TodoListItems)item).ItemId); todo.IsActive = "0"; dbEntities.SaveChanges(); } }
public bool DeleteTask(int taskId) { using (var _TaskContext = new ToDoListEntities()) { var query = from task in _TaskContext.Tasks where task.Id == taskId select task; Task selectedTask = query.First(); _TaskContext.Tasks.Remove(selectedTask); _TaskContext.SaveChanges(); } return(true); }
// GET: Data public JsonResult GetListItems() { //ListItem li = null; using (ToDoListEntities dc = new ToDoListEntities()) { var li = (dc.ListItems.ToList()); Console.WriteLine(li); return(new JsonResult { Data = li, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public Task GetTaskByTaskId(int taskId) { ToDoListEntities dbModel = new ToDoListEntities(); Task taskFind = dbModel.Tasks.Find(taskId); return(new Task() { ProjectRefId = taskFind.ProjectRefId, TaskName = taskFind.TaskName, DueDate = taskFind.DueDate, IsCompleted = taskFind.IsCompleted, Priority = taskFind.Priority, }); }
public bool MarkCompleted(Task task) { ToDoListEntities dbModel = new ToDoListEntities(); var taskFindDb = dbModel.Tasks.Find(task.TaskId); if (taskFindDb != null) { taskFindDb.IsCompleted = true; dbModel.SaveChanges(); int projectId = taskFindDb.ProjectRefId; UpdateProjectCount(projectId, dbModel); } return(true); }
public void Remove(int taskId) { ToDoTask task = new ToDoTask() { ToDoTaskID = taskId }; using (var context = new ToDoListEntities()) { context.ToDoTasks.Attach(task); context.ToDoTasks.Remove(task); context.SaveChanges(); } }
public bool CompleteTask(int taskId) { using (var _TaskContext = new ToDoListEntities()) { var query = from task in _TaskContext.Tasks where task.Id == taskId select task; Task selectedTask = query.First(); selectedTask.Status = true; selectedTask.DateCompleted = DateTime.Now; _TaskContext.Tasks.AddOrUpdate(selectedTask); _TaskContext.SaveChanges(); } return(true); }
public ToDoTask Add(ToDoTask task) { using (var context = new ToDoListEntities()) { context.ToDoTasks.Add(task); context.SaveChanges(); var data = from t in context.ToDoTasks where t.ToDoTaskID == 1 select t; //TODO - use a DTO (is it necessary if using poco????) ToDoDto dto = new ToDoDto(task); return(task); } }
public void MyFilter(string listName) { using (ToDoListEntities dbEntities = new ToDoListEntities()) { TodoListItems todoListItem = new TodoListItems(); lvToDoListItem.Items.Clear(); var _listName = (from x in dbEntities.ToDoListItems where (x.ListItemName.Contains(listName)) select x).FirstOrDefault <ToDoListItems>(); if (_listName != null) { todoListItem.ItemId = _listName.ItemId; todoListItem.ListItemName = _listName.ListItemName; todoListItem.Description = _listName.Description; todoListItem.Deadline = Convert.ToDateTime(_listName.Deadline); todoListItem.ListId = Convert.ToInt32(_listName.ListId); todoListItem.IsActive = _listName.IsActive; if (Convert.ToInt32(_listName.ListId) == 0) { todoListItem.ListName = ""; } else { todoListItem.ListName = _listName.ListItemName; } if (_listName.Status == "1") { todoListItem.Status = true; } else { todoListItem.Status = false; } } lvToDoListItem.Items.Add(todoListItem); } lvToDoListItem.Items.Refresh(); }
public List <TaskListDto> GetAll() { using (var context = new ToDoListEntities()) { var results = from t in context.ToDoTasks join l in context.ToDoLists on t.ToDoListID equals l.ToDoListID orderby t.SortOrder select new TaskListDto() { TaskListId = t.ToDoListID, TaskId = t.ToDoTaskID, ListName = l.ToDoListName, TaskName = t.ToDoTaskName, SortOrder = t.SortOrder }; return(results.ToList()); } }
public void AddUserOfListItems(int _ListId, int _UserId) { try { using (ToDoListEntities dbEntities = new ToDoListEntities()) { UsersOfToDoLists todo = new UsersOfToDoLists(); todo.ListId = _ListId; todo.UserId = _UserId; dbEntities.UsersOfToDoLists.Add(todo); dbEntities.SaveChanges(); MessageBox.Show("Adding Success!", "Information", MessageBoxButton.OK, MessageBoxImage.Information); } } catch (Exception ex) { MessageBox.Show("Adding Failed!", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }
//try //{ //} //catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) //{ // Exception raise = dbEx; // foreach (var validationErrors in dbEx.EntityValidationErrors) // { // foreach (var validationError in validationErrors.ValidationErrors) // { // string message = string.Format("{0}:{1}", // validationErrors.Entry.Entity.ToString(), // validationError.ErrorMessage); // // raise a new exception nesting // // the current instance as InnerException // raise = new InvalidOperationException(message, raise); // } // } // throw raise; //} public List <TaskViewModel> GetAllTaskByProjectId(int projectId) { ToDoListEntities dbModel = new ToDoListEntities(); IQueryable <Task> dbset = dbModel.Tasks.Where(t => t.ProjectRefId == projectId).AsQueryable(); List <TaskViewModel> list = dbset.Select( p => new TaskViewModel() { TaskId = p.TaskId, TaskName = p.TaskName, ProjectId = p.ProjectRefId, ProjectName = p.Project.ProjectName, Priority = p.Priority, IsCompleted = p.IsCompleted, DueDate = p.DueDate }).ToList(); return(list); }