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