示例#1
0
 private void BtnAdd_Click(object sender, EventArgs e)
 {
     try
     {
         using (SqlConnection sqlCon = new SqlConnection(conStr))
         {
             int    seat = int.Parse(txtTotalSeat.Text);
             string sql  = "Insert into [Bus] values('" +
                           txtBusNo.Text + "', " +
                           cmbBusType.SelectedValue + ", " +
                           seat + ", " +
                           seat + ")";
             SqlCommand cmd = new SqlCommand(sql, sqlCon);
             sqlCon.Open();
             if (cmd.ExecuteNonQuery() > 0)
             {
                 sqlCon.Close(); //closing connection for unintendent error
                 AsignCounterForm asignCounter = new AsignCounterForm(txtBusNo.Text, this);
                 asignCounter.ShowDialog(this);
             }
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
示例#2
0
 private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
 {
     if (e.ColumnIndex == dataGridView1.Columns["btnDel"].Index)
     {
         Bus bus = new Bus();
         if (MessageBox.Show("Are you sure about deleting this Bus?", "Warning!", MessageBoxButtons.YesNo) == DialogResult.Yes)
         {
             bus.DelBus(dataGridView1.CurrentRow.Cells["no"].Value.ToString());
         }
         RefreshGrid();
     }
     else if (e.ColumnIndex == dataGridView1.Columns["btnReasign"].Index)
     {
         AsignCounterForm asignCounter = new AsignCounterForm(dataGridView1.CurrentRow.Cells["no"].Value.ToString());
         asignCounter.ShowDialog(this);
     }
 }
示例#3
0
        private void AddCounterToolStripMenuItem_Click(object sender, EventArgs e)
        {
            AsignCounterForm asignCounter = new AsignCounterForm(dataGridView1.CurrentRow.Cells["no"].Value.ToString());

            asignCounter.ShowDialog(this);
        }