/// <summary> /// Debugging method /// </summary> /// <param name="getUserActionRequest"></param> /// <returns></returns> public GetUserActionResponse GetUserActionById(GetUserActionRequest getUserActionRequest) { GetUserActionResponse resp = new GetUserActionResponse(); List<SqlParameter> sqlParam = new List<SqlParameter>(); List<UserActionInfo> userActionList = new List<UserActionInfo>(); string sqlStr = null; if (getUserActionRequest.Action > 0) { sqlStr = @"select Id, UserId, Action, Parameter, FulfilledDateTime from UserAction where UserId = @UserId and Action = @Action"; DBUtility.AddSqlParam(sqlParam, "@UserId", SqlDbType.BigInt, getUserActionRequest.UserId); DBUtility.AddSqlParam(sqlParam, "@Action", SqlDbType.BigInt, getUserActionRequest.Action); } else { sqlStr = @"select Id, UserId, Action, Parameter, FulfilledDateTime from UserAction where UserId = @UserId"; DBUtility.AddSqlParam(sqlParam, "@UserId", SqlDbType.BigInt, getUserActionRequest.UserId); } DataSet ds = DBUtility.ExecuteDataset(sqlStr, sqlParam); if(DBUtility.hasResult(ds)) { foreach(DataRow dr in ds.Tables[0].Rows) { UserActionInfo userAction = new UserActionInfo(); userAction.Id = Convert.ToInt32(dr["Id"]); userAction.UserId = Convert.ToInt32(dr["UserId"]); userAction.Action = Convert.ToInt32(dr["Action"]); userAction.Parameter = dr["Parameter"].ToString(); userAction.FulfilledDateTime = Convert.ToDateTime(dr["FulfilledDateTime"]); userActionList.Add(userAction); } } resp.UserActionList = userActionList; return resp; }
public List<UserActionInfo> GetUserActionListByID(int userId) { List<UserActionInfo> userActionList = new List<UserActionInfo>(); List<SqlParameter> sqlParam = new List<SqlParameter>(); string sqlStr = @"select ua.Action as Action, ua.Parameter as Parameter, ua.FulfilledDateTime as FulfilledDateTime, at.Name as ActionName, ach.Name as AchievementName, ach.Criteria as AchievementCriteria from UserAction ua join ActionType at on at.Id = ua.Action join Achievement ach on ach.ActionType = ua.Action where ua.UserId = @UserId"; DBUtility.AddSqlParam(sqlParam, "@UserId", SqlDbType.BigInt, userId); DataSet ds = DBUtility.ExecuteDataset(sqlStr, sqlParam); //TODO: Add stored procedure to perform add Achievement //DataSet ds1 = DBUtility.ExecuteDataset(sqlStr, CommandType.StoredProcedure, sqlParam); if(DBUtility.hasResult(ds)) { foreach(DataRow dr in ds.Tables[0].Rows) { UserActionInfo info = new UserActionInfo(); info.Action = Convert.ToInt32(dr["Action"]); info.Parameter = dr["Parameter"].ToString(); info.FulfilledDateTime = Convert.ToDateTime(dr["FulfilledDateTime"]); userActionList.Add(info); } } return userActionList; }