Ejemplo n.º 1
0
 public void getSupplierID()
 {
     BLSupplier objSupplierDetails = new BLSupplier();
     DataTable dt = objSupplierDetails.getSupplierID();
     for (int i = 0; i < dt.Rows.Count; i++)
     {
         for (int j = 0; j < dt.Columns.Count; j++)
         {
             if (string.IsNullOrEmpty(dt.Rows[i][j].ToString()))
             {
                 // int a = 1;
                 //txttransationId.Text = Convert.ToString(a);
             }
             else
             {
                 //txttransationId.Text = dt.Rows[0][0].ToString();
             }
         }
     }
 }
Ejemplo n.º 2
0
        private void Usp_BindSupplierGrid()
        {
            try
            {
                DataTable dt = null;
                BLSupplier objBL = new BLSupplier();
                dt = objBL.BindFullGrid();
                if (dt.Rows.Count > 0)
                {

                    dgvSupplier.DataSource = dt;

                }
                else
                {
                    dgvSupplier.DataSource = null;

                }
                dgvSupplier.Refresh();
                dgvSupplier.Show();
                {
                    dgvSupplier.DataSource = dt;
                    dgvSupplier.Columns[0].HeaderCell.Value = "SupplierID";
                    dgvSupplier.Columns[0].Visible = false;
                    dgvSupplier.Columns[1].HeaderCell.Value = "Supplier Company";
                    dgvSupplier.Columns[2].HeaderCell.Value = "Supplier Name";
                    dgvSupplier.Columns[3].HeaderCell.Value = "Contact Number";
                    dgvSupplier.Columns[4].HeaderCell.Value = "Country";
                    dgvSupplier.Columns[5].HeaderCell.Value = "State";
                    dgvSupplier.Columns[6].HeaderCell.Value = "City";
                    dgvSupplier.Columns[7].HeaderCell.Value = "Area";
                    dgvSupplier.Columns[8].HeaderCell.Value = "Address";
                    dgvSupplier.Columns[9].HeaderCell.Value = "Mode of Transport";
                    dgvSupplier.Columns[10].HeaderCell.Value = "Price Type";
                    //dgvSupplier.Columns[10].HeaderCell.Value = "opening Balance";
                    dgvSupplier.Columns[11].HeaderCell.Value = "IsActive";
                    dgvSupplier.Columns[11].Visible = false;
                    dgvSupplier.Columns[12].HeaderCell.Value = "IsDelete";
                    dgvSupplier.Columns[12].Visible = false;
                    dgvSupplier.AllowUserToAddRows = false;
                    dgvSupplier.AllowUserToDeleteRows = false;
                    dgvSupplier.Refresh();
                    dgvSupplier.Show();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }
Ejemplo n.º 3
0
        /*rajesh
         * created date :- 07/08/2015
         * purpose :- all kaydown Events
         */
        ////#region------------------------------------------------------All KeyDown Events for supplier-----------------------------------------
        ////        private void txtCompanyName_KeyDown(object sender, KeyEventArgs e)
        ////        {
        ////            if (e.KeyData == Keys.Enter)
        ////            {
        ////                txtTermsofPayment.Select();
        ////            }
        ////        }
        ////        private void txtTermsofPayment_KeyDown(object sender, KeyEventArgs e)
        ////        {
        ////            if (e.KeyData == Keys.Enter)
        ////            {
        ////                cbState.Select();
        ////            }
        ////        }
        ////        private void cbProduct_KeyDown(object sender, KeyEventArgs e)
        ////        {
        ////            if (e.KeyData == Keys.Enter)
        ////            {
        ////                dtpDate.Select();
        ////            }
        ////        }
        ////        private void dtpDate_KeyDown(object sender, KeyEventArgs e)
        ////        {
        ////            if (e.KeyData == Keys.Enter)
        ////            {
        ////                cbModeofTransport.Select();
        ////            }
        ////        }
        ////        private void cbModeofTransport_KeyDown(object sender, KeyEventArgs e)
        ////        {
        ////            if (e.KeyData == Keys.Enter)
        ////            {
        ////                txtAddress.Select();
        ////            }
        ////        }
        ////        private void txtAddress_KeyDown(object sender, KeyEventArgs e)
        ////        {
        ////            if (e.KeyData == Keys.Enter)
        ////            {
        ////                cbActive.Select();
        ////            }
        ////        }
        ////        private void cbActive_KeyDown(object sender, KeyEventArgs e)
        ////        {
        ////            if (e.KeyData == Keys.Enter)
        ////            {
        ////                btnSave.Select();
        ////            }
        ////        }
        ////        private void btnSave_KeyDown(object sender, KeyEventArgs e)
        ////        {
        ////            if (e.KeyData == Keys.Enter)
        ////            {
        ////                btnDelete.Select();
        ////            }
        ////        }
        ////        //private void btnAddNew_KeyDown(object sender, KeyEventArgs e)
        ////        //{
        ////        //    if (e.KeyData == Keys.Enter)
        ////        //    {
        ////        //        btnDelete.Select();
        ////        //    }
        ////        //}
        ////        private void btnDelete_KeyDown(object sender, KeyEventArgs e)
        ////        {
        ////            if (e.KeyData == Keys.Enter)
        ////            {
        ////                btnClose.Select();
        ////            }
        ////        }
        ////#endregion
        private void dgvSupplier_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            try
            {

                if (dgvSupplier.SelectedRows.Count > 0)
                {
                    lblHideID.Text = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[0].Value);
                    txtSupplierCompany.Text = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[1].Value);
                    string SupplierCompany = txtSupplierCompany.Text;
                    BLSupplier objSupplier = new BLSupplier();
                    DataTable dt = objSupplier.GetID(SupplierCompany);
                    if (dt.Rows.Count != 0)
                    {
                        lblid.Text = dt.Rows[0]["SupplierID"].ToString();
                    }
                    txtSuplierName.Text = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[2].Value);
                    txtContactNumber.Text = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[3].Value);
                    cbCountry.Text = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[4].Value);
                    cbState.Text = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[5].Value);
                    cbCity.Text = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[6].Value);
                    txtArea.Text = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[7].Value);
                    txtAddress.Text = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[8].Value);
                    cbModeofTransport.Text = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[9].Value);
                    txtOpeningBalance.Text = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[13].Value);
                    txtOpeningBalance.ReadOnly = true;
                    string Type = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[10].Value);
                    if (Type == "CIF")
                    {
                        rdoCIF.Checked = true;
                    }
                    else
                        rdoFOB.Checked = true;
                    string Active = Convert.ToString(dgvSupplier.SelectedRows[0].Cells[11].Value);
                    if (Active == "Yes")
                    {
                        cbActive.Checked = true;
                    }
                    else
                    {
                        cbActive.Checked = false;
                    }
                    btnSave.Text = "Update";
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }