private void btnSubmit_Click(object sender, EventArgs e) { if (ValidateOfNull()) { using (MyJobEntities myJob = new MyJobEntities()) { try { int[] idArray = (int[])cbRecommand.Tag; var query = (from table in myJob.Reference where table.ReferenceId == id select table).SingleOrDefault(); if (DetectAddOrUpdate(id)) { query.FirstName = txtFistName.Text; query.LastName = txtLastName.Text; query.Alias = txtAlias.Text; query.Position = txtPosition.Text; query.Email = txtEmail.Text; query.EmployeeId = idArray[cbRecommand.SelectedIndex]; myJob.SaveChanges(); MessageBox.Show("updated Successfuly"); } else { myJob.Reference.Add(new Reference { FirstName = txtFistName.Text, LastName = txtLastName.Text, Alias = txtAlias.Text, Position = txtPosition.Text, Email = txtEmail.Text, EmployeeId = idArray[cbRecommand.SelectedIndex] }); myJob.SaveChanges(); MessageBox.Show("added Successfuly"); } ucReferenceTable.RefreshTable(1); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } else { MessageBox.Show("please fill all fileds"); } }
private void btnSubmit_Click(object sender, EventArgs e) { if (ValidateOfNull()) { using (MyJobEntities myJob = new MyJobEntities()) { try { int[] idArray = (int[])cbSkillOf.Tag; var query = (from table in myJob.Skills where table.SkillId == id select table).SingleOrDefault(); if (DetectAddOrUpdate(id)) { query.SkillName = txtSkillName.Text; query.BriefDescription = rtbDescription.Text; query.EmployeeId = idArray[cbSkillOf.SelectedIndex]; myJob.SaveChanges(); MessageBox.Show("updated Successfuly"); } else { myJob.Skills.Add(new Skills { SkillName = txtSkillName.Text, BriefDescription = rtbDescription.Text, EmployeeId = idArray[cbSkillOf.SelectedIndex] }); myJob.SaveChanges(); MessageBox.Show("added Successfuly"); } ucSkillsTable.RefreshTable(1); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } else { MessageBox.Show("please fill all fileds"); } }
private void btnSubmit_Click(object sender, EventArgs e) { if (ValidateOfNull()) { using (MyJobEntities myJob = new MyJobEntities()) { try { var query = (from table in myJob.Employees where table.EmployeeId == id select table).SingleOrDefault(); if (DetectAddOrUpdate(id)) { query.FirstName = txtFistName.Text; query.LastName = txtLastName.Text; query.Alias = txtAlias.Text; query.Email = txtEmail.Text; myJob.SaveChanges(); MessageBox.Show("updated Successfuly"); } else { myJob.Employees.Add(new Employees { FirstName = txtFistName.Text, LastName = txtLastName.Text, Alias = txtAlias.Text, Email = txtEmail.Text }); myJob.SaveChanges(); MessageBox.Show("added Successfuly"); } ucEmployeesTable.RefreshTable(1); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } else { MessageBox.Show("please fill all fields"); } }
private void DeleteById(int id) { using (MyJobEntities myJob = new MyJobEntities()) { try { var query = (from table in myJob.Reference where table.ReferenceId == id select table).SingleOrDefault(); myJob.Reference.Remove(query); myJob.SaveChanges(); MessageBox.Show("Deleting is done"); ucReferenceTable.RefreshTable(1); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }