public bool EditTicket(Ticket ticket) { try { using (var db = new TicketsContext(Manager)) { var ticketObj = db.Tickets.Where(i => i.IdTicket == ticket.IdTicket).FirstOrDefault(); if (ticketObj != null) { ticketObj.Usuario = ticket.Usuario; ticketObj.FechaActualizacion = DateTime.Now; ticketObj.Status = ticket.Status; db.Tickets.Update(ticketObj); db.SaveChanges(); return(true); } else { return(false); } } } catch (Exception ex) { return(false); } }
public Data.Entities.Train GetTrainDetails(int id) { using (var ctx = new TicketsContext()) { return(ctx.Trains.Include(x => x.Carriages.Select(c => c.Places)).First(x => x.Id == id)); } }
public List <Holiday> GetHolidays() { using (var context = new TicketsContext()) { return(context.Holidays.ToList()); } }
public List <Data.Entities.Run> GetRuns(DateTime start, DateTime end, int?traintId = null) { using (var ctx = new TicketsContext()) { return(ctx.Runs.Where(r => r.Date > start && r.Date < end && (traintId == null || r.TrainId == traintId)).ToList()); } }
public List <Holiday> GetAllHolidays() { using (var ctx = new TicketsContext()) { return(ctx.Holidays.ToList()); } }
public List <Reservation> GetAllForPlaceInRun(int placeInRunId) { using (var ctx = new TicketsContext()) { return(ctx.Reservations.Where(x => x.PlaceInRunId == placeInRunId).ToList()); } }
public ActionResult <Response> CreateTicket(Ticket ticket) { try { if (_ticket.CreateTicket(ticket)) { using (var db = new TicketsContext(Manager)) { int Id = Convert.ToInt32(db.Tickets.OrderByDescending(i => i.IdTicket).First().IdTicket); response.Message = $"El ticket ha sido creado correctamente, el id del ticket es: {Id}"; response.Status = true; response.Object = null; } } else { response.Message = "El ticket no ha sido creado"; response.Status = false; response.Object = null; } } catch (Exception ex) { response.Message = $"Ocurrio un error {ex.Message}"; response.Status = false; response.Object = null; } return(response); }
public List <Agency> GetAllAgencies() { using (var ctx = new TicketsContext()) { return(ctx.Agencies.ToList()); } }
public Reservation Get(int id) { using (var ctx = new TicketsContext()) { return(ctx.Reservations.FirstOrDefault(p => p.Id == id)); } }
public Data.Entities.Train GetTrainDetails(int id) { using (var ctx = new TicketsContext()) { return(ctx.Trains.Include("Carriages").Include("Carriages.Places").Include("Margin").First(x => x.Id == id)); } }
public void DeleteAgency(Data.Entities.Agency agency) { using (var ctx = new TicketsContext()) { ctx.Agencies.Remove(agency); ctx.SaveChanges(); } }
public void DeleteTrain(Data.Entities.Train train) { using (var ctx = new TicketsContext()) { ctx.Trains.Remove(train); ctx.SaveChanges(); } }
public void CreateTrain(Data.Entities.Train train) { using (var ctx = new TicketsContext()) { ctx.Trains.Add(train); ctx.SaveChanges(); } }
public Data.Entities.Run GetRunDetails(int runId) { using (var ctx = new TicketsContext()) { return(ctx.Runs.Include("Places") .Where(r => r.Id == runId).Single()); } }
public void CreateRun(Data.Entities.Run run) { using (var ctx = new TicketsContext()) { ctx.Runs.Add(run); ctx.SaveChanges(); } }
public Ticket Get(int id) { using (var ctx = new TicketsContext()) { return(ctx.Tickets .Include(t => t.PriceComponents).Where(r => r.Id == id).Single()); } }
public void Create(Reservation reservation) { using (var ctx = new TicketsContext()) { ctx.Reservations.Add(reservation); ctx.SaveChanges(); } }
public List <Reservation> GetAllForRun(int runId) { using (var ctx = new TicketsContext()) { var placesInRunIds = ctx.Runs.SelectMany(x => x.Places.Select(p => p.Id)); return(ctx.Reservations.Where(x => placesInRunIds.Contains(x.PlaceInRunId)).ToList()); } }
public void UpdateTrain(Data.Entities.Train train) { using (var ctx = new TicketsContext()) { ctx.Trains.Attach(train); ctx.Entry(train).State = EntityState.Modified; ctx.SaveChanges(); } }
public void Update(Reservation reservation) { using (var ctx = new TicketsContext()) { ctx.Reservations.Attach(reservation); ctx.Entry(reservation).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); } }
public void UpdateAgency(Data.Entities.Agency agency) { using (var ctx = new TicketsContext()) { ctx.Agencies.Attach(agency); ctx.Entry(agency).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); } }
public void Update(Data.Entities.Ticket ticket) { using (var ctx = new TicketsContext()) { ctx.Tickets.Attach(ticket); ctx.Entry(ticket).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); } }
public void DeleteRun(int runId) { using (var ctx = new TicketsContext()) { var run = ctx.Runs.Find(runId); ctx.Runs.Remove(run); ctx.SaveChanges(); } }
public void Create(Data.Entities.Ticket ticket) { using (var ctx = new TicketsContext()) { ctx.Tickets.Add(ticket); ctx.SaveChanges(); } }
public PlaceInRun GetPlaceInRun(int placeInRunId) { using (var ctx = new TicketsContext()) { return(ctx.PlacesInRuns .Include(x => x.Run) .Include(x => x.Run.Places).Single(x => x.Id == placeInRunId)); } }
public decimal GetMarkup(string code) { using (var ctx = new TicketsContext()) { var representatives = ctx.AgencyRepresentatives.FirstOrDefault(r => r.BookingAgenciesCode == code); if (representatives == null) { return(0); } var bookingAgencies = ctx.BookingAgencies.FirstOrDefault(b => b.Id == representatives.BookingAgenciesId); return((decimal)bookingAgencies.Markup); } }
public bool DeleteTicket(int Id) { try { using (var db = new TicketsContext(Manager)) { var ticket = db.Tickets.Where(i => i.IdTicket == Id).FirstOrDefault(); db.Tickets.Remove(ticket); db.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
public bool CreateTicket(Ticket ticket) { try { using (var db = new TicketsContext(Manager)) { Ticket modelTicket = new Ticket(); modelTicket.Usuario = ticket.Usuario; modelTicket.FechaCreacion = DateTime.Now; modelTicket.FechaActualizacion = DateTime.Now; modelTicket.Status = "Abierto"; db.Tickets.Add(modelTicket); db.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
public List <Ticket> RetrieveTicket(Ticket ticket) { try { using (var db = new TicketsContext(Manager)) { List <Ticket> listTicketResponse = new List <Ticket>(); if (ticket.IdTicket != 0) { listTicketResponse = db.Tickets.Where(i => i.IdTicket == ticket.IdTicket).ToList(); } else { listTicketResponse = db.Tickets.ToList(); } return(listTicketResponse); } } catch (Exception ex) { return(null); } }
public UnitOfwork(TicketsContext TicketsContext) { _TicketsContext = TicketsContext; }