public int contain() { try { adabdec.Fill(dataDataSet1.decTbl1); dataDataSet.decTbl1DataTable list = dataDataSet1.decTbl1; for (int i = 0; i < list.Count; i++) { if (list[i].decNumber == txtnumherman.Text && list[i].seatNo == txtseatNo.Text) { //MetroMessageBox.Show(this, "check name and id fun","found ", MessageBoxButtons.OK, MessageBoxIcon.Warning, 150); return(1); } } //MetroMessageBox.Show(this, "check name and id fun", "Not found ", MessageBoxButtons.OK, MessageBoxIcon.Warning, 150); return(0); } catch (Exception) { return(0); } }
private void txtsearch_TextChanged(object sender, EventArgs e) { try { adabdec.FillByname(dataDataSet1.decTbl1, txtsearch.Text); devgrid.Rows.Clear(); dataDataSet.decTbl1DataTable list = dataDataSet1.decTbl1; 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; } } catch (Exception) { } }
public void show() { try { adabdec.Fill(dataDataSet1.decTbl1); devgrid.Rows.Clear(); dataDataSet.decTbl1DataTable list = dataDataSet1.decTbl1; 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[7].Value = list[i].region; } } catch (Exception) { } }
private void devgrid_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex != -1) { // عرض قرار سابق من الجريد if (e.ColumnIndex == 5) { adabdec.FillBy(dataDataSet1.decTbl1, Convert.ToInt32(devgrid.Rows[e.RowIndex].Cells[0].Value)); dataDataSet.decTbl1DataTable list1 = dataDataSet1.decTbl1; 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.studentData1, Convert.ToInt32(txtseatNo.Text)); adabexam.FillBy(dataDataSet1.examTable1, Convert.ToInt32(dataDataSet1.studentData1.Rows[0][4].ToString())); cmbcourse.DisplayMember = "examName"; cmbcourse.ValueMember = "examId"; list = dataDataSet1.examTable1; cmbcourse.DataSource = list; cmbcourse.Text = list1[0].examName; txtDay.Text = list1[0].examday; txtDate.Text = list1[0].examDate; } } // حذف قرار else if (e.ColumnIndex == 6) { int test = 0; DialogResult res = MetroMessageBox.Show(this, "هل أنت متأكد من حذف هذا القرار \n مع العلم سيتم حذفه نهائياَ؟", "معلومات", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, 150); if (res == DialogResult.Yes) { adabdec.FillBy(dataDataSet1.decTbl1, Convert.ToInt32(devgrid.Rows[e.RowIndex].Cells[0].Value)); dataDataSet.decTbl1DataTable list = dataDataSet1.decTbl1; if (list.Count != 0) { //if (list[0].type_str is null) //{ int add = archeive.InsertQuery(1, Int32.Parse(list[0].decNumber), Int32.Parse(list[0].seatNo), list[0].examName, list[0].examDate, list[0].decType, list[0].dec_desc); //int add = archeive.InsertQuery(1,1, 233, "fuufuf", "ffff", 2333, "rrrrrr"); if (add == 1) { MetroMessageBox.Show(this, "added to archeieve ", "معلومات ", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, 100); } test = adabdec.Delete(list[0].seatNo, list[0].decNumber); //} //else //{ // test = adabdec.Delete(list[0].decNumber); // test = adabdec.Delete(list[0].decID, list[0].seatNo, list[0].stName, list[0].scName, list[0].examscName, list[0].examName, list[0].examday, list[0].examDate, list[0].decType, list[0].dec_desc, list[0].decNumber, list[0].region, list[0].type_str,list[0].type_adesc,list[0]); //} if (test == 1) { MetroMessageBox.Show(this, "تم حذف البيانات بنجاح", "معلومات ", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, 100); show(); } } } } } } catch (Exception v) { } }