public User GetUsersByID(int userID) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var objUser = session.Query <User>().Where(x => x.UserID == userID).FirstOrDefault(); return(objUser); } } }
public List <PatientMedicine> GetMedicinesByUserID(int userID) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var results = session.Query <PatientMedicine>().Where(x => x.UserID == userID).ToList(); return(results); } } }
public PatientMedicine GetMedicinesByAppointmnetID(int appointmentID) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var results = session.Query <PatientMedicine>().Where(x => x.AppointmentID == appointmentID).FirstOrDefault(); return(results); } } }
public PatientMedicine GetMedicineByID(int patientMedicineID) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var objMedicine = session.Query <PatientMedicine>().Where(x => x.PatientMedicineID == patientMedicineID).FirstOrDefault(); return(objMedicine); } } }
public User ValidateUser(string userName, string password) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var objUser = session.Query <User>().Where(x => x.UserName == userName && x.Password == password).FirstOrDefault(); return(objUser); } } }
public Roles GetRolesByID(int roleID) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var objRole = session.Query <Roles>().Where(x => x.RoleID == roleID).FirstOrDefault(); return(objRole); } } }
public List <Appointment> GetAppointmentsByDoctorID(int doctorID, DateTime date) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var objAppointment = session.Query <Appointment>().Where(x => x.DoctorID == doctorID && x.AppDate == date).ToList(); return(objAppointment); } } }
public List <Appointment> GetAppointmentByUserID(int userID) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var objAppointment = session.Query <Appointment>().Where(x => x.UserID == userID).ToList(); return(objAppointment); } } }
public List <DoctorCalendar> GetDoctorCalendar(int doctorID, DateTime date, int hospitalID) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var results = session.Query <DoctorCalendar>().Where(x => x.DoctorID == doctorID && x.Date == date && x.HospitalID == hospitalID).ToList(); return(results); } } }
public Appointment GetAppointmentByID(int appointmentID) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var objAppointment = session.Query <Appointment>().Where(x => x.AppointmentID == appointmentID).FirstOrDefault(); return(objAppointment); } } }
public IEnumerable <T> GetAll() { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var results = session.QueryOver <T>().List(); return(results); } } }
public DoctorCalendar GetDoctorCalendarByID(int doctorCalendarID) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var objDoctorCalendar = session.Query <DoctorCalendar>().Where(x => x.DoctorCalendarID == doctorCalendarID).FirstOrDefault(); return(objDoctorCalendar); } } }
public LoginHistory GetLoginHistoryByID(int loginHistoryID) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var objloginHistory = session.Query <LoginHistory>().Where(x => x.LoginHistoryID == loginHistoryID).FirstOrDefault(); return(objloginHistory); } } }
public void Delete(T obj) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { sessionWrapper.BeginTransaction(); using (var session = sessionWrapper.Session) { session.Delete(obj); sessionWrapper.Commit(); } } }
public List <Doctor> GetDoctorsBySpecialization(string specialist) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var query = session.Query <Doctor>().Where(x => x.Specialist.Contains(specialist)).ToList(); return(query); } } }
public List <Doctor> GetDoctorsByHospitalID(int hospitalID) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var query = "select d.* from doctor d join DoctorCalendar dc on dc.DoctorID = d.DoctorID inner join Hospital h on h.HospitalID = dc.HospitalID where h.HospitalID =" + hospitalID; var results = session.CreateSQLQuery(query).AddEntity(typeof(Doctor)).List <Doctor>().ToList(); return(results); } } }
public T SaveorUpdate(T obj) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { sessionWrapper.BeginTransaction(); using (var session = sessionWrapper.Session) { session.SaveOrUpdate(obj); sessionWrapper.Commit(); } } return(obj); }
public User GetUsersByDoctorID(int doctorID) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var query = "select u.* from UserTable u join Doctor d on u.UserID = d.UserID where d.DoctorID =" + doctorID; var results = session.CreateSQLQuery(query).AddEntity(typeof(User)).List <User>().FirstOrDefault(); return(results); } } }
public List <DoctorAppointment> GetAppointments(int doctorID, DateTime date) { using (SessionWrapper sessionWrapper = new SessionWrapper()) { using (var session = sessionWrapper.Session) { var query = "select d.DoctorID,a.UserID,a.AppointmentID,(u.FirstName + ' ' + u.LastName ) as UserName, a.StartTime,a.EndTime,h.Name,dc.Date from Doctor d" + "join Appointment a on d.DoctorID = a.DoctorID" + "join DoctorCalendar dc on dc.DoctorID = a.DoctorID" + "join Hospital h on h.HospitalID = dc.HospitalID" + "join UserTable u on u.UserID = a.UserID" + "where AppointmnetDate =" + date + "and d.doctorId =" + doctorID; var results = session.CreateSQLQuery(query).AddEntity(typeof(DoctorAppointment)).List <DoctorAppointment>().ToList(); return(results); } } }