public int Save(QuestionNazarsanjiEntity data) { try { return(Connection.Db.Query <int>("spQuestionNazarsanjiSet", new { Id = data.Id, Question = data.Question, Active = data.Active, }, commandType: CommandType.StoredProcedure).SingleOrDefault()); } catch (Exception ex) { SaveLog.Save(ex); return(-1); } }
public List <QuestionNazarsanjiEntity> Search(QuestionNazarsanjiEntity data) { try { return(Connection.Db.Query <QuestionNazarsanjiEntity>("spQuestionNazarsanjiSearch", new { Id = data.Id, Question = "%" + data.Question + "%", Active = data.Active, }, commandType: CommandType.StoredProcedure).ToList()); } catch (Exception ex) { SaveLog.Save(ex); return(new List <QuestionNazarsanjiEntity>()); } }