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;
}
