public List <pr> getProblems()
{
List <pr> retVal = new List <pr>();
string command = "SELECT * FROM [PROBLEMS] ";
SqlCommand com = new SqlCommand(command, con);
SqlDataReader reader;
con.Open();
reader = com.ExecuteReader();
while (reader.Read())
{
pr t = new pr();
t.id = reader.GetInt32(0);
t.pr_ = reader.GetString(1);
t.ca = reader.GetString(2);
retVal.Add(t);
}
reader.Close();
con.Close();
return(retVal);
}
VerifyAnswer(pr, score, wordsLeft, word, answer);
public static bool PopulateNewFromFile(this tsEntities db, string fileName)
{
try
{
string[] lines = File.ReadAllLines(fileName);
Debug.WriteLine(fileName);
for (int i = 0; i < lines.Length; i++)
{
Debug.WriteLine(i.ToString() + lines[i]);
if (lines[i].Trim().Contains("-"))
{
pr a = new pr();
string[] sy = lines[i].Split('-');
a.rt = sy[0].Trim();
if (a.rt.Trim() == string.Empty)
{
int lll = 0;
}
a.ex = sy[1].Trim();
i++; i++;
double pr = 0;
if (!double.TryParse(lines[i], out pr))
{
pr = 0;
}
a.price = pr;
i++;
double daily_ch = 0;
if (!double.TryParse(lines[i], out daily_ch))
{
daily_ch = 0;
}
a.daily_change = daily_ch;
i++;
double lt = 0;
string newVal = lines[i].Replace('%', ' ').Trim();
if (!double.TryParse(newVal, out lt))
{
lt = 0;
}
a.per_dayly_change = lt;
i++;
if (!lines[i].Contains('.'))
{
double v = 0;
if (!double.TryParse(lines[i], out v))
{
v = 0;
}
a.vol = (long)v;
i++;
}
else
{
Debug.WriteLine("no vol");
}
double high = 0;
if (!double.TryParse(lines[i], out high))
{
high = 0;
}
a.week_52_h = high;
i++;
double low = 0;
if (!double.TryParse(lines[i], out low))
{
low = 0;
}
a.week_52_l = low;
i++;
a.timestamp = DateTime.UtcNow;
if (i < lines.Length && lines[i].Contains("-") && !lines[i].Contains('|'))
{
i--;
}
// a.mdt = mdt;
try
{
pr ad = db.prs.SingleOrDefault(p1 => (p1.rt.Trim() == a.rt.Trim() && p1.ex.Trim() == a.ex.Trim()));
if (ad == null)
{
db.prs.Add(a);
db.SaveChanges();
db.RefreshDatabase(a);
Debug.WriteLine(">> " + a.rt + " - " + a.ex);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
return(true);
}
public static bool PopulatePerFromFile(this tsEntities db, string fileName)
{
try
{
string[] lines = File.ReadAllLines(fileName);
Debug.WriteLine(fileName);
for (int i = 0; i < lines.Length; i++)
{
Debug.WriteLine(i.ToString() + lines[i]);
if (lines[i].Trim().Contains("-"))
{
per a = new per();
string[] sy = lines[i].Split('-');
a.rt = sy[0].Trim();
a.ex = sy[1].Trim();
i++; i++;
if (a.rt.Trim().ToLower() == "")
{
int iii = 0;
}
bool skipPr = false;
double pr = 0;
if (!double.TryParse(lines[i], out pr))
{
pr = 0;
i--;
skipPr = true;
}
i++;
pr p = new pr();
p.rt = a.rt;
p.ex = a.ex;
p.price = pr;
if (skipPr)
{
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);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
}
double ht = 0;
lines[i] = lines[i].Replace("%", "0");
if (!double.TryParse(lines[i], out ht))
{
ht = 0;
}
i++;
a.ytd = ht;
double lt = 0;
lines[i] = lines[i].Replace("%", "0");
if (!double.TryParse(lines[i], out lt))
{
lt = 0;
}
i++;
a.five_day = lt;
double oneM = 0;
lines[i] = lines[i].Replace("%", "0");
if (!double.TryParse(lines[i], out oneM))
{
oneM = 0;
}
i++;
a.one_month = oneM;
double threeM = 0;
lines[i] = lines[i].Replace("%", "0");
if (!double.TryParse(lines[i], out threeM))
{
threeM = 0;
}
i++;
a.three_month = threeM;
double oneY = 0;
lines[i] = lines[i].Replace("%", "0");
if (!double.TryParse(lines[i], out oneY))
{
oneY = 0;
}
a.one_year = oneY;
try
{
per ad = db.pers.SingleOrDefault(p1 => (p1.rt.Trim() == p.rt.Trim() && p1.ex.Trim() == p.ex.Trim()));
if (ad == null)
{
db.pers.Add(a);
db.SaveChanges();
db.RefreshDatabase(a);
}
else
{
ad.ytd = a.ytd;
ad.five_day = a.five_day;
ad.one_month = a.one_month;
ad.three_month = a.three_month;
ad.one_year = a.one_year;
db.SaveChanges();
db.RefreshDatabase(ad);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
return(true);
}
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());
}
}
}
public static bool PopulateArFromFile(this tsEntities db, string fileName)
{
try
{
string[] lines = File.ReadAllLines(fileName);
Debug.WriteLine(fileName);
for (int i = 0; i < lines.Length; i++)
{
Debug.WriteLine(i.ToString() + lines[i]);
if (lines[i].Trim().Contains("-"))
{
ar a = new ar();
string[] sy = lines[i].Split('-');
a.rt = sy[0].Trim();
if (a.rt.Trim() == string.Empty)
{
int lll = 0;
}
a.ex = sy[1].Trim();
i++; i++;
double pr = 0;
if (!double.TryParse(lines[i], out pr))
{
pr = 0;
}
i++;
pr p = new pr();
p.rt = a.rt;
p.ex = a.ex;
p.price = pr;
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());
}
double ht = 0;
if (!double.TryParse(lines[i], out ht))
{
ht = 0;
}
i++;
a.ht = ht;
double lt = 0;
if (!double.TryParse(lines[i], out lt))
{
lt = 0;
}
i++;
a.lt = lt;
double met = 0;
if (!double.TryParse(lines[i], out met))
{
met = 0;
}
i++;
a.met = met;
double mdt = 0;
if (!double.TryParse(lines[i], out mdt))
{
mdt = 0;
}
a.mdt = mdt;
try
{
ar ad = db.ars.SingleOrDefault(p1 => (p1.rt.Trim() == p.rt.Trim() && p1.ex.Trim() == p.ex.Trim()));
if (ad == null)
{
db.ars.Add(a);
db.SaveChanges();
db.RefreshDatabase(a);
}
else
{
ad.ht = a.ht;
ad.lt = a.lt;
ad.met = a.met;
ad.mdt = a.mdt;
db.SaveChanges();
db.RefreshDatabase(ad);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
return(true);
}
