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