public IActionResult SignUp([Bind("Username,Email,FirstName,LastName,Password,PasswordRep")] SignUpViewModel model)
{
if (ModelState.IsValid)
{
if (context.Users.Any(u => u.Username == model.Username))
{
ModelState.AddModelError("NonUniqueUsername", "This username is already in use");
return(View(model));
}
User newUser = new User();
newUser.Username = model.Username;
newUser.FirstName = model.FirstName;
newUser.LastName = model.LastName;
newUser.Email = model.Email;
newUser.Password = BCrypt.Net.BCrypt.HashPassword(model.Password);
newUser.RoleId = RolesEnum.USER_ID;
newUser.Created = DateTime.Now;
newUser.Modified = DateTime.Now;
context.Users.Add(newUser);
context.SaveChanges();
return(Redirect("/Home"));
}
return(View(model));
}
public IHttpActionResult PutToDo(int id, ToDo toDo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != toDo.ID)
{
return(BadRequest());
}
db.Entry(toDo).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ToDoExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create(Task task)
{
if (ModelState.IsValid)
{
db.Tasks.Add(task);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(task));
}
public IActionResult Create(TaskItem model)
{
if (ModelState.IsValid)
{
_db.Add(model);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool remove(long id)
{
var entity = Context.BookRepos.Where(o => o.Id == id).FirstOrDefault();
if (entity == null)
{
throw new Exception();
}
Context.BookRepos.Remove(entity);
return(Context.SaveChanges() > 0);
}
/// <summary>
/// 删除待办事项
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteTodoList(long id)
{
var entity = todoListDbContext.Todos.Where(o => o.Id == id).FirstOrDefault();
if (entity == null)
{
throw new Exception();
}
todoListDbContext.Todos.Remove(entity);
return(todoListDbContext.SaveChanges() > 0);
}
public IHttpActionResult PostCategory(Category category)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Categories.Add(category);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = category.ID }, category));
}
public ActionResult Create(Task task)
{
//TODO: Implement me...
if (this.ModelState.IsValid)
{
db.Tasks.Add(task);
db.SaveChanges();
return(Redirect("/"));
}
return(View(task));
}
public ActionResult Create(Task task)
{
if (ModelState.IsValid)
{
using (database)
{
database.Tasks.Add(task);
database.SaveChanges();
return(Redirect("/"));
}
}
return(View());
}
public IHttpActionResult PostCategory(Category category)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//ajoute notre catégorie dans notre db par le db context.
db.Categories.Add(category);
//sauvegarde dans la bd
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = category.ID }, category));
}
private void AddListToDatabase()
{
string email = "*****@*****.**";
string password = "******";
_user = new User()
{
Email = email,
FirstName = "Atanas",
LastName = "Kambitov",
Id = 1,
IsAdmin = true,
UniqueToken = _uniqueToken,
Lists = new List <Backend.Models.Database.TodoList>(),
Password = password
};
_list = new Backend.Models.Database.TodoList()
{
Id = 1,
Title = "ListOne",
Items = new List <TodoItem>(),
UserId = 1
};
_db.Users.Add(_user);
_db.Lists.Add(_list);
_db.SaveChanges();
}
public ActionResult Create(Task task)
{
if (task == null)
{
return(RedirectToAction("Index"));
}
if (string.IsNullOrWhiteSpace(task.Title) || string.IsNullOrWhiteSpace(task.Comments))
{
return(RedirectToAction("Index"));
}
db.Tasks.Add(task);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Task task)
{
using (var db = new TodoListDbContext())
{
db.Tasks.Add(task);
db.SaveChanges();
}
return(RedirectToAction("Index", "Task"));
}
public ActionResult DeleteConfirm(int id)
{
using (var db = new TodoListDbContext())
{
Task task = db.Tasks.Find(id);
db.Tasks.Remove(task);
db.SaveChanges();
}
return(RedirectToAction("Index", "Task"));
}
public ActionResult DeleteConfirm(int id)
{
using (var db = new TodoListDbContext())
{
var task = db.Tasks.First(t => t.Id == id);
db.Tasks.Remove(task);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public IActionResult Edit(int?id, [Bind("Name,CategoryId")] TodoList model)
{
if (ModelState.IsValid)
{
var identity = HttpContext.Items["Identity"];
int currUserId = identity != null ? (int)identity : -1;
int listsCount = context.TodoLists
.Count(t => t.Name == model.Name && t.UserId == currUserId);
if ((id == null && listsCount > 0) || (id != null && listsCount > 1))
{
ModelState.AddModelError("NonUniqueName", "Provided name is not unique");
return(View(model));
}
TodoList list;
if (id == null)
{
list = new TodoList();
list.UserId = currUserId;
list.Created = DateTime.Now;
}
else
{
list = context.TodoLists.Find(id);
}
list.Name = model.Name;
list.CategoryId = model.CategoryId;
list.Modified = DateTime.Now;
if (id == null)
{
context.TodoLists.Add(list);
}
else
{
context.TodoLists.Update(list);
}
context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
return(View(model));
}
public IActionResult Edit(int?id, [Bind("Name")] Category model)
{
if (ModelState.IsValid)
{
var identity = HttpContext.Items["Identity"];
int currUserId = identity != null ? (int)identity : -1;
int categoriesCount = context.Categories
.Count(c => c.Name == model.Name && c.UserId == currUserId);
if ((id == null && categoriesCount > 0) || (id != null && categoriesCount > 1))
{
ModelState.AddModelError("NonUniqueCategory", "Provided category is not unique");
return(View(model));
}
Category category;
if (id == null)
{
category = new Category();
category.UserId = currUserId;
category.Created = DateTime.Now;
}
else
{
category = context.Categories.Find(id);
}
category.Name = model.Name;
category.Modified = DateTime.Now;
if (id == null)
{
context.Categories.Add(category);
}
else
{
context.Categories.Update(category);
}
context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
return(View(model));
}
public ActionResult Create(Task task)
{
if (ModelState.IsValid)
{
using (var database = new TodoListDbContext())
{
database.Tasks.Add(task);
database.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public IHttpActionResult PutCategory(int id, Category category)
{
if (id != category.ID)
{
return(BadRequest());
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Entry(category).State = System.Data.Entity.EntityState.Modified;
try
{
db.SaveChanges();
}
catch (Exception)
{
return(NotFound());
}
return(StatusCode(HttpStatusCode.NoContent));
}
/// <summary>
/// 用户注册
/// </summary>
/// <param name="user">用户信息</param>
/// <returns>1 成功，0 插入出错，-1 已存在该用户</returns>
public int Register(UserDto user)
{
//检验账号唯一性
var entity = todoListDbContext.Users.Where(o => o.Username == user.Username && o.Password == user.Password).FirstOrDefault();
if (entity == null)
{
//添加账号
using (var tran = todoListDbContext.Database.BeginTransaction())//开启事务
{
try
{
var u = new User {
Username = user.Username, Password = user.Password
};
//添加用户
todoListDbContext.Users.Add(u);
todoListDbContext.SaveChanges();
//添加实例
todoListDbContext.Todos.Add(new Todo {
Content = "示例", Priority = 1, UserId = u.Id
});
todoListDbContext.SaveChanges();
tran.Commit();
return(1);
}
catch (Exception e)
{
tran.Rollback();
return(0);
// TODO: Handle failure
}
}
}
else
{
return(-1);
}
}
public ActionResult Create(Task task)
{
if (string.IsNullOrWhiteSpace(task.Title) || string.IsNullOrWhiteSpace(task.Comments))
{
return(RedirectToAction("Index"));
}
using (var db = new TodoListDbContext())
{
db.Tasks.Add(task);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult EditConfirm([Bind(Include = "Id,Title,Comments")] Task task)
{
using (var db = new TodoListDbContext())
{
if (ModelState.IsValid)
{
db.Entry(task).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
public ActionResult DeleteConfirm(int id)
{
using (var db = new TodoListDbContext())
{
var task = db.Tasks.Find(id);
if (task != null)
{
db.Tasks.Remove(task);
db.SaveChanges();
}
return(Redirect("/"));
}
}
public ActionResult Create(Task task)
{
if (ModelState.IsValid)
{
using (var db = new TodoListDbContext())
{
db.Tasks.Add(task);
db.SaveChanges();
return(Redirect("/"));
}
}
return(View());
}
public ActionResult Create(Task task)
{
if (task == null || task.Title == null || task.Comments == null)
{
return(RedirectToAction("Index"));
}
using (var db = new TodoListDbContext())
{
db.Tasks.Add(task);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public IActionResult Edit(int?id, [Bind("Username,FirstName,LastName,Email")] User model)
{
if (ModelState.IsValid)
{
if (context.Users.Count(u => u.Username == model.Username) > 1)
{
ModelState.AddModelError("NonUniqueUsername", "This username is already in use");
return(View(model));
}
var user = context.Users.First(u => u.Id == id);
user.Username = model.Username;
user.FirstName = model.FirstName;
user.LastName = model.LastName;
user.Email = model.Email;
user.Modified = DateTime.Now;
context.Users.Update(user);
context.SaveChanges();
return(RedirectToAction(nameof(Details), new { id = user.Id }));
}
return(View(model));
}
public IActionResult Edit(int?id, [Bind("Name,Priority,Deadline,TodoListId")] TodoTask model)
{
if (ModelState.IsValid)
{
TodoTask task;
if (id == null)
{
task = new TodoTask();
task.TodoListId = model.TodoListId;
task.Created = DateTime.Now;
task.IsCompleted = false;
}
else
{
task = context.Tasks.Find(id);
}
task.Name = model.Name;
task.Priority = model.Priority;
task.Deadline = model.Deadline;
task.Modified = DateTime.Now;
if (id == null)
{
context.Tasks.Add(task);
}
else
{
context.Tasks.Update(task);
}
context.SaveChanges();
return(RedirectToAction("Manage", "TodoLists", new { id = task.TodoListId }));
}
return(View(model));
}
public ActionResult DeleteConfirm(int id)
{
TodoListDbContext db = new TodoListDbContext();
Task task = db.Tasks.Find(id);
if (task == null)
{
return(RedirectToAction("Index"));
}
db.Tasks.Remove(task);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Task task)
{
if (task == null)
{
return(RedirectToAction("Index", "Task"));
}
if (ModelState.IsValid)
{
using (var db = new TodoListDbContext())
{
db.Tasks.Add(task);
db.SaveChanges();
}
return(RedirectToAction("index", "Task"));
}
return(RedirectToAction("Create", "Task"));
}
public ActionResult DeleteConfirm(int?id)
{
using (var db = new TodoListDbContext())
{
var taskFromDb = db.Tasks.Find(id);
if (taskFromDb == null)
{
return(HttpNotFound());
}
db.Tasks.Remove(taskFromDb);
db.SaveChanges();
return(Redirect("/"));
}
}