//ADD NEW MEDIA BUTTON
private void addMediaButton_Click(object sender, EventArgs e)
{
int affectedRows = mediaLogic.InsertNewMedia(titleTextBox.Text, (int)directorComboBox.SelectedValue, (int)genreComboBox.SelectedValue, (int)languageComboBox.SelectedValue, int.Parse(yearTextBox.Text), int.Parse(budgetTextBox.Text));
//if affectedRows > 0, success!
RefreshMediaList();
}
private void btnAddMedia_Click(object sender, EventArgs e)
{
if (txtUAMediaTitle.Text == "" || cbUAMediaDirector.Text == "" || cbUAMediaGenre.Text == "" || cbUAMediaLanguage.Text == "" || txtUAMediaPublish.Text == "" || txtUAMediaBudget.Text == "")
{
lbStripStatus.Text = "Please fill all form";
MessageBox.Show("Missing Information");
return;
}
int iDirectorID = 1, iGenresID = 1, iLanguageID = 1;
List <PairModel> lstGenres = _mediaLogic.ListGenres();
List <PairModel> lstLanguage = _mediaLogic.ListLanguages();
List <PairModel> lstDirector = _mediaLogic.ListDirector();
for (int i = 0; i < lstDirector.Count; i++)
{
if (lstDirector[i].PairName == cbUAMediaDirector.Text)
{
iDirectorID = lstDirector[i].PairID;
break;
}
}
for (int i = 0; i < lstGenres.Count; i++)
{
if (lstGenres[i].PairName == cbUAMediaGenre.Text)
{
iGenresID = lstGenres[i].PairID;
break;
}
}
for (int i = 0; i < lstLanguage.Count; i++)
{
if (lstLanguage[i].PairName == cbUAMediaLanguage.Text)
{
iLanguageID = lstLanguage[i].PairID;
break;
}
}
//Update selected user with new password ONLY IF current logged in user is an admin
int rowAffrected = _mediaLogic.InsertNewMedia(txtUAMediaTitle.Text, iGenresID, iLanguageID, iDirectorID, int.Parse(txtUAMediaPublish.Text), decimal.Parse(txtUAMediaBudget.Text));
if (rowAffrected > 0)
{
statusStrip.Text = "Media has been inserted";
MessageBox.Show("\"" + txtUAMediaTitle.Text + "\"" + " Media has been inserted!");
}
RefreshMediaList();
}
private void btnaddmedia_Click(object sender, EventArgs e)
{
MediaLogic ml = new MediaLogic();
if (txttitle.Text == "")
{
MessageBox.Show("Please enter the title.");
}
else if (txtmediaid.Text == "")
{
MessageBox.Show("Please enter the media id.");
}
else if (txtpublishyear.Text == "")
{
MessageBox.Show("Please enter the publish year.");
}
else if (txtbudget.Text == "")
{
MessageBox.Show("Please enter the budget.");
}
else if (combogenre.Text == "")
{
MessageBox.Show("Please select the genre.");
}
else if (combolanguage.Text == "")
{
MessageBox.Show("Please enter the language.");
}
else if (combodirector.Text == "")
{
MessageBox.Show("Please enter the director.");
}
else
{
//List<MediaModel> Media = ml.searchmedaibyMediaID(txtmediaid.Text);
List <MediaModel> Media = ml.searchmedaibyMediaID(Int32.Parse(txtmediaid.Text));
if (Media.Count > 0)
{
MessageBox.Show("Already have a same Media id!!");
}
else
{
int result = ml.InsertNewMedia(txttitle.Text, Int32.Parse(combogenre.SelectedValue.ToString()), Int32.Parse(combodirector.SelectedValue.ToString()), Int32.Parse(combolanguage.SelectedValue.ToString()), Int32.Parse(txtpublishyear.Text), Int32.Parse(txtbudget.Text));
MessageBox.Show(result.ToString() + " Media added.");
MaintainMedia_Load(sender, e);
}
}
}
private void btnupdatemedia_Click(object sender, EventArgs e)
{
MediaLogic ml = new MediaLogic();
int result = 0;
result = ml.InsertNewMedia(txttitle.Text, Int32.Parse(combogenre.SelectedValue.ToString()), Int32.Parse(combodirector.SelectedValue.ToString()), Int32.Parse(combolanguage.SelectedValue.ToString()), Int32.Parse(txtpublishyear.Text), Int32.Parse(txtbudget.Text));
if (result >= 1)
{
MessageBox.Show(result.ToString() + " media update.");
}
else
{
MessageBox.Show("Please select media and fill the box.");
}
MaintainMedia_Load(sender, e);
}
public int InsertNewMedia(String Title, int Genre, int Director, int Language, int PublishYear, decimal Budget)
{
MediaLogic mediaLogic = new MediaLogic();
return(mediaLogic.InsertNewMedia(Title, Genre, Director, Language, PublishYear, Budget));
}
