private void buttonReturn_Click(object sender, EventArgs e) { if (tableLoanedCDs.SelectedItems.Length > 0) { LoanedCDDataSet.LoanedCDRow loanedCDRow = (LoanedCDDataSet.LoanedCDRow)tableLoanedCDs.SelectedItems[0].Tag; LoanedCDTableAdapter ta = new LoanedCDTableAdapter(dataBase); CDTableAdapter cdta = new CDTableAdapter(dataBase); PersonGroupTableAdapter personGroupta = new PersonGroupTableAdapter(dataBase); string artist = ""; string title = ""; try { CD cd = dataBase.GetCDById(loanedCDRow.CDID); artist = cd.Artist; title = cd.Title; } catch { artist = "<" + StringTable.Deleted + ">"; title = "<" + StringTable.Deleted + ">"; } string msg = String.Format(StringTable.ReturnLoanedCD, artist, title); if (MessageBox.Show(msg, Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ta.Delete(loanedCDRow.CDID); FillList(); } } }
public FormLoanProperties(DataBase dataBase, LoanedCDDataSet.LoanedCDRow loanedCD) : this() { loanedCDRow = loanedCD; CDTableAdapter cdta = new CDTableAdapter(dataBase); PersonGroupTableAdapter personGroupta = new PersonGroupTableAdapter(dataBase); CDDataSet.CDDataTable cd = cdta.GetDataById(loanedCDRow.CDID); PersonGroupDataSet.PersonGroupDataTable personGroup = personGroupta.GetDataById(cd[0].ArtistID); textBoxArtist.Text = personGroup[0].Name; textBoxTitle.Text = cd[0].Title; comboBoxLoanedTo.Text = loanedCDRow.LoanedTo; checkBoxActivateBringBack.Checked = !loanedCDRow.IsReturnDateNull(); if (!loanedCDRow.IsReturnDateNull()) { dateTimePickerBringBack.Value = loanedCDRow.ReturnDate; } if (!loanedCDRow.IsLoanedDateNull()) { dateTimePickerLoaned.Value = loanedCDRow.LoanedDate; } textBoxComment.Text = loanedCDRow.Comment; }
private void buttonProperties_Click(object sender, EventArgs e) { if (tableLoanedCDs.SelectedItems.Length > 0) { LoanedCDDataSet.LoanedCDRow loanedCDRow = (LoanedCDDataSet.LoanedCDRow)tableLoanedCDs.SelectedItems[0].Tag; FormLoanProperties formLoanProperties = new FormLoanProperties(dataBase, loanedCDRow); if (formLoanProperties.ShowDialog(this) == DialogResult.OK) { LoanedCDTableAdapter ta = new LoanedCDTableAdapter(dataBase); ta.Update(loanedCDRow); FillList(); } } }