public ActionResult getSalesReportByProductType(string start,string end)
{
List<UTDWSClient.Interfaces.SalesReportByProductType_Result> report = ReportMethods.getSalesReportByProductType(Convert.ToDateTime(start), Convert.ToDateTime(end));
List<SalesReport> listaSales = new List<SalesReport>();
foreach (var key in report)
{
SalesReport sales = new SalesReport()
{
PRODUCT_TYPE = Convert.ToString(key.PRODUCT_TYPE),
QUANTITY = Convert.ToString(key.QUANTITY),
AMOUNT = Convert.ToString(key.GROSS_TOTAL),
MCOMM_COMMISSION = Convert.ToString(key.M_COMMISSION),
NET_AMOUNT = Convert.ToString(key.NET_AMOUNT)
};
sales.ReportType = 3;
listaSales.Add(sales);
}
var result = listaSales;
return View(result);
}
public ActionResult getSalesReportByProduct(string start, string end)
{
List<UTDWSClient.Interfaces.SalesReportByProduct_Result> report = ReportMethods.getSalesReportByproduct(Convert.ToDateTime(start), Convert.ToDateTime(end));
List<SalesReport> listaSales = new List<SalesReport>();
foreach (var key in report)
{
SalesReport sales = new SalesReport()
{
D_COMISSION = Convert.ToString(key.D_COMMISSION),
AMOUNT = Convert.ToString(key.GROSS_TOTAL),
MCOMM_COMMISSION = Convert.ToString(key.M_COMMISSION),
NET_AMOUNT = Convert.ToString(key.NET_AMOUNT),
PRODUCT = Convert.ToString(key.PRODUCT),
PRODUCT_TYPE = Convert.ToString(key.PRODUCT_TYPE),
PROVIDER = Convert.ToString(key.PROVIDER)
};
sales.ReportType = 2;
listaSales.Add(sales);
}
return View(listaSales);
}
public ActionResult getSalesReportBydate(string start,string end)
{
List<UTDWSClient.Interfaces.SalesReportByDate_Result> report = ReportMethods.getSalesReportBydate(Convert.ToDateTime(start), Convert.ToDateTime(end));
List<SalesReport> listaSales = new List<SalesReport>();
foreach (var key in report)
{
SalesReport sales = new SalesReport()
{
DATE = key.DAY,
MCOMM_COMMISSION = Convert.ToString(key.M_COMMISSION),
AMOUNT = Convert.ToString(key.GROSS_TOTAL),
NET_AMOUNT = Convert.ToString(key.NET_AMOUNT)
,
V_COMISSION = Convert.ToString(key.V_COMMISSION),
QUANTITY = Convert.ToString(key.QUANTITY),
D_COMISSION = Convert.ToString(key.D_COMMISSION)
};
sales.ReportType = 1;
listaSales.Add(sales);
}
var resultList = listaSales;
return View(resultList);
}
public ActionResult getSalesReportGeneral(string start,string end,string productType,string product,string chain,string merchant)
{
List<UTDWSClient.Interfaces.SalesReport_Result> report = ReportMethods.getSalesReport(Convert.ToDateTime(start), Convert.ToDateTime(end), productType, product, "0", chain, merchant);
List<SalesReport> listaSales = new List<SalesReport>();
foreach (var key in report)
{
SalesReport sals = new SalesReport() { DATE = Convert.ToString(key.TXNDATE), AMOUNT = Convert.ToString(key.AMOUNT), PRODUCT_TYPE = key.PRODUCT_TYPE, PRODUCT = key.PRODUCT, MERCHANT = key.MERCHANT, MCOMM_COMMISSION = Convert.ToString(key.MCOMM_COMMISSION), NET_AMOUNT = Convert.ToString(key.NET_AMOUNT), AUTH_NUMBER = Convert.ToString(key.AUTH_NUMBER), MCOMM_PERCENTAGE = Convert.ToString((key.MCOMM_PERCENTAGE) * 100 + "%"), REFERENCE = Convert.ToString(key.REFERENCE) };
sals.ReportType = 0;
listaSales.Add(sals);
}
var resulList = listaSales;
return View(resulList);
}
