public ActionResult _TransactionEnquiryReport(HelpReportModel help)
{
var body = Newtonsoft.Json.JsonConvert.SerializeObject(help);
var model = ServerResponse.Invoke <List <TransactionEnquiryModel> >("api/report/transactionEnquiry", body, "POST");
return(PartialView(model));
}
public ActionResult TransactionEnquiryReport()
{
var obj = new HelpReportModel();
var body = Newtonsoft.Json.JsonConvert.SerializeObject(obj);
var BranchId = Services.BranchService.GetAll();
ViewBag.BranchId = new SelectList(BranchId, "Id", "Name");
var model = ServerResponse.Invoke <List <TransactionEnquiryModel> >("api/report/transactionEnquiry", body, "POST");
return(View(model));
}
public IHttpActionResult TransactionEnquiryReport(HelpReportModel model)
{
var _modellist = db.Branches.Where(x => x.IsActive == true);
if (!string.IsNullOrEmpty(model.branchFrom) && !string.IsNullOrEmpty(model.branchTo))
{
var bfrom = Convert.ToInt32(model.branchFrom);
var bto = Convert.ToInt32(model.branchTo);
var bcodelist = Utility.getRangeList(bfrom, bto, 3);
_modellist = _modellist.Where(x => bcodelist.Contains(x.BranchCode));
}
var modellist = _modellist.ToList();//db.Branches.Where(x => x.IsActive == true && bcodelist.Contains(x.BranchCode)).ToList();//.Select(s => s.Id).ToList();
//.Include(i => i.SalesOrders)
//.Include(i => i.SalesOrders.Select(s => s.SalesOrderItems))
//.Include(i => i.SalesOrders.Select(s => s.SalesOrderItems.Select(p => p.Product)))
//.Include(i => i.SalesOrders.Select(s => s.SalesOrderItems.Select(p => p.Product.Color)));
var branchList = new List <Branch>();
foreach (var item in modellist)
{
var _saleorder = db.SalesOrders.Where(x => x.IsActive == true && x.BranchId == item.Id);
if (!string.IsNullOrEmpty(model.startDate) && !string.IsNullOrEmpty(model.endDate))
{
var StartDate = Convert.ToDateTime(model.startDate).Date;
var EndDate = Convert.ToDateTime(model.endDate).AddDays(1).Date;
_saleorder = _saleorder.Where(x => x.TransactionDate >= StartDate && x.TransactionDate < EndDate);
}
var SalesOrders = _saleorder.ToList();//db.SalesOrders.Where(x => x.IsActive == true && x.BranchId == item.Id).ToList();//.ToList();
if (SalesOrders != null && SalesOrders.Count > 0)
{
var salesOrderList = new List <SalesOrder>();
foreach (var salesOrder in SalesOrders)
{
var _salesOrderItem = db.SalesOrderItems.Where(x => x.IsActive == true && x.SalesOrderId == salesOrder.Id &&
x.Product != null &&
x.Product.IsActive == true &&
x.Product.Color != null &&
x.Product.Color.IsActive == true
)
.Include(i => i.Product)
.Include(i => i.Product.Color);
if (!string.IsNullOrEmpty(model.productSKUFrom) && !string.IsNullOrEmpty(model.productSKUTo))
{
var bfrom = Convert.ToInt32(model.productSKUFrom);
var bto = Convert.ToInt32(model.productSKUTo);
var bcodelist = Utility.getRangeList(bfrom, bto, 3);
_salesOrderItem = _salesOrderItem.Where(x => bcodelist.Contains(x.Product.ProductSKU));
}
if (!string.IsNullOrEmpty(model.styleSKUFrom) && !string.IsNullOrEmpty(model.styleSKUFrom))
{
var bfrom = Convert.ToInt32(model.styleSKUFrom);
var bto = Convert.ToInt32(model.styleSKUTo);
var bcodelist = Utility.getRangeList(bfrom, bto, 4);
_salesOrderItem = _salesOrderItem.Where(x => bcodelist.Contains(x.Product.StyleSKU));
}
var salesOrderItem = _salesOrderItem.ToList();
salesOrder.SalesOrderItems = new List <SalesOrderItem>();
salesOrder.SalesOrderItems = salesOrderItem;
salesOrderList.Add(salesOrder);
}
item.SalesOrders = new List <SalesOrder>();
item.SalesOrders = salesOrderList;
branchList.Add(item);
}
}
var Branches = modellist.ToList();
var branch = TransactionEnquiryProcessing(branchList);
return(Ok(branch));
}
