public void datamagnet()
{
using (var dataBase = new NovelsModelContainer())
{
var queryNovel = from a in dataBase.Novels
orderby a.Name
select a;
foreach (var item in queryNovel)
{
novelinformation += item.Name + "\n" + "Chapters : " + item.Chapter + "\n" + "Genres : " + item.Genre + "\n\n";
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (var dataBase = new NovelsModelContainer())
{
var queryNovel = from a in dataBase.Novels
orderby a.Name
select a;
foreach (var item in queryNovel)
{
if (TextBox2.Text == item.Name)
{
dataBase.Novels.Remove(item);
}
}
dataBase.SaveChanges();
}
Response.Redirect(Request.RawUrl);
}
protected void Button1_Click(object sender, EventArgs e)
{
if (NovelChapter.Text.Length >= 1 && NovelText.Text.Length > 2)
{
try
{
using (var dataBase = new NovelsModelContainer())
{
var novelName = NovelText.Text;
int novelChapter;
if (!Int32.TryParse(NovelChapter.Text, out novelChapter))
{
Label4.Visible = true;
}
else
{
Label4.Visible = false;
var geen = "";
int counter = 1;
foreach (ListItem item in GenreCheckBox.Items)
{
if (item.Selected)
{
if (counter > 1)
{
geen += ", " + item.Value;
}
else
{
geen += item.Value;
counter++;
}
}
}
var novel = new Novel {
Name = novelName, Chapter = novelChapter, Genre = geen
};
dataBase.Novels.Add(novel);
dataBase.SaveChanges();
}
}
NovelText.Text = null;
NovelChapter.Text = null;
foreach (ListItem item in GenreCheckBox.Items)
{
item.Selected = false;
}
}
catch (DbEntityValidationException d)
{
foreach (var eve in d.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
else
{
Label4.Visible = true;
}
}