public bool Insert(ArticleLanguage articlelanguage) { int autonumber = 0; ArticleLanguageDAC articlelanguageComponent = new ArticleLanguageDAC(); bool endedSuccessfuly = articlelanguageComponent.InsertNewArticleLanguage(ref autonumber, articlelanguage.ArticleId, articlelanguage.LanguageId, articlelanguage.ArticleName, articlelanguage.ArticleContent, articlelanguage.ArticleAttachment, articlelanguage.AuthorAlias, articlelanguage.ArticleAlias, articlelanguage.PostDate, articlelanguage.PublishStartDate, articlelanguage.PublishEndDate, articlelanguage.RevisionDate, articlelanguage.ModifiedDate, articlelanguage.ArticleSummary); if (endedSuccessfuly) { articlelanguage.ArticleLanguageId = autonumber; } return(endedSuccessfuly); }
public IHttpActionResult Articles(ArticleLanguage language) { try { if (!ModelState.IsValid) { return(BadRequest("Passed information isn't valid.")); } var src = Mapper.MapSource(language); if (src != null) { var da = new DataAccess(); var arts = da.GetArticles(src); if (arts == null) { return(NotFound()); } // Let's convert the article objects var articles = Mapper.MapArticle(arts); if (articles == null) { throw new NotImplementedException(); } return(Ok(articles)); } else { throw new NotImplementedException(); } } catch (Exception ex) { logger.Error(ex, "Attempt to get articles from language " + language.Language + " failed: " + ex.Message); return(BadRequest("Something went wrong while saving comment.")); } }
// Map ArticleLanguage object to DAL.Source object public static Source MapSource(ArticleLanguage lang) { try { if (lang == null) { throw new NotImplementedException(); } var src = new Source() { Language = lang.Language }; return(src); } catch (Exception ex) { logger.Error(ex, "Attempt to map ArticleLanguage " + lang.Language + " to Source failed: " + ex.Message); return(null); } }
public List <ArticleLanguage> GetAllByArticleId(int ArticleId) { ArticleLanguageDAC _articleLanguageComponent = new ArticleLanguageDAC(); IDataReader reader = _articleLanguageComponent.GetAllArticleLanguage("ArticleId = " + ArticleId).CreateDataReader(); List <ArticleLanguage> _articleLanguageList = new List <ArticleLanguage>(); while (reader.Read()) { if (_articleLanguageList == null) { _articleLanguageList = new List <ArticleLanguage>(); } ArticleLanguage _articleLanguage = new ArticleLanguage(); if (reader["ArticleLanguageId"] != DBNull.Value) { _articleLanguage.ArticleLanguageId = Convert.ToInt32(reader["ArticleLanguageId"]); } if (reader["ArticleId"] != DBNull.Value) { _articleLanguage.ArticleId = Convert.ToInt32(reader["ArticleId"]); } if (reader["LanguageId"] != DBNull.Value) { _articleLanguage.LanguageId = Convert.ToInt32(reader["LanguageId"]); } if (reader["ArticleName"] != DBNull.Value) { _articleLanguage.ArticleName = Convert.ToString(reader["ArticleName"]); } if (reader["ArticleContent"] != DBNull.Value) { _articleLanguage.ArticleContent = Convert.ToString(reader["ArticleContent"]); } if (reader["ArticleAttachment"] != DBNull.Value) { _articleLanguage.ArticleAttachment = Convert.ToString(reader["ArticleAttachment"]); } if (reader["AuthorAlias"] != DBNull.Value) { _articleLanguage.AuthorAlias = Convert.ToString(reader["AuthorAlias"]); } if (reader["ArticleAlias"] != DBNull.Value) { _articleLanguage.ArticleAlias = Convert.ToString(reader["ArticleAlias"]); } if (reader["PostDate"] != DBNull.Value) { _articleLanguage.PostDate = Convert.ToDateTime(reader["PostDate"]); } if (reader["PublishStartDate"] != DBNull.Value) { _articleLanguage.PublishStartDate = Convert.ToDateTime(reader["PublishStartDate"]); } if (reader["PublishEndDate"] != DBNull.Value) { _articleLanguage.PublishEndDate = Convert.ToDateTime(reader["PublishEndDate"]); } if (reader["RevisionDate"] != DBNull.Value) { _articleLanguage.RevisionDate = Convert.ToDateTime(reader["RevisionDate"]); } if (reader["ModifiedDate"] != DBNull.Value) { _articleLanguage.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); } if (reader["ArticleSummary"] != DBNull.Value) { _articleLanguage.ArticleSummary = Convert.ToString(reader["ArticleSummary"]); } _articleLanguage.NewRecord = false; _articleLanguageList.Add(_articleLanguage); } reader.Close(); return(_articleLanguageList); }
public ArticleLanguage GetByArticleIDlanguageId(int ArticleId, int LanguageId) { ArticleLanguageDAC _articleLanguageComponent = new ArticleLanguageDAC(); IDataReader reader = _articleLanguageComponent.GetByIDArticleIdLanguageIdArticlelanguage(ArticleId, LanguageId); ArticleLanguage _articleLanguage = null; while (reader.Read()) { _articleLanguage = new ArticleLanguage(); if (reader["ArticleLanguageId"] != DBNull.Value) { _articleLanguage.ArticleLanguageId = Convert.ToInt32(reader["ArticleLanguageId"]); } if (reader["ArticleId"] != DBNull.Value) { _articleLanguage.ArticleId = Convert.ToInt32(reader["ArticleId"]); } if (reader["LanguageId"] != DBNull.Value) { _articleLanguage.LanguageId = Convert.ToInt32(reader["LanguageId"]); } if (reader["ArticleName"] != DBNull.Value) { _articleLanguage.ArticleName = Convert.ToString(reader["ArticleName"]); } if (reader["ArticleContent"] != DBNull.Value) { _articleLanguage.ArticleContent = Convert.ToString(reader["ArticleContent"]); } if (reader["ArticleAttachment"] != DBNull.Value) { _articleLanguage.ArticleAttachment = Convert.ToString(reader["ArticleAttachment"]); } if (reader["AuthorAlias"] != DBNull.Value) { _articleLanguage.AuthorAlias = Convert.ToString(reader["AuthorAlias"]); } if (reader["ArticleAlias"] != DBNull.Value) { _articleLanguage.ArticleAlias = Convert.ToString(reader["ArticleAlias"]); } if (reader["PostDate"] != DBNull.Value) { _articleLanguage.PostDate = Convert.ToDateTime(reader["PostDate"]); } if (reader["PublishStartDate"] != DBNull.Value) { _articleLanguage.PublishStartDate = Convert.ToDateTime(reader["PublishStartDate"]); } if (reader["PublishEndDate"] != DBNull.Value) { _articleLanguage.PublishEndDate = Convert.ToDateTime(reader["PublishEndDate"]); } if (reader["RevisionDate"] != DBNull.Value) { _articleLanguage.RevisionDate = Convert.ToDateTime(reader["RevisionDate"]); } if (reader["ModifiedDate"] != DBNull.Value) { _articleLanguage.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); } if (reader["ArticleSummary"] != DBNull.Value) { _articleLanguage.ArticleSummary = Convert.ToString(reader["ArticleSummary"]); } _articleLanguage.NewRecord = false; } reader.Close(); return(_articleLanguage); }
public bool Update(ArticleLanguage articlelanguage, int old_articleLanguageId) { ArticleLanguageDAC articlelanguageComponent = new ArticleLanguageDAC(); return(articlelanguageComponent.UpdateArticleLanguage(articlelanguage.ArticleId, articlelanguage.LanguageId, articlelanguage.ArticleName, articlelanguage.ArticleContent, articlelanguage.ArticleAttachment, articlelanguage.AuthorAlias, articlelanguage.ArticleAlias, articlelanguage.PostDate, articlelanguage.PublishStartDate, articlelanguage.PublishEndDate, articlelanguage.RevisionDate, articlelanguage.ModifiedDate, articlelanguage.ArticleSummary, old_articleLanguageId)); }
private HttpRequestMessage CreateSearchRequestToService(Search search) { try { HttpRequestMessage requestMessage = CreateRequestToService(HttpMethod.Post, "api/Data/" + search.Criteria); if (search.Criteria == "Title") { var at = new ArticleTitle() { Title = search.SearchString }; requestMessage.Content = new ObjectContent <ArticleTitle>(at, new JsonMediaTypeFormatter()); } else if (search.Criteria == "Topic") { var at = new ArticleTopic() { Topic = search.SearchString }; requestMessage.Content = new ObjectContent <ArticleTopic>(at, new JsonMediaTypeFormatter()); } else if (search.Criteria == "Source") { var at = new ArticleSource() { Name = search.SearchString }; requestMessage.Content = new ObjectContent <ArticleSource>(at, new JsonMediaTypeFormatter()); } else if (search.Criteria == "Country") { var at = new ArticleCountry() { Country = search.SearchString }; requestMessage.Content = new ObjectContent <ArticleCountry>(at, new JsonMediaTypeFormatter()); } else if (search.Criteria == "Language") { var at = new ArticleLanguage() { Language = search.SearchString }; requestMessage.Content = new ObjectContent <ArticleLanguage>(at, new JsonMediaTypeFormatter()); } else if (search.Criteria == "Date") { var at = new ArticlePulished() { PublishedDate = Convert.ToDateTime(search.SearchString) }; requestMessage.Content = new ObjectContent <ArticlePulished>(at, new JsonMediaTypeFormatter()); } return(requestMessage); } catch (Exception ex) { // log the error here logger.Error(ex.Message); return(null); } }