public SuRTENodeSearchResult GetWelcome(short languageId, string nodeType) { StringBuilder strQuery = new StringBuilder(); strQuery.AppendLine(" SELECT n.NodeId,n.NodeHeaderId,n.NodeOrderNo,c.languageId,n.NodeType,c.Header,c.Content,n.ImagePath"); strQuery.AppendLine(" From SuRTENode n "); strQuery.AppendLine("LEFT JOIN SuRTEContent c on c.nodeid = n.nodeid "); strQuery.AppendLine(" WHERE c.LanguageID = :LanguageID and n.nodetype = :NodeType "); strQuery.AppendLine(" AND n.Active = 'TRUE' "); strQuery.AppendLine(" ORDER BY n.NodeHeaderId,n.NodeOrderNo"); ISQLQuery query = GetCurrentSession().CreateSQLQuery(strQuery.ToString()); query.SetInt16("LanguageID", languageId); query.SetString("NodeType", nodeType); query.AddScalar("NodeId", NHibernateUtil.Int16); query.AddScalar("NodeHeaderId", NHibernateUtil.Int16); query.AddScalar("NodeOrderNo", NHibernateUtil.Int16); query.AddScalar("languageId", NHibernateUtil.Int16); query.AddScalar("NodeType", NHibernateUtil.String); query.AddScalar("Header", NHibernateUtil.String); query.AddScalar("Content", NHibernateUtil.String); query.AddScalar("ImagePath", NHibernateUtil.String); SuRTENodeSearchResult node = query.SetResultTransformer(Transformers.AliasToBean(typeof(SuRTENodeSearchResult))).UniqueResult <SuRTENodeSearchResult>(); return(node);//query.SetResultTransformer(Transformers.AliasToBean(typeof(SuRTENodeSearchResult))).UniqueResult<SuRTENodeSearchResult>(); }
protected void rptContent_ItemDataBound(object source, RepeaterItemEventArgs e) { RepeaterItem item = e.Item; if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem) { LinkButton ctlContent = (LinkButton)item.FindControl("ctlContent"); Label ctlContentID = (Label)item.FindControl("ctlContentID"); Image ctlImage = (Image)item.FindControl("ctlImage"); SuRTENodeSearchResult suRTENode = (SuRTENodeSearchResult)item.DataItem; short nodeId = suRTENode.NodeId; short languageId = suRTENode.LanguageId; SuRTENode rteNode = SuRTENodeService.FindByIdentity(nodeId); string filePath = ParameterServices.FilePathService; string imageName = rteNode.ImagePath; ctlImage.ImageUrl = filePath + imageName; } }
protected void Page_Load(object sender, EventArgs e) { short languageId; if (!Page.IsPostBack) { // How to get language ID languageId = UserAccount.CurrentLanguageID; SuRTENodeSearchResult rteNode = SuRTENodeService.GetWelcome(languageId, "Welcome"); if (rteNode != null) { ctlHeader.Text = rteNode.Header; ctlContent.Text = rteNode.Content; } System.Drawing.Image image = System.Drawing.Image.FromFile(AppDomain.CurrentDomain.BaseDirectory + "\\App_Themes\\Default\\images\\Welcome.png"); ctlPanel.Width = image.Width; //ctlPanel.Height = image.Height; } }