public int checknameandid()
{
try
{
adabdec.Fill(dataDataSet1.decTbl);
dataDataSet.decTblDataTable list = dataDataSet1.decTbl;
for (int i = 0; i < list.Count; i++)
{
if (list[i].decNumber == txtnumherman.Text && list[i].stName != txtname.Text)
{
if (list[i].decType == cmbType.Text)
{
return(1);
}
}
}
return(0);
}
catch (Exception)
{
return(0);
}
}
private void txtsearch_TextChanged(object sender, EventArgs e)
{
try
{
adabdec.FillByname(dataDataSet1.decTbl, txtsearch.Text);
// adabdec.FillBySDS(dataDataSet1.decTbl,txtsearch.Text, txtsearch.Text, txtsearch.Text);
devgrid.Rows.Clear();
dataDataSet.decTblDataTable list = dataDataSet1.decTbl;
for (int i = 0; i < list.Count; i++)
{
devgrid.Rows.Add();
devgrid.Rows[i].Cells[0].Value = list[i].decID;
devgrid.Rows[i].Cells[1].Value = i + 1;
devgrid.Rows[i].Cells[2].Value = list[i].seatNo;
devgrid.Rows[i].Cells[3].Value = list[i].stName;
devgrid.Rows[i].Cells[4].Value = list[i].decNumber;
devgrid.Rows[i].Cells[5].Value = list[i].examName;
}
}
catch (Exception)
{
}
}
public int contain()
{
try
{
adabdec.Fill(dataDataSet1.decTbl);
dataDataSet.decTblDataTable list = dataDataSet1.decTbl;
for (int i = 0; i < list.Count; i++)
{
if (list[i].decNumber == txtnumherman.Text && list[i].seatNo == txtseatNo.Text)
{
return(1);
}
}
return(0);
}
catch (Exception)
{
return(0);
}
}
private void txtsearch_TextChanged(object sender, EventArgs e)
{
try
{
string name = txtsearch.Text.ToString();
// int value = int.Parse(txtsearch.Text);
if (int.TryParse(txtsearch.Text, out int value))
{
adabdec.SearchBySeat(dataDataSet1.decTbl, value);
}
else
{
adabdec.SearchByName(dataDataSet1.decTbl, name, null);
}
// adabdec.SearchByName(dataDataSet1.decTbl, name,null);
// adabdec.FillBySDS(dataDataSet1.decTbl,txtsearch.Text, txtsearch.Text, txtsearch.Text);
devgrid.Rows.Clear();
dataDataSet.decTblDataTable list = dataDataSet1.decTbl;
for (int i = 0; i < list.Count; i++)
{
devgrid.Rows.Add();
devgrid.Rows[i].Cells[0].Value = list[i].decID;
devgrid.Rows[i].Cells[1].Value = i + 1;
devgrid.Rows[i].Cells[2].Value = list[i].seatNo;
devgrid.Rows[i].Cells[3].Value = list[i].stName;
devgrid.Rows[i].Cells[4].Value = list[i].decNumber;
devgrid.Rows[i].Cells[5].Value = list[i].examName;
}
}
catch (Exception)
{
}
}
public void show()
{
try
{
adabdec.Fill(dataDataSet1.decTbl);
devgrid.Rows.Clear();
dataDataSet.decTblDataTable list = dataDataSet1.decTbl;
for (int i = 0; i < list.Count; i++)
{
devgrid.Rows.Add();
devgrid.Rows[i].Cells[0].Value = list[i].decID;
devgrid.Rows[i].Cells[1].Value = i + 1;
devgrid.Rows[i].Cells[2].Value = list[i].seatNo;
devgrid.Rows[i].Cells[3].Value = list[i].stName;
devgrid.Rows[i].Cells[4].Value = list[i].decNumber;
devgrid.Rows[i].Cells[5].Value = list[i].examName;
}
}
catch (Exception)
{
}
}
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)
{
}
}
