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