private void CustomerLookup_Load(object sender, EventArgs e)
{
DafestyEntities context = new DafestyEntities();
CustGridView.DataSource = context.Customers.
Select(x => new
{
x.CustomerID,
x.CustomerName,
x.MemberCategory
}).ToList();
}
private void VideoLookup_Load(object sender, EventArgs e)
{
DafestyEntities context = new DafestyEntities();
gridView_Video.DataSource = context.Movies.
Select(x => new
{
x.VideoCode,
x.MovieTitle,
x.MovieType
}).ToList();
}
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 VideoCodeTextBox_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyData == Keys.Enter)
{
DafestyEntities context = new DafestyEntities();
Movie m = context.Movies.
Where(x => x.VideoCode.ToString() == VideoCodeTextBox.Text).First();
MovieTitleTextBox.Text = m.MovieTitle;
}
}
catch (Exception ex)
{
MessageBox.Show("Not Found");
MovieTitleTextBox.Text = "";
}
}
private void CIDTextBox_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyData == Keys.Enter)
{
DafestyEntities context = new DafestyEntities();
Customer c = context.Customers.
Where(x => x.CustomerID == CIDTextBox.Text).First();
CustNameTextBox.Text = c.CustomerName;
}
}
catch (Exception ex)
{
MessageBox.Show("Not Found");
CustNameTextBox.Text = "";
}
}
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();
}
private void VideoLookupButton_Click(object sender, EventArgs e)
{
using (VideoLookup videoForm = new VideoLookup())
{
if (videoForm.ShowDialog() == DialogResult.OK)
{
VideoCodeTextBox.Text = videoForm.TheValue;
try
{
DafestyEntities context = new DafestyEntities();
Movie m = context.Movies.
Where(x => x.VideoCode.ToString() == VideoCodeTextBox.Text).First();
MovieTitleTextBox.Text = m.MovieTitle;
}
catch (Exception ex)
{
MessageBox.Show("Not Found");
}
}
}
}
private void CustLookupButton_Click(object sender, EventArgs e)
{
using (CustomerLookup custForm = new CustomerLookup())
{
if (custForm.ShowDialog() == DialogResult.OK)
{
CIDTextBox.Text = custForm.TheValue;
try
{
DafestyEntities context = new DafestyEntities();
Customer c = context.Customers.
Where(x => x.CustomerID == CIDTextBox.Text).First();
CustNameTextBox.Text = c.CustomerName;
}
catch (Exception ex)
{
MessageBox.Show("Not Found");
}
}
}
}
