public Patient GetPatientId(AppointmentVm appointment)
{
Query = "SELECT Id FROM Patient WHERE PatientCode = @patientCode";
Command = new SqlCommand(Query, Connection);
Patient aPatient = null;
Connection.Open();
Command.Parameters.Clear();
Command.Parameters.Add("patientCode", SqlDbType.VarChar);
Command.Parameters["patientCode"].Value = appointment.PatientCode;
Reader = Command.ExecuteReader();
bool a = Reader.HasRows;
while (Reader.Read())
{
aPatient = new Patient();
aPatient.Id = (int)Reader["Id"];
}
Reader.Close();
Connection.Close();
return(aPatient);
}
public List <AppointmentVm> GetAllAppointment()
{
Query = "SELECT p.PatientCode,p.ContactNo,d.Name,a.time FROM Appointment a JOIN Doctor d ON a.DoctorId = d.Id JOIN Patient p ON p.Id = a.PatientId";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <AppointmentVm> appointmentVms = new List <AppointmentVm>();
while (Reader.Read())
{
AppointmentVm appointmentVm = new AppointmentVm();
appointmentVm.PatientCode = Reader["PatientCode"].ToString();
appointmentVm.DoctorName = Reader["Name"].ToString();
appointmentVm.PatientContactNo = Reader["ContactNo"].ToString();
int Time = Convert.ToInt32(Reader["Time"].ToString());
string ampm = null;
int Hr;
if (Time > 719)
{
ampm = "PM";
}
else
{
ampm = "AM";
}
string Min = Convert.ToString(Time % 60);
if (Min.Length == 1)
{
Min = Min + "0";
}
int Hr2 = Time / 60;
if (Hr2 > 12)
{
Hr = Hr2 - 12;
}
else
{
Hr = Hr2;
}
appointmentVm.Time = Hr + ":" + Min + "" + ampm;
appointmentVms.Add(appointmentVm);
}
Reader.Close();
Connection.Close();
return(appointmentVms);
}
public string Save(AppointmentVm appointment)
{
Patient patient = appointmentGateway.GetPatientId(appointment);
int pId = patient.Id;
appointment.PatientId = pId;
int rowAffected = appointmentGateway.Save(appointment);
if (rowAffected > 0)
{
return("1");
}
return("2");
}
protected void saveButton_Click(object sender, EventArgs e)
{
string time = timeTextBox.Value;
string timeHr = time.Substring(0, 2);
string timeMin = time.Substring(3, 2);
int timeHr2 = Convert.ToInt32(timeHr);
int timeMin2 = Convert.ToInt32(timeMin);
string timeAMPM = time.Substring(6, 2);
if (timeAMPM == "PM")
{
timeHr2 = timeHr2 + 12;
}
int time2 = timeHr2 * 60 + timeMin2;
AppointmentVm appointment = new AppointmentVm();
appointment.PatientCode = patientCodeTextBox.Value;
appointment.DoctorId = Convert.ToInt32(selectDoctorDropDownList.SelectedValue);
appointment.Time = Convert.ToString(time2);
string msg = appointmentManager.Save(appointment);
if (msg == "1")
{
messageLabel.InnerText = "Appointment saved";
}
else if (msg == "2")
{
messageLabel2.InnerText = "Saving failed";
}
PopulateGridView();
patientCodeTextBox.Value = String.Empty;
timeTextBox.Value = String.Empty;
}
public int Save(AppointmentVm appointment)
{
Query = "INSERT INTO Appointment VALUES(@patientid, @doctorId, @time)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("patientid", SqlDbType.Int);
Command.Parameters["patientid"].Value = appointment.PatientId;
Command.Parameters.Add("doctorId", SqlDbType.Int);
Command.Parameters["doctorId"].Value = appointment.DoctorId;
Command.Parameters.Add("time", SqlDbType.VarChar);
Command.Parameters["time"].Value = appointment.Time;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
