/// <DeleteDiscoverySearchByUserid>
/// Delete DiscoverySearch from database by userId(Guid)
/// </summary>
/// <param name="userid">UserId of DiscoverySearch(Guid)</param>
/// <returns>Return integer 1 for true 0 for false</returns>
public int DeleteDiscoverySearchByUserid(Guid userid)
{
//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())
{
try
{
//Proceed action to delete discoverysearch by userid.
NHibernate.IQuery query = session.CreateQuery("delete from DiscoverySearch where UserId = :userid")
.SetParameter("userid", userid);
int isUpdated = query.ExecuteUpdate();
transaction.Commit();
return(isUpdated);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
} //End Transaction
} //End session
}
/// <deleteTask>
/// Delete Task
/// </summary>
/// <param name="taskid">Task id.(String)</param>
/// <param name="userid">User id.(Guid)</param>
/// <returns>Return 1 for true and 0 for false.(int)</returns>
public int deleteTask(string taskid, Guid userid)
{
//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())
{
try
{
//Proceed action, to delete task by task id and user id.
NHibernate.IQuery query = session.CreateQuery("delete from Task where Id = :taskid and UserId = :userid")
.SetParameter("taskid", taskid)
.SetParameter("userid", userid);
int isUpdated = query.ExecuteUpdate();
transaction.Commit();
return(isUpdated);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
} //End Transaction
} //End Session
}
public int DeleteTaskOfGroup(Guid groupId)
{
//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 task of user by groupId.
NHibernate.IQuery query = session.CreateQuery("delete from Tasks where GroupId = :GroupId")
.SetParameter("GroupId", groupId);
int isUpdated = query.ExecuteUpdate();
transaction.Commit();
return(isUpdated);
}
}
}
public int DeleteUserByUserid(Guid userid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("delete from User where Id = :userid")
.SetParameter("userid", userid);
int isUpdated = query.ExecuteUpdate();
transaction.Commit();
return(isUpdated);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
}
}
}
