private static void InsertData(Article obj, string newDB) { if (CheckData(obj, newDB) == false) { CArticle.Insert(obj, new DAL()); } ; }
private static bool CheckData(Article obj, string newDB) { string q = "USE " + newDB + "; "; q += "SELECT * FROM " + ARTICLE.ARTICLE_TBL + " WHERE " + ARTICLE.ARTICLE_NAME + " = '" + obj.Article_name + "'; "; using (IDataReader redr = new DAL().Listreader(q)) { while (redr.Read() == true) { obj.Article_id = redr[ARTICLE.ARTICLE_ID].ToString(); CArticle.Update(obj, new DAL()); return(true); } return(false); } }
public HttpResponseMessage SearchNews(string tag, string country) { HttpResponseMessage response = Request.CreateResponse(); List <CArticle> articleList = new List <CArticle>(); var article = new CArticle { Content = "Test content", Country = new CCountry { Name = country }, Date = DateTime.Now, Html = new byte[10], Tags = new CTag[] { new CTag { Value = tag } }, Url = "Http://testurl.com" }; var count = 0; for (var i = 0; i < 50; i++) { String q = (count++).ToString(); // это всё равно не помогло =) отложенная операция - почему? article.Title = $"Test Title {q}"; articleList.Add(article); } CArticle[] articles = articleList.ToArray(); try { response.Headers.AcceptRanges.Add("articles"); response.StatusCode = HttpStatusCode.OK; response.Content = new ObjectContent(typeof(CArticle[]), articles, new XmlMediaTypeFormatter()); // response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue(""); // response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream"); } catch (Exception e) { response = Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message, new MediaTypeHeaderValue("application/xml")); } return(response); }