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