namespace TaskManager.Models
{
    public class DataManager
    {
        private MvsBugDataContext _datacontext;
        
        public DataManager(string connectionstring)
        {
            _datacontext = new MvsBugDataContext(connectionstring);
        }

        private MembershipRepository _membershipRepository;
        public MembershipRepository Membership
        {
            get
            {
                if (_membershipRepository == null)
                {
                   _membershipRepository = new MembershipRepository();
                }
                return _membershipRepository;
            }
        }

        private TaskRepository _taskRepository;
        public TaskRepository Tasks
        {
            get
            {
                if (_taskRepository == null)
                {
                    _taskRepository = new TaskRepository(_datacontext);
                }
                return _taskRepository;
            }
        }

        private StateRepository _stateRepository;
        public StateRepository States
        {
            get
            {
                if (_stateRepository == null)
                {
                    _stateRepository = new StateRepository(_datacontext);
                }
                return _stateRepository;
            }
        }
    }
}

namespace TaskManager.Models
{
    public class TaskRepository
    {
        private MvsBugDataContext _datacontects;

        public TaskRepository(MvsBugDataContext datacontext)
        {
            _datacontects = datacontext;
        }

        public IEnumerable<Task> GetTasks()
        {
            return _datacontects.Tasks.OrderBy(s => s.AssignedOn);
        }

        public Task GetTask(int taskId)
        {
            return _datacontects.Tasks.SingleOrDefault(t => t.TaskId == taskId);
        }

        public Task CreateTask(string title, string text)
        {
            Task t = new Task { Title = title, Text = text };
            _datacontects.Tasks.InsertOnSubmit(t);
            _datacontects.SubmitChanges();
            return t; 
        }

        public void UpdateTask(Task t)
        {
            Task dbTask = GetTask(t.TaskId);
            dbTask.AssignedOn = t.AssignedOn;
            dbTask.Title = t.Title;
            dbTask.Text = t.Text;
            dbTask.StateId = t.StateId;
            _datacontects.SubmitChanges();
        }

        public void DeleteTask(int taskId)
        {
            Task t = GetTask(taskId);
            _datacontects.Tasks.DeleteOnSubmit(t);
            _datacontects.SubmitChanges();
        }
    }
}

namespace TaskManager.Controllers
{
    public class TaskController : Controller
    {
        private DataManager _dataManager;

        public TaskController(DataManager dataManager)
        {
            _dataManager = dataManager;
        }

        public ActionResult List()
        {
            ViewData["Title"] = "Tasks List";
            ViewData["Tasks"] = _dataManager.Tasks.GetTasks();
            return View();
        }

        public ActionResult Task(int id)
        {
            ViewData.Model = _dataManager.Tasks.GetTask(id);
            return View();
        }

    }
}