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 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 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_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);
}
}