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