public void ClassFilter(string className) { if (className != "All") { JoinsList.Add("inner join Class cl on cl.id = c.class_id "); WhereList.Add($"cl.name = '{className}' "); } }
public void UserFilter(int userId, bool isEditable) { if (!isEditable) { JoinsList.Add("Inner join UserCards u on c.id = u.cardId "); WhereList.Add($"u.userId = {userId} "); } }