private void frmWatchlist_Load(object sender, EventArgs e) { //dgWList.DataSource = pDalTest.LatestValue(); WatchList_Design(); string sDM = "", sVM = "", sHTML = ""; char[] cfilter = { '\r', '\t' }; string[] sValues; int iPBValue = 0; DataView dtWatchList; theParent = (frmMain)this.ParentForm; //To access MDI parent control theParent.lblDMMsg.Text = "All script loading.."; theParent.pBarDM.Visible = true; Cursor = Cursors.WaitCursor; try { dtWatchList = pDalWatchLest.Stocks(ref sDM, ref sVM, 1); theParent.pBarDM.Maximum = dtWatchList.Table.Rows.Count; //for (int ii = 0; ii < dtWatchList.Table.Rows.Count; ii++) foreach (DataRow dtRow in dtWatchList.Table.Rows) { Application.DoEvents(); dgWList.Rows.Add(); dgWList[0, iPBValue].Value = dtRow[2].ToString(); theParent.lblDMMsg.Text = "Reading " + dgWList[0, iPBValue].Value; if (dtRow[5].ToString().Trim() != "") { //Reading from Rediff returns true once the reading successfully if (CommonDoubleM.RediffStockLatestUpdates(dtRow[5].ToString(), ref sHTML)) { sHTML = CommonDoubleM.StripHTML(sHTML); sValues = sHTML.Split(cfilter); for (int i = 0; i < sValues.Length; i++) { switch (sValues[i].Trim()) { case "Last traded": dgWList[1, iPBValue].Value = sValues[i + 1].Trim(); break; case "Change": dgWList[2, iPBValue].Value = sValues[i + 1].Trim(); break; case "Time": dgWList[3, iPBValue].Value = sValues[i + 1].Trim(); break; case "Prev Close": dgWList[4, iPBValue].Value = sValues[i + 1].Trim(); break; case "DaysH/L(Rs)": dgWList[5, iPBValue].Value = sValues[i + 1].Trim(); break; case "52wkH/L(Rs)": dgWList[6, iPBValue].Value = sValues[i + 1].Trim(); break; case "Volume": dgWList[7, iPBValue].Value = sValues[i + 1].Trim(); break; case "MktCap(RsCr)": dgWList[8, iPBValue].Value = sValues[i + 1].Trim(); break; } } // dgWList[2, iPBValue].Value = sHTML; } } else { dgWList[1, iPBValue].Value = "--"; } theParent.pBarDM.Value = iPBValue; iPBValue++; // if (iPBValue == 2) break; //Just for testing only 2 rows } theParent.pBarDM.Visible = false; } catch (Exception ex) { theParent.lblDMMsg.Text = ex.Message; CommonDoubleM.LogDM(ex.Message); } Cursor = Cursors.Default; //string s=null, abc=null; //if (CommonDoubleM.RediffStockLatestUpdates("10510001", ref s)) //{ // s = s.Substring(s.LastIndexOf("Last traded"), s.LastIndexOf("<img") - s.LastIndexOf("Last traded")); // abc = s; // char[] sp = { '\r', '\t' }; // s = CommonDoubleM.StripHTML(s); // CommonDoubleM.LogDM(s); // string[] a = s.Split(sp); //} }
private void frmDataImport_Load(object sender, EventArgs e) { _theParent = (frmMain)this.ParentForm; //To access MDI parent control /*Add Checkbox dynamically to 1st column of each row*/ c1 = new DataGridViewCheckBoxColumn(); c1.Width = 30; c1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvImport.Columns.Add(c1); dgvImport.Columns[0].Resizable = DataGridViewTriState.False; dgvImport.Columns[0].Frozen = true; dgvImport.Columns[0].ReadOnly = false; dgvImport.RowHeadersWidth = 60; dgvImport.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; dgvImport.RowHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; /*Add Checkbox to header*/ ckBox = new CheckBox(); //Get the column header cell bounds Rectangle rect = dgvImport.GetCellDisplayRectangle(0, -1, true); // set checkbox header to center of header cell. +1 pixel to position correctly. rect.X = rect.Location.X + (rect.Width / 4); ckBox.Size = new Size(18, 18); //Change the location of the CheckBox to make it stay on the header ckBox.Location = rect.Location; ckBox.CheckedChanged += new EventHandler(ckBox_CheckedChanged); //Add the CheckBox into the DataGridView dgvImport.Controls.Add(ckBox); ckBox.Visible = false; GetStocks(); switch (_ImportWhat) { case (short)ImportWhat.SingleRates: this.Text = "Data Import of Single Stock"; lblMsg.Text = string.Format(initMsg, "Date", "Rate"); lblMode.Text = "Stocks"; ddlStock.Visible = true; _MsgSelect = "Selected fields are \n[Dates] = {0}\n[Rates] = {1}"; _fields = new string[2]; _menuItems = new string[] { "Click Column is: Dates", "Clicked Column is: Rates" }; cmsLoaddata.Items.Add(_menuItems[0]); cmsLoaddata.Items.Add(_menuItems[1]); break; case (short)ImportWhat.MultipleRates: this.Text = "Data Import of Multiple Stock"; lblMsg.Text = string.Format(initMsg, "Stocks Code", "Rate"); lblMode.Text = "Date\\Time"; dtpPriceDate.Visible = true; dtpPriceDate.Value = DateTime.Now; chkActiveStock.Visible = true; chkActiveStock.CheckState = CheckState.Indeterminate; _MsgSelect = "Selected fields are \n[Stocks] = {0}\n[Rates] = {1}"; _fields = new string[2]; _menuItems = new string[] { "Click Column is: Stocks", "Clicked Column is: Rates" }; cmsLoaddata.Items.Add(_menuItems[0]); cmsLoaddata.Items.Add(_menuItems[1]); break; default: break; } }
private void frmCumulAvg_Load(object sender, EventArgs e) { frmMain theParent = (frmMain)this.ParentForm; //To access MDI parent control theParent.lblDMMsg.Text = "Please wait data loading.."; try { dblTotal = 0; dblGain = 0; dblValue = 0; decimal dicAvgPrice = 0, dicPerct = 0; DataTable dtQuickView = new DataTable(); theParent.pBarDM.Visible = true; Application.DoEvents(); if (_Caller == 1) //Avg { dtQuickView = _pdalStock_CA.StockAvgAfterSale(); /*Adding Columns Header to Datagrid*/ /*foreach (DataColumn dtcol in dtQuickView.Columns) * dgViewQ.Columns.Add(dtcol.ColumnName, dtcol.ColumnName);*/ dgViewQ.Columns.Add("Stock Name", "Stock Name"); dgViewQ.Columns.Add("Shrs", "Shrs"); dgViewQ.Columns.Add("Current", "Current"); dgViewQ.Columns.Add("SID", "SID"); dgViewQ.Columns.Add("AvgPrice", "Avg"); dgViewQ.Columns.Add("Percentage", "%"); dgViewQ.Columns.Add("Gain", "T Gain"); dgViewQ.Columns.Add("PricePaid", "Paid"); } else { dtQuickView = _pdalStock_CA.LatestValue(); //dtQuickView.con /*Adding Columns Header to Datagrid*/ foreach (DataColumn dtcol in dtQuickView.Columns) { dgViewQ.Columns.Add(dtcol.ColumnName, dtcol.ColumnName); } dgViewQ.Columns.Add("AvgPrice", "Avg"); dgViewQ.Columns.Add("Percentage", "%"); dgViewQ.Columns.Add("Gain", "T Gain"); dgViewQ.Columns.Add("PricePaid", "Paid"); } /* Data grid format display*/ dgViewQ.Columns[0].Width = 180; //Name dgViewQ.Columns[1].Width = 40; //Total Stock dgViewQ.Columns[2].Width = 60; //Current Price dgViewQ.Columns[3].Visible = false; // StockID dgViewQ.Columns[4].Width = 60; //Avg. Price dgViewQ.Columns[5].Width = 45; //% dgViewQ.Columns[6].Width = 50; //Gain dgViewQ.Columns[7].Width = 60; // TCost int iCount = 0; theParent.pBarDM.Maximum = dtQuickView.Rows.Count; foreach (DataRow dtrow in dtQuickView.Rows) { dgViewQ.Rows.Add(); dgViewQ.Columns[1].InheritedStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgViewQ.Columns[2].InheritedStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgViewQ.Columns[3].InheritedStyle.Alignment = DataGridViewContentAlignment.MiddleRight; if (_Caller == 2) { dgViewQ[0, iCount].Value = dtrow[0]; dgViewQ[1, iCount].Value = dtrow[1]; dgViewQ[2, iCount].Value = dtrow[2]; dicAvgPrice = _pdalStock_CA.StockAvg((int)dtrow[3]); dgViewQ[4, iCount].Value = dicAvgPrice; dgViewQ[6, iCount].Value = ((decimal)(dgViewQ[2, iCount].Value) - dicAvgPrice) * (decimal)(double)(dgViewQ[1, iCount].Value); dgViewQ[7, iCount].Value = dicAvgPrice * (decimal)(double)dgViewQ[1, iCount].Value; //dgViewQ[0, 0].Style.BackColor = Color.RoyalBlue; } else if (_Caller == 1) { dgViewQ[0, iCount].Value = dtrow[1]; dgViewQ[1, iCount].Value = dtrow[2]; dgViewQ[2, iCount].Value = dtrow[4]; dgViewQ[3, iCount].Value = dtrow[0]; dgViewQ[4, iCount].Value = dtrow[3]; dgViewQ[5, iCount].Value = dtrow[5]; dgViewQ[6, iCount].Value = dtrow[6]; dgViewQ[7, iCount].Value = dtrow[7]; } //dgViewQ[3, iCount].Value = dtrow[3]; //dgViewQ[4, iCount].Value = dtrow[4]; //double tmpValue = Convert.ToDouble(dgViewQ[4, iCount].Value); dicPerct = (decimal)((Convert.ToDouble(dgViewQ[2, iCount].Value) / Convert.ToDouble(dgViewQ[4, iCount].Value)) - 1) * 100; dicPerct = decimal.Round(dicPerct, 2); dgViewQ[5, iCount].Value = dicPerct; int iR = 255, iG = 255, iB = 255; int iMax = 0, iMin = 0; //http://www.flounder.com/csharp_color_table.htm (for color coding) if (dicPerct < 0) { iMin = 255 - (int)(dicPerct * -4); if ((iMin < 0) || (iMin > 255)) { iMin = 0; } iG = iMin; iB = iMin; } else { iMax = 255 - (int)(dicPerct * 4); if ((iMax < 0) || (iMax > 255)) { iMax = 0; } iR = iMax; iB = iMax; } dgViewQ[5, iCount].Style.BackColor = Color.FromArgb(iR, iG, iB); dblValue = dblValue + Convert.ToDouble(dgViewQ[1, iCount].Value) * Convert.ToDouble(dgViewQ[2, iCount].Value); dblGain = dblGain + Convert.ToDouble(dgViewQ[6, iCount].Value); dblTotal = dblTotal + Convert.ToDouble(dgViewQ[7, iCount].Value); iCount++; theParent.pBarDM.Value = iCount; } //dgViewQ.Rows[iCount].Selected = true; /*Summary at bottom*/ dgViewQ[0, iCount].Value = "Summary"; dgViewQ[2, iCount].Value = dblValue; dgViewQ[5, iCount].Value = decimal.Round(((decimal)((dblValue / dblTotal) - 1) * 100), 2); dgViewQ[6, iCount].Value = dblGain; dgViewQ[7, iCount].Value = dblTotal; theParent.lblDMMsg.Text = "Done.."; } catch (Exception ex) { theParent.lblDMMsg.Text = ex.Message; } finally { theParent.pBarDM.Visible = false; } }
private void frmAc_Load(object sender, EventArgs e) { //lblMsg.Text = "Total Quantity " + _iSellQuantity.ToString(); dgvAc.RowHeadersWidth = 25; _theParent = (frmMain)this.ParentForm; }