public static List <FE_Category> GetTop(int num)
{
try
{
IDbConnection dbConn = new OrmliteConnection().openConn();
var item = dbConn.Where <Category>(x => x.isactive == true);
if (item == null)
{
return(new List <FE_Category>());
}
item = item.Take(num).ToList();
return(Mapper.Map <List <FE_Category> >(item));
}
catch (Exception ex)
{
return(new List <FE_Category>());
}
}
public static FE_Article GetByArticleType(ArticleType articletype)
{
try
{
IDbConnection dbConn = new OrmliteConnection().openConn();
var articletypenum = (int)articletype;
//var item = dbConn.FirstOrDefault<Article>(x => x.isactive == ActiveStatus.Active && x.articletype == articletypenum);
var items = dbConn.Where <Article>(x => x.isactive == ActiveStatus.Active && x.articletype == articletypenum).OrderByDescending(x => x.entryid).ToList();
if (items != null && items.Count == 0)
{
return(null);
}
var mapped = Mapper.Map <FE_Article>(items[0]);
var result = mapped;
return(result);
}
catch (Exception ex)
{
return(new FE_Article());
}
}
public static HomePage GetById(int entryid)
{
var dbConn = new OrmliteConnection().openConn();
try
{
var data = dbConn.Where <HomePage>(x => x.entryid == entryid);
if (data != null && data.Count > 0)
{
return(data[0]);
}
else
{
return(null);
}
}
catch (Exception e)
{
return(null);
}
finally { }
}
public static HomePage GetLast()
{
var dbConn = new OrmliteConnection().openConn();
try
{
var data = dbConn.Where <HomePage>(x => x.isactive == true);
if (data != null && data.Count > 0)
{
return(data[0]);
}
else
{
return(null);
}
}
catch (Exception e)
{
return(null);
}
finally { }
}