// handler method to edit Movie object
public void HandleModifyObject(object sender, ModifyObjectEventArgs e)
{
MovieObject m = e.CourseToModify1 as MovieObject;
if (lvMovies.SelectedItems != null)
{
lvMovies.SelectedItems[0].Text = m.ToString();
lvMovies.SelectedItems[0].Tag = m;;
lvMovies.SelectedItems[0].ImageIndex = m.Index;
}
int sqlIndex = lvMovies.SelectedItems[0].Index + 1;
// application must be able to pass information to and from a database
string sql = "UPDATE SeriesTitles SET Title = @Title, YearReleased = @YearReleased, Publisher = @Publisher, Author = @Author, Genre = @Genre WHERE id = @id;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@id", sqlIndex);
cmd.Parameters.AddWithValue("@Title", m.Title);
cmd.Parameters.AddWithValue("@YearReleased", m.Year);
cmd.Parameters.AddWithValue("@Publisher", m.Publisher);
cmd.Parameters.AddWithValue("@Author", m.Author);
cmd.Parameters.AddWithValue("@Genre", m.Genre);
MySqlDataReader rdr = cmd.ExecuteReader();
btnApply.Visible = false;
btnCancel.Visible = false;
rdr.Close();
}
private void AddToListView(DataTable data)
{
foreach (DataRow item in data.Rows)
{
newMovie = new MovieObject();
newMovie.Title = item["Title"].ToString();
string year = item["YearReleased"].ToString();
newMovie.Year = Convert.ToDecimal(year);
newMovie.Publisher = item["Publisher"].ToString();
newMovie.Author = item["Author"].ToString();
newMovie.Genre = item["Genre"].ToString();
// Assign an appropriate ImageList icon to each record.
if (newMovie.Year == 2001)
{
newMovie.Index = 0;
}
else if (newMovie.Year == 2002)
{
newMovie.Index = 1;
}
else if (newMovie.Year == 2004)
{
newMovie.Index = 2;
}
else if (newMovie.Year == 2005)
{
newMovie.Index = 3;
}
else if (newMovie.Year == 2007)
{
newMovie.Index = 4;
}
else if (newMovie.Year == 2009)
{
newMovie.Index = 5;
}
else if (newMovie.Year == 2010)
{
newMovie.Index = 6;
}
else if (newMovie.Year == 2011)
{
newMovie.Index = 7;
}
lvi = new ListViewItem();
lvi.Tag = newMovie;
lvi.ImageIndex = newMovie.Index;
lvi.Text = newMovie.ToString();
lvMovies.Items.Add(lvi);
// Once data is loaded, The first record should populate user input controls
MovieInfo = (MovieObject)lvMovies.Items[0].Tag;
}
}
// ability for the user to move through the records.
private void btnNext_Click(object sender, EventArgs e)
{
if (row + 1 < lvMovies.Items.Count)
{
row++;
MovieInfo = (MovieObject)lvMovies.Items[row].Tag;
}
}
// ability for the user to move through the records.
private void btnPrevious_Click(object sender, EventArgs e)
{
if (row - 1 >= 0)
{
row--;
MovieInfo = (MovieObject)lvMovies.Items[row].Tag;
}
}
// ability for the user to edit an individual record.
private void btnApply_Click(object sender, EventArgs e)
{
newMovie = new MovieObject();
newMovie.Title = txtTitle.Text;
newMovie.Year = numYear.Value;
newMovie.Publisher = cmbPublisher.Text;
newMovie.Author = txtAuthor.Text;
newMovie.Genre = cmbGenre.Text;
// Assign an appropriate ImageList icon to each record.
if (newMovie.Year == 2001)
{
newMovie.Index = 0;
}
else if (newMovie.Year == 2002)
{
newMovie.Index = 1;
}
else if (newMovie.Year == 2004)
{
newMovie.Index = 2;
}
else if (newMovie.Year == 2005)
{
newMovie.Index = 3;
}
else if (newMovie.Year == 2007)
{
newMovie.Index = 4;
}
else if (newMovie.Year == 2009)
{
newMovie.Index = 5;
}
else if (newMovie.Year == 2010)
{
newMovie.Index = 6;
}
else if (newMovie.Year == 2011)
{
newMovie.Index = 7;
}
// Each of the fields should be validated.
ValidateInput();
if (create == true)
{
if (ModifyObject != null)
{
ModifyObject(this, new ModifyObjectEventArgs(newMovie));
}
}
}
// Makes applt button visable to save edited object
private void btnEdit_Click(object sender, EventArgs e)
{
btnApply.Visible = true;
btnCancel.Visible = true;
if (lvMovies.SelectedItems.Count > 0)
{
MovieInfo = (MovieObject)lvMovies.SelectedItems[0].Tag;
}
else
{
MovieInfo = (MovieObject)lvMovies.Items[row].Tag;
}
}
// ability for the user to delete an individual record.
private void btnDelete_Click(object sender, EventArgs e)
{
MovieObject title = (MovieObject)lvMovies.SelectedItems[0].Tag;
// application must be able to pass information to and from a database
string sql = "DELETE FROM SeriesTitles WHERE Title = @Title;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Title", title.Title);
MySqlDataReader rdr = cmd.ExecuteReader();
lvMovies.Items.Remove(lvMovies.SelectedItems[0]);
rdr.Close();
}
// ability to add new records.
private void btnSave_Click(object sender, EventArgs e)
{
// Each of the fields should be validated.
ValidateInput();
if (create == true)
{
newMovie = new MovieObject();
newMovie.Title = txtTitle.Text;
newMovie.Year = numYear.Value;
newMovie.Publisher = cmbGenre.Text;
newMovie.Author = txtAuthor.Text;
newMovie.Genre = cmbGenre.Text;
lvi = new ListViewItem();
lvi.Tag = newMovie;
lvi.ImageIndex = newMovie.Index;
lvi.Text = newMovie.ToString();
lvMovies.Items.Add(lvi);
// application must be able to pass information to and from a database
string sql = "INSERT INTO SeriesTitles (Title, YearReleased, Publisher, Author, Genre) VALUES (@Title, @YearReleased, @Publisher, @Author, @Genre);";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Title", newMovie.Title);
cmd.Parameters.AddWithValue("@YearReleased", newMovie.Year);
cmd.Parameters.AddWithValue("@Publisher", newMovie.Publisher);
cmd.Parameters.AddWithValue("@Author", newMovie.Author);
cmd.Parameters.AddWithValue("@Genre", newMovie.Genre);
MySqlDataReader rdr = cmd.ExecuteReader();
btnSave.Visible = false;
btnCancel.Visible = false;
rdr.Close();
}
}
// cancels input and hides buttons
private void btnCancel_Click(object sender, EventArgs e)
{
HideBTN();
MovieInfo = (MovieObject)lvMovies.Items[row].Tag;
}
public ModifyObjectEventArgs(MovieObject eCouse)
{
modifyMovie = eCouse;
}
