public List <Refuelling> GetAllByMonth(int month) { using (FuelCalcEntities fce = new FuelCalcEntities()) { var _refuels = fce.Refuelling; var result = _refuels.Include(c => c.Car).Where(u => u.DateRefuel.Month == month).ToList(); return(result); } }
public List <Travel> GetAllByMonth(int month) { using (FuelCalcEntities fce = new FuelCalcEntities()) { var _travels = fce.Travel; var result = _travels.Include(us => us.User).Where(u => u.DateTravel.Month == month).ToList(); return(result); } }
//section for adding refuelling private void FillDropdownUserList() { using (FuelCalcEntities db = new FuelCalcEntities()) { cbUser.DataSource = db.User.ToList <User>(); cbUser.DisplayMember = "LastName"; cbUser.ValueMember = "UserId"; cbUserTravel.DataSource = db.User.ToList <User>(); cbUserTravel.DisplayMember = "LastName"; cbUserTravel.ValueMember = "UserId"; } }
private void DataGridViewUser_DoubleClick(object sender, EventArgs e) { if (dataGridViewUser.CurrentCell.RowIndex != -1) { userDBModel.UserId = Convert.ToInt32(dataGridViewUser.CurrentRow.Cells["UserId"].Value); using (FuelCalcEntities db = new FuelCalcEntities()) { userDBModel = db.User.Where(x => x.UserId == userDBModel.UserId).FirstOrDefault(); txtFirstName.Text = userDBModel.FirstName; txtLastName.Text = userDBModel.LastName; txtEmail.Text = userDBModel.Email; } btnUserDelete.Enabled = true; btnUserSave.Text = "Update"; } }
private void DataGridViewCar_DoubleClick(object sender, EventArgs e) { if (dataGridViewCar.CurrentCell.RowIndex != -1) { carDBModel.CarId = Convert.ToInt32(dataGridViewCar.CurrentRow.Cells["CarId"].Value); using (FuelCalcEntities db = new FuelCalcEntities()) { carDBModel = db.Car.Where(x => x.CarId == carDBModel.CarId).FirstOrDefault(); txtCarMake.Text = carDBModel.CarMake; txtCarModel.Text = carDBModel.CarModel; txtCarRegNr.Text = carDBModel.CarRegNr; } btnCarDelete.Enabled = true; btnCarSave.Text = "Update"; } }
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 FillDropdownCarList() { using (FuelCalcEntities db = new FuelCalcEntities()) { List <Car> cars = db.Car.ToList <Car>(); var cbDict = new Dictionary <int, string>(); foreach (var car in cars) { cbDict.Add(car.CarId, car.CarMake.ToString() + " " + car.CarModel.ToString() + " " + car.CarRegNr.ToString()); } cbCar.DataSource = new BindingSource(cbDict, null); cbCar.DisplayMember = "Value"; cbCar.ValueMember = "Key"; cbCarTravel.DataSource = new BindingSource(cbDict, null); cbCarTravel.DisplayMember = "Value"; cbCarTravel.ValueMember = "Key"; } }
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 FillDropdownMonthList() { using (FuelCalcEntities db = new FuelCalcEntities()) { var cbMonthDict = new Dictionary <int, string>(); cbMonthDict.Add(1, "Jan"); cbMonthDict.Add(2, "Feb"); cbMonthDict.Add(3, "Mar"); cbMonthDict.Add(4, "Apr"); cbMonthDict.Add(5, "May"); cbMonthDict.Add(6, "Jun"); cbMonthDict.Add(7, "Jul"); cbMonthDict.Add(8, "Aug"); cbMonthDict.Add(9, "Sep"); cbMonthDict.Add(10, "Oct"); cbMonthDict.Add(11, "Nov"); cbMonthDict.Add(12, "Dec"); cbMonthReport.DataSource = new BindingSource(cbMonthDict, null); cbMonthReport.DisplayMember = "Value"; cbMonthReport.ValueMember = "Key"; } }
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 = ""; } }
void PopulateGridViewCar() { using (FuelCalcEntities db = new FuelCalcEntities()) { dataGridViewCar.DataSource = db.Car.ToList <Car>(); } }