private void btnSave_Click(object sender, EventArgs e) { if (isEditMode) { //edit code var id = int.Parse(lblid.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 = tbLicense.Text; } else { //add code var newCar = new typesOfCar { licensePlateNumber = tbLicense.Text, make = tbMake.Text, model = tbModel.Text, vin = tbVin.Text, year = int.Parse(tbYear.Text) }; _db.typesOfCars.Add(newCar); } _db.SaveChanges(); _manageVehicle.PopulateGrid(); MessageBox.Show("Done"); Close(); }
private void btnReset_Click(object sender, EventArgs e) { try { //get id var id = (int)gvUserList.SelectedRows[0].Cells["id"].Value; //query database 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 !"); } 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("SUcCESS"); _manageUsers.populateGrid(); Close(); } catch (Exception ex) { MessageBox.Show("an error occured"); } }
private void btnDeleteCar_Click(object sender, EventArgs e) { try { //get id var id = (int)gvRecordList.SelectedRows[0].Cells["id"].Value; //query database var record = _db.carRentalRecords.FirstOrDefault(q => q.id == id); //delete from table _db.carRentalRecords.Remove(record); _db.SaveChanges(); PopulateGrid(); } catch (Exception ex) { MessageBox.Show($"Error:{ex.Message}"); } }
private void btnsubmitpass_Click(object sender, EventArgs e) { try { var password = tbpassword.Text; var confirm_pass = tbConfirm.Text; var user = _db.Users.FirstOrDefault(q => q.id == _user.id); if (password != confirm_pass) { MessageBox.Show("Password do not match plz try again"); } user.password = Utils.HashPassword(password); _db.SaveChanges(); MessageBox.Show("pass was reset successfullu"); Close(); } catch (Exception) { MessageBox.Show("an error has occured plz try again"); } }
private void btnDeleteCar_Click(object sender, EventArgs e) { try { //get id var id = (int)gvRecList.SelectedRows[0].Cells["id"].Value; //query database var car = _db.typesOfCars.FirstOrDefault(q => q.id == id); DialogResult dr = MessageBox.Show("Are U sure u want to delete this record ?", "delete", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning); if (dr == DialogResult.Yes) { //delete from table _db.typesOfCars.Remove(car); _db.SaveChanges(); } PopulateGrid(); } catch (Exception ex) { MessageBox.Show($"Error:{ex.InnerException.Message}"); } }
private void btnSubmit_Click(object sender, EventArgs e) { try { string customerName = TbCustomerName.Text; var dateou = dtFrom.Value; var datein = dtTo.Value; var type = cbType.Text; double cost = Convert.ToDouble(tbCost.Text); var isValid = true; var errMsg = ""; if (string.IsNullOrWhiteSpace(customerName) || string.IsNullOrWhiteSpace(type)) { isValid = false; errMsg += "Please Enter Missing Data ! \n\r"; } if (dateou > datein) { isValid = false; errMsg += "Illegeal date Selection"; } if (isValid) { var rentalRecord = new carRentalRecord(); if (isEditMode) { var id = (int.Parse(lblrecId.Text)); rentalRecord = _db.carRentalRecords.FirstOrDefault(q => q.id == id); } rentalRecord.customerName = customerName; rentalRecord.dateRanted = dateou; rentalRecord.dateReturned = datein; rentalRecord.cost = (decimal)cost; rentalRecord.typeOfCarId = (int)cbType.SelectedValue; if (!isEditMode) { _db.carRentalRecords.Add(rentalRecord); } _db.SaveChanges(); MessageBox.Show( $"Customer Name : {customerName}\n\r" + $"Date Rented : {dateou}\n\r" + $"Date Returned : {datein}\n\r" + $"Car Type : {type}\n\r" + $"Cost : {cost}\n\r" + $"Thank You For Renting {customerName}"); Close(); } else { MessageBox.Show(errMsg); } } catch (Exception ex) { MessageBox.Show(ex.Message); //throw; } }