private void metroComboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (metroComboBox1.SelectedIndex == 1)
{
adabexam.FillBytype(dataDataSet1.examTable, Convert.ToInt32("1"));
}
if (metroComboBox1.SelectedIndex == 2)
{
adabexam.FillBytype(dataDataSet1.examTable, Convert.ToInt32("3"));
}
cmbcourse.DisplayMember = "examName";
cmbcourse.ValueMember = "examId";
list = dataDataSet1.examTable;
cmbcourse.DataSource = list;
}
private void metroButton1_Click(object sender, EventArgs e)
{
// البحث عن طالب
try
{
if (txtseatNo.Text != "")
{
int count = adabstu.FillBy(dataDataSet1.studentData, Convert.ToInt32(txtseatNo.Text));
if (count != 0)
{
txtname.Text = dataDataSet1.studentData.Rows[0]["stname"].ToString();
txtschool.Text = dataDataSet1.studentData.Rows[0]["scname"].ToString();
regionText.Text = dataDataSet1.studentData.Rows[0]["examScid"].ToString();
seerTxt.Text = dataDataSet1.studentData.Rows[0]["examscname"].ToString();
lagnaNumTxt.Text = dataDataSet1.studentData.Rows[0]["seercode"].ToString();
typedesc.Text = dataDataSet1.studentData.Rows[0]["type_adesc"].ToString();
stType.Text = dataDataSet1.studentData.Rows[0]["st_type"].ToString();
depatText.Text = dataDataSet1.studentData.Rows[0]["typename"].ToString();
//gender = dataDataSet1.studentData.Rows[0]["sex"];
if (cmbcourse.SelectedIndex == -1)
{
adabexam.FillBytype(dataDataSet1.examTable, Convert.ToInt32(dataDataSet1.studentData.Rows[0]["typecode"].ToString()));
}
cmbcourse.DisplayMember = "examName";
cmbcourse.ValueMember = "examId";
list = dataDataSet1.examTable;
cmbcourse.DataSource = list;
examscname = dataDataSet1.studentData.Rows[0]["examscname"].ToString();
}
else
{
MetroMessageBox.Show(this, "رقم الجلوس غير مسجل بالنظام", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Warning, 150);
}
}
else
{
MetroMessageBox.Show(this, "من فضلك أدخل رقم الجلوس", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Warning, 150);
}
}
catch (Exception g)
{
}
}
private void devgrid_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
// عرض قرار سابق من الجريد
if (e.ColumnIndex == 6)
{
adabdec.FillBy(dataDataSet1.decTbl, Convert.ToInt32(devgrid.Rows[e.RowIndex].Cells[0].Value));
dataDataSet.decTblDataTable list1 = dataDataSet1.decTbl;
if (list1.Count != 0)
{
txtname.Text = list1[0].stName;
txtschool.Text = list1[0].scName;
txtseatNo.Text = list1[0].seatNo.ToString();
txtnumherman.Text = list1[0].decNumber;
cmbType.Text = list1[0].decType;
// txtreport.Text = list1[0].dec_desc;
regionText.Text = list1[0].region;
seerTxt.Text = list1[0].examscName;
lagnaNumTxt.Text = list1[0].type_str;
adabstu.FillBy(dataDataSet1.studentData, Convert.ToInt32(txtseatNo.Text));
adabexam.FillBytype(dataDataSet1.examTable, Convert.ToInt32(dataDataSet1.studentData.Rows[0][4].ToString()));
cmbcourse.DisplayMember = "examName";
cmbcourse.ValueMember = "examId";
list = dataDataSet1.examTable;
cmbcourse.DataSource = list;
cmbcourse.Text = list1[0].examName;
txtDay.Text = list1[0].examday;
txtDate.Text = list1[0].examDate;
}
}
// حذف قرار
else if (e.ColumnIndex == 7)
{
int test = 0;
DialogResult res = MetroMessageBox.Show(this, "هل أنت متأكد من حذف هذا القرار \n مع العلم سيتم حذفه نهائياَ؟", "معلومات", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, 150);
if (res == DialogResult.Yes)
{
adabdec.FillBy(dataDataSet1.decTbl, Convert.ToInt32(devgrid.Rows[e.RowIndex].Cells[0].Value));
dataDataSet.decTblDataTable list = dataDataSet1.decTbl;
if (list.Count != 0)
{
test = adabdec.DeleteQuery(list[0].decNumber, Int32.Parse(list[0].seatNo));
if (test == 1)
{
MetroMessageBox.Show(this, "تم حذف البيانات بنجاح", "معلومات ", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, 100);
show();
}
}
}
}
}
}
catch (Exception v)
{
}
}
private void metroButton1_Click(object sender, EventArgs e)
{
// depatText.Text = "1";
// البحث عن طالب
try
{
if (txtseatNo.Text != "")
{
dataGridView1.DataSource = this.medicalBindingSource;
int count = this.medicalTableAdapter.Fill(this.dataDataSet1.medical, Convert.ToDecimal(txtseatNo.Text), Convert.ToDecimal(txtseatNo.Text));
dataGridView1.Columns["stname"].Visible = false;
dataGridView1.Columns["seatno"].Visible = false;
if (count != 0)
{
//this.medicalTableAdapter.FillBy(this.dataDataSet1.medical, Convert.ToDecimal(txtseatNo.Text), txtseatNo.Text);
// dataGridView1.Show();
txtname.Text = dataDataSet1.medical.Rows[0]["stname"].ToString();
txtschool.Text = dataDataSet1.medical.Rows[0]["school"].ToString();
// txtschool.Text = count.ToString();
regionText.Text = dataDataSet1.medical.Rows[0]["days"].ToString();
seerTxt.Text = count.ToString();
lagnaNumTxt.Text = dataDataSet1.studentData.Rows[0]["seercode"].ToString();
typedesc.Text = dataDataSet1.studentData.Rows[0]["type_adesc"].ToString();
stType.Text = dataDataSet1.studentData.Rows[0]["st_type"].ToString();
// depatText.Text = dataDataSet1.studentData.Rows[0]["typecode"].ToString();
//gender = dataDataSet1.studentData.Rows[0]["sex"];
int typecode = Convert.ToInt32(dataDataSet1.studentData.Rows[0]["typecode"].ToString());
if (cmbcourse.SelectedIndex == -1)
{
adabexam.FillBytype(dataDataSet1.examTable, typecode);
}
if (!IsEqualprevDep())
{
adabexam.FillBytype(dataDataSet1.examTable, typecode);
}
//adabexam.FillBytype(dataDataSet1.examTable, typecode);
cmbcourse.DisplayMember = "examName";
cmbcourse.ValueMember = "examId";
list = dataDataSet1.examTable;
cmbcourse.DataSource = list;
examscname = dataDataSet1.studentData.Rows[0]["examscname"].ToString();
}
else
{
MetroMessageBox.Show(this, "رقم الجلوس غير مسجل بالنظام", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Warning, 150);
}
}
else
{
MetroMessageBox.Show(this, "من فضلك أدخل رقم الجلوس", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Warning, 150);
}
}
catch (Exception g)
{
}
}
