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 = ""; } }