public int SaveDoctorSpeciality(DoctorsSpecialities aDoctorSpeciality)
{
Query = "INSERT INTO DoctorsSpecialities VALUES(@speciality)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("speciality", aDoctorSpeciality.Speciality);
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public string SaveDoctorSpeciality(DoctorsSpecialities aDoctorSpeciality)
{
int rowAffected = aMainAdminGateway.SaveDoctorSpeciality(aDoctorSpeciality);
if (rowAffected > 0)
{
return("Success");
}
else
{
return("Doctor speciality saving failed.");
}
}
public List <DoctorsSpecialities> GetSpecialities()
{
Query = "SELECT * FROM DoctorsSpecialities ORDER BY Speciality";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <DoctorsSpecialities> doctorsSpecialities = new List <DoctorsSpecialities>();
while (Reader.Read())
{
DoctorsSpecialities specialities = new DoctorsSpecialities();
specialities.Id = Convert.ToInt32(Reader["Id"]);
specialities.Speciality = Reader["Speciality"].ToString();
doctorsSpecialities.Add(specialities);
}
Reader.Close();
Connection.Close();
return(doctorsSpecialities);
}