public GarmentMonitoringPrepareDto(GarmentMonitoringPrepareDto garmentMonitoringPrepareDto)
{
Id = garmentMonitoringPrepareDto.Id;
roJob = garmentMonitoringPrepareDto.roJob;
article = garmentMonitoringPrepareDto.article;
buyerCode = garmentMonitoringPrepareDto.buyerCode;
productCode = garmentMonitoringPrepareDto.productCode;
uomUnit = garmentMonitoringPrepareDto.uomUnit;
roAsal = garmentMonitoringPrepareDto.roAsal;
remark = garmentMonitoringPrepareDto.remark;
stock = garmentMonitoringPrepareDto.stock;
receipt = garmentMonitoringPrepareDto.receipt;
mainFabricExpenditure = garmentMonitoringPrepareDto.mainFabricExpenditure;
nonMainFabricExpenditure = garmentMonitoringPrepareDto.nonMainFabricExpenditure;
expenditure = garmentMonitoringPrepareDto.expenditure;
aval = garmentMonitoringPrepareDto.aval;
remainQty = garmentMonitoringPrepareDto.remainQty;
nominal = garmentMonitoringPrepareDto.nominal;
}
public async Task <MemoryStream> Handle(GetXlsPrepareQuery request, CancellationToken cancellationToken)
{
DateTimeOffset dateFrom = new DateTimeOffset(request.dateFrom, new TimeSpan(7, 0, 0));
DateTimeOffset dateTo = new DateTimeOffset(request.dateTo, new TimeSpan(7, 0, 0));
var QueryMutationPrepareNow = from a in (from aa in garmentPreparingRepository.Query
where aa.UnitId == request.unit && aa.ProcessDate <= dateTo
select aa)
join b in garmentPreparingItemRepository.Query on a.Identity equals b.GarmentPreparingId
select new { Buyer = a.BuyerCode, RO = a.RONo, Articles = a.Article, Id = a.Identity, DetailExpend = b.UENItemId, Processdate = a.ProcessDate };
//List<int> detailExpendId = new List<int>();
//foreach (var item in QueryMutationPrepareNow.Distinct())
//{
// detailExpendId.Add(item.DetailExpend);
//}
//ExpenditureROResult dataExpenditure = await GetExpenditureById(detailExpendId, request.token);
var _unitName = (from a in garmentPreparingRepository.Query
where a.UnitId == request.unit
select a.UnitName).FirstOrDefault();
var sumbasicPrice = (from a in garmentPreparingRepository.Query
join b in garmentPreparingItemRepository.Query on a.Identity equals b.GarmentPreparingId
where /*(request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) &&*/
a.UnitId == request.unit
select new { a.RONo, b.BasicPrice })
.GroupBy(x => new { x.RONo }, (key, group) => new ViewBasicPrices
{
RO = key.RONo,
BasicPrice = Convert.ToDecimal(group.Sum(s => s.BasicPrice)),
Count = group.Count()
});
var QueryMutationPrepareItemsROASAL = (from a in QueryMutationPrepareNow
join b in garmentPreparingItemRepository.Query on a.Id equals b.GarmentPreparingId
where b.UENItemId == a.DetailExpend
select new { article = a.Articles, roJob = a.RO, buyerCode = a.Buyer, price = Convert.ToDecimal((from aa in sumbasicPrice where aa.RO == a.RO select aa.BasicPrice / aa.Count).FirstOrDefault()), prepareitemid = b.Identity, roasal = b.ROSource });
var QueryCuttingDONow = from a in (from data in garmentCuttingInRepository.Query where data.UnitId == request.unit && data.CuttingInDate <= dateTo select data)
join b in garmentCuttingInItemRepository.Query on a.Identity equals b.CutInId
join c in garmentCuttingInDetailRepository.Query on b.Identity equals c.CutInItemId
select new monitoringView {
prepareItemId = c.PreparingItemId, price = Convert.ToDecimal((from aa in sumbasicPrice where aa.RO == a.RONo select aa.BasicPrice / aa.Count).FirstOrDefault()), expenditure = 0, aval = 0, uomUnit = "", stock = a.CuttingInDate < dateFrom ? -c.PreparingQuantity : 0, nonMainFabricExpenditure = a.CuttingType == "Non Main Fabric" && (a.CuttingInDate >= dateFrom) ? c.PreparingQuantity : 0, mainFabricExpenditure = a.CuttingType == "Main Fabric" && (a.CuttingInDate >= dateFrom) ? c.PreparingQuantity : 0, remark = c.DesignColor, receipt = 0, productCode = c.ProductCode, remainQty = 0
};
var QueryMutationPrepareItemNow = (from d in QueryMutationPrepareNow
join e in garmentPreparingItemRepository.Query on d.Id equals e.GarmentPreparingId
//join c in dataExpenditure.data on e.UENItemId equals c.DetailExpenditureId
where e.UENItemId == d.DetailExpend
select new monitoringView {
prepareItemId = e.Identity, price = Convert.ToDecimal((from aa in sumbasicPrice where aa.RO == d.RO select aa.BasicPrice / aa.Count).FirstOrDefault()), uomUnit = "", stock = d.Processdate < dateFrom ? e.Quantity : 0, mainFabricExpenditure = 0, nonMainFabricExpenditure = 0, remark = e.DesignColor, receipt = (d.Processdate >= dateFrom ? e.Quantity : 0), productCode = e.ProductCode, remainQty = e.RemainingQuantity
}).Distinct();
var QueryAval = from a in (from data in garmentAvalProductRepository.Query where data.AvalDate <= dateTo select data)
join b in garmentAvalProductItemRepository.Query on a.Identity equals b.APId
join c in garmentPreparingItemRepository.Query on Guid.Parse(b.PreparingItemId) equals c.Identity
join d in (from data in garmentPreparingRepository.Query where data.UnitId == request.unit select data) on c.GarmentPreparingId equals d.Identity
select new monitoringView
{
prepareItemId = c.Identity, price = Convert.ToDecimal((from aa in sumbasicPrice where aa.RO == a.RONo select aa.BasicPrice / aa.Count).FirstOrDefault()), expenditure = 0, aval = a.AvalDate >= dateFrom ? b.Quantity : 0, uomUnit = "", stock = a.AvalDate < dateFrom ? -b.Quantity : 0, mainFabricExpenditure = 0, nonMainFabricExpenditure = 0, remark = b.DesignColor, receipt = 0, productCode = b.ProductCode, remainQty = 0
};
var QueryDeliveryReturn = from a in (from data in garmentDeliveryReturnRepository.Query where data.ReturnDate <= dateTo && data.UnitId == request.unit select data)
join b in garmentDeliveryReturnItemRepository.Query on a.Identity equals b.DRId
join c in garmentPreparingItemRepository.Query on Guid.Parse(b.PreparingItemId) equals(c.Identity)
select new monitoringView
{
prepareItemId = c.Identity, price = Convert.ToDecimal((from aa in sumbasicPrice where aa.RO == a.RONo select aa.BasicPrice / aa.Count).FirstOrDefault()), expenditure = a.ReturnDate >= dateFrom ? b.Quantity : 0, aval = 0, uomUnit = "", stock = a.ReturnDate < dateFrom ? -b.Quantity : 0, mainFabricExpenditure = 0, nonMainFabricExpenditure = 0, remark = b.DesignColor, receipt = 0, productCode = b.ProductCode, remainQty = 0
};
var queryNow = from a in (QueryMutationPrepareItemNow
.Union(QueryCuttingDONow)
.Union(QueryAval)
.Union(QueryDeliveryReturn).AsEnumerable())
join b in QueryMutationPrepareItemsROASAL on a.prepareItemId equals b.prepareitemid
select new { a, b };
var querySum = queryNow.GroupBy(x => new { x.a.price, x.b.roasal, x.b.roJob, x.b.article, x.b.buyerCode, x.a.productCode, x.a.remark }, (key, group) => new
{
ROAsal = key.roasal,
ROJob = key.roJob,
stock = group.Sum(s => s.a.stock),
ProductCode = key.productCode,
Article = key.article,
buyer = key.buyerCode,
Remark = key.remark,
Price = key.price,
mainFabricExpenditure = group.Sum(s => s.a.mainFabricExpenditure),
nonmainFabricExpenditure = group.Sum(s => s.a.nonMainFabricExpenditure),
receipt = group.Sum(s => s.a.receipt),
Aval = group.Sum(s => s.a.aval),
drQty = group.Sum(s => s.a.expenditure)
}).Where(s => s.Price > 0).OrderBy(s => s.ROJob);
GarmentMonitoringPrepareListViewModel garmentMonitoringPrepareListViewModel = new GarmentMonitoringPrepareListViewModel();
List <GarmentMonitoringPrepareDto> monitoringPrepareDtos = new List <GarmentMonitoringPrepareDto>();
foreach (var item in querySum)
{
GarmentMonitoringPrepareDto garmentMonitoringPrepareDto = new GarmentMonitoringPrepareDto()
{
article = item.Article,
roJob = item.ROJob,
productCode = item.ProductCode,
roAsal = item.ROAsal,
uomUnit = "MT",
remainQty = Math.Round(item.stock + item.receipt - item.nonmainFabricExpenditure - item.mainFabricExpenditure - item.Aval - item.drQty, 2),
stock = Math.Round(item.stock, 2),
remark = item.Remark,
receipt = Math.Round(item.receipt, 2),
aval = Math.Round(item.Aval, 2),
nonMainFabricExpenditure = Math.Round(item.nonmainFabricExpenditure, 2),
mainFabricExpenditure = Math.Round(item.mainFabricExpenditure, 2),
expenditure = Math.Round(item.drQty, 2),
price = Math.Round(item.Price, 2),
buyerCode = item.buyer,
nominal = (item.stock + item.receipt - item.nonmainFabricExpenditure - item.mainFabricExpenditure - item.Aval - item.drQty) * Convert.ToDouble(item.Price)
};
monitoringPrepareDtos.Add(garmentMonitoringPrepareDto);
}
var datas = from aa in monitoringPrepareDtos
where Math.Round(aa.stock, 2) > 0 || Math.Round(aa.receipt, 2) > 0 || Math.Round(aa.aval, 2) > 0 || Math.Round(aa.mainFabricExpenditure, 2) > 0 || Math.Round(aa.nonMainFabricExpenditure, 2) > 0 || Math.Round(aa.remainQty, 2) > 0
select aa;
monitoringPrepareDtos = datas.ToList();
double stocks = 0;
double receipts = 0;
double avals = 0;
double nonMainFabric = 0;
double mainFabric = 0;
double expenditure = 0;
double nominals = 0;
foreach (var item in datas)
{
stocks += item.stock;
receipts += item.receipt;
expenditure += item.expenditure;
avals += item.aval;
mainFabric += item.mainFabricExpenditure;
nonMainFabric += item.nonMainFabricExpenditure;
nominals += item.nominal;
}
GarmentMonitoringPrepareDto garmentMonitoringPrepareDtos = new GarmentMonitoringPrepareDto()
{
article = "",
roJob = "",
productCode = "",
roAsal = "",
uomUnit = "",
remainQty = stocks + receipts - nonMainFabric - mainFabric - avals - expenditure,
stock = stocks,
remark = "",
receipt = receipts,
aval = avals,
nonMainFabricExpenditure = nonMainFabric,
mainFabricExpenditure = mainFabric,
expenditure = expenditure,
price = 0,
buyerCode = "",
nominal = nominals
};
monitoringPrepareDtos.Add(garmentMonitoringPrepareDtos);
garmentMonitoringPrepareListViewModel.garmentMonitorings = monitoringPrepareDtos;
var reportDataTable = new DataTable();
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "RO JOB", DataType = typeof(string)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Article", DataType = typeof(string)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Kode Buyer", DataType = typeof(string)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Kode Barang", DataType = typeof(string)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Satuan", DataType = typeof(string)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Asal Barang", DataType = typeof(string)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Keterangan Barang", DataType = typeof(string)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Harga(M)", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Stock Awal", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Barang Masuk", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Keluar Ke Cutting(MAIN FABRIC)", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Keluar Ke Cutting(NON MAIN FABRIC)", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "BARANG Keluar ke Gudang", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Aval", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Sisa", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Nominal Sisa", DataType = typeof(double)
});
int counter = 5;
if (garmentMonitoringPrepareListViewModel.garmentMonitorings.Count > 0)
{
foreach (var report in garmentMonitoringPrepareListViewModel.garmentMonitorings)
{
reportDataTable.Rows.Add(report.roJob, report.article, report.buyerCode, report.productCode, report.uomUnit, report.roAsal, report.remark, report.price, report.stock, report.receipt, report.mainFabricExpenditure, report.nonMainFabricExpenditure, report.expenditure, report.aval, report.remainQty, report.nominal);
counter++;
}
}
using (var package = new ExcelPackage())
{
var worksheet = package.Workbook.Worksheets.Add("Sheet 1");
worksheet.Column(8).Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
worksheet.Cells["H" + 2 + ":H" + counter + ""].Style.Numberformat.Format = "#,##0.00";
worksheet.Column(9).Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
worksheet.Cells["I" + 2 + ":I" + counter + ""].Style.Numberformat.Format = "#,##0.00";
worksheet.Column(10).Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
worksheet.Cells["J" + 2 + ":J" + counter + ""].Style.Numberformat.Format = "#,##0.00";
worksheet.Column(11).Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
worksheet.Cells["K" + 2 + ":K" + counter + ""].Style.Numberformat.Format = "#,##0.00";
worksheet.Column(12).Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
worksheet.Cells["L" + 2 + ":L" + counter + ""].Style.Numberformat.Format = "#,##0.00";
worksheet.Column(13).Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
worksheet.Cells["M" + 2 + ":M" + counter + ""].Style.Numberformat.Format = "#,##0.00";
worksheet.Column(14).Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
worksheet.Cells["N" + 2 + ":N" + counter + ""].Style.Numberformat.Format = "#,##0.00";
worksheet.Column(15).Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
worksheet.Cells["O" + 2 + ":P" + counter + ""].Style.Numberformat.Format = "#,##0.00";
worksheet.Cells["A" + 5 + ":P" + counter + ""].Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
worksheet.Cells["A" + 5 + ":P" + counter + ""].Style.Border.Top.Style = ExcelBorderStyle.Thin;
worksheet.Cells["A" + 5 + ":P" + counter + ""].Style.Border.Left.Style = ExcelBorderStyle.Thin;
worksheet.Cells["A" + 5 + ":P" + counter + ""].Style.Border.Right.Style = ExcelBorderStyle.Thin;
worksheet.Cells["H" + (counter) + ":O" + (counter) + ""].Style.Font.Bold = true;
worksheet.Cells["A" + 1 + ":P" + 1 + ""].Style.Font.Bold = true;
worksheet.Row(5).Style.Font.Bold = true;
worksheet.Row(counter).Style.Font.Bold = true;
worksheet.Cells["A1"].Value = "Report Prepare"; worksheet.Cells["A" + 1 + ":O" + 1 + ""].Merge = true;
worksheet.Cells["A2"].Value = "Periode " + dateFrom.ToString("dd-MM-yyyy") + " s/d " + dateTo.ToString("dd-MM-yyyy");
worksheet.Cells["A3"].Value = "Konfeksi " + _unitName;
worksheet.Cells["A" + 1 + ":P" + 1 + ""].Merge = true;
worksheet.Cells["A" + 2 + ":P" + 2 + ""].Merge = true;
worksheet.Cells["A" + 3 + ":P" + 3 + ""].Merge = true;
worksheet.Cells["A" + 1 + ":P" + 3 + ""].Style.Font.Size = 15;
worksheet.Cells["A" + 1 + ":P" + 3 + ""].Style.Font.Bold = true;
worksheet.Cells["A" + 1 + ":P" + 6 + ""].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
worksheet.Cells["A" + 1 + ":P" + 6 + ""].Style.VerticalAlignment = ExcelVerticalAlignment.Center;
worksheet.Cells["A5"].LoadFromDataTable(reportDataTable, true);
worksheet.Cells["E" + 5 + ":P" + 5 + ""].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
var stream = new MemoryStream();
if (request.type != "bookkeeping")
{
worksheet.Column(3).Hidden = true;
worksheet.Column(8).Hidden = true;
worksheet.Cells["A" + (counter) + ":G" + (counter) + ""].Merge = true;
worksheet.Cells["A" + (counter) + ":G" + (counter) + ""].Style.Font.Bold = true;
}
else
{
worksheet.Cells["A" + (counter) + ":H" + (counter) + ""].Merge = true;
worksheet.Cells["A" + (counter) + ":H" + (counter) + ""].Style.Font.Bold = true;
}
package.SaveAs(stream);
return(stream);
}
}
public async Task <GarmentMonitoringPrepareListViewModel> Handle(GetMonitoringPrepareQuery request, CancellationToken cancellationToken)
{
DateTimeOffset dateFrom = new DateTimeOffset(request.dateFrom, new TimeSpan(7, 0, 0));
DateTimeOffset dateTo = new DateTimeOffset(request.dateTo, new TimeSpan(7, 0, 0));
var QueryMutationPrepareNow = from a in (from aa in garmentPreparingRepository.Query
where aa.UnitId == request.unit && aa.ProcessDate <= dateTo
select aa)
join b in garmentPreparingItemRepository.Query on a.Identity equals b.GarmentPreparingId
select new { Buyer = a.BuyerCode, RO = a.RONo, Articles = a.Article, Id = a.Identity, DetailExpend = b.UENItemId, Processdate = a.ProcessDate };
//List<int> detailExpendId = new List<int>();
//foreach (var item in QueryMutationPrepareNow.Distinct())
//{
// detailExpendId.Add(item.DetailExpend);
//}
//ExpenditureROResult dataExpenditure = await GetExpenditureById(detailExpendId, request.token);
var sumbasicPrice = (from a in garmentPreparingRepository.Query
join b in garmentPreparingItemRepository.Query on a.Identity equals b.GarmentPreparingId
where /*(request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) &&*/
a.UnitId == request.unit
select new { a.RONo, b.BasicPrice })
.GroupBy(x => new { x.RONo }, (key, group) => new ViewBasicPrices
{
RO = key.RONo,
BasicPrice = Convert.ToDecimal(group.Sum(s => s.BasicPrice)),
Count = group.Count()
});
var QueryMutationPrepareItemsROASAL = (from a in QueryMutationPrepareNow
join b in garmentPreparingItemRepository.Query on a.Id equals b.GarmentPreparingId
where b.UENItemId == a.DetailExpend
select new { article = a.Articles, roJob = a.RO, buyerCode = a.Buyer, price = Convert.ToDecimal((from aa in sumbasicPrice where aa.RO == a.RO select aa.BasicPrice / aa.Count).FirstOrDefault()), prepareitemid = b.Identity, roasal = b.ROSource });
var QueryCuttingDONow = from a in (from data in garmentCuttingInRepository.Query where data.UnitId == request.unit && data.CuttingInDate <= dateTo select data)
join b in garmentCuttingInItemRepository.Query on a.Identity equals b.CutInId
join c in garmentCuttingInDetailRepository.Query on b.Identity equals c.CutInItemId
select new monitoringView {
prepareItemId = c.PreparingItemId, price = Convert.ToDecimal((from aa in sumbasicPrice where aa.RO == a.RONo select aa.BasicPrice / aa.Count).FirstOrDefault()), expenditure = 0, aval = 0, uomUnit = "", stock = a.CuttingInDate < dateFrom ? -c.PreparingQuantity : 0, nonMainFabricExpenditure = a.CuttingType == "Non Main Fabric" && (a.CuttingInDate >= dateFrom) ? c.PreparingQuantity : 0, mainFabricExpenditure = a.CuttingType == "Main Fabric" && (a.CuttingInDate >= dateFrom) ? c.PreparingQuantity : 0, remark = c.DesignColor, receipt = 0, productCode = c.ProductCode, remainQty = 0
};
var QueryMutationPrepareItemNow = (from d in QueryMutationPrepareNow
join e in garmentPreparingItemRepository.Query on d.Id equals e.GarmentPreparingId
//join c in dataExpenditure.data on e.UENItemId equals c.DetailExpenditureId
where e.UENItemId == d.DetailExpend
select new monitoringView {
prepareItemId = e.Identity, price = Convert.ToDecimal((from aa in sumbasicPrice where aa.RO == d.RO select aa.BasicPrice / aa.Count).FirstOrDefault()), uomUnit = "", stock = d.Processdate < dateFrom ? e.Quantity : 0, mainFabricExpenditure = 0, nonMainFabricExpenditure = 0, remark = e.DesignColor, receipt = (d.Processdate >= dateFrom ? e.Quantity : 0), productCode = e.ProductCode, remainQty = e.RemainingQuantity
}).Distinct();
var QueryAval = from a in (from data in garmentAvalProductRepository.Query where data.AvalDate <= dateTo select data)
join b in garmentAvalProductItemRepository.Query on a.Identity equals b.APId
join c in garmentPreparingItemRepository.Query on Guid.Parse(b.PreparingItemId) equals c.Identity
join d in (from data in garmentPreparingRepository.Query where data.UnitId == request.unit select data) on c.GarmentPreparingId equals d.Identity
select new monitoringView
{
prepareItemId = c.Identity, price = Convert.ToDecimal((from aa in sumbasicPrice where aa.RO == a.RONo select aa.BasicPrice / aa.Count).FirstOrDefault()), expenditure = 0, aval = a.AvalDate >= dateFrom ? b.Quantity : 0, uomUnit = "", stock = a.AvalDate < dateFrom ? -b.Quantity : 0, mainFabricExpenditure = 0, nonMainFabricExpenditure = 0, remark = b.DesignColor, receipt = 0, productCode = b.ProductCode, remainQty = 0
};
var QueryDeliveryReturn = from a in (from data in garmentDeliveryReturnRepository.Query where data.ReturnDate <= dateTo && data.UnitId == request.unit select data)
join b in garmentDeliveryReturnItemRepository.Query on a.Identity equals b.DRId
join c in garmentPreparingItemRepository.Query on Guid.Parse(b.PreparingItemId) equals(c.Identity)
select new monitoringView
{
prepareItemId = c.Identity, price = Convert.ToDecimal((from aa in sumbasicPrice where aa.RO == a.RONo select aa.BasicPrice / aa.Count).FirstOrDefault()), expenditure = a.ReturnDate >= dateFrom ? b.Quantity : 0, aval = 0, uomUnit = "", stock = a.ReturnDate < dateFrom ? -b.Quantity : 0, mainFabricExpenditure = 0, nonMainFabricExpenditure = 0, remark = b.DesignColor, receipt = 0, productCode = b.ProductCode, remainQty = 0
};
var queryNow = from a in (QueryMutationPrepareItemNow
.Union(QueryCuttingDONow)
.Union(QueryAval)
.Union(QueryDeliveryReturn).AsEnumerable())
join b in QueryMutationPrepareItemsROASAL on a.prepareItemId equals b.prepareitemid
select new { a, b };
var querySum = queryNow.GroupBy(x => new { x.a.price, x.b.roasal, x.b.roJob, x.b.article, x.b.buyerCode, x.a.productCode, x.a.remark }, (key, group) => new
{
ROAsal = key.roasal,
ROJob = key.roJob,
stock = group.Sum(s => s.a.stock),
ProductCode = key.productCode,
Article = key.article,
buyer = key.buyerCode,
Remark = key.remark,
Price = key.price,
mainFabricExpenditure = group.Sum(s => s.a.mainFabricExpenditure),
nonmainFabricExpenditure = group.Sum(s => s.a.nonMainFabricExpenditure),
receipt = group.Sum(s => s.a.receipt),
Aval = group.Sum(s => s.a.aval),
drQty = group.Sum(s => s.a.expenditure)
}).Where(s => s.Price > 0).OrderBy(s => s.ROJob);
GarmentMonitoringPrepareListViewModel garmentMonitoringPrepareListViewModel = new GarmentMonitoringPrepareListViewModel();
List <GarmentMonitoringPrepareDto> monitoringPrepareDtos = new List <GarmentMonitoringPrepareDto>();
foreach (var item in querySum)
{
GarmentMonitoringPrepareDto garmentMonitoringPrepareDto = new GarmentMonitoringPrepareDto()
{
article = item.Article,
roJob = item.ROJob,
productCode = item.ProductCode,
roAsal = item.ROAsal,
uomUnit = "MT",
remainQty = Math.Round(item.stock + item.receipt - item.nonmainFabricExpenditure - item.mainFabricExpenditure - item.Aval - item.drQty, 2),
stock = Math.Round(item.stock, 2),
remark = item.Remark,
receipt = Math.Round(item.receipt, 2),
aval = Math.Round(item.Aval, 2),
nonMainFabricExpenditure = Math.Round(item.nonmainFabricExpenditure, 2),
mainFabricExpenditure = Math.Round(item.mainFabricExpenditure, 2),
expenditure = Math.Round(item.drQty, 2),
price = Math.Round(item.Price, 2),
buyerCode = item.buyer,
nominal = (item.stock + item.receipt - item.nonmainFabricExpenditure - item.mainFabricExpenditure - item.Aval - item.drQty) * Convert.ToDouble(item.Price)
};
monitoringPrepareDtos.Add(garmentMonitoringPrepareDto);
}
var datas = from aa in monitoringPrepareDtos
where Math.Round(aa.stock, 2) > 0 || Math.Round(aa.receipt, 2) > 0 || Math.Round(aa.aval, 2) > 0 || Math.Round(aa.mainFabricExpenditure, 2) > 0 || Math.Round(aa.nonMainFabricExpenditure, 2) > 0 || Math.Round(aa.remainQty, 2) > 0
select aa;
monitoringPrepareDtos = datas.ToList();
garmentMonitoringPrepareListViewModel.garmentMonitorings = monitoringPrepareDtos;
return(garmentMonitoringPrepareListViewModel);
}