public void Copy(int YearFrom, int YearTo, string type) { ISQLQuery query = GetCurrentSession().CreateSQLQuery("exec [dbo].[CopyHolidayProfile] :yearFrom , :yearTo , :type "); query.SetInt32("yearFrom", YearFrom); query.SetInt32("yearTo", YearTo); query.SetString("type", type); query.AddScalar("count", NHibernateUtil.Int32).UniqueResult(); }
public WorkFlowStateEvent GetSendDraftStateEvent(int workFlowTypeID) { StringBuilder strQuery = new StringBuilder(); strQuery.AppendLine(" select workflowstateevent.* "); strQuery.AppendLine(" from workflowstateevent "); strQuery.AppendLine(" inner join workflowstate "); strQuery.AppendLine(" on workflowstate.workflowstateid = workflowstateevent.workflowstateid "); strQuery.AppendLine(" where workflowstate.workflowtypeid = :workFlowTypeID "); strQuery.AppendLine(" and workflowstate.name = 'Draft' "); strQuery.AppendLine(" and workflowstateevent.name = 'Send' "); ISQLQuery query = GetCurrentSession().CreateSQLQuery(strQuery.ToString()); query.SetInt32("workFlowTypeID", workFlowTypeID); query.AddEntity(typeof(WorkFlowStateEvent)); IList <WorkFlowStateEvent> list = query.List <WorkFlowStateEvent>(); if (list != null) { return(list[0]); } else { return(null); } }
public IList <WorkFlowStateEventWithLang> FindByWorkFlowStateEventByStateID(int workFlowStateID, short languageID) { StringBuilder strQuery = new StringBuilder(); strQuery.AppendLine(" SELECT wse.WorkFlowStateEventID as EventID , wse.Name , wsel.DisplayName , wse.UserControlPath "); strQuery.AppendLine(" FROM WorkFlowState ws "); strQuery.AppendLine(" INNER JOIN WorkFlowStateEvent wse "); strQuery.AppendLine(" ON ws.WorkFlowStateID = wse.WorkFlowStateID "); strQuery.AppendLine(" INNER JOIN WorkFlowStateEventLang wsel "); strQuery.AppendLine(" ON wse.WorkFlowStateEventID = wsel.WorkFlowStateEventID AND wsel.LanguageID = :LanguageID "); strQuery.AppendLine(" WHERE ws.WorkFlowStateID = :WorkFlowStateID"); strQuery.AppendLine(" AND ws.Active = '1'"); strQuery.AppendLine(" AND wse.Active = '1'"); strQuery.AppendLine(" ORDER BY ws.Name "); ISQLQuery query = GetCurrentSession().CreateSQLQuery(strQuery.ToString()); query.SetInt16("LanguageID", languageID); query.SetInt32("WorkFlowStateID", workFlowStateID); query.AddScalar("EventID", NHibernateUtil.Int64); query.AddScalar("Name", NHibernateUtil.String); query.AddScalar("DisplayName", NHibernateUtil.String); query.AddScalar("UserControlPath", NHibernateUtil.String); query.SetResultTransformer(Transformers.AliasToBean(typeof(WorkFlowStateEventWithLang))); return(query.List <WorkFlowStateEventWithLang>()); }
public bool CheckDay(DateTime checkDay, string type) { StringBuilder sql = new StringBuilder(); sql.Append("SELECT count(*) as Count FROM DbHolidayProfile hp INNER JOIN DbHoliday h ON hp.Id = h.HolidayProfileId where hp.IsApprove = 1 AND hp.Year = :Year AND h.Date = :Date AND hp.Type = :Type"); ISQLQuery query = GetCurrentSession().CreateSQLQuery(sql.ToString()); query.SetInt32("Year", checkDay.Year); query.SetDateTime("Date", checkDay.Date); query.SetString("Type", type); query.AddScalar("Count", NHibernateUtil.Int32); int count = query.UniqueResult <Int32>(); if (count > 0 || (checkDay.DayOfWeek == DayOfWeek.Saturday || checkDay.DayOfWeek == DayOfWeek.Sunday)) { return(true); } return(false); }
public IList <WorkFlowStateEvent> FindWorkFlowStateEvent(string WorkFlowStateName, string WorkFlowStateEventName, int WorkFlowTypeID) { StringBuilder strQuery = new StringBuilder(); strQuery.AppendLine(" SELECT t2.WorkFlowStateEventID AS WorkFlowStateEventID "); strQuery.AppendLine(" FROM WorkFlowState t1 "); strQuery.AppendLine(" INNER JOIN WorkFlowStateEvent t2 "); strQuery.AppendLine(" ON t1.WorkFlowStateID = t2.WorkFlowStateID "); strQuery.AppendLine(" WHERE t1.[Name] = :WorkFlowStateEventName "); strQuery.AppendLine(" AND t2.[Name] = :WorkFlowStateName "); strQuery.AppendLine(" AND t1.WorkFlowTypeID = :WorkFlowTypeID "); ISQLQuery query = GetCurrentSession().CreateSQLQuery(strQuery.ToString()); query.SetString("WorkFlowStateName", WorkFlowStateName); query.SetString("WorkFlowStateEventName", WorkFlowStateEventName); query.SetInt32("WorkFlowTypeID", WorkFlowTypeID); query.AddScalar("WorkFlowStateEventID", NHibernateUtil.Int32); query.SetResultTransformer(Transformers.AliasToBean(typeof(WorkFlowStateEvent))); return(query.List <WorkFlowStateEvent>()); }