public HttpResponseMessage GetChanges(string db, string style, string since, int limit)
{
Console.WriteLine("In Changes, db: " + db + ", style: " + style + ", since: " + since + ", limit: " + limit);
// Get Revisions from DB
List <Change> revsList = new List <Change>();
// Get Data for revision Ids
List <PouchData> pouchDataList = new List <PouchData>();
using (DatabaseContext _db = new DatabaseContext())
{
// only take limit if there is more than limit in db
int RevsCount = _db.Changes.Where(e => e.DatabaseName.Equals(db)).ToList().Count();
if (RevsCount < limit)
{
limit = RevsCount;
}
revsList = _db.Changes.Where(e => e.DatabaseName.Equals(db)).OrderByDescending(e => e.seq).Take(limit).ToList();
// Remove all before Since
using (MessageControllerHelper helper = new MessageControllerHelper())
{
if (!since.Equals("") && !since.Equals("0"))
{
revsList = helper.FindRevsAfterSince(since, revsList);
}
}
// Get Data to look for revision ids
// TODO: Smarter solution!!
if (db.Equals("Tickets"))
{
// not sure if limit here would be working as intended as i don't know the ordering
// _db.Tickets.Take(limit).ToList();
// take the list and convert it into a json string
var tempString = JsonConvert.SerializeObject(_db.Tickets.ToList());
// If we now deserialize it, only the inclusive Parameters stay
pouchDataList = JsonConvert.DeserializeObject <List <PouchData> >(tempString);
}
else
{
Console.WriteLine("ERROR!!! Read TODOs. We may have other stuff than only Tickets");
}
}
// Get highest Sequence Number (Find latest Change)
int _seq = 0, highestSequenceId = 0;
string highestSequence = "";
List <Change> tempRevsList = new List <Change>();
foreach (Change cChange in revsList)
{
_seq = 0;
using (MessageControllerHelper helper = new MessageControllerHelper())
{
_seq = helper.ParseSeqId(cChange.seq);
}
if (highestSequenceId < _seq)
{
highestSequenceId = _seq;
highestSequence = cChange.seq;
}
// Remove first element since it is the same
if (!since.Equals("") && !since.Equals("0"))
{
continue;
}
tempRevsList.Add(cChange);
}
revsList = tempRevsList;
using (MessageControllerHelper helper = new MessageControllerHelper())
{
string temp;
using (ReturnParser parser = new ReturnParser())
{
temp = parser.GetChangesReturn(revsList, pouchDataList, highestSequence);
}
return(helper.GetJsonResponse(HttpStatusCode.OK, new StringContent(temp)));
}
}
