private void bthDeleteCar_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 want to delete this RECORD?",
"Delete", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
//delete vehincle fro, tbl
_db.TypesOfCars.Remove(car);
_db.SaveChanges();
}
PopulateGrid(); //List ko refresh pyan lote tak code tay yay htr tak method.
}
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 userRole = new UserRole
{
roleid = roleId,
userid = userId
};
_db.UserRoles.Add(userRole);
_db.SaveChanges();
MessageBox.Show("Add user successful.");
_manageUser.PopulateGrid();
Close();
}
catch (Exception)
{
MessageBox.Show("An error occured!");
}
}
private void btnResetPassword_Click(object sender, EventArgs e)
{
try
{
//get id of selected row
var id = (int)gvUserList.SelectedRows[0].Cells["id"].Value;
//query database for record
var user = _db.Users.FirstOrDefault(q => q.id == id);
//var genericPassword = "******";
//var hashed_password = Utils.HashPassword(genericPassword);
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 bthDeleteRecord_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.CarRentalRecords.FirstOrDefault(q => q.id == id);
//delete vehincle fro, tbl
_db.CarRentalRecords.Remove(record);
_db.SaveChanges();
PopulateGrid();
}
catch (Exception ex)
{
MessageBox.Show($"Error : {ex.Message}");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
var password = tbPassword.Text;
var confirmPassword = tbConfirmPassword.Text;
var uesr = _db.Users.FirstOrDefault(q => q.id == _user.id);
if (password != confirmPassword)
{
MessageBox.Show("Password not match! Please try again!");
}
uesr.password = Utils.HashPassword(password);
_db.SaveChanges();
MessageBox.Show("Password was reset successful.");
Close();
}
catch (Exception)
{
MessageBox.Show("Error has occured! Please try again?");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
var errorMsg = "";
var successMsg = "Operation complete.Refresh Grid to see changes.";
var make = tbMake.Text;
var model = tbModle.Text;
var vin = tbVin.Text;
var year = int.Parse(tbYear.Text);
var licensePlateNum = tbLicenseNum.Text;
if (string.IsNullOrWhiteSpace(make) || string.IsNullOrWhiteSpace(model))
{
errorMsg += "Please ensure that you provide a make and a mode.";
MessageBox.Show(errorMsg);
}
else
{
//if(isEditMode == true)
if (isEditMode)
{
//Edit code
var id = int.Parse(lblId.Text);
var car = _db.TypesOfCars.FirstOrDefault(q => q.Id == id);
car.Make = tbMake.Text;
car.Model = tbModle.Text;
car.VIN = tbVin.Text;
car.Year = int.Parse(tbYear.Text);
car.LicensePlateNumber = tbLicenseNum.Text;
/*_db.SaveChanges();
* mode = "Update";
* MessageBox.Show($"{mode} {successMsg}");
* Close();*/
}
else
{
//Add code
var newCar = new TypesOfCar
{
LicensePlateNumber = tbLicenseNum.Text,
Make = tbMake.Text,
Model = tbModle.Text,
VIN = tbVin.Text,
Year = int.Parse(tbYear.Text)
};
_db.TypesOfCars.Add(newCar);
}
_db.SaveChanges();
_manageVehicleListing.PopulateGrid();
MessageBox.Show($"{successMsg}");
Close();
}
}
catch (Exception ex)
{
MessageBox.Show($"Error : {ex.Message}");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
String customerName = tbCustomerName.Text;
var dateRent = dtpRent.Value;
var dateReturn = dtpReturn.Value;
double cost = Convert.ToDouble(tbCost.Text);
var carType = cbTypeOfCar.Text;
var isValid = true;
var errorMsg = "";
if (string.IsNullOrWhiteSpace(customerName) || string.IsNullOrWhiteSpace(carType))
{
isValid = false;
errorMsg += "Error : Please enter missing data!\n\r";
}
if (dateRent > dateReturn)
{
isValid = false;
errorMsg += "Error : Wrong date!\n\r";
}
// if (isValid == true) ------ same is below
/*if (isValid)
* {
* if (isEditMode)
* {
* var id = int.Parse(lblRecordId.Text);
* var rentalRecord = _db.CarRentalRecords.FirstOrDefault(q => q.id == id);
* rentalRecord.CustomerName = customerName;
* rentalRecord.DateRented = dateRent;
* rentalRecord.DateReturned = dateReturn;
* rentalRecord.Cost = (decimal)cost; // Decimal.Parse ko use los ma ya; bcs of .Parse ka string ko pl use los ya tr
* rentalRecord.TypeOfCarId = (int)cbTypeOfCar.SelectedValue;
*
* _db.SaveChanges();
*
* MessageBox.Show($"CustomerName : {customerName}\n\r" +
* $"Rented Date : {dateRent}\n\r" +
* $"Returned Date : {dateReturn}\n\r" +
* $"Cost : {cost}\n\r" +
* $"Car Type : {carType}\n\r" +
* $"Thanks you !"
* }
* else
* {
* var rentalRecord = new CarRentalRecord();
* rentalRecord.CustomerName = customerName;
* rentalRecord.DateRented = dateRent;
* rentalRecord.DateReturned = dateReturn;
* rentalRecord.Cost = (decimal)cost; // Decimal.Parse ko use los ma ya; bcs of .Parse ka string ko pl use los ya tr
* rentalRecord.TypeOfCarId = (int)cbTypeOfCar.SelectedValue;
* _db.CarRentalRecords.Add(rentalRecord);
* _db.SaveChanges();
*
* MessageBox.Show($"CustomerName : {customerName}\n\r" +
* $"Rented Date : {dateRent}\n\r" +
* $"Returned Date : {dateReturn}\n\r" +
* $"Cost : {cost}\n\r" +
* $"Car Type : {carType}\n\r" +
* $"Thanks you !"
* );
* }
* Close();
* }*/
if (isValid)
{
//Declare an object of the record to be added
var rentalRecord = new CarRentalRecord();
if (isEditMode)
{
//If in edit mode,then get ID and retrieve the record from the database and place
//The result in the record object
var id = int.Parse(lblRecordId.Text);
rentalRecord = _db.CarRentalRecords.FirstOrDefault(q => q.id == id);
}
//populate the record objects with values from the form
rentalRecord.CustomerName = customerName;
rentalRecord.DateRented = dateRent;
rentalRecord.DateReturned = dateReturn;
rentalRecord.Cost = (decimal)cost; // Decimal.Parse ko use los ma ya; bcs of .Parse ka string ko pl use los ya tr
rentalRecord.TypeOfCarId = (int)cbTypeOfCar.SelectedValue;
//if not editMode, add the record to the DB
if (!isEditMode)
{
_db.CarRentalRecords.Add(rentalRecord);
}
//save changes made to the entity
_db.SaveChanges();
MessageBox.Show($"CustomerName : {customerName}\n\r" +
$"Rented Date : {dateRent}\n\r" +
$"Returned Date : {dateReturn}\n\r" +
$"Cost : {cost}\n\r" +
$"Car Type : {carType}\n\r" +
$"Thanks you !"
);
Close();
}
else
{
MessageBox.Show(errorMsg);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
//throw; // to end program
}
}
