private void DrawChart(equity_holding equity_holding) { StockHoldingChart.Series["Domestic Holding"].Points.AddXY("Insurance", equity_holding.Domestic_Insurance); StockHoldingChart.Series["Foreign Holding"].Points.AddXY("Insurance", equity_holding.Foreign_Insurance); StockHoldingChart.Series["Domestic Holding"].Points.AddXY("Company", equity_holding.Domestic_Company); StockHoldingChart.Series["Foreign Holding"].Points.AddXY("Company", equity_holding.Foreign_Company); StockHoldingChart.Series["Domestic Holding"].Points.AddXY("Pension Fund", equity_holding.Domestic_Pension_Fund); StockHoldingChart.Series["Foreign Holding"].Points.AddXY("Pension Fund", equity_holding.Foreign_Pension_Fund); StockHoldingChart.Series["Domestic Holding"].Points.AddXY("Bank", equity_holding.Domestic_Bank); StockHoldingChart.Series["Foreign Holding"].Points.AddXY("Bank", equity_holding.Foreign_Bank); StockHoldingChart.Series["Domestic Holding"].Points.AddXY("Individual", equity_holding.Domestic_Individual); StockHoldingChart.Series["Foreign Holding"].Points.AddXY("Individual", equity_holding.Foreign_Individual); StockHoldingChart.Series["Domestic Holding"].Points.AddXY("Mutual Fund", equity_holding.Domestic_Mutual_Fund); StockHoldingChart.Series["Foreign Holding"].Points.AddXY("Mutual Fund", equity_holding.Foreign_Mutual_Fund); StockHoldingChart.Series["Domestic Holding"].Points.AddXY("Security", equity_holding.Domestic_Security); StockHoldingChart.Series["Foreign Holding"].Points.AddXY("Security", equity_holding.Foreign_Security); StockHoldingChart.Series["Domestic Holding"].Points.AddXY("Foundation", equity_holding.Domestic_Foundation); StockHoldingChart.Series["Foreign Holding"].Points.AddXY("Foundation", equity_holding.Foreign_Foundation); StockHoldingChart.Series["Domestic Holding"].Points.AddXY("Others", equity_holding.Domestic_Others); StockHoldingChart.Series["Foreign Holding"].Points.AddXY("Others", equity_holding.Foreign_Others); StockHoldingChart.Titles.Add("Holding Chart"); }
private void DisplayData(equity_holding equity) { StockTickerLabel.Text = equity.Code; StockDateTimePicker.Value = equity.Date; PriceLabel.Text = equity.Price.ToString(); //Domestic DomInsVaLabel.Text = equity.Domestic_Insurance.ToString(); DomComValabel.Text = equity.Domestic_Company.ToString(); DomPFVaLabel.Text = equity.Domestic_Pension_Fund.ToString(); DomBankVaLabel.Text = equity.Domestic_Bank.ToString(); DomIndVaLabel.Text = equity.Domestic_Individual.ToString(); DomMFVaLabel.Text = equity.Domestic_Mutual_Fund.ToString(); DomSecVaLabel.Text = equity.Domestic_Security.ToString(); DomFoundVaLabel.Text = equity.Domestic_Foundation.ToString(); DomOthersVaLabel.Text = equity.Domestic_Others.ToString(); decimal?domTotal = equity.Domestic_Insurance + equity.Domestic_Company + equity.Domestic_Pension_Fund + equity.Domestic_Bank + equity.Domestic_Individual + equity.Domestic_Mutual_Fund + equity.Domestic_Security + equity.Domestic_Foundation + equity.Domestic_Others; DomTotVaLabel.Text = domTotal.ToString(); //Foreign ForInsVaLabel.Text = equity.Foreign_Insurance.ToString(); ForCompVaLabel.Text = equity.Foreign_Company.ToString(); ForPFVaLabel.Text = equity.Foreign_Pension_Fund.ToString(); ForBankVaLabel.Text = equity.Foreign_Bank.ToString(); ForIndVaLabel.Text = equity.Foreign_Individual.ToString(); ForMFVaLabel.Text = equity.Foreign_Mutual_Fund.ToString(); ForSecVaLabel.Text = equity.Foreign_Security.ToString(); ForFoundVaLabel.Text = equity.Foreign_Foundation.ToString(); ForOthersVaLabel.Text = equity.Foreign_Others.ToString(); decimal?ForTotal = equity.Foreign_Insurance + equity.Foreign_Company + equity.Foreign_Pension_Fund + equity.Foreign_Bank + equity.Foreign_Individual + equity.Foreign_Mutual_Fund + equity.Foreign_Security + equity.Foreign_Foundation + equity.Foreign_Others; ForTotVaLabel.Text = ForTotal.ToString(); }
private void LoadData() { equity_holding equity = equityRepo.MonthlyLoadEquity(TickerTextBox.Text, StockDateTimePicker.Value); if (equity != null) { this.DisplayData(equity); } else { MessageBox.Show("Stock is not found"); } }
public bool SaveEquity(equity_holding equity_holding, out string errorMessage) { bool success = true; errorMessage = String.Empty; try { entities.equity_holding.Add(equity_holding); entities.SaveChanges(); } catch (Exception e) { Console.WriteLine(e.InnerException.Message.ToString()); errorMessage = e.InnerException.InnerException.Message; success = false; } return(success); }
private void LoadEquity() { equity_holding equity_holding = equityRepo.MonthlyLoadEquity(StockChartTextBox.Text, StockChartMonthDateTimePicker.Value); if (equity_holding != null) { foreach (var series in StockHoldingChart.Series) { series.Points.Clear(); } StockHoldingChart.Titles.Clear(); this.DrawChart(equity_holding); } else { MessageBox.Show("Data is not found"); } }
public static void ReadHoldingFile(OpenFileDialog fileDialog) { EquityRepository equityRepo = new EquityRepository(); StockRepository stockRepo = new StockRepository(); equity_holding equity = new equity_holding(); AwaitForm waitForm = new AwaitForm(); Stream stream = null; String ErrorMessage; if ((stream = fileDialog.OpenFile()) != null) { using (stream) { // string ErrorMessage; string filename = fileDialog.FileName; string[] fileLines = File.ReadAllLines(filename); char[] delimiters = { '|' }; bool checkMonth = CheckCurrentMonth(fileLines, equityRepo, delimiters); if (checkMonth == false) { bool success = false; bool flag = true; for (int i = 1; i < fileLines.Length; i++) { string[] words = fileLines[i].Split(delimiters); DateTime date = DateTime.Parse(words[0]); if (words[1].Length == 4) { if (words[2] == "EQUITY") { string stockCode = words[1].ToUpper().Trim(); bool isExisted = stockRepo.CheckCurrentStock(stockCode); if (!isExisted) { stock stock = new stock(); stock.code = stockCode; equity.stock_id = stockRepo.SaveStock(stock, out ErrorMessage); } equity.stock_id = CheckStockCode(stockRepo, stockCode); equity.Code = words[1]; equity.Date = date; equity.Price = Decimal.Parse(words[4]); equity.Domestic_Insurance = Decimal.Parse(words[5]); equity.Domestic_Company = Decimal.Parse(words[6]); equity.Domestic_Pension_Fund = Decimal.Parse(words[7]); equity.Domestic_Bank = Decimal.Parse(words[8]); equity.Domestic_Individual = Decimal.Parse(words[9]); equity.Domestic_Mutual_Fund = Decimal.Parse(words[10]); equity.Domestic_Security = Decimal.Parse(words[11]); equity.Domestic_Foundation = Decimal.Parse(words[12]); equity.Domestic_Others = Decimal.Parse(words[13]); equity.Foreign_Insurance = Decimal.Parse(words[15]); equity.Foreign_Company = Decimal.Parse(words[16]); equity.Foreign_Pension_Fund = Decimal.Parse(words[17]); equity.Foreign_Bank = Decimal.Parse(words[18]); equity.Foreign_Individual = Decimal.Parse(words[19]); equity.Foreign_Mutual_Fund = Decimal.Parse(words[20]); equity.Foreign_Security = Decimal.Parse(words[21]); equity.Foreign_Foundation = Decimal.Parse(words[22]); equity.Foreign_Others = Decimal.Parse(words[23]); success = equityRepo.SaveEquity(equity, out ErrorMessage); if (!String.IsNullOrEmpty(ErrorMessage)) { MessageBox.Show(ErrorMessage); } if (flag) { waitForm.Show(); waitForm.Refresh(); } } } flag = false; } if (success) { waitForm.Close(); MessageBox.Show("Data berhasil disimpan"); } } else { MessageBox.Show("Data untuk bulan ini telah tersedia"); } } } }
public equity_holding MonthlyLoadEquity(string stock, DateTime date) { equity_holding equity = entities.equity_holding.Where(q => q.Code == stock).Where(s => s.Date.Year == date.Year && s.Date.Month == date.Month).FirstOrDefault(); return(equity); }
public equity_holding LoadEquity(string stock) { equity_holding equity = entities.equity_holding.Where(q => q.Code == stock).FirstOrDefault(); return(equity); }