public async Task GetExistingArticleWithInformationFromDatabaseTest() { // arrange HAVIdatabaseContext dbContext = CreateDbContext(); ArticleRepository repository = new ArticleRepository(dbContext); Article article = new Article() { Id = 0, PurchaserId = 0, CountryId = 0, SupplierId = 0, ArticleInformationId = 0, InternalArticleInformationId = 0, VailedForCustomer = "Customer", DateCreated = DateTime.Now, ArticleInformationCompleted = 0, InternalArticalInformationCompleted = 0, ArticleState = 0, ErrorReported = 0, ErrorField = "Field", ErrorMessage = "Message", ErrorOwner = "Owner", ArticleInformation = new ArticleInformation(), InternalArticleInformation = new InternalArticleInformation() }; Article addedArticle = await repository.AddArticle(article); // act Article result = await repository.GetArticleWithInformation(addedArticle.ArticleInformationId); // assert Assert.IsTrue(result == addedArticle); dbContext.Dispose(); }
public HttpResponseMessage AddArticle([FromBody] ArticleModel articleModel) { ApiResultViewModel result = new ApiResultViewModel(); //驗證欄位資訊 if (!ModelState.IsValid) { result.Result = false; result.Status = ResponseCode.Fail.ToString(); result.Message = AllShared.GetModelStateError(ModelState); return(Request.CreateResponse(HttpStatusCode.OK, result)); } //取得使用者ID string UserID = JWTShared.GetUserID(Request.Headers.Authorization.Parameter); articleModel.UID = UserID; bool IsSuccess = articleRepository.AddArticle(articleModel); if (IsSuccess) { result.Result = true; result.Status = ResponseCode.Success.ToString(); result.Message = "新增成功!!!"; } else { result.Result = false; result.Status = ResponseCode.Fail.ToString(); result.Message = "新增資料時發生錯誤!!!"; } return(Request.CreateResponse(HttpStatusCode.OK, result)); }
public static void Create() { xx1 = new Article { //Id = 1, PublishTime = Global.BaseTime.AddDays(-1), Author = RegisterFactory.xx, Title = "first", Body = "virtual", Keywords = new List <ArticleAndKeyword> { new ArticleAndKeyword { Keyword = KeywordFactory.CSharp, Article = xx1 }, new ArticleAndKeyword { Keyword = KeywordFactory.SQL, Article = xx1 } }, Commnets = new List <Comment>(), AgreeCount = 1, DisagreeCount = 0, }; tt1 = new Article { //Id = 2, PublishTime = Global.BaseTime.AddDays(0), Author = RegisterFactory.tt, Title = "second", Body = "same", Keywords = new List <ArticleAndKeyword> { new ArticleAndKeyword { Keyword = KeywordFactory.JavaScript, Article = tt1 }, new ArticleAndKeyword { Article = tt1, Keyword = KeywordFactory.ASP }, }, Commnets = new List <Comment>(), AgreeCount = 2, DisagreeCount = 0 }; articleRepository.AddArticle(xx1); articleRepository.AddArticle(tt1); //articleRepository.AddRangeEntities(new List<Article> { xx1, tt1 }); }
public /*ArticleNewModel*/ int UIAddArticleNewModel(ArticleNewModel articleNewModel) { Article article = mapper.Map <Article>(articleNewModel); article.PublishTime = DateTime.Now; article.Author = new User(); article.Author = CurrentUser; return(_articleRepository.AddArticle(article)); //articleNewModel mapperNew = mapper.Map<ArticleNewModel>(article); }
public ActionResult Add(Article model) { var repo = new ArticleRepository(); var user = User.Identity; ViewBag.displayMenu = "Thanks"; model.UserId = user.GetUserId(); repo.AddArticle(model); return(View()); }
public ActionResult UploadArticle(Article article) { if (!(User.Identity.IsAuthenticated)) { return(Redirect("/")); } var userRepo = new UserRepository(Properties.Settings.Default.ConnectionString); article.UploadedBy = userRepo.GetUserByEmail(User.Identity.Name).Id; var ArticleRepo = new ArticleRepository(Properties.Settings.Default.ConnectionString); ArticleRepo.AddArticle(article); return(Redirect("/")); }
public ActionResult Add(ArticleInformation aInfo) { if (ModelState.IsValid) { using (var aRepository = new ArticleRepository()) { aRepository.AddArticle(aInfo); return(RedirectToAction("Manage")); } } return(View(aInfo)); }
public void CanInsertArticle() { Article articleToInsert = new Article(); var repo = new ArticleRepository(); articleToInsert.ArticleId = 5; articleToInsert.ArticleTitle = "How to survive Namek."; articleToInsert.ArticleContent = "A guide Namekians are DYING to read."; articleToInsert.DateAdded = DateTime.Today; articleToInsert.UserId = "00000000-0000-0000-0000-000000000000"; articleToInsert.Approved = true; repo.AddArticle(articleToInsert); Assert.AreEqual(5, articleToInsert.ArticleId); Assert.AreEqual(DateTime.Today, articleToInsert.DateAdded); }
public async Task <ActionResult <Article> > CreateArticle(Article article) { try { if (article == null) { return(BadRequest()); } var createdArticle = await _articleRepository.AddArticle(article); return(createdArticle); } catch (Exception) { return(StatusCode(StatusCodes.Status500InternalServerError, "Error retrieving data from the database.")); } }
public IHttpActionResult Add(string Title, string Body) { var repo = new ArticleRepository(); try { var parameters = new Article() { ArticleContent = Body, ArticleTitle = Title }; repo.AddArticle(parameters); return(Ok()); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public async Task GetExistingArticlesForPurchaserFromDatabaseTest() { // arrange HAVIdatabaseContext dbContext = CreateDbContext(); PurchaserRepository purchaserRepository = new PurchaserRepository(dbContext); Purchaser purchaser = new Purchaser() { Id = 0, ProfileId = 0, CountryId = 0, Profile = new Profile() { Id = 0, Username = "******", Password = "******", Usertype = 2 } }; ArticleRepository repository = new ArticleRepository(dbContext); Article article1 = new Article() { Id = 0, PurchaserId = 1, CountryId = 0, SupplierId = 0, ArticleInformationId = 0, InternalArticleInformationId = 0, VailedForCustomer = "Customer", DateCreated = DateTime.Now, ArticleInformationCompleted = 0, InternalArticalInformationCompleted = 0, ArticleState = 0, ErrorReported = 0, ErrorField = "Field", ErrorMessage = "Message", ErrorOwner = "Owner", ArticleInformation = new ArticleInformation(), InternalArticleInformation = new InternalArticleInformation() }; Article article2 = new Article() { Id = 0, PurchaserId = 1, CountryId = 0, SupplierId = 0, ArticleInformationId = 0, InternalArticleInformationId = 0, VailedForCustomer = "Customer", DateCreated = DateTime.Now, ArticleInformationCompleted = 0, InternalArticalInformationCompleted = 0, ArticleState = 0, ErrorReported = 0, ErrorField = "Field", ErrorMessage = "Message", ErrorOwner = "Owner", ArticleInformation = new ArticleInformation(), InternalArticleInformation = new InternalArticleInformation() }; await purchaserRepository.AddPurchaser(purchaser); Article addedArticle1 = await repository.AddArticle(article1); Article addedArticle2 = await repository.AddArticle(article2); // act List <Article> result = (List <Article>) await repository.GetArticlesForPurchaser(1); // assert Assert.IsTrue(result.Count == 2); Assert.IsTrue(result.Contains(addedArticle1)); Assert.IsTrue(result.Contains(addedArticle2)); dbContext.Dispose(); }
public int AddArticle(AC_Article m) { return(ar.AddArticle(m)); }