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 } }