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 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; 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 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 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(); }
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 BtnSave_Click(object sender, EventArgs e) { NetCollegeEntities db = new NetCollegeEntities(); if (IsEdit == false) { DeptTable deptTable = new DeptTable(); deptTable.deptName = txtdeptName.Text; deptTable.boss = txtboss.Text; try { db.DeptTables.Add(deptTable); RtlMessageBox.Show(" ساختمان جدیداضافه شد "); db.SaveChanges(); } catch { RtlMessageBox.Show("خطا در انجام عملیات"); } } else { DeptTable deptTable = new DeptTable(); deptTable.deptName = txtdeptName.Text; deptTable.boss = txtboss.Text; deptTable.deptId = int.Parse(txtdeptId.Text); db.Entry(deptTable).State = System.Data.Entity.EntityState.Modified; IsEdit = false; RtlMessageBox.Show("ویرایش ساختمان انجام شد"); db.SaveChanges(); } btnAdd.Enabled = true; btnEdit.Enabled = true; btnDelet.Enabled = true; btnEnebel(); BindGrid(); }
private void BtnSave_Click(object sender, EventArgs e) { NetCollegeEntities db = new NetCollegeEntities(); string imageName = Guid.NewGuid().ToString() + Path.GetExtension(pictureBox1.ImageLocation); string path = Application.StartupPath + "/Images/te/"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } else if (pictureBox1.Image == null) { pictureBox1.Image = amozeshgah.Properties.Resources.icons8_school_director_200px; } else { pictureBox1.Image.Save(path + imageName); } if (IsEdit == false) { teacherTable teacherTable = new teacherTable(); teacherTable.teacherId = txtTeID.Text; teacherTable.teacherName = txtName.Text; teacherTable.teacherFamily = txtFamily.Text; teacherTable.TeacherCetifacrte = txtCetifacrte.Text; teacherTable.TeacherExpert = txtExpert.Text; teacherTable.teacherAddress = txtAdress.Text; teacherTable.teacherTel = txtTel.Text; teacherTable.teImage = imageName;; try { db.teacherTables.Add(teacherTable); RtlMessageBox.Show(" استاد جدیداضافه شد "); db.SaveChanges(); } catch (DbUpdateException) { RtlMessageBox.Show("کد استاد تکراری است"); } catch { RtlMessageBox.Show("خطا در انجام عملیات"); } } else { try { teacherTable teacherTable = new teacherTable(); teacherTable.teacherId = txtTeID.Text; teacherTable.teacherName = txtName.Text; teacherTable.teacherFamily = txtFamily.Text; teacherTable.TeacherCetifacrte = txtCetifacrte.Text; teacherTable.TeacherExpert = txtExpert.Text; teacherTable.teacherAddress = txtAdress.Text; teacherTable.teacherTel = txtTel.Text; teacherTable.teImage = imageName;; db.Entry(teacherTable).State = System.Data.Entity.EntityState.Modified; IsEdit = false; RtlMessageBox.Show("ویرایش استاد انجام شد"); db.SaveChanges(); } catch (Exception) { RtlMessageBox.Show("خطا در انجام عملیات"); } } btnAdd.Enabled = true; btnEdit.Enabled = true; btnDelet.Enabled = true; btnEnebel(); BindGrid(); }
private void BtnSave_Click(object sender, EventArgs e) { NetCollegeEntities db = new NetCollegeEntities(); string imageName = Guid.NewGuid().ToString() + Path.GetExtension(pictureBox1.ImageLocation); string path = Application.StartupPath + "/Images/st/"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } else if (pictureBox1.Image == null) { pictureBox1.Image = amozeshgah.Properties.Resources.icons8_student_male_200px; } pictureBox1.Image.Save(path + imageName); if (IsEdit == false) { stTable stTable = new stTable(); stTable.studentID = txtStID.Text; stTable.stName = txtStName.Text; stTable.stFamily = txtSTFamily.Text; stTable.stTel = txtStTel.Text; stTable.stAddress = txtStAdress.Text; stTable.stImage = imageName; try { db.stTables.Add(stTable); RtlMessageBox.Show(" دانشجو جدیداضافه شد "); db.SaveChanges(); } catch (DbUpdateException) { RtlMessageBox.Show("شماره دانشجویی تکراری است"); } catch { RtlMessageBox.Show("خطا در انجام عملیات"); } } else { stTable stTable = new stTable(); stTable.studentID = txtStID.Text; stTable.stName = txtStName.Text; stTable.stFamily = txtSTFamily.Text; stTable.stTel = txtStTel.Text; stTable.stAddress = txtStAdress.Text; stTable.stImage = imageName; db.Entry(stTable).State = System.Data.Entity.EntityState.Modified; IsEdit = false; RtlMessageBox.Show("ویرایش دانشجو انجام شد"); db.SaveChanges(); } btnAdd.Enabled = true; btnEdit.Enabled = true; btnDelet.Enabled = true; btnEnebel(); BindGrid(); }
private void BtnSave_Click(object sender, EventArgs e) { NetCollegeEntities db = new NetCollegeEntities(); string imageName = Guid.NewGuid().ToString() + Path.GetExtension(pictureBox1.ImageLocation); string path = Application.StartupPath + "/Images/co/"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } else if (pictureBox1.Image == null) { pictureBox1.Image = amozeshgah.Properties.Resources.icons8_courses_150px; } else { pictureBox1.Image.Save(path + imageName); } if (IsEdit == false) { CoTable coTable = new CoTable(); coTable.coid = txtCoID.Text; coTable.capacity = Convert.ToInt32(txtcapa.Text); coTable.hour = Convert.ToInt32(txtTime.Text); coTable.price = Convert.ToInt32(txtPrice.Text); coTable.start_date = txtDataTime.Text; coTable.classId = comboBoxClass.SelectedValue.ToString(); coTable.dptID = Convert.ToInt32(comboBoxDep.SelectedValue.ToString()); coTable.teacherId = comboBoxTE.SelectedValue.ToString(); coTable.logo = imageName; try { db.CoTables.Add(coTable); RtlMessageBox.Show(" دوره جدیداضافه شد "); db.SaveChanges(); } catch (DbUpdateException) { RtlMessageBox.Show("شماره دوره تکراری است"); } catch { RtlMessageBox.Show("خطا در انجام عملیات"); } } else { try { CoTable coTable = new CoTable(); coTable.coid = txtCoID.Text; coTable.capacity = Convert.ToInt32(txtcapa.Text); coTable.hour = Convert.ToInt32(txtTime.Text); coTable.price = Convert.ToInt32(txtPrice.Text); coTable.start_date = txtDataTime.Text; coTable.classId = comboBoxClass.SelectedValue.ToString(); coTable.dptID = Convert.ToInt32(comboBoxDep.SelectedValue.ToString()); coTable.teacherId = comboBoxTE.SelectedValue.ToString(); coTable.logo = imageName; db.Entry(coTable).State = System.Data.Entity.EntityState.Modified; IsEdit = false; RtlMessageBox.Show("ویرایش دوره انجام شد"); db.SaveChanges(); } catch (Exception) { RtlMessageBox.Show("مقدار وارده درست نمی باشد "); } } btnAdd.Enabled = true; btnEdit.Enabled = true; btnDelet.Enabled = true; btnEnebel(); BindGrid(); }