コード例 #1
0
        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);
        }
コード例 #2
0
        /// <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
        }
コード例 #3
0
 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);
             }
         }
     }
 }
コード例 #4
0
ファイル: NHibernateDAO.cs プロジェクト: ewin66/VilinCode
 /// <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();
     }
 }
コード例 #5
0
        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);
                    }
                }
            }
        }
コード例 #6
0
 /// <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
 }
コード例 #7
0
        //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);
        }
コード例 #8
0
        public ActionResult Registration(Models.RegistrationModel reg_model)
        {
            if (Session["session_key"] != null)
            {
                return(RedirectToAction("index"));
            }
            using (NHibernate.ISession session = NHibernateSessionManeger.OpenSession())
            {
                if (!ModelState.IsValid)
                {
                    return(View());
                }
                else
                {
                    NHibernate.IQuery query = session.CreateQuery("FROM Users WHERE name = '" + reg_model.Name + "'");
                    if (query.List <Models.Users>().Count() > 0)
                    {
                        ViewData["ErrorMessage"] = "    Пользователь с ником " + reg_model.Name + " уже занят   ";
                        return(View());
                    }

                    var usr = new Models.Users();
                    usr.Email = reg_model.Email;
                    usr.Name  = reg_model.Name;
                    var    salt             = Guid.NewGuid().ToByteArray();
                    string hashsed_password = Convert.ToBase64String(CryptSharp.Utility.SCrypt.ComputeDerivedKey(System.Text.UTF8Encoding.UTF8.GetBytes(reg_model.Password), salt, 16384, 8, 1, null, 128));
                    usr.HashPassword = hashsed_password;
                    usr.Salt         = Convert.ToBase64String(salt);
                    session.Save(usr);

                    return(RedirectToAction("authorization"));
                }
            }
        }
コード例 #9
0
        /// <summary>
        /// 通过EPCID查询
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="isSetSupplier"></param>
        /// <param name="isSetSpec"></param>
        /// <returns></returns>
        public AscmContainer GetByEpcId(string epcId, string sessionKey = null)
        {
            AscmContainer ascmContainer = null;

            try
            {
                NHibernate.ISession session = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession();
                if (sessionKey != null)
                {
                    session = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession(sessionKey);
                }
                NHibernate.IQuery query = session.CreateQuery("from AscmContainer where rfid='" + epcId + "' ");
                if (query.List().Count > 0)
                {
                    ascmContainer = query.UniqueResult <AscmContainer>();
                    if (!string.IsNullOrEmpty(ascmContainer.supplierId.ToString()))
                    {
                        ascmContainer.supplier = MideaAscm.Services.Base.AscmSupplierService.GetInstance().Get(ascmContainer.supplierId, sessionKey);
                    }
                    if (!string.IsNullOrEmpty(ascmContainer.specId.ToString()))
                    {
                        ascmContainer.containerSpec = MideaAscm.Services.SupplierPreparation.AscmContainerSpecService.GetInstance().Get(ascmContainer.specId, sessionKey);
                    }
                }
            }
            catch (Exception ex)
            {
                YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmContainer)", ex);
                throw ex;
            }
            return(ascmContainer);
        }
コード例 #10
0
 /// <summary>
 /// 得到最新的一次流转记录
 /// 根据EPCID得到
 /// </summary>
 /// <param name="strEpcId">根据EPCID</param>
 /// <returns></returns>
 public string Get(string strEpcId)
 {
     try
     {
         using (NHibernate.ISession session = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession())
         {
             if (session.IsOpen)
             {
                 NHibernate.IQuery query      = session.CreateQuery("from AscmTagLog where readTime in (select to_char(max(to_date(readTime,'yyyy-MM-dd HH24:mi:ss')),'yyyy-MM-dd HH24:mi:ss') from AscmTagLog  where epcId='" + strEpcId + "' ) and epcId='" + strEpcId + "' ");
                 AscmTagLog        ascmTagLog = query.UniqueResult <AscmTagLog>();
                 if (ascmTagLog != null)
                 {
                     object obj = YnDaoHelper.GetInstance().nHibernateHelper.GetObject("select address from AscmReadingHead  where id=" + ascmTagLog.readingHeadId + "");
                     ascmTagLog.place = obj.ToString();
                     return
                         (YnBaseClass2.Helper.ObjectHelper.Serialize <AscmTagLog>(ascmTagLog));
                 }
                 else
                 {
                     return(null);
                 }
             }
         }
     }
     catch (Exception ex)
     {
         YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmContainer)", ex);
         throw ex;
     }
     return(null);
 }
コード例 #11
0
        /// <summary>
        /// 普通查询
        /// </summary>
        /// <typeparam name="T">类型</typeparam>
        /// <param name="hql">查询语句</param>
        /// <returns></returns>
        public static List <T> GetEntitiesByHQL <T>(string hql)
        {
            BasicDataManipulation baseData = new BasicDataManipulation();
            ISession Session = baseData.GetSession();
            List <T> list    = new List <T>();

            if (Session == null)
            {
                throw new Exception("打开数据库连接失败!");
            }
            try
            {
                NHibernate.IQuery query = Session.CreateQuery(hql);
                list = query.List <T>().ToList();
                return(list);
            }
            catch (Exception ex)
            {
                LogAPI.Debug(ex);
                return(list);
            }
            finally
            {
                if (Session != null)
                {
                    Session.Dispose();
                    Session = null;
                }
            }
        }
コード例 #12
0
 /// <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
 }
コード例 #13
0
ファイル: MasterInfoDao.cs プロジェクト: patagoniahiker/aimns
        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());
        }
コード例 #14
0
        public IList <User> GetActorByRole(IEnumerable <string> ids)
        {
            using ISession session = DbFactory.OpenBussinessSession();

            NHibernate.IQuery query = session
                                      .GetNamedQuery("queryActorByRole");
            IList <User> users = query.SetParameterList("RIDS", ids).List <User>();

            return(users);
        }
コード例 #15
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <typeparam name="T">类型</typeparam>
        /// <param name="hql">查询语句</param>
        /// <param name="skip">页数</param>
        /// <param name="take">每页显示条数</param>
        /// <param name="count">总数</param>
        /// <returns></returns>
        public static List <T> GetEntitiesByHQL <T>(string hql, int skip, int take, out int count)
        {
            BasicDataManipulation baseData = new BasicDataManipulation();
            ISession Session = baseData.GetSession();
            List <T> list    = new List <T>();

            if (Session == null)
            {
                throw new Exception("打开数据库连接失败!");
            }
            try
            {
                NHibernate.IQuery query1   = Session.CreateQuery(hql);
                string            hqlcount = "";
                int fromIndex = hql.IndexOf("from");
                int toIndex   = hql.IndexOf("order");
                int len       = 0;
                if (toIndex == -1)
                {
                    hqlcount = "select count(*) " + hql.Substring(fromIndex);
                }
                else
                {
                    len      = toIndex - fromIndex;
                    hqlcount = "select count(*) " + hql.Substring(fromIndex, len);
                }
                NHibernate.IQuery querycount = Session.CreateQuery(hqlcount);
                try
                {
                    count = int.Parse(querycount.UniqueResult().ToString());
                }
                catch
                {
                    count = 0;
                }
                NHibernate.IQuery query = query1.SetFirstResult(skip).SetMaxResults(take);
                list = query.List <T>().ToList();
                return(list);
            }
            catch (Exception ex)
            {
                count = 0;
                LogAPI.Debug(ex);
                return(list);
            }
            finally
            {
                if (Session != null)
                {
                    Session.Dispose();
                    Session = null;
                }
            }
        }
コード例 #16
0
 public Dal.ContainerManage.Entities.AscmCheck Get()
 {
     Dal.ContainerManage.Entities.AscmCheck ack = null;
     try
     {
         NHibernate.IQuery query = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().CreateQuery("from AscmCheck where id in (select max(id) from AscmCheck)");
         ack = query.UniqueResult <Dal.ContainerManage.Entities.AscmCheck>();
     }
     catch (Exception ex)
     {
         YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmCheck)", ex);
         throw ex;
     }
     return(ack);
 }
コード例 #17
0
ファイル: Repository.cs プロジェクト: darkish101/Show_List
        public IEnumerable <T> Get(NHibernate.IQuery query, int baseIndex, short pageSize, out int count, string sortFieldName, SortDirection sortDirection)
        {
            count = query.List <T>().Count;

            //if pageSize>0 then do paging, otherwise no paging and all records will be displayed
            if (pageSize > 0)
            {
                query.SetFirstResult(baseIndex)
                .SetMaxResults(pageSize)
                .SetMaxResults(pageSize);
            }

            IList <T> result = query.List <T>();

            return(result);
        }
コード例 #18
0
 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);
         }
     }
 }
コード例 #19
0
 /// <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
 }
コード例 #20
0
ファイル: AscmRfidService.cs プロジェクト: wuhuayun/Midea
        /// <summary>
        /// 2013/07/17
        /// </summary>
        /// <param name="epc"></param>
        /// <returns></returns>
        public AscmRfid GetByEpc(string epcId)
        {
            AscmRfid ascmRfid = null;

            try
            {
                NHibernate.ISession session = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession();
                NHibernate.IQuery   query   = session.CreateQuery("from AscmRfid where epcId='" + epcId + "' ");
                ascmRfid = query.UniqueResult <AscmRfid>();
            }
            catch (Exception ex)
            {
                YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmRfid)", ex);
                throw ex;
            }
            return(ascmRfid);
        }
コード例 #21
0
ファイル: Repository.cs プロジェクト: darkish101/Show_List
        public IEnumerable <T> Get(NHibernate.IQuery query, int pageIndex, int pageSize, out int count, string sortFieldName, SortDirection sortDirection)
        {
            count = query.List <T>().Count;

            //if pageSize>0 then do paging, otherwise no paging and all records will be displayed
            if (pageSize > 0)
            {
                query.SetFirstResult((int)pageIndex * pageSize)
                .SetMaxResults(pageSize)
                .SetMaxResults(pageSize);
            }

            IList <T> result = query.List <T>();

            //var rowCount = query.SetFirstResult(0).FutureValue<Int32>();
            //count = rowCount.Value;
            return(result);
        }
コード例 #22
0
 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
 }
コード例 #23
0
 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);
             }
         }
     }
 }
コード例 #24
0
        // 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
        }
コード例 #25
0
 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);
             }
         }
     }
 }
コード例 #26
0
        /// <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
        }
コード例 #27
0
 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);
             }
         }
     }
 }
コード例 #28
0
        /// <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
        }
コード例 #29
0
        /// <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
        }
コード例 #30
0
 public ArrayList UnPaidUserCountByMonth()
 {
     using (NHibernate.ISession session = SessionFactory.GetNewSession())
     {
         using (NHibernate.ITransaction transaction = session.BeginTransaction())
         {
             ArrayList alstUser = new ArrayList();
             try
             {
                 NHibernate.IQuery query = session.CreateSQLQuery("Select month(CreateDate),Count(*) from User where PaymentStatus='unpaid' group by month(CreateDate)");
                 foreach (var item in query.List())
                 {
                     alstUser.Add(item);
                 }
                 return(alstUser);
             }
             catch (Exception Err)
             {
                 Console.Write(Err.StackTrace);
                 return(alstUser);
             }
         }
     }
 }