public void ReturnVehicle(IVehicle vehicle) { Returned = DateTime.Now.AddDays(3); var days = RentDate.Duration(Returned); MilesReturned = vehicle.Odometer; Cost = days * vehicle.CostPerDay + (MilesReturned - MilesRented) * vehicle.CostKM; }
/// <summary> /// Tworzy nowy obiekt w bazie danych /// </summary> /// <param name="book">Książka do wyporzyczenia</param> /// <param name="student">Student który wyporzycza</param> /// <param name="rentDate">Data wyporzyczenia</param> /// <returns></returns> public void Create(uint bookId, uint studentId, DateTime rentDate) { if (Database.GetInstance() == null) { Database.Connect(); } StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO Rents (startDate, endDate, bookId, studentId) "); sb.Append("VALUES(@startDate, @endDate, @bookId, @studentId)"); using (SqlCommand command = new SqlCommand(sb.ToString(), Database.GetInstance())) { command.Parameters.Add("@startDate", SqlDbType.Date); command.Parameters.Add("@endDate", SqlDbType.Date); command.Parameters.Add("@bookId", SqlDbType.BigInt); command.Parameters.Add("@studentId", SqlDbType.BigInt); command.Parameters["@startDate"].Value = rentDate.Date; command.Parameters["@endDate"].Value = RentDate.AddDays(60).Date; command.Parameters["@bookId"].Value = bookId; command.Parameters["@studentId"].Value = studentId; try { command.ExecuteNonQuery(); } catch (SqlException e) { throw e; } catch (InvalidOperationException e) { throw e; } } }
public override string ToString() { return("[ ID = " + RentID + ". RentDate = " + RentDate.ToShortDateString() + ". DateGet = " + DateGet.ToShortDateString() + ". CarID = " + Car.CarID + ". ClientId = " + Client.Id + ". RentPrice = " + RentPrice + ". Paid = " + Paid.ToString() + ". WorkerFIO = " + WorkerFIO + ". ]"); }