Exemplo n.º 1
0
 public void Delete(BouquetBindingModel model)
 {
     using (var context = new FlowerShopDatabase())
     {
         using (var transaction = context.Database.BeginTransaction())
         {
             try
             {
                 context.FlowerBouquets.RemoveRange(context.FlowerBouquets.Where(rec =>
                                                                                 rec.BouquetId == model.Id));
                 context.PackagingBouquets.RemoveRange(context.PackagingBouquets.Where(rec =>
                                                                                       rec.BouquetId == model.Id));
                 Bouquet element = context.Bouquets.FirstOrDefault(rec => rec.Id
                                                                   == model.Id);
                 if (element != null)
                 {
                     context.Bouquets.Remove(element);
                     context.SaveChanges();
                 }
                 else
                 {
                     CheckingElement(element);
                 }
                 transaction.Commit();
             }
             catch (Exception)
             {
                 transaction.Rollback();
                 throw;
             }
         }
     }
 }
Exemplo n.º 2
0
        /// <summary>
        /// Конструктор класса <see cref="Bouquet"/>
        /// </summary>
        public static void DefBouquet()
        {
            Bouquet bouquet1 = new Bouquet();
            int     counter  = 0;

            //  вызов одноименных методов
            //bouquet1.Note();
            //((IPaper)bouquet1).Note();

            ((IPaper)bouquet1).Color = "Красный";
            bouquet1.Price           = 17.4F;
            bouquet1.Flowers         = new List <Flower>();
            bouquet1.Flowers.AddFlower();

            Console.WriteLine("--------------------------------------");
            Console.WriteLine($"Цвет обертки букета: {bouquet1.Color}\nЦена букета: {bouquet1.Price}\n");
            foreach (var flower in bouquet1.Flowers)
            {
                Console.WriteLine($"{counter}) {flower.Name}    {flower.Size}   {flower.Color}");
                counter++;
            }
            Console.WriteLine("--------------------------------------");


            bouquet1.Flowers.DeleteFlower();
        }
Exemplo n.º 3
0
        public void RemoveItemFromSessionCart(ISession session, Bouquet bouquet)
        {
            CartViewModel sessionCart = this.GetCartFromSession(session);

            sessionCart.items.Remove(bouquet);
            session.SetObjectAsJson("cart", sessionCart);
        }
Exemplo n.º 4
0
        /// <summary>
        /// Сортировки листа
        /// </summary>
        public static void CallSort()
        {
            Bouquet bouquet = new Bouquet();

            ((IPaper)bouquet).Color = "Красный";
            bouquet.Price           = 16.26F;
            bouquet.Flowers         = new List <Flower>()
            {
                new Flower {
                    Name = "Цветок 1", Color = (Colors)2, Size = 5
                },
                new Flower {
                    Name = "Цветок 2", Color = (Colors)2, Size = 4
                },
                new Flower {
                    Name = "Цветок 3", Color = (Colors)3, Size = 3
                },
                new Flower {
                    Name = "Цветок 4", Color = (Colors)4, Size = 2
                },
                new Flower {
                    Name = "Цветок 5", Color = (Colors)5, Size = 1
                }
            };

            BouquetController.SortListByParam(bouquet);
            BouquetController.FindByColor(bouquet);
        }
Exemplo n.º 5
0
        public static void DefBouquet()
        {
            Bouquet bouquet1 = new Bouquet();

            //  вызов одноименных методов
            bouquet1.Note();
            ((IPaper)bouquet1).Note();

            bouquet1.Color = "Красный";
            bouquet1.Price = 17.4F;
            bouquet1.SeNumberOfFlowers(ref bouquet1.flowers, 3);

            Console.WriteLine("--------------------------------------");
            Console.WriteLine($"Цвет обертки букета: {bouquet1.Color}\nЦена букета: {bouquet1.Price}\n");
            int counter = 1;

            foreach (var flwr in bouquet1.flowers)
            {
                Console.WriteLine($"Цветок {counter++}\nНазвание цветка: {flwr.Name}\nРазмер цветка: {flwr.Size}\n");
            }
            Console.WriteLine("--------------------------------------");

            //Bouquet bouquet2 = new Bouquet();
            //bouquet2.Color = "Красный";
            //bouquet2.Price = 17.4F;
            //bouquet2.SeNumberOfFlowers(ref bouquet2.flowers, 1);
        }
Exemplo n.º 6
0
        public async Task <ActionResult> PostBouquet(Bouquet bouquet)
        {
            database.Bouquets.Add(bouquet);
            await database.SaveChangesAsync();

            return(Accepted());
        }
Exemplo n.º 7
0
        public IActionResult RemoveBouquet(string bouquetId)
        {
            ISession session = HttpContext.Session;
            Bouquet  bouquet = _bouquetStorage.FindById(bouquetId);

            _sessionCartStorage.RemoveItemFromSessionCart(session, bouquet);
            return(RedirectToAction("Index", "Cart"));
        }
Exemplo n.º 8
0
        public Bouquet Update(Bouquet updatedBouquet)
        {
            var bouquet = context.Bouquets.Attach(updatedBouquet);

            bouquet.State = Microsoft.EntityFrameworkCore.EntityState.Modified;
            context.SaveChanges();
            return(updatedBouquet);
        }
        public IActionResult RemoveItem(string bouquetId)
        {
            ISession session = HttpContext.Session;
            Bouquet  bouquet = this.bouquetManager.GetBouquetById(bouquetId);

            this.sessionCartService.RemoveItemFromSessionCart(session, bouquet);
            return(RedirectToAction("Index", "Cart"));
        }
Exemplo n.º 10
0
        public ActionResult DeleteConfirmed(int id)
        {
            Bouquet bouquet = db.Bouquets.Find(id);

            db.Bouquets.Remove(bouquet);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public void RemoveBouquetById(string id)
        {
            Bouquet bouquet = this.GetBouquetById(id);

            if (bouquet != null)
            {
                this.bouquetStorage.RemoveBouquet(bouquet);
            }
        }
Exemplo n.º 12
0
        //edit/put
        internal Bouquet Edit(Bouquet updatedBouquet)
        {
            Bouquet found = Get(updatedBouquet.Id);

            found.Name        = updatedBouquet.Name;
            found.Description = updatedBouquet.Description != null ? updatedBouquet.Description : found.Description;
            found.Price       = updatedBouquet.Price != 0 ? updatedBouquet.Price : found.Price;
            return(_repo.Edit(found));
        }
Exemplo n.º 13
0
        //create/post
        internal Bouquet Create(Bouquet newBouquet)
        {
            Bouquet created = _repo.Create(newBouquet);

            if (created == null)
            {
                throw new Exception("Create Request Failed");
            }
            return(created);
        }
Exemplo n.º 14
0
        //Get by id
        internal Bouquet Get(int id)
        {
            Bouquet found = _repo.Get(id);

            if (found == null)
            {
                throw new Exception("Invalid Id");
            }
            return(found);
        }
Exemplo n.º 15
0
 public ActionResult Edit([Bind(Include = "BouquetID,BouquetName,Description,Price")] Bouquet bouquet)
 {
     if (ModelState.IsValid)
     {
         db.Entry(bouquet).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(bouquet));
 }
Exemplo n.º 16
0
 public ActionResult Edit([Bind(Include = "BouquetId,BouquetName")] BouquetViewModel bouquetModel)
 {
     if (ModelState.IsValid)
     {
         var bouquet = new Bouquet();
         bouquet.Name = bouquetModel.BouquetName;
         _bouquetService.Update(bouquet);
         return(RedirectToAction("Index"));
     }
     return(View(bouquetModel));
 }
        public ActionResult <Bouquet> EditBouquet(int id, Bouquet bouquet)
        {
            string query = @"
UPDATE bouquets SET
name = @Name
WHERE id = @Id;
SELECT * FROM bouquets WHERE id = @Id;
";

            return(_db.QueryFirstOrDefault <Bouquet>(query, bouquet));
        }
Exemplo n.º 18
0
        public Bouquet Create(Bouquet value)
        {
            string query = @"
            INSERT INTO bouquets (name, storeId)
                    VALUES (@Name, @StoreId);
                    SELECT LAST_INSERT_ID();";
            int    id    = _db.ExecuteScalar <int>(query, value);

            value.Id = id;
            return(value);
        }
Exemplo n.º 19
0
        public Bouquet GetById(int id)
        {
            string  query   = "SELECT * FROM bouquets WHERE id = @id";
            Bouquet bouquet = _db.QueryFirstOrDefault <Bouquet>(query, new { id });

            if (bouquet == null)
            {
                throw new Exception("Invalid Id");
            }
            return(bouquet);
        }
Exemplo n.º 20
0
        public void AddToSessionCart(ISession session, Bouquet bouquet)
        {
            var sessionCart = session.GetObjectFromJson <CartViewModel>("cart");

            if (sessionCart == null)
            {
                sessionCart = new CartViewModel();
            }
            sessionCart.items.Add(bouquet);
            session.SetObjectAsJson("cart", sessionCart);
        }
Exemplo n.º 21
0
 public ActionResult <Bouquet> Create([FromBody] Bouquet newBouquet)
 {
     try
     {
         return(Ok(_bs.Create(newBouquet)));
     }
     catch (Exception e)
     {
         return(BadRequest(e.Message));
     }
 }
Exemplo n.º 22
0
        //Post
        internal Bouquet Create(Bouquet newBouquet)
        {
            string sql = @"
      INSERT INTO bouquets (name, description, price)
      VALUES (@Name, @Description, @Price);
      SELECT LAST_INSERT_ID();
      ";

            newBouquet.Id = _db.ExecuteScalar <int>(sql, newBouquet);
            return(newBouquet);
        }
Exemplo n.º 23
0
        public Bouquet Delete(int id)
        {
            Bouquet bouquet = context.Bouquets.Find(id);

            if (bouquet != null)
            {
                context.Bouquets.Remove(bouquet);
                context.SaveChanges();
            }
            return(bouquet);
        }
Exemplo n.º 24
0
        public ActionResult Create([Bind(Include = "BouquetID,BouquetName,Description,Price")] Bouquet bouquet)
        {
            if (ModelState.IsValid)
            {
                db.Bouquets.Add(bouquet);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(bouquet));
        }
Exemplo n.º 25
0
 public ActionResult <Bouquet> Post([FromBody] Bouquet value)
 {
     try
     {
         return(Ok(_repo.Create(value)));
     }
     catch (Exception e)
     {
         return(BadRequest(e));
     }
 }
Exemplo n.º 26
0
        public Bouquet Update(Bouquet value)
        {
            string query = @"
            UPDATE bouquets
            SET
                name = @Name,
                storeId = @StoreId
            WHERE id = @Id;            
            SELECT * FROM bouquets WHERE id = @Id";

            return(_db.QueryFirstOrDefault <Bouquet>(query, value));
        }
Exemplo n.º 27
0
 public ActionResult <Bouquet> Edit(int id, [FromBody] Bouquet updatedBouquet)
 {
     try
     {
         updatedBouquet.Id = id;
         return(Ok(_bs.Edit(updatedBouquet)));
     }
     catch (Exception e)
     {
         return(BadRequest(e.Message));
     }
 }
Exemplo n.º 28
0
        public async Task <IActionResult> PutBouquet(int id, Bouquet bouquet)
        {
            if (id != bouquet.Id)
            {
                return(BadRequest());
            }

            database.Entry(bouquet).State = EntityState.Modified;
            await database.SaveChangesAsync();

            return(NoContent());
        }
Exemplo n.º 29
0
 public ActionResult <Bouquet> Put(int id, [FromBody] Bouquet value)
 {
     try
     {
         value.Id = id;
         return(Ok(_repo.Update(value)));
     }
     catch (Exception e)
     {
         return(BadRequest(e));
     }
 }
Exemplo n.º 30
0
        /// <summary>
        ///  <para>Работа с объектом через ссылку на интерфейс и абстрактный класс</para>
        ///  <para>Работа is и as</para>
        /// </summary>
        public static void ObjViaRefInterface()
        {
            IPaper paper = new Bouquet();

            paper.Color = "Зеленый";
            Console.WriteLine($"\nЦвет: {paper.Color}");
            paper.Note();

            Plant plant = new Bouquet();

            plant.Name = "Ромашка";
            Console.WriteLine($"\nНазвание: {plant.Name}");
            plant.Note();

            Plant plant1 = new Rose();

            plant1.Name = "Роза";
            plant1.Size = 2.43;
            Console.WriteLine($"\nНазвание: {plant1.Name}\nРазмер: {plant1.Size}");
            plant1.Note();
            Console.WriteLine($"{plant1.ToString()}");

            Flower  flower  = new Flower();
            Bouquet bouquet = new Bouquet();

            int num = 2;
            //bool checkFlower = flower is Flower;
            //bool checkBouquet = bouquet is Bouquet;
            //bool checkNum = num is Flower;

            bool checkFlower  = bouquet is Flower;
            bool checkBouquet = flower is Bouquet;

            Console.WriteLine($"\ncheckFlower: {checkBouquet}\ncheckBouquet: {checkFlower}\ncheckNum:");


            try
            {
                Flower flower1 = new Flower();
                Rose   rose    = flower1 as Rose;
                Console.WriteLine($"\n{rose.GetType()}");
            }
            catch (NullReferenceException e)
            {
                Console.WriteLine(e);
            }

            Rose   rose1   = new Rose();
            Flower flower2 = rose1 as Flower;

            Console.WriteLine($"\n{flower2.GetType()}");
        }
Exemplo n.º 31
0
        public BouquetDTO(Bouquet b)
        {
            this.IsNew = b.IsNew;
            this.Id = b.Id;
            this.ImgUrl = b.ImgUrl;
            this.Name = b.Name;
            this.Url = this.Name.RemoveDiacritics();
            this.Description = b.Description;
            Components = new List<ComponentDTO>();
            Sizes = new List<SizeDTO>();

            if(b.BouquetSizes != null)
                foreach(var s in b.BouquetSizes)
                    this.Sizes.Add(new SizeDTO(s));

            if (b.Components != null)
                foreach (var s in b.Components)
                    this.Components.Add(new ComponentDTO(s));
        }
Exemplo n.º 32
0
        /// <summary>
        /// Process the bouquet data.
        /// </summary>
        /// <param name="sections">A collection of MPEG2 sections containing the bouquet data.</param>
        protected override void ProcessBouquetSections(Collection<Mpeg2Section> sections)
        {
            foreach (Mpeg2Section section in sections)
            {
                if (RunParameters.Instance.TraceIDs.Contains("BOUQUETSECTIONS"))
                    Logger.Instance.Dump("Bouquet Section", section.Data, section.Length);

                BouquetAssociationSection bouquetSection = BouquetAssociationSection.ProcessBouquetAssociationTable(section.Data);
                if (bouquetSection != null)
                {
                    bool added = BouquetAssociationSection.AddSection(bouquetSection);
                    if (added)
                    {
                        if (bouquetSection.TransportStreams != null)
                        {
                            foreach (TransportStream transportStream in bouquetSection.TransportStreams)
                            {
                                if (transportStream.Descriptors != null)
                                {
                                    foreach (DescriptorBase descriptor in transportStream.Descriptors)
                                    {
                                        FreeSatChannelInfoDescriptor freeSatInfoDescriptor = descriptor as FreeSatChannelInfoDescriptor;
                                        if (freeSatInfoDescriptor != null)
                                        {
                                            if (freeSatInfoDescriptor.ChannelInfoEntries != null)
                                            {
                                                foreach (FreeSatChannelInfoEntry channelInfoEntry in freeSatInfoDescriptor.ChannelInfoEntries)
                                                {
                                                    FreeSatChannel channel = new FreeSatChannel();
                                                    channel.OriginalNetworkID = transportStream.OriginalNetworkID;
                                                    channel.TransportStreamID = transportStream.TransportStreamID;
                                                    channel.ServiceID = channelInfoEntry.ServiceID;
                                                    channel.UserChannel = channelInfoEntry.UserNumber;
                                                    channel.Unknown1 = channelInfoEntry.Unknown1;
                                                    channel.Unknown2 = channelInfoEntry.Unknown2;
                                                    channel.BouquetID = bouquetSection.BouquetID;
                                                    FreeSatChannel.AddChannel(channel);

                                                    Bouquet bouquet = Bouquet.FindBouquet(channel.BouquetID);
                                                    if (bouquet == null)
                                                    {
                                                        bouquet = new Bouquet(channel.BouquetID, BouquetAssociationSection.FindBouquetName(channel.BouquetID));
                                                        Bouquet.AddBouquet(bouquet);
                                                    }

                                                    Region region = bouquet.FindRegion(channel.Region);
                                                    if (region == null)
                                                    {
                                                        region = new Region(string.Empty, channel.Region);
                                                        bouquet.AddRegion(region);
                                                    }

                                                    region.AddChannel(channel);
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
Exemplo n.º 33
0
        private void processFreeviewInfoDescriptor(FreeviewChannelInfoDescriptor freeviewInfoDescriptor, int originalNetworkID, int transportStreamID, int bouquetID)
        {
            if (freeviewInfoDescriptor.ChannelInfoEntries == null)
                return;

            if (openTVChannels != 0)
                return;

            foreach (FreeviewChannelInfoEntry channelInfoEntry in freeviewInfoDescriptor.ChannelInfoEntries)
            {
                EITChannel channel = new EITChannel();
                channel.OriginalNetworkID = originalNetworkID;
                channel.TransportStreamID = transportStreamID;
                channel.ServiceID = channelInfoEntry.ServiceID;
                channel.UserChannel = channelInfoEntry.UserNumber;
                channel.Flags = channelInfoEntry.Flags;
                channel.BouquetID = bouquetID;
                EITChannel.AddChannel(channel);

                eitChannels++;

                Bouquet bouquet = Bouquet.FindBouquet(channel.BouquetID);
                if (bouquet == null)
                {
                    bouquet = new Bouquet(channel.BouquetID, BouquetAssociationSection.FindBouquetName(channel.BouquetID));
                    Bouquet.AddBouquet(bouquet);
                }

                Region region = bouquet.FindRegion(channel.Region);
                if (region == null)
                {
                    region = new Region(string.Empty, channel.Region);
                    bouquet.AddRegion(region);
                }

                region.AddChannel(channel);
            }
        }
Exemplo n.º 34
0
        private void processOpenTVInfoDescriptor(OpenTVChannelInfoDescriptor openTVInfoDescriptor, int originalNetworkID, int transportStreamID, int bouquetID)
        {
            if (openTVInfoDescriptor.ChannelInfoEntries == null)
                return;

            if (eitChannels != 0)
            {
                OpenTVChannel.Channels.Clear();
                eitChannels = 0;
                return;
            }

            foreach (OpenTVChannelInfoEntry channelInfoEntry in openTVInfoDescriptor.ChannelInfoEntries)
            {
                OpenTVChannel channel = new OpenTVChannel();
                channel.OriginalNetworkID = originalNetworkID;
                channel.TransportStreamID = transportStreamID;
                channel.ServiceID = channelInfoEntry.ServiceID;
                channel.ChannelID = channelInfoEntry.ChannelID;
                channel.UserChannel = channelInfoEntry.UserNumber;
                channel.Type = channelInfoEntry.Type;
                channel.Flags = channelInfoEntry.Flags;
                channel.BouquetID = bouquetID;
                channel.Region = openTVInfoDescriptor.Region;
                OpenTVChannel.AddChannel(channel);

                openTVChannels++;

                Bouquet bouquet = Bouquet.FindBouquet(channel.BouquetID);
                if (bouquet == null)
                {
                    bouquet = new Bouquet(channel.BouquetID, BouquetAssociationSection.FindBouquetName(channel.BouquetID));
                    Bouquet.AddBouquet(bouquet);
                }

                Region region = bouquet.FindRegion(channel.Region);
                if (region == null)
                {
                    region = new Region(string.Empty, channel.Region);
                    bouquet.AddRegion(region);
                }

                region.AddChannel(channel);
            }
        }
Exemplo n.º 35
0
        /// <summary>
        /// Process the bouquet data.
        /// </summary>
        /// <param name="sections">A collection of MPEG2 sections containing the bouquet data.</param>
        protected override void ProcessBouquetSections(Collection<Mpeg2Section> sections)
        {
            foreach (Mpeg2Section section in sections)
            {
                BouquetAssociationSection bouquetSection = BouquetAssociationSection.ProcessBouquetAssociationTable(section.Data);
                if (bouquetSection != null)
                {
                    bool added = BouquetAssociationSection.AddSection(bouquetSection);
                    if (added)
                    {
                        if (bouquetSection.TransportStreams != null)
                        {
                            foreach (TransportStream transportStream in bouquetSection.TransportStreams)
                            {
                                if (transportStream.Descriptors != null)
                                {
                                    foreach (DescriptorBase descriptor in transportStream.Descriptors)
                                    {
                                        OpenTVChannelInfoDescriptor infoDescriptor = descriptor as OpenTVChannelInfoDescriptor;
                                        if (infoDescriptor != null)
                                        {
                                            if (infoDescriptor.ChannelInfoEntries != null)
                                            {
                                                foreach (OpenTVChannelInfoEntry channelInfoEntry in infoDescriptor.ChannelInfoEntries)
                                                {
                                                    OpenTVChannel channel = new OpenTVChannel();
                                                    channel.OriginalNetworkID = transportStream.OriginalNetworkID;
                                                    channel.TransportStreamID = transportStream.TransportStreamID;
                                                    channel.ServiceID = channelInfoEntry.ServiceID;
                                                    channel.ChannelID = channelInfoEntry.ChannelID;
                                                    channel.UserChannel = channelInfoEntry.UserNumber;
                                                    channel.Type = channelInfoEntry.Type;
                                                    channel.Flags = channelInfoEntry.Flags;
                                                    channel.BouquetID = bouquetSection.BouquetID;
                                                    channel.Region = infoDescriptor.Region;
                                                    OpenTVChannel.AddChannel(channel);

                                                    Bouquet bouquet = Bouquet.FindBouquet(channel.BouquetID);
                                                    if (bouquet == null)
                                                    {
                                                        bouquet = new Bouquet(channel.BouquetID, BouquetAssociationSection.FindBouquetName(channel.BouquetID));
                                                        Bouquet.AddBouquet(bouquet);
                                                    }

                                                    Region region = bouquet.FindRegion(channel.Region);
                                                    if (region == null)
                                                    {
                                                        region = new Region(string.Empty, channel.Region);
                                                        bouquet.AddRegion(region);
                                                    }

                                                    region.AddChannel(channel);
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
Exemplo n.º 36
0
        /// <summary>
        /// Add a bouquet to the collection.
        /// </summary>
        /// <param name="newBouquet">The bouquet to be added.</param>
        public static void AddBouquet(Bouquet newBouquet)
        {
            foreach (Bouquet oldBouquet in Bouquets)
            {
                if (oldBouquet.BouquetID == newBouquet.BouquetID && oldBouquet.Region == newBouquet.Region)
                    return;
            }

            bouquets.Add(newBouquet);
        }
Exemplo n.º 37
0
        private static void addBouquetInNameOrder(Collection<Bouquet> sortedBouquets, Bouquet newBouquet)
        {
            foreach (Bouquet oldBouquet in sortedBouquets)
            {
                if (oldBouquet.Name.CompareTo(newBouquet.Name) > 0)
                {
                    sortedBouquets.Insert(sortedBouquets.IndexOf(oldBouquet), newBouquet);
                    return;
                }
            }

            sortedBouquets.Add(newBouquet);
        }