public static void nseCompanyCodes()
{
StreamReader sr = new StreamReader(@"C:\\Documents and Settings\\Amey\\Desktop\\EQUITY_L.csv");
DataTable nsedata = new DataTable();
DataColumn companyName = new DataColumn("CompanyName");
nsedata.Columns.Add(companyName);
DataColumn nsecode = new DataColumn("NSE Code");
nsedata.Columns.Add(nsecode);
DataRow row;
string[] values = null;
sr.ReadLine();
while (!sr.EndOfStream)
{
values = sr.ReadLine().Split(',');
row = nsedata.NewRow();
row[companyName] = values[1];
row[nsecode] = values[0];
nsedata.Rows.Add(row);
}
CommonFunctions.Write(nsedata, "nsecompanies.txt");
sr.Close();
nsedata.Dispose();
companyName.Dispose();
nsecode.Dispose();
}
//Convert DataTbale All column in String Column
public DataTable ConverDataTableToString(DataTable dataTable)
{
DataTable tempDataTable = new DataTable();
foreach (DataColumn columnName in dataTable.Columns)
{
DataColumn tempColumn = new DataColumn();
tempColumn.ColumnName = columnName.ColumnName;
tempColumn.DataType = System.Type.GetType("System.String");
tempColumn.AutoIncrement = false;
tempColumn.Caption = columnName.Caption;
tempColumn.ReadOnly = false;
tempColumn.Unique = false;
tempDataTable.Columns.Add(tempColumn);
tempColumn.Dispose();
}
foreach (DataRow readRow in dataTable.Rows)
{
DataRow tempdataRow = tempDataTable.NewRow();
foreach (DataColumn readColumn in dataTable.Columns)
{
tempdataRow[readColumn.ColumnName] = readRow[readColumn.ColumnName].ToString();
}
tempDataTable.Rows.Add(tempdataRow);
}
return tempDataTable;
}
public static void scrapBSECompaniesCode()
{
try
{
DataTable bsedata=new DataTable();
DataColumn companyName = new DataColumn("CompanyName");
bsedata.Columns.Add(companyName);
DataColumn bsecode = new DataColumn("BSE Code");
bsedata.Columns.Add(bsecode);
DataRow row;
string url = ConfigurationManager.AppSettings["BSECompanyCodeURL"].ToString();
HtmlWeb webpage = new HtmlWeb();
HtmlAgilityPack.HtmlDocument document = webpage.Load(url);
HtmlNode node = document.DocumentNode.SelectSingleNode("//div[@id='content']");
string[] temp;
foreach (HtmlNode link in node.SelectNodes("//a[@href]"))
{
if (Regex.IsMatch(link.InnerText, "BSE code:"))
{
temp = Regex.Split(link.InnerText, "BSE code:");
row=bsedata.NewRow();
row[companyName] = temp[0].Remove(temp[0].Length-1).Trim();
row[bsecode] = temp[1].Replace(')',' ').Trim();
bsedata.Rows.Add(row);
}
}
CommonFunctions.Write(bsedata, "bsecompanies.txt");
companyName.Dispose();
bsecode.Dispose();
bsedata.Dispose();
}
catch (Exception ex)
{
throw ex;
}
}
private void makeHeader(DataTable lsTable, string[] lsColumns)
{
try
{
DataColumn lsCol;
if (lsTable.Columns.Count == 0)
lsTable.Columns.Clear();
foreach (string s in lsColumns)
{
lsCol = new DataColumn();
lsCol.DataType = System.Type.GetType("System.String");
lsCol.ColumnName = s;
lsTable.Columns.Add(lsCol);
lsCol.Dispose();
}
return;
}
catch (Exception ex)
{
showErrorMessage(ex);
}
}
private void CreateColForTable()
{
_DTServerData = new DataTable();
DataColumn dc = new DataColumn("ValueName");
dc.DataType = System.Type.GetType("System.String");
_DTServerData.Columns.Add(dc);
dc = new DataColumn("Value");
dc.DataType = System.Type.GetType("System.String");
_DTServerData.Columns.Add(dc);
dc.Dispose();
}
private void MakeTPTable()
{
DataColumn myColumn = new DataColumn();
DataTable dtbl = new DataTable("history");
dtbl.Locale = CultureInfo.CurrentCulture;
myColumn.DataType = System.Type.GetType("System.String");
myColumn.ColumnName = "time";
dtbl.Columns.Add(myColumn);
myColumn = new DataColumn();
myColumn.DataType = System.Type.GetType("System.String");
myColumn.ColumnName = "name";
dtbl.Columns.Add(myColumn);
myColumn = new DataColumn();
myColumn.DataType = System.Type.GetType("System.String");
myColumn.ColumnName = "slurl";
dtbl.Columns.Add(myColumn);
dtbl.PrimaryKey = new DataColumn[] { dtbl.Columns["time"] };
tp = dtbl;
myColumn.Dispose();
dtbl.Dispose();
}
//private DataTable MakeDataTable()
//{
// DataColumn myColumn = new DataColumn();
// DataTable dtbl = new DataTable("list");
// myColumn.DataType = System.Type.GetType("System.String");
// myColumn.ColumnName = "mute_name";
// dtbl.Columns.Add(myColumn);
// myColumn = new DataColumn();
// myColumn.DataType = System.Type.GetType("System.String");
// myColumn.ColumnName = "uuid";
// dtbl.Columns.Add(myColumn);
// //mutelist.Columns.Add(myColumn);
// //dtbl.PrimaryKey = new DataColumn[] { dtbl.Columns["uuid"] };
// myColumn.Dispose();
// return dtbl;
//}
private static DataTable MakeGiverDataTable()
{
DataTable dtbl = new DataTable("list");
dtbl.Locale = CultureInfo.CurrentCulture;
DataColumn myColumn = new DataColumn();
myColumn.DataType = System.Type.GetType("System.String");
myColumn.ColumnName = "Command";
dtbl.Columns.Add(myColumn);
//client.Inventory.GiveItem(iitem.UUID, iitem.Name, iitem.AssetType, avid, false);
DataColumn myColumn1 = new DataColumn();
myColumn1.DataType = System.Type.GetType("System.String");
myColumn1.ColumnName = "UUID";
dtbl.Columns.Add(myColumn1);
DataColumn myColumn2 = new DataColumn();
myColumn2 = new DataColumn();
myColumn2.DataType = System.Type.GetType("System.String");
myColumn2.ColumnName = "Name";
dtbl.Columns.Add(myColumn2);
DataColumn myColumn3 = new DataColumn();
myColumn3.DataType = System.Type.GetType("System.String");
myColumn3.ColumnName = "AssetType";
dtbl.Columns.Add(myColumn3);
DataColumn[] keys = new DataColumn[1];
keys[0] = myColumn;
dtbl.PrimaryKey = keys;
myColumn.Dispose();
myColumn1.Dispose();
myColumn2.Dispose();
myColumn3.Dispose();
return dtbl;
}
