public PerformanceCounterData(PerformanceCounter[] performanceCounter, DataType dataType, GetDataType getDataType, string instanceName, Object[] param = null)
{
this.performanceCounter = performanceCounter;
this.dataType = dataType;
this.getDataType = getDataType;
this.param = param;
this.instanceName = instanceName;
}
private DataTable GetQuestionsAnswersOrResults(GetDataType getDataType)
{
var selectionField = string.Empty;
// SELECT BLOCK
var query = "Select distinct ";
switch (getDataType)
{
case GetDataType.Answers:
selectionField = "main.Answers.Name";
break;
case GetDataType.Questions:
selectionField = "main.Questions.Name";
break;
case GetDataType.QuestionsAnswersScores:
selectionField = "main.Questions.Name, main.Answers.Name, main.Interview.Score";
break;
case GetDataType.Theme:
selectionField = "main.Themes.Name";
break;
}
if (selectionField != string.Empty)
{
// FROM BLOCK
query += selectionField + " from main.Interview, " +
"main.Questions, " +
"main.Answers, " +
"main.Themes ";
// WHERE BLOCK
query += "where main.Interview.QUESTION_ID = main.Questions.ID " +
"and main.Interview.ANSWER_ID = main.Answers.ID " +
"and main.Interview.theme_id = main.Themes.ID";
if (getDataType != GetDataType.Theme)
{
query += " and main.Themes.Name = " + "'" + InterView.GetInterviewTheme() + "'";
}
query += " order by main.Questions.ID, main.Answers.ID ";
try
{
var result = DbConnection.SelectFromDb(query);
return(result);
}
catch (Exception exp)
{
throw new Exception(exp.ToString());
}
}
return(null);
}
public int GetWordCount(GetDataType type)
{
lock (this)
{
OleDbConnection cn = new OleDbConnection(ConnectionString);
cn.Open();
OleDbCommand cmd;
if (type == GetDataType.All)
{
cmd = new OleDbCommand("SELECT Count(Words.ID) FROM Words", cn);
}
else if (type == GetDataType.Studied)
{
cmd = new OleDbCommand("SELECT Count(Words.ID) FROM Words Where(Words.Hide=true)", cn);
}
else
{
cmd = new OleDbCommand("SELECT Count(Words.ID) FROM Words Where(Words.Hide=false)", cn);
}
return((int)cmd.ExecuteScalar());
}
}
public PerformanceCounterData(PerformanceCounter[] performanceCounter, DataType dataType, GetDataType getDataType, string instanceName, Object[] param = null)
{
this.performanceCounter = performanceCounter;
this.dataType = dataType;
this.getDataType = getDataType;
this.param = param;
this.instanceName = instanceName;
}
private void StartGetDataDelegate(GetDataType gdt)
{
switch (gdt)
{
case GetDataType.All:
while (SiteArtists.Count > 0)
{
var item = SiteArtists[0];
SiteArtists.RemoveAt(0);
Func<CArtist, List<CDownloadImage>> getdatadelegate = GetAllDataDelegate;
_getdataCount++;
getdatadelegate.BeginInvoke(item, GetDataCallBack, getdatadelegate);
while (_getdataCount > _maxtask)
{
Thread.Sleep(7000);
}
}
break;
case GetDataType.Update:
while (SiteArtists.Count > 0)
{
var item = SiteArtists[0];
SiteArtists.RemoveAt(0);
Func<CArtist, List<CDownloadImage>> getdatadelegate = GetUpdateDataDelegate;
_getdataCount++;
getdatadelegate.BeginInvoke(item, GetDataCallBack, getdatadelegate);
while (_getdataCount > _maxtask)
{
Thread.Sleep(7000);
}
}
break;
}
while (_getdataCount > 0)
{
Thread.Sleep(5000);
}
}
public List <Kanji> GetKanjiData(GetDataType type)
{
lock (this)
{
List <Kanji> arr = new List <Kanji>();
OleDbConnection cn = new OleDbConnection(ConnectionString);
cn.Open();
OleDbCommand cmd;
if (type == GetDataType.All)
{
cmd = new OleDbCommand("SELECT * FROM KANJI ", cn);
}
else if (type == GetDataType.Studied)
{
cmd = new OleDbCommand("SELECT * FROM KANJI WHERE Hide = true", cn);
}
else
{
cmd = new OleDbCommand("SELECT * FROM KANJI WHERE Hide = false", cn);
}
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
int i = da.Fill(dt);
if (i == 0)
{
cn.Close();
return(arr);
}
foreach (DataRow dr in dt.Rows)
{
Kanji k = new Kanji();
try
{
k.Id = (int)dr["Id"];
k.StrKanji = dr["Kanji"] as string;
k.StrAmon = dr["Amon"] as string;
k.StrAmkun = dr["Amkun"] as string;
k.StrMeaning = dr["Meaning"] as string;
k.StrSample = dr["Sample"] as string;
k.IsStudied = (bool)dr["Hide"];
}
catch
{
continue;
}
if (null != k.StrKanji && !string.IsNullOrEmpty(k.StrKanji.Trim()) &&
null != k.StrMeaning && !string.IsNullOrEmpty(k.StrMeaning.Trim()))
{
k.StrAmon = null == k.StrAmon ? string.Empty : k.StrAmon;
k.StrAmkun = null == k.StrAmkun ? string.Empty : k.StrAmkun;
k.StrSample = null == k.StrSample ? string.Empty : k.StrSample;
arr.Add(k);
}
}
cn.Close();
return(arr);
}
}
public List <Word> GetWordData(GetDataType type)
{
lock (this)
{
List <Word> arr = new List <Word>();
OleDbConnection cn = new OleDbConnection(ConnectionString);
cn.Open();
OleDbCommand cmd;
if (type == GetDataType.All)
{
cmd = new OleDbCommand("SELECT * FROM WORDS ", cn);
}
else if (type == GetDataType.Studied)
{
cmd = new OleDbCommand("SELECT * FROM WORDS WHERE Hide = true", cn);
}
else
{
cmd = new OleDbCommand("SELECT * FROM WORDS WHERE Hide = false", cn);
}
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
int i = da.Fill(dt);
if (i == 0)
{
cn.Close();
return(arr);
}
foreach (DataRow dr in dt.Rows)
{
Word w = new Word();
try
{
w.Id = (int)dr["Id"];
w.Kanji = dr["Kanji"] as string;
w.Kana = dr["Kana"] as string;
w.Meaning = dr["Meaning"] as string;
w.IsStudied = (bool)dr["Hide"];
}
catch
{
continue;
}
if (null != w.Kana || string.Empty != w.Kana ||
null != w.Meaning || string.Empty != w.Meaning)
{
w.Kana = null == w.Kana ? string.Empty : w.Kana;
w.Kanji = null == w.Kanji ? string.Empty : w.Kanji;
w.Meaning = null == w.Meaning ? string.Empty : w.Meaning;
w.Romanji = null == w.Romanji ? string.Empty : w.Romanji;
arr.Add(w);
}
}
cn.Close();
return(arr);
}
}
