public void CreateNewWithCatAndRest(LibNews news, string[] categoryes, string nameRest, string login) { using (var ctx = new NewsEntities()) { var search = ctx.News.Where(c => c.Date == news.ReleaseDate.Date && c.Title == news.Title).ToList(); if (search.Count == 0) { int idRest = -1; var rests = ctx.Restorans.Where(c => c.Name == nameRest).ToList(); if (rests.Count != 0) { idRest = rests[0].Id; } else { Console.WriteLine("Ресторана не существует"); } News newNews = new News { Title = news.Title, Date = news.ReleaseDate, TextContent = news.TextContent, User = (login != null) ? login : null }; if (idRest != -1) { newNews.RefIdRest = idRest; } ctx.News.Add(newNews); ctx.SaveChanges(); mq.Send(newNews.TextContent); Console.WriteLine("Новая новость '" + news.Title + "' добавлена"); using (var ptx = new NewsEntities()) { SelectAllNews(); Console.WriteLine("Передана дата " + news.ReleaseDate.Date + " заголовок " + news.Title); var idNew = ptx.News.Where(c => c.Date == news.ReleaseDate.Date && c.Title == news.Title).First().Id_news; int idCateg = -1; foreach (var category in categoryes) { var check = ctx.Category.Where(c => c.CatName == category).ToList(); if (check.Count == 0) { ; } CreateCategory(category); idCateg = ptx.Category.Where(c => c.CatName == category).FirstOrDefault().IdCategories; CreateCategoryForNews(idCateg, idNew); } } } } }
public void CreateNewWithCat(LibNews news, string[] categoryes) { using (var ctx = new NewsEntities()) { var search = ctx.News.Where(c => c.Date == news.ReleaseDate.Date && c.Title == news.Title).ToList(); if (search.Count == 0) { News newNews = new News { Title = news.Title, Date = news.ReleaseDate, TextContent = news.TextContent }; ctx.News.Add(newNews); //ctx.SaveChanges(); mq.Send(newNews.TextContent); Console.WriteLine("Новая новость '" + news.Title + "' добавлена"); //using (var ptx = new NewsEntities()) //{ // SelectAllNews(); // Console.WriteLine("Передана дата " + news.ReleaseDate.Date + " заголовок " + news.Title); // var idNew = ptx.News.Where(c => c.Date == news.ReleaseDate.Date && c.Title == news.Title).First().Id_news; // int idCateg = -1; // foreach (var category in categoryes) // { // var check = ctx.Category.Where(c => c.CatName == category).ToList(); // if (check.Count == 0) // ; // //CreateCategory(category); // // idCateg = ptx.Category.Where(c => c.CatName == category).FirstOrDefault().IdCategories; // //CreateCategoryForNews(idCateg, idNew); // } //} } else { Console.WriteLine("Такая новость уже существует"); } } }
public void CreateNews(LibNews news) { using (var ctx = new NewsEntities()) { var search = ctx.News.Where(c => c.Date == news.ReleaseDate.Date && c.Title == news.Title).ToList(); if (search.Count == 0) { News newNews = new News { Title = news.Title, Date = news.ReleaseDate, TextContent = news.TextContent }; ctx.News.Add(newNews); ctx.SaveChanges(); Console.WriteLine("Новая новость '" + news.Title + "' добавлена"); } else { Console.WriteLine("Такая новость уже существует"); } } }