//additional features for knockout demo
public static List<TodoItem> getAllTodoItems()
{
using (var db = new OrganizerDBContext()) {
return db.TodoItems.ToList();
}
}
public static IEnumerable<Category> getAllCategories()
{
List<Category> listCategories = new List<Category>();
using(var db = new OrganizerDBContext()){
listCategories = db.Categories.ToList();
}
return listCategories;
}
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 AppUser getAppUserByUserName(string sUserName)
{
AppUser oAppUser = null;
using(var db = new OrganizerDBContext()){
oAppUser =
db.
AppUsers.
Include("ThingsTodo").
Where(p => p.UserName == sUserName).
FirstOrDefault();
}
return oAppUser;
}
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();
}
}
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;
}
private static bool isUserNameUnique(string userName)
{
AppUser appUser;
using (var db = new OrganizerDBContext()) {
appUser = db.AppUsers.SingleOrDefault(p => p.UserName == userName);
}
return appUser == null;
}
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 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 void saveNewTodoItem(TodoItem oTodoItem)
{
using(var db = new OrganizerDBContext()){
db.TodoItems.Add(oTodoItem);
db.Entry(oTodoItem).State = System.Data.EntityState.Added;
db.SaveChanges();
}
}
