/// <summary>
/// This event is called by Search button to search for a
/// spelling and enter the text fields with the information found
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btSearch_Click(object sender, EventArgs e)
{
//check to see if the text field is not empty
if (!String.IsNullOrEmpty(tbSearchSpelling.Text))
{
Word checkWordObj = new Word();
SearchWord searchWordObj = new SearchWord();
checkWordObj = searchWordObj.checkWord(WordList, tbSearchSpelling.Text);
if (!(checkWordObj == null))
{
tbSpelling.Text = checkWordObj.Spelling;
tbMeaning.Text = checkWordObj.Meaning;
tbSampleSentence.Text = checkWordObj.SampleSentence;
}
//if the word is already present then alert a message
else
{
MessageBox.Show("Word searched is not on list", "Word Not Found");
ClearFields();
}
}
else
{
MessageBox.Show("Search Field is empty", "Please enter the word to search");
ClearFields();
}
}
/// <summary>
/// This event is called by Search button to search for a
/// spelling and enter the text fields with the information found
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btSearch_Click(object sender, EventArgs e)
{
EditSpelling = string.Empty;
//check to see if the text field is not empty
if (!String.IsNullOrEmpty(tbSearchSpelling.Text))
{
Word checkWordObj = new Word();
SearchWord searchWordObj = new SearchWord();
checkWordObj = searchWordObj.checkWord(WordList, tbSearchSpelling.Text);
if (!(checkWordObj == null))
{
tbSpelling.Text = checkWordObj.Spelling;
tbMeaning.Text = checkWordObj.Meaning;
tbSampleSentence.Text = checkWordObj.SampleSentence;
EditSpelling = checkWordObj.Spelling;
}
//if the word is already present then alert a message
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Failed", "alert('Word searched is not on list,Word Not Found')", true);
ClearFields();
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Failed", "alert('Search Field is empty,Please enter the word to search')", true);
ClearFields();
}
}
/// <summary>
/// This event is invoked when save button is clicked
/// It adds the words into text file only if the word doesnt exists
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btSave_Click(object sender, EventArgs e)
{
Word checkWordObj = new Word();
SearchWord searchWordObj = new SearchWord();
checkWordObj = searchWordObj.checkWord(WordList, tbSpelling.Text);
if (String.IsNullOrEmpty(tbSpelling.Text) || String.IsNullOrEmpty(tbMeaning.Text) || String.IsNullOrEmpty(tbSampleSentence.Text))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Failed", "alert('Please enter value in all fields.')", true);
}
//if the fields are not empty,stores into text file
else
{
//Check for word if it already exists
if (!(checkWordObj == null))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Failed", "alert('The word is already existing.Please Enter an other word')", true);
return;
}
else
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["WordsDBConnStr"].ConnectionString))
{
conn.Open();
//Insert into the table with current contents
string queryText = "insert into \"all-word-table\" values(@SpellingTxt, @MeaningTxt, @ExampleTxt, @TimeCreatedTxt,@TimeUpdatedTxt)";
SqlCommand cmd = new SqlCommand(queryText, conn);
cmd.Parameters.AddWithValue("@SpellingTxt", tbSpelling.Text);
cmd.Parameters.AddWithValue("@MeaningTxt", tbMeaning.Text);
cmd.Parameters.AddWithValue("@ExampleTxt", tbSampleSentence.Text);
cmd.Parameters.AddWithValue("@TimeCreatedTxt", DateTime.Now);
cmd.Parameters.AddWithValue("@TimeUpdatedTxt", DBNull.Value);
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Success", "alert('Word has been Added Successfully')", true);
dgvCompleteGridView.DataBind();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Failed", "alert('Word has not been added.')", true);
}
}
}
//LoadData();
}
ClearFields();
}
/// <summary>
/// This event is invoked when save button is clicked
/// It adds the words into text file only if the word doesnt exists
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btSave_Click(object sender, EventArgs e)
{
Word checkWordObj = new Word();
SearchWord searchWordObj = new SearchWord();
checkWordObj = searchWordObj.checkWord(WordList, tbSpelling.Text);//calls the method in the library to check the word
//see if the text fields are not empty and alert the user to enter all the fields
if (String.IsNullOrEmpty(tbSpelling.Text) || String.IsNullOrEmpty(tbMeaning.Text) || String.IsNullOrEmpty(tbSampleSentence.Text))
{
MessageBox.Show("Please enter value in all fields.", "Error in adding word");
}
//if the fields are not empty,stores into text file
else
{
//checks if the word is already present in the text file
if (!(checkWordObj == null))
{
MessageBox.Show("The word is already existing.Please Enter an other word");
return;
}
//if it is new word,adds into text file by writing it
//creates a instance of writer in write mode
StreamWriter writer = new StreamWriter(wordsFile, true);
string line = string.Concat(tbSpelling.Text, "*", tbMeaning.Text, "*",
tbSampleSentence.Text);
//append the word to file
try
{
writer.WriteLine(line);
writer.Close();
LoadData();//update datagridview with new word
}
//let the user know what went wrong in appending the line
catch (Exception ex)
{
MessageBox.Show("There is some error caught. Err: " + ex.Message);
}
}
ClearFields();//reset the fields
}
/// <summary>
/// This event is invoked when save button is clicked
/// It adds the words into text file only if the word doesnt exists
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btSave_Click(object sender, EventArgs e)
{
Word checkWordObj = new Word();
SearchWord searchWordObj = new SearchWord();
checkWordObj = searchWordObj.checkWord(WordList, tbSpelling.Text);
if (String.IsNullOrEmpty(tbSpelling.Text) || String.IsNullOrEmpty(tbMeaning.Text) || String.IsNullOrEmpty(tbSampleSentence.Text))
{
MessageBox.Show("Please enter value in all fields.", "Error in adding word");
}
//if the fields are not empty,stores into text file
else
{
//MessageBox to confirm addition
DialogResult dr = MessageBox.Show("Do you want to add this word to database?", "Word Addition", MessageBoxButtons.YesNo);
//if the user wants to save the add ,add it to database
if (dr == System.Windows.Forms.DialogResult.Yes)
{
try
{
//Check for word if it already exists
if (!(checkWordObj == null))
{
MessageBox.Show("The word is already existing.Please Enter an other word");
return;
}
else
{
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
//Insert into the table with current contents
string queryText = "insert into \"all-word-table\" values(@SpellingTxt, @MeaningTxt, @ExampleTxt, @TimeCreatedTxt,@TimeUpdatedTxt)";
SqlCommand cmd = new SqlCommand(queryText, conn);
cmd.Parameters.AddWithValue("@SpellingTxt", tbSpelling.Text);
cmd.Parameters.AddWithValue("@MeaningTxt", tbMeaning.Text);
cmd.Parameters.AddWithValue("@ExampleTxt", tbSampleSentence.Text);
cmd.Parameters.AddWithValue("@TimeCreatedTxt", DateTime.Now);
cmd.Parameters.AddWithValue("@TimeUpdatedTxt", DBNull.Value);
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Word has been added successfully.", "Success");
}
else
{
MessageBox.Show("Word has not been added.", "Fail");
}
}
}
LoadData();
}
// If Inner Exception occurs, the message for tht exception is displyed
// else normal exception is displayed.
catch (Exception ex)
{
MessageBox.Show("There is some error caught. Err: " + ex.Message);
}
}
}
ClearFields();
}
