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