public static async Task <IList <Problem> > GetAllUnaccepted() { using (var problemRepository = new ProblemRepository()) { return(await problemRepository.GetAllUnaccepted()); } }
public static async Task <Problem> GetAsync(Guid id) { using (var problemRepository = new ProblemRepository()) { return(await problemRepository.GetAsync(id)); } }
public IEnumerable <Problem> GetAllProblems() { ProblemRepository problem = new ProblemRepository(Startup.connectionString); IEnumerable <Problem> problems = problem.GetAllProblems(); return(problems); }
public ServiceProblem(IConfiguration config) { this.serviceZabbix = new ServiceZabbix(); this.serviceUser = new ServiceUser(config); this.problemRepo = new ProblemRepository(config); this.userRepo = new UserRepository(config); }
public static async Task <Problem> UpdateAsync(Problem problem) { using (var problemRepository = new ProblemRepository()) { return(await problemRepository.UpdateAsync(problem)); } }
public ProblemRepositoryTest() { // Perform factory set up (once for entire test run) IGenerationSessionFactory factory = AutoPocoContainer.Configure(x => { x.Conventions(c => c.UseDefaultConventions()); x.AddFromAssemblyContainingType <Member>(); x.Include <Member>() .Setup(m => m.Id).Use <ObjectIdDataSource>() .Setup(m => m.OpenId).Random(5, 10) .Setup(m => m.UserName).Random(5, 7); x.Include <Problem>() .Setup(p => p.Id).Use <ObjectIdDataSource>() .Setup(p => p.Text).Use <LoremIpsumSource>() .Setup(p => p.Title).Random(7, 12); x.Include <Response>() .Setup(r => r.Text).Use <LoremIpsumSource>(); }); // Generate one of these per test (factory will be a static variable most likely) _session = factory.CreateSession(); _conn = new DbConnexion("Test_LittleProblem"); _problemRepository = new ProblemRepository(_conn); _problemCollection = _conn.Collection <Problem>(CollectionNames.Problem); }
public void OnGet() { Keywords = _keyword.GetKeywords(); int pageId = Convert.ToInt32(Request.RouteValues["id"]); Problems = ProblemRepository.GetId(pageId); }
public void PostProblem(string id) { Problem problem = new Problem { problem = id }; ProblemRepository problemRepository = new ProblemRepository(Startup.connectionString); problemRepository.Create(problem); }
public static async Task <bool> DeleteAsync(Guid id) { using (var problemRepository = new ProblemRepository()) { var problemToDelete = await problemRepository.GetAsync(id); return(await problemRepository.DeleteAsync(problemToDelete)); } }
public List <problem> SearchListProblem(FilterModel filter) { return(ProblemRepository.FindBy(p => p.status != 2 && (filter.FromDate <= p.created_date && p.created_date <= filter.ToDate) && (Equals(filter.Address, null) || p.apartment.address.Contains(filter.Address)) && (Equals(filter.Building, null) || p.apartment.building.Contains(filter.Building)) && (Equals(filter.NoApartment, null) || p.apartment.no_apartment.Contains(filter.NoApartment)) && (filter.ProjectId == -1 || p.apartment.project_id == filter.ProjectId) && (filter.Type == -1 || p.issue_id == filter.Type)).Include(p => p.apartment.project.project_content).Include(p => p.contract.user_profile1.user_profile_note).Include(p => p.problem_image).Include(p => p.problem_tracking).OrderByDescending(p => p.problem_id).ToList()); }
public void OnGet() { int pageIndex; //未输入页码时默认显示第一页 if (Request.Query["page"].Count == 0) { pageIndex = 1; } else { pageIndex = Convert.ToInt32(Request.Query["page"][0]); } ProblemRepository repository = new ProblemRepository(); problems = repository.Get(pageIndex, pageSize); pageAmount = (repository.CountOfProblem() / pageSize) + 1; }
public static async Task <Problem> AcceptProblem(Guid id) { using (var context = new Entities()) { var problemRepository = new ProblemRepository(context); var districtRepository = new DistrictRepository(context); var districts = await districtRepository.GetAllAsync().ConfigureAwait(false); var problem = await problemRepository.GetAsync(id, new[] { nameof(Problem.Districts) }); problem.UserId = Guid.Empty; foreach (var district in districts) { problem.Districts.Add(district); } return(await problemRepository.UpdateAsync(problem)); } }
protected override void SetUp() { base.SetUp(); settingsProvider = NewMock<ISettingsProvider>(); localStorageHandler = NewMock<ILocalStorageHandler>(); using (mocks.Record()) { settingsProvider.Expect(f => f.Get<string>(SettingsKeys.ProblemRepositoryDir)).Return(TestDir); } localStorageRepository = new ProblemRepository(localStorageHandler, settingsProvider); }
/// <summary> /// 删除异常信息 /// </summary> /// <param name="ids">要删除的异常信息编号</param> /// <returns>业务操作结果</returns> public OperationResult DeleteProblems(params int[] ids) { return(ProblemRepository.Delete(ids)); }
public static void Main(string[] args) { //CreateHostBuilder(args).Build().Run(); //利用Linq to EntityFramework,实现方法: //GetBy(IList < ProblemStatus > exclude, bool hasSummary, bool descByPublishTime), //该方法可以根据输入参数: //1.IList<ProblemStatus> exclude:不显示(排除)某些状态的求助 //2.bool hasSummary:只显示已有总结的求助(如果传入值为true的话) //3.bool descByPublishTime:按发布时间正序还是倒序 //实现方法:GetMessage(),靠将消息列表: //1.所有未读在已读前面 //2.未读和已读各自按生成时间排序 MessageRepository message = new MessageRepository(); IList <Message> messages = message.GetMessage(); ProblemRepository problem = new ProblemRepository(); IList <Problem> problems = problem.GetBy(new List <ProblemStatus> { ProblemStatus.canceled }, true, true); //SqlDbContext context = new SqlDbContext(); //var db = context.Database; //DataBase从何来 ////Create数据库的同时建立表结构, //db.EnsureCreated(); ////Enusure:存在才删除,不存在才创建 //db.EnsureDeleted(); //db.Migrate(); //类似于Update-Database: apply all pending migrations //本身不生成Migrations //利用EF,插入3个User对象 //SqlDbContext context = new SqlDbContext(); //User user1= new User //{ // Name = "叶飞", // Password = 1234, // IsMale = true, // BCredit = 12, // CreateTime = new DateTime(2021, 7, 27) //}; //User user2 = new User //{ // Name = "韩佳宝", // Password = 2345, // IsMale = true, // BCredit = 20, // CreateTime = new DateTime(2021, 7, 1) //}; //User user3 = new User //{ // Name = "夏康平", // Password = 3456, // IsMale = true, // BCredit = 25, // CreateTime = new DateTime(2021, 8, 1) //}; //context.Add(user1); //context.Add(user2); //context.Add(user3); //通过主键找到其中一个User对象 //User user = context.Find<User>(2); //修改该User对象的Name属性,将其同步到数据库 //user.Name = "李腾"; //不加载User对象,仅凭其Id用一句Update SQL语句完成上题 //User user = new User { Id = 1 }; //context.Attach<User>(user); //user.Name = "马云"; //User user = new User { Id = 1 }; //user.Name = "马花藤"; //user.CreateTime = new DateTime(2021, 7, 27); //context.Update<User>(user); //删除该用户 //User user = context.Find<User>(3); //context.Remove<User>(user); //context.SaveChanges(); }
/// <summary> /// 添加异常信息 /// </summary> /// <param name="dtos">要添加的异常信息DTO信息</param> /// <returns>业务操作结果</returns> public OperationResult AddProblems(params ProblemDto[] dtos) { return(ProblemRepository.Insert(dtos)); }
/// <summary> /// 更新异常信息 /// </summary> /// <param name="dtos">包含更新信息的异常DTO信息</param> /// <returns>业务操作结果</returns> public OperationResult EditProblems(params ProblemDto[] dtos) { return(ProblemRepository.Update(dtos)); }
public SingleModel() { _repository = new ProblemRepository(); }
public Problem GetProblemById(int id) { ProblemRepository problem = new ProblemRepository(Startup.connectionString); return(problem.Get(id)); }
public List <Problem> GetProblemList() { return(ProblemRepository.GetProblems()); }
public ProblemModel() { _problem = new ProblemRepository(); }
public void SaveProblem(problem problem) { ProblemRepository.Save(problem); }
public problem GetProblemById(int id) { return(ProblemRepository.FindBy(p => p.problem_id == id).FirstOrDefault()); }
public NewModel() { _problemrepository = new ProblemRepository(); }
public List <Problem> GetProblemList(Category Category) { return(ProblemRepository.GetProblems(Category)); }
public Problem GetProblemByProblemId(string ProblemId, Category category) { return(ProblemRepository.GetProblems().FirstOrDefault(p => p.ProblemId.Equals(ProblemId) && p.Category.Equals(category))); }
public ProblemAPIController() { _repo = new ProblemRepository(); }
public static IProblemRepository GetProblemRepository() { var m = new Mock<IDatabaseFactory>(); var repo = new ProblemRepository(m.Object); return repo; }
public CsvUnitOfWork() { var problems = CSVHelper.LoadProblems(); Problems = new ProblemRepository(problems); }
/// <summary> /// 检查异常信息是否存在 /// </summary> /// <param name="predicate">检查谓语表达式</param> /// <param name="id">更新的异常信息编号</param> /// <returns>异常信息是否存在</returns> public bool CheckProblemExists(Expression <Func <Problem, bool> > predicate, int id = 0) { return(ProblemRepository.CheckExists(predicate, id)); }
public EditModel() { _repository = new ProblemRepository(); }
public NewModel() { _problemRepository = new ProblemRepository(); _keyword = new KeywordRepository(); }