static void Test10()
{
var homeUri = new Uri("http://192.168.1.105/svn/BIST/release");
var tgtUri = SvnTools.GetNormalizedUri(new Uri("http://192.168.1.105/svn/BIST/../modelsBinaries/missiontrModels/trunk"));
var client = new SvnClient();
SvnInfoEventArgs homeInfo;
if (!client.GetInfo(homeUri, out homeInfo))
{
return;
}
string homeRepoUrl = homeInfo.RepositoryRoot.AbsoluteUri;
SvnInfoEventArgs tgtInfo;
if (!client.GetInfo(tgtUri, out tgtInfo))
{
return;
}
string tgtRepoUrl = tgtInfo.RepositoryRoot.AbsoluteUri;
string relativizedUrl;
Exter.TryMakeRelativeReference(client, tgtUri.AbsoluteUri, homeRepoUrl, out relativizedUrl);
}
public void ReloadReleaseExternals()
{
ReleaseExternals.Clear();
if (!String.IsNullOrEmpty(Release))
{
SharpSvn.SvnExternalItem[] extItems;
Exter.ReadExternals(
dBase.svnClient,
GetReleaseUrl(Release),
out extItems
);
foreach (var i in extItems)
{
var r = i.Reference;
// strip the unimportant beginning of the link, show just the link/branch type and revision number
//var removableStart = $"^/{dBase.ShrSegm}/{Module}/{i.Target}/";
var removableStart = Exter.StripStdSvnLayoutFromUrl(i.Reference) + "/";
if (r.StartsWith(removableStart))
{
r = r.Substring(removableStart.Length);
}
var s = "";
if (i.Revision.RevisionType == SharpSvn.SvnRevisionType.Number)
{
s = $"{i.Target} => {r}@{i.Revision.Revision}";
}
else
{
s = $"{i.Target} => {r}";
}
ReleaseExternals.Add(s);
}
}
}
public void ReloadInstallExternals()
{
InstallExternals.Clear();
if (!String.IsNullOrEmpty(Release))
{
SharpSvn.SvnExternalItem[] extItems;
Exter.ReadExternals(
dBase.svnClient,
GetInstallUrl(Install),
out extItems
);
foreach (var i in extItems)
{
var r = i.Reference;
// strip the unimportant beginning of the reference, show just the linked release name
var removableStart = $"^/{dBase.RelSegm}/{i.Target}/";
if (r.StartsWith(removableStart))
{
r = r.Substring(removableStart.Length);
}
var s = "";
if (i.Revision.RevisionType == SharpSvn.SvnRevisionType.Number)
{
s = $"{i.Target} => {r}@{i.Revision.Revision}";
}
else
{
s = $"{i.Target} => {r}";
}
InstallExternals.Add(s);
}
}
}
public List <GarmentStockReportViewModel> GetStockQuery(string ctg, string unitcode, DateTime?datefrom, DateTime?dateto, int offset)
{
DateTime DateFrom = datefrom == null ? new DateTime(1970, 1, 1) : (DateTime)datefrom;
DateTime DateTo = dateto == null ? DateTime.Now : (DateTime)dateto;
var lastdate = dbContext.BalanceStocks.OrderByDescending(x => x.CreateDate).Select(x => x.CreateDate).FirstOrDefault();
var BalaceStock = (from a in dbContext.BalanceStocks
where a.CreateDate == lastdate
group a by new { a.ArticleNo, a.EPOID, a.EPOItemId } into data
select new
{
BalanceStockId = data.FirstOrDefault().BalanceStockId,
ArticleNo = data.FirstOrDefault().ArticleNo,
EPOID = data.FirstOrDefault().EPOID,
EPOItemId = data.FirstOrDefault().EPOItemId,
CloseStock = (double)data.Sum(x => x.CloseStock),
ClosePrice = (decimal)data.Sum(x => x.ClosePrice)
}).ToList();
//var saldoawalbalanceepoid = SaldoAwal.Select(x => x.EPOID).ToList();
var SAkhir = (from a in dbContext.GarmentUnitReceiptNotes
join b in dbContext.GarmentUnitReceiptNoteItems on a.Id equals b.URNId
join h in dbContext.GarmentDeliveryOrderDetails on b.DODetailId equals h.Id
join f in dbContext.GarmentInternalPurchaseOrders on b.POId equals f.Id
join e in dbContext.GarmentReceiptCorrectionItems on b.Id equals e.URNItemId into RC
from ty in RC.DefaultIfEmpty()
join c in dbContext.GarmentUnitExpenditureNoteItems on b.Id equals c.URNItemId into UE
from ww in UE.DefaultIfEmpty()
join r in dbContext.GarmentUnitExpenditureNotes on ww.UENId equals r.Id into UEN
from dd in UEN.DefaultIfEmpty()
join epoItem in dbContext.GarmentExternalPurchaseOrderItems on b.EPOItemId equals epoItem.Id into EP
from epoItem in EP.DefaultIfEmpty()
join epo in dbContext.GarmentExternalPurchaseOrders on epoItem.GarmentEPOId equals epo.Id into EPO
from epo in EPO.DefaultIfEmpty()
where h.CodeRequirment == (String.IsNullOrWhiteSpace(ctg) ? h.CodeRequirment : ctg) &&
a.IsDeleted == false && b.IsDeleted == false &&
a.CreatedUtc.AddHours(offset).Date >= DateFrom.Date &&
a.CreatedUtc.AddHours(offset).Date <= DateTo.Date &&
a.UnitCode == (string.IsNullOrWhiteSpace(unitcode) ? a.UnitCode : unitcode)
select new
{
URNId = a.Id,
URNItemsId = b.Id,
DODEtailId = h.Id,
IPOId = f.Id,
RCorrId = ty == null ? 0 : ty.Id,
UENItemsId = ww == null ? 0 : ww.Id,
UENId = dd == null ? 0 : dd.Id,
EPOItemId = epoItem == null ? 0 : epoItem.Id,
EPOId = epo == null ? 0 : epo.Id,
UnitCode = a.UnitCode,
UnitSenderCode = dd == null ? "-" : dd.UnitSenderCode
}).Distinct().ToList();
//SaldoAkhir = SaldoAkhir.Where(x => x.UENNo.Contains((String.IsNullOrWhiteSpace(unitcode) ? x.UnitCode : unitcode)) || x.UnitCode == ((String.IsNullOrWhiteSpace(unitcode) ? x.UnitCode : unitcode))).Select(x => x).ToList();
var SAkhirs = SAkhir.Select(x => x).ToList();
var unitreceiptnoteIds = SAkhirs.Select(x => x.URNId).ToList();
var unitreceiptnotes = dbContext.GarmentUnitReceiptNotes.Where(x => unitreceiptnoteIds.Contains(x.Id)).Select(s => new { s.ReceiptDate, s.URNType, s.UnitCode, s.Id }).ToList();
var unitreceiptnoteItemIds = SAkhirs.Select(x => x.URNItemsId).ToList();
var unitreceiptnoteItems = dbContext.GarmentUnitReceiptNoteItems.Where(x => unitreceiptnoteItemIds.Contains(x.Id)).Select(s => new { s.ProductCode, s.ProductName, s.ProductRemark, s.RONo, s.SmallUomUnit, s.POSerialNumber, s.ReceiptQuantity, s.PricePerDealUnit, s.Id }).ToList();
var deliveryorderdetailid = SAkhirs.Select(x => x.DODEtailId).ToList();
var deliveryorderdetails = dbContext.GarmentDeliveryOrderDetails.Where(x => deliveryorderdetailid.Contains(x.Id)).Select(s => new { s.CodeRequirment, s.Id }).ToList();
var purchaseorderIds = SAkhirs.Select(x => x.IPOId).ToList();
var purchaseorders = dbContext.GarmentInternalPurchaseOrders.Where(x => purchaseorderIds.Contains(x.Id)).Select(s => new { s.BuyerCode, s.Id, s.Article }).ToList();
var receiptCorrectionitemIds = SAkhirs.Select(x => x.RCorrId).ToList();
var receiptCorrectionitems = dbContext.GarmentReceiptCorrectionItems.Where(x => receiptCorrectionitemIds.Contains(x.Id)).Select(s => new { s.CorrectionQuantity, s.PricePerDealUnit, s.Id }).ToList();
var unitexpenditureitemIds = SAkhirs.Select(x => x.UENItemsId).ToList();
var unitexpenditureitems = dbContext.GarmentUnitExpenditureNoteItems.Where(x => unitexpenditureitemIds.Contains(x.Id)).Select(s => new { s.PricePerDealUnit, s.Quantity, s.Id }).ToList();
var unitexpenditureIds = SAkhirs.Select(x => x.UENId).ToList();
var unitexpenditures = dbContext.GarmentUnitExpenditureNotes.Where(x => unitexpenditureIds.Contains(x.Id)).Select(s => new { s.UnitRequestCode, s.UnitSenderCode, s.ExpenditureTo, s.Id }).ToList();
var externalpurchaseorderitemIds = SAkhirs.Select(x => x.EPOItemId).ToList();
var externalpurchaseorderitems = dbContext.GarmentExternalPurchaseOrderItems.Where(x => externalpurchaseorderitemIds.Contains(x.Id)).Select(s => new { s.Id }).ToList();
var externalpurchaseorderIds = SAkhirs.Select(x => x.EPOId).ToList();
var externalpurchaseorders = dbContext.GarmentExternalPurchaseOrders.Where(x => externalpurchaseorderIds.Contains(x.Id)).Select(s => new { s.PaymentMethod, s.Id }).ToList();
//var balancestocks = SaldoAwal.Where(x => externalpurchaseorderitemIds.Contains((long)x.EPOItemId)).Select(s => new { s.BeginningBalanceQty, s.BeginningBaancePrice, s.EPOItemId}).ToList();
List <GarmentStockReportViewModel> SaldoAkhir = new List <GarmentStockReportViewModel>();
foreach (var item in SAkhir)
{
var unitreceiptnote = unitreceiptnotes.Where(x => x.Id.Equals(item.URNId)).FirstOrDefault();
var unitreceiptnoteItem = unitreceiptnoteItems.FirstOrDefault(x => x.Id.Equals(item.URNItemsId));
var deliveryorderdetail = deliveryorderdetails.FirstOrDefault(x => x.Id.Equals(item.DODEtailId));
var purchaseorder = purchaseorders.FirstOrDefault(x => x.Id.Equals(item.IPOId));
var receiptCorrectionitem = receiptCorrectionitems.FirstOrDefault(x => x.Id.Equals(item.RCorrId));
var unitexpenditureitem = unitexpenditureitems.FirstOrDefault(x => x.Id.Equals(item.UENItemsId));
var unitexpenditure = unitexpenditures.FirstOrDefault(x => x.Id.Equals(item.UENId));
var externalpurchaseorderitem = externalpurchaseorderitems.FirstOrDefault(x => x.Id.Equals(item.EPOItemId));
var externalpurchaseorder = externalpurchaseorders.FirstOrDefault(x => x.Id.Equals(item.EPOId));
//var balancestock = balancestocks.FirstOrDefault(x => x.EPOItemId.Equals(item.EPOItemId));
SaldoAkhir.Add(new GarmentStockReportViewModel
{
BeginningBalanceQty = 0,
BeginningBalanceUom = unitreceiptnoteItem.SmallUomUnit,
Buyer = purchaseorder.BuyerCode,
EndingBalanceQty = 0,
EndingUom = unitreceiptnoteItem.SmallUomUnit,
ExpandUom = unitreceiptnoteItem.SmallUomUnit,
ExpendQty = unitexpenditureitem == null ? 0 : unitexpenditureitem.Quantity,
NoArticle = purchaseorder.Article,
PaymentMethod = externalpurchaseorder == null ? "-" : externalpurchaseorder.PaymentMethod,
PlanPo = unitreceiptnoteItem == null ? "-" : unitreceiptnoteItem.POSerialNumber,
POId = purchaseorder.Id,
ProductCode = unitreceiptnoteItem.ProductCode,
ProductName = unitreceiptnoteItem.ProductName,
ProductRemark = unitreceiptnoteItem.ProductRemark,
ReceiptCorrectionQty = receiptCorrectionitem == null ? 0 : (decimal)receiptCorrectionitem.CorrectionQuantity,
ReceiptQty = unitreceiptnoteItem.ReceiptQuantity,
ReceiptUom = unitreceiptnoteItem.SmallUomUnit,
RO = unitreceiptnoteItem.RONo,
UNitCode = unitreceiptnote.UnitCode,
UnitSenderCode = unitexpenditure == null ? "-" : unitexpenditure.UnitSenderCode,
UnitRequestCode = unitexpenditure == null ? "-" : unitexpenditure.UnitRequestCode
});
}
SaldoAkhir = (from query in SaldoAkhir
group query by new { query.ProductCode, query.ProductName, query.RO, query.PlanPo, query.POId, query.UNitCode, query.UnitSenderCode } into data
//group query by new { query.POId } into data
select new GarmentStockReportViewModel
{
BeginningBalanceQty = data.Sum(x => x.BeginningBalanceQty),
BeginningBalanceUom = data.FirstOrDefault().BeginningBalanceUom,
Buyer = data.FirstOrDefault().Buyer,
EndingBalanceQty = data.FirstOrDefault().EndingBalanceQty,
EndingUom = data.FirstOrDefault().EndingUom,
ExpandUom = data.FirstOrDefault().EndingUom,
ExpendQty = data.Sum(x => x.ExpendQty),
NoArticle = data.FirstOrDefault().NoArticle,
PaymentMethod = data.FirstOrDefault().PaymentMethod,
PlanPo = data.FirstOrDefault().PlanPo,
POId = data.FirstOrDefault().POId,
ProductCode = data.FirstOrDefault().ProductCode,
ProductName = data.FirstOrDefault().ProductName,
ProductRemark = data.FirstOrDefault().ProductRemark,
ReceiptCorrectionQty = data.Sum(x => x.ReceiptCorrectionQty),
//ReceiptQty = data.Sum(x => x.ReceiptQty),
ReceiptQty = data.FirstOrDefault().ReceiptQty,
ReceiptUom = data.FirstOrDefault().ReceiptUom,
RO = data.FirstOrDefault().RO,
UNitCode = data.FirstOrDefault().UNitCode,
UnitSenderCode = data.FirstOrDefault().UnitSenderCode,
UnitRequestCode = data.FirstOrDefault().UnitRequestCode
}).ToList();
var SaldoAkhirId = SaldoAkhir.Select(x => x.POId).ToList();
var SA = (from a in dbContext.GarmentUnitReceiptNotes
join b in dbContext.GarmentUnitReceiptNoteItems on a.Id equals b.URNId
join i in dbContext.GarmentInternalPurchaseOrders on b.POId equals i.Id
join c in dbContext.GarmentDeliveryOrderDetails on b.DODetailId equals c.Id
join e in dbContext.GarmentUnitExpenditureNoteItems on b.Id equals e.URNItemId into UENItem
from ee in UENItem.DefaultIfEmpty()
join h in dbContext.GarmentReceiptCorrectionItems on b.Id equals h.URNItemId into RC
from hh in RC.DefaultIfEmpty()
join f in dbContext.GarmentUnitExpenditureNotes on ee.UENId equals f.Id into UEN
from ff in UEN.DefaultIfEmpty()
join g in dbContext.GarmentExternalPurchaseOrders on b.EPOItemId equals g.Id into Exter
from gg in Exter.DefaultIfEmpty()
join epoItem in dbContext.GarmentExternalPurchaseOrderItems on b.EPOItemId equals epoItem.Id into EP
from epoItem in EP.DefaultIfEmpty()
join epo in dbContext.GarmentExternalPurchaseOrders on epoItem.GarmentEPOId equals epo.Id into EPO
from epo in EPO.DefaultIfEmpty()
where c.CodeRequirment == (string.IsNullOrWhiteSpace(ctg) ? c.CodeRequirment : ctg) &&
a.IsDeleted == false && b.IsDeleted == false &&
a.CreatedUtc > lastdate && a.CreatedUtc < DateFrom &&
a.UnitCode == (string.IsNullOrWhiteSpace(unitcode) ? a.UnitCode : unitcode) &&
SaldoAkhirId.Contains(i.Id)
select new
{
//BSId = bb == null ? "" : bb.BalanceStockId,
URNItemsId = b == null ? 0 : b.Id,
UENItemId = ee == null ? 0 : ee.Id,
RCorItemId = hh != null ? hh.Id : 0,
URNId = a == null ? 0 : a.Id,
DODEtailId = c == null ? 0 : c.Id,
IPOId = i == null ? 0 : i.Id,
RCorrId = hh == null ? 0 : hh.Id,
//UENItemsId = ee == null ? 0 : ee.Id,
UENId = ff == null ? 0 : ff.Id,
UnitCode = a == null ? "-" : a.UnitCode,
UnitSenderCode = ff == null ? "-" : ff.UnitSenderCode,
EPOItemId = epoItem == null ? 0 : epoItem.Id,
EPOId = epo == null ? 0 : epo.Id,
//SAQty = (bb != null ? bb.CloseStock : 0) + (hh != null ? hh.CorrectionQuantity : 0) + (double)b.ReceiptQuantity - (ee != null ? ee.Quantity : 0),
//SAPrice = (bb != null ? bb.ClosePrice : 0) + (hh != null ? (decimal)hh.PricePerDealUnit * (decimal)hh.CorrectionQuantity : 0) + b.PricePerDealUnit * b.ReceiptQuantity - (ee != null ? (decimal)ee.PricePerDealUnit * (decimal)ee.Quantity : 0)
}).ToList();
var SaldoAwals = SA.Select(x => x).ToList().Distinct();
var saldoawalunitreceiptnoteIds = SaldoAwals.Select(x => x.URNId).ToList();
var saldoawalunitreceiptnotes = dbContext.GarmentUnitReceiptNotes.Where(x => saldoawalunitreceiptnoteIds.Contains(x.Id)).Select(s => new { s.ReceiptDate, s.URNType, s.UnitCode, s.Id }).ToList();
var saldoawalunitreceiptnoteItemIds = SaldoAwals.Select(x => x.URNItemsId).ToList();
var saldoawalunitreceiptnoteItems = dbContext.GarmentUnitReceiptNoteItems.Where(x => saldoawalunitreceiptnoteItemIds.Contains(x.Id)).Select(s => new { s.ProductCode, s.ProductName, s.ProductRemark, s.RONo, s.SmallUomUnit, s.POSerialNumber, s.ReceiptQuantity, s.PricePerDealUnit, s.Id }).ToList();
var saldoawaldeliveryorderdetailid = SaldoAwals.Select(x => x.DODEtailId).ToList();
var saldoawaldeliveryorderdetails = dbContext.GarmentDeliveryOrderDetails.Where(x => saldoawaldeliveryorderdetailid.Contains(x.Id)).Select(s => new { s.CodeRequirment, s.Id }).ToList();
var saldoawalpurchaseorderIds = SaldoAwals.Select(x => x.IPOId).ToList();
var saldoawalpurchaseorders = dbContext.GarmentInternalPurchaseOrders.Where(x => saldoawalpurchaseorderIds.Contains(x.Id)).Select(s => new { s.BuyerCode, s.Id, s.Article }).ToList();
var saldoawalreceiptCorrectionitemIds = SaldoAwals.Select(x => x.RCorrId).ToList();
var saldoawalreceiptCorrectionitems = dbContext.GarmentReceiptCorrectionItems.Where(x => saldoawalreceiptCorrectionitemIds.Contains(x.Id)).Select(s => new { s.CorrectionQuantity, s.PricePerDealUnit, s.Id }).ToList();
var saldoawalunitexpenditureitemIds = SaldoAwals.Select(x => x.UENItemId).ToList();
var saldoawalunitexpenditureitems = dbContext.GarmentUnitExpenditureNoteItems.Where(x => saldoawalunitexpenditureitemIds.Contains(x.Id)).Select(s => new { s.PricePerDealUnit, s.Quantity, s.Id }).ToList();
var saldoawalunitexpenditureIds = SaldoAwals.Select(x => x.UENId).ToList();
var saldoawalunitexpenditures = dbContext.GarmentUnitExpenditureNotes.Where(x => saldoawalunitexpenditureIds.Contains(x.Id)).Select(s => new { s.UnitRequestCode, s.UnitSenderCode, s.ExpenditureTo, s.Id }).ToList();
//var saldoawalbalancestockepoitemids = SaldoAwals.Select(x => x.BSId).ToList();
var saldoawalexternalpurchaseorderitemIds = SaldoAwals.Select(x => x.EPOItemId).ToList();
var saldoawalexternalpurchaseorderitems = dbContext.GarmentExternalPurchaseOrderItems.Where(x => saldoawalexternalpurchaseorderitemIds.Contains(x.Id)).Select(s => new { s.Id }).ToList();
var saldoawalexternalpurchaseorderIds = SaldoAwals.Select(x => x.EPOId).ToList();
var saldoawalexternalpurchaseorders = dbContext.GarmentExternalPurchaseOrders.Where(x => saldoawalexternalpurchaseorderIds.Contains(x.Id)).Select(s => new { s.PaymentMethod, s.Id }).ToList();
var saldoawalbalancestocks = BalaceStock.Where(x => saldoawalexternalpurchaseorderitemIds.Contains((long)x.EPOItemId)).Select(s => new { s.ArticleNo, s.ClosePrice, s.CloseStock, s.EPOID, s.EPOItemId, s.BalanceStockId }).ToList();
List <GarmentStockReportViewModel> SaldoAwal = new List <GarmentStockReportViewModel>();
foreach (var i in SaldoAwals)
{
var saldoawalunitreceiptnote = saldoawalunitreceiptnotes.AsParallel().FirstOrDefault(x => x.Id == i.URNId);
var saldoawalunitreceiptnoteItem = saldoawalunitreceiptnoteItems.AsParallel().FirstOrDefault(x => x.Id.Equals(i.URNItemsId));
var saldoawaldeliveryorderdetail = saldoawaldeliveryorderdetails.AsParallel().FirstOrDefault(x => x.Id.Equals(i.DODEtailId));
var saldoawalpurchaseorder = saldoawalpurchaseorders.AsParallel().FirstOrDefault(x => x.Id.Equals(i.IPOId));
var saldoawalreceiptCorrectionitem = saldoawalreceiptCorrectionitems.AsParallel().FirstOrDefault(x => x.Id.Equals(i.RCorrId));
var saldoawalunitexpenditureitem = saldoawalunitexpenditureitems.AsParallel().FirstOrDefault(x => x.Id.Equals(i.URNItemsId));
var saldoawalunitexpenditure = saldoawalunitexpenditures.AsParallel().FirstOrDefault(x => x.Id.Equals(i.URNId));
var saldoawalbalancestock = saldoawalbalancestocks.AsParallel().FirstOrDefault(x => x.EPOItemId.Equals(i.EPOItemId));
var saldoawalexternalpurchaseorderitem = saldoawalexternalpurchaseorderitems.AsParallel().FirstOrDefault(x => x.Id.Equals(i.EPOItemId));
var saldoawalexternalpurchaseorder = saldoawalexternalpurchaseorders.AsParallel().FirstOrDefault(x => x.Id.Equals(i.EPOId));
SaldoAwal.Add(new GarmentStockReportViewModel
{
BeginningBalanceQty = saldoawalbalancestock == null ? (saldoawalreceiptCorrectionitem != null ? (decimal)saldoawalreceiptCorrectionitem.CorrectionQuantity : 0) + saldoawalunitreceiptnoteItem.ReceiptQuantity - (saldoawalunitexpenditureitem != null ? (decimal)saldoawalunitexpenditureitem.Quantity : 0) : (decimal)saldoawalbalancestock.CloseStock + (saldoawalreceiptCorrectionitem != null ? (decimal)saldoawalreceiptCorrectionitem.CorrectionQuantity : 0) + saldoawalunitreceiptnoteItem.ReceiptQuantity - (saldoawalunitexpenditureitem != null ? (decimal)saldoawalunitexpenditureitem.Quantity : 0),
//BeginningBalanceQty = saldoawalbalancestock != null ? (decimal)saldoawalbalancestock.CloseStock : 0) + (saldoawalreceiptCorrectionitem != null ? (decimal)saldoawalreceiptCorrectionitem.CorrectionQuantity : 0) + saldoawalunitreceiptnoteItem.ReceiptQuantity - (saldoawalunitexpenditureitem != null ? (decimal)saldoawalunitexpenditureitem.Quantity : 0,
BeginningBalanceUom = saldoawalunitreceiptnoteItem.SmallUomUnit,
Buyer = saldoawalpurchaseorder.BuyerCode,
EndingBalanceQty = 0,
EndingUom = saldoawalunitreceiptnoteItem.SmallUomUnit,
ExpandUom = saldoawalunitreceiptnoteItem.SmallUomUnit,
ExpendQty = saldoawalunitexpenditureitem == null ? 0 : saldoawalunitexpenditureitem.Quantity,
NoArticle = saldoawalpurchaseorder.Article,
PaymentMethod = saldoawalexternalpurchaseorder == null ? "-" : saldoawalexternalpurchaseorder.PaymentMethod,
PlanPo = saldoawalunitreceiptnoteItem == null ? "-" : saldoawalunitreceiptnoteItem.POSerialNumber,
POId = saldoawalpurchaseorder == null ? 0 : saldoawalpurchaseorder.Id,
ProductCode = saldoawalunitreceiptnoteItem.ProductCode,
ProductName = saldoawalunitreceiptnoteItem.ProductName,
ProductRemark = saldoawalunitreceiptnoteItem.ProductRemark,
ReceiptCorrectionQty = saldoawalreceiptCorrectionitem == null ? 0 : (decimal)saldoawalreceiptCorrectionitem.CorrectionQuantity,
ReceiptQty = saldoawalunitreceiptnoteItem.ReceiptQuantity,
ReceiptUom = saldoawalunitreceiptnoteItem.SmallUomUnit,
RO = saldoawalunitreceiptnoteItem.RONo,
UNitCode = saldoawalunitreceiptnote.UnitCode,
UnitSenderCode = saldoawalunitexpenditure == null ? "-" : saldoawalunitexpenditure.UnitSenderCode,
UnitRequestCode = saldoawalunitexpenditure == null ? "-" : saldoawalunitexpenditure.UnitRequestCode
});
}
SaldoAwal = (from query in SaldoAwal
group query by new { query.ProductCode, query.ProductName, query.RO, query.PlanPo, query.POId, query.UNitCode, query.UnitSenderCode } into data
select new GarmentStockReportViewModel
{
BeginningBalanceQty = data.Sum(x => x.BeginningBalanceQty),
BeginningBalanceUom = data.FirstOrDefault().BeginningBalanceUom,
Buyer = data.FirstOrDefault().Buyer,
EndingBalanceQty = data.FirstOrDefault().EndingBalanceQty,
EndingUom = data.FirstOrDefault().EndingUom,
ExpandUom = data.FirstOrDefault().EndingUom,
ExpendQty = 0,
NoArticle = data.FirstOrDefault().NoArticle,
PaymentMethod = data.FirstOrDefault().PaymentMethod,
PlanPo = data.FirstOrDefault().PlanPo,
POId = data.FirstOrDefault().POId,
ProductCode = data.FirstOrDefault().ProductCode,
ProductName = data.FirstOrDefault().ProductName,
ProductRemark = data.FirstOrDefault().ProductRemark,
ReceiptCorrectionQty = 0,
ReceiptQty = 0,
ReceiptUom = data.FirstOrDefault().ReceiptUom,
RO = data.FirstOrDefault().RO,
UNitCode = data.FirstOrDefault().UNitCode,
UnitSenderCode = data.FirstOrDefault().UnitSenderCode,
UnitRequestCode = data.FirstOrDefault().UnitRequestCode
}).ToList();
var stock = (from a in SaldoAkhir
join b in SaldoAwal on a.POId equals b.POId into stockdata
from bb in stockdata.DefaultIfEmpty()
select new GarmentStockReportViewModel
{
BeginningBalanceQty = (bb == null ? 0 : bb.BeginningBalanceQty),
BeginningBalanceUom = a.BeginningBalanceUom,
Buyer = a.Buyer,
EndingBalanceQty = (bb == null ? 0 : bb.BeginningBalanceQty) + a.ReceiptQty + a.ReceiptCorrectionQty - (decimal)a.ExpendQty,
EndingUom = a.EndingUom,
ExpendQty = a.ExpendQty,
NoArticle = a.NoArticle,
PaymentMethod = a.PaymentMethod,
PlanPo = a.PlanPo,
POId = a.POId,
ProductCode = a.ProductCode,
ProductName = a.ProductName,
ProductRemark = a.ProductRemark,
ReceiptCorrectionQty = a.ReceiptCorrectionQty,
ReceiptQty = a.ReceiptQty,
ReceiptUom = a.ReceiptUom,
RO = a.RO,
UNitCode = a.UNitCode,
UnitSenderCode = a.UnitSenderCode,
UnitRequestCode = a.UnitRequestCode
}).ToList();
//var stock = SaldoAwal.Concat(SaldoAkhir).ToList();
//stock = (from query in stock
// group query by new { query.POId, query.ProductCode, query.RO } into data
// select new GarmentStockReportViewModel
// {
// BeginningBalanceQty = data.Sum(x => x.BeginningBalanceQty),
// BeginningBalanceUom = data.FirstOrDefault().BeginningBalanceUom,
// Buyer = data.FirstOrDefault().Buyer,
// EndingBalanceQty = data.Sum(x => x.BeginningBalanceQty) + data.Sum(x => x.ReceiptQty) + data.Sum(x => x.ReceiptCorrectionQty) - data.Sum(x => (decimal)x.ExpendQty),
// EndingUom = data.FirstOrDefault().EndingUom,
// ExpandUom = data.FirstOrDefault().EndingUom,
// ExpendQty = data.Sum(x => x.ExpendQty),
// NoArticle = data.FirstOrDefault().NoArticle,
// PaymentMethod = data.FirstOrDefault().PaymentMethod,
// PlanPo = data.FirstOrDefault().PlanPo,
// POId = data.FirstOrDefault().POId,
// ProductCode = data.FirstOrDefault().ProductCode,
// ProductName = data.FirstOrDefault().ProductName,
// ProductRemark = data.FirstOrDefault().ProductRemark,
// ReceiptCorrectionQty = data.Sum(x => x.ReceiptCorrectionQty),
// ReceiptQty = data.Sum(x => x.ReceiptQty),
// ReceiptUom = data.FirstOrDefault().ReceiptUom,
// RO = data.FirstOrDefault().RO,
// UNitCode = data.FirstOrDefault().UNitCode,
// UnitSenderCode = data.FirstOrDefault().UnitSenderCode,
// UnitRequestCode = data.FirstOrDefault().UnitRequestCode
// }).ToList();
return(stock);
//return SaldoAwal;
}
