protected void btnCount_Click(object sender, EventArgs e)
{
OperationDataContext od = new OperationDataContext();
tblSizes2 tblSizes2 = new tblSizes2();
var counts =
}
public MenuController()
{
context = new OperationDataContext();
}
public UserModelController()
{
context = new OperationDataContext();
}
public UserRoleController()
{
context = new OperationDataContext();
}
private void BusVehicleSeed()
{
OperationDataContext context = new OperationDataContext();
var bandung = new PlaceModel {
Name = "Bandung"
};
var yogyakarta = new PlaceModel {
Name = "Yogyakarta"
};
var curup = new PlaceModel {
Name = "Curup"
};
var surabaya = new PlaceModel {
Name = "Surabaya"
};
var denpasar = new PlaceModel {
Name = "Denpasar"
};
var places = new List <PlaceModel>()
{
bandung, yogyakarta, curup, surabaya, denpasar
};
List <RouteModel> busRoutes = new List <RouteModel>();
// Generate list of busRoute
foreach (var origin in places)
{
foreach (var destination in places)
{
if (origin != destination)
{
busRoutes.Add(new RouteModel {
OriginName = origin.Name, DestinationName = destination.Name
});
}
}
}
if (context.Places.Count() == 0)
{
// Insert all places above to database
foreach (var item in places)
{
Place place = new Place()
{
Name = item.Name
};
context.Places.InsertOnSubmit(place);
context.SubmitChanges();
}
// Insert all busRoute to database
foreach (var item in busRoutes)
{
Route route = new Route()
{
Origin = item.OriginName,
Destination = item.DestinationName
};
context.Routes.InsertOnSubmit(route);
context.SubmitChanges();
}
}
if (context.BusVehicles.Count() == 0)
{
var dates = DateTimeGenerator.GetDaysInRange(DateTime.Today, DateTime.Today.AddDays(60));
var busses = new List <BusVehicleModel>();
var busNames = new List <string>()
{
"Primajasa", "MGI", "Budiman", "Putra Raflesia", "Lorena", "Haryanto"
};
var busClasses = AppConstants.BusClasses;
foreach (DateTime date in dates)
{
//var tes = date;
for (double i = 0; i < 24; i += 2)
{
foreach (var route in busRoutes)
{
int randName = rand.Next(busNames.Count);
int randClass = rand.Next(busClasses.Count);
busses.Add(BusGenerator.GenerateBus(route,
date.AddHours(rand.Next(0, 24)).AddMinutes(rand.Next(0, 60)),
busNames[randName],
busClasses[randClass]));
}
}
}
// Insert all busvehicle to database
// Belum bisa, masih ada errornya
foreach (var item in busses)
{
BusVehicle busVehicle = new BusVehicle()
{
Name = item.Name,
Class = item.Class,
DepartureTime = DateTime.Parse(item.DepartureTime),
RouteID = item.RouteID
};
//context.BusVehicles.InsertOnSubmit(busVehicle);
//context.SubmitChanges();
}
}
}
public GenreController()
{
context = new OperationDataContext();
}
public QorderController()
{
context = new OperationDataContext();
}
public ReservationController()
{
context = new OperationDataContext();
}
public KasirController()
{
context = new OperationDataContext();
}
public AdminController()
{
context = new OperationDataContext();
}
public HandlerController()
{
context = new OperationDataContext();
}
public PemesananController()
{
context = new OperationDataContext();
}
public SongController()
{
context = new OperationDataContext();
}
public BooksController()
{
context = new OperationDataContext();
}
public PesawatController()
{
context = new OperationDataContext();
}
public RouteController()
{
context = new OperationDataContext();
}
public InstructorController()
{
context = new OperationDataContext();
}
public BusVehicleController()
{
context = new OperationDataContext();
}
public PlaceController()
{
context = new OperationDataContext();
}
public CartController()
{
context = new OperationDataContext();
}
public MaskapaiController()
{
context = new OperationDataContext();
}
public InvoiceController()
{
context = new OperationDataContext();
}
public PassengerController()
{
context = new OperationDataContext();
}
