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