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