public List <Customer> GetCustomersData_DAL() { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { // To list the Customers using LINQ Queries var query = (from c in db.Customers select c).ToList(); return(query); } }
public void InsertCustomers_DAL(Customer obj_Customers_insert) { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //adding object to movies table db.Customers.Add(obj_Customers_insert); db.SaveChanges(); } }
// calling the object from business.Movies_BAL public void InsertMovies_DAL(Movy obj_movie_insert) { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //adding object to movies table db.Movies.Add(obj_movie_insert); db.SaveChanges(); } }
public List <Movy> GetMoviesData_DAL() { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { // To list the Movies using LINQ Queries // m is an object with fetching the data with Database Movies var query = (from m in db.Movies select m).ToList(); return(query); } }
public List <MovieReturned> GetMovieReturnedData_DAL() { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { // To list the Movie Return using LINQ Queries // a is an object with fetching the data with Database of table MovieReturn var query = (from a in db.MovieReturneds select a).ToList(); return(query); } }
public List <MovieReturned> GetMovyReturnedDetails_DAL(string selectedValue) { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { // To list the Movie Return using LINQ Queries // u is an object with fetching the data with Database of table MovieRent //selected value is the parameter for search query with RentID List <MovieReturned> Obj_Return_Detail = (from u in db.MovieReturneds where u.ReturnID.ToString() == selectedValue select u).ToList(); return(Obj_Return_Detail); } }
//To get the details from the drop down box to select the data public List <Customer> GetCustomerDetails_DAL(string selectedValue) { List <Customer> Obj_Customer_Detail = null; using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { // To list the Movie Return using LINQ Queries // u is an object with fetching the data with Database of table Customer //selected value is the parameter for search query with CustomerId Obj_Customer_Detail = (from u in db.Customers where u.CustomerID.ToString() == selectedValue select u).ToList(); return(Obj_Customer_Detail); } }
//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; } }
public static void DeletCustomer(string Obj_Cust_Delete) { try { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //Lembda expression for deleting customer Customer c = db.Customers.SingleOrDefault(x => x.CustomerID.ToString().Trim() == Obj_Cust_Delete.Trim()); if (c != null) { db.Customers.Remove(c); db.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public static void DeleteMovie(string Obj_mov_Delete) { try { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //Lembda expression to delete movie Movy c = db.Movies.SingleOrDefault(x => x.MovieID.ToString().Trim() == Obj_mov_Delete.Trim()); if (c != null) { db.Movies.Remove(c); db.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public static int UpdateCustomer(Customer Obj_Cust_Update) { try { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //Lembda expression for updating customer Customer c = db.Customers.SingleOrDefault(x => x.CustomerID == Obj_Cust_Update.CustomerID); c.FirstName = Obj_Cust_Update.FirstName; c.LastName = Obj_Cust_Update.LastName; c.Address = Obj_Cust_Update.Address; c.Phone = Obj_Cust_Update.Phone; db.SaveChanges(); return(Obj_Cust_Update.CustomerID); } } catch (Exception ex) { throw ex; } }
public static int UpdateMovie(Movy Obj_Movi_Update) { try { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //Lembda expression to update movie Movy c = db.Movies.SingleOrDefault(x => x.MovieID == Obj_Movi_Update.MovieID); c.Title = Obj_Movi_Update.Title; c.Year = Obj_Movi_Update.Year; c.Gener = Obj_Movi_Update.Gener; c.RentPerDay = Obj_Movi_Update.RentPerDay; db.SaveChanges(); return(Obj_Movi_Update.MovieID); } } catch (Exception ex) { throw ex; } }