private void EditBook_Clicked(object sender, RoutedEventArgs e)
{
int number;
if (String.IsNullOrEmpty(TextBoxYear.Text) || String.IsNullOrEmpty(TextBoxAuthor.Text) || String.IsNullOrEmpty(TextBoxTitle.Text))
{
MessageBox.Show("non of fields can be empty");
}
else if ((!(Int32.TryParse(TextBoxYear.Text, out number))))
{
MessageBox.Show("The year must be integer");
}
else if (number < 10 || number > 3000)
{
MessageBox.Show("The age must be between 10 and 3000");
}
else
{
BindingExpression author = TextBoxAuthor.GetBindingExpression(TextBox.TextProperty);
BindingExpression title = TextBoxTitle.GetBindingExpression(TextBox.TextProperty);
BindingExpression year = TextBoxYear.GetBindingExpression(TextBox.TextProperty);
author.UpdateSource();
title.UpdateSource();
year.UpdateSource();
mainVM.BooksView.Refresh();
mainVM.UpdateYears();
this.Close();
}
}
//add movies to table
private void btnAddMOvie_Click(object sender, EventArgs e)
{
string Title, RentCost, Year, Rating, Genre, StoryLine;
Title = TextBoxMOvieTitle.Text;
RentCost = TextBoxRent.Text;
Rating = TextBoxStarRating.Text;
Year = TextBoxYear.Text;
Genre = TextBoxGenre.Text;
StoryLine = textBoxStoryLine.Text;
if (Title == "")
{
MessageBox.Show("Movie title required!");
TextBoxMOvieTitle.Focus();
}
else if (Year == "")
{
MessageBox.Show("Movie released year required!");
TextBoxYear.Focus();
}
else if (Genre == "")
{
MessageBox.Show("Movie genre required!");
TextBoxGenre.Focus();
}
else if (Rating == "")
{
MessageBox.Show("Movie rating required!");
TextBoxStarRating.Focus();
}
else if (StoryLine == "")
{
MessageBox.Show("Story required!");
textBoxStoryLine.Focus();
}
else
{
MoviesDataTbl data = new MoviesDataTbl();
data.Title = Title;
data.Year = Year;
data.Rating = Rating;
data.Genre = Genre;
data.RentCost = int.Parse(RentCost);
data.StoryLine = StoryLine;
if (new Movies().InsertMovie(data))
{
MoviesTableGridDataBind(); // method calling to Bind Grid Movies
BindDropDownMovie(); // method calling to Bind dropdown Movies
MessageBox.Show("Movie Saved to Database!!");
TextBoxMOvieTitle.Text = "";
TextBoxYear.Text = "";
TextBoxStarRating.Text = "";
TextBoxGenre.Text = "";
TextBoxRent.Text = "";
textBoxStoryLine.Text = "";
}
}
}
internal void ClearControls()
{
TextBoxAdminNo.Clear();
TextBoxPayAmount.Clear();
ComboBoxPayType.ResetText();
DateTimePayment.ResetText();
TextBoxYear.Clear();
this.Refresh();
}
private void TextBoxYear_PreviewKeyDown(object sender, KeyEventArgs e)
{
if (e.Key != Key.Enter)
{
return;
}
TextBoxYear.MoveFocus(new TraversalRequest(FocusNavigationDirection.Next));
CheckEmpty();
}
private void ClearFields()
{
TextBoxYear.Clear();
TextBoxMonth.Clear();
TextBoxDay.Clear();
TextBoxFirstName.Clear();
TextBoxSecondName.Clear();
TextBoxLastName.Clear();
TextBoxPasportNumber.Clear();
TextBoxPasportSeries.Clear();
}
private void TextBoxYear_TextChanged(object sender, TextChangedEventArgs e)
{
TextBoxYear.MoveFocus(new TraversalRequest(FocusNavigationDirection.Next));
if (!String.IsNullOrWhiteSpace(TextBoxYear.Text))
{
if (TextBoxYear.Text.Trim().Length == 4)
{
CheckEmpty();
}
}
}
private void ClearFields()
{
TextBoxYear.Clear();
TextBoxMonth.Clear();
TextBoxDay.Clear();
TextBoxFirstName.Clear();
TextBoxSecondName.Clear();
TextBoxLastName.Clear();
TextBoxLocation.Clear();
TextBoxPost.Clear();
}
//Update movie
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
string MovieId = TextBoxMovieID.Text;
string Title, RentCost, Year, Rating, Genre, StoryLine;
Title = TextBoxMOvieTitle.Text;
RentCost = TextBoxRent.Text;
Rating = TextBoxStarRating.Text;
Year = TextBoxYear.Text;
Genre = TextBoxGenre.Text;
StoryLine = textBoxStoryLine.Text;
if (Title == "")
{
MessageBox.Show("Movie title required!");
TextBoxMOvieTitle.Focus();
}
else if (Year == "")
{
MessageBox.Show("Movie released year required!");
TextBoxYear.Focus();
}
else if (Genre == "")
{
MessageBox.Show("Movie genre required!");
TextBoxGenre.Focus();
}
else if (RentCost == "")
{
MessageBox.Show("Movie rent cost required!");
}
else if (StoryLine == "")
{
MessageBox.Show("Story required!");
textBoxStoryLine.Focus();
}
else if (Rating == "")
{
MessageBox.Show("Movie rating required!");
TextBoxStarRating.Focus();
}
else
{
MoviesDataTbl data = new MoviesDataTbl();
data.Title = Title;
data.Year = Year;
data.Rating = Rating;
data.Genre = Genre;
data.RentCost = int.Parse(RentCost);
data.MovieId = int.Parse(MovieId);
data.StoryLine = StoryLine;
if (new Movies().UpdateMovie(data))
{
MoviesTableGridDataBind();
BindDropDownMovie();
btnAddMOvie.Enabled = true; // enable Add movie button
MessageBox.Show("Movie Updated!!");
TextBoxMovieID.Text = "";
TextBoxMOvieTitle.Text = "";
TextBoxYear.Text = "";
TextBoxStarRating.Text = "";
TextBoxGenre.Text = "";
TextBoxRent.Text = "";
textBoxStoryLine.Text = "";
}
else
{
MessageBox.Show("Unable to update this movie!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
DataBaseConnection.CloseConnection(); // close connection with database when error occured
}
}
//Update movie
private void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
string MovieId = TextBoxMovieID.Text;
string Title, RentCost, Year, Rating, Genre, StoryLine;
Title = TextBoxMOvieTitle.Text;
RentCost = TextBoxRent.Text;
Rating = TextBoxStarRating.Text;
Year = TextBoxYear.Text;
Genre = TextBoxGenre.Text;
StoryLine = textBoxStoryLine.Text;
if (Title == "")
{
MessageBox.Show("Movie title is required!");
TextBoxMOvieTitle.Focus();
}
else if (Year == "")
{
MessageBox.Show("Movie released year is required!");
TextBoxYear.Focus();
}
else if (Genre == "")
{
MessageBox.Show("Movie genre is required!");
TextBoxGenre.Focus();
}
else if (RentCost == "")
{
MessageBox.Show("Movie rent cost is required!");
}
else if (StoryLine == "")
{
MessageBox.Show("Story Line is required!");
textBoxStoryLine.Focus();
}
else if (Rating == "")
{
MessageBox.Show("Movie rating is required!");
TextBoxStarRating.Focus();
}
else
{
MoviesData data = new MoviesData
{
Title = Title,
Year = Year,
Rating = Rating,
Genre = Genre,
RentCost = int.Parse(RentCost),
MovieId = int.Parse(MovieId),
StoryLine = StoryLine
};
if (new Movies().UpdateMovie(data))
{
MoviesGridViewDataBind();
BindDropDownMovie();
btnAddMOvie.Enabled = true; // enable Add movie button
MessageBox.Show("Movie Updated Successfully!");
TextBoxMovieID.Text = "";
TextBoxMOvieTitle.Text = "Movie Title...";
TextBoxYear.Text = "Release Year...";
TextBoxStarRating.Text = "Star Rating...";
TextBoxGenre.Text = "Genre...";
TextBoxRent.Text = "($)Rent... ";
textBoxStoryLine.Text = "Story Line...";
}
else
{
MessageBox.Show("Unable to update this movie!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
DataBaseConnection.CloseConnection(); // close connection with database when error occured
}
}
//insert movies
private void BtnAddMOvie_Click(object sender, EventArgs e)
{
string Title, RentCost, Year, Rating, Genre, StoryLine;
Title = TextBoxMOvieTitle.Text;
RentCost = TextBoxRent.Text;
Rating = TextBoxStarRating.Text;
Year = TextBoxYear.Text;
Genre = TextBoxGenre.Text;
StoryLine = textBoxStoryLine.Text;
if (Title == "")
{
MessageBox.Show("Movie title is required!");
TextBoxMOvieTitle.Focus();
}
else if (Year == "")
{
MessageBox.Show("Movie released year is required!");
TextBoxYear.Focus();
}
else if (Genre == "")
{
MessageBox.Show("Movie genre is required!");
TextBoxGenre.Focus();
}
else if (Rating == "")
{
MessageBox.Show("Movie rating is required!");
TextBoxStarRating.Focus();
}
else if (StoryLine == "")
{
MessageBox.Show("Story Line is required!");
textBoxStoryLine.Focus();
}
else
{
MoviesData data = new MoviesData
{
Title = Title,
Year = Year,
Rating = Rating,
Genre = Genre,
RentCost = int.Parse(RentCost),
StoryLine = StoryLine
};
if (new Movies().InsertMovie(data))
{
MoviesGridViewDataBind(); // method calling to Bind Grid Movies
BindDropDownMovie(); // method calling to Bind dropdown Movies
MessageBox.Show("Movie Inseted Successfully!");
TextBoxMOvieTitle.Text = "Movie Title...";
TextBoxYear.Text = "Release Year...";
TextBoxStarRating.Text = "Star Rating...";
TextBoxGenre.Text = "Genre...";
TextBoxRent.Text = "($)Rent... ";
textBoxStoryLine.Text = "Story Line...";
}
}
}
public void getData()
{
if (string.IsNullOrEmpty(TextBoxName.Text))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Eksik Alan", "<script>alert('Kullanıcı adını giriniz');</script>");
TextBoxName.Focus();
}
else if (string.IsNullOrEmpty(TextBoxEmail.Text))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Eksik Alan", "<script>alert('Email adresini giriniz');</script>");
TextBoxEmail.Focus();
}
else
{
newFilterInfo.UserName = TextBoxName.Text;
newFilterInfo.Email = TextBoxEmail.Text;
newFilterInfo.Brand = DropDownList1.SelectedItem.Text.ToLower();
newFilterInfo.Series = DropDownList2.SelectedItem.Text.ToLower();
int kmValid;
if (string.IsNullOrEmpty(TextBoxKm.Text))
{
newFilterInfo.MaxKm = null;
}
else if (!int.TryParse(TextBoxKm.Text, out kmValid))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Yanlış formatlı giriş", "<script>alert('Maksimum Kilometre alanı sadece sayı değerleri içermelidir');</script>");
TextBoxKm.Focus();
}
else
{
newFilterInfo.MaxKm = TextBoxKm.Text;
}
int fiyatValid;
if (string.IsNullOrEmpty(TextBoxFiyat.Text))
{
newFilterInfo.MaxPrice = null;
}
else if (!int.TryParse(TextBoxFiyat.Text, out fiyatValid))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Yanlış formatlı giriş", "<script>alert('Maksimum Fiyat alanı sadece sayı değerleri içermelidir');</script>");
TextBoxFiyat.Focus();
}
else
{
newFilterInfo.MaxPrice = TextBoxFiyat.Text;
}
int yearValid;
if (string.IsNullOrEmpty(TextBoxYear.Text))
{
newFilterInfo.MinModelYear = null;
}
else if (!int.TryParse(TextBoxYear.Text, out yearValid))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Yanlış formatlı giriş", "<script>alert('Minimum model yılı alanı sadece sayı değerleri içermelidir');</script>");
TextBoxYear.Focus();
}
else
{
newFilterInfo.MinModelYear = TextBoxYear.Text;
}
int yearValid1;
if (string.IsNullOrEmpty(TextBoxYear1.Text))
{
newFilterInfo.MaxModelYear = null;
}
else if (!int.TryParse(TextBoxYear1.Text, out yearValid1))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Yanlış formatlı giriş", "<script>alert('Maksimum model yılı alanı sadece sayı değerleri içermelidir');</script>");
TextBoxYear.Focus();
}
else
{
newFilterInfo.MaxModelYear = TextBoxYear1.Text;
}
newFilterInfo.Color = RadioButtonList1.SelectedValue.ToString();
Parser.brandName = newFilterInfo.Brand;
Parser.seriesName = newFilterInfo.Series;
string totalURL = goSelectedUrl();
Parser.getUrl(totalURL); // create url to take the data
Parser.makeClient(); // create client
Parser.getHTML(); // load html file
Parser.getCarList(carList); // store filtered car list locally
carList.Sort((x, y) => x.MONEY.CompareTo(y.MONEY));
Parser.storeList(carList); // copy the car list to action layer
Parser.getUserData(newFilterInfo.UserName, newFilterInfo.Email); // copy the user data to action layer
}
}
