public static void save(bom Part) { // create our NHibernate session factory var sessionFactory = FluentNHibernate.CreateSessionFactory(); using (var session = sessionFactory.OpenSession()) { // retreive all stores and display them using (session.BeginTransaction()) { session.Save(Part); session.Transaction.Commit(); } } }
internal static void InsertPart(bom part) { // create our NHibernate session factory var sessionFactory = FluentNHibernate.CreateSessionFactory(); using (var session = sessionFactory.OpenSession()) { // retreive all stores and display them using (var transaction = session.BeginTransaction()) { session.SaveOrUpdate(part); transaction.Commit(); } } }
public static string saveAll(List<inventory> Inventory, string masterItem) { if (masterItem == "undefined") { masterItem = null; } // create our NHibernate session factory var sessionFactory = FluentNHibernate.CreateSessionFactory(); using (var session = sessionFactory.OpenSession()) { // retreive all stores and display them try{ using (session.BeginTransaction()) { IList<bom> BOM=null; if (masterItem != null) { BOM = session.CreateCriteria(typeof(bom)).List<bom>(); BOM = BOM.Where(x => x.item == masterItem).ToList(); } if(BOM!=null){ foreach (inventory item in Inventory) { bom bomItem = BOM.Where(x => x.component == item.item).FirstOrDefault(); if (bomItem == null && item.bomQty > 0) { bomItem = new bom(); bomItem.component = item.item; bomItem.qty = item.bomQty; bomItem.item = masterItem; session.Save(bomItem); } else if(item.bomQty>0) { bomItem.qty = item.bomQty; session.SaveOrUpdate(bomItem); } else if (item.bomQty==0 && bomItem != null) { var queryString = string.Format("delete {0} where id = :id", typeof(bom)); session.CreateQuery(queryString) .SetParameter("id", bomItem.id) .ExecuteUpdate(); } } } else { foreach (inventory item in Inventory) { session.SaveOrUpdate(item); } } session.Transaction.Commit(); return "Inventory saved. "; } } catch(Exception ex) { return "Inventory update FAILURE. " + ex.Message + ex.InnerException; } } }