public getReports(string table) : base("Reports") { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection(table); //collection.EnsureIndex(IndexKeys.Ascending("_id"), IndexOptions.SetUnique(true)); }
public DemandReport(string table) : base("Demand") { conection = (MongoConection)Conection.getConection(); conection1 = (MongoConection)Conection.getConection(); conection2 = (MongoConection)Conection.getConection(); collection = conection.getCollection(table); }
public HwReport(string table) : base("Hardware") { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection(table); }
public LocationsReport(string table) : base("Locations") { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection(table); }
/// <summary> /// Intilializes the model, sets the collection to users /// </summary> public UserTable() { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection("Users"); }
/// <summary> /// Initializes the model and sets the Customer collection /// </summary> public CustomerTable() { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection("Customers"); }
public InventoryReport(string table) : base("Inventory") { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection(table); }
public ObjectsRefReport(string table) : base("ReferenceObjects") { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection(table); }
/// <summary> /// Initializes the model /// </summary> /// <param name="collectionname"> /// the mongo's collections where the data is /// </param> public ListTable() { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection("Lists"); }
public ProfileTable(string table = "Profiles") : base("Profiles") { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection(table); }
public MovementReport(string table) : base("MovementProfiles") { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection(table); }
public MessageReport(string table) : base("Messages") { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection(table); }
/// <summary> /// Initializes the models /// </summary> public ObjectPrototypeTable() { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection("ObjectPrototype"); }
public String Mapreduced(Dictionary <string, string> fields, List <string> movement = null, List <string> objs = null, List <string> locations = null, List <string> users = null, Int64 start = 0, Int64 end = 0) { var orderfield = "folio"; try { List <string> cols = new List <string>(); foreach (var x in fields) { cols.Add(x.Key); } cols.Add("CreatedTimeStamp"); string[] arrayfields = cols.ToArray(); string[] arraymov = movement.ToArray(); string[] arrayobjs = objs.ToArray(); string[] arraylocations = locations.ToArray(); string[] arrayusers = users.ToArray(); BsonArray bsonarraymov = new BsonArray(); BsonArray bsonarrayobjs = new BsonArray(); BsonArray bsonarrayloc = new BsonArray(); BsonArray bsonarrayusers = new BsonArray(); for (int i = 0; i < arraymov.Length; i++) { bsonarraymov.Add(arraymov[i]); } for (int i = 0; i < arrayobjs.Length; i++) { bsonarrayobjs.Add(arrayobjs[i]); } for (int i = 0; i < arraylocations.Length; i++) { bsonarrayloc.Add(arraylocations[i]); } for (int i = 0; i < arrayusers.Length; i++) { bsonarrayusers.Add(arrayusers[i]); } List <BsonDocument> documents = new List <BsonDocument>(); var query = Query.And(Query.In("movement", bsonarraymov), Query.In("object", bsonarrayobjs), Query.In("location", bsonarrayloc), Query.In("Creator", bsonarrayusers), Query.GTE("CreatedTimeStamp", start), Query.LTE("CreatedTimeStamp", end)); /*Realiza la conexion */ MongoCollection Demand = conection.getCollection("Demand"); MongoCollection Movements = conection1.getCollection("MovementProfiles"); MongoCollection Locations = conection2.getCollection("Locations"); var Movementsfunction = @"function() { var key = this._id.valueOf(); var value={movement:this.name}; emit(key,value); }"; var Locationsfunction = @"function() { var key = this._id.valueOf(); var value={location:this.name}; emit(key,value); }"; var Demandfunction = @"function() { var key = this.movement; var value = {id:this._id.valueOf(),folio:this.folio,object:this.object,total:this.total,status:this.status,movementFields:this.movementFields,CreatedDate:this.CreatedDate,CreatedTimeStamp:this.CreatedTimeStamp,Creator:this.Creator,system_status:this.system_status}; emit(key,value); }"; var Demandfunction2 = @"function() { var key = this.location; var value = {id:this._id.valueOf(),folio:this.folio,object:this.object,total:this.total,status:this.status,movementFields:this.movementFields,CreatedDate:this.CreatedDate,CreatedTimeStamp:this.CreatedTimeStamp,Creator:this.Creator,system_status:this.system_status}; emit(key,value); }"; var reducefunction = @"function (key, values) { var reduced = {id:'',folio:'',movement:'',location:'',object:'',total:'',status:'',movementFields:'',CreatedDate:'',CreatedTimeStamp:'',Creator:'',system_status:''}; var index=0; values.forEach(function(value){ if(value.movement != null && reduced.movement ==''){ reduced.movement = value.movement; } if(value.location != null && reduced.location == ''){ reduced.location = value.location; } if(value.id != null){ reduced.id= value.id; reduced.folio = value.folio; reduced.object = value.object; reduced.total = value.total; reduced.status = value.status; reduced.movementFields = value.movementFields; reduced.CreatedDate = value.CreatedDate; reduced.CreatedTimeStamp = value.CreatedTimeStamp; reduced.Creator = value.Creator; reduced.system_status = value.system_status; } }); return reduced; }"; /*Establece las propiedades a seguir del mapreduce */ MapReduceOptionsBuilder options = new MapReduceOptionsBuilder(); options.SetOutput(MapReduceOutput.Inline); options.SetOutput(MapReduceOutput.Reduce("result", true)); /* Realiza los mapreduce sobre el mismo resultado */ MapReduceResult result = Movements.MapReduce(Movementsfunction, reducefunction, options); // result = Locations.MapReduce(Locationsfunction, reducefunction, options); result = Demand.MapReduce(Demandfunction, reducefunction, options); // result = Demand.MapReduce(Demandfunction2, reducefunction, options); /* resultado en json */ string results = result.GetResults().ToJson(); return(results); } catch (Exception ex) { return(null); } }
public ProccessReport(string table) : base("Processes") { conection = (MongoConection)Conection.getConection(); collection = conection.getCollection(table); }