public FrontItemsModel GetItemObject(int itemID, Languages langID) { FrontItemsModel item = null; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("dbo.New_Items_GetOneByID", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@ItemID", SqlDbType.Int, 4).Value = itemID; myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)langID; //--------------------------------------------------------------------- //--------------------------------------------------------------------- // Execute the command myConnection.Open(); using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection)) { while (dr.Read()) { item = (FrontItemsModel)GetEntity(dr, typeof(FrontItemsModel)); } dr.Close(); } myConnection.Close(); return(item); } }
public void BuilDetailsPathesLinks(ItemsModulesOptions currentModule, FrontItemsModel currentItem) { string homeText = (string)HttpContext.GetGlobalResourceObject("Modules", "_Home"); string moduleTitle = currentModule.GetModuleTitle(); this.AddLink(homeText, "/"); this.AddLink(moduleTitle, string.Format("/{0}/all", currentModule.Identifire)); this.AddLastTitle(currentItem.Title); this.PageTitle = currentItem.Title; this.TopHeader = moduleTitle; }
//----------------------------------------------------------- public void LoadItem() { //------------------------------------------------------------------------ Languages langID = SiteSettings.GetCurrentLanguage(); RequiredItem = FrontItemsController.GetItemObject(ItemID, langID); if (RequiredItem != null && RequiredItem.IsAvailable) { this.Visible = true; } else { this.Visible = false; } //---------------------------------------------- }