private void TextBoxX1_TextChanged(object sender, EventArgs e)
{
NetCollegeEntities db = new NetCollegeEntities();
if (comboBoxEx1.SelectedIndex == 0)
{
dataGridViewX1.DataSource = db.DeptTables.Where(c =>
c.deptId.ToString().Contains(textBoxX1.Text)).ToList();
}
else if (comboBoxEx1.SelectedIndex == 1)
{
dataGridViewX1.DataSource = db.DeptTables.Where(c =>
c.deptName.Contains(textBoxX1.Text)).ToList();
}
else if (comboBoxEx1.SelectedIndex == 2)
{
dataGridViewX1.DataSource = db.DeptTables.Where(c =>
c.boss.Contains(textBoxX1.Text)).ToList();
}
else if (textBoxX1.Text == "")
{
BindGrid();
}
}
private void BtnEdit_Click(object sender, EventArgs e)
{
IsEdit = true;
btnAddImage.Enabled = true;
btnSave.Image = amozeshgah.Properties.Resources.icons8_save_as;
txtAdress.Enabled = true;
txtCetifacrte.Enabled = true;
txtExpert.Enabled = true;
txtFamily.Enabled = true;
txtName.Enabled = true;
txtTel.Enabled = true;
NetCollegeEntities db = new NetCollegeEntities();
var teId = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
teacherTable teacherTable = db.teacherTables.Where(c => c.teacherId == teId).Single();
txtAdress.Text = teacherTable.teacherAddress;
txtCetifacrte.Text = teacherTable.TeacherCetifacrte;
txtExpert.Text = teacherTable.TeacherExpert;
txtFamily.Text = teacherTable.teacherFamily;
txtName.Text = teacherTable.teacherName;
txtTeID.Text = teacherTable.teacherId;
txtTel.Text = teacherTable.teacherTel;
pictureBox1.ImageLocation = Application.StartupPath + "/Images/te/" + teacherTable.teImage;
btnDesibel();
}
private void Form1_Load(object sender, EventArgs e)
{
NetCollegeEntities db = new NetCollegeEntities();
DateTime dt = DateTime.Now;
labelX2.Text = dt.ToString(pc.GetYear(DateTime.Now) + "/" + pc.GetMonth(DateTime.Now) + "/" + pc.GetDayOfMonth(DateTime.Now));
this.Hide();
frmlogin frmlogin = new frmlogin();
if (frmlogin.ShowDialog() == DialogResult.OK)
{
if (User.AccessType != 1)
{
btnadduser.Visible = false;
}
this.Show();
frmlogin.Hide();
}
else
{
Application.Exit();
}
}
private void DataGridViewX1_CellClick(object sender, DataGridViewCellEventArgs e)
{
NetCollegeEntities db = new NetCollegeEntities();
var selectco = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
selectCourse selectCourse = db.selectCourses.Where(c => c.rowID.ToString() == selectco).Single();
CoTable coTable = db.CoTables.Where(c => c.coid == selectCourse.coid).Single();
txtprise.Text = coTable.price.ToString();
price = Convert.ToInt32(txtprise.Text);
pardack = Convert.ToInt32(selectCourse.pardakht);
mandeh = price - pardack;
txtmandeh.Text = mandeh.ToString();
txtDes.Text = selectCourse.description;
txtGrade.Text = selectCourse.grade.ToString();
txtPar.Text = selectCourse.pardakht;
txtRowId.Text = selectCourse.rowID.ToString();
comCoid.Text = selectCourse.coid;
comStId.Text = selectCourse.stid;
if (mandeh <= 0)
{
lbl.Image = amozeshgah.Properties.Resources.icons8_wink_48px;
}
else
{
lbl.Image = amozeshgah.Properties.Resources.icons8_question_48px;
}
}
private void UserControlCo_Load(object sender, EventArgs e)
{
comboBoxEx1.SelectedIndex = 0;
NetCollegeEntities db = new NetCollegeEntities();
dataGridViewX1.AutoGenerateColumns = false;
btnSave.Visible = false;
BindGrid();
comboBoxClass.DataSource = db.classTables.ToList();
comboBoxClass.DisplayMember = "class_ID";
comboBoxClass.ValueMember = "class_ID";
//comboBoxTE.SelectedIndex = 0;
comboBoxDep.DataSource = db.DeptTables.ToList();
comboBoxDep.DisplayMember = "deptId";
comboBoxDep.ValueMember = "deptId";
//comboBoxDep.SelectedIndex = 0;
comboBoxTE.DataSource = db.teacherTables.ToList();
comboBoxTE.DisplayMember = "teacherFamily";
comboBoxTE.ValueMember = "teacherId";
//comboBoxTE.SelectedIndex = 0;
}
private void BtnDelet_Click(object sender, EventArgs e)
{
btnDesibel();
btnSave.Visible = false;
btnAddImage.Enabled = false;
try
{
string tenamename = dataGridViewX1.CurrentRow.Cells[1].Value.ToString();
string tefamily = dataGridViewX1.CurrentRow.Cells[2].Value.ToString();
if (RtlMessageBox.Show($"آیا از حذف {tenamename + " " + tefamily} مطمئن هستید ؟", "توجه", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.Yes)
{
NetCollegeEntities db = new NetCollegeEntities();
var teID = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
teacherTable teacherTable = db.teacherTables.Where(c => c.teacherId == teID).Single();
db.Entry(teacherTable).State = System.Data.Entity.EntityState.Deleted;
db.teacherTables.Remove(teacherTable);
db.SaveChanges();
BindGrid();
}
}
catch (Exception)
{
RtlMessageBox.Show("خطا در انجام حذف!");
}
btnEnebel();
}
private void BtnDelet_Click(object sender, EventArgs e)
{
btnDesibel();
btnSave.Visible = false;
try
{
string userna = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
if (RtlMessageBox.Show($"آیا از حذف {userna } مطمئن هستید ؟", "توجه", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.Yes)
{
NetCollegeEntities db = new NetCollegeEntities();
var user = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
usersTable usersTable = db.usersTables.Where(c => c.username == user).Single();
db.Entry(usersTable).State = System.Data.Entity.EntityState.Deleted;
db.usersTables.Remove(usersTable);
db.SaveChanges();
BindGrid();
}
}
catch (Exception)
{
RtlMessageBox.Show("خطا در انجام حذف!");
}
btnEnebel();
}
private void BtnEdit_Click(object sender, EventArgs e)
{
IsEdit = true;
txtcapa.Enabled = true;
txtDataTime.Enabled = true;
txtPrice.Enabled = true;
txtTime.Enabled = true;
comboBoxClass.Enabled = true;
comboBoxDep.Enabled = true;
comboBoxTE.Enabled = true;
btnSave.Visible = true;
btnAddImage.Enabled = true;
btnSave.Image = amozeshgah.Properties.Resources.icons8_save_as;
NetCollegeEntities db = new NetCollegeEntities();
var cota = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
CoTable coTable = db.CoTables.Where(c => c.coid == cota).Single();
txtcapa.Text = Convert.ToString(coTable.capacity);
txtCoID.Text = coTable.coid;
txtDataTime.Text = Convert.ToString(coTable.start_date);
txtPrice.Text = Convert.ToString(coTable.price);
txtTime.Text = Convert.ToString(coTable.hour);
comboBoxClass.Text = coTable.classId;
comboBoxDep.Text = coTable.dptID.ToString();
comboBoxTE.Text = coTable.teacherId;
pictureBox1.ImageLocation = Application.StartupPath + "/Images/co/" + coTable.logo;
btnDesibel();
}
private void BtnDelet_Click(object sender, EventArgs e)
{
btnAdd.Enabled = false;
btnEdit.Enabled = false;
btnDelet.Enabled = false;
try
{
string classtabel = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
if (RtlMessageBox.Show($"آیا از حذف {classtabel } مطمئن هستید ؟", "توجه", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.Yes)
{
NetCollegeEntities db = new NetCollegeEntities();
var coname = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
classTable classTable = db.classTables.Where(c => c.class_ID == coname).Single();
db.Entry(classTable).State = System.Data.Entity.EntityState.Deleted;
db.classTables.Remove(classTable);
db.SaveChanges();
BindGrid();
}
}
catch (Exception)
{
RtlMessageBox.Show("خطا در انجام حذف!");
}
btnAdd.Enabled = true;
btnEdit.Enabled = true;
btnDelet.Enabled = true;
}
private void Txtserch_KeyPress(object sender, KeyPressEventArgs e)
{
NetCollegeEntities db = new NetCollegeEntities();
bs = dataGridViewX1.DataSource = db.classTables.Local.Where(c => c.class_ID == txtserch.Text).ToList();
bs = dataGridViewX1.DataSource.ToString();
}
private void BtnDelet_Click(object sender, EventArgs e)
{
btnDesibel();
btnSave.Visible = false;
if (dataGridViewX1.CurrentRow != null)
{
try
{
string dep = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
if (RtlMessageBox.Show($"آیا از حذف {dep } مطمئن هستید ؟", "توجه", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.Yes)
{
NetCollegeEntities db = new NetCollegeEntities();
var dept = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
DeptTable deptTable = db.DeptTables.Where(c => c.deptId.ToString() == dept).Single();
db.Entry(deptTable).State = System.Data.Entity.EntityState.Deleted;
db.DeptTables.Remove(deptTable);
db.SaveChanges();
BindGrid();
}
}
catch (Exception)
{
RtlMessageBox.Show("خطا در انجام حذف!");
}
btnEnebel();
}
else
{
RtlMessageBox.Show("رکوردی انتخاب نشده است");
}
}
private void UserControlTE_Load(object sender, EventArgs e)
{
comboBoxEx1.SelectedIndex = 0;
NetCollegeEntities db = new NetCollegeEntities();
dataGridViewX1.AutoGenerateColumns = false;
btnSave.Visible = false;
BindGrid();
}
private void DataGridViewX1_CellClick(object sender, DataGridViewCellEventArgs e)
{
NetCollegeEntities db = new NetCollegeEntities();
var dep = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
DeptTable deptTable = db.DeptTables.Where(c => c.deptId.ToString() == dep).Single();
txtdeptId.Text = deptTable.deptId.ToString();
txtdeptName.Text = deptTable.deptName;
txtboss.Text = deptTable.boss;
}
private void TextBoxX1_TextChanged(object sender, EventArgs e)
{
try
{
NetCollegeEntities db = new NetCollegeEntities();
if (comboBoxEx1.SelectedIndex == 0)
{
dataGridViewX1.DataSource = db.teacherTables.Where(c =>
c.teacherId.Contains(textBoxX1.Text)).ToList();
}
else if (comboBoxEx1.SelectedIndex == 1)
{
dataGridViewX1.DataSource = db.teacherTables.Where(c =>
c.teacherName.Contains(textBoxX1.Text)).ToList();
}
else if (comboBoxEx1.SelectedIndex == 2)
{
dataGridViewX1.DataSource = db.teacherTables.Where(c =>
c.teacherFamily.Contains(textBoxX1.Text)).ToList();
}
else if (comboBoxEx1.SelectedIndex == 3)
{
dataGridViewX1.DataSource = db.teacherTables.Where(c =>
c.TeacherExpert.Contains(textBoxX1.Text)).ToList();
}
else if (comboBoxEx1.SelectedIndex == 4)
{
dataGridViewX1.DataSource = db.teacherTables.Where(c =>
c.TeacherCetifacrte.Contains(textBoxX1.Text)).ToList();
}
else if (comboBoxEx1.SelectedIndex == 5)
{
dataGridViewX1.DataSource = db.teacherTables.Where(c =>
c.teacherAddress.Contains(textBoxX1.Text)).ToList();
}
else
{
BindGrid();
}
}
catch (Exception)
{
RtlMessageBox.Show("خطا در جستجو");
}
}
void BindGrid()
{
txtStAdress.Enabled = false;
txtSTFamily.Enabled = false;
txtStID.Enabled = false;
txtStName.Enabled = false;
txtStTel.Enabled = false;
NetCollegeEntities db = new NetCollegeEntities();
dataGridViewX1.DataSource = db.stTables.ToList();
dataGridViewX1.AutoGenerateColumns = false;
}
private void UserControluser_Load(object sender, EventArgs e)
{
NetCollegeEntities db = new NetCollegeEntities();
comAcsses.SelectedIndex = 1;
dataGridViewX1.AutoGenerateColumns = false;
btnSave.Visible = false;
BindGrid();
}
private void BtnSave_Click(object sender, EventArgs e)
{
NetCollegeEntities db = new NetCollegeEntities();
if (IsEdit == false)
{
selectCourse selectCourse = new selectCourse();
selectCourse.rowID = int.Parse(txtRowId.Text);
selectCourse.description = txtDes.Text;
selectCourse.pardakht = txtPar.Text;
selectCourse.grade = int.Parse(txtGrade.Text);
selectCourse.stid = comStId.SelectedValue.ToString();
selectCourse.coid = comCoid.SelectedValue.ToString();
try
{
db.selectCourses.Add(selectCourse);
RtlMessageBox.Show(" دوره جدیدانتخاب شد ");
db.SaveChanges();
}
catch (DbUpdateException)
{
RtlMessageBox.Show("شماره دوره انتخابی تکراری است");
}
catch
{
RtlMessageBox.Show("خطا در انجام عملیات");
}
}
else
{
selectCourse selectCourse = new selectCourse();
selectCourse.rowID = int.Parse(txtRowId.Text);
selectCourse.description = txtDes.Text;
selectCourse.pardakht = txtPar.Text;
selectCourse.grade = int.Parse(txtGrade.Text);
selectCourse.stid = comStId.SelectedValue.ToString();
selectCourse.coid = comCoid.SelectedValue.ToString();
db.Entry(selectCourse).State = System.Data.Entity.EntityState.Modified;
IsEdit = false;
RtlMessageBox.Show("ویرایش دوره انتخابی انجام شد");
db.SaveChanges();
}
btnAdd.Enabled = true;
btnEdit.Enabled = true;
btnDelet.Enabled = true;
btnEnebel();
BindGrid();
}
void BindGrid()
{
txtdeptId.Enabled = false;
txtdeptName.Enabled = false;
txtboss.Enabled = false;
txtdeptId.Text = "";
txtdeptName.Text = "";
txtboss.Text = "";
NetCollegeEntities db = new NetCollegeEntities();
dataGridViewX1.DataSource = db.DeptTables.ToList();
}
void BindGrid()
{
txtfamily.Enabled = false;
txtname.Enabled = false;
txtpass.Enabled = false;
comAcsses.Enabled = false;
txtuser.Enabled = false;
NetCollegeEntities db = new NetCollegeEntities();
dataGridViewX1.DataSource = db.usersTables.ToList();
dataGridViewX1.AutoGenerateColumns = false;
}
void BindGrid()
{
txtAdress.Enabled = false;
txtCetifacrte.Enabled = false;
txtExpert.Enabled = false;
txtFamily.Enabled = false;
txtName.Enabled = false;
txtTeID.Enabled = false;
txtTel.Enabled = false;
NetCollegeEntities db = new NetCollegeEntities();
dataGridViewX1.DataSource = db.teacherTables.ToList();
dataGridViewX1.AutoGenerateColumns = false;
}
private void TextBoxX1_TextChanged(object sender, EventArgs e)
{
try
{
NetCollegeEntities db = new NetCollegeEntities();
if (comboBoxEx1.SelectedIndex == 0)
{
dataGridViewX1.DataSource = db.selectCourses.Where(c =>
c.rowID.ToString().Contains(textBoxX1.Text)).ToList();
}
else if (comboBoxEx1.SelectedIndex == 1)
{
dataGridViewX1.DataSource = db.selectCourses.Where(c =>
c.stid.Contains(textBoxX1.Text)).ToList();
}
else if (comboBoxEx1.SelectedIndex == 2)
{
dataGridViewX1.DataSource = db.selectCourses.Where(c =>
c.grade.ToString().Contains(textBoxX1.Text)).ToList();
}
else if (comboBoxEx1.SelectedIndex == 3)
{
dataGridViewX1.DataSource = db.selectCourses.Where(c =>
c.coid.Contains(textBoxX1.Text)).ToList();
}
else if (comboBoxEx1.SelectedIndex == 4)
{
dataGridViewX1.DataSource = db.selectCourses.Where(c =>
c.pardakht.Contains(textBoxX1.Text)).ToList();
}
else
{
BindGrid();
}
}
catch (Exception)
{
RtlMessageBox.Show("خطا در جستجو");
}
}
void BindGrid()
{
txtcapa.Enabled = false;
txtCoID.Enabled = false;
txtDataTime.Enabled = false;
txtPrice.Enabled = false;
txtTime.Enabled = false;
comboBoxClass.Enabled = false;
comboBoxDep.Enabled = false;
comboBoxTE.Enabled = false;
NetCollegeEntities db = new NetCollegeEntities();
dataGridViewX1.DataSource = db.CoTables.ToList();
dataGridViewX1.AutoGenerateColumns = false;
}
void BindGrid()
{
comCoid.Enabled = false;
txtDes.Enabled = false;
txtGrade.Enabled = false;
//txtMan.Enabled = false;
txtPar.Enabled = false;
txtRowId.Enabled = false;
comStId.Enabled = false;
NetCollegeEntities db = new NetCollegeEntities();
dataGridViewX1.DataSource = db.selectCourses.ToList();
dataGridViewX1.AutoGenerateColumns = false;
}
void BindGrid()
{
txtCapacty.Enabled = false;
txtClassID.Enabled = false;
txtCooler.Enabled = false;
txtDest.Enabled = false;
txtVideo.Enabled = false;
btnSave.Visible = false;
txtCapacty.Text = "";
txtClassID.Text = "";
txtDest.Text = "";
NetCollegeEntities db = new NetCollegeEntities();
dataGridViewX1.DataSource = db.classTables.ToList();
}
private void BtnEdit_Click(object sender, EventArgs e)
{
txtdeptName.Enabled = true;
txtboss.Enabled = true;
btnSave.Image = amozeshgah.Properties.Resources.icons8_save_as;
IsEdit = true;
NetCollegeEntities db = new NetCollegeEntities();
var dep = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
DeptTable deptTable = db.DeptTables.Where(c => c.deptId.ToString() == dep).Single();
txtdeptId.Text = deptTable.deptId.ToString();
txtdeptName.Text = deptTable.deptName;
txtboss.Text = deptTable.boss;
btnDesibel();
}
private void DataGridViewX1_CellClick(object sender, DataGridViewCellEventArgs e)
{
NetCollegeEntities db = new NetCollegeEntities();
var cota = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
CoTable coTable = db.CoTables.Where(c => c.coid == cota).Single();
txtcapa.Text = Convert.ToString(coTable.capacity);
txtCoID.Text = coTable.coid;
txtDataTime.Text = Convert.ToString(coTable.start_date);
txtPrice.Text = Convert.ToString(coTable.price);
txtTime.Text = Convert.ToString(coTable.hour);
comboBoxClass.Text = coTable.classId;
comboBoxDep.Text = coTable.dptID.ToString();
comboBoxTE.Text = coTable.teacherId;
pictureBox1.ImageLocation = Application.StartupPath + "/Images/co/" + coTable.logo;
}
private void BtnSave_Click(object sender, EventArgs e)
{
NetCollegeEntities db = new NetCollegeEntities();
if (IsEdit == false)
{
classTable classTable = new classTable()
{
class_ID = txtClassID.Text,
capacity = Convert.ToInt32(txtCapacty.Text),
description = txtDest.Text,
cooler = txtCooler.Checked,
video_projector = txtVideo.Checked
};
try
{
db.classTables.Add(classTable);
RtlMessageBox.Show(" کلاس جدیداضافه شد ");
db.SaveChanges();
}
catch (DbUpdateException)
{
RtlMessageBox.Show("شماره کلاس تکراری است");
}
catch
{
RtlMessageBox.Show("خطا در انجام عملیات");
}
}
else
{
classTable classTable = new classTable();
classTable.class_ID = txtClassID.Text;
classTable.capacity = Convert.ToInt32(txtCapacty.Text);
classTable.description = txtDest.Text;
classTable.cooler = txtCooler.Checked;
classTable.video_projector = txtVideo.Checked;
db.Entry(classTable).State = System.Data.Entity.EntityState.Modified; IsEdit = false;
RtlMessageBox.Show("ویرایش کلاس انجام شد");
db.SaveChanges();
}
btnAdd.Enabled = true;
btnEdit.Enabled = true;
btnDelet.Enabled = true;
BindGrid();
}
private void DataGridViewX1_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
NetCollegeEntities db = new NetCollegeEntities();
var stID = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
stTable stTable = db.stTables.Where(c => c.studentID == stID).Single();
txtStAdress.Text = stTable.stAddress;
txtSTFamily.Text = stTable.stFamily;
txtStID.Text = stTable.studentID;
txtStName.Text = stTable.stName;
txtStTel.Text = stTable.stTel;
pictureBox1.ImageLocation = Application.StartupPath + "/Images/st/" + stTable.stImage;
}
catch (Exception)
{
RtlMessageBox.Show("رکوردی انتخاب نشده است");
}
}
private void ButtonX1_Click(object sender, EventArgs e)
{
NetCollegeEntities db = new NetCollegeEntities();
string ramz = encrypt(txtpass.Text);
var q = db.usersTables.Where(x => x.username == txtuser.Text && x.password == ramz).ToList();
if (q.Count > 0)
{
RtlMessageBox.Show("خوش امدید " + q[0].uname + " " + q[0].ufamily);
User.AccessType = (int)q[0].accessType;
User.Uname = q[0].uname;
User.Ufamily = q[0].ufamily;
DialogResult = DialogResult.OK;
}
else
{
RtlMessageBox.Show("نام یا رمز کاربری اشتباه است");
}
}
private void DataGridViewX1_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
NetCollegeEntities db = new NetCollegeEntities();
var coname = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
classTable classTable = db.classTables.Where(c => c.class_ID == coname).Single();
string classneme = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
txtClassID.Text = classTable.class_ID;
txtCapacty.Text = Convert.ToString(classTable.capacity);
txtDest.Text = classTable.description;
txtVideo.Checked = Convert.ToBoolean(classTable.video_projector);
txtCooler.Checked = Convert.ToBoolean(classTable.cooler);
}
catch (Exception)
{
RtlMessageBox.Show("رکوردی انتخاب نشده است");
}
}
