public async Task <List <Cabintype> > GetCabinType(int nid, int shipId) { using (var context = new CruiseContext()) { return(await context.cabinTypes.Where(x => x.nid == nid && x.ship_id == shipId).ToListAsync()); } }
public async Task <List <CruiseLine> > GetCruiseLine(string range) { using (var context = new CruiseContext()) { return(await context.cruiseLines.ToListAsync()); } }
public async Task <List <Ship> > GetShipsAsync(string nid) { using (var context = new CruiseContext()) { List <Ship> allShips = new List <Ship>(); List <Ship> ships = new List <Ship>(); List <int> shipIds = await context.cabinTypes.Where(x => x.nid == Convert.ToInt32(nid)).Select(x => x.ship_id).Distinct().ToListAsync(); foreach (int shipId in shipIds) { ships = await context.ships.Where(x => x.ship_id == shipId).GroupBy(x => x.title, (key, group) => group.First()).ToListAsync(); allShips.AddRange(ships); } return(allShips); } }
public async Task <bool> InsertCruise(CreateCruiseRequest message) { Cruise cruise = new Cruise(); cruise.nid = message.cruise.nid; cruise.shipId = message.cruise.shipId; cruise.cabinType = message.cruise.cabinType; cruise.rId = message.cruise.rId; cruise.departureDate = message.cruise.departureDate; cruise.isFlight = message.cruise.isFlight; using (var context = new CruiseContext()) { context.cruise.Add(cruise); await context.SaveChangesAsync(); return(true); } }
public async Task <bool> InsertPorts(List <Port> ports) { try { using (var context = new CruiseContext()) { foreach (var port in ports) { context.ports.Add(port); } context.Database.SetCommandTimeout(180); await context.SaveChangesAsync(); return(true); } } catch (Exception ex) { return(false); } }
public async Task <bool> InsertCabinTypes(List <Cabintype> cabintypes) { try { using (var context = new CruiseContext()) { foreach (var cabintype in cabintypes) { context.cabinTypes.Add(cabintype); } await context.SaveChangesAsync(); return(true); } } catch (Exception ex) { return(false); } }
public async Task <bool> InsertCruise(List <CruiseLine> cruiseLines) { try { using (var context = new CruiseContext()) { context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT cruiseLines ON"); foreach (var cruiseLine in cruiseLines) { context.cruiseLines.Add(cruiseLine); } await context.SaveChangesAsync(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT cruiseLines OFF"); return(true); } } catch (Exception ex) { return(false); } }
public async Task <bool> InsertShip(List <Ship> ships) { try { using (var context = new CruiseContext()) { foreach (var ship in ships) { context.ships.Add(ship); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[ships] ON"); await context.SaveChangesAsync(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[ships] OFF"); return(true); } } catch (Exception ex) { return(false); } }
public SalesUnitRepo(CruiseContext cruiseContext) { _cruiseContext = cruiseContext; }
public BookingsRepo(CruiseContext cruiseContext) { _cruiseContext = cruiseContext; }