public List<Appointment> GetAllAppointmentByRepeater()
{
SqlConnection connection = new SqlConnection(databaseConString);
string query = "SELECT * FROM view_appointmentList";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List<Appointment> appointmentList = new List<Appointment>();
int serialNo = 1;
while (reader.Read())
{
Appointment appointment = new Appointment();
appointment.SerialNo = serialNo++;
appointment.AppointmentDate = reader["appointment_date"].ToString();
appointment.AppointmentSerial = int.Parse(reader["appointment_serial"].ToString());
appointment.PatientName = reader["patient_name"].ToString();
appointment.PatientContactNo = reader["contact_number"].ToString();
appointment.DoctorName = reader["doctor_name"].ToString();
appointmentList.Add(appointment);
}
reader.Close();
connection.Close();
return appointmentList;
}
protected void addAppointmentButton_Click(object sender, EventArgs e)
{
Appointment appointment = new Appointment();
appointment.AppointmentDate = appointmentDateTextBox.Text;
appointment.AppointmentSerial = int.Parse(appointmentSerialTextBox.Text);
appointment.PatientId = int.Parse(patientNameDropDownList.SelectedValue);
appointment.DoctorId = int.Parse(doctorNameDropDownList.SelectedValue);
message.InnerHtml = appointmentManager.Save(appointment);
}
public string Save(Appointment appointment)
{
if (appointmentGateway.Save(appointment) > 0)
{
return "Added Successfully";
}
else
{
return "Could Not Added!";
}
}
public int Save(Appointment appointment)
{
SqlConnection connection = new SqlConnection(databaseConString);
string query = "INSERT INTO tbl_appointment VALUES ('" + appointment.AppointmentDate + "','" +
appointment.AppointmentSerial + "','" + appointment.PatientId + "','" + appointment.DoctorId +
"')";
SqlCommand command = new SqlCommand(query,connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return rowAffected;
}
