public static ICollection <FuelInfo> ReadFuelInfo(string filePath)
{
var result = new List <FuelInfo>();
var con = new OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0; Data Source = " + filePath + "; Extended Properties = \"Excel 12.0 Xml; HDR = YES; IMEX = 2\"");
con.Open();
using (con)
{
var dtExcelSchema = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
var sheetName = dtExcelSchema.Rows[0]["TABLE_NAME"];
var command = new OleDbCommand("SELECT * FROM " + "[" + sheetName + "]", con);
var reader = command.ExecuteReader();
while (reader.Read())
{
if (reader[0] == DBNull.Value)
{
return(result);
}
var info = new FuelInfo();
info.FuelId = Convert.ToInt32(reader[0]);
info.VehicleId = Convert.ToInt32(reader[1]);
info.Price = Convert.ToDecimal(reader[2]);
info.Spent = Convert.ToDecimal(reader[3]);
info.Total = Convert.ToDecimal(reader[4]);
result.Add(info);
}
}
return(result);
}
public FuelStatusSnapshot(SimulatorDataSet dataSet)
{
FuelInfo fuelInfo = dataSet.PlayerInfo.CarInfo.FuelSystemInfo;
FuelLevel = fuelInfo.FuelRemaining;
SessionTime = dataSet.SessionInfo.SessionTime;
TotalDistance = dataSet.PlayerInfo.TotalDistance;
}
protected override void Init(MyObjectBuilder_DefinitionBase builder)
{
MyObjectBuilder_GasFueledPowerProducerDefinition definition = (MyObjectBuilder_GasFueledPowerProducerDefinition)builder;
base.Init(builder);
this.FuelCapacity = definition.FuelCapacity;
this.Fuel = new FuelInfo(definition.FuelInfos[0]);
this.ResourceSinkGroup = MyStringHash.GetOrCompute(definition.ResourceSinkGroup);
}
private void getFuelInfo(string optionName)
{
FuelInfo fuelType = new FuelInfo(getFuelNode(optionName));
if (fuelType != null)
{
// Multiply volume by this to get the wet mass:
wetDensity = fuelType.wetDensity;
}
}
private void cmbFuels_SelectedIndexChanged(object sender, EventArgs e)
{
FuelInfo select = cmbFuels.SelectedItem as FuelInfo;
if (select != null)
{
tbFuelPrice.Text = select.Price.ToString("N2");
tbSumOfLitres_TextChanged(tbSumOfLitres, EventArgs.Empty);
}
}
public static void ImportExcellData(string filePath)
{
var reports = ExcellReportReader.ReadFromFile(filePath);
foreach (var fuelInfo in reports)
{
var fuelInfoModel = new FuelInfo
{
Price = fuelInfo.Price,
VehicleId = fuelInfo.VehicleId,
Spent = fuelInfo.Spent,
Total = fuelInfo.Total,
FuelId = fuelInfo.FuelId
};
data.FuelInfo.Add(fuelInfoModel);
}
data.FuelInfo.SaveChanges();
}
