public void Sp_UpdatePickUpAgreement(PickUpAgreement currentPickUpAgreement) { using (SqlConnection con = new SqlConnection(connectionString)) { try { con.Open(); SqlCommand cmd1 = new SqlCommand("Sp_UpdatePickUpAgreement", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add(new SqlParameter("@PickUpAgreementID", currentPickUpAgreement.PickUpAgreementId)); cmd1.Parameters.Add(new SqlParameter("@VehicleID", currentPickUpAgreement.Vehicle.VehicleId)); cmd1.Parameters.Add(new SqlParameter("@DriverName", currentPickUpAgreement.Driver.Name)); cmd1.Parameters.Add(new SqlParameter("@PickUpTruckName", currentPickUpAgreement.PickUpTruck.PickUpTruckName)); cmd1.Parameters.Add(new SqlParameter("@PostalCode", currentPickUpAgreement.PostalCode)); cmd1.Parameters.Add(new SqlParameter("@LicensePlate", currentPickUpAgreement.Vehicle.LicensePlate)); cmd1.Parameters.Add(new SqlParameter("@Brand", currentPickUpAgreement.Vehicle.Brand)); cmd1.Parameters.Add(new SqlParameter("@PickUpDate", currentPickUpAgreement.PickUpDate)); cmd1.Parameters.Add(new SqlParameter("@PickUpTime", currentPickUpAgreement.PickUpTime)); cmd1.Parameters.Add(new SqlParameter("@Price", currentPickUpAgreement.Price)); cmd1.Parameters.Add(new SqlParameter("StreetName", currentPickUpAgreement.Address)); cmd1.ExecuteNonQuery(); } catch (SqlException e) { Console.WriteLine("Ups" + e.Message); } } }
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 void CreatePickUpAgreement(string driverName, string pickUpTruckName, int postalCode, string address, string licensePlate, string brand, DateTime pickUpDate, string pickUpTime, double price) { PickUpAgreement pua = dbc.Sp_CreatePickUpAgreement(driverName, pickUpTruckName, postalCode, licensePlate, brand, price, address, pickUpDate, pickUpTime); try { puar.AddPickUpAgreementToList(pua); } catch (NullReferenceException e) { // MessageBox.Show(e.Message); throw; } }
public string UpdatePickUpAgreement(PickUpAgreement currentPickUpAgreement) { foreach (PickUpAgreement pickUpAgreement in pickUpAgreements) { if (currentPickUpAgreement.PickUpAgreementId == pickUpAgreement.PickUpAgreementId) { pickUpAgreements.Remove(pickUpAgreement); pickUpAgreements.Add(currentPickUpAgreement); NotifySubscribers(); return("Afhentnings aftale er ændret!"); } } return("En fejl er forekommet og afhentnings aftale er ikke ændret!"); }
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); }
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"); }
public void AddAllPickUpAgreementToList(PickUpAgreement pua) { pickUpAgreements.Add(pua); }
public void AddPickUpAgreementToList(PickUpAgreement pua) { pickUpAgreements.Add(pua); NotifySubscribers(); }
public void TestCreatePickUpDealId() { puaT = dbcT.Sp_CreatePickUpAgreement("Mathias", "Autotransporter 1", 5000, "43ty545", "BMW", 500, "Rødegårdsvej 273", new DateTime(2019, 9, 24, 10, 00, 00), "10:30"); Assert.IsTrue(puaT.PickUpAgreementId > 0); }