private void btnDeleteCar_Click(object sender, EventArgs e)
{
try
{
// get Id of selected row
var id = (int)gvVehicleList.SelectedRows[0].Cells["Id"].Value;
//query database for record
var car = _db.TypesOfCars.FirstOrDefault(q => q.id == id);
DialogResult dr = MessageBox.Show("Are You Sure You Want To Delete This Record?",
"Delete", MessageBoxButtons.YesNoCancel,
MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
//delete vehicle from table
_db.TypesOfCars.Remove(car);
_db.SaveChanges();
}
PopulateGrid();
}
catch (Exception ex)
{
MessageBox.Show($"Error: {ex.Message}");
}
}
private void btnResetPassword_Click(object sender, EventArgs e)
{
try
{
var password = tbPassword.Text;
var confirmPassword = tbConfirmPassword.Text;
var user = _db.Users.FirstOrDefault(q => q.id == _user.id);
if (password != confirmPassword)
{
MessageBox.Show("Password do not match. Please try again!");
}
user.password = Utils.HashPassword(password);
_db.SaveChanges();
MessageBox.Show("Password was resset successfully");
Close();
}
catch (Exception)
{
MessageBox.Show("An error has occured. Please try again.");
// throw;
}
}
private void btnResetPassword_Click(object sender, EventArgs e)
{
try
{
// get Id of selected row
var id = (int)gvUsersList.SelectedRows[0].Cells["Id"].Value;
//query database for user
var user = _db.Users.FirstOrDefault(q => q.id == id);
var hashed_password = Utils.DefaultHashPassword();
user.password = hashed_password;
_db.SaveChanges();
MessageBox.Show($"{user.username}'s password has been reset.");
PopulateGrid();
}
catch (Exception ex)
{
MessageBox.Show($"Error: {ex.Message}");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
//Added Validation for make and model
if (string.IsNullOrWhiteSpace(tbMake.Text) ||
string.IsNullOrWhiteSpace(tbModel.Text))
{
MessageBox.Show("Please ensure that you provide a make and a model");
}
else
{
//if(isEditMode == true)
if (isEditMode)
{
//Edit Code here
var id = int.Parse(labId.Text);
var car = _db.TypesOfCars.FirstOrDefault(q => q.id == id);
car.Model = tbModel.Text;
car.Make = tbMake.Text;
car.VIN = tbVIN.Text;
car.Year = int.Parse(tbYear.Text);
car.LicensePlateNumber = tbLicenseNum.Text;
}
else
{
//Added validation for make and model of cars being added
// Add Code Here
var newCar = new TypesOfCars
{
LicensePlateNumber = tbLicenseNum.Text,
Make = tbMake.Text,
Model = tbModel.Text,
VIN = tbVIN.Text,
Year = int.Parse(tbYear.Text)
};
_db.TypesOfCars.Add(newCar);
}
_db.SaveChanges();
_manageVehicleListing.PopulateGrid();
MessageBox.Show("Operation Completed. Refresh Grid To see Changes");
Close();
}
}
catch (Exception ex)
{
MessageBox.Show($"Error: {ex.Message}");
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
try
{
var username = tbUsername.Text;
var roleId = (int)cbRoles.SelectedValue;
var password = Utils.DefaultHashPassword();
var user = new User
{
username = username,
password = password,
isActive = true
};
_db.Users.Add(user);
_db.SaveChanges();
var userid = user.id;
var userRorle = new UserRole
{
roleid = roleId,
userid = userid
};
_db.UserRoles.Add(userRorle);
_db.SaveChanges();
MessageBox.Show("New user added successfully.");
_manageUsers.PopulateGrid();
Close();
}
catch (Exception)
{
MessageBox.Show("An error has occured.");
}
}
private void btnDeleteRecord_Click(object sender, EventArgs e)
{
try
{
// Get Id of selected row
var id = (int)gvRecordList.SelectedRows[0].Cells["id"].Value;
// Query database for record
var record = _db.CarRentalRecord.FirstOrDefault(q => q.id == id);
// delete vehicle from table
_db.CarRentalRecord.Remove(record);
_db.SaveChanges();
PopulateGrid();
}
catch (Exception ex)
{
MessageBox.Show($"Error: {ex.Message}");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string customerName = tbCustomerName.Text;
var dateOut = dtRented.Value;
var dateIn = dtReturned.Value;
double cost = Convert.ToDouble(tbCost.Text);
var carType = cbTypeOfCar.Text;
var isValid = true;
var errorMessage = "";
if (string.IsNullOrWhiteSpace(customerName) || string.IsNullOrWhiteSpace(carType))
{
isValid = false;
errorMessage += "Error: Please enter missing data.\n\r";
}
if (dateOut > dateIn)
{
isValid = false;
errorMessage += "Error: Illegal date selection.\n\r";
}
if (isValid)
{
// Declare an object of the record to be added
var rentalRecord = new CarRentalRecord();
if (isEditMode)
{
// If edit mode, then get ID and retrive the record from the database
// and platc the result in the record object
var id = int.Parse(labRecordId.Text);
rentalRecord = _db.CarRentalRecord.FirstOrDefault(q => q.id == id);
}
// Populate record object with valuse from the form
rentalRecord.CustomerName = customerName;
rentalRecord.DateRented = dateOut;
rentalRecord.DateReturned = dateIn;
rentalRecord.Cost = (decimal)cost;
rentalRecord.TypeOfCarId = (int)cbTypeOfCar.SelectedValue;
// If not in edit mode, then add record object to the database
if (!isEditMode)
{
_db.CarRentalRecord.Add(rentalRecord);
}
// Save changes made to the entity
_db.SaveChanges();
MessageBox.Show($"Customer Name: {customerName}\n\r" +
$"Date Rented: {dateOut}\n\r" +
$"Date Returned: {dateIn}\n\r" +
$"Cost: {cost}\n\r" +
$"Car Type: {carType}\n\r" +
$"THANK YOU FORU YOUR BUSINESS.");
Close();
}
else
{
MessageBox.Show(errorMessage);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
// throw;
}
}
