private void btnDelete_Click(object sender, EventArgs e)
{
DafestyEntities ctx = new DafestyEntities();
Movie mv = ctx.Movies1.Where(x => x.VideoCode == 400).First();
ctx.Movies1.Remove(mv);
ctx.SaveChanges();
MessageBox.Show("Successfully Deleted");
}
private void btnFind_Click(object sender, EventArgs e)
{
int code = Convert.ToInt32(tbFind.Text);
DafestyEntities ctx = new DafestyEntities();
Movie mv = ctx.Movies1.Where(x => x.VideoCode == code).First();
tbMovieTitle.Text = mv.MovieTitle;
tbGenre.Text = mv.Genre;
tbVideoCode.Text = mv.VideoCode.ToString();
tbRentalCost.Text = mv.RentalCost.ToString();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
int code = Convert.ToInt32(tbVideoCode.Text);
DafestyEntities ctx = new DafestyEntities();
Movie mv = ctx.Movies1.Where(x => x.VideoCode == code).First();
mv.MovieTitle = tbMovieTitle.Text;
mv.Genre = tbGenre.Text;
mv.RentalCost = float.Parse(tbRentalCost.Text);
ctx.SaveChanges();
MessageBox.Show("Update is successful");
Reset();
}
private void btnInsert_Click(object sender, EventArgs e)
{
DafestyEntities ctx = new DafestyEntities();
Movie mv = new Movie();
Producer pd = ctx.Producers.Where(x => x.ProducerID == "Warner").First();
//int code = Convert.ToInt16(tbVideoCode.Text);
mv.VideoCode = 400;
mv.MovieTitle = "Sully";
mv.Genre = "Darama";
mv.ProducerID = pd.ProducerID;
mv.RentalCost = 2.50f;
mv.Rating = "U";
mv.TotalStock = 4;
ctx.Movies1.Add(mv);
ctx.SaveChanges();
MessageBox.Show("Record is successfully inserted");
}
