public async Task <ActionResult> Quantity(int id) { Shoe_Size_Color shoe_Size_Color = await loadShoeSizeColorQuantity(id); return(PartialView("Quantity", shoe_Size_Color)); }
public void addShoeSizeColor(List <Shoe> shoes, List <Size> sizes, List <Color> colors, List <string> qty) { for (int i = 0; i < shoes.Count; i++) { var shoeToFind = shoes[i].shoeArticle; var sizeToFind = sizes[i].sizeNo; //checked int id = habib.Shoe_Size.Where(c => c.Shoe.shoeArticle == shoeToFind && c.Size.sizeNo == sizeToFind).First().shoeSize_Id; var colorToFind = colors[i].colorName; //checked int count = habib.Shoe_Size_Color.Where(c => c.shoeSize_Id == id && c.color_Id == habib.Colors.Where(x => x.colorName == colorToFind).FirstOrDefault().color_Id).Count(); if (count == 0) { Shoe_Size_Color obj = new Shoe_Size_Color() { shoeSize_Id = id, //checked color_Id = habib.Colors.Where(x => x.colorName == colorToFind).First().color_Id, quantityInWH = Convert.ToInt32(qty[i]) }; habib.Shoe_Size_Color.Add(obj); } else { //checked Shoe_Size_Color obj = habib.Shoe_Size_Color.Where(c => c.shoeSize_Id == id && c.color_Id == habib.Colors.Where(x => x.colorName == colorToFind).FirstOrDefault().color_Id).First(); obj.quantityInWH += Convert.ToInt32(qty[i]); } } habib.SaveChanges(); }
// 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); }
public JsonResult checkQty(string shoeArticle, int size, string color, int qty) { string result = ""; bool isError = false; Shoe_Size_Color shoe = habib.Shoe_Size_Color.Where(c => c.Shoe_Size.Shoe.shoeArticle == shoeArticle && c.Shoe_Size.Size.sizeNo == size && c.Color.colorName == color).First(); if (shoe.quantityInWH < qty) { result = "Shoe article: " + shoeArticle + " of size: " + size.ToString() + " and Color:" + color + " has less " + "quantity than you want to transfer.\n"; isError = true; } return(Json(new { resultString = result, error = isError }, JsonRequestBehavior.AllowGet)); }