public ActionResult Report(SupplierVM supplierVM)
{
SupplierReport _supplierReport = new SupplierReport();
byte[] abytes = _supplierReport.PrepareReport();
return(File(abytes, "application/pdf"));
}
public byte[] SupplierReport(string sqlConnectionString, DateTime fromDate, DateTime toDate, int?buildingId, int?supplierId)
{
using (var dc = new DataContext(sqlConnectionString))
{
var rp = new SupplierReport(dc);
return(rp.RunReport(fromDate, toDate, buildingId, supplierId));
}
}
private void btn_SupReport_Click(object sender, EventArgs e)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
string s = "Select * FROM Supplier";
SqlCommand cmd = new SqlCommand(s, conn);
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds, "Supplier");
SupplierReport cr1 = new SupplierReport();
cr1.SetDataSource(ds);
CrisReport.ReportSource = cr1;
conn.Close();
CrisReport.Refresh();
}
public async Task <IActionResult> ReportOrdersFromSupplier([FromRoute] Guid supplierId)
{
try
{
var supplier = await _uow.Repository <Supplier>().GetAll()
.FirstOrDefaultAsync(s => s.SupplierId == supplierId);
if (supplier == null)
{
return(Ok(new { info = "There is no such supplier." }));
}
var productsSupplier = _uow.Repository <Order>().GetAll()
.Join(_uow.Repository <OrderedItem>().GetAll(), order => order.OrderId,
item => item.OrderId,
(order, item) => new
{
OrderId = order.OrderId,
OrderStartDate = order.OrderStartDate,
OrderStopDate = order.OrderStopDate,
OrderedItemId = item.OrderedItemId,
ProductId = item.ProductId,
Quantity = item.Quantity
})
.Join(_uow.Repository <Product>().GetAll(),
orderItem => orderItem.ProductId,
product => product.ProductId,
(orderItem, product) => new
{
OrderId = orderItem.OrderId,
OrderStartDate = orderItem.OrderStartDate,
OrderStopDate = orderItem.OrderStopDate,
OrderedItemId = orderItem.OrderedItemId,
ProductId = orderItem.ProductId,
Quantity = orderItem.Quantity,
ProductName = product.ProductName,
Price = product.Price,
UnitName = product.Unit.UnitName,
SupplierId = product.SupplierId
})
.Where(x => x.SupplierId == supplierId);
if (ControllerContext.ActionDescriptor.AttributeRouteInfo?.Name == "LastOrderGrande")
{
var lastOrderGrandeId = _uow.Repository <Order>().GetAll()
.OrderByDescending(x => x.OrderStopDate)
.FirstOrDefault()?.OrderId;
productsSupplier = productsSupplier.Where(x => x.OrderId == lastOrderGrandeId);
}
if (!productsSupplier.Any())
{
return(Ok(new { info = "The supplier did not sell any products." }));
}
var groupOrder = productsSupplier
.AsEnumerable()
.GroupBy(x => x.OrderId);
var supplierReport = new SupplierReport
{
SupplierId = supplier.SupplierId,
SupplierName = supplier.SupplierName,
SupplierAbbr = supplier.SupplierAbbr,
Email = supplier.Email
};
foreach (var group in groupOrder)
{
var groupKey = group.Key;
var supplierOrder = new SupplierReportOrder
{
OrderId = groupKey,
};
foreach (var groupItem in group)
{
if (supplierOrder.OrderId == groupItem.OrderId)
{
supplierOrder.OrderStartDate = groupItem.OrderStartDate;
supplierOrder.OrderStopDate = groupItem.OrderStopDate;
supplierOrder.SupplierReport = supplierReport;
}
var supplierItem = new SupplierReportItem
{
ProductId = groupItem.ProductId,
ProductName = groupItem.ProductName,
Price = groupItem.Price,
Quantity = groupItem.Quantity,
UnitName = groupItem.UnitName,
SupplierReportOrder = supplierOrder,
TotalPrice = Math.Round((decimal)groupItem.Price * groupItem.Quantity, 2,
MidpointRounding.AwayFromZero)
};
supplierOrder.OrderTotalPrice += supplierItem.TotalPrice;
if (supplierOrder.SupplierReportItems.AreEquals(supplierItem) is var index && index > -1)
{
supplierOrder.SupplierReportItems[index].Quantity += groupItem.Quantity;
supplierOrder.SupplierReportItems[index].TotalPrice += supplierItem.TotalPrice;
}
else
{
supplierOrder.SupplierReportItems.Add(supplierItem);
}
}
