private void PopulateFields(CarRentalRecord recordToEdit)
{
tbCustomerName.Text = recordToEdit.CustomerName;
dtRented.Value = (DateTime)recordToEdit.DateRented;
dtReturned.Value = (DateTime)recordToEdit.DateReturned;
tbCost.Text = recordToEdit.Cost.ToString();
lblRecordId.Text = recordToEdit.id.ToString();
}
public AddEditRentalRecord(CarRentalRecord recordToEdit)
{
InitializeComponent();
lblTitle.Text = "Edit Rental Record";
this.Text = "Edit Rental Record";
if (recordToEdit == null)
{
MessageBox.Show("Please ensure that you selected a valid record to edit");
Close();
}
else
{
isEditMode = true;
_db = new CarRentalEntities3();
PopulateFields(recordToEdit);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
//MessageBox.Show($"Thanks you Renting: {tbCustomerName.Text}");
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 errMessage = "";
if (string.IsNullOrWhiteSpace(customerName) || string.IsNullOrWhiteSpace(carType))
{
isValid = false;
errMessage += "Error: Please enter missing data!!!!\n\r";
}
if (dateOut > dateIn)
{
isValid = false;
errMessage += "Error: Illegal date seletion!!!!\n\r";
}
//(isValid = true)
if (isValid)
{
/*if (isEditMode)
* {
* var id = int.Parse(lblRecordId.Text);
* var rentalRecord = _db.CarRentalRecords.FirstOrDefault(q => q.id == id);
* rentalRecord.CustomerName = customerName;
* rentalRecord.DateRented = dateOut;
* rentalRecord.DateReturned = dateIn;
* rentalRecord.Cost = (decimal)cost;
* rentalRecord.TypeOfCarid = (int)cbTypeOfCar.SelectedValue;
*
* _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" +
* "Thanks you for your business.");
* }
* else
* {
* var rentalRecord = new CarRentalRecord();
* rentalRecord.CustomerName = customerName;
* rentalRecord.DateRented = dateOut;
* rentalRecord.DateReturned = dateIn;
* rentalRecord.Cost = (decimal)cost;
* rentalRecord.TypeOfCarid = (int)cbTypeOfCar.SelectedValue;
*
* _db.CarRentalRecords.Add(rentalRecord);
* _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" +
* "Thanks you for your business.");
* }*/
//Declare an object if the record to be added
var rentalRecord = new CarRentalRecord();
if (isEditMode)
{
//If in edit mode, then get the ID and retrive 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 record object with values 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 the record object to the database
if (!isEditMode)
{
_db.CarRentalRecords.Add(rentalRecord);
}
//save change mode 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" +
"Thanks you for your business.");
Close();
}
else
{
MessageBox.Show(errMessage);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
//throw;
}
}
