public bool checkIsSW(string nameCheck, searchedWordList SWlist)
{
foreach (var a in SWlist.list)
{
if (a.Name == nameCheck)
{
return(true);
}
}
return(false);
}
public void TranslateParagraph(string[] words, DataGridView x, ref searchedWordList SWlist)
{
x.Rows.Clear();
mycnt.Open();
List <Word> TranslatedWord = new List <Word>(100);
for (int i = 0; i < words.Length; i++)
{
if (words[i] == "")
{
continue;
}
string search = "select * from EV_SOURCE where Name = '" + words[i].Trim() + "'";
SqlCommand com = new SqlCommand(search, mycnt); // truy van cau lenh vao sql
//com.CommandType = CommandType.Text;
SqlDataAdapter ada = new SqlDataAdapter(com); // chuyen data tu sql ve trong ada
DataTable dt = new DataTable();
ada.Fill(dt); // do data tu ada va dt
mycnt.Close();
if (checkIsTW(words[i], TranslatedWord) && TranslatedWord.Count != 0)
{
continue;
}
if (dt.Rows.Count > 0)
{
if (!checkIsSW(dt.Rows[0]["Name"].ToString().Trim(), SWlist))
{
DataManager.Instance.InsertWordToSearchedTable(dt.Rows[0]["Name"].ToString().Trim(), dt.Rows[0]["Meaning"].ToString().Trim(), 1);
SWlist.list.Add(new Word(Convert.ToInt32(dt.Rows[0]["ID"].ToString().Trim()), dt.Rows[0]["Name"].ToString().Trim(), dt.Rows[0]["Meaning"].ToString().Trim()));
}
x.Rows.Add(dt.Rows[0]["Name"].ToString().Trim(), dt.Rows[0]["Meaning"].ToString().Trim());
// Them tu vao class tu EV da tra
TranslatedWord.Add(new Word(Convert.ToInt32(0), words[i], ""));
}
else
{
x.Rows.Add(words[i], "Không tìm thấy nghĩa từ :>>>");
TranslatedWord.Add(new Word(Convert.ToInt32(0), words[i], ""));
}
}
x.Show();
}
//public void UpdatDataGirbViewtoList(DataGridView x, searchedWordList host)
//{
// host.list.Clear();
// for (int i = 0; i < x.Rows.Count; ++i)
// {
// if (i == x.NewRowIndex)
// {
// break;
// }
// string[] lines = new string[3];
// lines[0] = x.Rows[i].Cells[0].Value.ToString();
// lines[1] = x.Rows[i].Cells[1].Value.ToString();
// lines[2] = x.Rows[i].Cells[2].Value.ToString();
// host.list.Add(new Word(Int32.Parse(lines[0]), lines[1], lines[2]));
// }
//}
public void LoadSWToList(searchedWordList host)
{
host.list.Clear(); // Xóa dữ liệu để tránh bug ngoài ý muốn
mycnt.Open();
// lay het du lieu trong bang DTBQT
SqlCommand com = new SqlCommand("SELECT * FROM EV_SearchedWord ", mycnt); //bat dau truy van
com.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(com); //chuyen du lieu ve
DataTable dt = new DataTable(); //tạo một kho ảo để lưu trữ dữ liệu
da.Fill(dt); // đổ dữ liệu vào kho
foreach (DataRow row in dt.Rows)
{
int ID = Convert.ToInt32(row["ID"].ToString());
string Name = row["Name"].ToString();
string Meaning = row["Meaning"].ToString();
host.list.Add(new Word(ID, Name, Meaning));
}
mycnt.Close();
}
