private void BtnUserDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure to delete this record?", "Car delete operation", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (FuelCalcEntities db = new FuelCalcEntities()) {
var entry = db.Entry(userDBModel);
if (entry.State == System.Data.Entity.EntityState.Detached)
{
db.User.Attach(userDBModel);
}
db.User.Remove(userDBModel);
db.SaveChanges();
PopulateGridViewUser();
ClearFrm();
MessageBox.Show("Deleted successfully!");
}
}
}
private void BtnRefuellingSave_Click(object sender, EventArgs e)
{
refuelDBModel.Amount = Convert.ToDouble(txtAmount.Text.Trim());
refuelDBModel.Cost = Convert.ToDouble(txtCost.Text.Trim());
refuelDBModel.Mileage = Convert.ToDouble(txtMileage.Text.Trim());
refuelDBModel.fk_CarId = Convert.ToInt32(cbCar.SelectedValue.ToString());
refuelDBModel.fk_UserId = Convert.ToInt32(cbUser.SelectedValue.ToString());
refuelDBModel.DateRefuel = dateTimeRefuel.Value;
using (FuelCalcEntities db = new FuelCalcEntities()) {
if (refuelDBModel.RefuelingId == 0)
{
db.Refuelling.Add(refuelDBModel);
}
else
{
db.Entry(refuelDBModel).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
}
}
private void BtnCarSave_Click(object sender, EventArgs e)
{
carDBModel.CarMake = txtCarMake.Text.Trim();
carDBModel.CarModel = txtCarModel.Text.Trim();
carDBModel.CarRegNr = txtCarRegNr.Text.ToUpper().Replace(" ", "").Trim();
using (FuelCalcEntities db = new FuelCalcEntities()) {
if (carDBModel.CarId == 0) //table empty, adding row
{
db.Car.Add(carDBModel);
}
else //update row
{
db.Entry(carDBModel).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
}
ClearFrm();
PopulateGridViewCar();
MessageBox.Show("Submitted successfully!");
}
private void BtnUserSave_Click(object sender, EventArgs e)
{
userDBModel.FirstName = txtFirstName.Text.Trim();
userDBModel.LastName = txtLastName.Text.Trim();
userDBModel.Email = txtEmail.Text.Trim();
using (FuelCalcEntities db = new FuelCalcEntities())
{
if (userDBModel.UserId == 0)
{
db.User.Add(userDBModel);
}
else
{
db.Entry(userDBModel).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
}
ClearFrm();
PopulateGridViewUser();
MessageBox.Show("Submitted successfully!");
}
private void BtnSaveTravel_Click(object sender, EventArgs e)
{
travelDBModel.fk_CarId = Convert.ToInt32(cbCarTravel.SelectedValue.ToString());
travelDBModel.fk_UserId = Convert.ToInt32(cbUserTravel.SelectedValue.ToString());
travelDBModel.TravelStart = txtTravelStart.Text.Trim();
travelDBModel.TravelTarget = txtTravelTarget.Text.Trim();
travelDBModel.TravelPurpose = txtTravelPurpose.Text.Trim();
travelDBModel.TravelStartMileage = Convert.ToDouble(txtTravelStartMileage.Text.Trim());
travelDBModel.TravelTargetMileage = Convert.ToDouble(txtTravelTargetMileage.Text.Trim());
travelDBModel.DateTravel = dateTimePickerTravel.Value;
if (travelDBModel.TravelTargetMileage > travelDBModel.TravelStartMileage)
{
using (FuelCalcEntities db = new FuelCalcEntities())
{
if (travelDBModel.TravelId == 0)
{
db.Travel.Add(travelDBModel);
}
else
{
db.Entry(travelDBModel).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
}
txtTravelTargetMileage.BackColor = Color.Red;
ClearFrm();
MessageBox.Show("Submitted successfully!");
}
else
{
MessageBox.Show("Final mileage less than the initial one!");
txtTravelTargetMileage.BackColor = Color.Red;
txtTravelTargetMileage.Text = "";
}
}
