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