public void EditTrainClass(TrainClassDetails trainClassDetails) //method to update train class
{
using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext())
{
dbContext.Entry(trainClassDetails).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public void AddTrainClass(TrainClassDetails trainClassDetails) //Method to add train class
{
using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext())
{
dbContext.TrainClassDetails.Add(trainClassDetails);
dbContext.SaveChanges();
}
}
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 bool AddClass(TrainClass trainClass)
{
try
{
using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext()) //Adding train classes to the db
{
dbContext.TrainClass.Add(trainClass);
dbContext.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
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 bool ClearSeats(int bookingId) //method to make the seat no to 0 if the user cancel the booking
{
try
{
using (TrainTicketBookingDbContext dbContext = new TrainTicketBookingDbContext())
{
var seats = dbContext.PassengerDetails.Where(m => m.BookingId == bookingId);
foreach (var item in seats)
{
item.SeatNo = 0;
}
// dbContext.TicketBooking.Where(m=> m.BookingId == bookingId).
dbContext.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
