private void addmovie_Click(object sender, EventArgs e) { int a, b; if (movie_title.Text == "" || movie_year.Text == "" || movie_rating.Text == "" || movie_copies.Text == "" || movie_plot.Text == "" || movie_gener.Text == "") { MessageBox.Show("****Fill mandatory fields*****"); } else if (!int.TryParse(movie_year.Text, out a) || !(int.TryParse(movie_copies.Text, out b))) { MessageBox.Show("Year and Copies must be a correct value"); } else { int rental = 0; if ((DateTime.Now.Year - a) > 5) { rental = 2; } else { rental = 5; } DBContextHelper database = new DBContextHelper(); database.Create_Movie(movie_rating.Text, movie_title.Text, movie_year.Text, rental.ToString(), movie_copies.Text, movie_plot.Text, movie_gener.Text); MessageBox.Show("Movie Added"); ALLHIDE(); } }
private void button1_Click(object sender, EventArgs e) { int a, b; if (tb1.Text == "" || tb2.Text == "" || tb3.Text == "" || tb4.Text == "" || tb5.Text == "" || tb6.Text == "") { MessageBox.Show("****Fill mandatory fields*****"); } else if (!int.TryParse(tb3.Text, out a) || !(int.TryParse(tb4.Text, out b))) { MessageBox.Show("Year and Copies must be a correct value"); } else { int rental = 0; if ((DateTime.Now.Year - a) > 5) { rental = 2; } else { rental = 5; } DBContextHelper database = new DBContextHelper(); database.CreateMovie(tb1.Text, tb2.Text, tb3.Text, rental.ToString(), tb4.Text, tb5.Text, tb6.Text); MessageBox.Show("Movie Added"); } }
private void btnSubmit_Click(object sender, EventArgs e) { int a, b; if (tbx_Rating.Text == "" || tbx_Title.Text == "" || tbx_Year.Text == "" || tbx_Copies.Text == "" || tbx_Plot.Text == "" || tbx_Genre.Text == "") { MessageBox.Show("****Fill compulsory fields*****"); } else if (!int.TryParse(tbx_Year.Text, out a) || !(int.TryParse(tbx_Copies.Text, out b))) { MessageBox.Show("Year and Copies must have a correct value"); } else { int rental = 0; if ((DateTime.Now.Year - a) > 5) { rental = 2; } else { rental = 5; } DBContextHelper database = new DBContextHelper(); database.Update_Movie(tbx_Rating.Text, tbx_Title.Text, tbx_Year.Text, rental.ToString(), tbx_Copies.Text, tbx_Plot.Text, tbx_Genre.Text, MovieId); MessageBox.Show("Movie Details Updated"); Dispose(); } }
public EditCustomer(string CustomerId) { this.Id = CustomerId; DataTable dtCustomers = new DBContextHelper().GetCustomerByID(Id); InitializeComponent(); tbx_FirstName.Text = dtCustomers.Rows[0]["CustomerFirstName"].ToString(); tbx_LastName.Text = dtCustomers.Rows[0]["CustomerLastName"].ToString(); tbx_Address.Text = dtCustomers.Rows[0]["CustomerAddress"].ToString(); tbx_PhoneNo.Text = dtCustomers.Rows[0]["CustomerPhone"].ToString(); }
public EditCustomer(string Id) { this.Id = Id; DataTable table = new DBContextHelper().GetCustByID(Id); InitializeComponent(); tb1.Text = table.Rows[0]["FirstName"].ToString(); tb2.Text = table.Rows[0]["LastName"].ToString(); tb3.Text = table.Rows[0]["Address"].ToString(); tb4.Text = table.Rows[0]["Phone"].ToString(); }
public EditMovie(string Id) { MovieId = Id; InitializeComponent(); DataTable table = new DBContextHelper().GetMovieByMovieID(MovieId); tb1.Text = table.Rows[0]["Rating"].ToString(); tb2.Text = table.Rows[0]["Title"].ToString(); tb3.Text = table.Rows[0]["Year"].ToString(); tb4.Text = table.Rows[0]["Copies"].ToString(); tb5.Text = table.Rows[0]["Plot"].ToString(); tb6.Text = table.Rows[0]["Genre"].ToString(); }
public EditMovie(string movId) { MovieId = movId; InitializeComponent(); DataTable dtMovies = new DBContextHelper().Get_Movie_By_MovieID(movId); tbx_Rating.Text = dtMovies.Rows[0]["MoviesRatings"].ToString(); tbx_Title.Text = dtMovies.Rows[0]["MoviesTitle"].ToString(); tbx_Year.Text = dtMovies.Rows[0]["MoviesYear"].ToString(); tbx_Copies.Text = dtMovies.Rows[0]["MoviesCopies"].ToString(); tbx_Plot.Text = dtMovies.Rows[0]["MoviesPlot"].ToString(); tbx_Genre.Text = dtMovies.Rows[0]["MoviesGenre"].ToString(); }
private void addcustomer_Click(object sender, EventArgs e) { if (tb1.Text == "" || tb2.Text == "" || tb3.Text == "" || tb.Text == "") { MessageBox.Show("****Fill mandatory fields*****"); } else { DBContextHelper database = new DBContextHelper(); database.CreateCustomer(tb1.Text, tb2.Text, tb3.Text, tb.Text); MessageBox.Show("Customer Added"); ALLHIDE(); } }
private void returnToolStripMenuItem_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Are you sure to reurn this rental?", "Return Confirmation", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { string Date = DateTime.Now.ToString("MM/dd/yyyy") + " " + DateTime.Now.ToShortTimeString(); DBContextHelper database = new DBContextHelper(); database.Return_Movie(Date, dataGridView1return.SelectedRows[0].Cells[0].Value.ToString()); MessageBox.Show("Movie Returned"); dataGridView1return.DataSource = new DBContextHelper().Movies_ToBe_Returned(); } }
private void btnSubmit_Click(object sender, EventArgs e) { if (tbx_FirstName.Text == "" || tbx_LastName.Text == "" || tbx_Address.Text == "" || tbx_PhoneNo.Text == "") { MessageBox.Show("****Fill cumpulsory fields*****"); } else { DBContextHelper database = new DBContextHelper(); database.UpdateCustomer(tbx_FirstName.Text, tbx_LastName.Text, tbx_Address.Text, tbx_PhoneNo.Text, Id); MessageBox.Show("Customer Details Updated"); Dispose(); } }
private void button1_Click(object sender, EventArgs e) { if (tb1.Text == "" || tb2.Text == "" || tb3.Text == "" || tb4.Text == "") { MessageBox.Show("****Fill mandatory fields*****"); } else { DBContextHelper database = new DBContextHelper(); database.UpdateCust(tb1.Text, tb2.Text, tb3.Text, tb4.Text, Id); MessageBox.Show("Customer Updated"); Dispose(); } }
private void issueToolStripMenuItem_Click(object sender, EventArgs e) { int copies = new DBContextHelper().Check_Copies(Convert.ToInt32(gridmovie.SelectedRows[0].Cells[0].Value)); if (copies > 0) { Issue issueRental = new Issue(gridmovie.SelectedRows[0].Cells[0].Value.ToString()); issueRental.ShowDialog(); gridmovie.DataSource = new DBContextHelper().Get_All_Movies(); } else { MessageBox.Show("No copy available to rent"); } }
private void button1_Click(object sender, EventArgs e) { if (tb2.Text == "") { MessageBox.Show("Enter valid Customer ID"); } else { string Date = DateTime.Now.ToString("MM/dd/yyyy") + " " + DateTime.Now.ToShortTimeString(); DBContextHelper database = new DBContextHelper(); database.IssueMovie(Id, customerid.Text, Date); MessageBox.Show("Movie Rented"); Dispose(); } }
private void btnSubmit_Click(object sender, EventArgs e) { if (tbx_LastName.Text == "") { MessageBox.Show("Enter correct Customer ID"); } else { string CurrentDate = DateTime.Now.ToString("MM/dd/yyyy") + " " + DateTime.Now.ToShortTimeString(); DBContextHelper database = new DBContextHelper(); database.Issue_Movie(Id, tbx_CustomerID.Text, CurrentDate); MessageBox.Show("Movie is Rented"); Dispose(); } }
private void CustID_TextChanged(object sender, EventArgs e) { tb1.Text = ""; tb2.Text = ""; tb3.Text = ""; tb4.Text = ""; DataTable table = new DBContextHelper().GetCustByID(customerid.Text); if (table.Rows.Count > 0) { tb1.Text = table.Rows[0]["FirstName"].ToString(); tb2.Text = table.Rows[0]["LastName"].ToString(); tb3.Text = table.Rows[0]["Address"].ToString(); tb4.Text = table.Rows[0]["Phone"].ToString(); } }
private void tbx_CustomerID_TextChanged(object sender, EventArgs e) { tbx_FirstName.Text = ""; tbx_LastName.Text = ""; tbx_Address.Text = ""; tbx_PhoneNo.Text = ""; DataTable dtCustomers = new DBContextHelper().GetCustomerByID(tbx_CustomerID.Text); if (dtCustomers.Rows.Count > 0) { tbx_FirstName.Text = dtCustomers.Rows[0]["CustomerFirstName"].ToString(); tbx_LastName.Text = dtCustomers.Rows[0]["CustomerLastName"].ToString(); tbx_Address.Text = dtCustomers.Rows[0]["CustomerAddress"].ToString(); tbx_PhoneNo.Text = dtCustomers.Rows[0]["CustomerPhone"].ToString(); } }