private void monthlyReport() { MonthlyReportData reportDetails = new MonthlyReportData(); DataTable dtTable = reportDetails.CompanyDetails; MonthlyReport Report = new MonthlyReport(); readCompanyDetails(); DataRow drr = dtTable.NewRow(); drr["CompanyName"] = companyName; drr["CompanyDetails"] = companyDetails; dtTable.Rows.Add(drr); Report.Database.Tables["CompanyDetails"].SetDataSource((DataTable)dtTable); monthlyList(); DataTable dataTable = reportDetails._MonthlyReportData; for (int i = 0; i < saleDateList.Count; i++) { DataRow drow = dataTable.NewRow(); string[] fDate = Regex.Split(fromDate.ToString(), " "); drow["DateFrom"] = fDate[0]; string[] tDate = Regex.Split(toDate.ToString(), " "); drow["DateTo"] = tDate[0]; drow["BillNoFrom"] = bnoFromList[i]; drow["BillNoTo"] = bnoToList[i]; drow["SaleDate"] = saleDateList[i]; drow["GrossValue"] = totalPriceList[i]; drow["Discount"] = discountList[i]; drow["Gst"] = netGstList[i]; drow["SalesReturn"] = salesReturnList[i]; drow["Credit"] = creditList[i]; drow["CashPaid"] = cashPaidList[i]; drow["GrandTotal"] = grandTotalList[i]; drow["TotalExpense"] = expenseAmountList.Sum(); dataTable.Rows.Add(drow); } DataRow droww = dataTable.NewRow(); droww["TotalGross"] = totalPriceList.Sum(); droww["TotalDiscount"] = discountList.Sum(); droww["TotalGst"] = netGstList.Sum(); droww["TotalSalesReturn"] = salesReturnList.Sum(); droww["TotalCredit"] = creditList.Sum(); droww["TotalCashPaid"] = cashPaidList.Sum(); droww["TotalGrand"] = grandTotalList.Sum(); droww["NetExpense"] = expenseAmountList.Sum(); dataTable.Rows.Add(droww); Report.Database.Tables["MonthlyReportData"].SetDataSource((DataTable)dataTable); sales_Reporter_Viewer.ViewerCore.ReportSource = Report; Report.Refresh(); }
public static void MakeMonthlyReport() { List <Item> items = ItemData.FindAll(); string dt = string.Format("{0}/{1}", DateTime.Today.Month, DateTime.Today.Year); foreach (Item item in items) { int sbalance = StockCardData.GetStockBalanceByItemAndMonth(item, dt); int mcons = StockCardData.GetConsByItemAndMonth(item, dt); MonthlyReportData.CreateMonthlyReport(item.Id, dt, mcons, sbalance); } }
/////////////////////////////////////////////////////////Trend Report public async Task <ActionResult> TrendReport(int itemId) { Dictionary <int, Dictionary <string, int> > trendlist = (Dictionary <int, Dictionary <string, int> >)Session["trendlist"]; Item item = ItemData.GetItemById(itemId); List <string> monlist = new List <string>(); Dictionary <string, int> itemsbtrend = new Dictionary <string, int>(); for (int i = 12; i >= 1; i--) { string dt = string.Format("{0}/{1}", DateTime.Today.AddMonths(-i).Month, DateTime.Today.AddMonths(-i).Year); monlist.Add(dt); //Get stockbalance on given month from monthly report int stockbalance = MonthlyReportData.GetMonthlyStockbalanceByMonthAndItemId(dt, itemId); itemsbtrend.Add(dt, stockbalance); } int[] cons = trendlist[itemId].Values.ToArray(); int[] prelist = new int[4]; int[] paralist = new int[13]; paralist[0] = itemId; for (int i = 1; i < 13; i++) { paralist[i] = cons[i - 1]; } string conshist = string.Join(", ", paralist); using (var client = new HttpClient()) { string xValue = conshist; // send a GET request to the server uri with the data and get the response as HttpResponseMessage object HttpResponseMessage res = await client.GetAsync("http://127.0.0.1:5000/model1?x=" + xValue); // Return the result from the server if the status code is 200 (everything is OK) // should raise exception or error if it's not if (res.IsSuccessStatusCode) { // pass the result to update the user preference // have to read as string for the data in response.body //pre = Convert.ToInt32(res.Content.ReadAsStringAsync().Result); //if only display one month prediction. string arr = res.Content.ReadAsStringAsync().Result; prelist = arr.Split(',').Select(str => int.Parse(str)).ToArray(); } else { prelist = new int[4] { 0, 0, 0, 0 } }; } ViewBag.cons = cons; ViewBag.months = monlist.ToArray(); ViewBag.Item = item; ViewBag.sbalance = itemsbtrend.Values.ToArray(); ViewBag.prediction = prelist; return(View()); }
public ActionResult TrendReportList(string searchStr, int?page) { List <StockCard> itemlistsc = new List <StockCard>(); Dictionary <int, Dictionary <string, int> > trendlist = new Dictionary <int, Dictionary <string, int> >(); List <string> monlist = new List <string>(); for (int i = 12; i >= 1; i--) { string dt = string.Format("{0}/{1}", DateTime.Today.AddMonths(-i).Month, DateTime.Today.AddMonths(-i).Year); monlist.Add(dt); } //////////////////////////////////////////////////////searchbox feature List <Item> listitem = ItemData.FindAll(); List <Item> resultlist = new List <Item>(); ViewBag.listItem = listitem; IPagedList <Item> resultlist1; bool match = false; if (searchStr == null || searchStr == "") { searchStr = ""; resultlist1 = listitem.ToPagedList(page ?? 1, 7); } else { foreach (Item Pro in listitem) { bool fit = false; if (Search.Found(Pro.Description, searchStr).fit) { fit = true; Pro.Description = Search.Found(Pro.Description, searchStr).str; } if (fit) { match = true; resultlist.Add(Pro); } } resultlist1 = resultlist.ToPagedList(page ?? 1, 7); } ViewBag.listitem = resultlist1; ViewData["searchStr"] = searchStr; ViewData["match"] = match; ///////////////////////////////////////////////////////////// foreach (Item item in resultlist1) { Dictionary <string, int> itemsbtrend = new Dictionary <string, int>(); Dictionary <string, int> itemtrend = new Dictionary <string, int>(); foreach (string m in monlist) { //Get monthly consumption quant on given month int cons = MonthlyReportData.GetMonthlyConsByMonthAndItemId(m, item.Id); itemtrend.Add(m, cons); } trendlist.Add(item.Id, itemtrend); } ViewBag.trendlist = trendlist; ViewBag.monthslist = monlist; Session["trendlist"] = trendlist; return(View()); }