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 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 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)
{
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 password = encrypt(txtpass.Text);
if (IsEdit == false)
{
usersTable usersTable = new usersTable()
{
username = txtuser.Text,
password = password,
uname = txtname.Text,
ufamily = txtfamily.Text,
accessType = comAcsses.SelectedIndex + 1
};
try
{
db.usersTables.Add(usersTable);
RtlMessageBox.Show(" کاربر جدیداضافه شد ");
db.SaveChanges();
}
catch (DbUpdateException)
{
RtlMessageBox.Show("یوزر نیم تکراری است");
}
catch
{
RtlMessageBox.Show("خطا در انجام عملیات");
}
}
btnAdd.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();
}
