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 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"); }