public List <CheckStatusViewModel> GetAllRejectedAppointment() { string query = @"SELECT a.Id, a.PatientId,a.ScheduleId, convert(varchar, a.Date) as date,a.StartTime,a.EndTime,a.Status,p.DoctorName,s.SpecialityName FROM [dbo].[Appointment] a inner join [dbo].[DrRegistration] p on a.DoctorId=p.Id inner join [dbo].[Speciality] s on s.Id=p.SpecialityId where Status='Reject'"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <CheckStatusViewModel> alList = new List <CheckStatusViewModel>(); while (reader.Read()) { CheckStatusViewModel appointment = new CheckStatusViewModel(); appointment.AppointmentId = (int)reader["Id"]; appointment.PatientId = (int)reader["PatientId"]; appointment.ScheduleId = (int)reader["ScheduleId"]; appointment.DoctorName = reader["DoctorName"].ToString(); appointment.Speciality = reader["SpecialityName"].ToString(); appointment.AppointmentDate = reader["date"].ToString(); appointment.StartTime = reader["StartTime"].ToString(); appointment.EndTime = reader["EndTime"].ToString(); appointment.Status = reader["Status"].ToString(); alList.Add(appointment); } reader.Close(); con.Close(); return(alList); }
public List <CheckStatusViewModel> GetsubmitedEmail(int appointmentId) { string query = @"select convert(varchar, a.Date,101) as date,a.StartTime,a.EndTime,p.PatientName,p.Email from [dbo].[PtRegistration] p inner join [dbo].[Appointment] a on p.Id=a.PatientId where p.Id='" + appointmentId + "'"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <CheckStatusViewModel> alList = new List <CheckStatusViewModel>(); while (reader.Read()) { CheckStatusViewModel appointment = new CheckStatusViewModel(); appointment.PatientName = reader["PatientName"].ToString(); appointment.AppointmentDate = reader["date"].ToString(); appointment.StartTime = reader["StartTime"].ToString(); appointment.EndTime = reader["EndTime"].ToString(); appointment.PatientEmail = reader["Email"].ToString(); alList.Add(appointment); } reader.Close(); con.Close(); return(alList); }
public List <CheckStatusViewModel> GetAppointmentById(int id) { string query = @"SELECT CONVERT(varchar, a.Date, 101) as Date ,a.StartTime,a.EndTime,a.Status,p.DoctorName,s.SpecialityName FROM [dbo].[Appointment] a inner join [dbo].[DrRegistration] p on a.DoctorId=p.Id inner join [dbo].[Speciality] s on s.Id=p.SpecialityId where a.PatientId='" + id + "'"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <CheckStatusViewModel> alList = new List <CheckStatusViewModel>(); while (reader.Read()) { CheckStatusViewModel appointment = new CheckStatusViewModel(); appointment.DoctorName = reader["DoctorName"].ToString(); appointment.Speciality = reader["SpecialityName"].ToString(); appointment.AppointmentDate = (reader["Date"]).ToString(); appointment.StartTime = reader["StartTime"].ToString(); appointment.EndTime = reader["EndTime"].ToString(); appointment.Status = reader["Status"].ToString(); alList.Add(appointment); } reader.Close(); con.Close(); return(alList); }