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