public void Update(INTUSOFT.Data.Model.Patient _patient) { using (ISession session = NHibernateHelper.OpenSession()) using (ITransaction transaction = session.BeginTransaction()) { session.Update(_patient); transaction.Commit(); } }
public static void AddPatient(INTUSOFT.Data.Model.Patient patient) { DataVariables._patientRepo.Add(patient); DataVariables.Active_Patient = patient; DataVariables.Patients.Add(DataVariables.Active_Patient); DataVariables.Patients = DataVariables.Patients.Where(x => x.HideShowRow == false).ToList();//.OrderByDescending(x => x.RegistrationDateTime < DateTime.Now).ToList(); DataVariables.Patients.Sort((x, y) => x.RegistrationDateTime.CompareTo(y.RegistrationDateTime)); DataVariables.Patients.Reverse(); }
public void Remove(INTUSOFT.Data.Model.Patient _patient) { _patient.HideShowRow = true; //using (ISession session = NHibernateHelper.OpenSession()) //using (ITransaction transaction = session.BeginTransaction()) { // session.Delete(_patient); //transaction.Commit(); Update(_patient); } }
public bool Add(INTUSOFT.Data.Model.Patient _patient) { try { using (ISession session = NHibernateHelper.OpenSession()) using (ITransaction transaction = session.BeginTransaction()) { session.Save(_patient); transaction.Commit(); } return(true); } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } }
public INTUSOFT.Data.Model.Patient GetByName(string name) { using (ISession session = NHibernateHelper.OpenSession()) { DetachedCriteria criteria = null; if (!string.IsNullOrEmpty(name)) { criteria = DetachedCriteria.For(typeof(INTUSOFT.Data.Model.Patient)); criteria.Add(Expression.Eq("HideShowRow", false)); } INTUSOFT.Data.Model.Patient _patient = criteria.GetExecutableCriteria(session).UniqueResult <INTUSOFT.Data.Model.Patient>(); //return pats; // _patient = session // .CreateCriteria(typeof(Patient)) // .Add(Restrictions.Eq("Name", name)Restrictions.Eq() // .UniqueResult<Patient>(); return(_patient); } }
public ICollection <INTUSOFT.Data.Model.Patient> Search(INTUSOFT.Data.Model.Patient _patient) { using (ISession session = NHibernateHelper.OpenSession()) { //The below code has been modified by assing var disjunction to solve Defect no0000080 to add or implementation in search. var criteria = session.CreateCriteria <INTUSOFT.Data.Model.Patient>(); var disjunction = Restrictions.Disjunction(); if (_patient.ID != 0) { disjunction.Add(Restrictions.Eq("Id", _patient.ID)); } if (!string.IsNullOrEmpty(_patient.MRN)) { disjunction.Add(Restrictions.Like("MRN", _patient.MRN, MatchMode.Anywhere)); } if (!string.IsNullOrEmpty(_patient.FirstName)) { disjunction.Add(Restrictions.Like("FirstName", _patient.FirstName, MatchMode.Anywhere)); } if (!string.IsNullOrEmpty(_patient.LastName)) { disjunction.Add(Restrictions.Like("LastName", _patient.LastName, MatchMode.Anywhere)); } if (!string.IsNullOrEmpty(_patient.Gender)) { disjunction.Add(Restrictions.Eq("Gender", _patient.Gender)); } if ((DateTime.Now.Year - _patient.DOB.Year) > 3) { disjunction.Add(Restrictions.Eq("DOB", _patient.DOB)); } IList <INTUSOFT.Data.Model.Patient> pats = criteria.Add(disjunction).List <INTUSOFT.Data.Model.Patient>().Where(x => x.HideShowRow == false).ToList();; return(pats); } }