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("Такая новость уже существует");
}
}
}
