public fmRefExpAllwncEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            this.BaseFormStyle(caption);
            btnOk.Enabled = false;

            string error;

            _deps = _repoDep.GetAllDeps(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка завантаження довідника підрозділів.\nТехнічна інформація: " + error, "Помилка");
                return;
            }
            _cmbDepParams.refDeps = _deps;
            _cmbDepParams.tbCd    = tbDepCd;
            _cmbDepParams.tbNm    = tbDepNm;
            _cmbDep.AddCombobox(btnDep, _cmbDepParams);

            tbYear.AddNumericField();
            tbMech.AddFloatField(3, 2);
            tbOth.AddFloatField(3, 2);

            tbCd.NecessaryField();
            tbNm.NecessaryField();
            tbYear.NecessaryField();
            tbMech.NecessaryField();
            tbOth.NecessaryField();
        }
Exemple #2
0
        public fmPaymentEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            this.BaseFormStyle(caption);
            btnOk.Enabled = false;

            string error;

            _cards = _repoPersCard.GetAllCards(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка завантаження довідника особових карток.\nТехнічна інформація: " + error, "Помилка");
                return;
            }
            _cmbCardParams.persCards = _cards;
            _cmbCardParams.tbFio     = tbFIO;
            _cmbCardParams.tbTIN     = tbTIN;
            cmbCard.AddCombobox(btnCard, _cmbCardParams);

            tbAmt.AddFloatField(10, 2);
            tbSm.AddFloatField(10, 2);
            tbDate.AddDateField('.');

            tbFIO.NecessaryField(30);
            tbDate.NecessaryField();
            tbSm.NecessaryField();
        }
 private void buttonCancel_Click(object sender, EventArgs e)
 {
     if (mode == EnumFormMode.CallbackAdd)
     {
         DialogResult = DialogResult.Cancel;
         Close();
     }
     if (mode != EnumFormMode.ViewMode)
     {
         mode = EnumFormMode.ViewMode;
         buttonCancel.Text  = "Close";
         buttonSave.Visible = false;
         if (_rowIndex > 0)
         {
             FillTabContent(_rowIndex);
         }
         else if (_dtVenue.Rows.Count > 0)
         {
             //default to 0
             FillTabContent(0);
         }
         else
         {
             UtilityHelper.ClearTextbox(Controls);
             ClearImages();
         }
         UtilityHelper.SetToReadOnly(Controls);
         dataGridViewVenue.Enabled = true;
     }
     else
     {
         Close();
     }
 }
Exemple #4
0
        public fmPersCardSpecExpEdit(EnumFormMode mode, string caption, List <RefSpecExp> refSpecExps)
        {
            InitializeComponent();

            vwFldSpecExp.Add(new ViewField {
                Name = "RefSpecExp_Cd", Caption = "Код", Type = TypeFields.textBox
            });
            vwFldSpecExp.Add(new ViewField {
                Name = "RefSpecExp_ShortName", Caption = "Скорочене найменування", Type = TypeFields.textBox
            });
            vwFldSpecExp.Add(new ViewField {
                Name = "RefSpecExp_Name", Caption = "Найменування", Type = TypeFields.textBox
            });

            resFldSpecExp.Add(new ResField {
                Name = "RefSpecExp_Id"
            });
            resFldSpecExp.Add(new ResField {
                Name = "RefSpecExp_Cd", TxtBx = tbSpecExpCd, IsSearchByField = true
            });
            resFldSpecExp.Add(new ResField {
                Name = "RefSpecExp_Name", TxtBx = tbSpecExpNm
            });

            cmbSpecExp.AddCombobox(btnSpecExp, refSpecExps, vwFldSpecExp, resFldSpecExp, true, "RefSpecExp_Id");

            this.BaseFormStyle(caption);
            btnOk.Enabled = false;
            tbPerBeg.AddDateField('.');
            tbPerEnd.AddDateField('.');

            tbSpecExpCd.NecessaryField(175);
        }
Exemple #5
0
        public fmPersCardEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();

            Text          = caption;
            btnOk.Enabled = false;

            dgvAddInfo.BaseGrigStyle();
            dgvAddInfo.ReadOnly   = false;
            dgvAddInfo.DataSource = addInfo;
            dgvAddInfo.Columns["MonthName"].ReadOnly = true;

            tbLName.NecessaryField();
            tbFName.NecessaryField();
            tbDOB.NecessaryField();
            tbDOR.NecessaryField();
            tbTIN.NecessaryField();

            tbTIN.AddNumericField();
            tbExp.AddNumericField();
            tbGrade.AddNumericField();

            tbDOB.AddDateField('.');
            tbDOR.AddDateField('.');
            tbDOD.AddDateField('.');
            tbDOP.AddDateField('.');
        }
Exemple #6
0
 public fmPersCardStatusEdit(EnumFormMode mode, string caption)
 {
     InitializeComponent();
     this.BaseFormStyle(caption);
     btnOk.Enabled = false;
     tbPerBeg.AddDateField('.');
     tbPerEnd.AddDateField('.');
 }
        public fmRefTypeAddAccrEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            this.BaseFormStyle(caption);
            btnOk.Enabled = false;

            tbCode.NecessaryField();
            tbName.NecessaryField();
        }
 public fmRefAdmEdit(EnumFormMode mode, string caption)
 {
     InitializeComponent();
     this.BaseFormStyle(caption);
     btnOk.Enabled = false;
     tbFIO.NecessaryField();
     tbTIN.AddNumericField();
     tbTel.AddNumericField();
     InitCmbPosition();
 }
Exemple #9
0
        public fmPersCardTaxReliefEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            this.BaseFormStyle(caption);
            btnOk.Enabled = false;
            tbPerBeg.AddDateField('.');
            tbPerEnd.AddDateField('.');

            tbKoef.AddFloatField(10, 2);
            tbKoef.NecessaryField();
        }
        public fmRefMinSalaryEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            this.BaseFormStyle(caption);
            btnOk.Enabled = false;
            tbPerBeg.AddDateField('.');
            tbPerEnd.AddDateField('.');

            tbSm.AddFloatField(16, 2);
            tbSm.NecessaryField();
        }
Exemple #11
0
        public fmPersCardDisabilityEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            this.BaseFormStyle(caption);
            btnOk.Enabled = false;
            tbPerBeg.AddDateField('.');
            tbPerEnd.AddDateField('.');

            tbAttr.AddNumericField();
            tbAttr.NecessaryField();
        }
Exemple #12
0
        public fmAddPaymentEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            this.BaseFormStyle(caption);
            btnOk.Enabled = false;

            string error;

            _cards = _repoPersCard.GetAllCards(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка отримання довідника особових карток.\nТехнічна інформація: " + error, "Помилка");
                return;
            }
            _cmbCardParams.persCards = _cards;
            _cmbCardParams.tbFio     = tbFIO;
            _cmbCardParams.tbTIN     = tbTIN;
            cmbCard.AddCombobox(btnCard, _cmbCardParams);

            _typeAddPayments = _repoTypeAddPayment.GetAllTypeAddPayments(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка отримання довідника типів додаткових виплат.\nТехнічна інформація: " + error, "Помилка");
                return;
            }

            vwFldTypeAddPayment.Add(new ViewField {
                Name = "RefTypeAddPayment_Cd", Caption = "Код", Type = TypeFields.textBox
            });
            vwFldTypeAddPayment.Add(new ViewField {
                Name = "RefTypeAddPayment_Nm", Caption = "Найменування", Type = TypeFields.textBox
            });

            resFldTypeAddPayment.Add(new ResField {
                Name = "RefTypeAddPayment_Id"
            });
            resFldTypeAddPayment.Add(new ResField {
                Name = "RefTypeAddPayment_Cd", TxtBx = tbTypeCd, IsSearchByField = true
            });
            resFldTypeAddPayment.Add(new ResField {
                Name = "RefTypeAddPayment_Nm", TxtBx = tbTypeNm
            });

            cmbTypeAddPayment.AddCombobox(btnType, _typeAddPayments, vwFldTypeAddPayment, resFldTypeAddPayment, true, "RefTypeAddPayment_Id");

            InitCmbCalendar();


            tbFIO.NecessaryField(30);
            tbTypeNm.NecessaryField(30);
            tbSm.AddFloatField(10, 2);
        }
Exemple #13
0
        public fmRefOthAllwncEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            this.BaseFormStyle(caption);

            btnOk.Enabled = false;

            tbCd.NecessaryField();
            tbNm.NecessaryField();
            tbPct.NecessaryField();

            tbPct.AddFloatField(5, 2);
        }
        public fmRefPensAllwncEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            Text = caption;

            btnOk.Enabled = false;

            tbCd.NecessaryField();
            tbNm.NecessaryField();
            tbPct.NecessaryField();

            tbPct.AddFloatField(5, 2);
        }
        private void buttonNew_Click(object sender, EventArgs e)
        {
            if (mode == EnumFormMode.ViewMode)
            {
                mode = EnumFormMode.AddMode;

                buttonSave.Text           = "Save";
                buttonSave.Visible        = true;
                buttonCancel.Text         = "Cancel";
                dataGridViewVenue.Enabled = false;
                UtilityHelper.ClearTextbox(Controls);
                UtilityHelper.EnableControls(Controls);
            }
        }
Exemple #16
0
        public fmUSTCtEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            this.BaseFormStyle(caption);
            btnOk.Enabled = false;

            InitCmbCalendar();

            cmbCalendar.Enabled       = mode == EnumFormMode.Insert ? true : false;
            cmbCalendar.SelectedIndex = cmbCalendar.Items.Count - 1;

            tbNmr.NecessaryField();
            tbNm.NecessaryField();

            tbNmr.AddNumericField();
        }
Exemple #17
0
        public fmSickListEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            this.BaseFormStyle(caption);
            btnOk.Enabled = false;

            string error;

            _cards = _repoPersCard.GetAllCards(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка завантаження довідника особових карток.\nТехнічна інформація: " + error, "Помилка");
                return;
            }
            _cmbCardParams.persCards = _cards;
            _cmbCardParams.tbFio     = tbFIO;
            _cmbCardParams.tbTIN     = tbTIN;
            cmbCard.AddCombobox(btnCard, _cmbCardParams);

            _deps = _repoDep.GetAllDeps(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка завантаження довідника підрозділів.\nТехнічна інформація: " + error, "Помилка");
                return;
            }
            _cmbDepParams.refDeps = _deps;
            _cmbDepParams.tbCd    = tbDepCd;
            _cmbDepParams.tbNm    = tbDepNm;
            cmbDep.AddCombobox(btnDep, _cmbDepParams);

            InitCmbCalendar();
            InitCmbPayDate();

            tbDepCd.NecessaryField();
            tbDepNm.NecessaryField(30);

            tbFIO.NecessaryField(30);

            tbDaysEntprs.AddNumericField();
            tbSmEntprs.AddFloatField(10, 2);

            tbDaysSocInsrnc.AddNumericField();
            tbSmSocInsrnc.AddFloatField(10, 2);

            tbResSm.AddFloatField(10, 2);
        }
 private void buttonEdit_Click(object sender, EventArgs e)
 {
     if (_currentVenueIndex >= 0 &&
         mode == EnumFormMode.ViewMode)
     {
         bool editOk = (bool)_dtVenue.Rows[_currentVenueIndex]["EditTag"];
         if ((bool)_dtVenue.Rows[_currentVenueIndex]["EditTag"])
         {
             ClearImages();
             UtilityHelper.ClearTextbox(Controls);
             UtilityHelper.EnableControls(Controls);
             FillTabContent(_currentVenueIndex);
             dataGridViewVenue.Enabled = false;
             buttonSave.Visible        = true;
             buttonCancel.Text         = "Cancel";
             mode = EnumFormMode.EditMode;
         }
     }
 }
Exemple #19
0
        //=============================================================================================================================
        //
        //=============================================================================================================================
        public fmPersCardEdit(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            this.BaseFormStyle(caption);
            btnOk.Enabled = false;

            string error;

            refSpecExps = _repoSpecExp.GetAllSpecExps(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка отримання довідника спецстажів.\nТехнічна інформація: " + error, "Помилка");
                return;
            }

            InitGridChild();
            InitGridTaxRelief();
            InitGridCardStatus();
            InitGridDisability();
            InitGridCardSpecExp();

            tbLName.NecessaryField();
            tbFName.NecessaryField();
            tbDOB.NecessaryField();
            tbDOR.NecessaryField();
            tbTIN.NecessaryField();

            tbTIN.AddNumericField();
            tbExp.AddNumericField();
            tbGrade.AddNumericField();

            tbDOB.AddDateField('.');
            tbDOR.AddDateField('.');
            tbDOD.AddDateField('.');
            tbDOP.AddDateField('.');
        }
 public fmRefSpecExpEdit(EnumFormMode mode, string caption)
 {
     InitializeComponent();
     this.Text     = caption;
     btnOk.Enabled = false;
 }
        private void VenueForm_Load(object sender, EventArgs e)
        {
            #region create grid
            SAPEventReadWrite eventRW =
                new SAPEventReadWrite(Config._dbConnectionName);
            SAPVenueReadWrite venueRW =
                new SAPVenueReadWrite(Config._dbConnectionName);
            _dtVenue = new DataTable();
            //_dtVenue.Columns.Add("EditIco", typeof(byte[]));
            //_dtVenue.Columns.Add("DelIco", typeof(byte[]));
            _dtVenue.Columns.Add("VenueID", typeof(int));
            _dtVenue.Columns.Add("VenueName", typeof(string));
            _dtVenue.Columns.Add("VenueDescription", typeof(string));
            _dtVenue.Columns.Add("VenueStreet", typeof(string));
            _dtVenue.Columns.Add("VenueCity", typeof(string));
            _dtVenue.Columns.Add("VenueState", typeof(string));
            _dtVenue.Columns.Add("VenuePostalCode", typeof(string));
            _dtVenue.Columns.Add("VenueGeographicMap", typeof(byte[]));
            _dtVenue.Columns.Add("VenueFacilityMap", typeof(byte[]));
            _dtVenue.Columns.Add("VenueImage", typeof(byte[]));
            _dtVenue.Columns.Add("EditTag", typeof(bool));
            _dtVenue.Columns.Add("DelTag", typeof(bool));

            //byte[] editIco = UtilityHelper.BitmapToByte(Resources.icoedit);
            //byte[] delIco = UtilityHelper.BitmapToByte(Resources.icodelete);
            //byte[] editDisableIco = UtilityHelper.BitmapToByte(Resources.icoedit_disabled);
            //byte[] delDisableIco = UtilityHelper.BitmapToByte(Resources.icodelete_disabled);

            bool editAble = false;
            bool delAble  = false;

            List <int> usedVenue = new List <int>();
            using (SAPDataReaderEvent rdrEvent =
                       eventRW.ReaderSelectAll())
            {
                if (rdrEvent.DataReader != null &&
                    rdrEvent.DataReader.HasRows)
                {
                    while (rdrEvent.DataReader.Read())
                    {
                        usedVenue.Add(rdrEvent.VenueID);
                    } //while (rdrEvent.DataReader.Read());
                }
            }

            using (SAPDataReaderVenue rdrVenue =
                       venueRW.ReaderSelectAll())
            {
                if (rdrVenue.DataReader != null &&
                    rdrVenue.DataReader.HasRows)
                {
                    while (rdrVenue.DataReader.Read())
                    {
                        //byte[] editImage = editIco;
                        //byte[] delImage = delIco;


                        bool tag = usedVenue.Contains(rdrVenue.VenueID);
                        delAble  = !tag;
                        editAble = !tag;

                        _dtVenue.Rows.Add(
                            //editImage,
                            //delImage,
                            rdrVenue.VenueID,
                            rdrVenue.VenueName,
                            rdrVenue.VenueDescription,
                            rdrVenue.VenueStreet,
                            rdrVenue.VenueCity,
                            rdrVenue.VenueState,
                            rdrVenue.VenuePostalCode,
                            rdrVenue.VenueGeographicMap,
                            rdrVenue.VenueFacilityMap,
                            rdrVenue.VenueImage,
                            editAble,
                            delAble);
                    } //while (rdrVenue.DataReader.Read());
                }
            }

            dataGridViewVenue.DataSource = _dtVenue;
            #endregion

            #region utilize grid
            GridHelper.HideColumns(
                dataGridViewVenue,
                SAPVenueReadWrite._venueIDColumnName,
                SAPVenueReadWrite._venueDescriptionColumnName,
                SAPVenueReadWrite._venueGeographicMapColumnName,
                SAPVenueReadWrite._venueFacilityMapColumnName,
                SAPVenueReadWrite._venueImageColumnName,
                "EditTag",
                "DelTag");
            string[] columns = new string[]
            {
                //"EditIco",
                //"DelIco",
                SAPVenueReadWrite._venueNameColumnName,
                SAPVenueReadWrite._venueStreetColumnName,
                SAPVenueReadWrite._venueCityColumnName,
                SAPVenueReadWrite._venueStateColumnName,
                SAPVenueReadWrite._venuePostalCodeColumnName
            };
            string[] titles = new string[]
            {
                //"",
                //"",
                "Venue",
                "Street",
                "City",
                "State",
                "Postal Code"
            };
            int[] gridWidth = new int[]
            {
                //20,
                //20,
                200,
                100,
                100,
                100,
                100
            };
            GridHelper.SetColumnTitle(
                dataGridViewVenue,
                columns,
                titles);
            GridHelper.SetWidthColumn(
                dataGridViewVenue,
                columns,
                gridWidth);
            #endregion

            mode = EnumFormMode.ViewMode;
            UtilityHelper.SetToReadOnly(Controls);

            if (_isChildForm)
            {
                mode = EnumFormMode.CallbackAdd;
                buttonAddSave.Text        = "Save";
                buttonCancel.Text         = "Cancel";
                dataGridViewVenue.Enabled = false;
                UtilityHelper.ClearTextbox(Controls);
                UtilityHelper.EnableControls(Controls);
            }
        }
Exemple #22
0
 public fmVocationEdit(EnumFormMode mode, string caption)
 {
     InitializeComponent();
     Text = caption;
     //btnOk.Enabled = false;
 }
Exemple #23
0
 public fmRefSpecExpEdit(EnumFormMode mode, string caption)
 {
     InitializeComponent();
     this.BaseFormStyle(caption);
     btnOk.Enabled = false;
 }
        public fmSalaryAdd(EnumFormMode mode, string caption)
        {
            InitializeComponent();
            Text          = caption;
            btnOk.Enabled = false;

            string error;

            _cards = _repoPersCard.GetAllCards(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка оновлення таблиці.\nТехнічна інформація: " + error, "Помилка");
                return;
            }
            _cmbCardParams.persCards = _cards;
            _cmbCardParams.tbFio     = tbFIO;
            _cmbCardParams.tbTIN     = tbTIN;
            _cmbCardParams.tbExp     = tbExp;
            _cmbCardParams.tbGrade   = tbGrade;
            cmbCard.AddCombobox(btnCard, _cmbCardParams);

            _deps = _repoDep.GetAllDeps(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка оновлення таблиці.\nТехнічна інформація: " + error, "Помилка");
                return;
            }
            _cmbDepParams.refDeps = _deps;
            _cmbDepParams.tbCd    = tbDepCd;
            _cmbDepParams.tbNm    = tbDepNm;
            cmbDep.AddCombobox(btnDep, _cmbDepParams);
            //Надбавка пенсионерам
            _pensAllwncs = _repoPensAllwnc.GetAllPensAllwnc(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка оновлення таблиці.\nТехнічна інформація: " + error, "Помилка");
                return;
            }
            _pensAllwncs = _pensAllwncs.Where(
                rec => (rec.RefPensAllwnc_Flg & (int)EnumPensAllwnc_Flg.ALLWNC_NOTUSE) == 0)
                           .ToList();
            _cmbPensAllwncParams.tbCd        = tbPensCd;
            _cmbPensAllwncParams.tbNm        = tbPensNm;
            _cmbPensAllwncParams.tbPct       = tbPensPct;
            _cmbPensAllwncParams.pensAllwncs = _pensAllwncs;
            cmbPensAllwnc.AddCombobox(btnPens, _cmbPensAllwncParams);
            //Надбавка за классность
            _gradeAllwncs = _repoGradeAllwnc.GetAllGradeAllwnc(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка оновлення таблиці.\nТехнічна інформація: " + error, "Помилка");
                return;
            }
            _gradeAllwncs = _gradeAllwncs.Where(
                rec => (rec.RefGradeAllwnc_Flg & (int)EnumGradeAllwnc_Flg.ALLWNC_NOTUSE) == 0)
                            .ToList();
            _cmbGradeAllwncParams.tbCd         = tbGradeCd;
            _cmbGradeAllwncParams.tbNm         = tbGradeNm;
            _cmbGradeAllwncParams.tbPct        = tbGradePct;
            _cmbGradeAllwncParams.gradeAllwncs = _gradeAllwncs;
            cmbGradeAllwnc.AddCombobox(btnGrade, _cmbGradeAllwncParams);
            //Надбавка за стаж
            _expAllwncs = _repoExpAllwnc.GetAllExpAllwnc(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка оновлення таблиці.\nТехнічна інформація: " + error, "Помилка");
                return;
            }
            _expAllwncs = _expAllwncs.Where(
                rec => (rec.RefExpAllwnc_Flg & (int)EnumExpAllwnc_Flg.ALLWNC_NOTUSE) == 0)
                          .ToList();
            _cmbExpAllwncParams.tbCd       = tbExpCd;
            _cmbExpAllwncParams.tbNm       = tbExpNm;
            _cmbExpAllwncParams.tbPct      = tbExpPct;
            _cmbExpAllwncParams.expAllwncs = _expAllwncs;
            cmbExpAllwnc.AddCombobox(btnExp, _cmbExpAllwncParams);
            //Другие надбавки
            _othAllwncs = _repoOthAllwnc.GetAllOthAllwnc(out error);
            if (error != string.Empty)
            {
                MessageBox.Show("Помилка оновлення таблиці.\nТехнічна інформація: " + error, "Помилка");
                return;
            }
            _othAllwncs = _othAllwncs.Where(
                rec => (rec.RefOthAllwnc_Flg & (int)EnumOthAllwnc_Flg.ALLWNC_NOTUSE) == 0)
                          .ToList();
            _cmbOthAllwncParams.tbCd       = tbOthCd;
            _cmbOthAllwncParams.tbNm       = tbOthNm;
            _cmbOthAllwncParams.tbPct      = tbOthPct;
            _cmbOthAllwncParams.othAllwncs = _othAllwncs;
            cmbOthAllwnc.AddCombobox(btnOth, _cmbOthAllwncParams);

            InitCmbCalendar();

            tbDepCd.NecessaryField();
            tbDepNm.NecessaryField();
            tbDays.NecessaryField();
            tbHours.NecessaryField();
            tbFIO.NecessaryField();
            tbBaseSm.NecessaryField();

            tbBaseSm.AddFloatField(10, 2);

            tbPensSm.AddFloatField(10, 2);
            tbExpSm.AddFloatField(10, 2);
            tbGradeSm.AddFloatField(10, 2);
            tbOthSm.AddFloatField(10, 2);

            tbKTU.AddFloatField(5, 2);
            tbGrade.AddNumericField();
            tbKTUSm.AddFloatField(10, 2);
            tbDays.AddNumericField();
            tbHours.AddFloatField(5, 2);
        }
        private void buttonSave_Click(object sender, EventArgs e)
        {
            if (!IsValid())
            {
                return;
            }

            SAPVenueReadWrite venueRW =
                new SAPVenueReadWrite(Config._dbConnectionName);

            if (mode == EnumFormMode.EditMode)
            {
                #region modify record
                _locationMapImage = FileToByte(_fileLocationMapImage, _locationMapImage);
                _facilityImage    = FileToByte(_fileFacilityImage, _facilityImage);
                _venueImage       = FileToByte(_fileVenueImage, _venueImage);
                venueRW.Update(
                    _venueID,
                    textBoxName.Text.Trim(),
                    textBoxDescription.Text.Trim(),
                    textBoxStreet.Text.Trim(),
                    textBoxCity.Text.Trim(),
                    textBoxState.Text.Trim(),
                    textBoxPostalCode.Text.Trim(),
                    _locationMapImage,
                    _facilityImage,
                    _venueImage);
                _dtVenue.Rows[_rowIndex][SAPVenueReadWrite._venueNameColumnName] =
                    textBoxName.Text.Trim();
                _dtVenue.Rows[_rowIndex][SAPVenueReadWrite._venueDescriptionColumnName] =
                    textBoxDescription.Text.Trim();
                _dtVenue.Rows[_rowIndex][SAPVenueReadWrite._venueStreetColumnName] =
                    textBoxStreet.Text.Trim();
                _dtVenue.Rows[_rowIndex][SAPVenueReadWrite._venueCityColumnName] =
                    textBoxCity.Text.Trim();
                _dtVenue.Rows[_rowIndex][SAPVenueReadWrite._venueStateColumnName] =
                    textBoxState.Text.Trim();
                _dtVenue.Rows[_rowIndex][SAPVenueReadWrite._venuePostalCodeColumnName] =
                    textBoxPostalCode.Text.Trim();
                _dtVenue.Rows[_rowIndex][SAPVenueReadWrite._venueGeographicMapColumnName] =
                    _locationMapImage;
                _dtVenue.Rows[_rowIndex][SAPVenueReadWrite._venueImageColumnName] =
                    _facilityImage;
                _dtVenue.Rows[_rowIndex][SAPVenueReadWrite._venueFacilityMapColumnName] =
                    _venueImage;
                #endregion
            }
            else
            {
                #region insert record
                _locationMapImage = FileToByte(_fileLocationMapImage, null);
                _facilityImage    = FileToByte(_fileFacilityImage, null);
                _venueImage       = FileToByte(_fileVenueImage, null);
                venueRW.Insert(
                    textBoxName.Text.Trim(),
                    textBoxDescription.Text.Trim(),
                    textBoxStreet.Text.Trim(),
                    textBoxCity.Text.Trim(),
                    textBoxState.Text.Trim(),
                    textBoxPostalCode.Text.Trim(),
                    _locationMapImage,
                    _facilityImage,
                    _venueImage,
                    out _venueID);

                if (mode == EnumFormMode.CallbackAdd)
                {
                    _venueName   = textBoxName.Text.Trim();
                    DialogResult = DialogResult.OK;
                    Close();
                    return;
                }
                else
                {
                    //byte[] editIco = UtilityHelper.BitmapToByte(Resources.icoedit);
                    //byte[] delIco = UtilityHelper.BitmapToByte(Resources.icodelete);

                    _dtVenue.Rows.Add(
                        //editIco,
                        //delIco,
                        _venueID,
                        textBoxName.Text.Trim(),
                        textBoxDescription.Text.Trim(),
                        textBoxStreet.Text.Trim(),
                        textBoxCity.Text.Trim(),
                        textBoxState.Text.Trim(),
                        textBoxPostalCode.Text.Trim(),
                        _locationMapImage,
                        _facilityImage,
                        _venueImage,
                        true,
                        true);
                }
                #endregion
            }
            mode = EnumFormMode.ViewMode;
            dataGridViewVenue.Enabled = true;
            buttonCancel.Text         = "Close";
            buttonAddSave.Text        = "Add";
            UtilityHelper.SetToReadOnly(Controls);
        }