/// <summary>
/// Enter the news Id that needs to be update; then the details.
/// </summary>
/// <param name="news">enter the Id of the news.</param>
/// <param name="details">enter details.</param>
public static void Update(int news, string details)
{
var contextUserA = new NewsDbEntities();
var contextUserB = new NewsDbEntities();
try
{
var chooseNewsA = contextUserA.News.First(n => n.Id == news);
chooseNewsA.Text = chooseNewsA.Text + " --> " + details;
var chooseNewsB = contextUserB.News.First(n => n.Id == news);
chooseNewsB.Text = chooseNewsB.Text + " --> " + details;
}
catch (InvalidOperationException ex)
{
Console.WriteLine("Error: Enter a valid news Id.");
Console.WriteLine(ex);
}
try
{
contextUserA.SaveChanges();
Console.WriteLine("User A will see: Changes were successfully saved.");
Console.WriteLine();
Console.WriteLine("User B will see:");
contextUserB.SaveChanges();
}
catch (DbUpdateConcurrencyException) {
var chooseNews = contextUserA.News.First(n => n.Id == news);
var displayChanges = chooseNews.Text;
Console.WriteLine("Error: One more person works on this news and his/her changes were saved.");
Console.WriteLine();
Console.WriteLine("The new text is: {0}", displayChanges);
Console.WriteLine();
}
var contextUserC = new NewsDbEntities();
var chooseNewsC = contextUserC.News.First(n => n.Id == news);
Console.WriteLine("Enter the new update: ");
var line = Console.ReadLine();
var displayNewChanges = chooseNewsC.Text = chooseNewsC.Text + " --> " + line;
contextUserC.SaveChanges();
Console.WriteLine();
Console.WriteLine("Changes were successfully saved.");
Console.WriteLine();
Console.WriteLine("The new news is: {0}", displayNewChanges);
}
public static void Load()
{
var context = new NewsDbEntities();
var loadNews = context.News;
foreach (var news in loadNews)
{
Console.WriteLine("--{0}", news.Text);
}
}
public static void Football()
{
var context = new NewsDbEntities();
var newsA = new News()
{
Text = "Juventus - Milan"
};
var newsB = new News()
{
Text = "Barcelona - Real Madrid"
};
var newsC = new News()
{
Text = "Arsenal - Liverpool"
};
var newsD = new News()
{
Text = "PSG - Monaco"
};
var newsE = new News()
{
Text = "Bayern Munich - Borussia Dortmund"
};
context.News.Add(newsA);
context.News.Add(newsB);
context.News.Add(newsC);
context.News.Add(newsD);
context.News.Add(newsE);
context.SaveChanges();
Console.WriteLine("The 'Football' news were successefully add in the NewsDb database.");
}
public static void ComputerScience()
{
var context = new NewsDbEntities();
var newsA = new News()
{
Text = "The future of data science looks spectacular"
};
var newsB = new News()
{
Text = "New computer program first to recognise sketches more accurately than a human"
};
var newsC = new News()
{
Text = "How artificial intelligence is changing economic theory"
};
var newsD = new News()
{
Text = "Computer program fixes old code faster than expert engineers"
};
var newsE = new News()
{
Text = "A beautiful algorithm? The risks of automating online transactions"
};
context.News.Add(newsA);
context.News.Add(newsB);
context.News.Add(newsC);
context.News.Add(newsD);
context.News.Add(newsE);
context.SaveChanges();
Console.WriteLine("The 'Computer Science' news were successefully add in the NewsDb database.");
}
