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 IEnumerable <Category> getAllCategories() { List <Category> listCategories = new List <Category>(); using (var db = new OrganizerDBContext()){ listCategories = db.Categories.ToList(); } return(listCategories); }
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 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 ActionResult Login([Bind(Include = "Email, Password")] User model) { string result = helper.EncryptedPassword(model.Password, "h@sheD"); if (ModelState.IsValidField("Email") && ModelState.IsValidField("Hasło")) { using (OrganizerDBContext db = new OrganizerDBContext()) { var obj = db.Users.Where(a => a.Email.Equals(model.Email) && a.Password.Equals(result)).FirstOrDefault(); if (obj != null) { Session["UserID"] = obj.UserId.ToString(); Session["UserName"] = obj.Email.ToString(); return(RedirectToAction("Index", "User")); } } } return(View(model)); }
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(); } }
//additional features for knockout demo public static List <TodoItem> getAllTodoItems() { using (var db = new OrganizerDBContext()) { return(db.TodoItems.ToList()); } }