public string GetSubObjectsDemand(string locationId = null)
{
locationId = (locationId != null && locationId != "") ? locationId : "";
string queryFunction = "getSubObjectsDemand ( \"" + locationId + "\")";
BsonJavaScript SubFunction = new BsonJavaScript(queryFunction);
//Calling the stores Mongo Function
MongoConection conection = (MongoConection)Conection.getConection();
BsonArray result = conection.getDataBase().Eval(SubFunction).AsBsonArray;
List <BsonDocument> documents = new List <BsonDocument>();
foreach (BsonDocument document in result)
{
document.Set("_id", document.GetElement("_id").Value.ToString());
try
{
document.Set("CreatedTimeStamp", document.GetElement("CreatedTimeStamp").Value.ToString());
}
catch (Exception ex) { }
documents.Add(document);
}
return(documents.ToJson());
}
public string GetIdUnico()
{
string queryFunction = "getIDOne()";
BsonJavaScript SubFunction = new BsonJavaScript(queryFunction);
//Calling the stores Mongo Function
MongoConection conection = (MongoConection)Conection.getConection();
double result = conection.getDataBase().Eval(SubFunction).AsDouble;
return(result.ToString());
}
public string GetAlldemandsFolio(string objid = null)
{
objid = (objid != null && objid != "") ? objid : "";
string queryFunction = "getAllDemandsOfObject ( \"" + objid + "\")";
BsonJavaScript SubFunction = new BsonJavaScript(queryFunction);
//Calling the stores Mongo Function
MongoConection conection = (MongoConection)Conection.getConection();
String result = conection.getDataBase().Eval(SubFunction).AsString;
return(result);
}
public String NewObjectEPC(String idObjRef, String IdClient)
{
String result = "";
if (idObjRef != null && IdClient != null)
{
string queryFunction = "NewObjectBaseEPC ( '" + IdClient + "', '" + idObjRef + "' )";
BsonJavaScript JoinFunction = new BsonJavaScript(queryFunction);
//Calling the stores Mongo Function
MongoConection conection = (MongoConection)Conection.getConection();
result = conection.getDataBase().Eval(JoinFunction).AsString;
}
return(result);
}
public String getEPC(String idObjRef, String numEtiq)
{
String newepc = "";
if (idObjRef != null && numEtiq != null)
{
string queryFunction = "generateEPC ( '" + idObjRef + "', " + numEtiq + " )";
BsonJavaScript JoinFunction = new BsonJavaScript(queryFunction);
//Calling the stores Mongo Function
MongoConection conection = (MongoConection)Conection.getConection();
BsonDocument result = conection.getDataBase().Eval(JoinFunction).AsBsonDocument;
newepc = result.ToJson();
}
return(newepc);
}
/// <summary>
/// Returns all objects from a location and the locations whitin
/// </summary>
/// <param name="locationId"></param>
/// <returns></returns>
public string GetSubObjects(string locationId = null, bool filter = false)
{
locationId = (locationId != null && locationId != "") ? locationId : "";
string queryFunction = "getSubObjects ( \"" + locationId + "\")";
BsonJavaScript SubFunction = new BsonJavaScript(queryFunction);
//Calling the stores Mongo Function
MongoConection conection = (MongoConection)Conection.getConection();
BsonArray result = conection.getDataBase().Eval(SubFunction).AsBsonArray;
List <BsonDocument> documents = new List <BsonDocument>();
foreach (BsonDocument document in result)
{
document.Set("_id", document.GetElement("_id").Value.ToString());
try
{
document.Set("CreatedTimeStamp", document.GetElement("CreatedTimeStamp").Value.ToString());
}
catch (Exception ex) { }
string type = "true";
if (filter)
{
try
{
type = document.GetElement("system_status").Value.ToString().ToLower();
}
catch { }
}
if (filter && type == "false")
{
}
else
{
documents.Add(document);
}
}
return(documents.ToJson());
}
public int GetNumObjects(String idlocation)
{
int result = 0;
BsonArray objs = new BsonArray();
if (idlocation == null || idlocation == "")
{
idlocation = "null";
}
string queryFunction = "getSubObjects ('" + idlocation + "' )";
BsonJavaScript JoinFunction = new BsonJavaScript(queryFunction);
//Calling the stores Mongo Function
MongoConection conection = (MongoConection)Conection.getConection();
objs = conection.getDataBase().Eval(JoinFunction).AsBsonArray;
result = objs.Count;
return(result);
}
