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