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