private void chkActBat_CheckedChanged(object sender, EventArgs e) { if (chkActBat.Checked) { cmbBattalion.Enabled = true; if (code == "B") { DataTable dt = ClassQuotation.sp_fillBattQout((int)cmbBrigade.SelectedValue); cmbBattalion.DataSource = dt; cmbBattalion.DisplayMember = "Battalions_name"; cmbBattalion.ValueMember = "Battalions_id"; } if (code == "R") { DataTable dt = ClassRegiments.sp_FillSecondLRegQ((int)cmbBrigade.SelectedValue); cmbBattalion.DataSource = dt; cmbBattalion.DisplayMember = "Name"; cmbBattalion.ValueMember = "ID"; } } else { cmbBattalion.Enabled = false; } }
void fillcombo() { DataTable dt = ClassRegiments.sp_allRegiment(); cmbRegiment.DataSource = dt; cmbRegiment.ValueMember = "ID"; cmbRegiment.DisplayMember = "Name"; }
private void btnSave_Click(object sender, EventArgs e) { if (txtNameR.Text.Equals("")) { MessageBox.Show("Please Fill Fields"); } else { int i = ClassRegiments.sp_addnewRegiment(txtNameR.Text, rtxtDesc.Text); MessageBox.Show("Done"); txtNameR.Text = rtxtDesc.Text = ""; } }
private void BtnSave_Click(object sender, EventArgs e) { if (txtName.Text.Equals("")) { MessageBox.Show("Please Fill Fields."); } else { int i = ClassRegiments.sp_newSarayaR(txtName.Text, rtxtDescrip.Text, (int)cmbRegiment.SelectedValue); MessageBox.Show("Done"); txtName.Text = rtxtDescrip.Text = ""; } }
private void btnDelete_Click(object sender, EventArgs e) { if (txtid.Text.Equals("")) { MessageBox.Show("Select One Please."); } else { int i = ClassRegiments.sp_deleteSarayaR(int.Parse(txtid.Text)); MessageBox.Show("Done"); txtid.Text = txtname.Text = txtRegName.Text = rtxtDescrip.Text = ""; display(); } }
private void btnUpdate_Click(object sender, EventArgs e) { if (txtid.Text.Equals("") || txtname.Text.Equals("")) { MessageBox.Show("Please Select one."); } else { int i = ClassRegiments.sp_updateRegiment(int.Parse(txtid.Text), txtname.Text, rtxtDescrip.Text); MessageBox.Show("Done"); txtid.Text = txtname.Text = rtxtDescrip.Text = ""; display(); } }
private void txtSearch_TextChanged(object sender, EventArgs e) { dgvSaraya.DataSource = ClassRegiments.sp_SearchSarayaR(txtSearch.Text); }
void display() { dgvSaraya.DataSource = ClassRegiments.sp_allSarayaR(); }
private void txtSearch_TextChanged(object sender, EventArgs e) { dgvRegiment.DataSource = ClassRegiments.sp_searchRegiment(txtSearch.Text); }
void display() { dgvRegiment.DataSource = ClassRegiments.sp_allRegiment(); }