public async Task <IActionResult> UpdateUserDiscount(string type, UserDiscount discount)
{
var result = await _publicTransportRepository.UpdateDiscount(type, discount);
if (result != null)
{
return(Ok(result));
}
else
{
return(BadRequest("Failed to update timetable"));
}
}
public async Task <UserDiscount> UpdateDiscount(string type, UserDiscount discount)
{
var discountForUpdate = await _userDiscountRepository.GetUserDiscountForType(type);
_context.Update(discountForUpdate);
discountForUpdate.Value = discount.Value;
if (await SaveAll())
{
return(discountForUpdate);
}
else
{
return(null);
}
}
public void SeedStations()
{
List <Station> stations8 = new List <Station>();
List <Station> stations4 = new List <Station>();
List <StationLine> stlines8 = new List <StationLine>();
List <StationLine> stlines4 = new List <StationLine>();
Line lines8 = new Line();
Line lines4 = new Line();
if (!_context.Stations.Any())
{
Station station = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Jovana Ducica"
},
Location = new Location()
{
X = 45.248643,
Y = 19.792551
},
Name = "Okretnica 8-ce"
};
_context.Add(station);
stations8.Add(station);
Station station2 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.250305,
Y = 19.791516
},
Name = "Okretnica 8-ce"
};
_context.Add(station2);
stations8.Add(station2);
Station station3 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.253440,
Y = 19.789697
},
Name = "Okretnica 8-ce"
};
_context.Add(station3);
stations8.Add(station3);
Station station4 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.255003,
Y = 19.794144
},
Name = "Okretnica 8-ce"
};
_context.Add(station4);
stations8.Add(station4);
Station station5 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.251204,
Y = 19.796821
},
Name = "Okretnica 8-ce"
};
_context.Add(station5);
stations8.Add(station5);
Station station6 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.251023,
Y = 19.798561
},
Name = "Okretnica 8-ce"
};
_context.Add(station6);
stations8.Add(station6);
Station station7 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.254104,
Y = 19.807508
},
Name = "Okretnica 8-ce"
};
_context.Add(station7);
stations8.Add(station7);
Station station8 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.257155,
Y = 19.816241
},
Name = "Okretnica 8-ce"
};
_context.Add(station8);
stations8.Add(station8);
Station station9 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.258862,
Y = 19.822775
},
Name = "Okretnica 8-ce"
};
_context.Add(station9);
stations8.Add(station9);
Station station10 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.260678,
Y = 19.833057
},
Name = "Okretnica 8-ce"
};
_context.Add(station10);
stations8.Add(station10);
Station station11 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.262600,
Y = 19.839689
},
Name = "Okretnica 8-ce"
};
_context.Add(station11);
stations8.Add(station11);
Station station12 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Jovana Subotica"
},
Location = new Location()
{
X = 45.260318,
Y = 19.842785
},
Name = "Okretnica 8-ce"
};
_context.Add(station12);
stations8.Add(station12);
Station station13 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.256089,
Y = 19.841208
},
Name = "Okretnica 8-ce"
};
_context.Add(station13);
stations8.Add(station13);
Station station14 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.253385,
Y = 19.843214
},
Name = "Okretnica 8-ce"
};
_context.Add(station14);
stations8.Add(station14);
Station station15 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.253521,
Y = 19.847516
},
Name = "Okretnica 8-ce"
};
_context.Add(station15);
stations8.Add(station15);
Station station16 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.251270,
Y = 19.846840
},
Name = "Okretnica 8-ce"
};
_context.Add(station16);
stations8.Add(station16);
Station station17 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.247750,
Y = 19.849104
},
Name = "Okretnica 8-ce"
};
_context.Add(station17);
stations8.Add(station17);
Station station18 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.245620,
Y = 19.846819
},
Name = "Okretnica 8-ce"
};
_context.Add(station18);
stations8.Add(station18);
Station station19 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21000",
Street = "Bulevar Kneza Milosa"
},
Location = new Location()
{
X = 45.238989,
Y = 19.847967
},
Name = "Okretnica 8-ce"
};
_context.Add(station19);
stations8.Add(station19);
//stations 4
Station station20 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Bulevar Jase Tomica"
},
Location = new Location()
{
X = 45.26446733929329,
Y = 19.829593939230563
},
Name = "Zeleznicka stanica"
};
_context.Add(station20);
stations4.Add(station20);
Station station21 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Bulevar oslobodjenja 30"
},
Location = new Location()
{
X = 45.26001187717833,
Y = 19.832297605917574
},
Name = "Lutrija"
};
_context.Add(station21);
stations4.Add(station21);
Station station22 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Bulevar oslobodjenja 66a"
},
Location = new Location()
{
X = 45.25462227539901,
Y = 19.83525958562143
},
Name = "Aleksandar zgrada"
};
_context.Add(station22);
stations4.Add(station22);
Station station23 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Jevrejska 31"
},
Location = new Location()
{
X = 45.25158042895487,
Y = 19.83682571728548
},
Name = "Futoska pijaca"
};
_context.Add(station23);
stations4.Add(station23);
Station station24 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Centar"
},
Location = new Location()
{
X = 45.25390672021402,
Y = 19.842361796692217
},
Name = "Lili"
};
_context.Add(station24);
stations4.Add(station24);
Station station25 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Centar"
},
Location = new Location()
{
X = 45.25318165264042,
Y = 19.84401403744539
},
Name = "Bazar"
};
_context.Add(station25);
stations4.Add(station25);
Station station26 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Bulevar Jase Tomica"
},
Location = new Location()
{
X = 45.2534938719465,
Y = 19.84743306299697
},
Name = "Zeleznicka stanica"
};
_context.Add(station26);
stations4.Add(station26);
Station station27 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Bulevar Jase Tomica"
},
Location = new Location()
{
X = 45.25122798857049,
Y = 19.846853705849753
},
Name = "Zeleznicka stanica"
};
_context.Add(station27);
stations4.Add(station27);
Station station28 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Strazilovska"
},
Location = new Location()
{
X = 45.247753458479686,
Y = 19.84917113443862
},
Name = "Strazilovska"
};
_context.Add(station28);
stations4.Add(station28);
Station station29 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Izvor, Bulevar Cara Lazara"
},
Location = new Location()
{
X = 45.24551257269078,
Y = 19.846830790917465
},
Name = "Izvor"
};
_context.Add(station29);
stations4.Add(station29);
Station station30 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Narodnog fronta 1"
},
Location = new Location()
{
X = 45.24253627573835,
Y = 19.84749597875316
},
Name = "Zeleznicka stanica"
};
_context.Add(station30);
stations4.Add(station30);
Station station31 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Narodnog fronta"
},
Location = new Location()
{
X = 45.24037140396024,
Y = 19.837623919236535
},
Name = "Narodnog fronta"
};
_context.Add(station31);
stations4.Add(station31);
Station station32 = new Station()
{
Address = new Address()
{
City = "Novi Sad",
Number = "21101",
Street = "Narodnog fronta"
},
Location = new Location()
{
X = 45.237289068480194,
Y = 19.826809252488488
},
Name = "Narodnog fronta"
};
_context.Add(station32);
stations4.Add(station32);
}
if (!_context.StationLines.Any())
{
foreach (Station s in stations8)
{
StationLine stline = new StationLine()
{
Station = s
};
_context.Add(stline);
stlines8.Add(stline);
}
foreach (Station s in stations4)
{
StationLine stline = new StationLine()
{
Station = s
};
_context.Add(stline);
stlines4.Add(stline);
}
}
if (!_context.Lines.Any())
{
Line line8 = new Line()
{
Name = "NOVO NASELJE - CENTAR - LIMAN 4",
LineNumber = 8,
Buses = new List <Bus>()
{
new Bus()
{
BusNumber = 244,
InUse = true,
},
new Bus()
{
BusNumber = 222,
InUse = true,
},
new Bus()
{
BusNumber = 234,
InUse = true,
}
},
Stations = stlines8
};
_context.Add(line8);
lines8 = line8;
Line line4 = new Line()
{
Name = "ZELEZNICKA STANICA - CENTAR - LIMAN 4",
LineNumber = 4,
Buses = new List <Bus>()
{
new Bus()
{
BusNumber = 135,
InUse = true,
},
new Bus()
{
BusNumber = 789,
InUse = true,
},
new Bus()
{
BusNumber = 354,
InUse = true,
}
},
Stations = stlines4
};
_context.Add(line4);
lines4 = line4;
}
if (!_context.TimeTables.Any())
{
TimeTable timeTable1 = new TimeTable()
{
Day = "Working day",
Departures = "00:12-22-25-34-40-45-58-/01:30-/02:30-/03:30-/04:30-/05:30-/06:00-20-40-/07:03-12-23-30-45-58-/08:13-22-25-30-45-58-/09:03-12-23-30-45-58-/10:03-12-23-30-45-58-/11:03-12-23-30-45-58-/12:03-12-23-30-45-58-/13:03-12-23-30-45-58-/14:03-12-23-30-45-58-/15:03-12-23-30-45-58-/16:03-12-23-30-45-58-/17:00-23-30-40-58-/18:00-23-30-40-58-/19:00-23-30-40-58-/20:00-23-40-58-/21:00-23-40-58-/22:00-23-40-58-/23:00-30-58-/",
Type = "In City",
Line = lines8,
LineId = lines8.Id
};
_context.Add(timeTable1);
TimeTable timeTable2 = new TimeTable()
{
Day = "Working day",
Departures = "00:12-25-34-40-45-58-/01:30-/02:30-/03:30-/04:30-/05:30-/06:00-25-40-/07:03-14-23-37-45-52-/08:13-22-25-30-45-58-/09:03-12-30-45-58-/10:03-12-27-30-41-58-/11:03-12-23-30-45-58-/12:03-12-23-30-45-58-/13:03-12-23-30-45-58-/14:03-12-23-30-45-58-/15:03-12-23-30-45-58-/16:03-12-23-30-45-58-/17:00-23-30-40-58-/18:00-23-30-40-58-/19:00-23-30-40-58-/20:00-23-40-58-/21:00-23-40-58-/22:00-23-40-58-/23:00-30-58-/",
Type = "In City",
Line = lines4,
LineId = lines4.Id
};
_context.Add(timeTable2);
}
if (!_context.PricelistItems.Any())
{
UserDiscount ud1 = new UserDiscount()
{
Type = "Student",
Value = 20
};
_context.Add(ud1);
UserDiscount ud2 = new UserDiscount()
{
Type = "Regular",
Value = 0
};
_context.Add(ud2);
UserDiscount ud3 = new UserDiscount()
{
Type = "Senior",
Value = 35
};
_context.Add(ud3);
Item it1 = new Item()
{
Type = "Hourly",
Description = "This ticket is valid just for one hour"
};
_context.Add(it1);
Item it2 = new Item()
{
Type = "Daily",
Description = "This ticket is valid until 00:00 next day"
};
_context.Add(it2);
Item it3 = new Item()
{
Type = "Monthly",
Description = "This ticket is valid for one month"
};
_context.Add(it3);
Item it4 = new Item()
{
Type = "Annual",
Description = "This ticket is valid for one year"
};
_context.Add(it4);
_context.SaveChanges();
Pricelist pr = new Pricelist()
{
Active = true,
From = DateTime.Now,
To = DateTime.Now.AddMonths(4)
};
_context.Add(pr);
_context.SaveChanges();
PricelistItem prit1 = new PricelistItem()
{
Pricelist = pr,
Price = 150,
Item = it1
};
_context.Add(prit1);
PricelistItem prit2 = new PricelistItem()
{
Pricelist = pr,
Price = 390,
Item = it2
};
_context.Add(prit2);
PricelistItem prit3 = new PricelistItem()
{
Pricelist = pr,
Price = 3450,
Item = it3
};
_context.Add(prit3);
PricelistItem prit4 = new PricelistItem()
{
Pricelist = pr,
Price = 12050,
Item = it4
};
_context.Add(prit4);
}
_context.SaveChanges();
}
