private void GetData()
{
MovielinqDataContext dbContext = new MovielinqDataContext();
GridView1.DataSource = dbContext.Movies;
GridView1.DataBind();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
using (MovielinqDataContext dbContext = new MovielinqDataContext())
{
string deleteID = GridView1.DataKeys[e.RowIndex].Value.ToString();
Movies movie = dbContext.Movies.SingleOrDefault(x => x.Id == deleteID);
dbContext.Movies.DeleteOnSubmit(movie);
dbContext.SubmitChanges();
GetData();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
using (MovielinqDataContext dbContext = new MovielinqDataContext())
{
string deleteID = GridView1.DataKeys[e.RowIndex].Value.ToString();
Movies movie = dbContext.Movies.SingleOrDefault(x => x.Id == deleteID);
dbContext.Movies.DeleteOnSubmit(movie);
dbContext.SubmitChanges();
GetData();
}
}
protected void LibraryButton3_Click(object sender, EventArgs e)
{
using (MovielinqDataContext dbContext = new MovielinqDataContext())
{
Movies newMovie = new Movies()
{
Id = movieID3.Text,
Title = movieTitle3.Text,
ReleaseDate = movieDate3.Text,
Popularity = moviePop3.Text,
};
dbContext.Movies.InsertOnSubmit(newMovie);
dbContext.SubmitChanges();
}
}
public void checkDB()
{
using (MovielinqDataContext dbContext = new MovielinqDataContext())
{
var check1 = dbContext.Movies.SingleOrDefault(p => p.Id == movieID1.Text);
if (check1 != null)
{
LibraryButton1.Visible = true;
}
var check2 = dbContext.Movies.SingleOrDefault(p => p.Id == movieID2.Text);
if (check1 != null)
{
LibraryButton2.Visible = true;
}
var check3 = dbContext.Movies.SingleOrDefault(p => p.Id == movieID3.Text);
if (check1 != null)
{
LibraryButton3.Visible = true;
}
}
}
public void checkDB()
{
using (MovielinqDataContext dbContext = new MovielinqDataContext())
{
var check1 = dbContext.Movies.SingleOrDefault(p => p.Id == movieID1.Text);
if (check1 != null)
{
LibraryButton1.Visible = true;
}
var check2 = dbContext.Movies.SingleOrDefault(p => p.Id == movieID2.Text);
if (check1 != null)
{
LibraryButton2.Visible = true;
}
var check3 = dbContext.Movies.SingleOrDefault(p => p.Id == movieID3.Text);
if (check1 != null)
{
LibraryButton3.Visible = true;
}
}
}
protected void LibraryButton3_Click(object sender, EventArgs e)
{
using (MovielinqDataContext dbContext = new MovielinqDataContext())
{
Movies newMovie = new Movies()
{
Id = movieID3.Text,
Title = movieTitle3.Text,
ReleaseDate = movieDate3.Text,
Popularity = moviePop3.Text,
};
dbContext.Movies.InsertOnSubmit(newMovie);
dbContext.SubmitChanges();
}
}
private void GetData()
{
MovielinqDataContext dbContext = new MovielinqDataContext();
GridView1.DataSource = dbContext.Movies;
GridView1.DataBind();
}
