public IEnumerable <Hospital> GetAllHospital()
        {
            AllocatDbEntities db = new AllocatDbEntities();

            db.Configuration.ProxyCreationEnabled = false;
            try
            {
                return(db.Hospital.Where(t => t.IsActive == true));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
 public void CreateSession()
 {
     _connection = new AllocatDbEntities();
 }