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