private void typeDelete_Click(object sender, RoutedEventArgs e) { if (!String.IsNullOrEmpty(wordTypeTxt.Text) && !String.IsNullOrEmpty(typeIdTxt.Text)) { SqlConnection sqlConFill = new SqlConnection(conn); SqlCommand cmdFill = new SqlCommand(); cmdFill.CommandText = "DELETE FROM Catagory_list WHERE Cat_Id=@CatagoryId"; cmdFill.Parameters.AddWithValue("@CatagoryId", typeIdTxt.Text); cmdFill.Connection = sqlConFill; sqlConFill.Open(); cmdFill.ExecuteNonQuery(); sqlConFill.Close(); cmdFill.CommandText = "DELETE FROM Words WHERE Cat_Id=@CatagoryId3"; cmdFill.Parameters.AddWithValue("@CatagoryId3", typeIdTxt.Text); cmdFill.Connection = sqlConFill; sqlConFill.Open(); cmdFill.ExecuteNonQuery(); sqlConFill.Close(); cmdFill.CommandText = "UPDATE Catagory_list SET Cat_Id=Cat_Id-1 WHERE Cat_Id>@CatagoryId2"; cmdFill.Parameters.AddWithValue("@CatagoryId2", typeIdTxt.Text); cmdFill.Connection = sqlConFill; sqlConFill.Open(); cmdFill.ExecuteNonQuery(); sqlConFill.Close(); cmdFill.CommandText = "UPDATE Words SET Cat_Id=Cat_Id-1 WHERE Cat_Id>@CatagoryId7"; cmdFill.Parameters.AddWithValue("@CatagoryId7", typeIdTxt.Text); cmdFill.Connection = sqlConFill; sqlConFill.Open(); cmdFill.ExecuteNonQuery(); sqlConFill.Close(); cache(0); WordCatagory win2 = new WordCatagory(); win2.Show(); this.Close(); } else { MessageBox.Show("Catagory Id or Name Cann't be Empty"); } }
private void wordInsert_Click(object sender, RoutedEventArgs e) { if (!String.IsNullOrEmpty(wordTxt.Text) && !String.IsNullOrEmpty(catIdTxt.Text)) { if (!Regex.Match(catIdTxt.Text, @"^[0-9]*$").Success) { // phone number was incorrect MessageBox.Show("Invalid Catagory ID", "Message", MessageBoxButton.OK, MessageBoxImage.Error); catIdTxt.Focus(); return; } if (existCheck(wordTxt.Text, -1) != 1) { SqlConnection sqlConFill2 = new SqlConnection(conn); SqlCommand cmdFill2 = new SqlCommand(); sqlConFill2 = new SqlConnection(conn); cmdFill2 = new SqlCommand(); cmdFill2.CommandText = "INSERT INTO Words(Cat_Id,Word,singular,indef_singular,def_singular,plural,def_plural,note) VALUES (@CatId,@wordnm,@singularnm,@indefsingnm,@defsingnm,@pluralnm,@defpluralnm,@notenm)"; cmdFill2.Parameters.AddWithValue("@CatId", catIdTxt.Text); cmdFill2.Parameters.AddWithValue("@Wordnm", wordTxt.Text); cmdFill2.Parameters.AddWithValue("@singularnm", singularTxt.Text); cmdFill2.Parameters.AddWithValue("@indefsingnm", indefSingularTxt.Text); cmdFill2.Parameters.AddWithValue("@defsingnm", defSingularTxt.Text); cmdFill2.Parameters.AddWithValue("@pluralnm", pluralTxt.Text); cmdFill2.Parameters.AddWithValue("@defpluralnm", defPluralTxt.Text); cmdFill2.Parameters.AddWithValue("@notenm", noteTxt.Text); cmdFill2.Connection = sqlConFill2; sqlConFill2.Open(); cmdFill2.ExecuteNonQuery(); sqlConFill2.Close(); cache(Convert.ToInt32(catIdTxt.Text)); WordCatagory win2 = new WordCatagory(); win2.Show(); this.Close(); } } else { MessageBox.Show("Word Or Type Id Cann't be Empty", " ", MessageBoxButton.OK, MessageBoxImage.Error); catIdTxt.Focus(); return; } }
private void wordUpdate_Click(object sender, RoutedEventArgs e) { if (!String.IsNullOrEmpty(wordTxt.Text) && !String.IsNullOrEmpty(catIdTxt.Text)) { if (!Regex.Match(catIdTxt.Text, @"^[0-9]*$").Success) { // phone number was incorrect MessageBox.Show("Invalid Catagory ID", "Message", MessageBoxButton.OK, MessageBoxImage.Error); catIdTxt.Focus(); return; } if (existCheck(wordTxt.Text, Convert.ToInt32(wordIdTxt.Text)) == -1) { SqlConnection sqlConFill2 = new SqlConnection(conn); SqlCommand cmdFill2 = new SqlCommand(); cmdFill2.CommandText = "UPDATE Words SET Cat_Id=@CatId,Word=@wordnm,singular=@singularnm,indef_singular=@indefsingnm,def_singular=@defsingnm,plural=@pluralnm,def_plural=@defpluralnm,note=@notenm WHERE Word_Id=@wordId"; cmdFill2.Parameters.AddWithValue("@CatId", catIdTxt.Text); cmdFill2.Parameters.AddWithValue("@Wordnm", wordTxt.Text); cmdFill2.Parameters.AddWithValue("@singularnm", singularTxt.Text); cmdFill2.Parameters.AddWithValue("@indefsingnm", indefSingularTxt.Text); cmdFill2.Parameters.AddWithValue("@defsingnm", defSingularTxt.Text); cmdFill2.Parameters.AddWithValue("@pluralnm", pluralTxt.Text); cmdFill2.Parameters.AddWithValue("@defpluralnm", defPluralTxt.Text); cmdFill2.Parameters.AddWithValue("@notenm", noteTxt.Text); cmdFill2.Parameters.AddWithValue("@wordId", wordIdTxt.Text); cmdFill2.Connection = sqlConFill2; sqlConFill2.Open(); cmdFill2.ExecuteNonQuery(); sqlConFill2.Close(); cache(Convert.ToInt32(catIdTxt.Text)); WordCatagory win2 = new WordCatagory(); win2.Show(); this.Close(); } } else { MessageBox.Show("Type Id or Name Cann't be Empty", " ", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void typeUpdate_Click(object sender, RoutedEventArgs e) { if (!String.IsNullOrEmpty(wordTypeTxt.Text) && !String.IsNullOrEmpty(typeIdTxt.Text)) { SqlConnection sqlConFill = new SqlConnection(conn); SqlCommand cmdFill = new SqlCommand(); cmdFill.CommandText = "UPDATE Catagory_list SET Cat_Id=@CatagoryId,Cat_Name=@CatagoryName WHERE Cat_Id=@CatagoryId"; cmdFill.Parameters.AddWithValue("@CatagoryId", typeIdTxt.Text); cmdFill.Parameters.AddWithValue("@CatagoryName", wordTypeTxt.Text); cmdFill.Connection = sqlConFill; sqlConFill.Open(); cmdFill.ExecuteNonQuery(); sqlConFill.Close(); WordCatagory win2 = new WordCatagory(); win2.Show(); this.Close(); } else { MessageBox.Show("Type Id or Name Cann't be Empty", " ", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void wordDelete_Click(object sender, RoutedEventArgs e) { if (!String.IsNullOrEmpty(wordIdTxt.Text)) { SqlConnection sqlConFill = new SqlConnection(conn); SqlCommand cmdFill = new SqlCommand(); cmdFill.CommandText = "DELETE FROM Words WHERE Word_Id=@CatagoryId5"; cmdFill.Parameters.AddWithValue("@CatagoryId5", wordIdTxt.Text); cmdFill.Connection = sqlConFill; sqlConFill.Open(); cmdFill.ExecuteNonQuery(); sqlConFill.Close(); cache(Convert.ToInt32(catIdTxt.Text)); WordCatagory win2 = new WordCatagory(); win2.Show(); this.Close(); } else { MessageBox.Show("Word Id Cann't be Empty"); } }
private void change2(object sender, RoutedEventArgs e) { if (m == 0) { //wordList.ItemsSource = null; String txt2 = Convert.ToString(((DataRowView)grdCatagory.SelectedItem)["Cat_Id"]); if (txt2 != null) { typeIdTxt.Text = Convert.ToString(((DataRowView)grdCatagory.SelectedItem)["Cat_Id"]); wordTypeTxt.Text = Convert.ToString(((DataRowView)grdCatagory.SelectedItem)["Cat_Name"]); } SqlConnection sqlConFill = new SqlConnection(conn); SqlCommand cmdFill = new SqlCommand(); cmdFill.CommandText = "SELECT * FROM Words WHERE Cat_Id=@Id"; cmdFill.Parameters.AddWithValue("@Id", typeIdTxt.Text); cmdFill.Connection = sqlConFill; sqlConFill.Open(); SqlDataAdapter sda = new SqlDataAdapter(cmdFill); DataTable dt = new DataTable("Words"); sda.Fill(dt); wordList.ItemsSource = dt.DefaultView; sqlConFill.Close(); cache(Convert.ToInt32(typeIdTxt.Text)); typeUpdate.IsEnabled = true; typeDelete.IsEnabled = true; typeCreate.IsEnabled = true; //wordTxt.Focus(); //wordList.ItemsSource = null; } else { WordCatagory win2 = new WordCatagory(); win2.Show(); this.Close(); } }
private void typeCreate_Click(object sender, RoutedEventArgs e) { if (!String.IsNullOrEmpty(wordTypeTxt.Text)) { int sr = 0; SqlConnection sqlConFill2 = new SqlConnection(conn); SqlCommand cmdFill2 = new SqlCommand(); cmdFill2.CommandText = "SELECT MAX(Cat_Id) FROM Catagory_list"; cmdFill2.Connection = sqlConFill2; sqlConFill2.Open(); SqlDataReader rd1 = cmdFill2.ExecuteReader(); if (rd1.HasRows) { rd1.Read(); var outputParam = rd1[0]; if (!(outputParam is DBNull)) { sr = Convert.ToInt32(rd1[0]); } else { sr = 0; } rd1.Close(); } sqlConFill2.Close(); sr = sr + 1; cmdFill2.CommandText = "SELECT Cat_Id FROM Catagory_list WHERE Cat_Name=@Name"; cmdFill2.Parameters.AddWithValue("@Name", wordTypeTxt.Text); cmdFill2.Connection = sqlConFill2; sqlConFill2.Open(); SqlDataReader rd = cmdFill2.ExecuteReader(); String cat = ""; if (rd.HasRows) { rd.Read(); cat = cat + rd[0].ToString(); rd.Close(); sqlConFill2.Close(); MessageBox.Show("This Word Type Already Exist at Id " + cat, " ", MessageBoxButton.OK, MessageBoxImage.Exclamation); } else { sqlConFill2.Close(); sqlConFill2 = new SqlConnection(conn); cmdFill2 = new SqlCommand(); cmdFill2.CommandText = "INSERT INTO Catagory_list(Cat_Id,Cat_Name) VALUES (@CatagoryId,@CatagoryName)"; cmdFill2.Parameters.AddWithValue("@CatagoryId", sr.ToString()); cmdFill2.Parameters.AddWithValue("@CatagoryName", wordTypeTxt.Text); cmdFill2.Connection = sqlConFill2; sqlConFill2.Open(); cmdFill2.ExecuteNonQuery(); sqlConFill2.Close(); cache(0); WordCatagory win2 = new WordCatagory(); win2.Show(); this.Close(); } } else { MessageBox.Show("Catagory Name Cann't be Empty", " ", MessageBoxButton.OK, MessageBoxImage.Error); } }