Exemplo n.º 1
0
        public override TransportCompany FindByName(string name)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    bool exist = ((TBContext)context).TransportCompany.Any(u => u.CompanyName == name);
                    if (exist)
                    {
                        TransportCompany query = ((TBContext)context).TransportCompany.First(u => u.CompanyName == name);
                        return(query);
                    }
                    else
                    {
                        return(null);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Exemplo n.º 2
0
        public override Transport FindByName(string name)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    bool exist = ((TBContext)context).Transport.Any(u => u.Description == name);
                    if (exist)
                    {
                        Transport query = ((TBContext)context).Transport.Include(x => x.DestinationCity).Include(x => x.OriginCity).First(u => u.Description == name);
                        return(query);
                    }
                    else
                    {
                        return(null);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public Product FindByCode(string code)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    bool exist = ((TBContext)context).Product.Any(u => u.ProductCode == code);
                    if (exist)
                    {
                        Product query = ((TBContext)context).Product.Include(x => x.Hotel).Include(x => x.Transport).Include(x => x.SportEvent).First(u => u.ProductCode == code);
                        return(query);
                    }
                    else
                    {
                        return(null);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public override AppUser FindByName(string name)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    bool exist = ((TBContext)context).AppUser.Any(u => u.Name == name);
                    if (exist)
                    {
                        AppUser query = ((TBContext)context).AppUser.Include(x => x.City).First(u => u.Name == name);
                        return(query);
                    }
                    else
                    {
                        return(null);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public override RoomBooking FindByName(string name)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    bool exist = ((TBContext)context).RoomBooking.Any(u => u.Room.Name == name);
                    if (exist)
                    {
                        RoomBooking query = ((TBContext)context).RoomBooking.Include(x => x.Room).Include(x => x.Hotel).First(u => u.Room.Name == name);
                        return(query);
                    }
                    else
                    {
                        return(null);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Exemplo n.º 6
0
        public override TransportCompany FindById(int id)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    TransportCompany query = ((TBContext)context).TransportCompany.First(u => u.Id == id);
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Exemplo n.º 7
0
        public override List <TransportCompany> GetAll(Expression <Func <TransportCompany, bool> > Predicate)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    var query = context.Set <TransportCompany>().Where(Predicate).ToList();
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public override PurchaseOrderDetail FindByName(string name)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    PurchaseOrderDetail query = ((TBContext)context).PurchaseOrderDetail.Include(x => x.Product).First(u => u.Description == name);
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public override void Update(PurchaseOrderDetail entity)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    context.Entry(entity).State = EntityState.Modified;
                    context.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public override PurchaseOrder FindById(int id)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    PurchaseOrder query = ((TBContext)context).PurchaseOrder.Include(x => x.PurchaseOrderDetails).First(u => u.Id == id);
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public List <PurchaseOrder> GetPurchaseOrderbyProductId(int id, DateTime starDate, DateTime endDate)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    var list = context.Set <PurchaseOrder>().Where(x => x.CreationDate >= starDate && x.CreationDate <= endDate).Include(x => x.PurchaseOrderDetails.Select(y => y.ProductId == id)).ToList();
                    return(list);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public override List <RoomBooking> GetAll(Expression <Func <RoomBooking, bool> > Predicate)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    var query = context.Set <RoomBooking>().Include(x => x.Room).Include(x => x.Hotel).Where(Predicate).ToList();
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Exemplo n.º 13
0
        public override List <AppUser> GetAll()
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    var query = context.Set <AppUser>().Include(x => x.City).ToList();
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public override List <RoomBooking> GetAll()
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    var query = context.Set <RoomBooking>().ToList();
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public List <PurchaseOrder> FindByCustomerId(int id)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    List <PurchaseOrder> query = ((TBContext)context).PurchaseOrder.Include(x => x.PurchaseOrderDetails.Select(z => z.Product)).Where(u => u.CustomerId == id).ToList();
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Exemplo n.º 16
0
        public override Transport FindById(int id)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    Transport query = ((TBContext)context).Transport.Include(x => x.DestinationCity).Include(x => x.OriginCity).First(u => u.Id == id);
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public override List <PurchaseOrder> GetAll(Expression <Func <PurchaseOrder, bool> > Predicate)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    var query = context.Set <PurchaseOrder>().Where(Predicate).Include(x => x.PurchaseOrderDetails.Select(y => y.Product)).ToList();
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public override RoomBooking FindById(int id)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    RoomBooking query = ((TBContext)context).RoomBooking.Include(x => x.Room).Include(x => x.Hotel).First(u => u.Id == id);
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Exemplo n.º 19
0
        public override AppUser FindById(int id)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    AppUser query = ((TBContext)context).AppUser.First(u => u.Id == id);
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Exemplo n.º 20
0
        public override List <Transport> GetAll(Expression <Func <Transport, bool> > Predicate)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    var query = context.Set <Transport>().Include(x => x.DestinationCity).Include(x => x.OriginCity).Where(Predicate).ToList();
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public override SportEvent FindById(int id)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    SportEvent query = ((TBContext)context).SportEvent.Include(x => x.City).First(u => u.Id == id);
                    return(query);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public override int Add(PurchaseOrderDetail entity)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    ((TBContext)context).PurchaseOrderDetail.Add(entity);

                    return(entity.Id);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Exemplo n.º 23
0
        public override int Add(AppUser entity)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    context.Set <AppUser>().Add(entity);
                    context.SaveChanges();
                    int id = entity.Id;
                    return(id);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Exemplo n.º 24
0
        public override void Update(AppUser entity)
        {
            try
            {
                if (context == null || IsDisposed())
                {
                    context = new TBContext();
                }

                using (context)
                {
                    var itemEntity = ((TBContext)context).AppUser.First(x => x.Id == entity.Id);
                    var item       = context.Entry <AppUser>(itemEntity);
                    item.State = EntityState.Modified;

                    itemEntity.Names        = entity.Names;
                    itemEntity.Surname      = entity.Surname;
                    itemEntity.MobileNumber = entity.MobileNumber;
                    itemEntity.Phone        = entity.Phone;
                    itemEntity.Address1     = entity.Address1;
                    itemEntity.Address2     = entity.Address2;
                    itemEntity.Genre        = entity.Genre;
                    itemEntity.Category     = entity.Category;
                    itemEntity.Email        = entity.Email;
                    itemEntity.City         = entity.City;



                    context.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
 public RoomBookingRepository(TBContext context) : base(context)
 {
 }
Exemplo n.º 26
0
 public AppUserRepository(TBContext context) : base(context)
 {
 }
Exemplo n.º 27
0
 public CityRepository(TBContext context) : base(context)
 {
 }
Exemplo n.º 28
0
 public ProductRepository(TBContext context) : base(context)
 {
 }
Exemplo n.º 29
0
 public TransportRepository(TBContext context) : base(context)
 {
 }
 public SportEventRepository(TBContext context) : base(context)
 {
 }