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