示例#1
0
        private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (DGvTransPay.FocusedRowHandle < 0)
            {
                return;
            }
            int iPayId = Convert.ToInt32(DGvTransPay.GetRowCellValue(DGvTransPay.FocusedRowHandle, "TypeId").ToString());

            if (PaymentScheduleBL.CheckPaymentScheduleUsed(iPayId) == true)
            {
                MessageBox.Show("Payment Schedule Used, Do not Delete");
                return;
            }

            DialogResult result1 = MessageBox.Show("Do you want to Delete", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (result1 == DialogResult.Yes)
            {
                string     sql = String.Format("DELETE FROM PaySchType WHERE TypeId={0}", DGvTransPay.GetFocusedRowCellValue("TypeId"));
                SqlCommand cmd = new SqlCommand(sql, BsfGlobal.OpenCRMDB());
                cmd.ExecuteNonQuery();
                cmd.Dispose();
                BsfGlobal.g_CRMDB.Close();
                DGvTransPay.DeleteRow(DGvTransPay.FocusedRowHandle);
            }
        }
示例#2
0
        public void FillData()
        {
            dt = new DataTable();

            DGVPay.DataSource = null;
            DGvTransPay.Columns.Clear();

            dt = UnitDirBL.PaySchType();
            DGVPay.DataSource = dt;
            DGvTransPay.PopulateColumns();
            DGvTransPay.Columns["TypeId"].Visible     = false;
            DGvTransPay.Columns["EMI"].Visible        = false;
            DGvTransPay.Columns["RoundValue"].Visible = false;
            DGvTransPay.Columns["NoOfMonths"].Visible = false;
            dt.GetChanges();
        }