private void DisplayAllEmployees() { EntityManager em = PersistenceUtils.getEm(); grdEmployees.DataSource = em.CreateQuery <Employee>("from Employee", typeof(Employee)).GetResultList(); grdEmployees.DataBind(); }
private bool IsDuplicateOfExisting(Employee newEmployee) { try { EntityManager em = PersistenceUtils.getEm(); Employee duplicateEmployee = em.Find <Employee>(typeof(Employee), newEmployee.ID); return(duplicateEmployee != null); } catch (Exception e) { log.Info(e.Message); return(false); } }
private static void createAndSaveEntity() { EntityManager em = PersistenceUtils.getEm(); Employee jon = new Employee(); jon.FirstName = "jon"; jon.LastName = "do"; em.GetTransaction().Begin(); em.Persist(jon); em.GetTransaction().Commit(); TypedQuery <Employee> query = em.CreateQuery <Employee>("from Employee as emp where emp.FirstName = ?", typeof(Employee)); query.SetParameter(0, jon.FirstName); Employee emp = query.GetSingleResult(); Console.WriteLine("Hello" + emp.FirstName); }
protected void btnAdd_OnClick(object sender, EventArgs e) { if (txtEmployeeID.Text.Trim().Length > 0) { Employee newEmployee = new Employee(); newEmployee.FirstName = txtFirstName.Text; newEmployee.ID = txtEmployeeID.Text; newEmployee.LastName = txtLastName.Text; if (!IsDuplicateOfExisting(newEmployee)) { EntityManager em = PersistenceUtils.getEm(); em.GetTransaction().Begin(); try { em.Persist(newEmployee); em.GetTransaction().Commit(); Response.Redirect("NPA_ExampleForm.aspx"); } catch (Exception e1) { log.Info(e1.Message); lblMessage.Text = "<span style=\"color:red\">Problem during save</span><br />Please try again later."; } } else { lblMessage.Text = "<span style=\"color:red\">The ID you provided is already in use.</span><br />Please change the ID and try again."; } } else { lblMessage.Text = "<span style=\"color:red\">The ID can't be empty</span>"; } }