public static List <NewsStruct> selectAll()
{
List <NewsStruct> SDML = new List <NewsStruct>();
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = connection;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GET_NEWS";
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
NewsStruct SDM = new NewsStruct();
SDM.ID = (long)reader["ID"];
SDM.Headline = (string)reader["Headline"];
SDM.FullNewsLink = (string)reader["FullNewsLink"];
SDM.NewsContent = (string)reader["NewsContent"];
SDM.Source = (string)reader["Source"];
SDM.DateTimeUpdate = (DateTime)reader["DateTimeUpdate"];
SDML.Add(SDM);
}
connection.Close();
}
return(SDML);
}
private void ShowNews()
{
BottomMenu.SetActive(false);
choosenNews = thisRT.gameObject.GetComponentInParent <NewsStruct>();
initNews = Instantiate(newsPrefab, MENU.transform);
fullPage = initNews.GetComponent <FullNewsPage>();
fullPage.mainImage.sprite = choosenNews.mainImage.sprite;
fullPage.mainText.text = choosenNews.headerText.text;
fullPage.backButton.onClick.AddListener(StartGetBack);
fullPage.UpdatePage(choosenNews.link);
Vector3 needsPos = new Vector3(-1080, 0, 0f);
initNews.transform.localPosition = needsPos;
StartCoroutine(GoToScreen());
}
public void CreatePrefabs()
{
for (int i = 0; i < objectList.Count - 1; i++)
{
tableTags[i] = Regex.Split((string)objectList[i], @"(?<=[>])");
prefabs[i] = Instantiate(tablePrefab, tablePrefab.transform.localPosition, Quaternion.identity, content.transform);
}
for (int i = 0; i < objectList.Count - 1; i++)
{
prefabContent = prefabs[i].GetComponent <NewsStruct>();
for (int j = 0; j < tableTags[i].Length; j++)
{
if (tableTags[i][j].Contains("banner block-banner"))
{
continue;
}
if (tableTags[i][j].Contains("href")) // link
{
string[] temp = Regex.Split(tableTags[i][j], "href=\"");
string dis = temp[1].Substring(0, temp[1].Length - 2);
prefabContent.link = dis;
}
if (tableTags[i][j].Contains("item-news-bg")) // Main Image
{
string[] temp = Regex.Split(tableTags[i][j], "http");
string link = "http" + temp[1];
link = link.Substring(0, link.Length - 4);
byte[] image = webSite.DownloadData(link);
Texture2D texture = new Texture2D(350, 300);
texture.LoadImage(image);
Sprite mySprite = Sprite.Create(texture, new Rect(0.0f, 0.0f, texture.width, texture.height), new Vector2(0.5f, 0.5f), 100.0f);
prefabContent.mainImage.sprite = mySprite;
}
if (tableTags[i][j].Contains("icon-discipline")) // Discipline
{
string[] temp = Regex.Split(tableTags[i][j], "data-game=\"");
string dis = temp[1].Substring(0, temp[1].Length - 2);
ChangeSprite(prefabContent.gameImage, dis);
}
if (tableTags[i][j].Contains("header-item-news")) // Header Text
{
string temp = tableTags[i][j + 1];
temp = temp.Substring(0, temp.Length - 7);
prefabContent.headerText.text = temp;
}
if (tableTags[i][j].Contains("description-news")) // Description
{
string temp = tableTags[i][j + 1];
temp = temp.Substring(0, temp.Length - 7);
prefabContent.contentText.text = temp;
}
if (tableTags[i][j].Contains("data-news")) // Time
{
string temp = tableTags[i][j + 1];
string time = temp.Substring(0, temp.Length - 7);
prefabContent.timeText.text = time;
}
}
}
}
