private void dataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (dataGridView.Columns[e.ColumnIndex].Name == "lnkDeleteRecord")
            {
                if (MessageBox.Show("Do you want to Delete This Record", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    int rowIndex = Convert.ToInt32(e.RowIndex); // Get the current row
                    int id       = Convert.ToInt32(dataGridView.Rows[rowIndex].Cells[1].Value);
                    odeals.DeleteRecord(id);
                    MessageBox.Show("Deleted");
                }
                dataGridView.DataSource = odeals.ShowAllRecords();
            }

            if (dataGridView.Columns[e.ColumnIndex].Name == "lnkViewRecord")
            {
                int       rowIndex       = Convert.ToInt32(e.RowIndex); // Get the current row
                int       id             = Convert.ToInt32(dataGridView.Rows[rowIndex].Cells[1].Value);
                DataTable selectedRecord = odeals.ShowAllRecords(id);
                edeals.SellerName     = selectedRecord.Rows[0][1].ToString();
                edeals.SellerSO       = selectedRecord.Rows[0][2].ToString();
                edeals.SellerRO       = selectedRecord.Rows[0][3].ToString();
                edeals.PurchaserName  = selectedRecord.Rows[0][4].ToString();
                edeals.PurchaserSO    = selectedRecord.Rows[0][5].ToString();
                edeals.PurchaserRO    = selectedRecord.Rows[0][6].ToString();
                edeals.PlotHouseNo    = selectedRecord.Rows[0][7].ToString();
                edeals.Phase          = selectedRecord.Rows[0][8].ToString();
                edeals.StreetNo       = selectedRecord.Rows[0][9].ToString();
                edeals.RegistrationNo = selectedRecord.Rows[0][10].ToString();
                edeals.Catagory       = selectedRecord.Rows[0][11].ToString();
                edeals.Size           = selectedRecord.Rows[0][12].ToString();
                edeals.TotalAmount    = selectedRecord.Rows[0][13].ToString();
                edeals.Biana          = selectedRecord.Rows[0][14].ToString();
                edeals.BalanceAmount  = selectedRecord.Rows[0][15].ToString();
                edeals.OnOrBefore     = selectedRecord.Rows[0][16].ToString();
                edeals.SellerCnic     = selectedRecord.Rows[0][17].ToString();
                edeals.PurchaserCnic  = selectedRecord.Rows[0][18].ToString();
                edeals.WitnessOneName = selectedRecord.Rows[0][19].ToString();
                edeals.WitnessOneCnic = selectedRecord.Rows[0][20].ToString();
                edeals.WitnessTwoName = selectedRecord.Rows[0][21].ToString();
                edeals.WitnessTwoCnic = selectedRecord.Rows[0][22].ToString();
                try
                {
                    using (PrintForm frm = new PrintForm(edeals))
                    {
                        frm.ShowDialog();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
Beispiel #2
0
        private void btnInsert_Click(object sender, EventArgs e)
        {
            edeals.Date           = System.DateTime.Now.ToString("dd/MM/yyyy");
            edeals.BalanceAmount  = txtBalanceAmount.Text;
            edeals.Biana          = txtBiana.Text;
            edeals.Catagory       = txtCatagory.Text;
            edeals.OnOrBefore     = txtOnOrBefore.Text;
            edeals.Phase          = txtPhase.Text;
            edeals.PlotHouseNo    = txtPlotHouseNo.Text;
            edeals.PurchaserCnic  = txtPurchaserCNIC.Text;
            edeals.PurchaserName  = txtPurchaserName.Text;
            edeals.PurchaserRO    = txtPurchaserRO.Text;
            edeals.PurchaserSO    = txtPurchaserSO.Text;
            edeals.RegistrationNo = txtRegistrationNo.Text;
            edeals.SellerCnic     = txtSellerCNIC.Text;
            edeals.SellerName     = txtSellerName.Text;
            edeals.SellerRO       = txtSellerRO.Text;
            edeals.SellerSO       = txtSellerSonOf.Text;
            edeals.Size           = txtSize.Text;
            edeals.StreetNo       = txtStreetNo.Text;
            edeals.TotalAmount    = txtTotalAmount.Text;
            if (!string.IsNullOrWhiteSpace(txtWitnessOneCNIC.Text) && !string.IsNullOrWhiteSpace(txtWitnessOneName.Text) && !string.IsNullOrWhiteSpace(txtWitnessTwoCnic.Text) && !string.IsNullOrWhiteSpace(txtWitnessTwoName.Text))
            {
                edeals.WitnessOneCnic = txtWitnessOneCNIC.Text;
                edeals.WitnessOneName = txtWitnessOneName.Text;
                edeals.WitnessTwoCnic = txtWitnessTwoCnic.Text;
                edeals.WitnessTwoName = txtWitnessTwoName.Text;
            }
            else
            {
                edeals.WitnessOneCnic = "_______________";
                edeals.WitnessOneName = "_______________";
                edeals.WitnessTwoCnic = "_______________";
                edeals.WitnessTwoName = "_______________";
            }

            try
            {
                if (!string.IsNullOrWhiteSpace(txtBalanceAmount.Text) && !string.IsNullOrWhiteSpace(txtBiana.Text) && !string.IsNullOrWhiteSpace(txtCatagory.Text) && !string.IsNullOrWhiteSpace(txtOnOrBefore.Text) && !string.IsNullOrWhiteSpace(txtPhase.Text) && !string.IsNullOrWhiteSpace(txtPlotHouseNo.Text) && !string.IsNullOrWhiteSpace(txtPurchaserCNIC.Text) && !string.IsNullOrWhiteSpace(txtPurchaserName.Text) && !string.IsNullOrWhiteSpace(txtPurchaserRO.Text) && !string.IsNullOrWhiteSpace(txtPurchaserSO.Text) && !string.IsNullOrWhiteSpace(txtRegistrationNo.Text) && !string.IsNullOrWhiteSpace(txtSellerCNIC.Text) && !string.IsNullOrWhiteSpace(txtSellerName.Text) && !string.IsNullOrWhiteSpace(txtSellerRO.Text) && !string.IsNullOrWhiteSpace(txtSellerSonOf.Text) && !string.IsNullOrWhiteSpace(txtSize.Text) && !string.IsNullOrWhiteSpace(txtStreetNo.Text) && !string.IsNullOrWhiteSpace(txtTotalAmount.Text))
                {
                    if (MessageBox.Show("Do you want to Save This in Record", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        odeals.Insert(edeals);
                        MessageBox.Show("Record Saved Sucessfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    try
                    {
                        using (PrintForm frm = new PrintForm(edeals))
                        {
                            frm.ShowDialog();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    Clear();
                }
                else
                {
                    MessageBox.Show("Please Fill Out The Information", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }