public void AddListItem(ToDoList List) { //foreach (var pet in List.Pets) //{ // _usercontext.Users.Attach(List); //} _todocontext.ToDoLists.Add(List); _todocontext.SaveChanges(); }
public IActionResult AddTask(ToDoList thing) { if (ModelState.IsValid) { string id = User.FindFirst(ClaimTypes.NameIdentifier).Value; thing.UserId = id; _context.ToDoList.Add(thing); _context.SaveChanges(); } return(RedirectToAction("ToDoItemList")); }
public ActionResult Create(ToDo toDo) { toDo.Created = DateTime.UtcNow; if (ModelState.IsValid) { db.ToDoes.Add(toDo); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(toDo)); }
public bool Create(tToDo oTodo) { try { _db.DbSettToDo.Add(oTodo); _db.SaveChanges(); return(true); } catch { return(false); } }
public IActionResult Create(ToDoItem item) { _context.ToDoItems.Add(item); _context.SaveChanges(); return(CreatedAtRoute("GetToDo", new { id = item.ID }, item)); }
public IActionResult Create(ToDoItem t) { var claimsIdentity = (ClaimsIdentity)this.User.Identity; var claim = claimsIdentity.FindFirst(System.Security.Claims.ClaimTypes.NameIdentifier); var userId = claim.Value; t.UserId = userId; if (ModelState.IsValid) { _toDoDB.ToDoItem.Add(t); _toDoDB.SaveChanges(); return(RedirectToAction("Index")); } else { return(View()); } }
public ActionResult Index([Bind(Include = "ToDoListId,NameOfDuty,Date,DateToFinish,IsChecked")] IList <ToDoList> todolist, int id) { if (ModelState.IsValid) { ToDoList list = db.ToDoLists.Find(id); //ToDoList list = db.ToDoLists.Find(todolist[id].ToDoListId); //ToDoList = db.Entry.Where(c => c.Id == model.ToDoListId).FirstOrDefault(); list.NameOfDuty = todolist[id].NameOfDuty; list.Date = todolist[id].Date; list.DateToFinish = todolist[id].DateToFinish; // db.Entry(todolist).State = EntityState.Modified; list.IsChecked = todolist[id].IsChecked; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(db.ToDoLists.ToList())); }
public ToDo Post(ToDo todo) { var cx = new ToDoDBContext(); var curr = cx.ToDoes.Single(e => e.id == todo.id); curr.updated = DateTime.Now; curr.category = todo.category; curr.comment = todo.comment; cx.SaveChanges(); return(todo); }
public ToDo Post(ToDo todo) { var cx = new ToDoDBContext(); todo.id = Guid.NewGuid(); todo.created = DateTime.Now; todo.updated = DateTime.Now; cx.ToDoes.Add(todo); cx.SaveChanges(); return(todo); }
public async System.Threading.Tasks.Task <ActionResult> Detail(int id, ToDo model, FormCollection formcol) { if (formcol["Save"] == "Save") { var cx = new ToDoDBContext(); if (id == 0) { model.GId = Guid.NewGuid(); model.Created = DateTime.Now; cx.ToDoes.Add(model); cx.SaveChanges(); //Send to sservice bus ServiceBusHelper.SendToAll(model); } else { var p = cx.ToDoes.Single(e => e.Id == id); p.Note = model.Note; p.Category = model.Category; cx.SaveChanges(); } } else if (formcol["Comment"] == "Comment") { if (formcol["CommentText"].Length > 0) { var td = new ToDoComment(); td.Id = Guid.NewGuid(); td.ToDoGId = model.GId; td.Created = DateTime.Now; td.Comment = formcol["CommentText"]; var doc = new DocDBContext(); await doc.InsertComment(td); return(RedirectToAction("Detail", new { id = id })); } } return(RedirectToAction("Index")); }
public IActionResult Delete(int id) { using (var db = new ToDoDBContext()) { var taskToDelete = db.Tasks.First(t => t.Id == id); db.Tasks.Remove(taskToDelete); db.SaveChanges(); } return(RedirectToAction("Index")); }
public ToDoController(ToDoDBContext context) { _context = context; if (_context.ToDoItems.Count() == 0) { _context.ToDoItems.Add(new ToDoItem { Name = "Item1" }); _context.SaveChanges(); } }
public UserDefn UserLogin(UserDetails userDetails) { try { var results = (from u in _context.UserDefn where u.UserName == userDetails.UserName || u.Email == userDetails.Email select u).FirstOrDefault(); if (results == null) { var newUser = new UserDefn { UserName = userDetails.UserName, Email = userDetails.Email }; _context.UserDefn.Add(newUser); _context.SaveChanges(); } results = (from u in _context.UserDefn where u.UserName == null && u.Email == userDetails.Email select u).FirstOrDefault(); if (results != null) { _context.Database.ExecuteSqlRaw("UPDATE User_DEFN SET UserName = '******' WHERE Email = '" + userDetails.Email + "'"); _context.SaveChanges(); } var user = (from u in _context.UserDefn where u.Email == userDetails.Email select u).FirstOrDefault(); return(user); } catch (Exception ex) { throw ex; } }
public ActionResult Register(User u) { try { u.RegisterTime = DateTime.Now; u.LastLoginTime = null; u.AddressId = null; db.User.Add(u); //对表进行添加操作 int row = db.SaveChanges(); if (row > 0) { return(Ok()); } else { return(BadRequest()); } } catch (Exception ex) { return(NotFound()); } }
public ActionResult AddToShopCart(int uid, int proid, int num) { try { User u = db.User.ToList().Where(n => (n.Uid == uid)).SingleOrDefault(); if (u != null) { //购物车中是否存在该物品 Shopcart cart = db.Shopcart.Where(n => n.ProId == proid && n.Uid == u.Uid).SingleOrDefault(); //存在就添加数量 if (cart != null) { cart.Num += num; db.SaveChanges(); } //否则就新增 else { cart = new Shopcart(); cart.Uid = u.Uid; cart.Num = num; cart.ProId = proid; db.Shopcart.Add(cart); db.SaveChanges(); } return(Ok("添加成功")); } else { return(BadRequest()); } } catch (Exception ex) { return(NotFound(ex.Message)); } }
public IActionResult Create(Task taskToCreate) { if (ModelState.IsValid) { using (var db = new ToDoDBContext()) { db.Tasks.Add(taskToCreate); db.SaveChanges(); } } else { TempData["ErrorMessage"] = "Fill up all the fields of the form!"; return(this.View()); } return(RedirectToAction("Index")); }
public IActionResult Edit(Task editedTask) { if (ModelState.IsValid) { using (var db = new ToDoDBContext()) { var taskToEdit = db.Tasks.First(t => t.Id == editedTask.Id); taskToEdit.Title = editedTask.Title; taskToEdit.Comments = editedTask.Comments; db.SaveChanges(); return(RedirectToAction("Index")); } } return(RedirectToAction("Index")); }
public void AddTask(TaskDetails taskModel) { try { var user = (from u in _context.UserDefn where u.Email == taskModel.Email select u).FirstOrDefault(); if (user == null) { UserDefn newUser = new UserDefn { Email = taskModel.Email }; _context.UserDefn.Add(newUser); _context.SaveChanges(); } user = (from u in _context.UserDefn where u.Email == taskModel.Email select u).FirstOrDefault(); Tasks newTask = new Tasks { TaskName = taskModel.Name, TaskDescription = taskModel.Description, TaskDate = taskModel.Date, StatusId = 1, UserId = user.UserId }; _context.Tasks.Add(newTask); _context.SaveChanges(); } catch (Exception ex) { throw ex; } }
public void Insert(ToDo entity) { _context.Tasks.Add(entity); _context.SaveChanges(); }
public void Insert(SubTask entity) { _context.SubTasks.Add(entity); _context.SaveChanges(); }
public int SaveChanges() { return(_context.SaveChanges()); }
public void Insert(User entity) { _context.Users.Add(entity); _context.SaveChanges(); }