public static void TransferVxToT(this tsEntities db)
{
foreach (var r in db.t_x.OrderBy(a => a.Root_Ticker).ToList())
{
try
{
t_s tt = new t_s();
tt.AFRICA = r.AFRICA;
tt.asia_region = r.Asia_Region;
tt.AUS_NZ_PNG = r.AUS_NZ_PNG;
tt.base__precious_metals = r.base__precious_metals;
tt.CANADA = r.CANADA;
tt.CHINA__ASIA = r.CHINA__ASIA;
tt.clean_tech_primary = r.clean_tech_primary;
tt.clean_tech_sub_sector = r.clean_tech_sub_sector;
tt.Coal = r.Coal;
tt.Copper = r.Copper;
tt.Co_ID = r.Co_ID;
tt.cps = r.cps;
tt.date_of_amalgamation = r.Date_of_amalgamation;
tt.date_of_listing = r.date_of_listing;
tt.Diamond = r.Diamond;
tt.Exchange = r.Exchange;
tt.former_cpc = r.formar_cpc_or_cpc;
tt.Gold = r.Gold;
tt.hq_location = r.hq_location;
tt.hq_region = r.hq_region;
tt.Index = r.Index;
tt.interlisted = r.Interlisted;
tt.Iron = r.Iron;
tt.LATIN_AMERICA = r.LATIN_AMERICA;
tt.Lead = r.Lead;
tt.Lithium = r.Lithium;
tt.mineral_properties = r.mineral_properties;
tt.Molybdenum = r.Molybdenum;
tt.Name = r.Name;
tt.Nickel = r.Nickel;
tt.num_of_month_trading_data = r.num_of_month_trading_data;
tt.num_traded_share_ytd = r.num_traded_share_ytd;
tt.Oil_Gas = r.Oil_Gas;
tt.OS_Shares = r.OS_Shares;
tt.OTHER = r.OTHER;
tt.other_properties = r.other_properties;
tt.Platinum_PGM = r.Platinum_PGM;
tt.Potash = r.Potash;
tt.QMV = r.qmv;
tt.qt_date = r.QT_Date;
tt.Rare_Earths = r.Rare_Earths;
tt.re = r.re;
tt.root__ticker = r.Root_Ticker;
tt.rto_date = r.RTO_Date;
tt.section = r.Section;
tt.Sector = r.Sector;
tt.Silver = r.Silver;
tt.Sub_Sector = r.Sub_Sector;
tt.technology_sub_sector = r.tech_sub_sec;
tt.trust = r.trust;
tt.Tungsten = r.Tungsten;
tt.type_of_listing = r.type_of_listing;
tt.UK_EUROPE = r.UK_EUROPE;
tt.Uranium = r.Uranium;
tt.USA = r.USA;
tt.usa_city = r.usa_city;
tt.USA_State = r.USA_State;
tt.value__ytd = r.value__ytd;
tt.ven_50_2018 = r.Ven_50_2018;
tt.volume_ytd = r.volume_ytd;
tt.Zinc = r.Zinc;
db.t_s.Add(tt);
db.SaveChanges();
db.RefreshDatabase(tt);
Debug.WriteLine(">> " + tt.root__ticker + " - " + tt.Name);
}
catch (Exception ex) { Debug.WriteLine(ex.ToString()); }
}
}
public static void ImportNYSESymbols(this tsEntities db, string v, string Ex, long seedValue, char deli = ',')
{
string[] stLines = File.ReadAllLines(v);
long pKey = seedValue;
foreach (string st in stLines)
{
string[] stl = st.Split(deli);
t_s ts = new t_s();
ts.pKey = pKey++;
ts.root__ticker = stl[0].Trim();
ts.Name = stl[1].Trim();
ts.Exchange = Ex;
double price = 0;
if (!double.TryParse(stl[2], out price))
{
price = 0;
}
pr p = new pr();
p.rt = stl[0].Trim();
p.ex = Ex.Trim();
p.price = price;
try
{
pr pd = db.prs.SingleOrDefault(p1 => (p1.rt.Trim() == p.rt.Trim() && p1.ex.Trim() == p.ex.Trim()));
if (pd == null)
{
db.prs.Add(p);
db.SaveChanges();
db.RefreshDatabase(p);
}
else
{
pd.price = p.price;
db.SaveChanges();
db.RefreshDatabase(pd);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
ts.QMV = stl[3].Trim();
ts.Sector = stl[6].Trim();
ts.Sub_Sector = stl[7].Trim();
try
{
t_s ad = db.t_s.SingleOrDefault(p1 => (p1.root__ticker.Trim() == ts.root__ticker.Trim() && p1.Exchange.Trim() == ts.Exchange.Trim()));
if (ad == null)
{
ts.Co_ID = ts.pKey.ToString();
db.t_s.Add(ts);
db.SaveChanges();
db.RefreshDatabase(ts);
Debug.WriteLine(ts.root__ticker.ToString() + " - " + ts.Name.ToString());
}
else
{
ad.Name = ts.Name;
ad.QMV = ts.QMV;
ad.Sector = ts.Sector;
ad.Sub_Sector = ts.Sub_Sector;
db.SaveChanges();
db.RefreshDatabase(ad);
Debug.WriteLine("update >>> " + ts.root__ticker.ToString() + " - " + ts.Name.ToString());
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
}
}
