public void deleteDoctor(doctorDTO d) { s.sqlConnection.Open(); string query = "delete from doctors where doctorId = '" + d.DoctorId + "'"; s.sqlCommand = new SqlCommand(query, s.sqlConnection); s.sqlCommand.ExecuteNonQuery(); s.sqlConnection.Close(); }
private void doctorDataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e) { bool blank = false; if (doctorDataGridView.Rows[e.RowIndex].Cells[0].Value.ToString() == "") { blank = true; } if (doctorDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString() == "") { blank = true; } if (doctorDataGridView.Rows[e.RowIndex].Cells[2].Value.ToString() == "") { blank = true; } if (doctorDataGridView.Rows[e.RowIndex].Cells[3].Value.ToString() == "") { blank = true; } if (doctorDataGridView.Rows[e.RowIndex].Cells[4].Value.ToString() == "") { blank = true; } if (doctorDataGridView.Rows[e.RowIndex].Cells[5].Value.ToString() == "") { blank = true; } if (doctorDataGridView.Rows[e.RowIndex].Cells[6].Value.ToString() == "") { blank = true; } if (doctorDataGridView.Rows[e.RowIndex].Cells[7].Value.ToString() == "") { blank = true; } if (blank) { loadDoctorsInfo(); return; } int doctorId = Convert.ToInt32(doctorDataGridView.Rows[e.RowIndex].Cells[0].Value.ToString()); string name = doctorDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString(); string age = doctorDataGridView.Rows[e.RowIndex].Cells[3].Value.ToString(); string gender = doctorDataGridView.Rows[e.RowIndex].Cells[2].Value.ToString(); string degree = doctorDataGridView.Rows[e.RowIndex].Cells[4].Value.ToString(); string specialistIn = doctorDataGridView.Rows[e.RowIndex].Cells[5].Value.ToString(); string phone = doctorDataGridView.Rows[e.RowIndex].Cells[6].Value.ToString(); string salary = doctorDataGridView.Rows[e.RowIndex].Cells[7].Value.ToString(); d = new doctorDTO(doctorId, name, age, gender, degree, specialistIn, phone, salary); dD.updateDoctor(d); loadDoctorsInfo(); }
private void doctorDataGridView_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { int doctorId = Convert.ToInt32(doctorDataGridView.Rows[e.Row.Index].Cells[0].Value.ToString()); string name = doctorDataGridView.Rows[e.Row.Index].Cells[1].Value.ToString(); string age = doctorDataGridView.Rows[e.Row.Index].Cells[3].Value.ToString(); string gender = doctorDataGridView.Rows[e.Row.Index].Cells[2].Value.ToString(); string degree = doctorDataGridView.Rows[e.Row.Index].Cells[4].Value.ToString(); string specialistIn = doctorDataGridView.Rows[e.Row.Index].Cells[5].Value.ToString(); string phone = doctorDataGridView.Rows[e.Row.Index].Cells[6].Value.ToString(); string salary = doctorDataGridView.Rows[e.Row.Index].Cells[7].Value.ToString(); d = new doctorDTO(doctorId, name, age, gender, degree, specialistIn, phone, salary); }
private void addButton_Click(object sender, EventArgs e) { string name = nameBox.Text; string age = ageBox.Text; string gender = genderBox.Text; string degree = DegreeBox.Text; string specialistIn = specialistBox.Text; string phone = phoneBox.Text; string salary = salaryBox.Text; doctorDTO d = new doctorDTO(name, age, gender, degree, specialistIn, phone, salary); doctorDAO dD = new doctorDAO(); dD.createDoctor(d); clearFields(); }
public void createDoctor(doctorDTO d) { s.sqlConnection.Open(); string query = "insert into doctors(name,gender,age,phone,degree,specialistIn,salary) values('" + d.Name + "','" + d.Gender + "','" + d.Age + "','" + d.Phone + "','" + d.Degree + "','" + d.SpecialistIn + "','" + d.Salary + "')"; s.sqlCommand = new SqlCommand(query, s.sqlConnection); s.sqlCommand.ExecuteNonQuery(); s.sqlConnection.Close(); }
public void updateDoctor(doctorDTO d) { s.sqlConnection.Open(); string query = "update doctors set name = '" + d.Name + "', gender = '" + d.Gender + "', age = '" + d.Age + "', phone = '" + d.Phone + "', degree = '" + d.Degree + "', specialistIn = '" + d.SpecialistIn + "', salary = '" + d.Salary + "' where doctorId = '" + d.DoctorId + "' "; s.sqlCommand = new SqlCommand(query, s.sqlConnection); s.sqlCommand.ExecuteNonQuery(); s.sqlConnection.Close(); }
private void deleteButton_Click(object sender, EventArgs e) { if (doctorDataGridView.SelectedRows.Count == 0) { MessageBox.Show("Select a row from table"); return; } int idx = doctorDataGridView.SelectedRows[0].Index; int doctorId = Convert.ToInt32(doctorDataGridView.Rows[idx].Cells[0].Value.ToString()); string name = doctorDataGridView.Rows[idx].Cells[1].Value.ToString(); string age = doctorDataGridView.Rows[idx].Cells[3].Value.ToString(); string gender = doctorDataGridView.Rows[idx].Cells[2].Value.ToString(); string degree = doctorDataGridView.Rows[idx].Cells[4].Value.ToString(); string specialistIn = doctorDataGridView.Rows[idx].Cells[5].Value.ToString(); string phone = doctorDataGridView.Rows[idx].Cells[6].Value.ToString(); string salary = doctorDataGridView.Rows[idx].Cells[7].Value.ToString(); d = new doctorDTO(doctorId, name, age, gender, degree, specialistIn, phone, salary); dD.deleteDoctor(d); loadDoctorsInfo(); }