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 BtnDelet_Click(object sender, EventArgs e) { btnDesibel(); btnSave.Visible = false; try { string courset = dataGridViewX1.CurrentRow.Cells[0].Value.ToString(); if (RtlMessageBox.Show($"آیا از حذف {courset } مطمئن هستید ؟", "توجه", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.Yes) { NetCollegeEntities db = new NetCollegeEntities(); var course = dataGridViewX1.CurrentRow.Cells[0].Value.ToString(); selectCourse selectCourse = db.selectCourses.Where(c => c.rowID.ToString() == course).Single(); db.Entry(selectCourse).State = System.Data.Entity.EntityState.Deleted; db.selectCourses.Remove(selectCourse); db.SaveChanges(); BindGrid(); } } catch (Exception) { RtlMessageBox.Show("خطا در انجام حذف!"); } btnEnebel(); }
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 BtnEdit_Click(object sender, EventArgs e) { IsEdit = true; txtDes.Enabled = true; txtGrade.Enabled = true; comCoid.Enabled = true; txtPar.Enabled = true; comStId.Enabled = true; btnSave.Visible = true; btnSave.Image = amozeshgah.Properties.Resources.icons8_save_as; NetCollegeEntities db = new NetCollegeEntities(); var selectco = dataGridViewX1.CurrentRow.Cells[0].Value.ToString(); selectCourse selectCourse = db.selectCourses.Where(c => c.rowID.ToString() == selectco).Single(); 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; btnDesibel(); }