//Filling the details of rent private void FillRentDetails() { MovieRent_BAL Obj_rental = new MovieRent_BAL(); List <MovieRent> Obj_Rent_ID = Obj_rental.GetMovieRentData_BAL(); if (Obj_Rent_ID != null && Obj_Rent_ID.Count > 0) { for (int i = 0; i < Obj_Rent_ID.Count; i++) { ddl_RentID.Items.Add(Obj_Rent_ID[i].RentID.ToString()); } ddl_RentID.Items.Insert(0, new ListItem("Select Rental ID", " ")); } else { ddl_RentID.Items.Clear(); } }
//Selecting the datas by selecring the Id from drop down box protected void ddl_Rent_SelectedIndexChanged(object sender, EventArgs e) { //Creating a varibale to find the rent per day decimal MovieRe = 0; //Listing the Movie rental datas to dropdownbox List <MovieRent> Obj_Rent = MovieRent_BAL.GetRentDetails_BAL(ddl_RentID.SelectedValue); if (Obj_Rent != null && Obj_Rent.Count > 0) { for (int i = 0; i < Obj_Rent.Count; i++) { //Getting selected customer details List <Customer> Obj_Customer = Customer_BAL.GetCustomerDetails_BAL(Obj_Rent[i].CustomerID.ToString()); if (Obj_Customer != null && Obj_Customer.Count > 0) { for (int k = 0; k < Obj_Customer.Count; k++) { txt_CustomerName.Text = Obj_Customer[k].FirstName; } } //Getting Movie details List <Movy> Obj_Movie = Movies_BAL.GetMovieDetails_BAL(Obj_Rent[i].MovieID.ToString()); if (Obj_Movie != null && Obj_Movie.Count > 0) { for (int j = 0; j < Obj_Movie.Count; j++) { txt_movieTitle.Text = Obj_Movie[j].Title; MovieRe = Convert.ToDecimal(Obj_Movie[j].RentPerDay); } } // Coverting to the datatype to string and dateTime txtIssueDate.Text = Obj_Rent[i].IssuseDate.ToString(); txtReturnDate.Text = DateTime.Now.ToString(); DateTime issuedate = Convert.ToDateTime(Obj_Rent[i].IssuseDate); double days = (DateTime.Now - issuedate).TotalDays; //Calculating the Rent txtTotalRent.Text = (MovieRe * Convert.ToDecimal(Math.Round(days))).ToString(); } } }