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)); }