public void Car() { string CarPol = dRow.ItemArray.GetValue(5).ToString(); connect.sql_string = "SELECT * FROM Car WHERE CarID = " + CarPol; Car_ds = connect.GetConnection; dRowCar = Car_ds.Tables[0].Rows[0]; String carReg = EncypherDecypher.Decypher(dRowCar.ItemArray.GetValue(1).ToString()); tbCarRegistration.Text = carReg; String chasisNo = EncypherDecypher.Decypher(dRowCar.ItemArray.GetValue(2).ToString()); tbChasisNumber.Text = chasisNo; String carMake = EncypherDecypher.Decypher(dRowCar.ItemArray.GetValue(3).ToString()); tbCarMake.Text = carMake; String carModel = EncypherDecypher.Decypher(dRowCar.ItemArray.GetValue(4).ToString()); tbCarModel.Text = carModel; String carEngineSize = EncypherDecypher.Decypher(dRowCar.ItemArray.GetValue(5).ToString()); tbCarEngineSize.Text = carEngineSize; String estimatedWorth = EncypherDecypher.Decypher(dRowCar.ItemArray.GetValue(6).ToString()); cbEstimatedWorth.Text = estimatedWorth; }
public void Customer() { string CustPol = dRow.ItemArray.GetValue(3).ToString(); connect.sql_string = "SELECT * FROM Customer WHERE CustomerID = " + CustPol; Cust_ds = connect.GetConnection; dRowCustomer = Cust_ds.Tables[0].Rows[0]; String firstName = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(1).ToString()); tbFirstName.Text = firstName; String Surname = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(2).ToString()); tbSurname.Text = Surname; String Title = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(3).ToString()); cbTitle.Text = Title; String Street = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(4).ToString()); tbStreet.Text = Street; String Town = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(5).ToString()); tbTown.Text = Town; String County = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(6).ToString()); cbCounty.Text = County; String Eircode = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(7).ToString()); tbEircode.Text = Eircode; String dateOfBirth = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(8).ToString()); dpDateOfBirth.Text = dateOfBirth; String contactNumber = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(9).ToString()); tbContactNumber.Text = contactNumber; String licenceType = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(10).ToString()); cbLicenceType.Text = licenceType; String licenceNo = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(11).ToString()); tbLicenceNo.Text = licenceNo; String licenceIssued = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(12).ToString()); dpLicenceIssued.Text = licenceIssued; String penaltyPoints = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(13).ToString()); tbPenaltyPoints.Text = penaltyPoints; String noClaims = EncypherDecypher.Decypher(dRowCustomer.ItemArray.GetValue(14).ToString()); if (noClaims.Equals("TRUE")) { cbNoClaims.Checked = true; } else { cbNoClaims.Checked = false; } }
void dgvUsers_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { try { if (e.ColumnIndex == 2 || e.ColumnIndex == 5 || e.ColumnIndex == 6 || e.ColumnIndex == 7 && e.RowIndex != this.dgvUsers.NewRowIndex) { if (e != null && !String.IsNullOrEmpty(e.Value as string)) { if (IsEncrypted(e.Value.ToString())) { // MessageBox.Show(e.Value.ToString(), "encrypting"); e.Value = EncypherDecypher.Decypher(e.Value.ToString()); } } } } catch (Exception err) { MessageBox.Show(err.Message, e.Value.ToString()); } }
public void NewDriver() { string DrivePol = dRow.ItemArray.GetValue(4).ToString(); connect.sql_string = "SELECT * FROM Customer WHERE CustomerID = " + DrivePol; Driver_ds = connect.GetConnection; var temp = dRow.ItemArray.GetValue(4); if (!dRow.ItemArray.GetValue(4).Equals((object)0)) { dRowDriver = Driver_ds.Tables[0].Rows[0]; String firstName = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(1).ToString()); tbnFirstName.Text = firstName; String Surname = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(2).ToString()); tbnSurname.Text = Surname; String Title = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(3).ToString()); cbnTitle.Text = Title; String Street = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(4).ToString()); tbnStreet.Text = Street; String Town = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(5).ToString()); tbnTown.Text = Town; String County = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(6).ToString()); cbnCounty.Text = County; String Eircode = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(7).ToString()); tbnEircode.Text = Eircode; dpnDateOfBirth.Format = DateTimePickerFormat.Custom; dpnDateOfBirth.CustomFormat = "dd MMMM yyyy"; String dateOfBirth = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(8).ToString()); dpnDateOfBirth.Text = dateOfBirth; String contactNumber = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(9).ToString()); tbnContactNumber.Text = contactNumber; String licenceType = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(10).ToString()); cbnLicenceType.Text = licenceType; String licenceNo = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(11).ToString()); tbnLicenceNumber.Text = licenceNo; dpnLicenceIssued.Format = DateTimePickerFormat.Custom; dpnLicenceIssued.CustomFormat = "dd MMMM yyyy"; String licenceIssued = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(12).ToString()); dpnLicenceIssued.Text = licenceIssued; String penaltyPoints = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(13).ToString()); tbnPenaltyPoints.Text = penaltyPoints; String noClaims = EncypherDecypher.Decypher(dRowDriver.ItemArray.GetValue(14).ToString()); if (noClaims.Equals("TRUE")) { cbnNoClaims.Checked = true; } else { cbnNoClaims.Checked = false; } } else { tbnFirstName.Clear(); tbnSurname.Clear(); cbnTitle.Text = (" "); tbnStreet.Clear(); tbnTown.Clear(); cbnCounty.Text = (" "); tbnEircode.Clear(); dpnDateOfBirth.Format = DateTimePickerFormat.Custom; dpnDateOfBirth.CustomFormat = " "; tbnContactNumber.Clear(); cbnLicenceType.Text = (" "); tbnLicenceNumber.Clear(); dpnLicenceIssued.Format = DateTimePickerFormat.Custom; dpnLicenceIssued.CustomFormat = " "; tbnPenaltyPoints.Clear(); cbnNoClaims.Checked = false; } }