private void cmb_name_SelectedIndexChanged(object sender, EventArgs e) { if (flag2) { using (DataSet ds = DataManger.GetDataSet("stud_selectbyid", "x", new SqlParameter("@stud_id", (int)cmb_name.SelectedValue))) { foreach (DataRow item in ds.Tables["x"].Rows) { txt_studname.Text = item[1].ToString(); txt_studid.Text = item[0].ToString(); cmb_studclass.Text = cmb1_class.Text; stud_bar = item[3].ToString(); stud_id = item[0].ToString(); stud_class = cmb1_class.Text; stud_group = item[2].ToString(); stud_name = item[1].ToString(); using (DataSet dw = DataManger.GetDataSet("group_selectbyclass", "x", new SqlParameter("@class", cmb_studclass.Text))) { cmb_studgroup.DataSource = dw.Tables["x"]; cmb_studgroup.DisplayMember = "group_id"; } cmb_studgroup.Text = ""; cmb_studgroup.Text = item[2].ToString(); barc = item[3].ToString(); } } } }
private void btn_delete_Click(object sender, EventArgs e) { if (!btnfinish.Enabled) { if (MessageBox.Show("متاكدانك تريد حذف هذا الطالب", "warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.Yes) { if (clear3()) { DataManger.ExecuteNonQuery("stud_deletestudid", new SqlParameter("@stud_id", int.Parse(stud_id))); label21.BackColor = Color.LightGreen; label21.ForeColor = Color.Black; label21.Text = "تم حذف الطالب بنجاح......."; clear4(); } else { MessageBox.Show("!!من فضلك حدد الطالب", "warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } else { MessageBox.Show("!!يجب اتمام عملية الغياب قبل هذه العملية", "warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btnfinish_Click(object sender, EventArgs e) { if (MessageBox.Show("!!هل انت متاكد من انهاء عملية الغياب", "confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { foreach (string item in id) { DataManger.ExecuteNonQuery("absence_insert", new SqlParameter("@stud_id", int.Parse(item)), new SqlParameter("@Date", Convert.ToDateTime(DateTime.Now.ToShortDateString())) ); } drb3_class.Text = ""; cmb_group2.Text = ""; txtbar.Text = ""; drb3_class.Enabled = true; cmb_group2.Enabled = true; txtbar.Enabled = false; btnfinish.Enabled = false; btnstart.Enabled = true; lblname.Text = ""; lblresult.Text = ""; lblid.Text = ""; lblgroup.Text = ""; lblclass.Text = ""; lblabse.Text = ""; lblpres.Text = "0"; cmb.Items.Clear(); lblresult.BackColor = Color.Transparent; } }
private void btnstart_Click(object sender, EventArgs e) { if (MessageBox.Show("!!هل انت متاكد من بيانات المجموعه", @"confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { if (drb3_class.Text != "" && cmb_group2.Text != "") { id = new List <string>(); id2 = new List <string>(); using (DataSet ds = DataManger.GetDataSet("stud_selectbygroupid", "x", new SqlParameter("@group_id", cmb_group2.Text))) { foreach (DataRow item in ds.Tables["x"].Rows) { id.Add(item[0].ToString()); } } drb3_class.Enabled = false; cmb_group2.Enabled = false; txtbar.Enabled = true; txtbar.Focus(); btnfinish.Enabled = true; btnstart.Enabled = false; c = id.Count; lblabse.Text = id.Count.ToString(); } else { MessageBox.Show("من فضلك املا الفراغات", "mistake", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void cmb_studclass_SelectedIndexChanged(object sender, EventArgs e) { using (DataSet ds = DataManger.GetDataSet("group_selectbyclass", "x", new SqlParameter("@class", cmb_studclass.Text))) { cmb_studgroup.DataSource = ds.Tables["x"]; cmb_studgroup.DisplayMember = "group_id"; } cmb_studgroup.Text = ""; }
private void drb1_class_SelectedIndexChanged(object sender, EventArgs e) { using (DataSet ds = DataManger.GetDataSet("group_selectbyclass", "x", new SqlParameter("@class", drb1_class.Text))) { drb2_groub.DataSource = ds.Tables["x"]; drb2_groub.DisplayMember = "group_id"; } drb2_groub.Text = ""; }
void clear4() { clear2(); using (DataSet ds = DataManger.GetDataSet("stud_selectbygroupid", "x", new SqlParameter("@group_id", cmb_group3.Text))) { cmb_name.DataSource = ds.Tables["x"]; cmb_name.DisplayMember = "stud_name"; cmb_name.ValueMember = "stud_id"; } flag2 = true; cmb_name.Text = ""; }
private void cmb1_class_SelectedIndexChanged(object sender, EventArgs e) { clear2(); flag = false; using (DataSet ds = DataManger.GetDataSet("group_selectbyclass", "x", new SqlParameter("@class", cmb1_class.Text))) { cmb_group3.DataSource = ds.Tables["x"]; cmb_group3.DisplayMember = "group_id"; } flag = true; cmb_group3.Text = ""; }
private void btn2_barcode_Click(object sender, EventArgs e) { do { s = (new Random().Next(111111111, 999999999)).ToString(); dr = DataManger.GetDataReader("stud_selectbybarcode", out con, new SqlParameter("@barcode", s)); } while (dr.HasRows); con.Close(); b = creat_barcode(s); pictureBox1.Image = b; btn_add.Enabled = true; }
private void cmb_group3_SelectedIndexChanged(object sender, EventArgs e) { clear2(); if (flag) { using (DataSet ds = DataManger.GetDataSet("stud_selectbygroupid", "x", new SqlParameter("@group_id", cmb_group3.Text))) { cmb_name.DataSource = ds.Tables["x"]; cmb_name.DisplayMember = "stud_name"; cmb_name.ValueMember = "stud_id"; } } flag2 = true; cmb_name.Text = ""; }
private void btn_report_Click(object sender, EventArgs e) { if (clear3()) { skinEngine1.Active = false; DataSet ds = DataManger.GetDataSet("absence_selectbymonth", "x", new SqlParameter("@mon", int.Parse(DateTime.Now.Month.ToString())), new SqlParameter("@stud_id", int.Parse(stud_id))); new Report(ds, stud_id, stud_name, stud_class, stud_group).ShowDialog(); skinEngine1.Active = true; } else { MessageBox.Show("!!من فضلك حدد الطالب", "warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btn_delete_Click(object sender, EventArgs e) { if (txt1_group.Text != "") { if (DataManger.ExecuteNonQuery("group_deletebyid", new SqlParameter("@group_id", txt1_group.Text)) == 0) { MessageBox.Show("كودالمجموعة غير موجود", "warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { DataManger.ExecuteNonQuery("stud_deletebyid", new SqlParameter("@group_id", txt1_group.Text)); clear(); MessageBox.Show("تم حذف المجموعة بنجاح", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("من فضلك املا الفراغات", "mistake", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_add_Click(object sender, EventArgs e) { if (list.Count <= 10) { if (txt1_name.Text != "" && txt2_code.Text != "" && drb1_class.Text != "" && drb2_groub.Text != "") { dr = DataManger.GetDataReader("stud_selectbyid", out con, new SqlParameter("@stud_id", int.Parse(txt2_code.Text))); if (!dr.HasRows) { DataManger.ExecuteNonQuery("stud_insert", new SqlParameter("@stud_id", int.Parse(txt2_code.Text)), new SqlParameter("@stud_name", txt1_name.Text), new SqlParameter("@group_id", drb2_groub.Text), new SqlParameter("@barcode", s)); list.Add(new student_info(txt1_name.Text, drb1_class.Text, drb2_groub.Text, txt2_code.Text, b)); btn3_print.Text = string.Format("طباعة" + "({0})", ++count); if (count == 10) { btn3_print.ForeColor = Color.Red; } btn_add.Enabled = false; clear(); con.Close(); } else { con.Close(); MessageBox.Show("كودالطالب محجوز مسبقا", "warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("من فضلك املا الفراغات", "mistake", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("تم الوصول للحد الاقصي للطباعة", "warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btn_update_Click(object sender, EventArgs e) { if (!btnfinish.Enabled) { if (clear3()) { DataManger.ExecuteNonQuery("stud_updatebystudid", new SqlParameter("@stud_name", txt_studname.Text), new SqlParameter("@group_id", cmb_studgroup.Text), new SqlParameter("@stud_id", int.Parse(txt_studid.Text)), new SqlParameter("@barcode", stud_bar) ); if (DataManger.GetDataSet("stud_selectbyid", "x", new SqlParameter("@stud_id", int.Parse(txt_studid.Text))).Tables["x"].Rows.Count > 1) { DataManger.ExecuteNonQuery("stud_updatebystudid", new SqlParameter("@stud_name", stud_name), new SqlParameter("@group_id", stud_group), new SqlParameter("@stud_id", int.Parse(stud_id)), new SqlParameter("@barcode", stud_bar) ); MessageBox.Show("!!كود الطالب محجوز", "warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } clear4(); label21.BackColor = Color.LightGreen; label21.ForeColor = Color.Black; label21.Text = "تم تعديل الطالب بنجاح......."; } else { MessageBox.Show("!!بيانات الطالب غير كامله", "warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("!!يجب اتمام عملية الغياب قبل هذه العملية", "warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btn_add_Click(object sender, EventArgs e) { if (txt1_group.Text != "" || drb1_class.SelectedText != "") { if (!DataManger.GetDataReader("group_selectbyid", out con, new SqlParameter("@group_id", txt1_group.Text)).HasRows) { DataManger.ExecuteNonQuery("group_insert", new SqlParameter("@group_id", txt1_group.Text), new SqlParameter("@class", drb1_class.Text)); clear(); } else { MessageBox.Show("كودالمجموعة محجوز مسبقا", "warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } con.Close(); } else { MessageBox.Show("من فضلك املا الفراغات", "mistake", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void txtbar_KeyPress(object sender, KeyPressEventArgs e) { if (char.IsNumber(e.KeyChar) || e.KeyChar == (char)Keys.Back || e.KeyChar == (char)Keys.Enter) { e.Handled = false; if (e.KeyChar == (char)Keys.Enter) { dr = DataManger.GetDataReader("stud_selectbygroupidstudbar", out con, new SqlParameter("@barcode", txtbar.Text)); if (!dr.HasRows) { lblresult.BackColor = Color.HotPink; lblresult.ForeColor = Color.Red; lblresult.Text = "تم حذف هذا الطالب؟؟"; con.Close(); return; } else { while (dr.Read()) { if (dr[5].ToString() == drb3_class.Text) { if (id.Remove(dr[0].ToString())) { lblid.Text = dr[0].ToString(); lblname.Text = dr[1].ToString(); lblclass.Text = dr[5].ToString(); lblgroup.Text = dr[2].ToString(); id2.Add(dr[0].ToString()); lblresult.BackColor = Color.LightGreen; lblresult.ForeColor = Color.Black; lblresult.Text = "تم حضور الطالب......."; lblpres.Text = id2.Count.ToString(); cmb.Items.Add(dr[1].ToString()); lblabse.Text = id.Count.ToString(); con.Close(); return; } else { if (!id2.Remove(dr[0].ToString())) { if (MessageBox.Show("!!هل انت متاكد من اخذ حضور هذا الطالب", "confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { lblid.Text = dr[0].ToString(); lblname.Text = dr[1].ToString(); lblclass.Text = dr[5].ToString(); lblgroup.Text = dr[2].ToString(); id2.Add(dr[0].ToString()); cmb.Items.Add(dr[1].ToString()); lblpres.Text = id2.Count.ToString(); if (DataManger.ExecuteNonQuery("absence_deletebyid", new SqlParameter("@stud_id", int.Parse(dr[0].ToString()))) == 0) { MessageBox.Show("يجب اخذ رقم الطالب لتثبيت حضوره في مجموعته"); lblresult.BackColor = Color.LightGray; lblresult.ForeColor = Color.Black; lblresult.Text = ".........................."; con.Close(); return; } lblresult.BackColor = Color.MediumVioletRed; lblresult.ForeColor = Color.Black; lblresult.Text = "تم حضور الطالب......."; con.Close(); return; } else { con.Close(); return; } } else { id2.Add(dr[0].ToString()); lblid.Text = dr[0].ToString(); lblname.Text = dr[1].ToString(); lblclass.Text = dr[5].ToString(); lblgroup.Text = dr[2].ToString(); lblresult.BackColor = Color.LightBlue; lblresult.ForeColor = Color.Black; lblresult.Text = ".....تم اخذ حضور الطالب من قبل"; con.Close(); return; } } } else { MessageBox.Show(" الطالب في الصف : " + dr[5].ToString(), "mistake", MessageBoxButtons.OK, MessageBoxIcon.Error); con.Close(); return; } } } } } else { e.Handled = true; } }