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