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);
}