private void btnSave_Click(object sender, EventArgs e)
{
var username = txtUsername.Text;
var roleId = (int)cboRole.SelectedValue;
var password = Utils.DefaultPassword();
try
{
var user = new User
{
Username = username,
Password = password,
IsActive = true
};
db.Users.Add(user);
db.SaveChanges();
var userId = user.UserId;
var userRole = new UserRole
{
RoleId = roleId,
UserId = userId
};
db.UserRoles.Add(userRole);
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show($"Error: { ex.Message}");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (isEditMode)
{
// code for edit record.
var id = int.Parse(lblId.Text);
var car = db.CarTypes.FirstOrDefault(x => x.CarTypeId == id);
car.Model = txtModel.Text;
car.Name = txtName.Text;
car.VIN = txtVin.Text;
car.Year = (txtYear.Text);
car.LicensePlateNumber = txtNumberPlate.Text;
db.SaveChanges();
MessageBox.Show("Current record successfully updated.");
}
else
{
// code insert new record.
var newCar = new CarType();
newCar.Model = txtModel.Text;
newCar.Name = txtName.Text;
newCar.VIN = txtVin.Text;
newCar.Year = txtYear.Text;
newCar.LicensePlateNumber = txtNumberPlate.Text;
db.CarTypes.Add(newCar);
db.SaveChanges();
MessageBox.Show("New record successfully added.");
}
}
private void btnDeleteRecord_Click(object sender, EventArgs e)
{
try
{
var id = (int)dgvUserRecord.SelectedRows[0].Cells["id"].Value;
var user = db.Users.FirstOrDefault(x => x.UserId == id);
user.IsActive = false;
db.SaveChanges();
MessageBox.Show("User deleted successfully.");
}
catch (Exception ex)
{
MessageBox.Show("user has been deactivated!");
}
}
private void btnDeleteCar_Click(object sender, EventArgs e)
{
var id = (int)dgvVehicleListing.SelectedRows[0].Cells["CarTypeId"].Value;
var car = db.CarTypes.FirstOrDefault(x => x.CarTypeId == id);
db.CarTypes.Remove(car);
db.SaveChanges();
dgvVehicleListing.Refresh();
}
private void btnDeleteRecord_Click(object sender, EventArgs e)
{
try
{
var id = (int)dgvRentalRecord.SelectedRows[0].Cells["RentalId"].Value;
var record = db.CarRentalRecords.FirstOrDefault(x => x.RentalId == id);
db.CarRentalRecords.Remove(record);
db.SaveChanges();
PopulateGrid();
}
catch (Exception ex)
{
MessageBox.Show($"Error: {ex.Message}");
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
string name = txtName.Text;
DateTime dateOut = dpDateRented.Value;
DateTime dateIn = dpDateReturned.Value;
double cost = Convert.ToDouble(txtCost.Text);
var carType = cboCarType.Text;
//bool isValid = true;
string errorMessage = string.Empty;
isValid = true;
if (isValid)
{
var rentalRecord = new CarRentalRecord();
if (isEditMode)
{
var id = int.Parse(lblId.Text);
rentalRecord = db.CarRentalRecords.FirstOrDefault(q => q.RentalId == id);
}
rentalRecord.Name = name;
rentalRecord.RentalDate = dateOut;
rentalRecord.ReturnDate = dateIn;
rentalRecord.Cost = (decimal)cost;
rentalRecord.TypeOfCarId = (int)cboCarType.SelectedValue;
if (!isEditMode)
{
db.CarRentalRecords.Add(rentalRecord);
}
db.SaveChanges();
MessageBox.Show("Record updated successfully.");
Close();
}
else
{
MessageBox.Show(errorMessage);
}
try
{
//if (string.IsNullOrWhiteSpace(name) || string.IsNullOrWhiteSpace(carType))
//{
// isValid = false;
// errorMessage += "Error: Please enter the missing data. \n\n";
//}
//if (dateOut > dateIn)
//{
// isValid = false;
// errorMessage += "Illegal Date Selection.\n\n";
//}
//if (isValid == true)
//{
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
