private void BtnDelet_Click(object sender, EventArgs e) { btnDesibel(); btnSave.Visible = false; btnAddImage.Enabled = false; try { string stname = dataGridViewX1.CurrentRow.Cells[1].Value.ToString(); string stfamily = dataGridViewX1.CurrentRow.Cells[2].Value.ToString(); if (RtlMessageBox.Show($"آیا از حذف {stname + " " + stfamily} مطمئن هستید ؟", "توجه", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.Yes) { NetCollegeEntities db = new NetCollegeEntities(); var sttable = dataGridViewX1.CurrentRow.Cells[0].Value.ToString(); stTable stTable = db.stTables.Where(c => c.studentID == sttable).Single(); db.Entry(stTable).State = System.Data.Entity.EntityState.Deleted; db.stTables.Remove(stTable); db.SaveChanges(); BindGrid(); } } catch (Exception) { RtlMessageBox.Show("خطا در انجام حذف!"); } btnEnebel(); }
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 BtnEdit_Click(object sender, EventArgs e) { IsEdit = true; txtStAdress.Enabled = true; txtSTFamily.Enabled = true; txtStName.Enabled = true; txtStTel.Enabled = true; btnSave.Visible = true; btnAddImage.Enabled = true; btnSave.Image = amozeshgah.Properties.Resources.icons8_save_as; 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; btnDesibel(); }
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(); }
/// <summary> /// Loads a previously saved xml configuration that describes all the tables in a meter /// </summary> /// <param name="sFileName"></param> public void LoadXML(string sFileName) { XmlDocument docXML = new XmlDocument(); docXML.Load(sFileName); m_Defines.Clear(); foreach (XmlNode node in docXML.SelectNodes("OpticalInterface/Defines/Define")) { stDefine newDefine = new stDefine(); newDefine.sName = node.SelectSingleNode("Name").InnerText; newDefine.iValue = int.Parse(node.SelectSingleNode("Value").InnerText); m_Defines.Add(newDefine); } m_AllTablesID.Clear(); foreach (XmlNode node in docXML.SelectNodes("OpticalInterface/AllTables/Table")) { stTableID newTable = new stTableID(); newTable.sName = node.SelectSingleNode("Name").InnerText; newTable.iValue = int.Parse(node.SelectSingleNode("Value").InnerText); m_AllTablesID.Add(newTable); } m_SupportedTables.Clear(); foreach (XmlNode node in docXML.SelectNodes("OpticalInterface/SupportedTables/SupportedTable")) { stTable newTable = new stTable(); newTable.sName = node.SelectSingleNode("Name").InnerText; newTable.sStructure = node.SelectSingleNode("StructureName").InnerText; m_SupportedTables.Add(newTable); } m_TableStructures.Clear(); foreach (XmlNode node in docXML.SelectNodes("OpticalInterface/Tables/Table")) { stTableStructure newTable = new stTableStructure(); newTable.sFields = new List<string>(); newTable.sFieldsType = new List<string>(); newTable.sDescription = new List<string>(); newTable.sStructureName = node.SelectSingleNode("Name").InnerText; newTable.bBitField = bool.Parse(node.SelectSingleNode("BitField").InnerText); foreach (XmlNode fieldnode in node.SelectNodes("Fields/Field")) { newTable.sFields.Add(fieldnode.SelectSingleNode("Name").InnerText); newTable.sFieldsType.Add(fieldnode.SelectSingleNode("Type").InnerText); newTable.sDescription.Add(fieldnode.SelectSingleNode("Description").InnerText); } m_TableStructures.Add(newTable); } }