private void DisplayAllSuppliers() { ISupplierDao supplierDao = new NHibernateDaoFactory().GetSupplierDao(); grdSuppliers.DataSource = supplierDao.GetAll(); grdSuppliers.DataBind(); }
private void ShowProductsOrdered(Customer customer) { IDaoFactory daoFactory = new NHibernateDaoFactory(); IHistoricalOrderSummaryDao orderSummaryDao = daoFactory.GetHistoricalOrderSummaryDao(); grdProductsOrdered.DataSource = orderSummaryDao.GetCustomerOrderHistoryFor(customer.ID); grdProductsOrdered.DataBind(); }
public void CanGetCustomerOrderHistory() { IDaoFactory daoFactory = new NHibernateDaoFactory(); IHistoricalOrderSummaryDao historicalOrderSummaryDao = daoFactory.GetHistoricalOrderSummaryDao(); List<HistoricalOrderSummary> foundSummaries = historicalOrderSummaryDao.GetCustomerOrderHistoryFor(TestGlobals.TestCustomer.ID); Assert.AreEqual(11, foundSummaries.Count); }
public void CanGetByExample() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); Customer exampleCustomer = new Customer(TestGlobals.TestCustomer.CompanyName); Customer foundCustomer = customerDao.GetUniqueByExample(exampleCustomer); Assert.AreEqual(TestGlobals.TestCustomer.CompanyName, foundCustomer.CompanyName); }
public void TestGetById() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); Customer foundCustomer = customerDao.GetById(TestGlobals.TestCustomer.ID, false); Assert.AreEqual(TestGlobals.TestCustomer.CompanyName, foundCustomer.CompanyName); }
private void DisplayAllSuppliers() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ISupplierDao supplierDao = daoFactory.GetSupplierDao(); grdSuppliers.DataSource = supplierDao.GetAll(); grdSuppliers.DataBind(); }
public void can_delete_autor() { IAutorDao autorDao = new NHibernateDaoFactory().getAutorDao(); Autor a = autorDao.GetById(147L, true); if(a != null) autorDao.delete(a); }
private void DisplayAllCustomers() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); grdEmployees.DataSource = customerDao.GetAll(); grdEmployees.DataBind(); }
protected void btnAdd_OnClick(object sender, EventArgs e) { if (txtCustomerID.Text.Trim().Length == 5) { Customer newCustomer = new Customer(txtCompanyName.Text); newCustomer.SetAssignedIdTo(txtCustomerID.Text); newCustomer.ContactName = txtContactName.Text; IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); if (!IsDuplicateOfExisting(newCustomer, customerDao)) { customerDao.Save(newCustomer); Response.Redirect("ListCustomers.aspx?action=added"); } 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 you provide must be exactly 5 characters long.</span><br />Please change the ID and try again."; } }
public void CanGetCustomerOrderHistory() { IDaoFactory daoFactory = new NHibernateDaoFactory(); IHistoricalOrderSummaryDao historicalOrderSummaryDao = daoFactory.GetHistoricalOrderSummaryDao(); List <HistoricalOrderSummary> foundSummaries = historicalOrderSummaryDao.GetCustomerOrderHistoryFor(TestGlobals.TestCustomer.ID); Assert.AreEqual(11, foundSummaries.Count); }
private void DisplayAllCustomers() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); grdEmployees.DataSource = customerDao.GetAll(); grdEmployees.DataBind(); }
private void ShowProductsOrdered(Customer customer) { IDaoFactory daoFactory = new NHibernateDaoFactory(); IHistoricalOrderSummaryDao orderSummaryDao = daoFactory.GetHistoricalOrderSummaryDao(); grdProductsOrdered.DataSource = orderSummaryDao.GetCustomerOrderHistoryFor(customer.ID); grdProductsOrdered.DataBind(); }
public void CanGetByExample() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); Customer exampleCustomer = new Customer(TestGlobals.TestCustomer.CompanyName); Customer foundCustomer = customerDao.GetUniqueByExample(exampleCustomer); Assert.AreEqual(TestGlobals.TestCustomer.CompanyName, foundCustomer.CompanyName); }
public void TestGetById() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); Customer foundCustomer = customerDao.GetById(TestGlobals.TestCustomer.ID, false); Assert.AreEqual(TestGlobals.TestCustomer.CompanyName, foundCustomer.CompanyName); }
public static void append(long tID, long pID) { IDaoFactory daoFactory = new NHibernateDaoFactory(); Track track = daoFactory.getTrackDao().GetById(tID, false); Playlist playlist = daoFactory.getPlaylistDao().GetById(pID, false); playlist.addEinsatz( new Einsatz( playlist, track )); Playlist_Service.updatePositions(playlist); }
private void DisplayCustomerToEdit() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); // No need to lock the customer since we're just viewing the data Customer customerToEdit = customerDao.GetById(Request.QueryString["customerID"], false); ShowCustomerDetails(customerToEdit); ShowPastOrders(customerToEdit); ShowProductsOrdered(customerToEdit); }
private void UpdateCustomer() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); // Now that we're about to update the customer, be sure to lock the entity Customer customerToUpdate = customerDao.GetById(hidCustomerID.Value, true); // Changes to the customer object will be automatically committed at the end of the HTTP request customerToUpdate.CompanyName = txtCompanyName.Text; customerToUpdate.ContactName = txtContactName.Text; }
public void initialise() { long id = QueryID.getValidated(this.view.QueryId); Playlist p = new NHibernateDaoFactory().getPlaylistDao().GetById(id, false); IList<Track> tracks = new List<Track>(); if(p != null) { foreach(Einsatz e in p.Einsaetze) tracks.Add(e.Track); this.view.Playlist = p; } this.view.Tracks = tracks; }
private void UpdateCustomer() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); // Now that we're about to update the customer, be sure to lock the entity Customer customerToUpdate = customerDao.GetById(hidCustomerID.Value, true); // Changes to the customer object will be automatically committed at the end of the HTTP request customerToUpdate.CompanyName = txtCompanyName.Text; customerToUpdate.ContactName = txtContactName.Text; }
public void TestGetOrdersShippedTo() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); Customer customer = customerDao.GetById(TestGlobals.TestCustomer.ID, false); // Give the customer its DAO dependency via a public setter customer.OrderDao = daoFactory.GetOrderDao(); IList<Order> ordersMatchingDate = customer.GetOrdersOrderedOn(new DateTime(1998, 3, 10)); Assert.AreEqual(1, ordersMatchingDate.Count); Assert.AreEqual(10937, ordersMatchingDate[0].ID); }
private void DisplayCustomerToEdit() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); // No need to lock the customer since we're just viewing the data Customer customerToEdit = customerDao.GetById(Request.QueryString["customerID"], false); ShowCustomerDetails(customerToEdit); ShowPastOrders(customerToEdit); ShowProductsOrdered(customerToEdit); }
public void CanGetOrdersShippedTo() { IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); IOrderDao orderDao = daoFactory.GetOrderDao(); Customer customer = customerDao.GetById(TestGlobals.TestCustomer.ID, false); // Give the customer its DAO dependency via a public setter IList <Order> ordersMatchingDate = orderDao.GetOrdersOrderedOn(customer, new DateTime(1998, 3, 10)); Assert.AreEqual(1, ordersMatchingDate.Count); Assert.AreEqual(10937, ordersMatchingDate[0].ID); }
public static void persist(Playlist playlist, IList<Einsatz> einsaetze) { NHibernateDaoFactory daoFactory = new NHibernateDaoFactory(); IPlaylistDao playlistDao = daoFactory.getPlaylistDao(); ITrackDao trackDao = daoFactory.getTrackDao(); IEinsatzDao einsatzDao = daoFactory.getEinsatzDao(); playlistDao.save(playlist); foreach(Einsatz einsatz in einsaetze) { einsatz.Track = trackDao.save(einsatz.Track); einsatzDao.save(einsatz); } }
public virtual void init() { NHibernateDaoFactory df = new NHibernateDaoFactory(); this.view.AutorList = df.getAutorDao().getAllSortedBy(true, Autor.Property.Name.ToString()); this.view.BpmList = df.getBpmDao().getAllSortedBy(true, Bpm.Property.Value.ToString()); this.view.CodeList = df.getCodeDao().getAllSortedBy(true, Code.Property.Name.ToString()); this.view.EndingList = new List<Ending.Attribute>(Enum.GetValues(typeof(Ending.Attribute)) as IEnumerable<Ending.Attribute>); this.view.InterpretList = df.getInterpretDao().getAllSortedBy(true, Interpret.Property.Name.ToString()); this.view.LabelList = df.getLabelDao().getAllSortedBy(true, Label.Property.Name.ToString()); this.view.LaengeList = df.getLaengeDao().getAllSortedBy(true, Laenge.Property.Dauer.ToString()); this.view.TitelList = df.getTitelDao().getAllSortedBy(true, Titel.Property.Name.ToString()); this.view.VerlagList = df.getVerlagDao().getAllSortedBy(true, Verlag.Property.Name.ToString()); this.view.YearList = df.getYearDao().getAllSortedBy(true, Year.Property.Value.ToString()); }
public override void update() { Track original = dao.GetById(this.view.TrackToEditID, true); Track new1 = this.view.TrackToCreate; if(original.Equals(new1)) return; // Does edited track already exist? ICriteria c = NHibernateSessionManager.Instance.GetSession().CreateCriteria(typeof(Track)); c.Add(Example.Create(new1)).CreateCriteria("Autor").Add(Example.Create(new1.Autor)); c.Add(Example.Create(new1)).CreateCriteria("Bpm").Add(Example.Create(new1.Bpm).ExcludeNone()); c.Add(Example.Create(new1)).CreateCriteria("Interpret").Add(Example.Create(new1.Interpret)); c.Add(Example.Create(new1)).CreateCriteria("Label").Add(Example.Create(new1.Label)); c.Add(Example.Create(new1)).CreateCriteria("Code").Add(Example.Create(new1.Code)); c.Add(Example.Create(new1)).CreateCriteria("Laenge").Add(Example.Create(new1.Laenge)); c.Add(Example.Create(new1)).CreateCriteria("Titel").Add(Example.Create(new1.Titel)); c.Add(Example.Create(new1)).CreateCriteria("Verlag").Add(Example.Create(new1.Verlag)); c.Add(Example.Create(new1)).CreateCriteria("Year").Add(Example.Create(new1.Year).ExcludeNone()); c.Add(Expression.Eq("Ending.Value", new1.Ending.Value)); Track existing = c.UniqueResult<Track>(); if(existing != null) { foreach(Einsatz einsatz in original.Einsaetze) einsatz.Track = existing; } else { NHibernateDaoFactory df = new NHibernateDaoFactory(); if(!original.Autor.Equals(new1.Autor)) original.Autor = df.getAutorDao().save(new1.Autor); original.Bpm = df.getBpmDao().save(new1.Bpm); if(!original.Code.Equals(new1.Code)) original.Code = df.getCodeDao().save(new1.Code); if(!original.Interpret.Equals(new1.Interpret)) original.Interpret = df.getInterpretDao().save(new1.Interpret); if(!original.Label.Equals(new1.Label)) original.Label = df.getLabelDao().save(new1.Label); if(!original.Laenge.Equals(new1.Laenge)) original.Laenge = df.getLaengeDao().save(new1.Laenge); if(!original.Titel.Equals(new1.Titel)) original.Titel = df.getTitelDao().save(new1.Titel); if(!original.Verlag.Equals(new1.Verlag)) original.Verlag = df.getVerlagDao().save(new1.Verlag); original.Year = df.getYearDao().save(new1.Year); original.Ending.Value = new1.Ending.Value; } }
protected void btnAdd_OnClick(object sender, EventArgs e) { if (txtCustomerID.Text.Trim().Length == 5) { Customer newCustomer = new Customer(txtCompanyName.Text); newCustomer.SetAssignedIdTo(txtCustomerID.Text); newCustomer.ContactName = txtContactName.Text; IDaoFactory daoFactory = new NHibernateDaoFactory(); ICustomerDao customerDao = daoFactory.GetCustomerDao(); if (!IsDuplicateOfExisting(newCustomer, customerDao)) { customerDao.Save(newCustomer); Response.Redirect("ListCustomers.aspx?action=added"); } 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 you provide must be exactly 5 characters long.</span><br />Please change the ID and try again."; } }
public void replace(ISet<long> replaceable, long replacement) { ITrackDao trackDao = new NHibernateDaoFactory().getTrackDao(); Track substitue = trackDao.GetById(replacement, true); ISession s = NHibernateSessionManager.Instance.GetSession(); IList<Track> tracks = s.CreateQuery("from Track t where t.Id in (:idList)").SetParameterList("idList", replaceable).List<Track>(); IList<Einsatz> updateableEinsaetze = s.CreateQuery("from Einsatz e where e.Track in (:tracks)") .SetParameterList("tracks", tracks) .List<Einsatz>(); foreach(Einsatz einsatz in updateableEinsaetze) einsatz.Track = substitue; trackDao.commitChanges(); foreach(Track track in tracks) trackDao.delete(track); trackDao.commitChanges(); }
protected void Page_Load(object sender, EventArgs e) { if(IsPostBack) daoFactory = new NHibernateDaoFactory(); }