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"); }