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();
}
