public static void saveNewTodoItem(TodoItem oTodoItem)
{
using (var db = new OrganizerDBContext()){
db.TodoItems.Add(oTodoItem);
db.Entry(oTodoItem).State = System.Data.EntityState.Added;
db.SaveChanges();
}
}
public static void updateTodoItem(TodoItem oTodoItem)
{
using (var db = new OrganizerDBContext())
{
db.TodoItems.Attach(oTodoItem);
db.Entry(oTodoItem).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
public static void deleteTodoItemById(int id)
{
TodoItem todoItem = getAppUserByUserName(HttpContext.Current.User.Identity.Name).ThingsTodo.FirstOrDefault(p => p.Id == id);
using (var db = new OrganizerDBContext()){
db.Entry(todoItem).State = System.Data.EntityState.Deleted;
db.SaveChanges();
}
}
public static void saveTodoItem(TodoItemDTO todoItemDTO)
{
using (var db = new OrganizerDBContext()){
AppUser appUser =
db.
AppUsers.
Include("ThingsTodo").
Single(p => p.UserName == HttpContext.Current.User.Identity.Name);
appUser.ThingsTodo.Add(
new TodoItem {
CategoryId = todoItemDTO.SelectedCategoryId, Title = todoItemDTO.Title, Completed = false
}
);
db.AppUsers.Attach(appUser);
db.Entry(appUser).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
public static bool registerUser(RegisterDTO oDTO)
{
if (!isUserNameUnique(oDTO.UserName))
{
return(false);
}
using (var db = new OrganizerDBContext())
{
AppUser oAppUser = new AppUser();
oAppUser.UserName = oDTO.UserName;
oAppUser.Password = PasswordHash.CreateHash(oDTO.Password);
db.AppUsers.Add(oAppUser);
db.Entry(oAppUser).State = System.Data.EntityState.Added;
db.SaveChanges();
}
return(true);
}
public static void EditTodoItem(TodoItemDTO todoItemDTO, int todoItemId)
{
TodoItem todoItem =
getAppUserByUserName(HttpContext.Current.User.Identity.Name).
ThingsTodo.
FirstOrDefault(p => p.Id == todoItemId);
if (todoItem == null)
{
throw new Exception("Access denied");
}
todoItem.CategoryId = todoItemDTO.SelectedCategoryId;
todoItem.Completed = todoItemDTO.SelectedCompletedId == 0 ? false : true;
todoItem.Title = todoItemDTO.Title;
using (var db = new OrganizerDBContext())
{
db.TodoItems.Attach(todoItem);
db.Entry(todoItem).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}