private void cmbFilier_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = Class_student.Ps_GetClassByFiliere(Convert.ToInt32(cmbFilier.SelectedValue), Convert.ToInt32(cmbYearSchool.SelectedValue));
cmbClass.DisplayMember = "Label";
cmbClass.ValueMember = "idClass";
cmbClass.DataSource = dt;
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (cmbClass.Text != "")
{
DataTable dt = Class_student.Usp_SearchStudentbyClass(Convert.ToInt32(cmbClass.SelectedValue));
dataGridView1.DataSource = dt;
}
}
private void cmbniveau_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = Class_student.Ps_GetFilierByNivau(Convert.ToInt32(cmbniveau.SelectedValue));
if (dt.Rows.Count > 0)
{
cmbFilier.DisplayMember = "label";
cmbFilier.ValueMember = "idFiliere";
cmbFilier.DataSource = dt;
}
cmbFilier_SelectedIndexChanged(null, null);
}
private void btnMu_Click(object sender, EventArgs e)
{
try
{
DataSet ds = Class_student.ups_getMofStudent(dataGridView1.SelectedRows[0].Cells[0].Value.ToString(), dataGridView1.SelectedRows[0].Cells[15].Value.ToString());
RPT.FRM_REPORT frm = new RPT.FRM_REPORT();
RPT.CR_MUPaper rapport = new RPT.CR_MUPaper();
rapport.SetDataSource(ds);
frm.crystalReportViewer1.ReportSource = rapport;
frm.ShowDialog();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
}
public Form_AddStudent(bool check)
{
InitializeComponent();
GetYear();
GetNivau();
cmbFilier_SelectedIndexChanged(null, null);
if (check == true)
{
_check = true;
this.Text = "تعديل بيانات طالب";
Readonly(false);
btnsave.Enabled = true;
DataTable dt = Class_student.usp_GetStudentByID(Form_studentManagment.ID);
foreach (DataRow dr in dt.Rows)
{
txtid.Text = dr["NumInscription"].ToString();
txtFullNameAR.Text = dr["FullNameAr"].ToString();
txtFullNameFr.Text = dr["FullNameFr"].ToString();
cmbGender.Text = dr["Gender"].ToString();
dtpBirthday.Text = dr["birthday"].ToString();
txtBirthPlace.Text = dr["birthPlace"].ToString();
txtNationalite.Text = dr["Nationalite"].ToString();
txtAdress.Text = dr["adress"].ToString();
dtpInscriptionDate.Text = dr["InscriptionDate"].ToString();
cmbYearSchool.Text = dr["SchoolYear"].ToString();
cmbniveau.Text = dr["niveau"].ToString();
cmbFilier.Text = dr["filier"].ToString();
cmbClass.Text = dr["class"].ToString();
txtInscriptionFees.Text = dr["Registrationfees"].ToString();
txtMonthlyFees.Text = dr["Monthlyfees"].ToString();
txtFatherName.Text = dr["fatherName"].ToString();
txtFatherJob.Text = dr["fatherJob"].ToString();
txtHandphone.Text = dr["handphone"].ToString();
txtHomePhone.Text = dr["homephone"].ToString();
byte[] Arr = (byte[])dr["photo"];
MemoryStream ms = new MemoryStream(Arr);
imgStudent.Image = Image.FromStream(ms);
}
}
else
{
_check = false;
this.Text = "إضافة طالب";
Readonly(true);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
string num = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
DialogResult dr = MessageBox.Show("هل حقا تريد حذف هذا الطالب؟", "إشعار", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
Class_student.usp_tblStudentDelete(num);
MessageBox.Show("تم الحذف ينجاح");
GetData();
}
}
catch (SqlException ex)
{
//MessageBox.Show(ex.Message + ex.Number);
}
catch (Exception ex)
{
//
}
}
private void btnsave_Click(object sender, EventArgs e)
{
if (_check == false)
{
foreach (Control c in groupBox1.Controls)
{
if (c is TextBox || c is ComboBox)
{
if (c == txtNationalite || c == txtAdress)
{
continue;
}
if (c.Text == "")
{
MessageBox.Show("المرجوا ملئ جميع الخانات الإجبارية");
return;
break;
}
}
}
foreach (Control c in groupBox2.Controls)
{
if (c is TextBox || c is ComboBox)
{
if (c.Text == "")
{
MessageBox.Show("المرجوا ملئ جميع الخانات الإجبارية");
return;
break;
}
}
}
try
{
MemoryStream ms = new MemoryStream();
imgStudent.Image.Save(ms, imgStudent.Image.RawFormat);
byte[] arr = ms.ToArray();
Class_student.PS_addStudent(txtid.Text, txtFullNameAR.Text, txtFullNameFr.Text,
cmbGender.Text, dtpBirthday.Value, txtBirthPlace.Text, txtNationalite.Text, txtFatherName.Text, txtFatherJob.Text,
txtAdress.Text, txtHandphone.Text, txtHomePhone.Text, arr, true, dtpInscriptionDate.Value, Convert.ToDecimal(txtInscriptionFees.Text), Convert.ToDecimal(txtMonthlyFees.Text), Convert.ToInt32(cmbClass.SelectedValue), Convert.ToInt32(cmbYearSchool.SelectedValue));
MessageBox.Show("تمت الإضافة بنجاح");
}
catch (SqlException ex)
{
if (ex.Number == 2627)
{
MessageBox.Show("رقم التسجيل هذا موجود مسبقاً");
}
}
catch (Exception ex)
{
MessageBox.Show("حصل خطأ أثناء إضافة الطالب");
}
}
else
{
foreach (Control c in groupBox1.Controls)
{
if (c is TextBox || c is ComboBox)
{
if (c.Text == "")
{
MessageBox.Show("المرجوا ملئ جميع الخانات الإجبارية");
return;
break;
}
}
}
foreach (Control c in groupBox2.Controls)
{
if (c is TextBox || c is ComboBox)
{
if (c.Text == "")
{
MessageBox.Show("المرجوا ملئ جميع الخانات الإجبارية");
return;
break;
}
}
}
try
{
MemoryStream ms = new MemoryStream();
imgStudent.Image.Save(ms, imgStudent.Image.RawFormat);
byte[] arr = ms.ToArray();
Class_student.usp_tblStudentUpdate(txtid.Text, txtFullNameAR.Text, txtFullNameFr.Text,
cmbGender.Text, dtpBirthday.Value, txtBirthPlace.Text, txtNationalite.Text, txtFatherName.Text, txtFatherJob.Text,
txtAdress.Text, txtHandphone.Text, txtHomePhone.Text, arr, true, dtpInscriptionDate.Value, Convert.ToDecimal(txtInscriptionFees.Text), Convert.ToDecimal(txtMonthlyFees.Text), Convert.ToInt32(cmbClass.SelectedValue), Convert.ToInt32(cmbYearSchool.SelectedValue));
MessageBox.Show("تم تعديل المعلومات بنجاح");
}
catch (Exception ex)
{
MessageBox.Show("حصل خطأ أثناء تديل الطالب");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dt = Class_student.Usp_SearchStudentbyDate(dateTimePicker1.Value, dateTimePicker2.Value);
dataGridView1.DataSource = dt;
}
private void txtNum_TextChanged(object sender, EventArgs e)
{
DataTable dt = Class_student.usp_tblStudentSelectByNumber(txtNum.Text);
dataGridView1.DataSource = dt;
}
private void GetData()
{
DataTable dt = Class_student.usp_tblStudentSelect();
dataGridView1.DataSource = dt;
}
