static void Main(string[] args)
{
var list = new ListSolution();
list.ListOfElementsLinq();
// var column = new ColumnOutput();
//column.PrintDictionariesFE();
}
protected void Doldur(string Code)
{
if (Session["category"] != null)
{
int categoryID = Convert.ToInt32(Session["category"]);
int solutionID = (from s in db.Solution
where s.IsActive == true && s.CategoryID == categoryID
join l in db.Language on s.LanguageID equals l.ID
where l.Code == Code
select s.ID).FirstOrDefault();
if (solutionID == 0)
{
Code = "tr-TR";
}
ListSolution.DataSource = (from s in db.Solution
where s.IsActive == true && s.CategoryID == categoryID
join l in db.Language on s.LanguageID equals l.ID
where l.Code == Code
select s).ToList();
}
else
{
int solutionID = (from s in db.Solution
where s.IsActive == true
join l in db.Language on s.LanguageID equals l.ID
where l.Code == Code
select s.ID).FirstOrDefault();
if (solutionID == 0)
{
Code = "tr-TR";
}
ListSolution.DataSource = (from s in db.Solution
where s.IsActive == true
join l in db.Language on s.LanguageID equals l.ID
where l.Code == Code
select s).ToList();
}
ListSolution.DataBind();
Session["category"] = null;
}
protected void Doldur(string code, int ID)
{
ListService.DataSource = (from s in db.Services
where s.IsActive == true
join l in db.Language on s.LanguageID equals l.ID
where l.Code == code
orderby s.ID ascending
select new
{
BigWriting = (s.BigWriting.Length > 150) ? s.BigWriting.Substring(0, 149) : s.BigWriting,
Title = s.Title,
Img = s.Image
}).Take(4).ToList();
ListService.DataBind();
listReferance.DataSource = (from r in db.Referance
where r.IsActive == true
join l in db.Language on r.LanguageID equals l.ID
where l.Code == code
select r).ToList();
listReferance.DataBind();
ListNews.DataSource = (from n in db.News
where n.IsActive == true
join l in db.Language on n.LanguageID equals l.ID
where l.Code == code
orderby n.ID descending
select new
{
SmallWriting = (n.SmallWriting.Length > 150) ? n.SmallWriting.Substring(0, 149) : n.SmallWriting,
Title = n.Title,
Image = n.Image,
ID = n.ID
}).Take(3).ToList();
ListNews.DataBind();
ListSolution.DataSource = (from s in db.Solution
where s.IsActive == true
join l in db.Language on s.LanguageID equals l.ID
where l.Code == code
orderby s.ID ascending
select new
{
Title = s.Title,
SmallWriting = (s.SmallWriting.Length > 150) ? s.SmallWriting.Substring(0, 149) : s.SmallWriting
}).Take(4).ToList();
ListSolution.DataBind();
int firstSliderID = (from s in db.Slider
where s.IsActive == true
join l in db.Language on s.LanguageID equals l.ID
where l.Code == code
select s.ID).FirstOrDefault();
AnalitikBilisimSite.Model.Entities.Slider slider1 = (from s in db.Slider where s.ID == (firstSliderID) && s.IsActive == true && s.LanguageID == ID select s).FirstOrDefault();
AnalitikBilisimSite.Model.Entities.Slider slider2 = (from s in db.Slider where s.ID == (firstSliderID + 1) && s.IsActive == true && s.LanguageID == ID select s).FirstOrDefault();
AnalitikBilisimSite.Model.Entities.Slider slider3 = (from s in db.Slider where s.ID == (firstSliderID + 2) && s.IsActive == true && s.LanguageID == ID select s).FirstOrDefault();
ImageSlider1.ImageUrl = slider1.SliderURL;
lblSliderTitle1.Text = slider1.sliderTitle;
lblSliderWriting1.Text = slider1.SliderWriting;
ImageSlider2.ImageUrl = slider2.SliderURL;
lblSliderTitle2.Text = slider2.sliderTitle;
lblSliderWriting2.Text = slider2.SliderWriting;
ImageSlider3.ImageUrl = slider3.SliderURL;
lblSliderTitle3.Text = slider3.sliderTitle;
lblSliderWriting3.Text = slider3.SliderWriting;
}
