示例#1
0
        private void usr_grd_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.ColumnIndex == usr_grd.Columns["editBtn"].Index && e.RowIndex >= 0)
            {
                //MessageBox.Show("Edit ID : "+usr_grd.Rows[e.RowIndex].Cells["ID"].Value.ToString());LedgerId
                sup_id   = Convert.ToInt32(usr_grd.Rows[e.RowIndex].Cells["ID"].Value.ToString());
                LedgerId = Convert.ToInt32(usr_grd.Rows[e.RowIndex].Cells["colLEDGERID"].Value.ToString());
                Edit_supplier edt = new Edit_supplier();
                edt.ShowDialog();
                bind_data();
            }
            if (e.ColumnIndex == usr_grd.Columns["btnDelete"].Index && e.RowIndex >= 0)
            {
                // MessageBox.Show("Deleted ID : "+usr_grd.Rows[e.RowIndex].Cells["ID"].Value.ToString());
                sup_id   = Convert.ToInt32(usr_grd.Rows[e.RowIndex].Cells["ID"].Value.ToString());
                LedgerId = Convert.ToInt32(usr_grd.Rows[e.RowIndex].Cells["colLEDGERID"].Value.ToString());

                DialogResult dialogResult = MessageBox.Show("Sure, You want to delete Customer", "Delete Customer", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (dialogResult == DialogResult.Yes)
                {
                    try
                    {
                        impfunc._Command            = new SqlCommand();
                        impfunc._Command.Connection = impfunc.cnn;
                        impfunc.cnn.Open();
                        impfunc._TR = impfunc.cnn.BeginTransaction(IsolationLevel.ReadCommitted);
                        impfunc._Command.Transaction = impfunc._TR;

                        impfunc.DELETE_RECORDS(impfunc.cnn, "SUPPLIER_MASTER", impfunc._TR, "ID", sup_id);
                        impfunc.DELETE_RECORDS(impfunc.cnn, "LEDGER", impfunc._TR, "LedgerId", LedgerId);
                        impfunc.DELETE_RECORDS(impfunc.cnn, "JOURNAL", impfunc._TR, "LedgerId", LedgerId);
                        impfunc._TR.Commit();
                        impfunc.cnn.Close();
                        bind_data();
                    }
                    catch (Exception ex)
                    {
                        impfunc._TR.Rollback();
                        impfunc.cnn.Close();
                        MessageBox.Show(("ERROR: " + (ex.Message + ("\r\n" + "PLEASE CONTACT Mr. Amit Tiwari"))));
                    }
                    finally
                    {
                        impfunc.cnn.Close();
                    }
                }
                else if (dialogResult == DialogResult.No)
                {
                    return;
                }
            }
            if (e.ColumnIndex == usr_grd.Columns["btnAccount"].Index && e.RowIndex >= 0)
            {
                // MessageBox.Show("Deleted ID : "+usr_grd.Rows[e.RowIndex].Cells["ID"].Value.ToString());
                sup_id = Convert.ToInt32(usr_grd.Rows[e.RowIndex].Cells["ID"].Value.ToString());
                view_supplier edt = new view_supplier();
                edt.ShowDialog();
                bind_data();
            }
        }
示例#2
0
        private void srch_btn_Click(object sender, EventArgs e)
        {
            this.Close();
            Edit_supplier edt = new Edit_supplier();

            edt.ShowDialog();
        }