private async Task GetArticlesListAsync() { using (ArticleDbContext articleDbContext = new ArticleDbContext()) { ArticleList = await articleDbContext.Articles.ToListAsync(); } }
public ActionResult UpsertLocale(Article item) { if (ModelState.IsValid) { String error = null; if (item.ArticleID == 0) { // create error = ArticleDbContext.getInstance().tryCreateNewLocaleArticle(item); } else { // edit error = ArticleDbContext.getInstance().tryEditArticle(item); } if (error != null) { ModelState.AddModelError("", error); } else { ViewBag.Message = "Edit '" + item.Name + "' successfully"; return(View(item)); } } return(View(item)); }
public ArtikleDataAccess() { _provider = InitServiceProviderDA.GetInstance().ServiceProvider; _dbContext = _provider.GetService <ArticleDbContext>(); _logger = _provider.GetService <ILogger>(); //{ Name = "ILoggerFactory" Id = "Microsoft.Extensions.Logging.ILoggerFactory"} }
public static List <T> GetList <T>(Expression <Func <T, bool> > expression) where T : BaseEntity, new() { using (var context = new ArticleDbContext()) { return(context.Set <T>().Where(expression).ToList()); } }
public static T Get <T>(int id) where T : BaseEntity { using (var context = new ArticleDbContext()) { return(context.Set <T>().Where(x => x.Id == id).FirstOrDefault()); } }
private async Task GetMainHeaderListAsync() { using (ArticleDbContext articleDbContext = new ArticleDbContext()) { MainHeaderList = await articleDbContext.MainHeaders.ToListAsync(); } }
public ActionResult EditProperties(int baseArticleID = 0, int version = 0, String lang = null) { Article item = ArticleDbContext.getInstance().findArticleByVersionAndLang(baseArticleID, version, lang); if (item == null) { // if locale not exists, create blank form, while inheriting latest base article's version var baseArticle = ArticleDbContext.getInstance().findLatestArticleByBaseArticleID(baseArticleID, null); if (baseArticle == null) { return(HttpNotFound()); } var article = new Article(); article.BaseArticleID = baseArticle.BaseArticleID; article.Lang = lang; article.Version = baseArticle.Version; item = article; } else { // if locale exists, treat as edit form } ViewBag.categoryID = getCategoriesForSelect(item.categoryID); return(View(item)); }
public ActionResult DetailsProperties(int baseArticleID = 0, int version = 0, String lang = null) { // find existing locale article for base article ID and version and lang Article item = ArticleDbContext.getInstance().findArticleByVersionAndLang(baseArticleID, version, lang); if (item == null) { // if locale not exists, create blank form, while inheriting latest base article's version var baseArticle = ArticleDbContext.getInstance().findLatestArticleByBaseArticleID(baseArticleID, null); if (baseArticle == null) { return(HttpNotFound()); } var article = new Article(); article.BaseArticleID = baseArticle.BaseArticleID; article.Lang = lang; article.Version = baseArticle.Version; item = article; } else { // if locale exists, treat as edit form } return(View(item)); }
public ActionResult CreateNewVersion(Article article) { if (ModelState.IsValid) { article.Lang = null; article.Version = 0; var error = ArticleDbContext.getInstance().tryCreateNewArticle(article); if (error == null) { ModelState.Clear(); var a = ArticleDbContext.getInstance().findLatestArticleByBaseArticle(article); TempData["Message"] = "New Version of '" + a.Name + "' with version: " + a.Version + " successfully created."; return(RedirectToAction("DetailsLocale", new { baseArticleID = a.BaseArticleID, version = a.Version, lang = a.Lang })); } else { ModelState.AddModelError("", error); return(View()); } } else { return(View()); } }
static void Main(string[] args) { var url = "https://interface.meiriyiwen.com/article/random"; string json = HttpHelper.SendPost(url, new Dictionary <string, string>(), "get"); JObject obj = JObject.Parse(json); using (ArticleDbContext db = new ArticleDbContext("Server=.;Database=Reading;User ID=sa;Password=123456")) { var title = (string)obj["data"]["title"]; var author = (string)obj["data"]["author"]; //表中是否存在此条数据 bool exist = db.Articles.Any(a => a.Title == title && a.Author == author); if (!exist) { db.Articles.Add(new Articles() { Title = title, Author = author, Details = (string)obj["data"]["content"], Summary = (string)obj["data"]["digest"], Category = "阅读", IssueTime = DateTime.Now, UpdateTime = DateTime.Now }); db.SaveChanges(); } } }
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, ArticleDbContext articleDbContext) { if (!articleDbContext.Database.CanConnect()) { articleDbContext.Database.EnsureCreated(); } if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler("/Home/Error"); app.UseHsts(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseRouting(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapControllerRoute( name: "default", pattern: "{controller=Home}/{action=Index}/{id?}"); }); }
public static T Get <T>(Expression <Func <T, bool> > expression) where T : BaseEntity { using (var context = new ArticleDbContext()) { return(context.Set <T>().Where(expression).FirstOrDefault()); } }
public IndexModel(ILogger <IndexModel> logger, IHttpClientFactory clientFactory, ArticleDbContext articleDbContext) { _logger = logger; _clientFactory = clientFactory; _articleDbContext = articleDbContext; this.Articles = new List <Article>(); }
public static BaseEntity Update(BaseEntity entity) { using (var context = new ArticleDbContext()) { context.Set <BaseEntity>().Update(entity); context.SaveChanges(); return(entity); } }
public ArticleTopWidgetService(IWidgetBasePartService widgetService, IArticleService articleService, IApplicationContext applicationContext, IArticleTypeService articleTypeService, ArticleDbContext dbContext) : base(widgetService, applicationContext, dbContext) { _articleService = articleService; _articleTypeService = articleTypeService; }
public ActionResult ListArticleVersions(int baseArticleID = 0) { var article = new Article(); article.BaseArticleID = baseArticleID; var items = ArticleDbContext.getInstance().findAllArticlesByBaseArticle(article); return(View(items)); }
public ActionResult DeleteSingle(int id = 0) { var item = ArticleDbContext.getInstance().findArticleByID(id); if (item == null) { return(HttpNotFound()); } return(View(item)); }
public ActionResult List() { var items = ArticleDbContext.getInstance().findArticlesGroupByBaseVersion(); if (TempData["Message"] != null) { ViewBag.Message = TempData["Message"]; } return(View(items)); }
public ManagerController(IConfiguration configuration, ArticleDbContext articleDbContext, NotifyService notifyService, IMemoryCache memoryCache) { this.articleDbContext = articleDbContext; this.configuration = configuration; this.notifyService = notifyService; this.memoryCache = memoryCache; }
public ServiceController(VerificationCodeService verificationHelper, OssService ossService, ArticleDbContext articleDbContext, IServiceProvider serviceProvider) { this.verificationHelper = verificationHelper; this.ossService = ossService; this.articleDbContext = articleDbContext; this.serviceProvider = serviceProvider; }
public BlogController(ArticleDbContext articleDbContext, OssService ossService, IMemoryCache memoryCache, IConfiguration configuration) { this.articleDbContext = articleDbContext; this.ossService = ossService; this.memoryCache = memoryCache; pageSize = configuration.GetValue <int>("PageSize"); }
public ArticleTests() { var options = new DbContextOptionsBuilder <ArticleDbContext>() .UseNpgsql("User ID=root;Password=root;Host=localhost;Port=54320;Database=myarticle;") .Options; ArticleDbContext context = new ArticleDbContext(options); _unitofwork = new UnitOfWork(context); //_unitofwork = new Mock<IUnitOfWork>(); _articleService = new ArticleService(_unitofwork); }
public ArticleController(IConfiguration configuration, ArticleDbContext articleDbContext, OssService ossService, NotifyService notifyService) { this.articleDbContext = articleDbContext; this.ossService = ossService; this.notifyService = notifyService; this.configuration = configuration; pageSize = configuration.GetValue <int>("PageSize"); }
static void Main(string[] args) { IConfigurationRoot configuration = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json", optional: true, reloadOnChange: true).Build(); string connection = configuration.GetConnectionString("ArticleConnection"); var articleContext = ArticleDbContext.Create(connection); if (articleContext.AllMigrationsApplied()) { articleContext.Database.Migrate(); } }
public ActionResult PublishArticle(Article article) { if (ModelState.IsValid) { var datePublishStart = article.datePublishStart; var datePublishEnd = article.datePublishEnd; var item = ArticleDbContext.getInstance().findArticleByVersionAndLang(article.BaseArticleID, article.Version, "en"); if (item == null) { return(HttpNotFound()); } if (datePublishStart != null && datePublishEnd != null) { var start = datePublishStart.GetValueOrDefault(); var end = datePublishEnd.GetValueOrDefault(); if (start.CompareTo(end) > 0) { TempData["ErrorMessage"] = "Publish end date must be greater than publish start date"; return(RedirectToAction("DetailsLocale", new { baseArticleID = item.BaseArticleID, version = item.Version, lang = "en" })); } } item.datePublishStart = datePublishStart; item.datePublishEnd = datePublishEnd; var error = ArticlePublishedDbContext.getInstance().tryPublishArticle(item, true); if (error != null) { TempData["ErrorMessage"] = error; return(RedirectToAction("DetailsLocale", new { baseArticleID = item.BaseArticleID, version = item.Version, lang = "en" })); } else { TempData["Message"] = "'" + item.Name + "' Published"; return(RedirectToAction("DetailsLocale", new { baseArticleID = item.BaseArticleID, version = item.Version, lang = "en" })); } } else { foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { TempData["ErrorMessage"] = error.ErrorMessage; } } var item = ArticleDbContext.getInstance().findArticleByVersionAndLang(article.BaseArticleID, article.Version, "en"); return(RedirectToAction("DetailsLocale", new { baseArticleID = item.BaseArticleID, version = item.Version, lang = "en" })); } }
public ActionResult ListArticleVersions(int baseArticleID = 0) { var article = new Article(); article.BaseArticleID = baseArticleID; var items = ArticleDbContext.getInstance().findAllArticlesByBaseArticle(article); if (TempData["Message"] != null) { ViewBag.Message = TempData["Message"]; } return(View(items)); }
public ActionResult ApproveArticle(int baseArticleID = 0, int version = 0, String lang = null) { // find existing locale article for base article ID and version and lang Article item = ArticleDbContext.getInstance().findArticleByVersionAndLang(baseArticleID, version, lang); if (item == null) { return(HttpNotFound()); } else { // if locale exists, treat as edit form } return(View(item)); }
public static async Task SeedTopics(ArticleDbContext context) { if (!context.Topics.Any()) { context.Topics.Add(new Topic { TopicName = "Basketball" }); context.Topics.Add(new Topic { TopicName = "IT" }); context.Topics.Add(new Topic { TopicName = "Business" }); await context.SaveChangesAsync(); } }
public static async Task SeedRoles(ArticleDbContext context, RoleManager <Role> roleManager, UserManager <User> userManager) { if (!context.Roles.Any()) { await roleManager.CreateAsync(new Role { Name = "User" }); await roleManager.CreateAsync(new Role { Name = "Admin" }); await userManager.AddToRoleAsync(await userManager.FindByNameAsync("incorcadit"), "User"); await userManager.AddToRoleAsync(await userManager.FindByNameAsync("admin"), "User"); await userManager.AddToRoleAsync(await userManager.FindByNameAsync("admin"), "Admin"); await context.SaveChangesAsync(); } }
public ActionResult ApproveArticle(Article item) { if (ModelState.IsValid) { var error = ArticleDbContext.getInstance().tryRequestApproval(item, true); if (error != null) { ModelState.AddModelError("", error); } else { TempData["Message"] = "'" + item.Name + "' Approved"; return(RedirectToAction("DetailsLocale", new { baseArticleID = item.BaseArticleID, version = item.Version, lang = item.Lang })); } } return(View(item)); }
public SitemapRepository(ArticleDbContext articleDbContext, ISettingsProvider settingsProvider) { _articleDbContext = articleDbContext; _settingsProvider = settingsProvider; }