public List <PickUpTruck> Sp_GetAllPickUpTrucks()
{
List <PickUpTruck> pickUpTrucks = new List <PickUpTruck>();
PickUpTruck p;
using (SqlConnection con = new SqlConnection(connectionString))
{
try
{
con.Open();
SqlCommand cmd1 = new SqlCommand("Sp_GetAllPickUpTrucks", con);
cmd1.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd1.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
string pickUpTruckName = reader["PickUpTruckName"].ToString();
p = new PickUpTruck(pickUpTruckName);
pickUpTrucks.Add(p);
}
}
}
catch (SqlException e)
{
Console.WriteLine("Ups" + e.Message);
}
}
return(pickUpTrucks);
}
public string UpdatePickUpAgreement(int pickUpAgreementId, int vehicleID, string driverName, string pickUpTruckName, int postalCode, string licensePlate,
string brand, string streetName, DateTime pickUpDate, string pickUpTime, double price)
{
string city = dbc.Sp_GetCityByPostalCode(postalCode);
PickUpTruck pickUpTruck = new PickUpTruck(pickUpTruckName);
Driver driver = new Driver(driverName);
Vehicle vehicle = new Vehicle(licensePlate, brand, vehicleID);
PickUpAgreement pickUpAgreement = puar.GetSinglePickUpAgreement(pickUpAgreementId);
pickUpAgreement.UpdatePickUpAgreement(driver, pickUpTruck, city, postalCode, vehicle, price, streetName, pickUpDate, pickUpTime);
dbc.Sp_UpdatePickUpAgreement(pickUpAgreement);
return(puar.UpdatePickUpAgreement(pickUpAgreement));
}
public List <PickUpAgreement> Sp_GetAllPickUpAgreements()
{
List <PickUpAgreement> pickUpAgreements = new List <PickUpAgreement>();
PickUpAgreement pickUpAgreement;
using (SqlConnection con = new SqlConnection(connectionString))
{
try
{
con.Open();
SqlCommand cmd1 = new SqlCommand("Sp_GetAllPickUpAgreements", con);
cmd1.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd1.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
int pickUpAgreementId = int.Parse(reader["PickUpAgreementId"].ToString());
string driverName = reader["DriverName"].ToString();
string pickUpTruckName = reader["PickUpTruckName"].ToString();
string streetName = reader["StreetName"].ToString();
int postalCode = int.Parse(reader["PostalCode"].ToString());
string city = reader["City"].ToString();
string pickUpTime = reader["PickUpTime"].ToString();
DateTime pickUpDate = reader.GetFieldValue <DateTime>(reader.GetOrdinal("PickUpDate"));
string licensePlate = reader["LicensePlate"].ToString();
string brand = reader["Brand"].ToString();
double price = double.Parse(reader["Price"].ToString());
int vehicleId = int.Parse(reader["VehicleID"].ToString());
Vehicle vehicle = new Vehicle(licensePlate, brand, vehicleId);
Driver driver = new Driver(driverName);
PickUpTruck pickUpTruck = new PickUpTruck(pickUpTruckName);
pickUpAgreement = new PickUpAgreement(pickUpAgreementId, driver, pickUpTruck, city, postalCode, vehicle, price, streetName, pickUpDate, pickUpTime);
pickUpAgreements.Add(pickUpAgreement);
}
}
}
catch (SqlException e)
{
Console.WriteLine("Ups" + e.Message);
}
}
return(pickUpAgreements);
}
public PickUpAgreement Sp_CreatePickUpAgreement(string driverName, string pickUpTruckName, int postalCode, string licensePlate, string brand, double price, string address, DateTime pickUpDate, string pickUpTime)
{
PickUpAgreement pua = null;
int pickUpId = 0;
string city = "";
int vehicleId = 0;
using (SqlConnection con = new SqlConnection(connectionString))
{
try
{
con.Open();
SqlCommand cmd1 = new SqlCommand("Sp_CreatePickUpAgreement", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add(new SqlParameter("@DriverName", driverName));
cmd1.Parameters.Add(new SqlParameter("@PickUpTruckName", pickUpTruckName));
cmd1.Parameters.Add(new SqlParameter("@PostalCode", postalCode));
cmd1.Parameters.Add(new SqlParameter("@LicensePlate", licensePlate));
cmd1.Parameters.Add(new SqlParameter("@Brand", brand));
cmd1.Parameters.Add(new SqlParameter("@Price", price));
cmd1.Parameters.Add(new SqlParameter("@StreetName", address));
cmd1.Parameters.Add(new SqlParameter("@PickUpDate", pickUpDate));
cmd1.Parameters.Add(new SqlParameter("@PickUpTime", pickUpTime));
SqlDataReader reader = cmd1.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
pickUpId = int.Parse(reader["PickUpAgreementID"].ToString());
city = reader["City"].ToString();
vehicleId = int.Parse(reader["VehicleID"].ToString());
}
}
Driver driver = new Driver(driverName);
PickUpTruck put = new PickUpTruck(pickUpTruckName);
Vehicle vehicle = new Vehicle(licensePlate, brand, vehicleId);
pua = new PickUpAgreement(pickUpId, driver, put, city, postalCode, vehicle, price, address, pickUpDate, pickUpTime);
}
catch (SqlException e)
{
Console.WriteLine("Ups" + e.Message);
}
}
return(pua);
}
void Start()
{
truck = FindObjectOfType <PickUpTruck>();
grabberPos.transform.localPosition = new Vector2(0, grabberOffsetY * -1);
animator = GetComponent <Animator>();
animator.runtimeAnimatorController = controller;
objectToPickUp = null;
pickUpTrigger = GetComponentInChildren <PlayerPickUpTrigger>();
movement = transform.position;
canPickUp = pickUpTrigger.CanPickUpObj;
rb = GetComponent <Rigidbody2D>();
// Set default state
state = PlayerState.NOT_HOLDING_ITEM;
}
public void TestInitialize()
{
dbcT = new DBConnectorTest();
bcT = new BookingController();
puacT = new PickUpAgreementController();
brT = new BookingRepo();
pudrT = new PickUpAgreementRepo();
prT = new PackageRepo();
p1 = new Package("Premium Pakke", "Polering og bilrude", 250.43);
p2 = new Package("Luksus Pakke", "Polering og bilrude", 25000);
p3 = new Package("Basis Pakke", "Polering og bilrude", 4444);
packages1 = new List <Package>();
packages2 = new List <Package>();
packages1.Add(p1);
packages1.Add(p2);
packages1.Add(p3);
packages2.Add(p1);
packages2.Add(p2);
stringPackagesT = new List <string>();
d1 = new Driver("Mathias");
d2 = new Driver("Muslim");
d3 = new Driver("Adam");
v1 = new Vehicle("12ty432", "BMW", 1);
c1 = new Customer("Frank", "*****@*****.**", "004523438452", 1, "");
c2 = new Customer("Daniel", "*****@*****.**", "004522639513", v1, 2, "");
c3 = new Customer("muslim", "*****@*****.**", "004523674598", 3, "");
put1 = new PickUpTruck("Autotransporter 1");
b1 = new Booking(c1, "12.30", new DateTime(2019, 9, 24, 10, 00, 00), packages1, 1);
b2 = new Booking(c1, "12.30", new DateTime(2019, 9, 24, 10, 00, 00), packages1, 2);
b3 = new Booking(c2, "12.30", new DateTime(2019, 9, 24, 10, 00, 00), packages2, 3);
b4 = new Booking(c3, "12.30", new DateTime(2019, 9, 24, 10, 00, 00), packages2, 4);
bookingsT = new List <Booking>();
bookingStringsT = new List <List <string> >();
pickUpAgreementsT = new List <PickUpAgreement>();
puaT = new PickUpAgreement(1, d1, put1, "Odense C", 5000, v1, 500, "Rødegårdsvej 273", new DateTime(2019, 9, 24, 10, 00, 00), "15.30");
}
