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();
}
}
