public async Task <GarmentExpenditureGood> Handle(RemoveGarmentExpenditureGoodCommand request, CancellationToken cancellationToken)
{
var ExpenditureGood = _garmentExpenditureGoodRepository.Query.Where(o => o.Identity == request.Identity).Select(o => new GarmentExpenditureGood(o)).Single();
GarmentComodityPrice garmentComodityPrice = _garmentComodityPriceRepository.Query.Where(a => a.IsValid == true && new UnitDepartmentId(a.UnitId) == ExpenditureGood.UnitId && new GarmentComodityId(a.ComodityId) == ExpenditureGood.ComodityId).Select(s => new GarmentComodityPrice(s)).Single();
Dictionary <Guid, double> finStockToBeUpdated = new Dictionary <Guid, double>();
_garmentExpenditureGoodItemRepository.Find(o => o.ExpenditureGoodId == ExpenditureGood.Identity).ForEach(async expenditureItem =>
{
if (finStockToBeUpdated.ContainsKey(expenditureItem.FinishedGoodStockId))
{
finStockToBeUpdated[expenditureItem.FinishedGoodStockId] += expenditureItem.Quantity;
}
else
{
finStockToBeUpdated.Add(expenditureItem.FinishedGoodStockId, expenditureItem.Quantity);
}
GarmentFinishedGoodStockHistory garmentFinishedGoodStockHistory = _garmentFinishedGoodStockHistoryRepository.Query.Where(a => a.ExpenditureGoodItemId == expenditureItem.Identity).Select(a => new GarmentFinishedGoodStockHistory(a)).Single();
garmentFinishedGoodStockHistory.Remove();
await _garmentFinishedGoodStockHistoryRepository.Update(garmentFinishedGoodStockHistory);
expenditureItem.Remove();
await _garmentExpenditureGoodItemRepository.Update(expenditureItem);
});
foreach (var finStock in finStockToBeUpdated)
{
var garmentFinishingGoodStockItem = _garmentFinishedGoodStockRepository.Query.Where(x => x.Identity == finStock.Key).Select(s => new GarmentFinishedGoodStock(s)).Single();
var qty = garmentFinishingGoodStockItem.Quantity + finStock.Value;
garmentFinishingGoodStockItem.SetQuantity(qty);
garmentFinishingGoodStockItem.SetPrice((garmentFinishingGoodStockItem.BasicPrice + (double)garmentComodityPrice.Price) * (qty));
garmentFinishingGoodStockItem.Modify();
await _garmentFinishedGoodStockRepository.Update(garmentFinishingGoodStockItem);
}
ExpenditureGood.Remove();
await _garmentExpenditureGoodRepository.Update(ExpenditureGood);
_storage.Save();
return(ExpenditureGood);
}
public async Task <GarmentExpenditureGood> Handle(UpdateGarmentExpenditureGoodCommand request, CancellationToken cancellationToken)
{
var ExpenditureGood = _garmentExpenditureGoodRepository.Query.Where(o => o.Identity == request.Identity).Select(o => new GarmentExpenditureGood(o)).Single();
_garmentExpenditureGoodItemRepository.Find(o => o.ExpenditureGoodId == ExpenditureGood.Identity).ForEach(async expenditureItem =>
{
await _garmentExpenditureGoodItemRepository.Update(expenditureItem);
});
ExpenditureGood.SetCarton(request.Carton);
ExpenditureGood.SetExpenditureDate(request.ExpenditureDate);
ExpenditureGood.SetInvoice(request.Invoice);
ExpenditureGood.SetIsReceived(request.IsReceived);
ExpenditureGood.Modify();
await _garmentExpenditureGoodRepository.Update(ExpenditureGood);
_storage.Save();
return(ExpenditureGood);
}
public async Task <GarmentExpenditureGood> Handle(PlaceGarmentExpenditureGoodCommand request, CancellationToken cancellationToken)
{
request.Items = request.Items.ToList();
GarmentComodityPrice garmentComodityPrice = _garmentComodityPriceRepository.Query.Where(a => a.IsValid == true && a.UnitId == request.Unit.Id && a.ComodityId == request.Comodity.Id).Select(s => new GarmentComodityPrice(s)).Single();
GarmentExpenditureGood garmentExpenditureGood = new GarmentExpenditureGood(
Guid.NewGuid(),
GenerateExpenditureGoodNo(request),
request.ExpenditureType,
new UnitDepartmentId(request.Unit.Id),
request.Unit.Code,
request.Unit.Name,
request.RONo,
request.Article,
new GarmentComodityId(request.Comodity.Id),
request.Comodity.Code,
request.Comodity.Name,
new BuyerId(request.Buyer.Id),
request.Buyer.Code,
request.Buyer.Name,
request.ExpenditureDate,
request.Invoice,
request.ContractNo,
request.Carton,
request.Description,
request.IsReceived
);
Dictionary <string, double> finStockToBeUpdated = new Dictionary <string, double>();
Dictionary <Guid, double> finstockQty = new Dictionary <Guid, double>();
foreach (var item in request.Items)
{
if (item.isSave)
{
double StockQty = 0;
var garmentFinishingGoodStock = _garmentFinishedGoodStockRepository.Query.Where(x => x.SizeId == item.Size.Id && x.UomId == item.Uom.Id && x.RONo == request.RONo && x.UnitId == request.Unit.Id && x.Quantity > 0).OrderBy(a => a.CreatedDate).ToList();
double qty = item.Quantity;
foreach (var finishedGood in garmentFinishingGoodStock)
{
if (!finstockQty.ContainsKey(finishedGood.Identity))
{
finstockQty.Add(finishedGood.Identity, finishedGood.Quantity);
}
string key = finishedGood.Identity.ToString() + "~" + item.Description;
if (qty > 0)
{
double remainQty = finstockQty[finishedGood.Identity] - qty;
if (remainQty < 0)
{
qty -= finstockQty[finishedGood.Identity];
finStockToBeUpdated.Add(key, 0);
finstockQty[finishedGood.Identity] = 0;
}
else if (remainQty == 0)
{
finStockToBeUpdated.Add(key, 0);
finstockQty[finishedGood.Identity] = remainQty;
break;
}
else if (remainQty > 0)
{
finStockToBeUpdated.Add(key, remainQty);
finstockQty[finishedGood.Identity] = remainQty;
break;
}
}
}
}
}
foreach (var finStock in finStockToBeUpdated)
{
var keyString = finStock.Key.Split("~");
var garmentFinishingGoodStockItem = _garmentFinishedGoodStockRepository.Query.Where(x => x.Identity == Guid.Parse(keyString[0])).Select(s => new GarmentFinishedGoodStock(s)).Single();
var item = request.Items.Where(a => new SizeId(a.Size.Id) == garmentFinishingGoodStockItem.SizeId && new UomId(a.Uom.Id) == garmentFinishingGoodStockItem.UomId && a.Description == keyString[1]).Single();
item.Price = (item.BasicPrice + ((double)garmentComodityPrice.Price * 1)) * item.Quantity;
var qty = garmentFinishingGoodStockItem.Quantity - finStock.Value;
GarmentExpenditureGoodItem garmentExpenditureGoodItem = new GarmentExpenditureGoodItem(
Guid.NewGuid(),
garmentExpenditureGood.Identity,
garmentFinishingGoodStockItem.Identity,
new SizeId(item.Size.Id),
item.Size.Size,
qty,
0,
new UomId(item.Uom.Id),
item.Uom.Unit,
item.Description,
garmentFinishingGoodStockItem.BasicPrice,
(garmentFinishingGoodStockItem.BasicPrice + (double)garmentComodityPrice.Price) * qty
);
await _garmentExpenditureGoodItemRepository.Update(garmentExpenditureGoodItem);
GarmentFinishedGoodStockHistory garmentFinishedGoodStockHistory = new GarmentFinishedGoodStockHistory(
Guid.NewGuid(),
garmentFinishingGoodStockItem.Identity,
Guid.Empty,
Guid.Empty,
garmentExpenditureGood.Identity,
garmentExpenditureGoodItem.Identity,
Guid.Empty,
Guid.Empty,
Guid.Empty,
Guid.Empty,
"OUT",
garmentExpenditureGood.RONo,
garmentExpenditureGood.Article,
garmentExpenditureGood.UnitId,
garmentExpenditureGood.UnitCode,
garmentExpenditureGood.UnitName,
garmentExpenditureGood.ComodityId,
garmentExpenditureGood.ComodityCode,
garmentExpenditureGood.ComodityName,
garmentExpenditureGoodItem.SizeId,
garmentExpenditureGoodItem.SizeName,
garmentExpenditureGoodItem.UomId,
garmentExpenditureGoodItem.UomUnit,
garmentExpenditureGoodItem.Quantity,
garmentExpenditureGoodItem.BasicPrice,
garmentExpenditureGoodItem.Price
);
await _garmentFinishedGoodStockHistoryRepository.Update(garmentFinishedGoodStockHistory);
garmentFinishingGoodStockItem.SetQuantity(finStock.Value);
garmentFinishingGoodStockItem.SetPrice((garmentFinishingGoodStockItem.BasicPrice + (double)garmentComodityPrice.Price) * (finStock.Value));
garmentFinishingGoodStockItem.Modify();
await _garmentFinishedGoodStockRepository.Update(garmentFinishingGoodStockItem);
}
await _garmentExpenditureGoodRepository.Update(garmentExpenditureGood);
_storage.Save();
return(garmentExpenditureGood);
}
public async Task <GarmentExpenditureGoodReturn> Handle(PlaceGarmentExpenditureGoodReturnCommand request, CancellationToken cancellationToken)
{
request.Items = request.Items.ToList();
GarmentComodityPrice garmentComodityPrice = _garmentComodityPriceRepository.Query.Where(a => a.IsValid == true && a.UnitId == request.Unit.Id && a.ComodityId == request.Comodity.Id).Select(s => new GarmentComodityPrice(s)).Single();
GarmentExpenditureGoodReturn garmentExpenditureGoodReturn = new GarmentExpenditureGoodReturn(
Guid.NewGuid(),
GenerateExpenditureGoodReturnNo(request),
request.ReturType,
new UnitDepartmentId(request.Unit.Id),
request.Unit.Code,
request.Unit.Name,
request.RONo,
request.Article,
new GarmentComodityId(request.Comodity.Id),
request.Comodity.Code,
request.Comodity.Name,
new BuyerId(request.Buyer.Id),
request.Buyer.Code,
request.Buyer.Name,
request.ReturDate.GetValueOrDefault(),
request.Invoice,
request.ReturDesc
);
Dictionary <Guid, double> finstockQty = new Dictionary <Guid, double>();
Dictionary <string, double> finStockToBeUpdated = new Dictionary <string, double>();
Dictionary <Guid, double> exGoodToBeUpdated = new Dictionary <Guid, double>();
foreach (var item in request.Items)
{
if (item.isSave)
{
var garmentexGood = _garmentExpenditureGoodRepository.Query.Where(x => x.UnitId == request.Unit.Id && x.RONo == request.RONo).OrderBy(a => a.CreatedDate).ToList();
var garmentexGoodItem = _garmentExpenditureGoodItemRepository.Query.Where(x => x.SizeId == item.Size.Id && x.UomId == item.Uom.Id && (x.Quantity - x.ReturQuantity) > 0 && x.Description == item.Description).OrderBy(a => a.CreatedDate).ToList();
var join = (from a in garmentexGoodItem join b in garmentexGood on a.ExpenditureGoodId equals b.Identity select a).ToList();
double qty = item.Quantity;
foreach (var exGood in join)
{
string key = exGood.FinishedGoodStockId.ToString() + "~" + item.Description;
if (qty > 0)
{
double exGoodQty = exGood.Quantity - exGood.ReturQuantity;
double remainQty = exGoodQty - qty;
if (!finstockQty.ContainsKey(exGood.FinishedGoodStockId))
{
finstockQty.Add(exGood.FinishedGoodStockId, 0);
}
//double stockQty = exGoodQty - qty;
if (remainQty < 0)
{
qty -= exGood.Quantity;
exGoodToBeUpdated.Add(exGood.Identity, exGoodQty);
finstockQty[exGood.FinishedGoodStockId] += exGoodQty;
//finStockToBeUpdated.Add(key, exGoodQty);
}
else if (remainQty == 0)
{
exGoodToBeUpdated.Add(exGood.Identity, exGoodQty);
finstockQty[exGood.FinishedGoodStockId] += exGoodQty;
//finStockToBeUpdated.Add(key, exGoodQty);
break;
}
else if (remainQty > 0)
{
exGoodToBeUpdated.Add(exGood.Identity, qty);
finstockQty[exGood.FinishedGoodStockId] += qty;
//finStockToBeUpdated.Add(key, qty);
break;
}
}
}
}
}
foreach (var exGood in exGoodToBeUpdated)
{
var garmentExpenditureGoodItem = _garmentExpenditureGoodItemRepository.Query.Where(x => x.Identity == exGood.Key).Select(s => new GarmentExpenditureGoodItem(s)).Single();
//var dup= request.Items.Where(a => new SizeId(a.Size.Id) == garmentExpenditureGoodItem.SizeId && new UomId(a.Uom.Id) == garmentExpenditureGoodItem.UomId && a.isSave == true).FirstOrDefault();
var item = request.Items.Where(a => a.Description.Trim() == garmentExpenditureGoodItem.Description.Trim() && new SizeId(a.Size.Id) == garmentExpenditureGoodItem.SizeId && new UomId(a.Uom.Id) == garmentExpenditureGoodItem.UomId && a.isSave == true).Single();
var quantityRetur = garmentExpenditureGoodItem.ReturQuantity + exGood.Value;
double price = (garmentExpenditureGoodItem.BasicPrice + ((double)garmentComodityPrice.Price * 1)) * quantityRetur;
GarmentExpenditureGoodReturnItem garmentExpenditureGoodReturnItem = new GarmentExpenditureGoodReturnItem(
Guid.NewGuid(),
garmentExpenditureGoodReturn.Identity,
garmentExpenditureGoodItem.ExpenditureGoodId,
garmentExpenditureGoodItem.Identity,
garmentExpenditureGoodItem.FinishedGoodStockId,
new SizeId(item.Size.Id),
item.Size.Size,
exGood.Value,
new UomId(item.Uom.Id),
item.Uom.Unit,
item.Description,
garmentExpenditureGoodItem.BasicPrice,
price
);
GarmentFinishedGoodStockHistory garmentFinishedGoodStockHistory = new GarmentFinishedGoodStockHistory(
Guid.NewGuid(),
item.FinishedGoodStockId,
Guid.Empty,
Guid.Empty,
Guid.Empty,
Guid.Empty,
Guid.Empty,
Guid.Empty,
garmentExpenditureGoodReturn.Identity,
garmentExpenditureGoodReturnItem.Identity,
"RETUR",
garmentExpenditureGoodReturn.RONo,
garmentExpenditureGoodReturn.Article,
garmentExpenditureGoodReturn.UnitId,
garmentExpenditureGoodReturn.UnitCode,
garmentExpenditureGoodReturn.UnitName,
garmentExpenditureGoodReturn.ComodityId,
garmentExpenditureGoodReturn.ComodityCode,
garmentExpenditureGoodReturn.ComodityName,
garmentExpenditureGoodReturnItem.SizeId,
garmentExpenditureGoodReturnItem.SizeName,
garmentExpenditureGoodReturnItem.UomId,
garmentExpenditureGoodReturnItem.UomUnit,
garmentExpenditureGoodReturnItem.Quantity,
garmentExpenditureGoodReturnItem.BasicPrice,
garmentExpenditureGoodReturnItem.Price
);
await _garmentFinishedGoodStockHistoryRepository.Update(garmentFinishedGoodStockHistory);
await _garmentExpenditureGoodReturnItemRepository.Update(garmentExpenditureGoodReturnItem);
var qty = garmentExpenditureGoodItem.ReturQuantity + exGood.Value;
garmentExpenditureGoodItem.SetReturQuantity(qty);
garmentExpenditureGoodItem.Modify();
await _garmentExpenditureGoodItemRepository.Update(garmentExpenditureGoodItem);
}
foreach (var finStock in finstockQty)
{
//var keyString = finStock.Key.Split("~");
var garmentFinishingGoodStockItem = _garmentFinishedGoodStockRepository.Query.Where(x => x.Identity == finStock.Key).Select(s => new GarmentFinishedGoodStock(s)).Single();
var qty = garmentFinishingGoodStockItem.Quantity + finStock.Value;
garmentFinishingGoodStockItem.SetQuantity(qty);
garmentFinishingGoodStockItem.SetPrice((garmentFinishingGoodStockItem.BasicPrice + (double)garmentComodityPrice.Price) * (qty));
garmentFinishingGoodStockItem.Modify();
await _garmentFinishedGoodStockRepository.Update(garmentFinishingGoodStockItem);
}
await _garmentExpenditureGoodReturnRepository.Update(garmentExpenditureGoodReturn);
_storage.Save();
return(garmentExpenditureGoodReturn);
}