public ActionResult Appointment(AppointmentScheduleModel appointment)
{
ViewBag.doctorList = appointmentManager.GetAllDoctor();
ViewBag.specialization = doctorManager.GetSpecialization();
ViewBag.message = appointmentManager.Appointment(appointment);
ModelState.Clear();
return(View());
}
//--------------------------------------------------------------------
public string Appointment(AppointmentScheduleModel appointment)
{
int rowEffect = appointmentGateway.Appointment(appointment);
if (rowEffect > 0)
{
return("Save Successful");
}
else
{
return("Save Faild");
}
}
public int Appointment(AppointmentScheduleModel appointment)
{
query = "INSERT INTO AppointmentScheduleTable VALUES('" + appointment.DoctorId + "' , '" +
appointment.AppointmentDate + "', '" + appointment.AppointmentNo + "' , '" + appointment.ContactNo + "') ";
Command = new SqlCommand(query, Connection);
Connection.Open();
int rowEffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowEffect);
}
