public int GetTotalCost(int bookingId) //Method to get total money { using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext()) { return(dbContext.PassengerDetails.Where(m => m.BookingId == bookingId).Sum(m => m.Cost)); } }
public TrainDetails GetTrainByNo(int trainId) //Method to get train details based on id { using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext()) { return(dbContext.TrainDetails.Find(trainId)); } }
public List <TicketBooking> GetBookingDetailsByIdandDOJ(int trainId, DateTime DOJ) //Method to get booking details based on traind id and Date of journey { using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext()) { return(dbContext.TicketBooking.Where(m => m.TrainId == trainId && m.JourneyDate == DOJ).ToList()); } }
public void DeleteTrainDetails(int trainNo) //Method to delete train details by trainId { using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext()) { SqlParameter TrainId = new SqlParameter("@TrainId", trainNo); int result = dbContext.Database.ExecuteSqlCommand("sp_DeleteTrainDetails @TrainId", TrainId); } }
public void UpdateTrainDetails(TrainDetails trainDetails) //Method to update train details { using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext()) { TrainDetails details = GetTrainByNo(trainDetails.TrainId); dbContext.Entry(trainDetails).State = EntityState.Modified; dbContext.SaveChanges(); } }
public List <TrainDetails> SearchTrain(string source, string destination) //Method to search train based on source and destination { List <TrainDetails> trainList = new List <TrainDetails>(); using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext()) { trainList = dbContext.TrainDetails.Where(m => m.SourceStation == source && m.DestinationStation == destination).ToList(); } return(trainList); }
public IEnumerable <TrainDetails> GetTrainDetails() //Meethod to fetch train details from db { List <TrainDetails> trainList = new List <TrainDetails>(); using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext()) { trainList = dbContext.TrainDetails.ToList(); } return(trainList); }
public bool AddPassengerDetails(PassengerDetails passengerDetails) //Method to add passenger details to db { try { using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext()) { dbContext.PassengerDetails.Add(passengerDetails); //dbContext.Database.ExecuteSqlCommand(@"SET IDENTITY_INSERT [dbo].[TrainDetails] ON"); dbContext.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public List <TrainClassDetails> GetSeatDetailsById(int trainId) //method to get seat details based on train id { //object value; List <TrainClassDetails> trainClassDetails; using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext()) { //var data = (from td in dbContext.TrainDetails // join tcd in dbContext.TrainClassDetails on td.TrainId equals tcd.TrainId where td.TrainId == id // join tc in dbContext.TrainClass on tcd.ClassId equals tc.ClassId // select new // { // td.TrainNo, // td.TrainName, // tc.ClassName, // tcd.Seats, // tcd.Cost // }).ToList(); //value = data; trainClassDetails = dbContext.TrainClassDetails.Include("TrainClasses").Include("TrainDetails").Where(td => td.TrainId == trainId).ToList(); } return(trainClassDetails); }