private void button1_Click(object sender, EventArgs e) { DafestyEntities context = new DafestyEntities(); IssueTran i = context.IssueTrans. Where(x => x.TransactionID.ToString() == tb_transactionID.Text).First(); i.RentalStatus = "in"; i.DateActualReturn = DTP_DateReturn.Value; Movie m = context.Movies. Where(x => x.VideoCode == i.VideoCode).First(); m.NumberRented--; context.SaveChanges(); }
private void SubmitButton_Click(object sender, EventArgs e) { DafestyEntities context = new DafestyEntities(); IssueTran i = new IssueTran(); i.CustomerID = CIDTextBox.Text; i.VideoCode = Convert.ToInt16(VideoCodeTextBox.Text); i.DateIssue = IssueDateDTP.Value; i.DateDue = DueDateDTP.Value; i.RentalStatus = "out"; i.Remarks = RemarksTextBox.Text; context.IssueTrans.Add(i); Movie m = context.Movies. Where(x => x.VideoCode.ToString() == VideoCodeTextBox.Text).First(); m.NumberRented++; context.SaveChanges(); }