//update public Staff UpdateOfStaff(Staff staff) { using (var connection = SqlConnectionFactory.GetConnectionString()) { try { var result = connection.Query <Staff>("[dbo].[UpdateStaff]", new { StaffID = staff.StaffID, FirstName = staff.FirstName, LastName = staff.LastName, StartDate = staff.StartDate, DateOfBirth = staff.DateOfBirth, StaffTypeID = staff.StaffTypeID }, commandType: CommandType.StoredProcedure); return(result.FirstOrDefault()); } catch (Exception ex) { throw ex; } } }
public List <SelectListItem> GetAllAppointments() { using (var connection = SqlConnectionFactory.GetConnectionString()) { try { var AllAppointmentTimes = connection.Query <AppointmentTime>("[dbo].[GetAllAppointments]", commandType: CommandType.StoredProcedure); var appointmentList = new List <SelectListItem>(); foreach (var oneAppointmentTime in AllAppointmentTimes) { var selectListItem = new SelectListItem(); selectListItem.Text = oneAppointmentTime.AppointmentDescription; selectListItem.Value = oneAppointmentTime.AppointmentTimeID.ToString(); appointmentList.Add(selectListItem); } return(appointmentList); } catch (Exception ex) { throw ex; } } }
public List <SelectListItem> GetAllStaff() { using (var connection = SqlConnectionFactory.GetConnectionString()) { try { var AllStaff = connection.Query <Staff>("[dbo].[GetAllStaff]", commandType: CommandType.StoredProcedure); var staffList = new List <SelectListItem>(); foreach (var oneStaff in AllStaff) { var selectListItem = new SelectListItem(); selectListItem.Text = oneStaff.LastName; selectListItem.Value = oneStaff.StaffID.ToString(); staffList.Add(selectListItem); } return(staffList); } catch (Exception ex) { throw ex; } } }
public List <Patient> AllPatients() { using (var connection = SqlConnectionFactory.GetConnectionString()) { try { var result = connection.Query <Patient>("GetAllPatients", commandType: CommandType.StoredProcedure); return(result.ToList()); } catch (Exception ex) { throw ex; } } }
public List <Staff> GetAllStaff() { using (var connection = SqlConnectionFactory.GetConnectionString()) { try { var result = connection.Query <Staff>("[dbo].[GetAllStaff]", commandType: CommandType.StoredProcedure); return(result.ToList()); } catch (Exception ex) { throw ex; } } }
//Update public Patient GetPatientDetails(int patientID) { using (var connection = SqlConnectionFactory.GetConnectionString()) { try { var result = connection.Query <Patient>("[dbo].[GetPatientByID]", new { PatientID = patientID }, commandType: CommandType.StoredProcedure); return(result.FirstOrDefault()); } catch (Exception ex) { throw ex; } } }
//Update public Staff GettingStaffDetails(int StaffID) { using (var connection = SqlConnectionFactory.GetConnectionString()) { try { var result = connection.Query <Staff>("[dbo].[GetStaffByID]", new { StaffID = StaffID }, commandType: CommandType.StoredProcedure); return(result.FirstOrDefault()); } catch (Exception ex) { throw ex; } } }
public Patient UpdateOfPatient(Patient patient) { using (var connection = SqlConnectionFactory.GetConnectionString()) { try { var result = connection.Query <Patient>("[dbo].[UpdatePatient]", new { PatientID = patient.PatientID, FirstName = patient.FirstName, LastName = patient.LastName, NhsNumber = patient.NhsNumber }, commandType: CommandType.StoredProcedure); return(result.FirstOrDefault()); } catch (Exception ex) { throw ex; } } }
public void InsertPatient(Patient patient) { using (var connection = SqlConnectionFactory.GetConnectionString()) { try { connection.Query("[dbo].[InsertPatient]", new { FirstName = patient.FirstName, LastName = patient.LastName, DateOfBirth = patient.DateOfBirth, NhsNumber = patient.NhsNumber }, commandType: CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } } }
public void InsertAppointment(Appointment appointment) { using (var connection = SqlConnectionFactory.GetConnectionString()) { try { connection.Query("[dbo].[InsertAppointment]", new { PatientID = appointment.PatientID, StaffID = appointment.SelectedStaff, AppointmentDate = appointment.AppointmentDate, AppointmentTimeID = appointment.SelectedAppointmentTime }, commandType: CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } } }