private void LoadFuelCostValues(FuelCost fuelCost)
{
LblId.Text = fuelCost.Id.ToString();
LblDateIssued.Text = fuelCost.DateIssued.ToShortDateString();
LblTimeIssued.Text = fuelCost.TimeIssued.ToString();
LblPosition.Text = fuelCost.Position;
LblAmount.Text = fuelCost.Amount.ToString();
LblPrice.Text = fuelCost.Price.ToString();
}
public override string ToString()
{
return("Destination: " + Destination +
"\nTotal Miles: " + DistanceTravelled +
"\nFuel Consumed: " + GallonsConsumed.ToString("f1") + " gallons" +
"\nCost: " + FuelCost.ToString("c") +
"\nMPG: " + MilesPerGallon().ToString("f0") +
"\nCost Per Mile: " + CostPerMile().ToString("c"));
}
public FuelCostPanel(FuelCost fuelCost)
{
InitializeComponent();
fuelCostsSqlRepository = new FuelCostsSqlRepository();
this.fuelCost = fuelCost;
SetFuelCostValues();
}
private void LoadDataToWindow(TravelWarrant travelWarrant)
{
// Travel Warrant
LblIdTravelWarrant.Text = travelWarrant.Id.ToString();
LblStatus.Text = travelWarrant.WarrantStatus;
LblDateTravelWarrant.Text = travelWarrant.DateIssued.ToShortDateString();
LblTimeTravelWarrant.Text = travelWarrant.TimeIssued.ToString();
// Driver
Driver driver = driversSqlRepository.ReadById(travelWarrant.DriverId);
LblIdDriver.Text = driver.Id.ToString();
LblFirstName.Text = driver.FirstName;
LblLastName.Text = driver.LastName;
LblPhoneNumber.Text = driver.PhoneNumber;
LblDriversLicenceNumber.Text = driver.DriversLicenceNumber;
// Vehicle
Vehicle vehicle = vehiclesSqlRepository.ReadById(travelWarrant.VehicleId);
LblIdVehicle.Text = vehicle.Id.ToString();
LblMake.Text = vehicle.Make;
LblModel.Text = vehicle.Model;
LblYearOfManufacture.Text = vehicle.YearOfManufacture.ToString();
LblInitialMileage.Text = vehicle.InitialMileage.ToString();
LblAvailability.Text = vehicle.Available == true ? "Available" : "Not available";
// Fuel Cost
FuelCost fuelCost = fuelCostsSqlRepository.ReadById(travelWarrant.FuelCostId);
LblIdFuelCost.Text = fuelCost.Id.ToString();
LblDateIssuedFc.Text = fuelCost.DateIssued.ToShortDateString();
LblTimeIssuedFc.Text = fuelCost.TimeIssued.ToString();
LblPosition.Text = fuelCost.Position;
LblAmount.Text = fuelCost.Amount.ToString();
LblPrice.Text = fuelCost.Price.ToString();
// Travel Route
TravelRoute travelRoute = travelRoutesSqlRepository.ReadById(travelWarrant.TravelRouteId);
LblIdTravelRoute.Text = travelRoute.Id.ToString();
LblDateIssuedTr.Text = travelRoute.DateIssued.ToShortDateString();
LblTimeIssuedTr.Text = travelRoute.TimeIssued.ToString();
LblOrigin.Text = travelRoute.Origin;
LblDestination.Text = travelRoute.Destination;
LblKilometersTraveled.Text = travelRoute.KilometersTraveled.ToString();
LblAverageSpeed.Text = travelRoute.AverageSpeed.ToString();
LblSpentFuel.Text = travelRoute.SpentFuel.ToString();
}
private void CreateFuelCost()
{
if (TbDate.Text != string.Empty && TbTime.Text != string.Empty && TbPosition.Text != string.Empty && TbAmount.Text != string.Empty && TbPrice.Text != string.Empty)
{
if (DateTime.TryParse(TbDate.Text, out DateTime date) && TimeSpan.TryParse(TbTime.Text, out TimeSpan time) && float.TryParse(TbAmount.Text, out float amount) && decimal.TryParse(TbPrice.Text, out decimal price))
{
if ((Regex.IsMatch(TbDate.Text, @"\d\d/\d\d/\d\d\d\d") || Regex.IsMatch(TbDate.Text, @"\d/\d\d/\d\d\d\d")) && Regex.IsMatch(TbTime.Text, @"\d\d:\d\d:\d\d"))
{
FuelCost createdFuelCost = new FuelCost()
{
DateIssued = date,
TimeIssued = time,
Position = TbPosition.Text,
Amount = amount,
Price = price
};
bool success = fuelCostsSqlRepository.Create(createdFuelCost);
if (success)
{
MessageBox.Show("Success");
Close();
}
else
{
MessageBox.Show("Fail");
}
}
else
{
MessageBox.Show("Date format must be: \"MM/dd/yyyy\"\nTime format must be: \"HH:MM:ss\"");
}
}
else
{
MessageBox.Show("Amount and price must be numbers\nDate format must be: \"MM/dd/yyyy\"\nTime format must be: \"HH:MM:ss\"");
}
}
else
{
MessageBox.Show("All input fields are required");
}
}
private void ReadFuelCosts(string filePath)
{
XmlReader xmlReader = XmlReader.Create(filePath);
xmlReader.ReadToFollowing("FuelCost");
do
{
xmlReader.MoveToFirstAttribute();
int id = int.Parse(xmlReader.Value);
xmlReader.ReadToFollowing("DateIssued");
DateTime dateIssued = DateTime.Parse(xmlReader.ReadElementContentAsString());
xmlReader.ReadToFollowing("TimeIssued");
TimeSpan timeIssued = TimeSpan.Parse(xmlReader.ReadElementContentAsString());
xmlReader.ReadToFollowing("Position");
string position = xmlReader.ReadElementContentAsString();
xmlReader.ReadToFollowing("Amount");
float amount = xmlReader.ReadElementContentAsFloat();
xmlReader.ReadToFollowing("Price");
decimal price = xmlReader.ReadElementContentAsDecimal();
FuelCost fuelCost = new FuelCost()
{
Id = id,
DateIssued = dateIssued,
TimeIssued = timeIssued,
Position = position,
Amount = amount,
Price = price
};
fuelCostsSqlRepository.Restore(fuelCost);
} while (xmlReader.ReadToFollowing("FuelCost"));
xmlReader.Close();
}
public ShowFuelCostWindow(FuelCost fuelCost)
{
InitializeComponent();
LoadFuelCostValues(fuelCost);
}
