public bool bookMark(EN_VN_Word w)
{
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (SqlCommand cmd = new SqlCommand(bookMarkCommand, conn))
{
cmd.Parameters.Add("@ENKey", SqlDbType.VarChar).Value = w.ENKey;
cmd.Parameters.Add("@Pronounciation", SqlDbType.NVarChar).Value = w.Pronounciation;
cmd.Parameters.Add("@WordType", SqlDbType.NVarChar).Value = w.WordType;
cmd.Parameters.Add("@VNMeans", SqlDbType.NText).Value = w.Means;
cmd.Parameters.Add("@Example", SqlDbType.NText).Value = w.Example;
cmd.ExecuteNonQuery();
return(true);
}
}
catch (Exception)
{
conn.Close();
}
return(false);
}
public void updateWord(string key, EN_VN_Word w)
{
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (SqlCommand cmd = new SqlCommand(updateWordCommand, conn))
{
cmd.Parameters.Add("ENKey", SqlDbType.VarChar).Value = w.ENKey;
cmd.Parameters.Add("@Pronounciation", SqlDbType.NVarChar).Value = w.Pronounciation;
cmd.Parameters.Add("@WordType", SqlDbType.NVarChar).Value = w.WordType;
cmd.Parameters.Add("@VNMeans", SqlDbType.NText).Value = w.Means;
cmd.Parameters.Add("@Example", SqlDbType.NText).Value = w.Example;
cmd.Parameters.Add("@key", SqlDbType.VarChar).Value = key;
cmd.ExecuteNonQuery();
}
}
catch
{
}
}
//autosave, is for history
public void saveWord(EN_VN_Word w, DateTime t)
{
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (SqlCommand cmd = new SqlCommand(saveWordCommand, conn))
{
cmd.Parameters.Add("@Time", SqlDbType.SmallDateTime).Value = t;
cmd.Parameters.Add("@ENKey", SqlDbType.VarChar).Value = w.ENKey;
cmd.Parameters.Add("@Pronounciation", SqlDbType.NVarChar).Value = w.Pronounciation;
cmd.Parameters.Add("@WordType", SqlDbType.NVarChar).Value = w.WordType;
cmd.Parameters.Add("@VNMeans", SqlDbType.NText).Value = w.Means;
cmd.Parameters.Add("@Example", SqlDbType.NText).Value = w.Example;
cmd.ExecuteNonQuery();
}
}
catch (Exception e)
{
conn.Close();
throw e;
}
}
public void unMarkWord(EN_VN_Word w)
{
if (objEN_VN.unMark(w.ENKey) == false)
{
MessageBox.Show("Failed");
}
else
{
return;
}
}
public void bookMarkWord(EN_VN_Word w)
{
if (objEN_VN.bookMark(w) == false)
{
MessageBox.Show("Failed");
}
else
{
return;
}
}
public EN_VN_Word getWord(string key)
{
EN_VN_Word w = null;
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (SqlCommand cmd = new SqlCommand(getEnWordCommand, conn))
{
cmd.Parameters.Add("@ENKey", SqlDbType.VarChar).Value = key;
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
w = new EN_VN_Word();
w.ENKey = sdr["ENKey"].ToString();
w.Pronounciation = sdr["Pronounciation"].ToString();
w.WordType = sdr["WordType"].ToString();
w.Means = sdr["VNMeans"].ToString();
w.Example = sdr["Example"].ToString();
}
sdr.Close();
}
}
catch (Exception e)
{
conn.Close();
throw e;
}
return(w);
}
public void updateWord(string key, EN_VN_Word w)
{
objEN_VN.updateWord(key, w);
}
public void addWord(EN_VN_Word w)
{
objEN_VN.addWord(w);
}
