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