public AccountSetAvatarHandler(TodoListContext context, IPhotoAccessor photoAccessor, UserManager <User> userManager, IHttpContextAccessor httpContextAccessor) { _context = context; _photoAccessor = photoAccessor; UserManager = userManager; _httpContextAccessor = httpContextAccessor; }
public IActionResult SaveChanges([FromBody] List <List> modelList) { if (!ModelState.IsValid) { return(StatusCode(404)); } else { using (var db = new TodoListContext()) { foreach (var list in modelList) { foreach (var listitem in list.ListItem) { foreach (var item in db.ListItem) { if (item.Id == listitem.Id) { item.Completed = listitem.Completed; } } } } int count = db.ListItem.Count(); db.SaveChanges(); } return(Ok()); } }
public IActionResult Edit(UsuarioRequest oUsuarioRequest) { Respuesta oResponse = new Respuesta(); try { using (TodoListContext db = new TodoListContext()) { Usuario oUsuario = db.Usuario.Find(oUsuarioRequest.Id); oUsuario.Nombre = oUsuarioRequest.Nombre; oUsuario.Password = oUsuarioRequest.Password; oUsuario.UserName = oUsuarioRequest.UserName; db.Entry(oUsuario).State = Microsoft.EntityFrameworkCore.EntityState.Modified; db.SaveChanges(); oResponse.Result = 1; oResponse.Message = "Usuario modificado exitosamente"; return(Ok(oResponse)); } } catch (Exception ex) { oResponse.Message = ex.Message; } return(Ok(oResponse)); }
public TaskService( TodoListContext todoListContext, ILogger <TaskService> logger) { _todoListContext = todoListContext; _logger = logger; }
public IActionResult Add(TareaRequest oTareaRequest) { Respuesta oResponse = new Respuesta(); try { using (TodoListContext db = new TodoListContext()) { Tarea oTarea = new Tarea(); oTarea.Nombre = oTareaRequest.Nombre; oTarea.IdUsuario = oTareaRequest.IdUsuario; oTarea.IdEstado = oTareaRequest.IdEstado; oTarea.Descripcion = oTareaRequest.Descripcion; db.Tarea.Add(oTarea); db.SaveChanges(); oResponse.Result = 1; oResponse.Message = "Tarea agregada exitosamente"; return(Ok(oResponse)); } } catch (Exception ex) { oResponse.Message = ex.Message; } return(Ok(oResponse)); }
public UserApiController(TodoListContext context, IWebHostEnvironment hostingEnvironment) { _context = context; _usersService = new UsersService(_context); _hostEnvironment = hostingEnvironment; _userEditHelper = new UserEditHelper(_usersService); }
public IActionResult Add(UsuarioRequest oUsuarioRequest) { Respuesta oResponse = new Respuesta(); try { using (TodoListContext db = new TodoListContext()) { Usuario oUsuario = new Usuario(); oUsuario.Nombre = oUsuarioRequest.Nombre; oUsuario.Password = oUsuarioRequest.Password; oUsuario.UserName = oUsuarioRequest.UserName; db.Usuario.Add(oUsuario); db.SaveChanges(); oResponse.Result = 1; oResponse.Message = "Usuario agregado exitosamente"; return(Ok(oResponse)); } } catch (Exception ex) { oResponse.Message = ex.Message; } return(Ok(oResponse)); }
public ActionResult GetUsers() { //return Json(_users); TodoListContext context = HttpContext.RequestServices.GetService(typeof(TodoApp.Models.TodoListContext)) as TodoListContext; return(Json(context.GetAllTheUsers())); }
public ActionResult Users() { TodoListContext context = HttpContext.RequestServices.GetService(typeof(TodoApp.Models.TodoListContext)) as TodoListContext; return(Json(context.GetAllUsers())); //return resultJson; }
public IActionResult AddItem([FromBody] ListItem listitem) { DateTime now = DateTime.Now; now = DateTime.ParseExact(now.ToString("yyyy-MM-dd HH:mm:ss"), "yyyy-MM-dd HH:mm:ss", null); if (!ModelState.IsValid) { return(StatusCode(404)); } else { using (var db = new TodoListContext()) { db.ListItem.Add(new ListItem { Completed = false, ListId = listitem.ListId, UserId = listitem.UserId, ListItemText = listitem.ListItemText, Created = now }); db.SaveChanges(); } return(Ok()); } }
public static void Register(HttpConfiguration config) { // Web API configuration and services // Web API routes config.MapHttpAttributeRoutes(); using (var context = new TodoListContext()) { config.Routes.MapODataRoute( routeName: "odata", routePrefix: "odata", model: context.GetEdm(), batchHandler: new DefaultODataBatchHandler(GlobalConfiguration.DefaultServer) ); } config.Routes.MapHttpRoute( name: "DefaultApi", routeTemplate: "api/{controller}/{id}", defaults: new { id = RouteParameter.Optional } ); // Only used by TestController config.Routes.MapHttpRoute( name: "BreezeApi", routeTemplate: "breeze/{controller}/{action}" ); }
public IActionResult Delete(Int64 Id) { Respuesta oResponse = new Respuesta(); try { using (TodoListContext db = new TodoListContext()) { Tarea oTarea = db.Tarea.Find(Id); db.Tarea.Remove(oTarea); db.SaveChanges(); oResponse.Result = 1; oResponse.Message = "Tarea eliminada exitosamente"; return(Ok(oResponse)); } } catch (Exception ex) { oResponse.Message = ex.Message; } return(Ok(oResponse)); }
public IActionResult Edit(TareaRequest oTareaRequest) { Respuesta oResponse = new Respuesta(); try { using (TodoListContext db = new TodoListContext()) { Tarea oTarea = db.Tarea.Find(oTareaRequest.Id); oTarea.Nombre = oTareaRequest.Nombre; oTarea.IdUsuario = oTareaRequest.IdUsuario; oTarea.IdEstado = oTareaRequest.IdEstado; oTarea.Descripcion = oTareaRequest.Descripcion; db.Entry(oTarea).State = Microsoft.EntityFrameworkCore.EntityState.Modified; db.SaveChanges(); oResponse.Result = 1; oResponse.Message = "Tarea modificada exitosamente"; return(Ok(oResponse)); } } catch (Exception ex) { oResponse.Message = ex.Message; } return(Ok(oResponse)); }
public IActionResult Delete(UsuarioRequest oUsuarioRequest) { Respuesta oResponse = new Respuesta(); try { using (TodoListContext db = new TodoListContext()) { Usuario oUsuario = db.Usuario.Find(oUsuarioRequest.Id); db.Usuario.Remove(oUsuario); db.SaveChanges(); oResponse.Result = 1; oResponse.Message = "Usuario eliminado exitosamente"; return(Ok(oResponse)); } } catch (Exception ex) { oResponse.Message = ex.Message; } return(Ok(oResponse)); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, TodoListContext context) { loggerFactory.AddConsole(Configuration.GetSection("Logging")); loggerFactory.AddDebug(); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); app.UseBrowserLink(); } else { app.UseExceptionHandler("/Home/Error"); } app.UseStaticFiles(); app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller=Home}/{action=Index}/{id?}"); }); DbInitializer.Initialize(context); }
public void Initialize() { var options = new DbContextOptionsBuilder <TodoListContext>().UseInMemoryDatabase(Guid.NewGuid().ToString()).Options; var context = new TodoListContext(options); new InMemoryDatabasePopulator(context).PopulateData(); _provider = new ReaderProvider(context); }
public TodoRepositoryTest() { var builder = new DbContextOptionsBuilder <TodoListContext>(); builder.UseInMemoryDatabase(); _context = new TodoListContext(builder.Options); _repository = new TodoRepository(_context, Substitute.For <ILogger <TodoRepository> >()); }
public EFItemRepository(TodoListContext connection = null) { if (connection == null) { this.db = new TodoListContext(); } else { this.db = connection; } }
private ObservableCollection <TaskItem> GetTasks(TodoListContext db, Func <TaskItem, bool> predicate) { try { var list = db.Tasks.Where(predicate).OrderBy(x => x.DueToDate).ToList(); return(new ObservableCollection <TaskItem>(list)); } catch (ArgumentNullException) { return(new ObservableCollection <TaskItem>()); } }
public AbstractRepository(TodoListContext context) { this.context = context; var property = typeof(TodoListContext).GetProperties().SingleOrDefault(x => x.PropertyType == typeof(DbSet <T>)); if (property == null || !property.CanRead) { throw new ArgumentException("Entity " + typeof(T).Name + " does not exist in the current database context."); } this.persistentCollection = (DbSet <T>)property.GetValue(context, null); }
private async Task ToggleItemComplete(TaskItem item) { await Task.Run(() => { using (var db = new TodoListContext()) { var itemInDb = db.Tasks.Find(item.ID); itemInDb.Completed = item.Completed; db.SaveChanges(); } }); }
public async System.Threading.Tasks.Task CreateTodoList_creates_a_valid_todolistAsync() { using (var context = new TodoListContext(InMemoryOptions())) { var logger = GetMockedLogger(); var handler = new CreateTodoListHandler(context, logger); var id = await handler.Handle(new CreateNewTodoListCommand("A new todo list"), default(CancellationToken)); Assert.Equal(1, id); Assert.Equal("A new todo list", context.TodoLists.Where(t => t.Id == 1).SingleOrDefault().Name); } }
public void Initialize() { var options = new DbContextOptionsBuilder <TodoListContext>().UseInMemoryDatabase(Guid.NewGuid().ToString()).Options; _context = new TodoListContext(options); new InMemoryDatabasePopulator(_context).PopulateData(); var dateTimeWrapper = A.Fake <IDateTimeWrapper>(); A.CallTo(() => dateTimeWrapper.Now).Returns(DEFAULT_DATE_NOW); _provider = new WriterProvider(_context, dateTimeWrapper); }
private async Task OnDeleteTodoCommandExecute(object parameter) { var item = (TaskItem)parameter; _eventAggregator.Publish(new TaskItemDeleted(item)); await Task.Run(() => { using (var db = new TodoListContext()) { var itemToDelete = db.Tasks.Find(item.ID); db.Tasks.Remove(itemToDelete); db.SaveChanges(); } }); }
private async Task OnSaveItemCommandExecute() { _eventAggregator.Publish(new TaskItemUpdated(Todo)); _eventAggregator.Publish(new TodoEditorShouldCloseItself()); await Task.Run(() => { using (var db = new TodoListContext()) { var item = db.Tasks.Find(Todo.ID); item.Name = Todo.Name; item.Completed = Todo.Completed; item.DueToDate = Todo.DueToDate; db.SaveChanges(); } }); }
public ActionResult <IEnumerable <string> > DeleteItem(int id) { using (var db = new TodoListContext()) { foreach (var item in db.ListItem) { if (item.Id == id) { db.ListItem.Remove(item); } } db.SaveChanges(); } return(Get()); }
private async Task OnAddNewTaskCommandExecuted() { var task = new TaskItem { Name = TaskName, DueToDate = SelectedDate }; _eventAggregator.Publish(new TaskItemAdded(task)); TaskName = string.Empty; await Task.Run(() => { using (var db = new TodoListContext()) { db.Tasks.Add(task); db.SaveChanges(); } }); }
private async Task OnRefreshListCommandExecuted() { ObservableCollection <TaskItem> old = null, current = null, following = null; await Task.Run(() => { using (var db = new TodoListContext()) { old = GetTasks(db, FindOldTasks); current = GetTasks(db, FindCurrentTasks); following = GetTasks(db, FindFollowingTasks); } Loading = false; }); ReplaceList(OldTasks, old); ReplaceList(CurrentTasks, current); ReplaceList(FollowingTasks, following); }
public UserResponseSvr Auth(AuthRequest model) { UserResponseSvr userResponse = new UserResponseSvr(); using (var db = new TodoListContext()) { string spassword = Encript.GetSHA256(model.Password); var usuario = db.Usuario.Where(d => d.UserName == model.UserName && d.Password == spassword).FirstOrDefault(); if (usuario == null) { return(null); } userResponse.userName = usuario.UserName; userResponse.token = GetToken(usuario); } return(userResponse); }
static void Main(string[] args) { var builder = new DbContextOptionsBuilder(); builder.UseSqlite("Data Source=./Data/TodoListDatabase.db"); using (var context = new TodoListContext(builder.Options)) { var todolist = new Domain.TodoList("minha lista exemplo"); todolist.Todos.Add(new Domain.Todo("Todo 1", true)); todolist.Todos.Add(new Domain.Todo("Todo 2", true)); todolist.Todos.Add(new Domain.Todo("Todo 3", true)); todolist.Todos.Add(new Domain.Todo("Todo 4", true)); todolist.Todos.Add(new Domain.Todo("Todo 5", true)); todolist.Todos.Add(new Domain.Todo("Todo 6", true)); todolist.Todos.Add(new Domain.Todo("Todo 7", true)); context.TodoLists.Add(todolist); context.SaveChanges(); } }