public List <Entity_title> gettitle(string _sNews_Seo_Url)
{
try
{
List <Entity_title> l = new List <Entity_title>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where c.CAT_SEO_URL == _sNews_Seo_Url
select new { b.NEWS_TITLE, c.CAT_NAME }).ToList();
if (list.Count > 0)
{
foreach (var i in list)
{
Entity_title t = new Entity_title();
t.Cat_name = i.CAT_NAME;
t.News_title = i.NEWS_TITLE;
l.Add(t);
}
}
else
{
var list2 = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where b.NEWS_SEO_URL == _sNews_Seo_Url
select new { b.NEWS_TITLE, c.CAT_NAME }).ToList();
foreach (var i in list2)
{
Entity_title t = new Entity_title();
t.Cat_name = i.CAT_NAME;
t.News_title = i.NEWS_TITLE;
l.Add(t);
}
}
return(l);
}
catch (Exception)
{
throw;
}
}
public List<Entity_title> gettitle(string _sCatSeoUrl, string _sNews_Seo_Url)
{
try
{
List<Entity_title> l = new List<Entity_title>();
if (_sCatSeoUrl != "")
{
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where c.CAT_SEO_URL == _sCatSeoUrl
select new { b.NEWS_TITLE, c.CAT_NAME }).ToList();
foreach (var i in list)
{
Entity_title t = new Entity_title();
t.Cat_name = i.CAT_NAME;
t.News_title = i.NEWS_TITLE;
l.Add(t);
}
}
else
{
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where b.NEWS_SEO_URL == _sNews_Seo_Url
select new { b.NEWS_TITLE, c.CAT_NAME }).ToList();
foreach (var i in list)
{
Entity_title t = new Entity_title();
t.Cat_name = i.CAT_NAME;
t.News_title = i.NEWS_TITLE;
l.Add(t);
}
}
return l;
}
catch (Exception)
{
throw;
}
}
public List<Entity_title> gettitle(string _sNews_Seo_Url)
{
try
{
List<Entity_title> l = new List<Entity_title>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where c.CAT_SEO_URL == _sNews_Seo_Url
select new { b.NEWS_TITLE, c.CAT_NAME,b.NEWS_UPDATE,b.NEWS_PUBLISHDATE}).ToList();
if (list.Count > 0)
{
foreach (var i in list)
{
Entity_title t = new Entity_title();
t.Cat_name = i.CAT_NAME;
t.News_title = i.NEWS_TITLE;
if(i.NEWS_UPDATE.ToString()!=string.Empty&&i.NEWS_UPDATE!=null)
t.New_update = DateTime.Parse(i.NEWS_UPDATE.ToString()).ToString("dd/MM/yyyy");
else
t.New_update = DateTime.Parse(i.NEWS_PUBLISHDATE.ToString()).ToString("dd/MM/yyyy");
l.Add(t);
}
}
else
{
var list2 = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where b.NEWS_SEO_URL == _sNews_Seo_Url
select new { b.NEWS_TITLE, c.CAT_NAME, b.NEWS_UPDATE, b.NEWS_PUBLISHDATE }).ToList();
foreach (var i in list2)
{
Entity_title t = new Entity_title();
t.Cat_name = i.CAT_NAME;
t.News_title = i.NEWS_TITLE;
if (i.NEWS_UPDATE.ToString() != string.Empty && i.NEWS_UPDATE != null)
t.New_update = DateTime.Parse(i.NEWS_UPDATE.ToString()).ToString("dd/MM/yyyy");
else
t.New_update = DateTime.Parse(i.NEWS_PUBLISHDATE.ToString()).ToString("dd/MM/yyyy");
l.Add(t);
}
}
return l;
}
catch (Exception)
{
throw;
}
}
public List <Entity_title> gettitle(string _sNews_Seo_Url)
{
try
{
List <Entity_title> l = new List <Entity_title>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where c.CAT_SEO_URL == _sNews_Seo_Url
select new { b.NEWS_TITLE, c.CAT_NAME, b.NEWS_UPDATE, b.NEWS_PUBLISHDATE }).ToList();
if (list.Count > 0)
{
foreach (var i in list)
{
Entity_title t = new Entity_title();
t.Cat_name = i.CAT_NAME;
t.News_title = i.NEWS_TITLE;
if (i.NEWS_UPDATE.ToString() != string.Empty && i.NEWS_UPDATE != null)
{
t.New_update = DateTime.Parse(i.NEWS_UPDATE.ToString()).ToString("dd/MM/yyyy");
}
else
{
t.New_update = DateTime.Parse(i.NEWS_PUBLISHDATE.ToString()).ToString("dd/MM/yyyy");
}
l.Add(t);
}
}
else
{
var list2 = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where b.NEWS_SEO_URL == _sNews_Seo_Url
select new { b.NEWS_TITLE, c.CAT_NAME, b.NEWS_UPDATE, b.NEWS_PUBLISHDATE }).ToList();
foreach (var i in list2)
{
Entity_title t = new Entity_title();
t.Cat_name = i.CAT_NAME;
t.News_title = i.NEWS_TITLE;
if (i.NEWS_UPDATE.ToString() != string.Empty && i.NEWS_UPDATE != null)
{
t.New_update = DateTime.Parse(i.NEWS_UPDATE.ToString()).ToString("dd/MM/yyyy");
}
else
{
t.New_update = DateTime.Parse(i.NEWS_PUBLISHDATE.ToString()).ToString("dd/MM/yyyy");
}
l.Add(t);
}
}
return(l);
}
catch (Exception)
{
throw;
}
}
