private void LoadUserFuelChart()
{
FuelBLL fuelBll = new FuelBLL();
if (_userObj != null)
{
hcFrutas.Series.Clear();
List<Fuel> fuelList = fuelBll.GetUserFuels(_userObj.UserId);
if (fuelList != null)
{
//Defining Axis
ArrayList Dates = new ArrayList();
ArrayList Gallons = new ArrayList();
foreach (var userFuel in fuelList)
{
Dates.Add(userFuel.FillDate.ToString("MMM"));
Gallons.Add(userFuel.AvgMilesPerGallon);
}
//Title configuration
hcFrutas.Title = new Title("Miles Per Gallon");
hcFrutas.SubTitle = new SubTitle("Fuel Data");
//Defining Axis
hcFrutas.YAxis.Add(new YAxisItem { title = new Title("Gallons"), min = 0, max = 100, tickInterval=10, allowDecimals = true });
hcFrutas.XAxis.Add(new XAxisItem { title = new Highchart.Core.Title("Fill Date"), categories = new object[]{ "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"} });
//data
var series = new Collection<Serie>();
// series.Add(new Serie { name = DateTime.Now.ToShortDateString(), data = new object[] { 20 } });
//data
//var series = new Collection<Serie>();
foreach (var userFuel in fuelList)
{
ArrayList avgMilesPerGallon = new ArrayList();
for (int i = 1; i <= 12; i++)
{
if (i == userFuel.FillDate.Month)
{
avgMilesPerGallon.Add(userFuel.AvgMilesPerGallon);
}
else
{
avgMilesPerGallon.Add(0.0);
}
}
series.Add(new Serie { name = userFuel.FillDate.ToShortDateString(), data = avgMilesPerGallon.ToArray() });
}
//configuring Visual
hcFrutas.PlotOptions = new Highchart.Core.PlotOptions.PlotOptionsColumn { borderColor = "#dedede", borderRadius = 4 };
//bind
hcFrutas.DataSource = series;
hcFrutas.DataBind();
}
}
}
private void loadUserFuels()
{
FuelBLL fuelBll = new FuelBLL();
List<Fuel> fuelList = fuelBll.GetUserFuels(_userObj.UserId);
if (fuelList != null)
{
foreach (var fuel in fuelList)
{
_fuel.Add(fuel.FuelId, fuel.Odometer);
}
}
}
private void BindUserFuelDetails()
{
FuelBLL fuelBll = new FuelBLL();
if (_userObj != null)
{
List<Fuel> fuelList = fuelBll.GetUserFuels(_userObj.UserId);
bool isHideFirstRow = false;
if (fuelList != null)
{
gvDetails.DataSource = fuelList;
gvDetails.DataBind();
}
else
{
isHideFirstRow = true;
List<Fuel> fuels = new List<Fuel>();
fuels.Add(new Fuel());
gvDetails.DataSource = fuels;
gvDetails.DataBind();
gvDetails.ShowFooter = true;
}
if (isHideFirstRow)
{
//Hide the first row if it's empty
gvDetails.Rows[0].Visible = false;
}
}
}