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