private void button1_Click(object sender, EventArgs e) { //w taki sposób mozemy pobrać dane z combobox połączonego z bazą danych var display = cmb_CarType.Text; var value = cmb_CarType.SelectedValue; //pobieranie danych z pól tekstowych i wprowadzenie ich do bazy danych //za pośrednictwem nowo stworzonego obiektu klasy CarRetnalRecord (automatyczna klasa stworzona na wzór tabeli w bazie danych) if (DataValidation()) { //stworzenie nowego obiektu na cele utworzenia nowego wpisu do bazy danych var newr = new CarRentalRecord(); newr.CustomerName = txt_CustomerName.Text; newr.DateRented = dtp_RentDate.Value; newr.DateReturned = dtp_ReturnDate.Value; newr.Cost = Decimal.Parse(txt_costs.Text); newr.CarId = Convert.ToInt32(cmb_CarType.SelectedValue); carRentalEntities.CarRentalRecords.Add(newr); carRentalEntities.SaveChanges(); OnAddedData(EventArgs.Empty); carRentalEntities.SaveChanges(); MessageBox.Show("Data updated successfully"); Close(); } else { MessageBox.Show("Your Data is invalid\nCheck your form for incorrect data.", "Data Validation System"); } }
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(); }
private void PopulateFields(CarRentalRecord recordToEdit) { txtUsername.Text = recordToEdit.customerName; dtRented.Value = (DateTime)recordToEdit.dateRented; dtReturned.Value = (DateTime)recordToEdit.dateReturned; txtCost.Text = recordToEdit.cost.ToString(); lblRecorId.Text = recordToEdit.id.ToString(); }
public AddRentalRecord(CarRentalRecord record) { InitializeComponent(); carRentalEntities = new CarRentalEntities(); bs = new BindingSource(); isEditMode = true; this.record = record; }
private void PopulateFileds(CarRentalRecord recordToEdit) { lblId.Text = recordToEdit.RentalId.ToString(); txtName.Text = recordToEdit.Name; dpDateRented.Value = (DateTime)recordToEdit.RentalDate; dpDateReturned.Value = (DateTime)recordToEdit.ReturnDate; txtCost.Text = recordToEdit.Cost.ToString(); //cboCarType.Text = recordToEdit.CarType.Name; }
private void PopulateFields(CarRentalRecord recordToEdit) { txtBox_CoustomerName.Text = recordToEdit.CustomerName; //cmBox_TypeOfCar.Text=recordToEdit.TypeOfCarID dateRented.Value = (DateTime)recordToEdit.DateRented; dateReturned.Value = (DateTime)recordToEdit.DateReturned; txtBox_Cost.Text = recordToEdit.Cost.ToString(); lblRecordId.Text = recordToEdit.id.ToString(); }
public AddEditRentalRecord(CarRentalRecord recordToEdit, ManageRentalRecords manageRentalRecords = null) { InitializeComponent(); lblTitle.Text = "Edit Rental Record"; PopulateFields(recordToEdit); _manageRentalRecords = manageRentalRecords; _db = new CarRentalEntities(); isEditMode = true; }
private void populateFields(CarRentalRecord recordToEdit) { //throw new NotImplementedException(); customer_tb.Text = recordToEdit.Customer_Name; rent_picker.Value = (DateTime)recordToEdit.DateRented; return_picker.Value = (DateTime)recordToEdit.DateReturned; cost_tb.Text = recordToEdit.Cost.ToString(); recordId_lbl.Text = recordToEdit.ID.ToString(); }
public AddEditRentalRecord(CarRentalRecord recordToEdit) { InitializeComponent(); title_lbl.Text = "Edit New Rental Record"; this.Text = "Edit Rental Record"; if (recordToEdit == null) { MessageBox.Show("Please to ensure that you selected a valid record to edit"); } else { isEditMode = true; carRentalEntities = new CarRentalEntities(); populateFields(recordToEdit); } }
public frmAddEditRentalRecord(CarRentalRecord recordToEdit) { InitializeComponent(); if (recordToEdit == null) { MessageBox.Show("Please ensure that you selected a valid record to edit."); isValid = false; Close(); } else { isEditMode = true; db = new CarRentalEntity(); PopulateFileds(recordToEdit); } }
public AddEditRentalRecord(CarRentalRecord recordToEdit, ManageRentalRecords manageRentalRecords) { InitializeComponent(); label1.Text = "Edit Vehicle"; _manageRentalRecords = manageRentalRecords; if (recordToEdit == null) { MessageBox.Show("Please ensure that you selected a valid record"); Close(); } else { isEditMode = true; _db = new CarRentalEntities(); PopulateFields(recordToEdit); } }
public AddEditRentalRecord(CarRentalRecord recordToEdit) { InitializeComponent(); lblTitle.Text = "Edit Rental Record"; this.Text = "Edit Rental Record"; if (recordToEdit == null) { MessageBox.Show("Select a record to Edit."); Close(); } else { isEditMode = true; db = new CarRentalEntities(); PopulateFields(recordToEdit); } }
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 == true) if (isValid) { //Declare an object of the record to be added var rentalRecord = new CarRentalRecord(); if (isEditMode) { //If in edit mode, then get the 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 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 Changes made to the entity _db.SaveChanges(); _manageRentalRecords.PopulateGrid(); 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 FOR YOUR BUSINESS"); Close(); } else { MessageBox.Show(errorMessage); } } catch (Exception ex) { MessageBox.Show(ex.Message); //throw; } }
private void btnSubmit_Click(object sender, EventArgs e) { try { string customerName = txtUsername.Text; var dateOut = dtRented.Value; var dateIn = dtReturned.Value; var carType = cboCarType.Text; double cost = Convert.ToDouble(txtCost.Text); var isValid = true; var errorMessage = ""; if (string.IsNullOrEmpty(customerName) || string.IsNullOrEmpty(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) { var id = int.Parse(lblRecorId.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.carID = (int)cboCarType.SelectedValue; // if not in edit mode, then add the record object to DB if (!isEditMode) { db.CarRentalRecords.Add(rentalRecord); } //Save changes to entity db.SaveChanges(); MessageBox.Show("Data Saved Successfully"); DialogResult dialogResult = MessageBox.Show("Want to Add new Record?", "New Record", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { txtUsername.Text = ""; txtUsername.Focus(); txtCost.Text = ""; var addRentalRecord = new AddEditRentalRecord(); addRentalRecord.Show(); } else { var manageRentalRecord = new ManageRentalRecords(); manageRentalRecord.Show(); this.Close(); } this.Close(); } else { MessageBox.Show(errorMessage); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { try { string customerName = tbCustomerName.Text; var dateRented = dtpRented.Value; var dateReturned = dtpReturned.Value; var carType = cmbCarType.Text; var isValid = true; var errorMessage = ""; double cost = Convert.ToDouble(tbCost.Text); if (string.IsNullOrWhiteSpace(customerName) || string.IsNullOrWhiteSpace(carType)) { isValid = false; errorMessage += "Enter missing data!\n"; } if (dateRented > dateReturned) { isValid = false; errorMessage += "Ilegal date selection!\n"; } if (isValid == true) { if (isEditMode) { var id = int.Parse(lblRecordId.Text); var carRentalRecord = _db.CarRentalRecords.FirstOrDefault(q => q.id == id); carRentalRecord.CustomerName = customerName; carRentalRecord.DateRented = dateRented; carRentalRecord.DateReturned = dateReturned; carRentalRecord.Cost = (decimal)cost; carRentalRecord.TypeofCarId = (int)cmbCarType.SelectedValue; _db.SaveChanges(); MessageBox.Show($"Thank you for submitting {tbCustomerName.Text} the car {cmbCarType.Text} on date {dtpRented.Value}" + $" Cost is: {cost}"); } else { var carRentalRecord = new CarRentalRecord(); carRentalRecord.CustomerName = customerName; carRentalRecord.DateRented = dateRented; carRentalRecord.DateReturned = dateReturned; carRentalRecord.Cost = (decimal)cost; carRentalRecord.TypeofCarId = (int)cmbCarType.SelectedValue; _db.CarRentalRecords.Add(carRentalRecord); _db.SaveChanges(); MessageBox.Show($"Thank you for submitting {tbCustomerName.Text} the car {cmbCarType.Text} on date {dtpRented.Value}" + $" Cost is: {cost}"); } _manageRentalRecords.PopulateGrid(); Close(); } else { MessageBox.Show(errorMessage); } } catch (Exception ex) { MessageBox.Show(ex.Message); // throw; } }
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()); } }
private void Btn_Submit_Click(object sender, EventArgs e) { string coustomerName = txtBox_CoustomerName.Text; string cartype = cmBox_TypeOfCar.Text; DateTime daterented = dateRented.Value; DateTime datereturned = dateReturned.Value; double cost = toDouble(txtBox_Cost.Text); bool isValid = true; string errorMessage = ""; if (string.IsNullOrWhiteSpace(coustomerName) || string.IsNullOrWhiteSpace(cartype)) { isValid = false; errorMessage += "Error: Please enter the missing data.\n\r"; } if (daterented > datereturned) { isValid = false; errorMessage += "Error: Illegal Date Selection\n\r"; } if (isValid) { var rentalRecord = new CarRentalRecord(); if (isEditMode) { var id = int.Parse(lblRecordId.Text); rentalRecord = _db.CarRentalRecords.FirstOrDefault(q => q.id == id); } rentalRecord.CustomerName = coustomerName; rentalRecord.DateRented = daterented; rentalRecord.DateReturned = datereturned; rentalRecord.Cost = (decimal)cost; rentalRecord.TypeOfCarID = (int)cmBox_TypeOfCar.SelectedValue; if (rentalRecord.Cost <= 0) { MessageBox.Show("cost cant be 0 or less."); } else { if (!isEditMode) { _db.CarRentalRecords.Add(rentalRecord); } _db.SaveChanges(); if (_manageRentalRecords != null) { _manageRentalRecords.populateData(); } MessageBox.Show("Thank You for renting " + coustomerName, "Thank you!", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } else { MessageBox.Show(errorMessage); } }
private void submit_btn_Click(object sender, EventArgs e) { //Validating form try { string customerName = customer_tb.Text; var rented = rent_picker.Value; var returned = return_picker.Value; double cost = Convert.ToDouble(cost_tb.Text); var car = car_cb.Text; var isValid = true; var error = ""; //Checking if customer did not enter name field if (string.IsNullOrWhiteSpace(customerName) || string.IsNullOrWhiteSpace(car)) { isValid = false; error += "Error: Please Enter Missing Information."; } if (rented > returned) { isValid = false; error += "Error: Illegal Date Selection"; } if (isValid) { //Object declaration of rentalrecord var rentalRecord = new CarRentalRecord(); if (isEditMode) { var id = int.Parse(recordId_lbl.Text); var record = carRentalEntities.CarRentalRecords.FirstOrDefault(q => q.ID == id); } //Values populated from form details rentalRecord.Customer_Name = customerName; rentalRecord.DateRented = rented; rentalRecord.DateReturned = returned; rentalRecord.Cost = (decimal)cost; //Casting cost which is of double data type to decimal which is type in DB rentalRecord.TypeOfCarID = (int)car_cb.SelectedValue; if (!isEditMode) { carRentalEntities.CarRentalRecords.Add(rentalRecord); } carRentalEntities.SaveChanges(); MessageBox.Show($"Customer: {customerName} \n\r" + $"Rent Date: {rented}\n\r" + $"Return Date: {returned}\n\r" + $"Cost: ${cost}\n\r" + $"Car Type: {car}\n\r" + $"THANK YOU FOR YOUR BUSINESS"); Close(); } else { MessageBox.Show(error); } } catch (Exception ex) { MessageBox.Show(ex.Message); //throw; // Normally ends program once exception occurs. } }