public bool Delete(DoctorsClass d) { bool Success = false; SqlConnection conn = GetConnection(); try { string sql = "DELETE FROM Doctors WHERE DoctorID=@DoctorID"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@DoctorID", d.DoctorID); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { Success = true; } else { Success = false; } } catch (Exception ex) { } finally { conn.Close(); } return(Success); }
public bool Insert(DoctorsClass d) { bool Success = false; SqlConnection conn = GetConnection(); try { string sql = "INSERT INTO Doctors (FullName, Speciality, Phone, Address, Email) VALUES (@FullName, @Speciality, @Phone, @Address, @Email)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@FullName", d.FullName); cmd.Parameters.AddWithValue("@Speciality", d.Speciality); cmd.Parameters.AddWithValue("@Phone", d.Phone); cmd.Parameters.AddWithValue("@Address", d.Address); cmd.Parameters.AddWithValue("@Email", d.Email); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { Success = true; } else { Success = false; } } catch (Exception ex) { } finally { conn.Close(); } return(Success); }