//NIC autofill function
private void CustomerReport_Load(object sender, EventArgs e)
{
db = new DBconnection();
AutoCompleteStringCollection at1 = db.dataLoadToSuggestion("nic", "customer");
txt_nic.AutoCompleteCustomSource = at1;
}
private void movieNameMsgBox_Load(object sender, EventArgs e)
{
dbc1 = new DBconnection();
AutoCompleteStringCollection at1 = dbc1.dataLoadToSuggestion("movie_name", "movie");//Autocomplete movie input text box with all existing movies
movieI.AutoCompleteCustomSource = at1;
}
private void customerSearch_Load(object sender, EventArgs e)
{
dbc1 = new DBconnection();
AutoCompleteStringCollection at1 = dbc1.dataLoadToSuggestion("nic", "customer");
nicI.AutoCompleteCustomSource = at1;
}
private void EditMovie_Load(object sender, EventArgs e)
{
cmb_genre.Enabled = false;
txt_movieName.Text = movieNameCurrent;
dbc1 = new DBconnection();
AutoCompleteStringCollection at1 = dbc1.dataLoadToSuggestion("movie_name", "movie");
txt_movieName.AutoCompleteCustomSource = at1;
Movie movie = new Movie();
movie = movie.searchMovie(movieNameCurrent);
id = movie.Movie_Id;
txt_movieName.Text = movie.Movie_Name;
cmb_genre.SelectedItem = movie.Genre;
txt_price.Text = movie.Price.ToString();
txt_noCopies.Text = movie.No_Of_Copies.ToString();
}