public List <Badge> SearchByName(string parameter = "")
{
if (parameter == "")
{
return(BadgeContext.GetDatabase().Fetch <Badge>("select * from Badges"));
}
string sql = String.Format("select * from Badges where title like '%{0}%' or description like '%{0}%'", parameter);
return(BadgeContext.GetDatabase().Fetch <Badge>(sql));
}
public List <Badge> GetAll()
{
return(BadgeContext.GetDatabase().Fetch <Badge>("select * from Badges"));
}
internal void delete(Badge badge)
{
BadgeContext.GetDatabase().Delete(badge);
}
internal void update(Badge badge)
{
BadgeContext.GetDatabase().Update(badge);
}
public void Add(Badge badge)
{
BadgeContext.GetDatabase().Insert(badge);
}
public Badge GetById(int id)
{
String sql = "select * from Badges where Id =" + id.ToString();
return(BadgeContext.GetDatabase().FirstOrDefault <Badge>(sql));
}