コード例 #1
0
        private void UpdateRecord()
        {
            using (new WaitCursor())
            {
                Record oclsRecord = new Record();
                Record clsRecord  = new Record();

                oclsRecord.Record_ID = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text);
                oclsRecord           = RecordData.Select_Record(oclsRecord);

                if (VerifyData() == true)
                {
                    SetData(clsRecord);
                    Boolean bSucess = new Boolean();
                    bSucess = RecordData.Update(oclsRecord, clsRecord);
                    if (bSucess == true)
                    {
                        GoBack_To_Grid();
                    }
                    else
                    {
                        MessageBox.Show("Update failed.", "Error");
                    }
                }
            }
        }
コード例 #2
0
        private void GetData()
        {
            using (new WaitCursor())
            {
                ClearRecord();

                Record clsRecord = new Record();
                clsRecord.Record_ID = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text);
                clsRecord           = RecordData.Select_Record(clsRecord);

                if ((clsRecord != null))
                {
                    try
                    {
                        nudRecord_ID.Text                              = System.Convert.ToInt32(clsRecord.Record_ID).ToString();
                        cbGroom_ID.SelectedValue                       = System.Convert.ToInt32(clsRecord.Groom_ID);
                        cbBride_ID.SelectedValue                       = System.Convert.ToInt32(clsRecord.Bride_ID);
                        dtpPapers_Recieved_Date.SelectedDate           = System.Convert.ToDateTime(clsRecord.Papers_Recieved_Date);
                        dtpWedding_Date.SelectedDate                   = System.Convert.ToDateTime(clsRecord.Wedding_Date);
                        dtpPapers_Mailed.SelectedDate                  = System.Convert.ToDateTime(clsRecord.Papers_Mailed);
                        cbDispensation_Type_ID.SelectedValue           = System.Convert.ToInt16(clsRecord.Dispensation_Type_ID);
                        tbAdditional_Circumstances_Note.Text           = Convert.ToString(clsRecord.Additional_Circumstances_Note);
                        cbDispensation_ID.SelectedValue                = System.Convert.ToInt32(clsRecord.Dispensation_ID);
                        cbCatholic_Party_ID.SelectedValue              = System.Convert.ToInt16(clsRecord.Catholic_Party_ID);
                        tbApproved_By.Text                             = Convert.ToString(clsRecord.Approved_By);
                        tbPapers_Mailed_Note.Text                      = Convert.ToString(clsRecord.Papers_Mailed_Note);
                        cbPaperwork_Originated_Parish_ID.SelectedValue = System.Convert.ToInt16(clsRecord.Paperwork_Originated_Parish_ID);
                        cbParish_Of_Wedding_Parish_ID.SelectedValue    = System.Convert.ToInt16(clsRecord.Parish_Of_Wedding_Parish_ID);
                        cbIs_Parish_Outside_Of_Diocese.IsChecked       = System.Convert.ToBoolean(clsRecord.Is_Parish_Outside_Of_Diocese);
                        tbOfficiant_Name.Text                          = Convert.ToString(clsRecord.Officiant_Name);
                        cbIs_Convalidated.IsChecked                    = System.Convert.ToBoolean(clsRecord.Is_Convalidated);
                        cbHas_Been_Annulled.IsChecked                  = System.Convert.ToBoolean(clsRecord.Has_Been_Annulled);
                        cbDispensationLink_ID.SelectedValue            = System.Convert.ToInt32(clsRecord.DispensationLink_ID);
                        tbModifiedBy.Text                              = Convert.ToString(clsRecord.ModifiedBy);
                    }
                    catch
                    {
                    }
                }
            }
        }