コード例 #1
0
        // constructor

        public int TransferShoes(int transferId, int outletId, List <Shoe> shoes, List <Size> sizes, List <Color> colors, List <string> qty)
        {
            int totalQty  = 0;
            var shoeName  = "";
            var sizeNo    = 0;
            var colorName = "";

            using (Habib habib = new Habib())
            {
                for (int i = 0; i < shoes.Count; i++)
                {
                    shoeName  = shoes[i].shoeArticle;
                    sizeNo    = Convert.ToInt32(sizes[i].sizeNo);
                    colorName = colors[i].colorName;
                    totalQty += Convert.ToInt32(qty[i]);

                    Shoe_Size_Color obj = habib.Shoe_Size_Color.Where(c => c.Shoe_Size.Shoe.shoeArticle == shoeName &&
                                                                      c.Shoe_Size.Size.sizeNo == sizeNo && c.Color.colorName == colorName).First();

                    int count = habib.Outlet_ShoeSizeColor.Where(c => c.Shoe_Size_Color.shoeSizeColor_Id == obj.shoeSizeColor_Id &&
                                                                 c.outlet_Id == outletId).Count();

                    if (count == 0)
                    {
                        Outlet_ShoeSizeColor outletShoe = new Outlet_ShoeSizeColor()
                        {
                            outlet_Id        = outletId,
                            shoeSizeColor_Id = obj.shoeSizeColor_Id,
                            quantity         = Convert.ToInt32(qty[i])
                        };

                        habib.Outlet_ShoeSizeColor.Add(outletShoe);
                    }
                    else
                    {
                        Outlet_ShoeSizeColor outletShoe = habib.Outlet_ShoeSizeColor.Where(c => c.shoeSizeColor_Id == obj.shoeSizeColor_Id &&
                                                                                           c.outlet_Id == outletId).First();

                        outletShoe.quantity += Convert.ToInt32(qty[i]);
                    }

                    obj.quantityInWH -= Convert.ToInt32(qty[i]);

                    Transfer_ShoeSizeColor transfer = new Transfer_ShoeSizeColor()
                    {
                        transfer_Id      = transferId,
                        shoeSizeColor_Id = obj.shoeSizeColor_Id,
                        quantity         = Convert.ToInt32(qty[i])
                    };

                    habib.Transfer_ShoeSizeColor.Add(transfer);
                }
                habib.SaveChanges();
            }

            return(totalQty);
        }
コード例 #2
0
 public vendorOrderDataHandler()
 {
     habib = HabibDataClass.Habib;
 }