public JsonResult GetSubTask(string taskId) { using (var db = new DbFactory()) { var subTaskList = db.WunderListSubTasks.Where(p => p.TaskId == taskId).ToList(); return Json(subTaskList); } }
public ActionResult BookList() { using (var db = new DbFactory()) { return View(db.Books.ToList()); } }
public JsonResult GetTask() { DateTime dt = DateTime.Now; using (var db = new DbFactory()) { var task = db.WunderTasks.ToList(); task = task.Where(p => p.CreateAt.Month == dt.Month && p.ListId == "148182326").OrderByDescending(p => p.CreateAt).ToList(); return Json(task); } }
public ActionResult Index() { //GenerateBook(); //GenerateDatabase(); using (var db = new DbFactory()) { var list = db.WunderListItems.ToList(); foreach (var wunderlist in list) { wunderlist.Title = wunderlist.Title; } return View(list); } }
public ActionResult YearlyTask() { List<WunderlistItemViewModel> wvmList = new List<WunderlistItemViewModel>(); DateTime dt = DateTime.Now; string currentYear = dt.Year.ToString(); using (var db = new DbFactory()) { var yearList = db.WunderListItems.Where(p => p.Title.Contains(currentYear)).ToList(); foreach (var list in yearList) { WunderlistItemViewModel wvm = new WunderlistItemViewModel(); wvm.WudnerListItem = list; wvm.WunderTasks = db.WunderTasks.Where(p => p.ListId == list.WunderListId).ToList(); wvmList.Add(wvm); } return View(wvmList); } }
private void GenerateBook() { string filePath = Server.MapPath("~/Db/WunderListJosn.txt"); StreamReader reader = new StreamReader(filePath, System.Text.Encoding.Default); var d = JsonConvert.DeserializeObject<Rootobject>(reader.ReadToEnd()); var listdata = d.data.lists; var taskdata = d.data.tasks; var subtaskdata = d.data.subtasks; using (var db = new DbFactory()) { var task = taskdata.Where(p => p.list_id ==143779280).ToList(); foreach (var t in task) { Book b = new Book(); b.BookName = t.title; b.BookTaskId = t.id.ToString(); b.IsCompleted = t.completed; b.Create_Begin = t.created_at; b.BookConverUrl = ""; db.Books.Add(b); } db.SaveChanges(); } }
private void GenerateDatabase() { string filePath = Server.MapPath("~/Db/WunderListJosn.txt"); StreamReader reader = new StreamReader(filePath, System.Text.Encoding.Default); var d = JsonConvert.DeserializeObject<Rootobject>(reader.ReadToEnd()); var listdata = d.data.lists; var taskdata = d.data.tasks; var subtaskdata = d.data.subtasks; try { using (var db = new DbFactory()) { foreach (var list in listdata) { WunderListItem wunderList = new WunderListItem(); wunderList.CreatedAt = list.created_at; wunderList.ListType = WunderListType.List; wunderList.Title = list.title; wunderList.WunderListId = list.id.ToString(); db.WunderListItems.Add(wunderList); } foreach (var task in taskdata) { WunderTask wunderTask = new WunderTask(); wunderTask.CreateAt = task.created_at; wunderTask.IsCompleted = task.completed; wunderTask.ListId = task.list_id.ToString(); wunderTask.Title = task.title; wunderTask.TaskId = task.id.ToString(); db.WunderTasks.Add(wunderTask); } foreach (var subtask in subtaskdata) { WunderListSubTask wunderSubTask = new WunderListSubTask(); wunderSubTask.IsCompleted = subtask.completed; wunderSubTask.TaskId = subtask.task_id.ToString(); wunderSubTask.Title = subtask.title; db.WunderListSubTasks.Add(wunderSubTask); } db.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }