public async Task AddDriver(Domain.Driver.Driver driver)
{
string query = "INSERT INTO driver(name, surname, phone, carid) VALUES(@Name, @Surname, @Phone, @CarId)";
await _dbConnection.ExecuteAsync(query, driver);
}
protected override void Seed(WingsContext context)
{
Role dispatcher = new Role()
{
RoleId = 2,
RoleName = "Dispatcher",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow,
Users = new List<User>()
{
new User()
{
FirstName = "malshan",
LastName = "malshan",
Email = "*****@*****.**", // Username
Password = "******", // User@123
//PasswordSalt = "100000.YD4FrpXzZ1Dv3iUX3LZBCuvAYs/XkKCZkR9d2l0R5b6XnQ==",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
},
new User()
{
FirstName = "dilini",
LastName = "dilini",
Email = "*****@*****.**", // Username
Password = "******", // User@123
//PasswordSalt = "100000.YD4FrpXzZ1Dv3iUX3LZBCuvAYs/XkKCZkR9d2l0R5b6XnQ==",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
},
new User()
{
FirstName = "sachitra",
LastName = "sachitra",
Email = "*****@*****.**", // Username
Password = "******", // User@123
//PasswordSalt = "100000.YD4FrpXzZ1Dv3iUX3LZBCuvAYs/XkKCZkR9d2l0R5b6XnQ==",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
},
new User()
{
FirstName = "yohan",
LastName = "yohan",
Email = "*****@*****.**", // Username
Password = "******", // User@123
//PasswordSalt = "100000.YD4FrpXzZ1Dv3iUX3LZBCuvAYs/XkKCZkR9d2l0R5b6XnQ==",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
},
new User()
{
FirstName = "darrell",
LastName = "darrell",
Email = "*****@*****.**", // Username
Password = "******", // User@123
//PasswordSalt = "100000.YD4FrpXzZ1Dv3iUX3LZBCuvAYs/XkKCZkR9d2l0R5b6XnQ==",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
},
new User()
{
FirstName = "sugeeth",
LastName = "sugeeth",
Email = "*****@*****.**", // Username
Password = "******", // User@123
//PasswordSalt = "100000.YD4FrpXzZ1Dv3iUX3LZBCuvAYs/XkKCZkR9d2l0R5b6XnQ==",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
},
new User()
{
FirstName = "diran",
LastName = "diran",
Email = "*****@*****.**", // Username
Password = "******", // User@123
//PasswordSalt = "100000.YD4FrpXzZ1Dv3iUX3LZBCuvAYs/XkKCZkR9d2l0R5b6XnQ==",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
}
}
};
Role admin = new Role()
{
RoleId = 1,
RoleName = "Admin",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow,
Users = new List<User>()
{
new User()
{
FirstName = "shanaka",
LastName = "shanaka",
Email = "[email protected] ", // Username
Password = "******", // User@123
//PasswordSalt = "100000.YD4FrpXzZ1Dv3iUX3LZBCuvAYs/XkKCZkR9d2l0R5b6XnQ==",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
},
new User()
{
FirstName = "cheyenne",
LastName = "cheyenne",
Email = "*****@*****.**", // Username
Password = "******", // User@123
//PasswordSalt = "100000.YD4FrpXzZ1Dv3iUX3LZBCuvAYs/XkKCZkR9d2l0R5b6XnQ==",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
},
new User()
{
FirstName = "prasad",
LastName = "prasad",
Email = "*****@*****.**", // Username
Password = "******", // User@123
//PasswordSalt = "100000.YD4FrpXzZ1Dv3iUX3LZBCuvAYs/XkKCZkR9d2l0R5b6XnQ==",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
},
new User()
{
FirstName = "roshan",
LastName = "roshan",
Email = "*****@*****.**", // Username
Password = "******", // User@123
//PasswordSalt = "100000.YD4FrpXzZ1Dv3iUX3LZBCuvAYs/XkKCZkR9d2l0R5b6XnQ==",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
},
new User()
{
FirstName = "chaminda",
LastName = "chaminda",
Email = "*****@*****.**", // Username
Password = "******", // User@123
//PasswordSalt = "100000.YD4FrpXzZ1Dv3iUX3LZBCuvAYs/XkKCZkR9d2l0R5b6XnQ==",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
}
}
};
Vehicle car = new Vehicle()
{
VehicleNumber = "HG-1234",
ChassisNumber = "876ythgrsqwqee-wqwqsqe",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow,
EmissionTestExpDate = DateTime.UtcNow,
EngineNumber = "engine0098ythee",
InsuranceNumber = "Ceylinco",
InsuranceExpDate = DateTime.UtcNow,
LicenseExpDate = DateTime.UtcNow,
IsDeleted = false,
//VehicleId = 001,
VehicleMake = "Nissan",
VehicleMFYear = "2000",
VehicleModel = "Cefiro",
VehicleDeliveryType = "Car"
};
Vehicle suv = new Vehicle()
{
VehicleNumber = "KG-7801",
ChassisNumber = "876yth679hgjyqwqee-wqwqsqe",
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow,
EmissionTestExpDate = DateTime.UtcNow,
EngineNumber = "engine009mnjythee",
IsDeleted = false,
InsuranceNumber = "Ceylinco",
InsuranceExpDate = DateTime.UtcNow,
LicenseExpDate = DateTime.UtcNow,
//VehicleId = 001,
VehicleMake = "Toyota",
VehicleMFYear = "2008",
VehicleModel = "Prado",
VehicleDeliveryType = "SUV",
};
VehicleRate rateOne = new VehicleRate()
{
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow,
IsDeleted = false,
PassengerType = "Guest",
FarePerKm = 85,
WaitingChargers = 300,
VehicleType = "Car"
};
VehicleRate rateTwo = new VehicleRate()
{
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow,
IsDeleted = false,
PassengerType = "Guest",
FarePerKm = 100,
WaitingChargers = 300,
VehicleType = "SUV"
};
VehicleRate rateThree = new VehicleRate()
{
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow,
IsDeleted = false,
PassengerType = "Staff",
FarePerKm = 70,
WaitingChargers = 300,
VehicleType = "Car/SUV"
};
PreDefineTrip tripOne = new PreDefineTrip()
{
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow,
IsDeleted = false,
VehicleType = "Car",
Distance = "100",
Rate = 2500,
PreDefineTripName = "Odel, Alexandra Place"
};
PreDefineTrip tripTwo = new PreDefineTrip()
{
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow,
IsDeleted = false,
VehicleType = "SUV",
Distance = "120",
Rate = 4500,
PreDefineTripName = "Airport, Katunayake"
};
Domain.Driver.Driver driverOne = new Domain.Driver.Driver()
{
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow,
DLNumber = "gr23334!!334244rdewe**&32232",
EPFNumber = "16700982",
Name = "Eranda Asiri",
IsDeleted = false,
ResidentAddress = "Ratnapura",
NIC = "907865434v",
ContactNumber1 = "098767656",
ContactNumber2 = "87876544356"
};
Domain.Driver.Driver driverTwo = new Domain.Driver.Driver()
{
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow,
DLNumber = "gr23334==-334244rdewe**&32232",
EPFNumber = "16704582",
Name = "Asanka Madushan",
IsDeleted = false,
ResidentAddress = "Seeduwa",
NIC = "867869634v",
ContactNumber1 = "098767656",
ContactNumber2 = "87876544356"
};
BataRate bataRateOne = new BataRate()
{
Description = "Overnight",
Amount = 1000,
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
};
BataRate bataRateTwo = new BataRate()
{
Description = "Full Day - Colombo",
Amount = 400,
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
};
BataRate bataRateThree = new BataRate()
{
Description = "Full Day - Outstation",
Amount = 600,
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
};
BataRate bataRateFour = new BataRate()
{
Description = "Airport - Pick Up",
Amount = 200,
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
};
BataRate bataRateFive = new BataRate()
{
Description = "Airport - Drop",
Amount = 200,
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
};
BataRate bataRateSix = new BataRate()
{
Description = "Airort - Drop & Pickup",
Amount = 750,
Created = DateTime.UtcNow,
Modified = DateTime.UtcNow
};
context.Role.Add(admin);
context.Role.Add(dispatcher);
//context.Vehicle.Add(car);
//context.Vehicle.Add(suv);
context.VehicleRate.Add(rateOne);
context.VehicleRate.Add(rateTwo);
context.VehicleRate.Add(rateThree);
//context.PreDefineTrip.Add(tripOne);
//context.PreDefineTrip.Add(tripTwo);
//context.Driver.Add(driverOne);
//context.Driver.Add(driverTwo);
//context.BataRate.Add(bataRateOne);
//context.BataRate.Add(bataRateTwo);
//context.BataRate.Add(bataRateThree);
//context.BataRate.Add(bataRateFour);
//context.BataRate.Add(bataRateFive);
//context.BataRate.Add(bataRateSix);
base.Seed(context);
}