//Inserting data to return movie table
public static void InsertReturnedMovie(MovieReturned Obj_Returned_Movie_Insert)
{
try
{
using (MovieRentalDBEntities db = new MovieRentalDBEntities())
{
db.MovieReturneds.Add(Obj_Returned_Movie_Insert);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
// Function to return Movies
protected void Return_btn_Click(object sender, EventArgs e)
{
MovieRent_DAL.DeleteIssue(ddl_RentID.SelectedValue);
MovieReturned Obj_Returned_Movie = new MovieReturned
{
ReturnID = Convert.ToInt32(ddl_RentID.SelectedValue),
CustomerName = txt_CustomerName.Text,
MovieTitle = txt_movieTitle.Text,
IssueDate = Convert.ToDateTime(txtIssueDate.Text),
ReturnDate = Convert.ToDateTime(txtReturnDate.Text),
TotalRent = Convert.ToDecimal(txtTotalRent.Text)
};
//Once the movie is Returned form Rent It will insert into retunred table from Rent table
MovieRent_DAL.InsertReturnedMovie(Obj_Returned_Movie);
Response.Redirect("default.aspx");
}
