/// <checkTaskExists>
/// checkTaskExists
/// </summary>
/// <param name="TaskId">Task id.(String)</param>
/// <param name="Userid">User id.(Guid)</param>
/// <returns>True and False.(bool)</returns>
public bool checkTaskExists(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 get task details by userid and task id.
NHibernate.IQuery query = session.CreateQuery("from Task where UserId = :userid and Id = :taskid");
query.SetParameter("userid", Userid);
query.SetParameter("taskid", TaskId);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
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 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);
}
/// <summary>
/// Gets the entity list from respersitory.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="hQuery">The hibernate query string.</param>
/// <param name="paras">The parameters in the query string,a dictionary,its key represent the parameter name,and its value is the parameter value.</param>
/// <returns></returns>
public IList <T> GetList <T>(string hQuery, Dictionary <string, object> paras)
{
try
{
OpenConnect();
Hib.IQuery query = _Session.CreateQuery(hQuery);
if (paras != null)
{
foreach (string key in paras.Keys)
{
query.SetParameter(key, paras[key]);
}
}
return(query.List <T>());
}
catch (Exception ex)
{
LogExepttion(ex);
throw;
}
finally
{
Disconnect();
}
}
public bool IsUserExist(string Emailid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from User u where u.EmailId = : email");
query.SetParameter("email", Emailid);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
}
}
}
/// <getTaskById>
/// Get Task By Id
/// </summary>
/// <param name="Taskid">Task id.(string)</param>
/// <param name="userId">User id.(Guid)</param>
/// <returns>Return object of Tasks Class with all Tasks info.(List<Tasks>)</returns>
public Domain.Socioboard.Domain.Tasks getTaskById(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())
{
//Proceed action, to get Account details by Fb user id and user id.
NHibernate.IQuery query = session.CreateQuery("from FacebookAccount where FbUserId = :Fbuserid and UserId=:userId");
query.SetParameter("Fbuserid", Taskid);
query.SetParameter("userId", userId);
Domain.Socioboard.Domain.Tasks result = (Domain.Socioboard.Domain.Tasks)query.UniqueResult();
return(result);
} //End Transaction
} //End Session
}
public IList FindByMainId(string id)
{
NHibernate.ISession session = HibernateTemplate.SessionFactory.OpenSession();
NHibernate.IQuery query = session.CreateQuery("from MasterInfo m where m.InfoCode=:infoCode");
query.SetParameter("infoCode", id);
return(query.List());
}
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
}
public User GetUserInfo(string EmailId, string Password)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from User u where u.EmailId = : email and u.Password= :password");
query.SetParameter("email", EmailId);
query.SetParameter("password", Password);
User result = (User)query.UniqueResult();
return(result);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
/// <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
}
public User getUsersById(Guid userId)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from User where Id =: userid");
query.SetParameter("userid", userId);
User usr = query.UniqueResult <User>();
return(usr);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
/// <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
}
