public IActionResult Edit(Models.Task task, int?id) { if (task == null || id == null) { return(RedirectToAction("Index", "Home")); } using (var db = new TaskDbContext()) { var taskToEdit = db.Tasks.Find(id); if (taskToEdit == null) { return(RedirectToAction("Index", "Home")); } taskToEdit.Title = task.Title; db.SaveChanges(); } return(RedirectToAction("Index", "Home")); }
public IActionResult Details(int?id) { if (id == null) { return(RedirectToAction("Index", "Home")); } using (var db = new TaskDbContext()) { var task = db.Tasks.Find(id); if (task == null) { return(RedirectToAction("Index", "Home")); } return(View(task)); } }
public IActionResult Delete(int?id) { if (id == null) { return(RedirectToAction("Index", "Home")); } using (var db = new TaskDbContext()) { var task = db.Tasks.Find(id); if (task == null) { return(RedirectToAction("Index", "Home")); } db.Tasks.Remove(task); db.SaveChanges(); } return(RedirectToAction("Index", "Home")); }
public async Task <IHttpActionResult> PendingQuery() { try { using (TaskDbContext db = new TaskDbContext()) { var queries = await db.Queries.Where(q => q.QueryStatus == QueryStatus.Pending).ToListAsync(); if (queries.Count != 0) { return(Ok(queries)); } } } catch (Exception) { return(BadRequest()); } return(NotFound()); }
public async Task <IHttpActionResult> IsBusyWorker(int workerId) { try { using (TaskDbContext db = new TaskDbContext()) { var worker = await db.Workers.FirstOrDefaultAsync(q => q.Id == workerId); if (worker != null) { return(Ok(worker)); } } } catch (Exception) { return(BadRequest()); } return(NotFound()); }
public void TaskService_GetsAllTasks_GivenTheyExist() { var options = new DbContextOptionsBuilder <TaskDbContext>() .UseInMemoryDatabase("gets_all").Options; using var context = new TaskDbContext(options); var sut = new TaskService(context); sut.Create(new Data.Models.Task { Id = 1 }); sut.Create(new Data.Models.Task { Id = 2 }); var allTasks = sut.GetAll(); allTasks.Count.Should().Be(2); }
public async Task <IHttpActionResult> BusyWorkers() { try { using (TaskDbContext db = new TaskDbContext()) { var workers = await db.Workers.Where(q => q.IsBusy).ToListAsync(); if (workers.Count != 0) { return(Ok(workers)); } } } catch (Exception) { return(BadRequest()); } return(NotFound()); }
public async Task <IHttpActionResult> StatusQuery(int id) { try { using (TaskDbContext db = new TaskDbContext()) { var query = await db.Queries.FirstOrDefaultAsync(q => q.Id == id); if (query == null) { return(NotFound()); } return(Ok(query.QueryStatus)); } } catch (Exception ex) { return(BadRequest()); } }
public void PutTask() { using (_context = new TaskDbContext(options)) { List <Tasks> testTasks = GetTestTasks(); foreach (Tasks x in testTasks) { _context.AllTasks.Add(x); } _context.SaveChanges(); testTasks[0].Title = "Eek Help! Oh no, Molly."; // Arrange TaskController controller = new TaskController(_context); // Act controller.Put(1, testTasks[0]); Tasks resultGet = controller.Get(1); // Assert Assert.Equal(testTasks[0], resultGet); } }
public async Task <IHttpActionResult> Worker([FromBody] Worker worker) { if (worker == null) { return(StatusCode(HttpStatusCode.NoContent)); } try { using (TaskDbContext db = new TaskDbContext()) { db.Workers.Add(worker); await db.SaveChangesAsync(); } return(StatusCode(HttpStatusCode.Created)); } catch (Exception ex) { return(BadRequest()); } }
public async Task GetTaskAll_ShouldExecuteRepository_GetTaskAll() { using (var context = new TaskDbContext(contextOptions, configuration, DataBaseFlags.Test)) { //Arrange var textService = new Services.TaskService(context, _mapper, _cacheTaskService.Object); var controller = new TaskController(textService); //Act var actionResultFromController = await controller.GetAllTask(); //Assert var objectResult = actionResultFromController.Result as OkObjectResult; var taskResults = objectResult.Value as List <TaskResultModel>; Assert.NotNull(objectResult); Assert.NotNull(taskResults); Assert.Equal(200, objectResult.StatusCode); Assert.Equal(_textTaskResult[0].Count, taskResults[0].ListGuids[0].ListFoundWord[0].Count); // 1 Assert.Equal(_textTaskResult[1].Count, taskResults[0].ListGuids[0].ListFoundWord[1].Count); // 21 } }
public async Task AddUserTest() { var user = await _serviceFactory.Invoke().AddUser("Иван", "Иванов"); Assert.NotNull(user); user = await _serviceFactory.Invoke().AddUser("Иван", "Петров"); Assert.NotNull(user); user = await _serviceFactory.Invoke().AddUser("Петр", "Иванов"); Assert.NotNull(user); Assert.CatchAsync(() => _serviceFactory.Invoke().AddUser("Иван", "Иванов")); using (var db = new TaskDbContext()) { var usersCount = db.Users.Count(); Assert.AreEqual(usersCount, 3); } }
public async Task <IHttpActionResult> CountPendingByQuery(int id) { try { using (TaskDbContext db = new TaskDbContext()) { var query = await db.Queries.FirstOrDefaultAsync(q => q.Id == id && q.QueryStatus == QueryStatus.Pending); if (query == null) { return(NotFound()); } var count = await db.Queries.Where(q => q.QueryStatus == QueryStatus.Pending).CountAsync(q => q.CreatedAt < query.CreatedAt); return(Ok(count)); } } catch (Exception ex) { return(BadRequest()); } }
public static void Init() { Queue = new BufferQueue <SystemLogEntity>(); var td = new System.Threading.Thread(() => { using (TaskDbContext db = new TaskDbContext()) { while (true) { Queue.Read((item, index) => { db.SystemLog.Add(item); }); db.SaveChanges(); System.Threading.Thread.Sleep(5000); } } }); td.IsBackground = true; td.Start(); }
protected void Application_Start() { //AreaRegistration.RegisterAllAreas(); GlobalConfiguration.Configure(WebApiConfig.Register); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); //BundleConfig.RegisterBundles(BundleTable.Bundles); SQLHelper.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConn"].ConnectionString; LogManager.Init(); Common.QuartzManager.InitScheduler(); using (TaskDbContext db = new TaskDbContext()) { var list = db.Task.Where(m => m.Status == (int)TaskStatus.Running).ToList(); foreach (var task in list) { Common.QuartzManager.StartWithRetry(task); } } }
public async System.Threading.Tasks.Task AddAsync_ValidRequest_CreateListAndTask() { using (var context = new TaskDbContext(_options)) { var taskListRepo = new TaskListRepository(context); var taskRepo = new TaskRepository(context); var taskList = new TaskList { Title = "New List", OwnerId = Guid.NewGuid().ToString(), CreatedDate = DateTimeOffset.Now }; var newTaskList = context.TaskLists.Add(taskList).Entity; var task = new TaskModel { Description = "Write a Task List", TaskList = newTaskList, CreatedDate = DateTimeOffset.Now, Start = DateTimeOffset.Now, End = DateTimeOffset.Now.AddMinutes(45), Status = Domain.Enums.TaskModelStatus.Open }; var newTask = context.Tasks.Add(task).Entity; context.SaveChanges(); var getListTasks = await context.TaskLists.AsNoTracking().Include(x => x.Tasks).ToListAsync(); Assert.IsNotNull(newTaskList); Assert.IsNotNull(newTask); Assert.AreEqual(1, getListTasks.Count); Assert.AreEqual(1, getListTasks[0].Tasks.Count); Assert.AreEqual(newTask.Id, getListTasks[0].Tasks[0].Id); } }
public async Task RemoveUserTest() { const int userId = (int)UserIdPool.RemoveId; await AddUser(new User { Id = userId, Name = "Иван", Surname = "Иванов", }); var returnedId = await _serviceFactory.Invoke().RemoveUser(userId); User user; using (var db = new TaskDbContext()) { user = await db.Users.FindAsync(userId); } Assert.IsNull(user); Assert.AreEqual(userId, returnedId); }
public async Task <IHttpActionResult> CancelQuery(int id) { try { using (TaskDbContext db = new TaskDbContext()) { var query = await db.Queries.FirstOrDefaultAsync(q => q.Id == id && (q.QueryStatus == QueryStatus.Pending)); if (query == null) { return(NotFound()); } query.QueryStatus = QueryStatus.Cance; await db.SaveChangesAsync(); return(Ok(query)); } } catch (Exception ex) { return(BadRequest()); } }
public ApiResponseMessage StopTask(Guid id) { using (TaskDbContext db = new TaskDbContext()) { var task = db.Task.FirstOrDefault(m => m.Id == id); if (task != null && task.Status > (int)TaskStatus.Stop) { bool success = false; var list = db.ServerNodes.Where(m => m.Status == 1).ToList(); var header = Header; foreach (var node in list) { var result = HttpRequest.Send($"http://{node.Host}/api/Quartz/Stop/{task.Id.ToString()}", "post", null, header); success = success || result.Key == System.Net.HttpStatusCode.OK; } if (success) { //更新任务状态为已停止 _repositoryFactory.Tasks.ModifyBy(m => m.Id == task.Id, m => new Task { Status = (int)TaskStatus.Stop, NextRunTime = null }); if (db.SaveChanges() > 0) { return(ServiceResult(ResultStatus.Success, "任务已停止运行!")); } return(ServiceResult(ResultStatus.Failed, "更新任务状态失败!")); } else { return(ServiceResult(ResultStatus.Failed, "任务停止失败!")); } } } return(ServiceResult(ResultStatus.Failed, "当前任务状态下不能停止!")); }
static async Task Main(string[] args) { using (var context = new TaskDbContext()) { try { int lastDbTimestamp = context.ExchangeRates.Select(x => x.Timestamp).Max(); if (lastDbTimestamp < GetLastTimestampYesterday()) { ExchangeRate currentRate = MapExchangeRate(await Rates.GetRate( Constants.BaseCurrency, Constants.TargetCurrency, null)); if (currentRate != null) { context.ExchangeRates.Add(currentRate); context.SaveChanges(); Console.WriteLine("Database was updated."); } else { Console.WriteLine("Database was not updated."); } } else { Console.WriteLine("Database is up to date."); } } catch (Exception ex) { //add to log ex.Message Console.WriteLine("Error: DB Update failed"); } } }
public async Task <IHttpActionResult> Login([FromBody] Login login) { try { using (TaskDbContext db = new TaskDbContext()) { var worker = await db.Workers.FirstOrDefaultAsync(w => w.NickName == login.NickName && w.Password == login.Password); if (worker != null) { login.Role = Role.Worker; login.Id = worker.Id; worker.IsLogin = true; await db.SaveChangesAsync(); return(Ok(login)); } else { var user = await db.Users.FirstOrDefaultAsync(u => u.UserName == login.NickName && u.Password == login.Password); if (user != null) { login.Role = Role.User; login.Id = user.Id; return(Ok(login)); } } } } catch (Exception ex) { return(BadRequest()); } return(NotFound()); }
public UserRepository(TaskDbContext dbContext) : base(dbContext) { }
public EFRepository(TaskDbContext dbContext) { _dbContext = dbContext; }
public static List <T> ObtenerTodoInclude <T, I>(Expression <Func <T, I> > expresion) where T : class where I : class { var ctx = new TaskDbContext(); return(ctx.Set <T>().Include <T, I>(expresion).ToList()); }
public LoginRepository(TaskDbContext context, IOptions <AppSettings> appSettings) { this._appSettings = appSettings.Value; this.context = context; }
public static List <T> ObtenerTodo <T>() where T : class { var ctx = new TaskDbContext(); return(ctx.Set <T>().ToList <T>()); }
public static void InsertarSinGuardar <T>(T elemento, TaskDbContext ctx) where T : class { ctx.Add <T>(elemento); }
public TaskRepository() { context = new TaskDbContext(); }
public HomeController(ILogger <HomeController> logger, TaskDbContext context) { _logger = logger; _context = context; }
public TaskService(TaskDbContext dbContext) { _db = dbContext; }