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);
}
