/// <summary>
/// Kullanıcı giriş yaptığında çalışır, ana sayfadaki haber kategorilerinin her biri için çağrılması gerekir.
/// </summary>
/// <param name="cat">string olarak gönderilen kategori ismi örneğin: "World"</param>
protected void NewsBoxSetUsr(string cat, string Langs)
{
var connection = WebConfigurationManager.ConnectionStrings["DBConnection"];
SqlConnection sc = new SqlConnection(connection.ConnectionString);
SqlCommand c = new SqlCommand("EXECUTE spViewNewsCatLangBeginAmount '" + cat + "', '" + Langs + "',1,6");
SqlDataReader r;
c.Connection = sc;
try
{
sc.Open();
r = c.ExecuteReader();
if (cat == "World")
{
RepeaterWorld.DataSource = r;
RepeaterWorld.DataBind();
}
else if (cat == "Business")
{
RepeaterBusiness.DataSource = r;
RepeaterBusiness.DataBind();
}
else if (cat == "Technology")
{
RepeaterTech.DataSource = r;
RepeaterTech.DataBind();
}
else if (cat == "Science")
{
RepeaterScience.DataSource = r;
RepeaterScience.DataBind();
}
else if (cat == "Health")
{
RepeaterHealth.DataSource = r;
RepeaterHealth.DataBind();
}
else if (cat == "Video")
{
RepeaterVideo.DataSource = r;
RepeaterVideo.DataBind();
}
else if (cat == "Sport")
{
RepeaterSport.DataSource = r;
RepeaterSport.DataBind();
}
r.Close();
}
catch (SqlException ex)
{
Response.Write("Error!" + ex.Message);
}
finally
{
sc.Close();
sc.Dispose();
}
}
private void HealthBinding()
{
HealthCount = _query.HealthNewsCount();
if (FavorableCount > 0)
{
var health = _query.HealthNews(5, 1);
RepeaterHealth.DataSource = from it in health
select new { it.Title };
RepeaterHealth.DataBind();
}
}
