private void button2_Click(object sender, EventArgs e) { correct = true; if (txtName.Text == "" || txtVatRegNum.Text == "" || txtTelephone.Text == "" || txtFaxNumber.Text == "" || txtEmailAdd.Text == "" || txtPhysicalAdd.Text == "") { MessageBox.Show("Please enter all fields!"); correct = false; } DialogResult dialogResult = MessageBox.Show("Would you like to update the client Information ?", "Update Template", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { if (correct == true) { try { if (correct == true) { var query = db.Clients.Where(co => co.Client_ID == ClientID).FirstOrDefault(); var query1 = db.Provinces.Where(co => co.Province_Id == query.Province_Id).FirstOrDefault(); var query2 = db.Cities.Where(co => co.City_Id == query.City_Id).FirstOrDefault(); var query3 = db.Credit_Approval.Where(co => co.Credit_Approval_ID == query.Credit_Approval_ID).FirstOrDefault(); var query4 = db.Credit_Status.Where(co => co.Credit_Status_ID == query3.Credit_Approval_ID).FirstOrDefault(); var query5 = db.Client_Account_Status.Where(co => co.Account_Status_ID == query3.Credit_Approval_ID).FirstOrDefault(); Client NewCllient = new Client(); Credit_Approval NewCA = new Credit_Approval(); City newCity = new City(); Credit_Status crStatus = new Credit_Status(); Client_Account_Status cAS = new Client_Account_Status(); Province NewProv = new Province(); NewCllient = db.Clients.Where(co => co.Client_ID == ClientID).FirstOrDefault(); NewCA = db.Credit_Approval.Where(co => co.Credit_Approval_ID == query3.Credit_Approval_ID).FirstOrDefault(); newCity = db.Cities.Where(co => co.City_Id == query.City_Id).FirstOrDefault(); crStatus = db.Credit_Status.Where(co => co.Credit_Status_ID == query.Credit_Approval_ID).FirstOrDefault(); cAS = db.Client_Account_Status.Where(co => co.Account_Status_ID == query.Credit_Approval_ID).FirstOrDefault(); query.Client_Name = txtName.Text; query.Client_VAT_Reg_Number = txtVatRegNum.Text; query.Client_Telephone = "+27" + txtTelephone.Text; query.Client_Fax_Number = txtFaxNumber.Text; query.Physical_Address = txtPhysicalAdd.Text; query.Client_Email_Address = txtEmailAdd.Text; query1.Province_Name = cbxProvince.Text; query2.City_Name = cbxCity.Text; query3.Credit_Approval_Amount = Convert.ToDecimal(txtCreditAmount.Text); if (query3.Credit_Status_ID == null) { cbxCreditStatus.SelectedIndex = -1; } else { query4.Credit_Status_Description = cbxCreditStatus.Text; } NewCA.Credit_Approval_ID = crStatus.Credit_Status_ID; query5.Account_Status_Description = comboBox5.Text; query3.Credit_Approval_Form = FileData; //query3.Credit_Approval_Form = Encoding.ASCII.GetBytes(txtFilePath.Text); db.SaveChanges(); MessageBox.Show("Client Has been updated succesfully"); this.Close(); } } catch (Exception ex) { MessageBox.Show("Error has occured, and template was not updated successfully" + ex); } } } }