private void UpdateRecord() { using (new WaitCursor()) { Dispensation oclsDispensation = new Dispensation(); Dispensation clsDispensation = new Dispensation(); oclsDispensation.Dispensation_ID = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text); oclsDispensation = DispensationData.Select_Record(oclsDispensation); if (VerifyData() == true) { SetData(clsDispensation); Boolean bSucess = new Boolean(); bSucess = DispensationData.Update(oclsDispensation, clsDispensation); if (bSucess == true) { GoBack_To_Grid(); } else { MessageBox.Show("Update failed.", "Error"); } } } }
private void SetData(Dispensation clsDispensation) { using (new WaitCursor()) { clsDispensation.Dispensation_Category = System.Convert.ToString(tbDispensation_Category.Text); } }
public static Dispensation Select_Record(Dispensation clsDispensationPara) { Dispensation clsDispensation = new Dispensation(); SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [Dispensation_ID] " + " ,[Dispensation_Category] " + "FROM " + " [Dispensation] " + "WHERE " + " [Dispensation_ID] = @Dispensation_ID " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@Dispensation_ID", clsDispensationPara.Dispensation_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsDispensation.Dispensation_ID = System.Convert.ToInt32(reader["Dispensation_ID"]); clsDispensation.Dispensation_Category = System.Convert.ToString(reader["Dispensation_Category"]); } else { clsDispensation = null; } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(clsDispensation); }
public static bool Update(Dispensation oldDispensation, Dispensation newDispensation) { SqlConnection connection = MarriageData.GetConnection(); string updateStatement = "UPDATE " + " [Dispensation] " + "SET " + " [Dispensation_Category] = @NewDispensation_Category " + "WHERE " + " [Dispensation_ID] = @OldDispensation_ID " + " AND [Dispensation_Category] = @OldDispensation_Category " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; updateCommand.Parameters.AddWithValue("@NewDispensation_Category", newDispensation.Dispensation_Category); updateCommand.Parameters.AddWithValue("@OldDispensation_ID", oldDispensation.Dispensation_ID); updateCommand.Parameters.AddWithValue("@OldDispensation_Category", oldDispensation.Dispensation_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()) { Dispensation clsDispensation = new Dispensation(); if (VerifyData() == true) { SetData(clsDispensation); Boolean bSucess = new Boolean(); bSucess = DispensationData.Add(clsDispensation); if (bSucess == true) { GoBack_To_Grid(); } else { MessageBox.Show("Insert failed.", "Error"); } } } }
public static bool Add(Dispensation clsDispensation) { SqlConnection connection = MarriageData.GetConnection(); string insertStatement = "INSERT " + " [Dispensation] " + " ( " + " [Dispensation_Category] " + " ) " + "VALUES " + " ( " + " @Dispensation_Category " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; insertCommand.Parameters.AddWithValue("@Dispensation_Category", clsDispensation.Dispensation_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()) { Dispensation clsDispensation = new Dispensation(); clsDispensation.Dispensation_ID = System.Convert.ToInt32((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(clsDispensation); Boolean bSucess = new Boolean(); bSucess = DispensationData.Delete(clsDispensation); if (bSucess == true) { GoBack_To_Grid(); } else { MessageBox.Show("Delete failed.", "Error"); } } } }
private void GetData() { using (new WaitCursor()) { ClearRecord(); Dispensation clsDispensation = new Dispensation(); clsDispensation.Dispensation_ID = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text); clsDispensation = DispensationData.Select_Record(clsDispensation); if ((clsDispensation != null)) { try { nudDispensation_ID.Text = System.Convert.ToInt32(clsDispensation.Dispensation_ID).ToString(); tbDispensation_Category.Text = Convert.ToString(clsDispensation.Dispensation_Category); } catch { } } } }
public static bool Delete(Dispensation clsDispensation) { SqlConnection connection = MarriageData.GetConnection(); string deleteStatement = "DELETE FROM " + " [Dispensation] " + "WHERE " + " [Dispensation_ID] = @OldDispensation_ID " + " AND [Dispensation_Category] = @OldDispensation_Category " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldDispensation_ID", clsDispensation.Dispensation_ID); deleteCommand.Parameters.AddWithValue("@OldDispensation_Category", clsDispensation.Dispensation_Category); try { connection.Open(); int count = deleteCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }