public VideoLookupScreen() { InitializeComponent(); // linq query context = new DafestyEntities(); var q = from x in context.Movies select x; // display in datagridview VideoDataGridView.DataSource = q.ToList(); }
/// <summary> /// Submits the Issue with RentalStatus "in". /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SubmitButton_Click(object sender, EventArgs e) { if (CustomerIDTextBox.Text != "" && VideoCodeTextBox.Text != "") { string cid = CustomerIDTextBox.Text; string vcode = VideoCodeTextBox.Text; DateTime issuedate = IssueDateTimePicker.Value; DateTime duedate = DueDateTimePicker.Value; string remarks = RemarksTextBox.Text; // create LINQ Query with CustomerIDTextBox, VideoCodeTextBox, IssueDateTimePicker, DueDateTimePicker // instantiate context DafestyEntities context = new DafestyEntities(); // Since you're not displaying information, you don't need a query obj // create new tran IssueTran t = new IssueTran(); t.CustomerID = cid; t.VideoCode = Convert.ToInt16(vcode); t.DateIssue = issuedate; t.DateDue = duedate; if (remarks != "") { t.Remarks = remarks; } t.RentalStatus = "in"; context.IssueTrans.Add(t); context.SaveChanges(); MessageBox.Show("Issue Submitted"); } else { toolStripStatusLabel1.Text = "Please enter Customer ID and Video Code."; } }