private void UpdateRecord() { using (new WaitCursor()) { Catholic_Party oclsCatholic_Party = new Catholic_Party(); Catholic_Party clsCatholic_Party = new Catholic_Party(); oclsCatholic_Party.Catholic_Party_ID = System.Convert.ToInt16((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text); oclsCatholic_Party = Catholic_PartyData.Select_Record(oclsCatholic_Party); if (VerifyData() == true) { SetData(clsCatholic_Party); Boolean bSucess = new Boolean(); bSucess = Catholic_PartyData.Update(oclsCatholic_Party, clsCatholic_Party); if (bSucess == true) { GoBack_To_Grid(); } else { MessageBox.Show("Update failed.", "Error"); } } } }
private void SetData(Catholic_Party clsCatholic_Party) { using (new WaitCursor()) { clsCatholic_Party.Catholic_Party_Category = System.Convert.ToString(tbCatholic_Party_Category.Text); } }
public static Catholic_Party Select_Record(Catholic_Party clsCatholic_PartyPara) { Catholic_Party clsCatholic_Party = new Catholic_Party(); SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [Catholic_Party_ID] " + " ,[Catholic_Party_Category] " + "FROM " + " [Catholic_Party] " + "WHERE " + " [Catholic_Party_ID] = @Catholic_Party_ID " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@Catholic_Party_ID", clsCatholic_PartyPara.Catholic_Party_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsCatholic_Party.Catholic_Party_ID = System.Convert.ToInt16(reader["Catholic_Party_ID"]); clsCatholic_Party.Catholic_Party_Category = System.Convert.ToString(reader["Catholic_Party_Category"]); } else { clsCatholic_Party = null; } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(clsCatholic_Party); }
public static bool Update(Catholic_Party oldCatholic_Party, Catholic_Party newCatholic_Party) { SqlConnection connection = MarriageData.GetConnection(); string updateStatement = "UPDATE " + " [Catholic_Party] " + "SET " + " [Catholic_Party_Category] = @NewCatholic_Party_Category " + "WHERE " + " [Catholic_Party_ID] = @OldCatholic_Party_ID " + " AND [Catholic_Party_Category] = @OldCatholic_Party_Category " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; updateCommand.Parameters.AddWithValue("@NewCatholic_Party_Category", newCatholic_Party.Catholic_Party_Category); updateCommand.Parameters.AddWithValue("@OldCatholic_Party_ID", oldCatholic_Party.Catholic_Party_ID); updateCommand.Parameters.AddWithValue("@OldCatholic_Party_Category", oldCatholic_Party.Catholic_Party_Category); try { connection.Open(); int count = updateCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
private void InsertRecord() { using (new WaitCursor()) { Catholic_Party clsCatholic_Party = new Catholic_Party(); if (VerifyData() == true) { SetData(clsCatholic_Party); Boolean bSucess = new Boolean(); bSucess = Catholic_PartyData.Add(clsCatholic_Party); if (bSucess == true) { GoBack_To_Grid(); } else { MessageBox.Show("Insert failed.", "Error"); } } } }
public static bool Add(Catholic_Party clsCatholic_Party) { SqlConnection connection = MarriageData.GetConnection(); string insertStatement = "INSERT " + " [Catholic_Party] " + " ( " + " [Catholic_Party_Category] " + " ) " + "VALUES " + " ( " + " @Catholic_Party_Category " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; insertCommand.Parameters.AddWithValue("@Catholic_Party_Category", clsCatholic_Party.Catholic_Party_Category); try { connection.Open(); int count = insertCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
private void DeleteRecord() { using (new WaitCursor()) { Catholic_Party clsCatholic_Party = new Catholic_Party(); clsCatholic_Party.Catholic_Party_ID = System.Convert.ToInt16((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text); if (MessageBox.Show("Are you sure? Delete this record?", "Delete", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { SetData(clsCatholic_Party); Boolean bSucess = new Boolean(); bSucess = Catholic_PartyData.Delete(clsCatholic_Party); if (bSucess == true) { GoBack_To_Grid(); } else { MessageBox.Show("Delete failed.", "Error"); } } } }
private void GetData() { using (new WaitCursor()) { ClearRecord(); Catholic_Party clsCatholic_Party = new Catholic_Party(); clsCatholic_Party.Catholic_Party_ID = System.Convert.ToInt16((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text); clsCatholic_Party = Catholic_PartyData.Select_Record(clsCatholic_Party); if ((clsCatholic_Party != null)) { try { nudCatholic_Party_ID.Text = System.Convert.ToInt16(clsCatholic_Party.Catholic_Party_ID).ToString(); tbCatholic_Party_Category.Text = Convert.ToString(clsCatholic_Party.Catholic_Party_Category); } catch { } } } }
public static bool Delete(Catholic_Party clsCatholic_Party) { SqlConnection connection = MarriageData.GetConnection(); string deleteStatement = "DELETE FROM " + " [Catholic_Party] " + "WHERE " + " [Catholic_Party_ID] = @OldCatholic_Party_ID " + " AND [Catholic_Party_Category] = @OldCatholic_Party_Category " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldCatholic_Party_ID", clsCatholic_Party.Catholic_Party_ID); deleteCommand.Parameters.AddWithValue("@OldCatholic_Party_Category", clsCatholic_Party.Catholic_Party_Category); try { connection.Open(); int count = deleteCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }