public List <Warehouses> GetWarehouses() { CouchRequest <Warehouses> list = new CouchRequest <Warehouses>(); var url = "http://127.0.0.1:5984/_fti/local/warehouse/_design/searchwarehouse/by_flag?q=flag:1"; var user = new User(); var lucene1 = new List <Warehouses> (); Task <string> task = HTTP_GET(url); task.Wait(); var res = task.Result; var lucene = JsonConvert.DeserializeObject <LuceneRequest <Warehouses> >(res); foreach (var l in lucene.rows) { Warehouses ev = new Warehouses(); ev = l.fields; ev._id = l.id; lucene1.Add(ev); } return(lucene1); }
private ViewResult ProcessResults(string uri, ViewOptions options) { CouchRequest req = GetRequest(options, uri); var resp = req.GetResponse(); return(new ViewResult(resp, req.GetRequest())); }
private ViewResult <T> ProcessGenericResults <T>(string uri, ViewOptions options) { CouchRequest req = GetRequest(options, uri); var resp = req.GetResponse(); if (resp.StatusCode == HttpStatusCode.BadRequest) { throw new CouchException(req.GetRequest(), resp, resp.GetResponseString() + "\n" + req.GetRequest().RequestUri); } return(new ViewResult <T>(resp, req.GetRequest(), ObjectSerializer)); }
public CouchRequest <EventCouch> FilterSortDocument(string filter, int pagesize, string sort, string order, int page, string warehouse) { var FS = new FilterSort(); var res1 = new CouchRequest <EventCouch>(); //Repository.Update(); res1 = Repository.GetFilterSortDocuments(filter, pagesize, sort, order, page, warehouse); return(res1); }
private ViewResult <T> ProcessGenericResults <T>(string uri, ViewOptions options) { CouchRequest req = GetRequest(options, uri); CouchResponse resp = req.GetCouchResponse(); bool includeDocs = false; if (options != null) { includeDocs = options.IncludeDocs ?? false; } return(new ViewResult <T>(resp, req.GetRequest(), ObjectSerializer, includeDocs)); }
private CouchRequest GetRequest(ViewOptions options, string uri) { if (options != null) { uri += options.ToString(); } CouchRequest request = GetRequest(uri, options == null ? null : options.Etag).Get().Json(); if (options.isAtKeysSizeLimit) { // Encode the keys parameter in the request body and turn it into a POST request. string keys = "{\"keys\": [" + String.Join(",", options.Keys.Select(k => k.ToRawString()).ToArray()) + "]}"; request.Post().Data(keys); } return(request); }
public void Update() { var url = "http://localhost:5984/_fti/local/events/_design/searchdocuments/by_fields?q=archive:false&limit=80"; var user = new User(); var lucene1 = new LuceneRequest <EventCouch>(); lucene1.rows = new List <Row <EventCouch> >(); Task <string> task = HTTP_GET(url); task.Wait(); var res = task.Result; var lucene = JsonConvert.DeserializeObject <LuceneRequest <EventWar> >(res); foreach (var l in lucene.rows) { EventCouch ev = new EventCouch(); ev = EventManager.ConvertEventWarToEventCouchParent(l.fields); lucene1.rows.Add(new Row <EventCouch>() { id = l.id, fields = ev }); } CouchRequest <EventCouch> list = new CouchRequest <EventCouch>(); list.total_rows = lucene.total_rows; foreach (var r in lucene1.rows) { list.rows.Add(r.fields); list.rows.Last()._id = r.id; } int i = 0; foreach (var r in list.rows) { r.warehouse_id = "91af1930ecfb96fcc19ae7689c000689"; //var id1 = ""; //// id1 = GetUUID(); //DateTime UpdatedTime = r.Data_vydachi ?? new DateTime(); //r.Data_vydachi = new DateTimeOffset(r.Data_vydachi).ToUnixTimeMilliseconds(); var json = JsonConvert.SerializeObject(r); var request = (HttpWebRequest)WebRequest.Create("http://localhost:5984/events/" + r._id); ServicePointManager.DefaultConnectionLimit = 1000; request.Credentials = new NetworkCredential("admin", "root"); request.Method = "PUT"; request.ContentType = "application/json"; request.KeepAlive = false; using (var streamWriter = new StreamWriter(request.GetRequestStream())) { var o = (Newtonsoft.Json.Linq.JObject)JsonConvert.DeserializeObject(json); var json1 = JsonConvert.SerializeObject(o); streamWriter.Write(json1); } } }
public CouchRequest <EventCouch> GetFilterSortDocuments(string filter = "", int pagesize = 10, string sort = "Номер_упаковки", string order = "", int page = 0, string warehouse = "") { CouchRequest <EventCouch> list = new CouchRequest <EventCouch>(); var limit = pagesize; var skip = (page - 1) * limit; if (filter == null) { filter = ""; } var q = ""; if (filter != "") { q = "( " + filter + " ) AND archive:false "; } else { q = "archive:false "; } var sort1 = "&sort="; if (sort == "Номер_упаковки" || sort == "Количество") { if (order != "desc") { sort1 += "\"/\"" + sort + "<int>"; } else { sort1 += "\"\\\"" + sort + "<int>"; } } else { if (order != "desc") { sort1 += "\"/\"" + sort; } else { sort1 += "\"\\\"" + sort; } } if (warehouse == null || warehouse == "") { warehouse = ""; } else if (warehouse == "") { q = "(" + q + ")"; } else { q = "(" + q + ")" + " AND " + "warehouse:" + warehouse; } var url = "http://localhost:5984/_fti/local/events/_design/searchdocuments/by_fields?q=" + q + sort1 + "&skip=" + skip + "&limit=" + limit; var user = new User(); var lucene1 = new LuceneRequest <EventCouch>(); lucene1.rows = new List <Row <EventCouch> >(); Task <string> task = HTTP_GET(url); task.Wait(); var res = task.Result; var lucene = JsonConvert.DeserializeObject <LuceneRequest <EventWar> >(res); foreach (var l in lucene.rows) { EventCouch ev = new EventCouch(); ev = EventManager.ConvertEventWarToEventCouchParent(l.fields); lucene1.rows.Add(new Row <EventCouch>() { id = l.id, fields = ev }); } list.total_rows = lucene.total_rows; // url = "http://localhost:5984/_fti/local/warehouses/_design/searchdocuments/by_fields?q=archive:false"; // task = HTTP_GET(url); // task.Wait(); // res = task.Result; //var lucene123 = JsonConvert.DeserializeObject<LuceneRequest<Warehouse.Model.Db.Warehouse>>(res); // foreach (var r in lucene123.rows) // { // r.fields.id = r.id; // list.wars.Add(r.fields); // } foreach (var r in lucene1.rows) { list.rows.Add(r.fields); } list.wars = GetWarehouses(); return(list); }
private static void Replicate(string sourceDb, string targetDb) { var result = new CouchRequest(GetServer()) .Path("_replicate") .Data(GetReplicationString(sourceDb, targetDb)) .Post() .String(); }