public bool EditRoute(Route model)
        {
            bool result = false;

            try
            {
                var route = _db.Get <Route>().Where(x => x.Id == model.Id).FirstOrDefault();
                if (route != null)
                {
                    route.Name        = model.Name;
                    route.CardPAN     = model.CardPAN;
                    route.Description = model.Description;
                    route.SinkNode    = model.SinkNode;
                    result            = _db.Update(route);
                    _db.Commit();
                }
                return(result);
            }
            catch (Exception)
            {
                _db.Rollback();
                throw;
            }
        }