public void Reload()
        {
            try
            {
                AlternateMissionsBO aAlternateMissionsBO = new AlternateMissionsBO();
                dgvAlternateMissions.DataSource = aAlternateMissionsBO.SelectDetail_All();
                dgvAlternateMissions.RefreshDataSource();
            }
            catch (Exception ex)
            {
                MessageBox.Show("frmLst_AlternateMissions.Reload\n" + ex.ToString(), "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }
        }
        private void btnAddNew_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.ValidateData() == true)
                {
                    DateTime? NullDateTime = null;
                    AlternateMissionsBO aAlternateMissionsBO = new AlternateMissionsBO();
                    AlternateMissions aAlternateMissions = new AlternateMissions();
                    aAlternateMissions.ID = ID_Old;

                    aAlternateMissions.IDSystemUser = lueIDSystemUser.EditValue ==null ? 0 : Convert.ToInt32(lueIDSystemUser.EditValue);
                    aAlternateMissions.NumberDecision = String.IsNullOrEmpty(txtNumberDecision.Text) == true ? String.Empty : txtNumberDecision.Text;
                    aAlternateMissions.Subject = String.IsNullOrEmpty(txtSubject.Text) == true ? String.Empty : txtSubject.Text;
                    aAlternateMissions.DecisionLevel = String.IsNullOrEmpty(txtDecisionLevel.Text) == true ? String.Empty : txtDecisionLevel.Text;
                    aAlternateMissions.Description = String.IsNullOrEmpty(txtDescription.Text) == true ? String.Empty : txtDescription.Text;

                    aAlternateMissions.ToDate = dtpToDate.EditValue == null ? NullDateTime : dtpToDate.DateTime;
                    aAlternateMissions.FromDate = dtpFromDate.EditValue == null ? NullDateTime : dtpFromDate.DateTime;
                    aAlternateMissions.CreatedDate = dtpCreatedDate.EditValue == null ? NullDateTime : dtpCreatedDate.DateTime;
                    aAlternateMissions.DecisionDate = dtpDecisionDate.EditValue == null ? NullDateTime : dtpDecisionDate.DateTime;

                    aAlternateMissions.Country = lueCountry.EditValue == null ? String.Empty : Convert.ToString(lueCountry.EditValue);
                    aAlternateMissions.Disable =String.IsNullOrEmpty(cbbDisable.Text) == true ? false : Convert.ToBoolean(cbbDisable.Text);
                    aAlternateMissions.Type =String.IsNullOrEmpty(cbbType.Text) == true ? 0: Convert.ToInt32(cbbType.Text);
                    aAlternateMissions.Status =String.IsNullOrEmpty(cbbStatus.Text) == true ? 0: Convert.ToInt32(cbbStatus.Text);

                    int count = aAlternateMissionsBO.Update(aAlternateMissions);
                    if(count > 0)
                    {
                        MessageBox.Show("Sửa thành công !", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    this.Close();

                    if(this.afrmLst_AlternateMissions_Old !=null)
                    {
                        this.afrmLst_AlternateMissions_Old.Reload();
                    }

                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("frmUpd_AlternateMissions.btnEdit_Click\n" + ex.ToString(), "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }
        }
        private void btnDelete_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            try
            {
                int ID = int.Parse(grvAlternateMissions.GetFocusedRowCellValue("ID").ToString());
                DialogResult result = MessageBox.Show("Bạn có muốn xóa AlternateMissions " + ID + " này không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (result == DialogResult.Yes)
                {
                    AlternateMissionsBO aAlternateMissionsBO = new AlternateMissionsBO();
                    int count = aAlternateMissionsBO.Delete(ID);
                    if (count > 0)
                    {
                        MessageBox.Show("Xóa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.Reload();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("frmLst_AlternateMissions.btnDelete_ButtonClick\n" + ex.ToString(), "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }
        }
        private void frmUpd_AlternateMissions_Load(object sender, EventArgs e)
        {
            try
            {
                AlternateMissionsBO aAlternateMissionsBO = new AlternateMissionsBO();
                AlternateMissions aAlternateMissions = aAlternateMissionsBO.Select_ByID(ID_Old);
                if(aAlternateMissions !=null)
                {
                    SystemUsersBO aSystemUsersBO = new SystemUsersBO();
                    lueIDSystemUser.Properties.DataSource = aSystemUsersBO.Select_All();
                    lueIDSystemUser.Properties.DisplayMember = "Name";
                    lueIDSystemUser.Properties.ValueMember = "ID";

                    lueIDSystemUser.EditValue = aAlternateMissions.IDSystemUser;

                    lueCountry.Properties.DataSource = CORE.CONSTANTS.ListCountries;
                    lueCountry.Properties.DisplayMember = "Name";
                    lueCountry.Properties.ValueMember = "Code";

                    lueCountry.EditValue = CORE.CONSTANTS.SelectedCountry(aAlternateMissions.Country).Code;

                    if (aAlternateMissions.CreatedDate != null)
                    {
                        dtpCreatedDate.DateTime = aAlternateMissions.CreatedDate.GetValueOrDefault();
                    }
                    if (aAlternateMissions.DecisionDate != null)
                    {
                        dtpDecisionDate.DateTime = aAlternateMissions.DecisionDate.GetValueOrDefault();
                    }
                    if (aAlternateMissions.FromDate != null)
                    {
                        dtpFromDate.DateTime = aAlternateMissions.FromDate.GetValueOrDefault();
                    }
                    if (aAlternateMissions.ToDate != null)
                    {
                        dtpToDate.DateTime = aAlternateMissions.ToDate.GetValueOrDefault();
                    }

                    txtDecisionLevel.Text = aAlternateMissions.DecisionLevel;
                    txtDescription.Text = aAlternateMissions.Description;
                    txtNumberDecision.Text = aAlternateMissions.NumberDecision;
                    txtSubject.Text = aAlternateMissions.Subject;

                    cbbDisable.Text = Convert.ToString(aAlternateMissions.Disable);
                    cbbStatus.Text = Convert.ToString(aAlternateMissions.Status);
                    cbbType.Text = Convert.ToString(aAlternateMissions.Type);
                    lblID.Text = Convert.ToString(this.ID_Old);
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show("frmUpd_AlternateMissions_Load\n" + ex.ToString(), "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }
        }