private void btnCancel_Click(object sender, EventArgs e) { var am = new AdminPage(); am.ClearAllTextBoxes(this); EnableTextBoxes(this, false); btnCancel.Enabled = false; btnUpdate.Enabled = false; }
private void btnSubmit_Click(object sender, EventArgs e) { try { conn = new SqlConnection { ConnectionString = constr }; conn.Open(); // string insrtlg = "INSERT INTO LoginTB(Username,Password,Access_Level) VALUES(@usr,@pass,@role)"; string insrtInPat = "INSERT INTO InPatientReg(Fname,Lname,Birth,Gender,Phone,Address,Occupation,MaritalStatus,Age,Status,AdmissionDate,Symptoms,Departement,AssignedDoc,WardNo,BedNo) VALUES(@FirstName,@LastName,@DOB,@Gender,@PhoneNumber,@Address,@Occupation,@Mstatus,@Age,@Status,@AdminDate,@Sympt,@Dept,@Doc,@WNo,@BNo)"; SqlCommand cmd1 = new SqlCommand(insrtInPat, conn); //Adding Registration Infos cmd1.Parameters.AddWithValue("@FirstName", txtFirstName.Text); cmd1.Parameters.AddWithValue("@LastName", txtLastName.Text); cmd1.Parameters.AddWithValue("@DOB", txtDateOfBirth.Text); cmd1.Parameters.AddWithValue("@Gender", txtGender.SelectedItem); cmd1.Parameters.AddWithValue("@PhoneNumber", txtPhoneNumber.Text); cmd1.Parameters.AddWithValue("@Address", txtAddress.Text); cmd1.Parameters.AddWithValue("@Occupation", txtOccupation.Text); cmd1.Parameters.AddWithValue("@Mstatus", txtMaritalStatus.SelectedItem); cmd1.Parameters.AddWithValue("@Age", txtAge.Text); cmd1.Parameters.AddWithValue("@Status", txtStatus.SelectedItem); cmd1.Parameters.AddWithValue("@AdminDate", lblCurrentDateTime.Text); cmd1.Parameters.AddWithValue("@Sympt", txtSymptoms.Text); cmd1.Parameters.AddWithValue("@Dept", txtDepartment.SelectedItem); cmd1.Parameters.AddWithValue("@Doc", txtAssignDoctor.Text); cmd1.Parameters.AddWithValue("@WNo", txtWardNo.SelectedItem); cmd1.Parameters.AddWithValue("@BNo", txtBedNumber.Value); cmd1.ExecuteNonQuery(); conn.Close(); MessageBox.Show(this, "User successfully inserted into database. ", "Report", MessageBoxButtons.OK, MessageBoxIcon.Information); var am = new AdminPage(); am.ClearAllTextBoxes(this); } catch (Exception ex) { lblErrorMess.Text = ex.Message; } }