//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); }