public ActionResult Create([Bind(Include = "Id,LName,FName,EmployedDate")] Staff staff)
{
if (ModelState.IsValid)
{
db.Staffs.Add(staff);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(staff));
}
public ActionResult Create([Bind(Include = "Id,Name,Origin")] Airline airline)
{
if (ModelState.IsValid)
{
db.Airline.Add(airline);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(airline));
}
public ActionResult Create([Bind(Include = "Id,Code,DestPlace,FlightDate")] Flight flight)
{
if (ModelState.IsValid)
{
db.Flights.Add(flight);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(flight));
}
public ActionResult Create([Bind(Include = "Id,LName,FName,EnrolmentDate")] Client client)
{
if (ModelState.IsValid)
{
db.Clients.Add(client);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(client));
}
public bool DeleteMealById(int Id)
{
bool status = false;
var meal = GetMealById(Id);
meal.IsActive = false;
try
{
_airlineContext.SaveChanges();
status = true;
}
catch { }
return(status);
}
public void AddUser(string username, string email, string password)
{
context.Users.Add(new User {
Username = username, Email = email, Password = password, RoleId = 3
});
context.SaveChanges();
}
public ActionResult Create([Bind(Include = "Id,Name,NameAlias,FriendlyName,DisplayName,DbName,SSRSFolder")] Airline airlineModels)
{
if (ModelState.IsValid)
{
try
{
context.Airline.Add(airlineModels);
context.SaveChanges();
return(RedirectToAction("Index"));
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
return(View(airlineModels));
}
//Update race
public static void UpdateRace(int raceID, int raceTeamID)
{
AirlineContext db = new AirlineContext();
Race a = db.Races.Find(raceID);
a.RaceTeamID = raceTeamID;
db.SaveChanges();
}
static void Main(string[] args)
{
//Country c = new Country { Name="Serbia" };
AirlineContext context = new AirlineContext();
context.SaveChanges();
context.Dispose();
}
//Updating of the stuardesses for RaceTeam
public static void UpdateStuardesses(int?firstStuardess, int?secondStuardess, int raceTeamID)
{
AirlineContext db = new AirlineContext();
RaceTeam b = db.RaceTeams.Include(i => i.Stuardesses).FirstOrDefault(i => i.ID == raceTeamID);
b.Stuardesses.Clear();
db.SaveChanges();
Stuardess a = db.Stuardesses.FirstOrDefault(i => i.ID == firstStuardess);
if (a != null)
{
b.Stuardesses.Add(a);
db.SaveChanges();
}
a = db.Stuardesses.FirstOrDefault(i => i.ID == secondStuardess);
if (a != null)
{
b.Stuardesses.Add(a);
db.SaveChanges();
}
}
public bool Register(Users users)
{
bool status = false;
try
{
_airlineContext.Users.Add(users);
_airlineContext.SaveChanges();
status = true;
}
catch (Exception ex)
{
}
return(status);
}
public async Task <IActionResult> resetPassword(int id, User user)
{
var editPassword = await _context.Users.SingleOrDefaultAsync(r => r.ID == user.ID);
if (editPassword != null)
{
if (ModelState.IsValid)
{
string password = Crypto.HashPassword(user.Password);
editPassword.Password = password;
_context.Entry(editPassword).State = EntityState.Modified;
_context.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View());
}
public async Task <int> AddFligth(FlightRaw model)
{
_context.Flight.Add(model);
return(_context.SaveChanges());
}
public int SaveChanges()
{
return(Db.SaveChanges());
}
public void Commit()
{
context.SaveChanges();
}
public async Task Handle(CarNotReserved message, IMessageHandlerContext context)
{
log.Info($"Received CarNotReserved, CombinedReservationId = ");
//oslobodi sjedista
foreach (var seatRes in message.tickets)
{
List <Airline> companies = _context.AirlineCompanies
.Include(comp => comp.FastTickets)
.Include(comp => comp.Destinations)
.Include(comp => comp.PopDestinaations)
.Include(comp => comp.Raters)
.Include(comp => comp.Flights).ThenInclude(f => f.Luggage)
.Include(fs => fs.Flights).ThenInclude(d => d.From)
.Include(fs => fs.Flights).ThenInclude(d => d.To)
.Include(fs => fs.Flights).ThenInclude(d => d.Stops)
.Include(fs => fs.Flights).ThenInclude(d => d.Raters)
.Include(fs => fs.Flights).ThenInclude(d => d.SoldTickets)
.Include(fs => fs.Flights).ThenInclude(d => d.AllTickets)
.Include(fs => fs.Flights).ThenInclude(d => d.Seats).ThenInclude(d => d.Traveller)
.Include(fs => fs.Flights).ThenInclude(d => d.SoldTickets)
.Include(fs => fs.Flights).ThenInclude(d => d.Raters)
.ToList();
foreach (var u in companies)
{
foreach (var u2 in u.Flights)
{
foreach (var u3 in u2.Seats)
{
if (seatRes.Item1 == u3.Id)
{
u3.Taken = false;
_context.SaveChanges();
}
}
}
}
foreach (var c in companies)
{
foreach (var f in c.Flights)
{
foreach (var rez in f.AllTickets)
{
if (rez.userId == message.userId)
{
if (rez.Id == seatRes.Item2)
{
rez.userId = "-1";
rez.reqTick = "-1";
_context.SaveChanges();
}
}
}
}
}
}
SeatNotReserved seatNotReserved = new SeatNotReserved();
seatNotReserved.userId = message.userId;
seatNotReserved.resId = message.resId;
seatNotReserved.combinedReservationId = message.combinedReservationId;
await context.Publish(seatNotReserved).ConfigureAwait(false);
}
public static void SeedAirlines(AirlineContext con)
{
if (con.AirlineCompanies.Count() != 0)
{
return;
}
Airline airline = new Airline();
Destination d1 = new Destination();
d1.Name = "Belgrade";
d1.Description = "The capital and largest city of Serbia. It is located at the confluence of the Sava and Danube";
d1.Img = "belgrade.jpg";
Destination d2 = new Destination();
d2.Name = "Paris";
d2.Description = "Paris contains the most visited monuments in the city, including the Notre Dame Cathedral and the Louvre as well as the Sainte-Chapelle and the Eiffel Tower.";
d2.Img = "paris.jpg";
Destination d3 = new Destination();
d3.Name = "Banja Luka";
d3.Description = "The city lies on the Vrbas River and is well known in the countries of the former Yugoslavia for being full of tree-lined avenues, boulevards, gardens, and parks.";
d3.Img = "banjaluka.jpg";
Destination d4 = new Destination();
d4.Name = "London";
d4.Description = "London is considered to be one of the most important global cities and has been called the most powerful, most desirable, most influential and most visited city.";
d4.Img = "london.jpg";
airline.Lat = 45.254410;
airline.Lon = 19.842550;
airline.Name = "Serbian air";
airline.FastTickets = new List <Ticket>();
airline.Raters = new List <Rater>();
airline.Address = "Belgrade, Serbia";
airline.Description = "Svi direktni letovi kompanije Air Serbia Beograd na jednom mestu. Ukoliko želite direktno da letite za Pariz, Amasterdam, Njujork, Tivat, Rim, Milano i druge evropske gradove Air Serbia je pravi izbor za vas!";
airline.Destinations = new List <Destination>();
airline.Destinations.Add(d1);
airline.Destinations.Add(d2);
airline.Destinations.Add(d3);
airline.Destinations.Add(d4);
airline.Img = "air-serbia.jpg";
airline.Rating = 0;
Flight flight = new Flight();
/* flight.SoldTickets = new List<Ticket>();
* flight.Extra = "Perfect your flight experience with full-flat seats, special food offers and other privileges.";
* flight.Luggage = new Luggage() { Dimensions = "20x30", Quantity = 200, Weight = 122 };
* flight.Rate = 0;
* flight.Raters = new List<Rater>();
* flight.IdCompany = "Serbian air";
* flight.Trip = Trip.One_way;
* flight.Seats = new List<Seat>();
* flight.From = d1;
* flight.To = d2;
* flight.DepartureDate = "10.29.1203";
*
* flight.NumOfPassengers = 300;
* flight.Price = 300;
* flight.Duration = "2";
* flight.Stops = new List<Destination>();
*
*
* Seat s1 = new Seat();
* s1.Type = Classes.First;
* s1.Traveller = new Traveller();
* s1.Taken = true;
* s1.IsSelected = false;
*
* Seat s2 = new Seat();
* s2.Type = Classes.First;
* s2.Traveller = new Traveller();
* s2.Taken = false;
* s2.IsSelected = false;
*
* Seat s3 = new Seat();
* s3.Type = Classes.First;
* s3.Traveller = new Traveller();
* s3.Taken = false;
* s3.IsSelected = false;
*
* Seat s4 = new Seat();
* s4.Type = Classes.First;
* s4.Traveller = new Traveller();
* s4.Taken = false;
* s4.IsSelected = false;
*
* Seat s5 = new Seat();
* s5.Type = Classes.First;
* s5.Traveller = new Traveller();
* s5.Taken = true;
* s5.IsSelected = false;
*
* Seat s6 = new Seat();
* s6.Type = Classes.First;
* s6.Traveller = new Traveller();
* s6.Taken = false;
* s6.IsSelected = false;
*
* Seat s7 = new Seat();
* s7.Type = Classes.First;
* s7.Traveller = new Traveller();
* s7.Taken = false;
* s7.IsSelected = false;
*
* Seat s8 = new Seat();
* s8.Type = Classes.First;
* s8.Traveller = new Traveller();
* s8.Taken = false;
* s8.IsSelected = false;
*
* Seat s9 = new Seat();
* s9.Type = Classes.Business;
* s9.Traveller = new Traveller();
* s9.Taken = false;
* s9.IsSelected = false;
*
* Seat s10 = new Seat();
* s10.Type = Classes.Business;
* s10.Traveller = new Traveller();
* s10.Taken = false;
* s10.IsSelected = false;
*
* Seat s11 = new Seat();
* s11.Type = Classes.Business;
* s11.Traveller = new Traveller();
* s11.Taken = false;
* s11.IsSelected = false;
*
* Seat s12 = new Seat();
* s12.Type = Classes.Business;
* s12.Traveller = new Traveller();
* s12.Taken = true;
* s12.IsSelected = false;
*
* Seat s13 = new Seat();
* s13.Type = Classes.Economy;
* s13.Traveller = new Traveller();
* s13.Taken = true;
* s13.IsSelected = false;
*
* Seat s14 = new Seat();
* s14.Type = Classes.Economy;
* s14.Traveller = new Traveller();
* s14.Taken = true;
* s14.IsSelected = false;
*
* Seat s15 = new Seat();
* s15.Type = Classes.Economy;
* s15.Traveller = new Traveller();
* s15.Taken = true;
* s15.IsSelected = false;
*
* Seat s16 = new Seat();
* s16.Type = Classes.Economy;
* s16.Traveller = new Traveller();
* s16.Taken = true;
* s16.IsSelected = false;
*
*
* flight.Seats.Add(s1);
* flight.Seats.Add(s2);
* flight.Seats.Add(s3);
* flight.Seats.Add(s4);
* flight.Seats.Add(s5);
* flight.Seats.Add(s6);
* flight.Seats.Add(s7);
* flight.Seats.Add(s8);
* flight.Seats.Add(s9);
* flight.Seats.Add(s10);
* flight.Seats.Add(s11);
* flight.Seats.Add(s12);
* flight.Seats.Add(s13);
* flight.Seats.Add(s14);
* flight.Seats.Add(s15);
* flight.Seats.Add(s16);
*/
airline.Flights = new List <Flight>();
//airline.Flights.Add(flight);
con.AirlineCompanies.Add(airline);
con.SaveChanges();
}
public async Task Handle(ReservationCreated message, IMessageHandlerContext context)
{
log.Info($"Received ReservationCreated, CombinedReservationId = {message.combinedReservationId}");
//napravi rezervaciju za sjedista
List <Airline> companies = _context.AirlineCompanies
.Include(comp => comp.FastTickets)
.Include(comp => comp.Destinations)
.Include(comp => comp.PopDestinaations)
.Include(comp => comp.Raters)
.Include(comp => comp.Flights).ThenInclude(f => f.Luggage)
.Include(fs => fs.Flights).ThenInclude(d => d.From)
.Include(fs => fs.Flights).ThenInclude(d => d.To)
.Include(fs => fs.Flights).ThenInclude(d => d.Stops)
.Include(fs => fs.Flights).ThenInclude(d => d.Raters)
.Include(fs => fs.Flights).ThenInclude(d => d.SoldTickets)
.Include(fs => fs.Flights).ThenInclude(d => d.AllTickets)
.Include(fs => fs.Flights).ThenInclude(d => d.Seats).ThenInclude(d => d.Traveller)
.Include(fs => fs.Flights).ThenInclude(d => d.SoldTickets)
.Include(fs => fs.Flights).ThenInclude(d => d.Raters)
.ToList();
string userid = message.userId;
int points = Int32.Parse(message.pointsS);
Discount dis = new Discount();
dis.BronzeTier = message.tickets[0].b;
dis.SilverTier = message.tickets[0].s;
dis.DiscountPercent = message.tickets[0].d;
dis.GoldTier = message.tickets[0].g;
List <Tuple <int, int> > tickets = new List <Tuple <int, int> >();
int mainSeatId = 0;
using (var dbContextTransaction = _context.Database.BeginTransaction())
{
foreach (var model in message.tickets)
{
foreach (var u in companies)
{
foreach (var u2 in u.Flights)
{
foreach (var u3 in u2.Seats)
{
if (u3.Id == model.seat.Id) // ako je to sediste iz rezervacije
{
if (!u3.Taken)
{
u3.Traveller = new Traveller()
{
Email = model.seat.Traveller.Email, FirstName = model.seat.Traveller.FirstName, IdUser = model.seat.Traveller.IdUser, LastName = model.seat.Traveller.LastName, Passport = model.seat.Traveller.Passport
};
u3.Taken = true;
try
{
_context.SaveChanges();
}
catch (Exception e)
{
await dbContextTransaction.RollbackAsync();
SeatNotReserved resFailed = new SeatNotReserved();
resFailed.combinedReservationId = message.combinedReservationId;
resFailed.userId = message.userId;
resFailed.resId = message.resId;
await context.Publish(resFailed).ConfigureAwait(false);
return;
}
Ticket t = new Ticket()
{
Discount = 0, Flight = u2, Seat = u3
};
if (userid == model.seat.Traveller.IdUser)
{
t.userId = userid;
if (points > dis.BronzeTier && points < dis.SilverTier)
{
t.Discount = (Int32)(dis.DiscountPercent) + t.Discount;
}
else if (points > dis.SilverTier && points < dis.GoldTier)
{
t.Discount = (Int32)(dis.DiscountPercent * 2) + t.Discount;
}
else
{
t.Discount = (Int32)(dis.DiscountPercent * 3) + t.Discount;
}
if (u2.SoldTickets == null)
{
u2.SoldTickets = new List <SoldTicket>();
}
u2.SoldTickets.Add(new SoldTicket()
{
ticket = t
});
if (u2.AllTickets == null)
{
u2.AllTickets = new List <Ticket>();
}
u2.AllTickets.Add(t);
try
{
_context.SaveChanges();
}
catch (Exception e)
{
await dbContextTransaction.RollbackAsync();
SeatNotReserved resFailed = new SeatNotReserved();
resFailed.combinedReservationId = message.combinedReservationId;
resFailed.userId = message.userId;
resFailed.resId = message.resId;
await context.Publish(resFailed).ConfigureAwait(false);
return;
}
mainSeatId = t.Id;
}
else
{
t.reqTick = model.seat.Traveller.IdUser;
u2.AllTickets.Add(t);
try
{
_context.SaveChanges();
}
catch (Exception e)
{
await dbContextTransaction.RollbackAsync();
SeatNotReserved resFailed = new SeatNotReserved();
resFailed.combinedReservationId = message.combinedReservationId;
resFailed.userId = message.userId;
resFailed.resId = message.resId;
await context.Publish(resFailed).ConfigureAwait(false);
return;
}
}
tickets.Add(new Tuple <int, int>(u3.Id, t.Id));
if (message.userId == model.seat.Traveller.IdUser)
{
mainSeatId = t.Id;
}
}
else
{
await dbContextTransaction.RollbackAsync();
SeatNotReserved resFailed = new SeatNotReserved();
resFailed.combinedReservationId = message.combinedReservationId;
resFailed.userId = message.userId;
resFailed.resId = message.resId;
await context.Publish(resFailed).ConfigureAwait(false);
return;
}
}
}
}
}
}
await dbContextTransaction.CommitAsync();
}
SeatReserved seatReserved = new SeatReserved();
seatReserved.combinedReservationId = message.combinedReservationId;
seatReserved.car = message.car;
seatReserved.userId = message.userId;
seatReserved.pointsS = message.pointsS;
seatReserved.tickets = tickets;
seatReserved.resId = message.resId;
seatReserved.mainSeatId = mainSeatId;
await context.Publish(seatReserved).ConfigureAwait(false);
}
