public List <Domain.Socioboard.Domain.Tasks> getAllTasksOfUserBYDays(Guid Userid, Guid GroupId, int days)
{
List <Domain.Socioboard.Domain.Tasks> alstTask = new List <Domain.Socioboard.Domain.Tasks>();
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())
{
DateTime AssignDate = DateTime.Now;
string AssinDate = AssignDate.AddDays(-days).ToString("yyyy-MM-dd HH:mm:ss");
//Proceed action, to get all task of user.
//NHibernate.IQuery query = session.CreateQuery("from Tasks where (UserId = :Userid or AssignTaskTo =:Userid) and GroupId =:GroupId and AssignDate>=DATE_ADD(NOW(),INTERVAL -" + days + " DAY)");
NHibernate.IQuery query = session.CreateQuery("from Tasks where UserId = :Userid and GroupId =:GroupId and AssignDate>=:AssinDate");
query.SetParameter("Userid", Userid);
query.SetParameter("GroupId", GroupId);
query.SetParameter("AssinDate", AssinDate);
foreach (var item in query.Enumerable())
{
alstTask.Add((Domain.Socioboard.Domain.Tasks)item);
}
} //End Transaction
} //End Session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(alstTask);
}
public List <User> getAllUsers()
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from User where Id !=null");
List <User> alstUser = new List <User>();
foreach (User item in query.Enumerable())
{
alstUser.Add(item);
}
return(alstUser);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
//public ArrayList getAllTasksOfUser(Guid UserId)
//{
// ArrayList alstTask = new ArrayList();
// 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 get all task of user.
// NHibernate.IQuery query = session.CreateQuery("from Tasks where UserId = :UserId and AssignTaskTo !=:UserId");
// query.SetParameter("UserId", UserId);
// query.SetParameter("UserId", UserId);
// //query.SetParameter("GroupId", GroupId);
// foreach (var item in query.Enumerable())
// {
// alstTask.Add(item);
// }
// }//End Transaction
// }//End Session
// }
// catch (Exception ex)
// {
// Console.WriteLine("Error : " + ex.StackTrace);
// }
// return alstTask;
//}
public ArrayList getAllTasksOfUser(Guid UserId)
{
ArrayList alstTask = new ArrayList();
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 get all task of user.
NHibernate.IQuery query = session.CreateQuery("from Tasks where UserId = :UserId ");
query.SetParameter("UserId", UserId);
query.SetParameter("UserId", UserId);
//query.SetParameter("GroupId", GroupId);
foreach (var item in query.Enumerable())
{
alstTask.Add(item);
}
} //End Transaction
} //End Session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(alstTask);
}
public ArrayList getAllIncompleteTasksOfUsers(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())
{
//Proceed action, to get values by user id and where status is zero.
NHibernate.IQuery query = session.CreateQuery("from Tasks where AssignTaskTo = :userid and TaskStatus = 0 and UserId!=:UserId");
query.SetParameter("userid", UserId);
query.SetParameter("UserId", UserId);
ArrayList alstTask = new ArrayList();
foreach (var item in query.Enumerable())
{
alstTask.Add(item);
}
return(alstTask);
} //End Transaction
} //End Session
}
// Edited by Antima
public bool isKeywordPresentforNetwork(string keyword, string Network)
{
//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 check if keyword is present in database or not.
// And Set the reuired paremeters to find the specific values.
NHibernate.IQuery query = session.CreateQuery("from DiscoverySearch where SearchKeyword = :keyword and Network = :Network");
query.SetParameter("keyword", keyword);
query.SetParameter("Network", Network);
List <Domain.Socioboard.Domain.DiscoverySearch> lst = new List <Domain.Socioboard.Domain.DiscoverySearch>();
foreach (Domain.Socioboard.Domain.DiscoverySearch item in query.Enumerable())
{
lst.Add(item);
}
if (lst.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End session
}
/// <getAllTasksCommentOfUser>
/// Get All Tasks Comment Of User
/// </summary>
/// <param name="UserId">User id.(Guid)</param>
/// <param name="TaskId">Task id.(Guid)</param>
/// <returns>Return Array list with value.(ArrayList)</returns>
public ArrayList getAllTasksCommentOfUser(Guid TaskId)
{
//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 get Task comments by user id and task id.
NHibernate.IQuery query = session.CreateQuery("from TaskComment where TaskId=:taskid");
// query.SetParameter("userid", UserId);
query.SetParameter("taskid", TaskId);
ArrayList alstTaskcomment = new ArrayList();
foreach (var item in query.Enumerable())
{
alstTaskcomment.Add(item);
}
return(alstTaskcomment);
} //End Transaction
} //End Session
}
/// <getAllTasksOfUserByStatus>
/// Get all tasks of user by status.
/// </summary>
/// <param name="UserId">User id.(Guid)</param>
/// <param name="status">Status.(bool)</param>
/// <returns>Return values in the form of array list.(ArrayList)</returns>
public ArrayList getAllTasksOfUserByStatus(Guid UserId, bool status)
{
//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 get Tasks by user id and task status.
NHibernate.IQuery query = session.CreateQuery("from Tasks where UserId = :userid and TaskStatus=:TaskStatus");
query.SetParameter("userid", UserId);
query.SetParameter("TaskStatus", status);
ArrayList alstTask = new ArrayList();
foreach (var item in query.Enumerable())
{
alstTask.Add(item);
}
return(alstTask);
} //End Transaction
} //End Session
}
/// <getAllMyTasksOfUser>
/// Get All My Tasks Of User
/// </summary>
/// <param name="UserId">User id.(Guid)</param>
/// <param name="AssignTo">Assign to.(Guid)</param>
/// <returns>Return values in the form of array list.(ArrayList)</returns>
public ArrayList getAllMyTasksOfUser(Guid AssignTo, 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 get values by user id and assign task to.
NHibernate.IQuery query = session.CreateQuery("from Tasks where AssignTaskTo=:AssignTo and GroupId=:GroupId");
//query.SetParameter("userid", UserId);
query.SetParameter("AssignTo", AssignTo);
query.SetParameter("GroupId", GroupId);
ArrayList alstTask = new ArrayList();
foreach (var item in query.Enumerable())
{
alstTask.Add(item);
}
return(alstTask);
} //End Transaction
} //End Session
}
