private bool addFuelRecord()
{
float cost, fill;
int miles;
var rs1 = float.TryParse(txtCost.Text, out cost);
var rs2 = float.TryParse(txtFill.Text, out fill);
var rs3 = int.TryParse(txtMiles.Text, out miles);
if (txtMiles.Text.Length > 0 && txtCost.Text.Length > 0 && txtFill.Text.Length > 0 && datePick.Value.ToString().Length > 0 &&
rs1 && rs2 && rs3)
{
fuelInfo finfo = new fuelInfo {
Cost = cost,
DateStr = datePick.Value.Value.ToShortDateString(),
Date = datePick.Value.Value,
Filled = fill,
Miles = miles,
CarID = int.Parse(carID)
};
App.ViewModel.Database.fuelInfo.InsertOnSubmit(finfo);
App.ViewModel.Database.SubmitChanges();
return(true);
}
else
{
MessageBox.Show("Incomplete or Incorrect data");
return(false);
}
}
private bool UpdateFuelRecord()
{
float cost, fill;
int miles;
var rs1 = float.TryParse(txtCost.Text, out cost);
var rs2 = float.TryParse(txtFill.Text, out fill);
var rs3 = int.TryParse(txtMiles.Text, out miles);
if (txtMiles.Text.Length > 0 && txtCost.Text.Length > 0 && txtFill.Text.Length > 0 && datePick.Value.ToString().Length > 0 &&
rs1 && rs2 && rs3)
{
var record = from fuelInfo info in App.ViewModel.Database.fuelInfo
where info.CarID == int.Parse(carID) && info.FuelID == int.Parse(fuelID)
orderby info.Date ascending
select info;
App.ViewModel.Database.fuelInfo.DeleteOnSubmit(record.FirstOrDefault());
fuelInfo finfo = new fuelInfo
{
Cost = cost,
DateStr = datePick.Value.Value.ToShortDateString(),
Date = datePick.Value.Value,
Filled = fill,
Miles = miles,
CarID = int.Parse(carID)
};
App.ViewModel.Database.fuelInfo.InsertOnSubmit(finfo);
App.ViewModel.Database.SubmitChanges();
return(true);
}
else
{
MessageBox.Show("Incorrect or Incomplete data");
return(false);
}
}
