/// <Delete> /// Delete a Blog_Comments from Database by Id. /// </summary> /// <param name="blog_Comments">The object of the Blog_Comments class(Domain.Blog_Comments)</param> /// <returns>Integer</returns> public int Delete(Blog_Comments blog_Comments) { int delete = 0; try { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //Proceed action, to Delete session.Delete(blog_Comments.Id); transaction.Commit(); delete = 1; } //End Trsaction } //End session } catch (Exception ex) { Console.WriteLine("Error : " + ex.StackTrace); } return(delete); }
public bool removeIstruttore(Istruttore i) { // elimina i collegamenti coi corsi che tiene Corso[] corsi_che_tiene = i.Corsi.ToArray(); foreach (Corso c in corsi_che_tiene) { c.Istruttori.Remove(i); i.Corsi.Remove(c); } istruttori.Remove(i); using (NHibernate.ISession session = HibernateHelper.Open()) using (NHibernate.ITransaction transaction = session.BeginTransaction()) try { foreach (Corso c in corsi_che_tiene) { session.SaveOrUpdate(c); } session.SaveOrUpdate(i); session.Delete(i); transaction.Commit(); return(true); } catch (Exception exc) { Log.Instance.WriteLine(Log.LogLevel.Error, "instance::removeIstruttore(" + (i != null ? i.ID.ToString() : "null") + "):" + exc.Message); return(false); } }
public void DeleteAllList <T>(IList item) where T : class, new() { try { using (NHibernate.ISession session = SessionFactory.GetNewSession(_env)) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { foreach (var temp in item) { session.Delete(temp); } transaction.Commit(); } } } catch (Exception ex) { _logger.LogCritical(ex.Message); _logger.LogError(ex.StackTrace); if (ex.InnerException != null) { _logger.LogError(ex.InnerException.Message); _logger.LogError(ex.InnerException.StackTrace); } } }
public void Delete <T>(T item) where T : class, new() { try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { session.Delete(item); transaction.Commit(); } } } catch (Exception ex) { //_logger.LogCritical(ex.Message); //_logger.LogError(ex.StackTrace); //if (ex.InnerException != null) //{ // _logger.LogError(ex.InnerException.Message); // _logger.LogError(ex.InnerException.StackTrace); //} } // throw new NotImplementedException(); }
public void Remove(Guid id) { Contact contactEntity = session.Get <Contact>(id); if (contactEntity != null) { session.Delete(contactEntity); } }
public void Delete(int id) { using (var transaction = _session.BeginTransaction()) { var foo = _session.Get <Foo>(id); _session.Delete(foo); transaction.Commit(); } }
public static void Delete(Product student) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { session.Delete(student); transaction.Commit(); } } }
public static bool deleteIscrizione(Iscrizione p) { using (NHibernate.ISession session = HibernateHelper.Open()) using (NHibernate.ITransaction transaction = session.BeginTransaction()) try { session.Delete(p); transaction.Commit(); return(true); } catch (Exception exc) { Log.Instance.WriteLine(Log.LogLevel.Error, "deleteIscrizione(" + (p != null ? p.ID.ToString() : "null") + "):" + exc.Message); return(false); } }
public void Delete(Account acc) { try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { session.Delete(acc.UserName); transaction.Commit(); } } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }
public void Delete(faceboardpro.Domain.Captcha captcha) { try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { session.Delete(captcha.CaptchaService); transaction.Commit(); } } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }
/// <summary> /// Delete the Elements from the Database /// according to the Object /// </summary> public static void Delete <T>(T newObject) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { session.Delete(newObject); transaction.Commit(); } catch (Exception) { throw; } } } }
public static bool deletePersona(Persona p) { using (NHibernate.ISession session = HibernateHelper.Open()) using (NHibernate.ITransaction transaction = session.BeginTransaction()) try { session.Delete(p); transaction.Commit(); return(true); } catch (Exception exc) { Log.Instance.WriteLine(Log.LogLevel.Error, "deletePersona(" + (p != null ? p.Nome ?? string.Empty + " " + p.Cognome ?? string.Empty : "null") + "):" + exc.Message); return(false); } }
public bool Delete(ContatoEntitis contatoToBeDelete) { try { using (NHibernate.ISessionFactory sessionFactory = SessionFactoryBuilder.BuildSessionFactory()) { using (NHibernate.ISession session = sessionFactory.OpenSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { session.Delete(contatoToBeDelete); transaction.Commit(); } } } return(true); } catch (Exception ex) { throw; } }
/// <summary> /// Delete the Elements from the Database /// by Filteration /// </summary> public static int Delete <T>(Expression <Func <T, bool> > predicate) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { List <T> obj = GetAllByCondition(predicate); foreach (var item in obj) { session.Delete(item); } transaction.Commit(); return(obj.Count); } catch (Exception) { throw; } } } }
public List <ToolStripItem> LoadLayoutMenu() { var noDatabase = _session == null; var currentMenuLevel = new List <ToolStripItem>(); ToolStripMenuItem saveMenu; ToolStripMenuItem loadMenu; ToolStripMenuItem deleteMenu = null; var menuList = new List <ToolStripItem>(); #region Load Options //set up user load options foreach (var item in _userLayoutList) { var tempItem = item; var newOption = new ToolStripMenuItem { Text = item.Name + (CurrentLayout.Name == item.Name ? " (current)" : "") }; newOption.Click += (s, e) => CurrentLayout = tempItem; currentMenuLevel.Add(newOption); } //check if more needs to be done if (noDatabase) { loadMenu = new ToolStripMenuItem("Load", null, currentMenuLevel.ToArray()); } else { currentMenuLevel.Add(new ToolStripSeparator()); IList <LayoutProperty> databaseLayouts; lock (_session) databaseLayouts = _session.QueryOver <LayoutProperty>().List(); foreach (var item in databaseLayouts) { var tempItem = item; var newOption = new ToolStripMenuItem { Text = item.Name + (CurrentLayout.Name == item.Name ? " (current)" : "") }; newOption.Click += (s, e) => CurrentLayout = tempItem; currentMenuLevel.Add(newOption); } loadMenu = new ToolStripMenuItem("Load", null, currentMenuLevel.ToArray()); } #endregion #region Save Options //create user save list currentMenuLevel = new List <ToolStripItem>(); foreach (var item in _userLayoutList) { var tempItem = item; var newOption = new ToolStripMenuItem { Text = item.Name + (CurrentLayout.Name == item.Name ? " (current)" : "") }; newOption.Click += (s, e) => { var saveColumns = false; var formProperties = new Dictionary <string, FormProperty>(); if (MessageBox.Show("Save column settings as well?", "Save", MessageBoxButtons.YesNo) == DialogResult.Yes) { saveColumns = true; foreach (var form in _persistentForms) { formProperties[form.Name] = form.GetCurrentProperties(false); } } updateLayout(tempItem, saveColumns, false, formProperties); }; currentMenuLevel.Add(newOption); } //replace system default (not editable) with new layout option { var newLayout = new ToolStripMenuItem("New Local Layout"); newLayout.Click += (s, e) => { var textInput = new TextInputPrompt("Layout Name", true, string.Empty); if (textInput.ShowDialog() == DialogResult.OK) { var formProperties = new Dictionary <string, FormProperty>(); if (textInput.GetCheckState()) { foreach (var form in _persistentForms) { formProperties[form.Name] = form.GetCurrentProperties(false); } } saveNewLayout(textInput.GetText(), textInput.GetCheckState(), false, formProperties); } }; currentMenuLevel.RemoveAt(0); currentMenuLevel.Insert(0, newLayout); } //check if more needs to be done if (noDatabase) { saveMenu = new ToolStripMenuItem("Save", null, currentMenuLevel.ToArray()); } else { var currentDatabaseMenuLevel = new List <ToolStripItem>(); currentMenuLevel.Add(new ToolStripSeparator()); IList <LayoutProperty> databaseLayouts; lock (_session) databaseLayouts = _session.QueryOver <LayoutProperty>().List(); foreach (var item in databaseLayouts) { var newOption = new ToolStripMenuItem { Text = item.Name + (CurrentLayout.Name == item.Name ? " (current)" : "") }; LayoutProperty tempItem = item; newOption.Click += (s, e) => { var saveColumns = false; var formProperties = new Dictionary <string, FormProperty>(); if (MessageBox.Show("Save column settings as well?", "Save", MessageBoxButtons.YesNo) == DialogResult.Yes) { saveColumns = true; foreach (var form in _persistentForms) { formProperties[form.Name] = form.GetCurrentProperties(false); } } updateLayout(tempItem, saveColumns, true, formProperties); }; currentDatabaseMenuLevel.Add(newOption); } //Add new layout option { var newLayout = new ToolStripMenuItem("New Database Layout"); newLayout.Click += (s, e) => { var textInput = new TextInputPrompt("Layout Name", true, string.Empty); if (textInput.ShowDialog() == DialogResult.OK) { var formProperties = new Dictionary <string, FormProperty>(); if (textInput.GetCheckState()) { foreach (var form in _persistentForms) { formProperties[form.Name] = form.GetCurrentProperties(false); } } saveNewLayout(textInput.GetText(), textInput.GetCheckState(), true, formProperties); } }; currentDatabaseMenuLevel.Insert(0, newLayout); } currentMenuLevel.AddRange(currentDatabaseMenuLevel); saveMenu = new ToolStripMenuItem("Save", null, currentMenuLevel.ToArray()); } #endregion #region Delete Options //set up user delete options currentMenuLevel = new List <ToolStripItem>(); foreach (var item in _userLayoutList) { var tempItem = item; var newOption = new ToolStripMenuItem { Text = item.Name }; newOption.Click += (s, e) => { if (MessageBox.Show(string.Format("Are you sure you want to delete '{0}'?", tempItem.Name), "Delete", MessageBoxButtons.YesNo) == DialogResult.Yes) { _userLayoutList.Remove(tempItem); SaveUserLayoutList(); } }; currentMenuLevel.Add(newOption); } //Dont allow user to delete defaults currentMenuLevel.RemoveRange(0, 2); //dont delete if nothing to delete, but check for database first if (noDatabase) { deleteMenu = currentMenuLevel.Count > 0 ? new ToolStripMenuItem("Delete", null, currentMenuLevel.ToArray()) : null; } else { var currentDatabaseMenuLevel = new List <ToolStripItem>(); if (currentMenuLevel.Count > 0) { currentMenuLevel.Add(new ToolStripSeparator()); } IList <LayoutProperty> databaseLayouts; lock (_session) databaseLayouts = _session.QueryOver <LayoutProperty>().List(); foreach (var item in databaseLayouts) { var tempItem = item; var newOption = new ToolStripMenuItem { Text = item.Name }; newOption.Click += (s, e) => { if (MessageBox.Show(string.Format("Are you sure you want to delete '{0}'?", tempItem.Name), "Delete", MessageBoxButtons.YesNo) == DialogResult.Yes) { _session.Delete(tempItem); _session.Flush(); } }; currentDatabaseMenuLevel.Add(newOption); } currentDatabaseMenuLevel.RemoveAt(0); currentMenuLevel.AddRange(currentDatabaseMenuLevel); if (currentMenuLevel.Count > 0) { deleteMenu = new ToolStripMenuItem("Delete", null, currentMenuLevel.ToArray()); } } #endregion menuList.Add(saveMenu); menuList.Add(loadMenu); if (deleteMenu != null) { menuList.Add(deleteMenu); } return(menuList); }
private void _Delete(NHibernate.ISession session) { session.Delete(_resourceToDelete); }