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("رکوردی انتخاب نشده است"); } }