private void UpdateRecord()
{
using (new WaitCursor())
{
MarriageRec oclsMarriageRec = new MarriageRec();
MarriageRec clsMarriageRec = new MarriageRec();
oclsMarriageRec.Record_ID = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text);
oclsMarriageRec = MarriageRecData.Select_Record(oclsMarriageRec);
if (VerifyData() == true)
{
SetData(clsMarriageRec);
Boolean bSucess = new Boolean();
bSucess = MarriageRecData.Update(oclsMarriageRec, clsMarriageRec);
if (bSucess == true)
{
GoBack_To_Grid();
}
else
{
MessageBox.Show("Update failed.", "Error");
}
}
}
}
private void SetData(MarriageRec clsMarriageRec)
{
using (new WaitCursor())
{
clsMarriageRec.Groom_ID = System.Convert.ToInt32(cbGroom_ID.SelectedValue);
clsMarriageRec.Bride_ID = System.Convert.ToInt32(cbBride_ID.SelectedValue);
clsMarriageRec.Papers_Recieved_Date = System.Convert.ToDateTime(dtpPapers_Recieved_Date.Text);
clsMarriageRec.Wedding_Date = System.Convert.ToDateTime(dtpWedding_Date.Text);
clsMarriageRec.Papers_Mailed = System.Convert.ToDateTime(dtpPapers_Mailed.Text);
clsMarriageRec.Dispensation_Type_ID = System.Convert.ToInt16(cbDispensation_Type_ID.SelectedValue);
clsMarriageRec.Additional_Circumstances_Note = System.Convert.ToString(tbAdditional_Circumstances_Note.Text);
clsMarriageRec.Dispensation_ID = System.Convert.ToInt32(cbDispensation_ID.SelectedValue);
clsMarriageRec.Catholic_Party_ID = System.Convert.ToInt16(cbCatholic_Party_ID.SelectedValue);
clsMarriageRec.Approved_By = System.Convert.ToString(tbApproved_By.Text);
clsMarriageRec.Papers_Mailed_Note = System.Convert.ToString(tbPapers_Mailed_Note.Text);
clsMarriageRec.Paperwork_Originated_Parish_ID = System.Convert.ToInt16(cbPaperwork_Originated_Parish_ID.SelectedValue);
clsMarriageRec.Parish_Of_Wedding_Parish_ID = System.Convert.ToInt16(cbParish_Of_Wedding_Parish_ID.SelectedValue);
clsMarriageRec.Is_Parish_Outside_Of_Diocese = System.Convert.ToBoolean(System.Convert.ToBoolean(cbIs_Parish_Outside_Of_Diocese.IsChecked) ? true : false);
clsMarriageRec.Officiant_Name = System.Convert.ToString(tbOfficiant_Name.Text);
clsMarriageRec.Is_Convalidated = System.Convert.ToBoolean(System.Convert.ToBoolean(cbIs_Convalidated.IsChecked) ? true : false);
clsMarriageRec.Has_Been_Annulled = System.Convert.ToBoolean(System.Convert.ToBoolean(cbHas_Been_Annulled.IsChecked) ? true : false);
clsMarriageRec.DispensationLink_ID = System.Convert.ToInt32(nudDispensationLink_ID.Text);
clsMarriageRec.ModifiedBy = System.Convert.ToString(tbModifiedBy.Text);
clsMarriageRec.Bride_First_Name = System.Convert.ToString(tbBride_First_Name.Text);
clsMarriageRec.Bride_Middle_Int = System.Convert.ToString(tbBride_Middle_Int.Text);
clsMarriageRec.Bride_Last_Name = System.Convert.ToString(tbBride_Last_Name.Text);
clsMarriageRec.Groom_First_Name = System.Convert.ToString(tbGroom_First_Name.Text);
clsMarriageRec.Groom_Middle_Int = System.Convert.ToString(tbGroom_Middle_Int.Text);
clsMarriageRec.Groom_Last_Name = System.Convert.ToString(tbGroom_Last_Name.Text);
}
}
private void GetData()
{
using (new WaitCursor())
{
ClearRecord();
MarriageRec clsMarriageRec = new MarriageRec();
clsMarriageRec.Record_ID = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text);
clsMarriageRec = MarriageRecData.Select_Record(clsMarriageRec);
if ((clsMarriageRec != null))
{
try
{
nudRecord_ID.Text = System.Convert.ToInt32(clsMarriageRec.Record_ID).ToString();
cbGroom_ID.SelectedValue = System.Convert.ToInt32(clsMarriageRec.Groom_ID);
cbBride_ID.SelectedValue = System.Convert.ToInt32(clsMarriageRec.Bride_ID);
dtpPapers_Recieved_Date.SelectedDate = System.Convert.ToDateTime(clsMarriageRec.Papers_Recieved_Date);
dtpWedding_Date.SelectedDate = System.Convert.ToDateTime(clsMarriageRec.Wedding_Date);
dtpPapers_Mailed.SelectedDate = System.Convert.ToDateTime(clsMarriageRec.Papers_Mailed);
cbDispensation_Type_ID.SelectedValue = System.Convert.ToInt16(clsMarriageRec.Dispensation_Type_ID);
tbAdditional_Circumstances_Note.Text = Convert.ToString(clsMarriageRec.Additional_Circumstances_Note);
cbDispensation_ID.SelectedValue = System.Convert.ToInt32(clsMarriageRec.Dispensation_ID);
cbCatholic_Party_ID.SelectedValue = System.Convert.ToInt16(clsMarriageRec.Catholic_Party_ID);
tbApproved_By.Text = Convert.ToString(clsMarriageRec.Approved_By);
tbPapers_Mailed_Note.Text = Convert.ToString(clsMarriageRec.Papers_Mailed_Note);
cbPaperwork_Originated_Parish_ID.SelectedValue = System.Convert.ToInt16(clsMarriageRec.Paperwork_Originated_Parish_ID);
cbParish_Of_Wedding_Parish_ID.SelectedValue = System.Convert.ToInt16(clsMarriageRec.Parish_Of_Wedding_Parish_ID);
cbIs_Parish_Outside_Of_Diocese.IsChecked = System.Convert.ToBoolean(clsMarriageRec.Is_Parish_Outside_Of_Diocese);
tbOfficiant_Name.Text = Convert.ToString(clsMarriageRec.Officiant_Name);
cbIs_Convalidated.IsChecked = System.Convert.ToBoolean(clsMarriageRec.Is_Convalidated);
cbHas_Been_Annulled.IsChecked = System.Convert.ToBoolean(clsMarriageRec.Has_Been_Annulled);
nudDispensationLink_ID.Text = System.Convert.ToInt32(clsMarriageRec.DispensationLink_ID).ToString();
tbModifiedBy.Text = Convert.ToString(clsMarriageRec.ModifiedBy);
tbBride_First_Name.Text = Convert.ToString(clsMarriageRec.Bride_First_Name);
tbBride_Middle_Int.Text = Convert.ToString(clsMarriageRec.Bride_Middle_Int);
tbBride_Last_Name.Text = Convert.ToString(clsMarriageRec.Bride_Last_Name);
tbGroom_First_Name.Text = Convert.ToString(clsMarriageRec.Groom_First_Name);
tbGroom_Middle_Int.Text = Convert.ToString(clsMarriageRec.Groom_Middle_Int);
tbGroom_Last_Name.Text = Convert.ToString(clsMarriageRec.Groom_Last_Name);
}
catch
{
}
}
}
}
private void InsertRecord()
{
using (new WaitCursor())
{
MarriageRec clsMarriageRec = new MarriageRec();
if (VerifyData() == true)
{
SetData(clsMarriageRec);
Boolean bSucess = new Boolean();
bSucess = MarriageRecData.Add(clsMarriageRec);
if (bSucess == true)
{
GoBack_To_Grid();
}
else
{
MessageBox.Show("Insert failed.", "Error");
}
}
}
}
private void DeleteRecord()
{
using (new WaitCursor())
{
MarriageRec clsMarriageRec = new MarriageRec();
clsMarriageRec.Record_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(clsMarriageRec);
Boolean bSucess = new Boolean();
bSucess = MarriageRecData.Delete(clsMarriageRec);
if (bSucess == true)
{
GoBack_To_Grid();
}
else
{
MessageBox.Show("Delete failed.", "Error");
}
}
}
}
