private void validateButton_Click(object sender, EventArgs e)
{
dbIO dataHandler = new dbIO();
Transaction foundTrans = new Transaction();
foundTrans = dataHandler.findTrans(Int32.Parse(transactionTextBox.Text));
dueDateTextBox.Text = foundTrans.DueDate;
rentDateTextBox.Text = foundTrans.RentDate;
memberTextBox.Text = foundTrans.MemberId.ToString();
nameTextBox.Text = foundTrans.FirstName + " " + foundTrans.LastName;
}
private void okButton_Click(object sender, EventArgs e)
{
dbIO dataHandler = new dbIO();
Movie newMovie = new Movie(0,titleTextBox.Text,descriptionTextBox.Text,publisherTextBox.Text,releaseDateMaskedTextBox.Text,ratingTextBox.Text,double.Parse(priceMaskedTextBox.Text),(int)numberOfCopiesUpDown.Value);
dataHandler.addMovie(newMovie,(Int32)numberOfCopiesUpDown.Value);
titleTextBox.Text = "";
descriptionTextBox.Text = "";
publisherTextBox.Text = "";
releaseDateMaskedTextBox.Text = "";
ratingTextBox.Text = "";
priceMaskedTextBox.Text = "";
numberOfCopiesUpDown.Value = 0;
}
private void button2_Click(object sender, EventArgs e)
{
dbIO dataHandler = new dbIO();
Int32 num;
if (gameListView.SelectedIndices.Count == 1)
{
num = Int32.Parse(gameListView.SelectedItems[0].Text);
dataHandler.deleteGame(num);
}
gameListView.Items.Clear();
Document.clear();
reload();
}
private void okButton_Click(object sender, EventArgs e)
{
dbIO dataHandler = new dbIO();
Game newGame = new Game(int.Parse(idMaskedTextBox.Text), titleTextBox.Text, descriptionTextBox.Text, publisherTextBox.Text, releaseDateMaskedTextBox.Text, ratingTextBox.Text, double.Parse(priceMaskedTextBox.Text), (int)numberOfCopiesUpDown.Value);
dataHandler.updateGame(newGame);
idMaskedTextBox.Text = "";
titleTextBox.Text = "";
descriptionTextBox.Text = "";
publisherTextBox.Text = "";
releaseDateMaskedTextBox.Text = "";
ratingTextBox.Text = "";
priceMaskedTextBox.Text = "";
numberOfCopiesUpDown.Value = 0;
}
private void okButton_Click(object sender, EventArgs e)
{
dbIO dataHandler = new dbIO();
Member newMember = new Member(0,firstNameTextBox.Text,lastNameTextBox.Text,streetAddressTextbox.Text,cityTextbox.Text,stateMaskedTextBox.Text,zipCodeMaskedTextBox.Text,telephoneMaskedTextBox.Text,creditCardMaskedTextBox.Text,expMaskedTextbox.Text,companyTextbox.Text);
dataHandler.addMember(newMember);
firstNameTextBox.Text = "";
lastNameTextBox.Text = "";
streetAddressTextbox.Text = "";
cityTextbox.Text = "";
stateMaskedTextBox.Text = "";
zipCodeMaskedTextBox.Text = "";
telephoneMaskedTextBox.Text = "";
expMaskedTextbox.Text = "";
companyTextbox.Text = "";
}
private void okButton_Click(object sender, EventArgs e)
{
dbIO dataHandler = new dbIO();
Member newMember = new Member(Int32.Parse(idTextBox.Text), firstNameTextbox.Text, textBox3.Text, textBox4.Text, textBox5.Text, maskedTextBox5.Text, maskedTextBox1.Text, maskedTextBox2.Text, maskedTextBox3.Text, maskedTextBox4.Text, textBox1.Text);
dataHandler.updateMember(newMember);
idTextBox.Text = "";
firstNameTextbox.Text="";
textBox3.Text="";
textBox4.Text="";
textBox5.Text="";
maskedTextBox5.Text="";
maskedTextBox1.Text="";
maskedTextBox2.Text="";
maskedTextBox3.Text="";
maskedTextBox4.Text="";
textBox1.Text = "";
}
private void TransactionList_Load(object sender, EventArgs e)
{
dbIO dataHandler = new dbIO();
List<Transaction> allTransactions = new List<Transaction>();
allTransactions = dataHandler.getTransactions();
foreach (Transaction item in allTransactions)
{
Document.Add(new LViewItem(item.Id, item.MemberId,item.FirstName,item.LastName,item.RentDate,item.DueDate,item.ReturnDate,item.Status));
}
RefreshList();
}
private void reload()
{
dbIO dataHandler = new dbIO();
List<Game> allGames = new List<Game>();
allGames = dataHandler.getGames();
foreach (Game item in allGames)
{
Document.Add(new LViewItem(item.Id, item.Title, item.Description, item.Publisher, item.ReleaseDate, item.Rating, item.Price, item.Copies, false));
}
List<Movie> allMovies = new List<Movie>();
allMovies = dataHandler.getMovies();
foreach (Movie item in allMovies)
{
Document.Add(new LViewItem(item.Id, item.Title, item.Description, item.Publisher, item.ReleaseDate, item.Rating, item.Price, item.Copies, true));
}
RefreshList();
}
private void button1_Click(object sender, EventArgs e)
{
dbIO dataHandler = new dbIO();
List<Game> likeGames = new List<Game>();
List<Movie> likeMovies = new List<Movie>();
likeGames = dataHandler.searchGame(searchTextBox.Text);
likeMovies = dataHandler.searchMovie(searchTextBox.Text);
Document.clear();
movieListBox.Items.Clear();
gameListBox.Items.Clear();
foreach (Game item in likeGames)
{
Document.Add(new LViewItem(item.Id, item.Title, item.Description, item.Publisher, item.ReleaseDate, item.Rating, item.Price, item.Copies, false));
}
foreach (Movie item in likeMovies)
{
Document.Add(new LViewItem(item.Id, item.Title, item.Description, item.Publisher, item.ReleaseDate, item.Rating, item.Price, item.Copies, true));
}
RefreshList();
}
private void validateButton_Click(object sender, EventArgs e)
{
dbIO dataHandler = new dbIO();
Member foundMember = new Member();
foundMember = dataHandler.findMember(Int32.Parse(memberTextBox.Text));
nameTextBox.Text = foundMember.FirstName + foundMember.LastName;
rentDateTextBox.Text = System.DateTime.Today.Date.ToShortDateString();
dueDateTextBox.Text = System.DateTime.Today.Date.AddDays(5).ToShortDateString();
}
private void okButton_Click(object sender, EventArgs e)
{
Transaction newTrans = new Transaction();
newTrans.MemberId = Int32.Parse(memberTextBox.Text);
foreach (LViewItem item in this.Document)
{
if (item.MemberId == Int32.Parse(memberTextBox.Text))
{
newTrans.FirstName = item.FirstName;
newTrans.LastName = item.LastName;
}
}
newTrans.RentDate = rentDateTextBox.Text;
newTrans.DueDate = dueDateTextBox.Text;
newTrans.Status = "Open";
dbIO dataHandler = new dbIO();
dataHandler.rentGame(newTrans, Int32.Parse(memberTextBox.Text));
}
private void reload()
{
dbIO dataHandler = new dbIO();
List<Member> allMembers = new List<Member>();
allMembers = dataHandler.getMembers();
foreach (Member item in allMembers)
{
Document.Add(new LViewItem(item.Id, item.FirstName, item.LastName, item.StreetAddress, item.City, item.State, item.ZipCode, item.Telephone, item.CreditCard, item.ExpirationDate, item.CardType));
}
RefreshList();
}
