public bool EliminateStory(StoryCriteria pCriteriaKey, String pCriteriaValue) { bool mBoolSuccess = false; String mStrSQL = ""; String[] ArrCriteria = GetDBFieldByCriteria(pCriteriaKey, pCriteriaValue); mStrSQL = "DELETE FROM STORIES " + "WHERE " + ArrCriteria[cCRITERIAKEY] + " = " + ArrCriteria[cCRITERIAVALUE]; try { oConnection.OpenConnection(); oConnection.UpdateSQL(mStrSQL,null); mBoolSuccess = true; //oConnection.CloseConnection(); } catch (Exception ex) { throw ex; } finally { oConnection.CloseConnection(); } return mBoolSuccess; }
public void ToDictionary_ReturnsCorrectDictionary() { // Arrange var sut = new StoryCriteria { ModifiedSince = new DateTime(2015, 1, 15, 8, 59, 21), Characters = new List <int> { 1, 2, 3 }, Comics = new List <int> { 21, 22, 23 }, Creators = new List <int> { 11, 12, 13 }, Events = new List <int> { 0, 56 }, Series = new List <int> { 0 }, OrderBy = new List <StoryOrder> { StoryOrder.IdAscending } }; // Act var result = sut.ToDictionary(); // Assert Assert.AreEqual(7, result.Count); Assert.Contains(ParameterModifiedSince, result.Keys); Assert.Contains(ParameterCharacters, result.Keys); Assert.Contains(ParameterComics, result.Keys); Assert.Contains(ParameterCreators, result.Keys); Assert.Contains(ParameterEvents, result.Keys); Assert.Contains(ParameterSeries, result.Keys); Assert.Contains(ParameterOrderBy, result.Keys); Assert.AreEqual(sut.ModifiedSince.Value.ToString(ParameterDateTimeFormat), result[ParameterModifiedSince]); Assert.AreEqual(string.Join(ParameterListSeparator, sut.Comics), result[ParameterComics]); Assert.AreEqual(string.Join(ParameterListSeparator, sut.Series), result[ParameterSeries]); Assert.AreEqual(string.Join(ParameterListSeparator, sut.Characters), result[ParameterCharacters]); Assert.AreEqual(string.Join(ParameterListSeparator, sut.Creators), result[ParameterCreators]); Assert.AreEqual(string.Join(ParameterListSeparator, sut.Events), result[ParameterEvents]); Assert.AreEqual(string.Join(ParameterListSeparator, sut.OrderBy.Select(o => o.GetStringValue())), result[ParameterOrderBy]); }
/// <summary> /// Fetches a list of comic stories from the specified series, with optional filters /// </summary> /// <param name="seriesId">The series ID.</param> /// <param name="limit">Limit the result set to the specified number of resources.</param> /// <param name="offset">Skip the specified number of resources in the result set.</param> /// <param name="criteria">Filter the result set by the specified criteria.</param> /// <returns></returns> public async Task <Response <List <Story> > > GetSeriesStoriesAsync(int seriesId, int?limit = null, int?offset = null, StoryCriteria criteria = null) { return(await _storyService.GetBySeriesAsync(seriesId, limit, offset, criteria)); }
/// <summary> /// Fetches a list of comic stories featuring the specified character, with optional filters /// </summary> /// <param name="characterId">The character ID.</param> /// <param name="limit">Limit the result set to the specified number of resources.</param> /// <param name="offset">Skip the specified number of resources in the result set.</param> /// <param name="criteria">Filter the result set by the specified criteria.</param> /// <returns></returns> public async Task <Response <List <Story> > > GetCharacterStoriesAsync(int characterId, int?limit = null, int?offset = null, StoryCriteria criteria = null) { return(await _storyService.GetByCharacterAsync(characterId, limit, offset, criteria)); }
internal async Task <Response <List <Story> > > GetBySeriesAsync(int seriesId, int?limit = null, int?offset = null, StoryCriteria criteria = null) { return(await GetList(string.Format(UrlSuffixSeriesStories, seriesId), limit, offset, criteria)); }
internal async Task <Response <List <Story> > > GetByCharacterAsync(int characterId, int?limit = null, int?offset = null, StoryCriteria criteria = null) { return(await GetList(string.Format(UrlSuffixCharacterStories, characterId), limit, offset, criteria)); }
internal async Task <Response <List <Story> > > GetAllAsync(int?limit = null, int?offset = null, StoryCriteria criteria = null) { return(await GetList(UrlSuffixAllStories, limit, offset, criteria)); }
private String[] GetDBFieldByCriteria(StoryCriteria pCriteriaKey, String pCriteriaValue) { String[] ArrCriteriaField = new String[2]; switch (pCriteriaKey) { case StoryCriteria.cID : ArrCriteriaField[cCRITERIAKEY] = "ID"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cSUBMITTERFIRSTNAME : ArrCriteriaField[cCRITERIAKEY] = "SUBMITTERFIRSTNAME"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue+ "'"; break; case StoryCriteria.cPHOTOID : ArrCriteriaField[cCRITERIAKEY] = "PHOTOID"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cSTORYTITLE : ArrCriteriaField[cCRITERIAKEY] = "STORYTITLE"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; case StoryCriteria.cSTORYPLOT : ArrCriteriaField[cCRITERIAKEY] = "STORYPLOT"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; case StoryCriteria.cROLEINSTORY : ArrCriteriaField[cCRITERIAKEY] = "ROLEINSTORY"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; case StoryCriteria.cAGE : ArrCriteriaField[cCRITERIAKEY] = "AGE"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; case StoryCriteria.cSTORYDATE : ArrCriteriaField[cCRITERIAKEY] = "STORYDATE"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; case StoryCriteria.cDONATIONTRANSPLANT : ArrCriteriaField[cCRITERIAKEY] = "DONATIONSTRANSPLANT"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; case StoryCriteria.cAUTHORIZATIONTEXT : ArrCriteriaField[cCRITERIAKEY] = "AUTHORIZATIONTEXT"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; case StoryCriteria.cAUTHORIZED : ArrCriteriaField[cCRITERIAKEY] = "AUTHORIZED"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cSUBMITTED: ArrCriteriaField[cCRITERIAKEY] = "SUBMITTED"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cCONFIRMATIONID : ArrCriteriaField[cCRITERIAKEY] = "CONFIRMATIONID"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; case StoryCriteria.cSTORYSTATUS : ArrCriteriaField[cCRITERIAKEY] = "STORYSTATUS"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; case StoryCriteria.cHEARTH: ArrCriteriaField[cCRITERIAKEY] = "HEARTH"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cLUNG: ArrCriteriaField[cCRITERIAKEY] = "LUNG"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cLIVER: ArrCriteriaField[cCRITERIAKEY] = "LIVER"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cKIDNEY: ArrCriteriaField[cCRITERIAKEY] = "KIDNEY"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cPANCREAS: ArrCriteriaField[cCRITERIAKEY] = "PANCREAS"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cINTESTINES: ArrCriteriaField[cCRITERIAKEY] = "INTESTINES"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cCORNEAS: ArrCriteriaField[cCRITERIAKEY] = "CORNEAS"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cMIDDLEEAR: ArrCriteriaField[cCRITERIAKEY] = "MIDDLEEAR"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cBLOODVESSELS: ArrCriteriaField[cCRITERIAKEY] = "BLOODVESSELS"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cBONE: ArrCriteriaField[cCRITERIAKEY] = "BONE"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cSKIN: ArrCriteriaField[cCRITERIAKEY] = "SKIN"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cOTHERORGAN: ArrCriteriaField[cCRITERIAKEY] = "OTHERORGAN"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cORGANDESCRIPTION: ArrCriteriaField[cCRITERIAKEY] = "ORGANDESCRIPTION"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; case StoryCriteria.cORGANIZATIONDESCRIPTION: ArrCriteriaField[cCRITERIAKEY] = "ORGANIZATIONDESCRIPTION"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; case StoryCriteria.cEMAIL: ArrCriteriaField[cCRITERIAKEY] = "EMAIL"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; case StoryCriteria.cISPUBLIC: ArrCriteriaField[cCRITERIAKEY] = "ISPUBLIC"; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; default: ArrCriteriaField[cCRITERIAKEY] = ""; ArrCriteriaField[cCRITERIAVALUE] = pCriteriaValue; break; case StoryCriteria.cRELATIONSHIP: ArrCriteriaField[cCRITERIAKEY] = "RELATIONSHIP"; ArrCriteriaField[cCRITERIAVALUE] = "'" + pCriteriaValue + "'"; break; } return ArrCriteriaField; }
public String[,] ListStoriesByCriteria(StoryCriteria pCriteriaKey, String pCriteriaValue) { String[,] ArrStories; String[] ArrCriteria = GetDBFieldByCriteria(pCriteriaKey, pCriteriaValue); String mStrSQL = ""; mStrSQL = "SELECT ID, SUBMITTERFIRSTNAME, PHOTOID, STORYTITLE, STORYPLOT, ROLEINSTORY, AGE, " + "STORYDATE, DONATIONTRANSPLANT, AUTHORIZATIONTEXT, AUTHORIZED, SUBMITTED, " + "CONFIRMATIONID, STORYSTATUS, HEARTH, LUNG, LIVER, KIDNEY, PANCREAS, " + "INTESTINES, CORNEAS, MIDDLEEAR, BLOODVESSELS, BONE, SKIN, OTHERORGAN, " + "ORGANDESCRIPTION, ORGANIZATIONDESCRIPTION, EMAIL, ISPUBLIC, RELATIONSHIP " + "WHERE " + ArrCriteria[cCRITERIAKEY] + " = " + ArrCriteria[cCRITERIAVALUE]; try { oConnection.OpenConnection(); ArrStories = oConnection.QuerySQLResultFlatArray(mStrSQL); //oConnection.CloseConnection(); } catch (Exception ex) { throw ex; } finally { oConnection.CloseConnection(); } return ArrStories; }