private void AddButton_Click(object sender, EventArgs e) { if (StockOutTextBox.Text == String.Empty) { WarningLabel.Text = "Stock Out Value is Empty"; return; } StockReport stockitem = new StockReport(); stockitem.ItemName = ItemNameComboBox.Text; stockitem.CompanyName = CompanyNameComboBox.Text; stockitem.StockOutQty = Convert.ToDecimal(StockOutTextBox.Text); stockitem.AvaliableQty = Convert.ToDecimal(AvailableQuantityLabel.Text); stockOutList.Add(stockitem); string si = Convert.ToString(serial); var lvi = new ListViewItem(new[] { si, stockitem.ItemName, stockitem.CompanyName, stockitem.StockOutQty.ToString() }); StockOutListView.Items.Add(lvi); serial++; StockOutTextBox.Text = String.Empty; }
private void toolStripButton5_Click(object sender, EventArgs e) { try { string id = this.ctrlr.getprev(doctor_id); if (doctor_id != "1") { if (int.Parse(id) > 0) { MessageBox.Show("There is No Privilege to View the Inventory", "Security Role", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { var form2 = new StockReport(); form2.doctor_id = doctor_id; form2.Closed += (sender1, args) => this.Close(); this.Hide(); form2.Show(); } } else { var form2 = new StockReport(); form2.doctor_id = doctor_id; form2.Closed += (sender1, args) => this.Close(); this.Hide(); form2.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error!...", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static int UpdateStock(StockReport item) { decimal stock = item.AvaliableQty - item.StockOutQty; string query = @"UPDATE ItemInfo SET AvailableQuantity = '" + stock + "' WHERE Name = '" + item.ItemName + "' AND " + "CompanyName = '" + item.CompanyName + "'"; SqlCommand command = new SqlCommand(query, connect); connect.Open(); result = command.ExecuteNonQuery(); if (result != 0) { result = (int)Utilities.SearchResult.Found; } else { result = (int)Utilities.SearchResult.NotFound; } connect.Close(); return(result); }
private void SaveEmData(Stock stock, StockReport stockReport) { AddNewStockData(stockReport); try { var StockCodeKey = Service.StockService.GetStockByKey(stock.StockCodeId); if (StockCodeKey != null) { if (!stockcodes.ContainsKey(stock.StockCodeId)) { stockcodes.Add(stock.StockCodeId, StockCodeKey); } stock.LastModifiedAt = DateTimeOffset.Now; Service.StockService.AddorUpdate(stock); AddNewStockData(stockReport); } else { Service.StockService.Add(stock); AddNewStockData(stockReport); } } catch (Exception ex) { MyLog.OutputAndSaveTxt(ex.Message); } }
public async Task <StockReport> AddStockReport(StockReport StockReport) { _context.StockReports.Add(StockReport); await _context.SaveChangesAsync(); return(StockReport); }
//private void Cmb_Manufacture_Click(object sender, EventArgs e) //{ // //DataTable dt = this.cntrl.Fill_manufactureCombo(); // //Fill_ManufactureCombo(dt); //} private void toolStripButton5_Click(object sender, EventArgs e) { if (doctor_id != "1") { string id = this.cntrl.privilge_for_inventory(doctor_id); if (int.Parse(id) > 0) { MessageBox.Show("There is No Privilege to View the Inventory", "Security Role", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { var form2 = new StockReport(); form2.doctor_id = doctor_id; form2.Closed += (sender1, args) => this.Close(); this.Hide(); form2.Show(); } } else { var form2 = new StockReport(); form2.doctor_id = doctor_id; form2.Closed += (sender1, args) => this.Close(); this.Hide(); form2.Show(); } }
public IActionResult GetStockHistory(string symbol) { byte[] encodedDataAsBytes = System.Convert.FromBase64String(symbol); string symbolName = System.Text.ASCIIEncoding.ASCII.GetString(encodedDataAsBytes); Globals.Log.Info($"History for {symbolName}"); return(Ok(StockReport.GetStockHistory(symbolName))); }
private void toolStripButton5_Click(object sender, EventArgs e) { var form2 = new StockReport(); form2.doctor_id = doctor_id; form2.Closed += (sender1, args) => this.Close(); this.Hide(); form2.Show(); }
public async Task <StockReport> UpdateStockReport(StockReport StockReport) { var StockReportChanges = _context.StockReports.Attach(StockReport); StockReportChanges.State = EntityState.Modified; await _context.SaveChangesAsync(); return(StockReport); }
private void AddNewStockData(StockReport stockReport) { var reportUrl = string.Format("http://data.eastmoney.com/report/{0}/{1}.html", stockReport.ReportTime.Value.ToString("yyyyMMdd"), stockReport.Infocode); stockReport.DataReportUrl = reportUrl; stockReport = Service.StockReportService.Add(stockReport); Console.WriteLine($"stockReport插入了一条数据,ID:{stockReport.StockReportId}"); Console.WriteLine(reportUrl); GetReportData(reportUrl, stockReport.StockReportId); }
public async Task <StockReport> DeleteStockReport(int id) { StockReport StockReport = _context.StockReports.Find(id); if (StockReport != null) { _context.StockReports.Remove(StockReport); await _context.SaveChangesAsync(); } return(StockReport); }
public async Task <byte[]> GeneratePdfReport(StockReport stocks) { var report = await _jsReport.RenderByNameAsync("StockReport", stocks).ConfigureAwait(false); using (var ms = new MemoryStream()) { await report.Content.CopyToAsync(ms).ConfigureAwait(false); return(ms.ToArray()); } }
private void BuildModel(EmDataDetailModel emDataDetailModel) { Stock stock = new Stock(); stock.IsActivity = true; stock.CreatedAt = DateTimeOffset.Now; stock.LastModifiedAt = DateTimeOffset.Now; #region 分区 var codes = emDataDetailModel.secuFullCode.Split('.'); if (string.IsNullOrEmpty(codes[0])) { throw new Exception("代码有问题"); } stock.StockCodeId = codes[0]; if (string.IsNullOrEmpty(codes[1])) { throw new Exception("代码有问题"); } switch (codes[1]) { case "SZ": stock.StockTypeId = 2; break; case "SH": stock.StockTypeId = 1; break; default: throw new Exception("怎么可能"); } #endregion stock.StockName = emDataDetailModel.secuName; StockReport stockReport = new StockReport(); stockReport.Author = emDataDetailModel.author; stockReport.Change = emDataDetailModel.change; stockReport.Companycode = emDataDetailModel.companyCode ?? null; stockReport.ReportTime = emDataDetailModel.datetime; stockReport.Infocode = emDataDetailModel.infoCode; stockReport.InsCode = emDataDetailModel.insCode; stockReport.InsName = emDataDetailModel.insName; stockReport.InsStar = emDataDetailModel.insStar ?? null; stockReport.Rate = emDataDetailModel.rate; stockReport.StockCodeId = stock.StockCodeId; stockReport.Title = emDataDetailModel.title; stockReport.SratingName = emDataDetailModel.sratingName; stockReport.NewPrice = emDataDetailModel.newPrice ?? null; SaveEmData(stock, stockReport); }
private void stockReportsToolStripMenuItem_Click(object sender, EventArgs e) { try { StockReport myStockReport = new StockReport(); myStockReport.MdiParent = this; MessageBox.Show("The Stock Reports Table was loaded Succcessfully. Please Press OK. to continue."); myStockReport.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void DoRowDoubleClick(DevExpress.XtraGrid.Views.Grid.GridView view, Point pt) { GridHitInfo info = view.CalcHitInfo(pt); if (info.InRow || info.InRowCell) { string colCaption = info.Column == null ? "N/A" : info.Column.GetCaption(); frmStockDetailReport frm = new frmStockDetailReport(); StockReport row = (StockReport)gridView.GetRow(info.RowHandle); frmStockDetailReport.Filterbject = row; frm.ShowDialog(); } }
public static async Task <List <StockReport> > GetStockReports(int userId, IPortfolioService portfolioService, int portfolioId) { var stocks = portfolioService.GetStocks(portfolioId, userId); var stockReports = new List <StockReport>(); foreach (var stockInfo in stocks) { var name = await stockInfo.GetName(); var price = await stockInfo.GetPrice(); var percentChange = await stockInfo.GetPriceChange(); var allPrice = await stockInfo.GetAllPrice(); var paperProfit = await stockInfo.GetPaperProfit(); var paperProfitPercent = await stockInfo.GetPaperProfitPercent(); var updateTime = await stockInfo.GetUpdateTime(); var stockReport = new StockReport() { Name = name, Ticket = stockInfo.Ticket, Price = price, PriceChange = FinanceHelpers.GetPriceDouble(percentChange), AllPrice = FinanceHelpers.GetPriceDouble(allPrice), BoughtPrice = FinanceHelpers.GetPriceDouble(stockInfo.BoughtPrice), Amount = stockInfo.Amount, PaidDividends = FinanceHelpers.GetPriceDouble(stockInfo.GetSumPayments()), PaperProfit = FinanceHelpers.GetPriceDouble(paperProfit), PaperProfitPercent = paperProfitPercent, UpdateTime = updateTime, NearestDividend = stockInfo.GetNearestPayment() }; stockReports.Add(stockReport); } return(stockReports); }
public IActionResult ProductStockReport() { try { var list = reportLogic.GetProductStockReport(); if (list.Count > 0) { byte[] result = StockReport.Generate(list); return(File(result, "application/pdf", "Stock-" + DateTime.Now.ToString("dd-MM-yyyy HH:mm tt") + ".pdf")); } else { return(NotFound(new { ErrorMessage = "No hay datos para generar el reporte." })); } } catch (Exception ex) { logger.LogError(ex, ex.Message); throw new Exception("Ocurrió un error al generar el reporte."); } }
public static int InsertStockOut(StockReport item, string flag) { string query = String.Empty; if (flag == "SALE") { query = @"INSERT INTO StockReport(ItemName, CompanyName, StockOutQuantity, SalesFlag) VALUES ( '" + item.ItemName + "', '" + item.CompanyName + "' ," + item.StockOutQty + ", 1 )"; } else if (flag == "DAMAGE") { query = @"INSERT INTO StockReport(ItemName, CompanyName, StockOutQuantity, DamageFlag) VALUES ( '" + item.ItemName + "', '" + item.CompanyName + "' ," + item.StockOutQty + ", 1 )"; } else if (flag == "LOST") { query = @"INSERT INTO StockReport(ItemName, CompanyName, StockOutQuantity, LostFlag) VALUES ( '" + item.ItemName + "', '" + item.CompanyName + "' ," + item.StockOutQty + ", 1 )"; } SqlCommand command = new SqlCommand(query, connect); connect.Open(); result = command.ExecuteNonQuery(); if (result != 0) { result = (int)Utilities.SearchResult.Found; } else { result = (int)Utilities.SearchResult.NotFound; } connect.Close(); return(result); }
private async Task <StockReport> CreateStockReportModel( string symbol, string companyName, string category, DateTime event1Start, DateTime event2Start) { var stockReport = new StockReport { CompanyName = companyName, Symbol = symbol, Category = category }; stockReport.CurrentPrice = (await _quoteApiService.Get(symbol)).Quote.Price; var dailyTimeSeries = await _dailyTimeSeriesApiService.Get(symbol); stockReport.ChangeFromEvent1ToEvent2 = _statisticsService.Difference(dailyTimeSeries, event1Start, event2Start.AddDays(-1)); stockReport.ChangeFromEvent2ToReportDate = _statisticsService.Difference(dailyTimeSeries, event2Start, DateTime.Now.Date); var yearlyStats = await _yearlyStatsService.GetMinAndAvg( symbol, event1Start, new List <int> { 1, 2, 3, 4, 5 }); stockReport.YearlyStats = yearlyStats.Select(y => new StockReportYearlyStats { NumberOfYearsPriorToEvent1 = y.NumberOfYears, Min = y.Min, Avg = y.Avg }).ToList(); return(stockReport); }
public async Task <ActionResult <StockReport> > PutStockReport(StockReport StockReport) { var update = await _stockReport.UpdateStockReport(StockReport); return(update); }
public async Task <ActionResult <StockReport> > PostStockReport(StockReport StockReport) { return(await _stockReport.AddStockReport(StockReport)); }
public IActionResult GetLastestStockReport() { var result = StockReport.GetStockReport(stockService.GetLastUpdatedDate()); return(Ok(result)); }
public IActionResult GetStockReport(DateTime date) { var result = StockReport.GetStockReport(date); return(Ok(result)); }