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));
}
