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);
}
