public IEnumerable <TaskToDo> getTaskByUser(string user) { try { EuroFinDBContext dBContext = new EuroFinDBContext(); return(dBContext.TaskToDo.Where(x => x.UserName == user)); } catch (Exception) { throw; } }
public IEnumerable <TaskToDo> getMyToDoList() { try { EuroFinDBContext dBContext = new EuroFinDBContext(); return(dBContext.TaskToDo.ToList()); } catch (Exception ex) { throw; } }
public void Login(User value) { EuroFinDBContext dBContext = new EuroFinDBContext(); var a = dBContext.User.SingleOrDefault(x => x.UserName == value.UserName && x.Password == value.Password); if (a == null) { return(Request.CreateResponse(HttpStatusCode.OK, new User())); } else { return(Request.CreateResponse(HttpStatusCode.OK, a)); } }
public User Login(User value) { EuroFinDBContext dBContext = new EuroFinDBContext(); var a = dBContext.User.SingleOrDefault(x => x.UserName == value.UserName && x.Password == value.Password); if (a == null) { return(new User()); } else { return(a); } }
public string getRegisterUser(string user) { EuroFinDBContext dBContext = new EuroFinDBContext(); var a = dBContext.User.SingleOrDefault(x => x.UserName == user); if (a == null) { return(""); } else { return(a.UserName); } }
public bool deleteMyToDoList(int id) { try { EuroFinDBContext dBContext = new EuroFinDBContext(); dBContext.TaskToDo.Remove(dBContext.TaskToDo.SingleOrDefault(x => x.Id == id)); dBContext.SaveChanges(); return(true); } catch (Exception) { return(false); //throw; } }
public bool postRegisterUser(User value) { try { EuroFinDBContext dBContext = new EuroFinDBContext(); value.CreateDate = DateTime.Now; dBContext.User.Add(value); dBContext.SaveChanges(); return(true); } catch (Exception) { return(false); throw; } }
public bool saveMyToDoList(TaskToDo value) { try { EuroFinDBContext dBContext = new EuroFinDBContext(); TaskToDo t = new TaskToDo { Note = value.Note, UserName = value.UserName }; dBContext.TaskToDo.Add(t); dBContext.SaveChanges(); return(true); } catch (Exception) { return(false); throw; } }