/// <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);
}