public IQueryable<WatchListEntry> GetAll() { List<WatchListEntry> watchListEntries = new List<WatchListEntry>(); using (OleDbConnection conn = new OleDbConnection(this.ConnectionString)) { using (OleDbCommand cmd = new OleDbCommand(this.SelectAllCommand, conn)) { try { if (conn.State != System.Data.ConnectionState.Open) conn.Open(); OleDbDataAdapter dataAdapter = new OleDbDataAdapter(cmd); DataSet ds = new DataSet(); dataAdapter.Fill(ds); DataTable watchListTable = ds.Tables[0]; WatchListEntry watchListEntry = null; for (int i = 0; i < watchListTable.Rows.Count; ++i) { watchListEntry = new WatchListEntry(); watchListEntry.Id = Convert.ToInt32(watchListTable.Rows[i]["Id"]); watchListEntry.BSESymbol = Convert.ToString(watchListTable.Rows[i]["BSESymbol"]); watchListEntry.NSESymbol = Convert.ToString(watchListTable.Rows[i]["NSESymbol"]); watchListEntry.Name = Convert.ToString(watchListTable.Rows[i]["Name"]); watchListEntry.AltName1 = Convert.ToString(watchListTable.Rows[i]["AltName1"]); watchListEntry.AltName2 = Convert.ToString(watchListTable.Rows[i]["AltName2"]); watchListEntry.TempName = Convert.ToString(watchListTable.Rows[i]["TempName"]); watchListEntry.Active = Convert.ToInt32(watchListTable.Rows[i]["Active"]); watchListEntry.Alert = Convert.ToInt32(watchListTable.Rows[i]["Alert"]); watchListEntry.ModifiedOn = Convert.ToInt32(watchListTable.Rows[i]["ModifiedOn"]); watchListEntry.CreatedOn = Convert.ToInt32(watchListTable.Rows[i]["CreatedOn"]); watchListEntries.Add(watchListEntry); } } catch (Exception e) { Console.WriteLine("[Error] GetAll() failed.", this.DataSource); Console.WriteLine(e.Message); } } } return watchListEntries.AsQueryable(); }
private string GetNSEDownloadUrl(WatchListEntry wle) { string nseDownloadUrl = @"http://www.nseindia.com/content/equities/scripvol/datafiles/{0}-TO-{1}{2}EQN.csv"; string strFromDate = string.Format("{0:dd-MM-yyyy}", fromDate); string strToDate = string.Format("{0:dd-MM-yyyy}", toDate); nseDownloadUrl = string.Format(nseDownloadUrl, strFromDate.Trim(), strToDate.Trim(), wle.NSESymbol.Trim()); return nseDownloadUrl; }
private string GetBSEDownloadUrl(WatchListEntry wle) { string bseDownloadUrl = @"http://www.bseindia.com/stockinfo/stockprc2_excel.aspx?scripcd={0}&FromDate={1}&ToDate={2}&OldDMY=D"; string strFromDate = string.Format("{0:MM/dd/yyyy}", fromDate); string strToDate = string.Format("{0:MM/dd/yyyy}", toDate); bseDownloadUrl = string.Format(bseDownloadUrl, wle.BSESymbol.Trim(), strFromDate.Trim(), strToDate.Trim()); return bseDownloadUrl; }