private void cmbBrigade_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = ClassBrigade.sp_fillBattalion(cmbBrigade.Text);
cmbBattalion.DataSource = dt;
cmbBattalion.DisplayMember = "Battalions_name";
cmbBattalion.ValueMember = "Battalions_id";
}
void fillBriComb()
{
//Brigade..
DataTable dt = ClassBrigade.allBrigade();
cmbBrigade.DataSource = dt;
cmbBrigade.DisplayMember = "Name";
cmbBrigade.ValueMember = "ID";
}
void fillcmb()
{
DataTable dt = ClassBrigade.fillBrigade();
for (int i = 0; i < dt.Rows.Count; i++)
{
cmbBrigade.Items.Add(dt.Rows[i][1].ToString());
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtNameB.Text.Equals(""))
{
MessageBox.Show("Please Write Brigade Name");
}
else
{
int i = ClassBrigade.AddNewBrigade(txtNameB.Text, rtxtDesc.Text);
MessageBox.Show("Done");
txtNameB.Text = rtxtDesc.Text = "";
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
if (txtID.Text.Equals("") || txtName.Text.Equals(""))
{
MessageBox.Show("Please Fill Fields");
}
else
{
int i = ClassBrigade.AddNewBattlion(int.Parse(txtID.Text), txtName.Text, rtxtDescrip.Text);
txtName.Text = rtxtDescrip.Text = "";
MessageBox.Show("Done");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtname.Text.Equals("") || cmbBrigade.Text.Equals("") || cmbBattalion.Text.Equals(""))
{
MessageBox.Show("Fill Fields Please.");
}
else
{
int i = ClassBrigade.sp_addsaraya(txtname.Text, rtxtDescrip.Text, (int)cmbBrigade.SelectedValue, (int)cmbBattalion.SelectedValue);
MessageBox.Show("Done");
txtname.Text = rtxtDescrip.Text = "";
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtid.Text.Equals(""))
{
MessageBox.Show("Please Select One.");
}
else
{
int i = ClassBrigade.DeleteBrigade(int.Parse(txtid.Text));
MessageBox.Show("Done");
txtid.Text = txtname.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 = ClassBrigade.UpdateBrigade(int.Parse(txtid.Text), txtname.Text, rtxtDescrip.Text);
MessageBox.Show("Done");
txtid.Text = txtname.Text = rtxtDescrip.Text = "";
display();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtid.Text.Equals("") || txtname.Text.Equals(""))
{
MessageBox.Show("Please Fill Fields");
}
else
{
int i = ClassBrigade.sp_addbattalion(int.Parse(txtid.Text), txtname.Text, rtxtDescrip.Text);
MessageBox.Show("Done");
txtid.Text = txtname.Text = rtxtDescrip.Text = txtBriName.Text = "";
display();
}
}
public FRM_NewSaraya()
{
InitializeComponent();
DataTable dt1 = ClassBrigade.fillBrigade();
cmbBrigade.DataSource = dt1;
cmbBrigade.DisplayMember = "Brigades_name";
cmbBrigade.ValueMember = "Brigades_id";
DataTable dt = ClassBrigade.sp_fillBattalion(cmbBrigade.Text);
cmbBattalion.DataSource = dt;
cmbBattalion.DisplayMember = "Battalions_name";
cmbBattalion.ValueMember = "Battalions_id";
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvBrigade.DataSource = ClassBrigade.searchBrigade(txtSearch.Text);
}
void display()
{
dgvBrigade.DataSource = ClassBrigade.allBrigade();
}
void display()
{
dgvBattalion.DataSource = ClassBrigade.sp_allBattalion();
}
private void cmbBrigade_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = ClassBrigade.cmbchangeBrigades(cmbBrigade.Text);
txtID.Text = dt.Rows[0][0].ToString();
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvSaraya.DataSource = ClassBrigade.sp_searchSaraya(txtSearch.Text);
}
void display()
{
dgvSaraya.DataSource = ClassBrigade.sp_allSaraya();
}
