public int SaveCustImprove(TaskCard tc, TaskItem ti, TaskOfPlan tp, Score score) { var conn = Resolver.Resolve <ISQLite>().GetConnection(); conn.InsertOrReplace(tc); conn.InsertOrReplace(ti); conn.InsertOrReplace(tp); return(conn.InsertOrReplace(score)); }
public bool CheckLocalModiYN() { List <string> parameters = new List <string>(); string sql = @"SELECT * FROM SCORE WHERE IFNULL(GRUD,'') <> ''"; Score score = _scoreRepository.GetAsyncConnection().QueryAsync <Score>(sql, parameters.ToArray()).Result.FirstOrDefault(); string sql2 = @"SELECT * FROM TaskOfPlan WHERE IFNULL(GRUD,'') <> ''"; TaskOfPlan taskOfPlan = _taskOfPlanRepository.GetAsyncConnection().QueryAsync <TaskOfPlan>(sql2, parameters.ToArray()).Result.FirstOrDefault(); if (null != score || taskOfPlan != null) { return(true); } return(false); }