//public StatisticsViewModel CountViewOverviewEcommerce(string keyword)
//{
// var result = _botDomainRepository.GetAllIQueryable().Where(x =>
// x.RECORD_STATUS == "1").ToList();
// StatisticsViewModel statisticsViewModel = new StatisticsViewModel();
// double sum=0;
// foreach (var item in result)
// {
// statisticsViewModel.SUM_ITEM_REVENUE += Double.Parse(item.ITEM_REVENUE);
// statisticsViewModel.SUM_PRODUCT_DETAIL_VIEWS += Double.Parse(item.PRODUCT_DETAIL_VIEWS);
// statisticsViewModel.SUM_QUANTITY_ADDED_TO_CART += Double.Parse(item.QUANTITY_ADDED_TO_CART);
// statisticsViewModel.SUM_QUANTITY_CHECKED_OUT += Double.Parse(item.QUANTITY_CHECKED_OUT);
// }
// double sumGroup = 0;
// var result2 = _botDomainRepository.GetAllIQueryable().Where(x =>
// x.RECORD_STATUS == "1").GroupBy(x=>x.PRODUCT_NAME).ToList();
// List<ProductPerformace> list = new List<ProductPerformace>();
// foreach (var itemGroup in result2)
// {
// // Nested foreach is required to access group items.
// foreach (var item in itemGroup)
// {
// item.ITEM_REVENUE += Double.Parse(item.ITEM_REVENUE);
// item.PRODUCT_DETAIL_VIEWS += Double.Parse(item.PRODUCT_DETAIL_VIEWS);
// item.QUANTITY_ADDED_TO_CART += Double.Parse(item.QUANTITY_ADDED_TO_CART);
// list.Add(item);
// // Console.WriteLine("\t{student.LastName}, {student.FirstName}");
// }
// }
// statisticsViewModel.SUM_LISTPRODUCT_OVERVIEWE_COMMERCE = list;
// return statisticsViewModel;
// //var version = GetVersionFinal();
// //var result = _botDomainRepository.GetAllIQueryable().Where(x =>
// // x.RECORD_STATUS == "1" && x.VERSION_INT == version).OrderByDescending(x => x.ITEM_REVENUE);
//}
public void Add(ProductPerformace botDomain)
{
_botDomainRepository.Add(botDomain);
}
public void Update(ProductPerformace botDomain)
{
_botDomainRepository.Update(botDomain);
}
public IActionResult Post([FromBody] Welcome welcome)
{
var reports = welcome.FormattedJson;
var project = welcome.Project;
IActionResult _result = new ObjectResult(false);
GenericResult _addResult = null;
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//ADD
var version = _productPerformaceService.GetVersionFinal(project["PROJECT_ID"]);
_productPerformaceService.RemoveVersionOld(project["PROJECT_ID"]);
var rows = reports.Reports[0].Data.Rows;
if (rows == null)
{
_addResult = new GenericResult()
{
Succeeded = false,
Message = "Không có dữ liệu trong 30 ngày gần nhất"
};
_result = new ObjectResult(_addResult);
return(_result);
}
for (int i = 0; i < rows.Length; i++)
{
var productName = rows[i].Dimensions[0];
var values = rows[i].Metrics[0].Values;
// decimal moeny = Decimal.Parse(values[0], System.Globalization.NumberStyles.Any);
// var moeny= Double.Parse(values[0], System.Globalization.NumberStyles.Float);
//string[] moeny = values[0].ToString().Split('E');
//var x = Double.Parse(moeny[0])*(10^moeny)
ProductPerformace newProductPerformace = new ProductPerformace
{
OVERVIEW_ECOMMERCE_ID = 0,
PRODUCT_NAME = productName,
// ITEM_REVENUE = moeny.ToString(),
ITEM_REVENUE = values[0],
PRODUCT_DETAIL_VIEWS = values[1],
QUANTITY_ADDED_TO_CART = values[2],
QUANTITY_CHECKED_OUT = values[3],
CREATE_DT = DateTime.Now,
RECORD_STATUS = "1",
VERSION_INT = version + 1,
VERSION = (version + 1).ToString(),
PROJECT_ID = project["PROJECT_ID"],
DOMAIN = project["DOMAIN"]
};
_productPerformaceService.Add(newProductPerformace);
_productPerformaceService.Save();
}
//ProductPerformace _newOverviewEcommerce = PropertyCopy.Copy<ProductPerformace, DomainViewModel>(overviewEcommerce);
//_newOverviewEcommerce.CREATE_DT = DateTime.Now;
//_newOverviewEcommerce.PROJECT_ID = 1;
_addResult = new GenericResult()
{
Succeeded = true,
Message = "Add success."
};
}
catch (Exception ex)
{
_addResult = new GenericResult()
{
Succeeded = false,
Message = ex.Message
};
_loggingRepository.Add(new Error()
{
Message = ex.Message, StackTrace = ex.StackTrace, DateCreated = DateTime.Now
});
_loggingRepository.Commit();
}
_result = new ObjectResult(_addResult);
return(_result);
}
