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